About this template
A checking account reconciliation form is an essential financial document used by business owners, accountants, and finance teams to match company ledger records with monthly bank statements. Keeping accounts balanced helps detect discrepancies, catch unauthorized transactions early, and maintain clean books for tax and audit preparation.
Using Doc2Form to generate this reconciliation form allows you to quickly collect statement dates, ending balances, outstanding checks, and recent deposits in one standardized format. Streamline your monthly close process by giving your accounting team a reliable digital intake workflow that eliminates scattered paperwork and manual calculation errors.
Key features
- Standardize monthly bank and ledger reconciliation inputs
- Track ending statement balances and outstanding deposits
- Account for outstanding checks and drafts instantly
- Ensure audit readiness with organized financial records
Use cases
- Monthly closing and bookkeeping reviews for small businesses
- Internal financial audits and expense verification
- Accountant-client reconciliation data collection
What this form collects
- Account Name or Number (Short answer)Enter the business account name or the last 4 digits of the checking account.
- Statement Period Ending Date (Date)Select the last day of the month covered by the bank statement.
- Ending Balance Shown On Statement (Short answer)Enter the exact ending balance printed on your bank statement.
- Plus Deposits Not Shown On Statement (Short answer)Enter the total amount of deposits made that have not yet cleared the bank.
- Sub-Total (Short answer)Enter the subtotal of the statement ending balance plus unrecorded deposits.
- Less Total Outstanding Drafts and Checks (Short answer)Enter the total sum of outstanding checks and drafts that have not cleared.
- Equals Adjusted Ending Balance (Short answer)Enter the final calculated adjusted balance.
- General Ledger Ending Balance (Short answer)Enter the ending balance from your company's internal general ledger for the same period.
- Reconciliation Status (Multiple choice)Do the bank adjusted balance and the general ledger balance match?
- Notes and Discrepancy Explanations (Paragraph)Provide details on any variance, bank fees, interest earned, or corrections needed.
- Supporting Document Link (Paragraph)Please paste a link to your file (Google Drive, Dropbox, etc.) or describe the document you wish to attach.
FAQ
How often should checking account reconciliation be performed?
Most businesses perform reconciliations monthly as soon as the bank statement is issued to catch errors or discrepancies promptly.
Can I customize the fields in this template?
Yes! Once generated in Google Forms, you can fully edit questions, add new calculation fields, or adjust requirements to match your accounting workflow.
What information do I need before filling out this form?
You will need your monthly bank statement, current general ledger balance, a list of outstanding checks, and records of any deposits in transit.
How does Doc2Form help with this template?
Doc2Form instantly converts this structured financial template into a ready-to-use Google Form so you can start collecting reconciliation data immediately.
Get this form in your Google Drive
Save a copy to your Google Drive with one click (uses 1 credit). Or build from a PDF or description in the app.