Reconciling Multiple Bank Accounts for One Client

Reconciling multiple bank accounts for one client works best in a fixed order: the main operating checking account first, then savings, cards and loans. Each internal transfer is matched on both sides, so a transfer reconciled in checking must appear in the receiving account too. Loan balances are tied to the lender's statement, principal only.

Which of the multiple bank accounts do you reconcile first?

The account to reconcile first is the client's main operating checking account, the one most of the other accounts touch. Deposits arrive there, card and loan payments leave from there, and transfers to savings start there. Once it is reconciled, every transfer and payment it sends has a confirmed amount and date to match on the other side.

Think of the operating account as a hub. A small business with checking, savings, a credit card and an equipment loan might have a dozen movements a month between them, and nearly all of them pass through checking. Reconciling checking first means you identify every outgoing payment once, then use it as the reference when you open the card or loan statement.

The rest follow by how much they depend on the hub:

1. Operating checking, the hub.
2. Other checking or payroll accounts funded from the hub.
3. Savings and money market accounts, which mostly hold transfers and interest.
4. Credit cards, whose payments come from checking.
5. Loans and lines of credit, whose payments and draws also run through checking.

Reconcile the same statement month across every account before moving on. Doing all of January, then all of February, keeps transfers between accounts in the same period. Doing a full year of checking before opening savings means you will find mismatched transfers months after you could have fixed them cheaply.

There are exceptions. If one account is far behind or its statements are incomplete, set it aside and finish the others; its transfers will show as unmatched until you return to it. And if a client has two hubs, such as an operating account and a separate payroll account at another bank, reconcile the one with more outside activity first.

A complete set of statements is the precondition for any order. Schema CPA reads checking, savings and loan statements in the client's file, checks that each one's closing balance becomes the next opening balance, and flags the month that is missing, so you know before starting which accounts are ready to reconcile.

Matching transfers between a client's accounts

A transfer between a client's own accounts is one movement of money that appears on two statements, out of one account and in to another. Matching it means confirming both sides exist, the amounts agree, and the books record it once as a transfer, not as income on one side and an expense on the other.

The most common error is recording both sides separately. A bookkeeper reconciling checking codes a $2,500 outflow to an expense, and someone reconciling savings codes the $2,500 inflow to income. Each account reconciles, yet the client's profit is wrong in both directions. A transfer entry posts to both accounts at once and avoids that.

Accounting software handles this differently, so check how yours does it. Xero's guide to transferring money between bank accounts says you only need to create the transfer in one bank account; Xero creates the matching transaction in the other, and you click OK to reconcile it there. It also warns to use only one method per transfer, either creating it before reconciliation or during it, to avoid duplicates.

Match by amount first, then date, then reference. Most transfers carry the same amount on both sides. Dates may differ by a day when the bank posts the receiving side later. Bank references help when several transfers share an amount, such as weekly sweeps of the same figure.

Some movements are not one-to-one. A single deposit to checking may come from two savings withdrawals, or a loan payment may combine principal, interest and escrow. In those cases match the total, then confirm the parts against the statement that itemizes them.

A transfer-matching table across three accounts

This example is fictional. Larchmont Print Shop (example client) has operating checking XXXX-4821, savings XXXX-9050 and an equipment loan XXXX-3317 with an example lender. All figures are for January.

Three movements match inside January. The fourth left checking on January 31 and reached savings on February 1, so the January savings statement does not show it. That one is handled as a timing item, which the section on transfers landing in a different month covers.

Loan statement reconciliation: principal, interest and escrow

Loan statement reconciliation means tying the loan liability in the books to the outstanding principal balance on the lender's statement. Each payment from checking splits into parts: principal lowers the balance owed, interest is a cost of borrowing, and escrow, where a mortgage has one, is money the servicer holds for taxes and insurance.

For consumer mortgage loans, the statement format is set by regulation. Regulation Z, section 1026.41 requires the servicer's periodic statement to break the payment down into how much goes to principal, interest and escrow, to show the total of payments received since the last statement and how they were applied, and to state the outstanding principal balance. Those figures are exactly what the reconciliation uses. Regulation Z, section 1026.3 exempts credit extended primarily for business purposes, so a business equipment loan's statement may use a different layout or leave lines out. Read each lender's statement for the equivalent figures, and ask for a payment history when the split is not shown.

Reconcile in three steps:

1. Match the payment. The amount leaving checking should equal the total payment the lender reports receiving.
2. Check the split. Principal, interest and escrow from the lender's statement should add to that payment, and the books should carry the same split.
3. Tie the balance. The loan account in the books should equal the statement's outstanding principal balance as of the statement date.

When the balance does not tie, the split is usually the cause. A payment booked entirely to the loan account overstates how much principal was repaid by the interest and escrow amounts. Over twelve months that difference grows, and the loan account ends the year well below what the lender says is owed.

Escrow needs its own attention. The servicer pays property taxes and insurance out of escrow, and the statement shows those disbursements. How a firm records escrow is a judgment for the engagement; the reconciliation's job is to make sure the amounts in the books agree with what the statement reports.

Lines of credit behave more like cards: draws raise the balance, payments lower it, and interest posts monthly. For card accounts in particular, see card payments, refunds and interest on the credit card statement.

Transfers that land in a different month

A transfer lands in a different month when money leaves one account on the last day of a period and arrives in the other on the first day of the next. Both sides are real and the amounts agree, but at month end only one statement shows the transfer. The gap is timing, not an error.

The fix is to record the transfer on the date it left the sending account and treat the receiving side as in transit. On the sending account's reconciliation, the transfer clears because the statement shows it. On the receiving account's reconciliation, it stays outstanding, the same way a deposit made after the bank's cutoff does. Next month's statement shows the arrival, and it clears then.

Take Larchmont Print Shop, a fictional client: $10,000.00 left checking on January 31 and reached savings on February 1. The January checking reconciliation clears it. The January savings reconciliation lists it as a deposit in transit, so the savings account in the books is $10,000.00 higher than the January savings statement. The February savings statement shows the deposit, and the difference disappears.

Weekends and holidays stretch the gap. A transfer started on a Friday that is also month end may not post to the other account until Monday. Banks also differ in when they post, especially between institutions. When a transfer has been in transit for more than a few business days, check whether it arrived at all.

Two mistakes are common here. One is recording the transfer twice, once on each date, which overstates the receiving account. The other is moving the transfer date to the 1st so both statements agree, which leaves the sending account unreconciled for January. Recording one transfer and letting the receiving side be outstanding avoids both.

Year end makes this matter more. A transfer in transit on December 31 affects what each account shows on the client's year-end balance sheet. The post on year-end bank reconciliation covers the December checks in detail.

A monthly checklist for bookkeeping client bank accounts

A monthly checklist for bookkeeping client bank accounts turns a multi-account close into the same steps in the same order every month. It starts with collecting every statement, reconciles the hub account first, matches transfers across accounts, ties loan and card balances, and ends with a list of open items for the next month.

A workable checklist for one client:

1. Collect every statement for the month: each checking, savings, card and loan account. Confirm each statement's opening balance equals last month's closing balance.
2. Enter or import transactions for the period in every account before reconciling any of them.
3. Reconcile operating checking to its statement.
4. Reconcile other checking and payroll accounts.
5. Reconcile savings and money market accounts, matching each transfer to its checking side.
6. Reconcile each card to its statement closing date, not the calendar month end.
7. Tie each loan to the outstanding principal balance on the lender's statement, with the payment split checked.
8. List transfers in transit and other outstanding items, with the account and amount for each.
9. Save each reconciliation report with the statement it was reconciled to.

Step 1 catches more problems than any other. A missing savings statement means every transfer to savings that month cannot be confirmed, and a missing loan statement means the principal balance cannot be tied. Request missing statements before starting, not halfway through.

Step 8 is the hand-off to next month. Each item on the list should clear on the following statement. Any item still open after two cycles needs a closer look.

For a client with many accounts, the checklist also shows where time goes. If one account takes most of the hour every month, that account may need a bank rule, a cleaner feed, or a conversation with the client about how it is used. Statement-level reconciliation also feeds the client's financial statements; the financial statements and ledgers category covers what comes after the bank work.

When should a client consolidate bank accounts?

A client should consider consolidating bank accounts when the accounts no longer serve separate purposes and the extra transfers, statements and reconciliations add work without adding information. Whether to close an account is the client's decision. The bookkeeper's part is to show what each account is doing and what it costs to keep reconciling it.

Signs that accounts have sprawled:

• Two accounts with the same job, such as two operating accounts at different banks that both pay vendors.
• Accounts that only shuttle money, receiving a transfer and sending it on within days.
• Dormant accounts with a small balance and no activity except a monthly fee.
• Accounts the client forgot about, discovered when a statement turns up in the mail.

Each extra account adds a statement to collect, a reconciliation to run and transfers to match every month. A dormant account still needs its statement reconciled, and a forgotten one may hold activity no one has recorded.

There are good reasons to keep separate accounts. A separate payroll account limits who can see and move operating cash. A tax savings account makes set-aside money visible. Loans and cards cannot be merged into checking at all. The question is purpose, not count.

When you raise consolidation, bring the record. A short list showing each account, its purpose, its monthly transfer count and its fees makes the conversation about facts. If a client is catching up after months of unreconciled accounts, the post on catch-up bookkeeping from bank statements covers rebuilding first. Statement reconciliation across a client's accounts is part of Schema CPA's Practice plan; the pricing section of the homepage lists what each plan includes.