Multiple accounts on one bank statement means one PDF that reports a client's checking, savings or other accounts together. Treat each account as its own set of books: split the file by account section, give each section its own opening and closing balance, and run the balance check on each one separately, never on the grand total.
Why do banks combine accounts on one statement?
Banks combine accounts because they bill and report by customer relationship, not by account. A client with a business checking account and a linked savings account receives one mailing, one PDF and one statement period, with a section for each account and often a summary page on top.
Combined statements are common for small businesses that opened several accounts at the same bank. They also appear when a client holds a line of credit or a money market account alongside checking. Not every bank does this, and some banks let the customer choose between combined and separate statements. If a client keeps sending combined files and you would rather have separate ones, ask whether the bank offers a setting for it. That is worth a short question to the client, because separate files are easier to name, store and check.
The catch for a bookkeeper is that the books do not combine. Each account is its own ledger account in QuickBooks or Xero, with its own reconciliation. A transaction in the savings section belongs to a different account than the line above it in the checking section, even though they sit on consecutive pages.
Splitting a combined statement by account section
Splitting by account section means each account ends up with its own lines, its own opening balance and its own closing balance. You can do that by cutting the PDF into one file per account, or by keeping the PDF whole and tagging every line with the account it came from.
Start by finding the section breaks. Look for a heading that names the account and a masked account number, such as "Business Checking ending 4417", followed by a small summary of that account's opening balance, deposits, withdrawals and closing balance. The summary page at the front lists every account, but it only holds totals, not transactions. Keep it, because it gives you the numbers to check against.
A few cautions apply when you split:
- A section can start in the middle of a page, so a page-range cut will not always separate the accounts cleanly. Tag lines by account instead of cutting by page when sections share a page.
- Keep the account number fragment with every piece, so a lone savings file never loses track of which account it is.
- Keep the period dates with every piece. A savings section for March is useless as a file named only "savings".
When you cut a PDF by months rather than accounts, the method differs; see how to find period breaks inside a combined statement PDF for that case. Once the sections exist, give each its own file name using the pattern in a bank statement file naming convention for client folders.
AutoBankConvert checks that the opening balance plus the transactions equals the closing balance before a statement is marked done. On a combined file, confirm that each account section got its own check, rather than one check on the summary total.
A worked example
The figures below are an example of a combined statement for March, with a checking section and a savings section. All values are illustrative.
| Line | Account | Debit | Credit | Balance |
|---|---|---|---|---|
| Opening | Checking ending 4417 | 8,200.00 | ||
| Customer deposit | Checking | 5,400.00 | 13,600.00 | |
| Rent | Checking | 2,100.00 | 11,500.00 | |
| Supplies | Checking | 640.00 | 10,860.00 | |
| Transfer to savings | Checking | 1,500.00 | 9,360.00 | |
| Closing | Checking | 9,360.00 | ||
| Opening | Savings ending 9082 | 12,000.00 | ||
| Transfer from checking | Savings | 1,500.00 | 13,500.00 | |
| Interest | Savings | 4.10 | 13,504.10 | |
| Closing | Savings | 13,504.10 |
The checking check: 8,200.00 plus 5,400.00 minus 2,100.00 minus 640.00 minus 1,500.00 equals 9,360.00, which matches the printed closing balance. The savings check: 12,000.00 plus 1,500.00 plus 4.10 equals 13,504.10, which also matches. Each account passes alone. The two accounts together open at 20,200.00 and close at 22,864.10, a figure that appears on the summary page and that you should never use as the check for either ledger.
Transfers between accounts on a combined statement
A transfer between accounts on a combined statement appears twice: as a withdrawal in one section and a deposit in the other. In the worked example, 1,500.00 leaves checking and arrives in savings. Record it once as a transfer between the two ledger accounts, not as an expense plus income.
If you load both lines as ordinary transactions, income and expenses both grow by 1,500.00, and the profit and loss report overstates both. The fix is to categorize the pair as a transfer, with the checking line posted to the savings account and the savings line matched to it, so the two lines cancel.
Watch for timing. A transfer made on the last day of the period can show in one section on March 31 and in the other on April 1. The statement for April will then hold a deposit with no matching withdrawal in the same file. Do not force a match inside a single month. Leave the transfer open until both sides are loaded, and note the date gap. The same treatment applies to a client paying a card from checking, which is covered in credit card statement bookkeeping for client accounts.
Which balance applies to a combined statement?
The balance that applies is the one printed for each account, not the combined total. Every account section has its own opening and closing balance, and each ledger account reconciles to its own figure. The summary page total is useful for a sanity check only.
In practice, three balance questions come up:
- Which opening balance starts the month? Use the prior month's closing balance for that same account. If the savings opening balance does not match last month's savings closing balance, a statement is missing or a section was misread.
- Which closing balance do I reconcile to? The one at the end of the account's own section, matched to the same account in the books.
- Does the summary total matter? Only as a cross-check. Add the section closing balances; the sum should equal the combined figure on the summary page. If it does not, a section was missed.
A combined file that passes for checking but fails for savings tells you where to look. The gap points to a line in the savings section, not to the statement as a whole. That precision is the reason to check account by account. If you convert statements in bulk, what a bank statement converter for bookkeepers should return describes the checks to expect, and AutoBankConvert applies the balance check to each statement it reads.