Ledge Month-End Close Checklist.xlsx

	B	C	D	E	F	G	H	I	J
1
2	Month-end Close Checklist For the (sample) month of: April 2025
3
4
5
6
7		First work day	4/1/2025
8
9	Index	Task description	Workday to completion	Due date for completion	Day of the week	Preparer	Preparer Sign-off	Reviewer	Reviewer Sign-off

10	1	Update employee records in ERP for department correct allocation	-4	3/28/2025	Fri
11	2	Review and approve of expense reports	-4	3/28/2025	Fri
12	3	Automatic integration from expensing system to ERP	-1	3/31/2025	Mon
13	4	Prepare FIN48+FAS5 accruals WP and record appropriate journal entry in ERP - Quarterly	-1	3/31/2025	Mon
14	5	Petty Cash Reconciliation	1	4/2/2025	Wed
15	6	Payments to vendors	1	4/2/2025	Wed
16	7	Check that all chargebacks are recorded in billing system, including related credit memos	1	4/2/2025	Wed
17	8	Finalize invoicing of resellers-related transactions	1	4/2/2025	Wed
18	9	Recording of all vendor bills	2	4/3/2025	Thu
19	10	Complete processing quotes submitted	2	4/3/2025	Thu
20	11	Review and clean up customer open balances of up to $1,000	2	4/3/2025	Thu
21	12	Run through draft invoices to make sure all customers are invoiced	2	4/3/2025	Thu
22	13	AP closed - confirm all invoices were recorded	3	4/4/2025	Fri
23	14	Paypal reconciliation	3	4/4/2025	Fri
24	15	Invoice total amount - comparing NetSuite vs. Zuora	3	4/4/2025	Fri
25	16	Prepare employee bonus accruals WP and record journal entry - Quarterly	3	4/4/2025	Fri
26	17	Prepare R&D Capitalization WP and record journal entry - Quarterly	3	4/4/2025	Fri
27	18	Payroll journal entry and reconciliation of related items on balance sheet	3	4/4/2025	Fri
28	19	Update and record vacation accruals	3	4/4/2025	Fri
29	20	Cap Table reconciliation - Quarterly	3	4/4/2025	Fri
30	21	Euqity grants file reconciliation - Quarterly	3	4/4/2025	Fri
31	22	Bank accounts reconciliation	6	4/7/2025	Mon
32	23	Credit card bills entry to credit card statement	6	4/7/2025	Mon
33	24	Reconcile Balance sheet to credit card statements	6	4/7/2025	Mon
34	25	Reconcile Balance sheet to bank statements	6	4/7/2025	Mon
35	26	Review sales tax reports and confirm completeness and accuracy	6	4/7/2025	Mon
36	27	Reporting to Tax Authorities of Withholding tax, national insurance/social security, etc)	6	4/7/2025	Mon
37	28	Record deferred revenues journal entry	6	4/7/2025	Mon
38	29	Record prepaid Expenses amortization and review breakdown of prepaid expenses balance	6	4/7/2025	Mon
39	30	Record stock based compensation expenses - quarterly	6	4/7/2025	Mon
40	31	Net-off reseller revenue sold a net basis	6	4/7/2025	Mon
41	32	Review expenses recorded without department and location allocation	7	4/8/2025	Tue
42	33	Option exercises reconciliation to equity grants status file	7	4/8/2025	Tue
43	34	Recorded hedge accounting entries	7	4/8/2025	Tue
44	35	Prepare Gross Burn analysis by expense type, department	7	4/8/2025	Tue
45	36	Prepare fixed assets reconciliation and run depreciation amortization	7	4/8/2025	Tue
46	37	Prepare and record accrued expenses	8	4/9/2025	Wed
47	38	Update accrued expenses breakdown WP	8	4/9/2025	Wed
48	39	Record VAT reclassification journal entries	8	4/9/2025	Wed
49	40	Review vendors balance aging	8	4/9/2025	Wed
50	41	Prepare intercompany reconciliation- Quarterly	8	4/9/2025	Wed
51	42	Prepare PSP reconciliation, including recording PSP fees and reclass journal entries of balances	8	4/9/2025	Wed
52	43	Record Deferred Commissions capitalization journal entries	8	4/9/2025	Wed
53	44	Prepare and record journal entries for MBO & Sales Commission provision	8	4/9/2025	Wed
54	45	Update and record entitlements of reseller Commissions	9	4/10/2025	Thu
55	46	Run cost center allocations of overhead expenses	10	4/11/2025	Fri
56	47	AR aging report reconciliation to balance sheet	10	4/11/2025	Fri
57	48	Prepare and record allowance for doubtful accounts - Quarterly	10	4/11/2025	Fri
58	49	Pension and social funds balances reconciliation	10	4/11/2025	Fri
59	50	DTA\DTL calculation and journal entry posting - Quarterly	13	4/14/2025	Mon
60	51	Prepare and record transfer pricing calculation + invoicing of affiliates - Quarterly	13	4/14/2025	Mon
61	52	Prepare and record tax provision per subsidiary - Quarterly	13	4/14/2025	Mon
62	53	Prepare flux analysis per subsidiary on a stand-alone basis	13	4/14/2025	Mon
63	54	Make sure Elimination accounts zero out	13	4/14/2025	Mon
64	55	Run system revaluation on both local and reporting currencies (multi-book)	13	4/14/2025	Mon
65	56	P&L flux Analysis - consolidated basis	13	4/14/2025	Mon
66	57	BS flux Analysis - consolidated basis	13	4/14/2025	Mon
67	58	Prepare P&L, BS and CF reporting package	13	4/14/2025	Mon
68	59	Prepare reporting package per investors' format	14	4/15/2025	Tue
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100