Balance Sheet Reconciliation Template | Notion

Source: AAC-Template-05-Balance-Sheet-Reconciliation.docx (Google Drive) | Owner: Sandra Lea, CPA | Confidential — Not for Distribution

Rule: Reconcile every balance sheet account to a supporting document each period. No period should be closed with an unresolved variance.

Header Info

Field	Value
Client Name
Period
Entity Type
Accounting Method	Cash / Accrual
Assigned To
Due Date
Reviewed By	Sandra Lea
Date Approved

How to Use

Run Balance Sheet in QBO for the close period
Enter GL Balance from QBO for each account
Pull supporting document listed in column 5
Enter Supporting Balance from that document
Variance = GL Balance minus Support Balance
All variances must be resolved before closing
Mark Status: ✓ Reconciled, ⚠ Variance, N/A

Common Supporting Documents:

Cash Accounts → Bank Statement
Accounts Receivable → AR Aging Report
Accounts Payable → AP Aging Report
Credit Cards → Credit Card Statement
Fixed Assets → Fixed Asset Schedule