ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for Balance Sheet Reconciliation Template
2
3
4
Important Notice for Template Users
5
This Excel template is designed as a general framework to assist in structuring financial processes. However, every organization has unique policies, systems, and workflows that may require modifications to fit specific needs.
6
7
Customization & Verification Required:
8
9
✅ Modify fields, formulas, and categories to align with your company’s policies.
10
✅ Test all calculations to ensure accuracy before implementation.
11
✅ Verify outputs with your finance team or auditors for compliance.
12
✅ Regularly review and update the template as your processes evolve.
13
14
This template serves as a starting point—adjust as needed to maximize effectiveness.
15
16
17
Purpose
18
19
This reconciliation template is designed to ensure that the General Ledger (GL) balance for a given balance sheet account is fully supported by the underlying subledger or supporting documentation. Any discrepancies between the two must be identified, explained, documented, and corrected if necessary.
20
21
This template can be used for reconciling any balance sheet account, including but not limited to:
22
23
• Accounts Receivable (AR)
24
• Accounts Payable (AP)
25
• Fixed Assets
26
• Prepaid Expenses
27
• Accrued Liabilities
28
• Bank Accounts
29
• Inventory
30
• Deferred Revenue
31
• Intercompany Accounts
32
33
Process Overview
34
35
The reconciliation process compares the balance of the General Ledger (GL) account recorded in the trial balance to the subledger or supporting documents (e.g., aging reports, bank statements, fixed asset schedules, etc.).
36
37
• The subledger or external source document is considered the source of truth as it contains transaction-level detail.
38
• The GL balance should always be fully supported by the subledger or supporting schedules.
39
• Any discrepancies must be investigated, explained, and adjusted where necessary.
40
41
42
Key Principles
43
44
✅ The subledger or supporting document should fully support the GL balance.
45
✅ The GL should not contain balances that cannot be traced to specific transactions.
46
✅ Any differences must be researched, documented, and resolved in a timely manner.
47
✅ Adjusting journal entries must be posted for valid corrections and documented in the reconciliation.
48
✅ Reconciliations should be reviewed and approved as part of the month-end close process.
49
50
Steps to Complete the Reconciliation
51
52
1️⃣ Obtain Supporting Documents
53
54
Pull relevant reports based on the account type:
55
56
• AR/AP: Aging Reports
57
• Bank Accounts: Bank Statements
58
• Fixed Assets: Fixed Asset Schedules
59
• Prepaid/Accrued Expenses: Amortization or Accrual Schedules
60
• Intercompany Accounts: Intercompany Transaction Listings
61
62
63
2️⃣ Extract the GL Account Balance
64
65
• Retrieve the account balance from the General Ledger Trial Balance for the reconciliation period.
66
67
68
3️⃣ Compare the Balances
69
70
• Compare the GL balance with the subledger balance or supporting documents.
71
• Any differences must be investigated and documented.
72
73
74
4️⃣ Identify and Explain Differences
75
76
Differences could be caused by:
77
78
• Timing Differences (e.g., transactions recorded in one system but not yet reflected in another)
79
• Mispostings (e.g., entries posted to the wrong account)
80
• Unrecorded Transactions (e.g., missing journal entries)
81
• Errors in the Subledger or GL
82
83
84
5️⃣ Prepare Adjusting Journal Entries (if required)
85
86
• If a correction is needed, prepare and post an adjusting journal entry.
87
• Obtain appropriate approval before posting adjustments.
88
89
90
6️⃣ Attach Supporting Documentation
91
92
Ensure all supporting documents are attached to the reconciliation, including:
93
94
• Subledger reports or external source documents
95
• GL account detail or transaction listing
96
• Bank statements, invoices, or payment records (if applicable)
97
• Copies of journal entries for adjustments
98
99
100
7️⃣ Save and Archive the Reconciliation