ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for Accounts Receivable 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 Accounts Receivable General Ledger (GL) balance is fully supported by the detailed transactions in the Accounts Receivable Subledger (Aging Report). Any discrepancies between the two must be identified, explained, documented, and corrected if necessary.
20
21
22
Process Overview
23
24
This reconciliation compares the total balance from the Accounts Receivable Subledger (Aging Report) to the Accounts Receivable GL balance recorded in the trial balance. The subledger is considered the source of truth because it contains the transaction-level detail — customer invoices, payments, and adjustments.
25
26
27
Key Principles
28
29
30
✅ The subledger should fully support the GL balance.
31
✅ The GL should not contain balances that cannot be traced to specific customer transactions in the subledger.
32
✅ Any differences should be researched, with documentation retained to support the resolution (e.g., mispostings, timing issues, manual adjustments).
33
✅ Approved adjustments should be posted as journal entries and referenced within the reconciliation.
34
35
36
Steps to Complete the Reconciliation
37
38
1. Obtain the AR Aging Report from the subledger system.
39
40
2. Extract the AR balance from the General Ledger trial balance.
41
42
3. Compare the two balances.
43
44
4. Identify, document, and explain any differences.
45
46
5. Prepare adjusting journal entries if required and obtain appropriate approvals.
47
48
6. Attach supporting documentation (aging report, GL detail, payment support, journal entries).
49
50
7. Save the reconciliation in the designated month-end close folder.
51
52
8. Complete preparer and reviewer sign-offs.
53
54
55
Supporting Documentation Checklist
56
57
✔️ AR Aging Report.
58
59
✔️ GL Account Detail.
60
61
✔️ Payment Remittances and Customer Statements (if applicable).
62
63
✔️ Copies of Journal Entries (if adjustments were needed).
64
65
✔️ Explanation Memo for any unresolved differences.
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