General Ledger + Converter in one subscription.
See pricingBLOG · BANK STATEMENTS
A bank statement shows the account, the period, an opening balance, every transaction and a closing balance. Layouts vary: a summary box with sectioned lists, one table with debit and credit columns, a card summary, or several accounts in one PDF. A bank statement converter such as ZeraBooks has to keep the printed balances to prove the result.
7-day trial · 1,000 pages a month from $79/month billed annually
DEFINITION
The bank’s own record of one account for one period, usually a month: who holds it, the account number, the opening balance, each deposit and withdrawal with its date, and the closing balance. The two printed balances are what make it proof.
WHAT’S ON IT
Every bank prints these, though not always in the same place or under the same name.
The business name and address, and the account number, usually shortened to the last four digits.
The first and last day covered. It matters more than it looks: many banks print transaction dates without a year, so the year comes from here.
What the account held at the start and end of the period. Opening plus every transaction must equal closing; that one sum is the check on everything else.
Totals for deposits, withdrawals, checks and fees, often with how many of each. Useful for checking, never to be copied as transactions.
Date, description and amount for each item, either grouped into sections or in one table.
A daily ending balance list or a running balance column. These restate the account’s balance; they are not money moving.
We set you up and catch up your past months for free. Then ZeraBooks keeps your books done.
FROM PDF TO ROWS
Here is a real run in ZeraBooks Convert. The statement belongs to Bayside Print Co., a fictional print shop: its September Chase Business Complete Checking statement with 21 transactions, file Chase_Business_Complete_Checking_x4417_Sep2026.pdf. Convert read every line and proved $18,432.17 + $993.57 = $19,425.74, the closing balance printed on the statement, before offering the download.
The PDF as uploaded
The same statement in ZeraBooks
EXAMPLE 1: SUMMARY BOX
Many U.S. business statements open with a summary box and then list each kind of transaction in its own section. Chase calls its box the Checking Summary. Here is a fictional one for Harbor & Pine Bakery, business checking, July 2026:
| Checking summary | Instances | Amount |
|---|---|---|
| Beginning balance | 12,480.60 | |
| Deposits and additions | 3 | 9,445.50 |
| Checks paid | 2 | (2,272.35) |
| Electronic withdrawals | 3 | (6,938.72) |
| Fees | 1 | (25.00) |
| Ending balance | 12,690.03 |
How to read it: 12,480.60 + 9,445.50 − 2,272.35 − 6,938.72 − 25.00 = 12,690.03. In the sections below a box like this, every amount usually prints without a minus sign, and the section heading tells you which way the money went. Dates print as MM/DD. A Daily Ending Balance list often follows the transactions; it repeats balances and isn’t a list of transactions. Bank by bank details: Chase bank statement to Excel.
THE SAME MONTH AS ROWS
A converter merges the sections into one dated list with a signed amount, so money out is negative. The bakery’s month:
| Date | Description | Type | Amount |
|---|---|---|---|
| 07/01/2026 | ACH rent, Wharf Street Properties | Withdrawal | −2,600.00 |
| 07/03/2026 | Card settlement deposit | Deposit | 4,215.00 |
| 07/08/2026 | Check 1184 | Check | −860.00 |
| 07/15/2026 | Payroll | Withdrawal | −3,920.00 |
| 07/17/2026 | Card settlement deposit | Deposit | 3,980.50 |
| 07/20/2026 | Electric utility | Withdrawal | −418.72 |
| 07/22/2026 | Check 1185 | Check | −1,412.35 |
| 07/28/2026 | Catering deposit | Deposit | 1,250.00 |
| 07/31/2026 | Monthly service fee | Fee | −25.00 |
| Net change | 209.43 |
The check: 12,480.60 + 209.43 = 12,690.03, the printed ending balance. Money in is 9,445.50 and money out 9,236.07; the difference is the same 209.43. Nine rows, not twelve: the summary box and the daily balances stayed out.
OTHER LAYOUTS
Layout facts from ZeraBooks’ public bank statement formats repository, which documents six banks with fictional sample months.
| Layout | Typical example | How to read it | The trap |
|---|---|---|---|
| One table, credit and debit columns | Wells Fargo business statements | Money in and money out in their own columns; a check number column; an activity summary above | The ending daily balance prints only on the last line of each day |
| Running balance, dates without a year | RBC and TD business chequing (Canada) | Cheques and debits, deposits and credits, then a balance | TD and RBC order columns differently; a January statement can start with a December date |
| Sections with changing names | Bank of America business statements | Deposits and other credits, withdrawals and other debits, checks, service fees | Older statements use other section names; checks often print two columns side by side |
| Credit card statement | Capital One business cards | Payment information and account summary, then one transactions list | Year-end totals and the interest calculation print amounts that look like charges |
Column and section names vary by product and year, so treat these as the usual pattern, not a specification. The repository’s sample files each add up to their printed closing balance. For the Wells Fargo layout step by step, see Wells Fargo bank statement to Excel.
EXAMPLE 2: A CARD STATEMENT
A card statement runs the other way: purchases raise what you owe, payments and refunds lower it. A fictional business card, one month:
| Account summary | Amount |
|---|---|
| Previous balance | 2,940.18 |
| Purchases | 1,806.44 |
| Payment received, thank you | (2,940.18) |
| Refund from a supplier | (54.20) |
| Interest charged | 0.00 |
| New balance | 1,752.24 |
The check: 2,940.18 + 1,806.44 − 2,940.18 − 54.20 = 1,752.24. Interest is zero because the previous month was paid in full. A rewards summary may sit on the same page; points earned aren’t money moving and aren’t rows. Card statements with several cardholders print a subtotal per person, which also has to tie. More on cards: credit card statement to Excel.
WHAT A CONVERTER MUST KEEP
Copying a PDF into a spreadsheet loses things quietly. A converter worth using keeps these.
Without them nothing proves the rows are complete. Bank activity downloads often leave them out, which is why the PDF statement is the better source.
Sectioned statements print every amount positive. The converter has to turn the section into a sign, or into separate money in and money out columns.
A year added from the statement period, including the December line on a January statement.
Some PDFs hold checking and savings together. Each account needs its own rows and its own proof.
Check numbers match a check register; ACH descriptions that wrap onto a second line belong to one row, not two.
Summary totals, daily balances, year-end totals and interest calculations stay out, or the money gets counted twice.
The layout notes on this page come from ZeraBooks’ open repository of bank statement formats, free to reuse with credit.
WITH ZERABOOKS CONVERT
ZeraBooks Convert reads bank, credit card, check and investment statements and gives you Excel or CSV. It doesn’t connect to your bank; you upload the PDF.
THE PROOF
For each account on a statement, the opening balance plus the transactions read must equal the printed closing balance; for a card, the previous balance plus charges minus payments must equal the new balance, and each cardholder must match their printed total. A statement that doesn’t add up is marked Needs a look before you download it.
How Convert proves a statement
THE FILE
Each row carries a Type from the section it was printed in, such as Deposit, Check or Fee, and money out is negative. Download as Standard, Money in and out, QuickBooks-ready, Xero-ready, Sage-ready or All details, in Excel or CSV, one file or one per account or cardholder.
Choose a download formatMORE BANKS
Yes: a fictional CommBank business statement, converted line by line in our CommBank statement to Excel example.
The bank’s name and your account details at the top, the statement period, an opening and closing balance, a summary of totals, then the transactions with dates, descriptions and amounts. Some banks group transactions into sections; others use one table with debit and credit columns. Bank pages such as the Monzo statement converter and the Synchrony statement converter show how one U.K. bank and one U.S. card issuer deliver their statements.
A statement is a fixed record of a closed period with printed opening and closing balances. A transaction history or activity download lists recent transactions and usually has no balances, so it can’t prove the list is complete.
On sectioned statements the section says which way the money moved, so every amount prints positive. On table layouts, money in and money out sit in separate columns. Either way, a spreadsheet needs a sign or two columns added.
Yes. Some banks print checking and savings, or several cards, in one statement. ZeraBooks Convert splits the transactions by account and proves each account against its own printed balances.
ZeraBooks keeps a public repository on GitHub, ZeraBooks/bank-statement-formats, with layout notes for Chase, Bank of America, Wells Fargo, Capital One, RBC and TD and a fictional sample month for each. Everything in it is made up.
1,000 pages a month for $149 a month, or $79 a month billed annually, after a 7-day trial. Larger page plans are listed on ZeraBooks pricing.
FREE SETUP + CATCH-UP
Any bank’s layout, read into rows and checked against the printed balances. 7 days, then 1,000 pages a month from $79 a month billed annually. When you’re ready to keep books from your statements, see AI bookkeeping.