Ed. note: This is an article I wrote when I had my own consulting practice. Originally, this article was posted to my company’s website and one of the groups on LinkedIn. I’ve noticed that the template has been download consistently month after month. The fate of the Doan + Associates website is questionable, so I decided to reproduce the article here with some minor changes.
* * *
Performing a monthly reconciliation of your general ledger accounts is hard, not because it is complex, but because it is so time consuming. As such, it’s a task that is often neglected. When auditors ask for an account reconciliation, they often get a print out of the general ledger detail from the accounting software. The general ledger detail does contain all the information affecting an account, but it often contains too much information (e.g., correcting entries, reversing entries, etc.) making it difficult to use for the both the accounting staff and auditor.
I’ve been a controller for several companies in the past. One of the first procedures I implement when I come into a company is to assign account reconciliations. Its often not a popular procedure, but everyone pitches in to lessen the pain. To facilitate the procedure, I ask that a standard general ledger reconciliation form be used. Using a standard form enables everyone involved in the procedure to quickly interpret the information and help out when a staff member is out sick.
Here’s a partial screen shot of the form:

Here’s some guidelines on how to use the form:
- Use the account reconciliation form for EVERY general ledger account including control accounts like accounts receivable and accounts payable.
- Having staff reconcile accounts that are not part of their daily responsibilities. For example, let the billing clerk reconcile the fixed asset accounts. Because the billing clerk isn’t familiar with the transactions going in and out of the fixed asset accounts, they will be less likely to “go through the motions” of reconciling the account. Also unfamiliarity with the account will prompt the billing clerk to communicate with the person responsible for the account — they might even find an error!
- Start reconciling the accounts before the end of the month so that at month end, you only have one week of activity to reconcile.
- Put all supporting calculations in individual tabs in the workbook. This leaves an audit trail for others.
- Record only the net activity onto the form; that is, ignore all the ins and outs that completely eliminate in the account in the same month.
- Fill in the “Account Use” field. Sometimes its not so obvious why an account exists, so this field will help reinforce the purpose of the account.
- Complete that “natural balance” field. Similar to item #6 above, sometimes its not so obvious.
- Always use debit/credit format for the form so there’s no confusion.
Keep up the use of this form on a monthly basis and you’ll always know what’s in your accounts.
Download: General Ledger Reconciliation Form (Excel).
See this form in Google Docs.