AR Reconciliation Template
An accounts receivable reconciliation template for confirming that the AR subledger agrees to the general ledger control account. Includes sections for beginning balance, activity during the period, ending balance, and reconciling item detail.
How to use this template
Pull the AR subledger total
Export the AR subledger aging report as of the reconciliation date. Confirm the total agrees to the sum of all open customer balances.
Pull the GL control account balance
Obtain the ending balance of the accounts receivable GL control account for the same period.
Calculate the difference
Subtract the GL balance from the subledger total. Any difference requires identification and resolution.
Identify and document reconciling items
List each reconciling item with the dollar amount and explanation. Common items include timing differences and unposted cash receipts.
Obtain sign-off
Route the completed reconciliation to a reviewer. Both preparer and reviewer sign off before the workpaper is filed.
Why use this template
- Confirms accuracy of the AR balance presented on the balance sheet
- Identifies posting errors or timing differences before the period is locked
- Serves as documented evidence of the subledger-to-GL reconciliation control
- Reduces external audit time by providing clear, organized workpaper documentation
Related templates
Accounts Receivable Month-End Close Checklist
A month-end close checklist focused specifically on the accounts receivable cycle. Covers invoicing cutoff, cash receipts cutoff, collections aging, allowance review, subledger reconciliation, and AR sign-off.
ReconciliationsCash Reconciliation Template
A cash account reconciliation template for reconciling the GL cash balance to bank statements. Covers outstanding checks, deposits in transit, bank charges, and other reconciling items to arrive at the adjusted cash balance.
Accounts ReceivableAccounts Receivable Checklist
An accounts receivable checklist covering invoicing, collections follow-up, cash application, and period-end reconciliation. Keeps AR teams on track with a structured task list, clear ownership, and status tracking.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.