ValueXPA Month end checklist tracker general_Oct 2023.xlsx

	B	C	D	E
1	ValueXPA
2	Month-end Close Checklist
3	Financials Checklist
4	S.no	Activities	Description	Category
5	1	Salaries JE	Recording journal entries to account for employee salaries and related expenses.	Month End
6	2	Payroll accrual/Reversal	Accruing or reversing payroll expenses that span across two accounting periods.	Month End
7	3	credit card - Matching	Matching credit card transactions with corresponding receipts or invoices.	Month End
8	4	Bank Transactions - Matching	Matching bank transactions in the books of accounts for accuracy.	Month End
9	5	Uncategorized Expenses	Identifying and allocating expenses that couldn't be categorized during the month.	Month End
10	6	Revenue GL	Reviewing and reconciling revenue entries in the General Ledger.	Month End
11	7	Payroll clearing account	Clearing account used to reconcile payroll transactions and expenses.	Month End
12	8	Depreciation	Calculating and recording the depreciation expense for fixed assets.	Month End
13	9	P&L Review	Reviewing and analyzing the Profit and Loss (P&L) statement for accuracy.	Financial Statements
14	10	Balance Sheet Review	Reviewing and analyzing the Balance Sheet accounts for accuracy.	Financial Statements
15	11	Bank Reconciliation	Reconciling the company's bank accounts to ensure consistency with the bank's records.	Reconciliation
16	12	Credit cards Reconciliation	Reconciling credit card statements with company records.	Reconciliation
17	13	AP Reconcilaion	Reconciling Accounts Payable (AP) to verify outstanding liabilities	Reconciliation
18	14	Accounts Receivables	Reviewing and managing outstanding customer payments and invoices.	Reconciliation
19	15	Payroll Reconciliation	Reconciling payroll-related accounts and ensuring payroll accuracy.	Reconciliation
20	16	Payroll accrual	Recognizing expenses for unpaid salaries and benefits.	Reconciliation
21	17	Prepaid Expenses GL	Managing and adjusting prepaid expenses in the General Ledger.	Reconciliation
22	18	Tax	Preparing and processing tax-related transactions and calculations.	Reconciliation
23	19	Inventory	Evaluating and reconciling inventory levels and costs.	Reconciliation
24	20	Fixed Assets	Managing fixed assets, including additions, disposals, and depreciation.	Reconciliation
25	21	Complaince and Tax filings as applicable	Ensuring compliance with relevant regulations and filing taxes accurately.	Tax compliance
26	22	Deferred revenue entries	Recording revenue that is received in advance but not yet earned.	Month End
27	23	Accrued Expenses	Outstanding expenses that haven't been paid yet which are to be listed seperately under liabilites.	Month End
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
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