To reconcile multiple bank accounts at month-end, start from a complete list of every account, reconcile the busiest operating account first, then the accounts that feed or drain it. Prove each internal transfer on both sides before calling either account done, and track status, difference and reviewer for every account on one sheet.
Which bank account should you reconcile first when there are several?
Reconcile the main operating account first. It touches almost every other account through transfers, sweeps, payroll funding and card payments, so finishing it gives you a confirmed list of what left or entered each sibling account. The smaller accounts then reconcile against known amounts instead of guesses.
A workable order for a typical small business looks like this:
- Operating account. The most lines, the most transfers, the most risk of error.
- Payroll account. Usually funded from operating, so its incoming transfers are already proven.
- Merchant or deposit accounts. Card settlements and lockbox credits that are swept to operating.
- Savings and reserve accounts. Few lines, mostly interest and transfers. Reconciling a savings account each month covers the quirks, such as statements that arrive quarterly.
- Foreign currency or special-purpose accounts. These need their own method, covered in reconciling a foreign currency bank account, because the balance must be revalued after it agrees.
- Dormant or near-dormant accounts. Quick to do, and the ones most likely to be skipped.
The order matters less than the rule behind it. Work from the account with the most connections outward. Each finished account turns its transfers into facts for the next one.
Why not reconcile them all at once?
Doing several accounts in parallel tempts you to match a transfer on one side and assume the other. A transfer of 5,000.00 out of operating and 5,000.00 into payroll looks paired, but if the payroll side shows 5,000.00 on a different date, or twice, the assumption hides the error. Finishing one account before starting the next keeps each match grounded in a statement line.
An account inventory before the multiple bank account close
An account inventory is a list of every bank account the entity owns, with bank, last four digits, purpose, ledger account and statement cycle. Build it before the first close and confirm it every month. An account that is not on the list will not be reconciled, and nobody will notice it missing.
Sources to build the inventory from:
- The chart of accounts. Every cash account in the ledger should map to one real account.
- The bank's online portal. Most portals list all accounts tied to a login, including ones the bookkeeper never sees in the ledger.
- Bank statements arriving by mail or email. A statement for an account not in the ledger is a red flag, not a filing problem.
- Year-end bank confirmations or the bank's account list, if the entity is audited.
- The 1099-INT forms that banks issue for interest, which can reveal an interest-bearing account no one mentioned.
Compare the lists. Any account in one source but not another needs an answer before month-end, not after.
What each inventory row should hold
Keep the inventory short enough to read in a minute. For each account, record the bank, the last four digits, the ledger account it maps to, its purpose in a few words, the statement cycle, who receives the statement and who can move money out of it. The last two columns matter most. They show at a glance whether the person reconciling the account is also the person who could empty it, and whether statements still reach someone who reads them.
Date the inventory and keep each month's copy. When an account is opened or closed, the change appears between two dated versions, which is the simplest record a reviewer can ask for.
Transfers between the bank accounts you reconcile together
An internal transfer moves money between two accounts the same entity owns. It should appear once in the ledger, as a credit to one cash account and a debit to the other, and once on each bank statement. When you reconcile multiple bank accounts, prove both legs before marking either account finished.
The check is simple. For each transfer out of an account, find the matching transfer in on the other account's statement, with the same amount, within the expected number of business days. Most same-bank transfers post the same day. Transfers between different banks can take a day or more.
Three things go wrong with transfers:
- One leg recorded twice. Two people each record the transfer from their side, so the ledger shows two entries. Both accounts will be off by the transfer amount, in opposite directions.
- A leg in transit. The money left one account on 31 March and arrived in the other on 1 April. Both statements are correct, and the ledger needs to know which side is timing.
- A leg that never arrived. The out-transfer posted and nothing came in. That is not a timing item if it persists. It may be a transfer sent to the wrong account.
Reconciling transfers between bank accounts without doubling them works through each case. Transfers that leave at month-end and land after it behave like the timing items in outstanding checks and deposits in transit: they sit on the reconciliation, not in a journal entry.
A month-end tracking sheet for multiple bank accounts
A tracking sheet is a single table with one row per account, showing the statement date, the balance per bank, the adjusted book balance, the unexplained difference, the preparer, the reviewer and the date signed. It turns "are the banks done?" into a question anyone can answer by looking.
The table below is an example for a fictional company's March close. All values are made up.
| Account | Statement date | Balance per bank | Adjusted book balance | Difference | Preparer | Reviewer |
|---|---|---|---|---|---|---|
| Operating, ending 2210 | 31 Mar | 84,312.55 | 84,312.55 | 0.00 | JL | MK, 6 Apr |
| Payroll, ending 7781 | 31 Mar | 1,018.40 | 1,018.40 | 0.00 | JL | MK, 6 Apr |
| Merchant deposits, ending 0934 | 31 Mar | 3,640.00 | 3,412.80 | 227.20 | JL | open |
| Reserve savings, ending 5520 | 31 Mar | 40,092.17 | 40,092.17 | 0.00 | JL | MK, 7 Apr |
| Old escrow, ending 3306 | 28 Feb | 512.00 | 512.00 | 0.00 | none | none |
Reading the example sheet
Three rows are finished and signed. The merchant account has an unexplained difference of 227.20, so it stays open. The escrow account is the interesting one: its statement is a month old, nobody prepared it and nobody reviewed it. The difference column reads zero only because the figures were copied from February.
Add a transfer-pairing check under the main table. List every internal transfer in the month, the account it left, the account it entered and whether both legs have been ticked. The column of ticks should be complete before the reviewer signs any row that the transfers touch.
If the books run in QuickBooks Online, each account is reconciled separately on its own screen, and the tracking sheet sits outside the software. Reconciling in QuickBooks Online shows that screen and what its zero difference does and does not prove.
How do you spot a bank account nobody has reconciled?
A bank account nobody has reconciled shows itself through stale dates. Its last reconciliation is older than the others, its statement date lags the month, its ledger balance has not moved, or its preparer field is blank. Sort the tracking sheet by last reconciled date and the forgotten account rises to the top.
Other signs worth checking each month:
- A ledger balance that never changes. If the bank charges a monthly fee, the balance should move. A flat balance means fees are not being recorded, which means the statement is not being read.
- Statements going to someone who has left. Online statements tied to a former employee's login, or paper statements to an old address, stop reaching the bookkeeper.
- An account opened for a project that ended. Escrow, grant or construction accounts often outlive their purpose and drop off the routine.
- A small balance treated as immaterial. Small accounts are also cheap places to move money without attention.
When you find one, reconcile it back to the last point where it agreed, then forward month by month. Decide whether it should be closed. An account that serves no purpose is a control risk, because activity in it gets little scrutiny.
When multiple bank accounts should not share one reconciler
Multiple bank accounts should not share one reconciler when the same person can also move money between them. Someone who initiates transfers and reconciles both sides can hide a shortage in one account by shifting the gap to another, and each reconciliation still looks clean on its own.
Split the work, or add an independent review, in these cases:
- The preparer has online banking rights to send transfers or wires between the accounts.
- One account is a trust, escrow or client account, where the owner of the funds is not the business.
- Volume is high enough that the preparer cannot finish every account inside the close deadline.
- An account has shown repeated unexplained differences, which calls for a second pair of eyes.
Even in a very small office, the reviewer can look at the transfer-pairing check alone. Ten minutes on both legs of every internal transfer catches most of what a single reconciler could hide.
When several statements arrive at once, PreciseBankFlow foots each one and lists its unmatched lines as exceptions, which gives each row of the tracking sheet a starting point backed by the statement. You can request early access to try it on a close.