Reconciling an account step by step
Use the same order every time. It helps. The steps below are general, and menu names differ a lot from one program to the next, so treat them as a map rather than a script. Menu names differ between programs, so follow your own software's help pages for the exact screens.
One accounting manual sums up the order. Match existing entries first, create missing ones only when necessary, and explain every difference at the end.1
Before you start
You'll need three things in front of you:
- The account you're reconciling, such as the main checking or current account.
- The bank statement, or the statement date and closing balance shown online.
- Your feed lines, imported and up to date. If the feed has stalled, fix that first. Where feed lines come from is covered earlier.
The steps
Choose the account and the statement end date. Use the date on the statement. Don't use today's date unless that's the date on the statement.
Check the opening balance. It should equal the closing balance of your last finished reconciliation. One manual explains that its opening balance is the balance up to the day before the start date.1 In that manual, an entry dated on the start day is not in the opening balance. Other programs may differ. If the opening balance has changed since last time, an old entry may have been edited, or the start date may be off. Stop and find it before going on.
Match the bank lines to existing records. Work down the list. For each line, compare amount, date, reference, party and description.2 How the software matches lines explains what it's doing behind the suggestions.
Search before you create. If a line has no match, look for the record first. The same manual says not to create a new entry until you have searched for an existing one.2 Creating a second record for a payment you already entered is how duplicates start.
Record what's genuinely missing. Bank fees, interest and similar items appear on the bank side before you've written them down. The manual says to record bank fees, interest and timing differences explicitly.1 Categorize each one, by hand or with a bank rule.
Leave timing items open. A payment you recorded that the bank hasn't processed yet stays unmatched for now. Don't force it.
Compare the final figures. The closing balance in your software should agree with the statement.1 The difference should show zero.
Finish. Do it only once the difference is zero, or once you can name every item that explains it. Not before.
If you fall behind
A quick look may not explain the gap. Then the whole period needs a line-by-line pass.3 That's slow. Doing it often keeps each pass short, which is the point of a regular schedule.
When the difference isn't zero
Don't add a made-up entry to force it. Check the date range first, then the opening balance, then duplicates. The page on a stubborn difference gives the full order to look in.
Keep a record
Save the report. If your software offers a printable reconciliation report, keep a copy. It shows what was matched and what stayed open. That helps when an accountant asks about a past period months later.
Notes and sources
- Bank Reconciliation, ERPNext Documentation
- Bank Transaction, ERPNext Documentation
- Reconciliation (accounting), Wikipedia