How to read a bank statement

A bank statement has five parts, and only one of them is the transaction list everybody looks at. The other four are what let you tell whether the transaction list is complete.

The five parts

1. The header. Your name and address, the account number, usually masked to the last four digits, and the statement period. The period is the thing to read carefully. Cycles are cut on a day the bank assigned to your account, not on calendar months, so a statement labelled April often runs mid-March to mid-April.

2. The summary box. Beginning balance, total deposits, total withdrawals, ending balance. Four numbers on the first page. Most people skip it. It is the most useful part of the document and we come back to it below.

3. The transaction list. The bulk of the pages.

4. Fees and interest. Sometimes inside the transaction list, sometimes broken out. Worth reading once a year even if you never read anything else.

5. The back matter. Error resolution rights, dispute deadlines, regulatory notices. Boilerplate, except for the dispute deadline, which is a real clock.

The transaction list, column by column

Date. One date per transaction on a bank statement. Whether it is the day you spent the money or the day it settled depends on the bank, and none of them tell you. Card purchases usually post one to three days after the swipe.

Format varies more than you would expect, and it matters when converting. Chase writes MM/DD with no year at all. Capital One writes an abbreviated month and day, also with no year. Chime writes a full MM/DD/YYYY. The year lives only in the statement header, which is why a January statement converted in December can end up dated wrong if nobody is paying attention.

Description. The messiest column. What appears here is passed through from the payment network, and the bank does little to clean it up.

An ACH deposit on a Chase statement arrives in raw NACHA format: ORIG CO NAME, then ORIG ID, then DESC DATE, then an entry description, all on one line. A Wells Fargo card purchase reads PURCHASE AUTHORIZED ON 08/12 before the merchant name even starts. Bank of America prefixes debit purchases with CHECKCARD and appends a long reference number.

If a description looks like machine output, it is machine output. The abbreviations post covers what the recurring codes mean.

Amount, or debit and credit. Banks split into two camps.

Style	Banks	What it looks like
One signed column	Chase, Bank of America, Citi, Capital One, Chime	Withdrawals negative, deposits positive
Separate columns	Wells Fargo, TD Bank, PNC	Money in one column, money out the other, one of them blank on most rows

The separate-column style is the harder one to convert, because most rows leave a wide blank gap that a converter can mistake for part of the description.

Balance. The running total after each transaction. This column is the whole reason a bank statement can be verified, and the next section is about it.

Check number. Present at Wells Fargo and a few others, blank on almost every row, and sitting between the description and the amounts. That empty column is the single most common cause of amounts landing one column to the left in a converted file.

The check that takes thirty seconds

Go to the summary box on page one. It gives you four numbers. Then:

beginning balance + deposits - withdrawals = ending balance

If that holds, the statement is internally consistent. It does not prove the bank is right, but it proves you are reading a complete document.

Now the row-level version, which is the useful one. Take any transaction. Add its amount to the balance printed on the row above it. You should land exactly on the balance printed beside it.

That property holds for every row on the statement, and it is what makes bank statements verifiable in a way credit card statements are not. A card statement has no running balance, so a transaction dropped from the middle leaves no trace.

This is also what our converter does automatically. It walks the balance column after extraction and tells you whether the arithmetic closes. When it does, the extraction is almost certainly correct. When it does not, something was misread, and you know before the numbers reach your books.

What people miss

Fees buried mid-list. Monthly maintenance, overdraft, out-of-network ATM, foreign transaction, paper statement. They appear as ordinary transactions and read as ordinary spending. Sort a converted statement by description and they cluster, which is usually when people discover they have been paying twelve dollars a month for four years.

Pending versus posted. Statements show posted transactions only. Anything still pending at the cycle cut appears on the following statement, dated then. If your records disagree with the statement by exactly one transaction near the cycle boundary, this is why.

Holds. A hotel or gas station authorisation can hold more than the eventual charge. The hold does not appear as a transaction, but it moved your available balance at the time. This is the most common reason people remember having less money than the statement says.

Getting it into a spreadsheet

Reading a statement page by page is fine for one month. For a year, or for anything you have to categorise, you want it in a sheet.

Pick your bank and drop the PDF in. The converter already knows that institution’s column order, date format, and whether amounts are signed or split, so the output matches how your statement actually prints rather than a generic guess. Nothing is uploaded; the conversion runs inside the page.

For several months at once, convert each cycle and then merge the files. Where cycles overlap, check for duplicate rows before you do anything else with the result.