A bank statement PDF is laid out for a person reading a printed page. A spreadsheet needs something stricter: one row per transaction, one column per kind of value, and numbers that are numbers. Getting from one to the other depends on which of three layouts your bank uses, because each one hides the sign of an amount in a different place.
This guide shows the three layouts, what a correct spreadsheet looks like for each, and how to prove the conversion is complete. Every figure below is invented for the example.
Layout 1: deposits and withdrawals in separate sections
Many US banks print the money coming in and the money going out as separate lists under headings, often with checks and fees in lists of their own. Bank of America, Chase and Wells Fargo statements are typical. A cut-down example:
Deposits and other credits
Date Description Amount
01/03/26 Payroll deposit EXAMPLE CO 1,800.00
01/17/26 Transfer from savings 200.00
Total deposits and other credits $2,000.00
Withdrawals and other debits
Date Description Amount
01/05/26 Rent payment SAMPLE PROPERTIES -1,200.00
01/09/26 Card purchase GROCERY STORE 0412 -85.40
REF 000123
Total withdrawals and other debits -$1,285.40The trap is that the amount column alone does not tell you which way the money moved. Some banks print withdrawals with a minus sign and some do not; the only reliable signal is the heading above the row. A converter that reads the rows without tracking the heading turns your rent into income.
The spreadsheet this should become:
Date Description Amount 2026-01-03 Payroll deposit EXAMPLE CO 1800.00 2026-01-05 Rent payment SAMPLE PROPERTIES -1200.00 2026-01-09 Card purchase GROCERY STORE 0412 REF 000123 -85.40 2026-01-17 Transfer from savings 200.00
Three things changed, and all three matter:
- One list, in date order. The sections are merged and sorted by date, so the spreadsheet reads like the account actually moved. Entries on the same day keep the order the statement gave them.
- The sign comes from the section. Money out is negative whether or not the PDF printed a minus.
- The wrapped line is joined back on. "REF 000123" sits on its own line in the PDF with no date and no amount. It belongs to the card purchase above it, so it goes into the same description cell rather than becoming a row of its own.
Section statements rarely print a balance after every row (the daily balances, if any, appear in a separate table), so the check here is the totals. The deposits you extracted must add up to the printed "Total deposits", the withdrawals to "Total withdrawals", and the opening balance plus money in minus money out must equal the closing balance. With an opening balance of 1,000.00 in the example:
1,000.00 + 2,000.00 − 1,285.40 = 1,714.60 (the closing balance)
Layout 2: one amount column with a sign
The second layout has a single amount column, and the direction is carried by the number itself. Card statements, many European banks and most digital banks work this way. The sign can be written in at least four ways, sometimes more than one on the same statement:
-85.40 leading minus (the most common) 85.40- trailing minus (85.40) accounting brackets 85.40 Dr a Dr or Cr marker
All four mean the same thing, and all four must end up as the number -85.40 in Excel, not as text. If a cell holds the characters "(85.40)", SUM ignores it and your totals quietly drop that row. The converter here reads each of these forms, along with currency symbols and both 1,234.56 and 1.234,56 number styles.
The spreadsheet keeps the same shape as layout 1: Date, Description, Amount, plus Balance when the statement prints one. If there is a balance column, use it: it is the strongest check there is, covered below.
Layout 3: separate debit and credit columns with a running balance
Most Indian banks, and many others, print two money columns (withdrawals and deposits, or debit and credit) and a balance after every row:
Date Narration Debit Credit Balance
01/04/26 OPENING BALANCE 25,000.00
02/04/26 UPI/600000000001/SAMPLE STORE/ 1,250.00 23,750.00
PAYTM
05/04/26 NEFT CR-EXAMPLE PVT LTD-SALARY 40,000.00 63,750.00
07/04/26 ATM WDL SAMPLE BRANCH 5,000.00 58,750.00For this layout the spreadsheet should keep the columns as they are: Date, Description, Debit, Credit, Balance. Collapsing them into one signed column would make the sheet harder to compare against the PDF line by line, and the balance column already gives you the proof you need.
The narration in the second row wraps in the middle of a UPI reference. Joined back together it must read "UPI/600000000001/SAMPLE STORE/PAYTM", with no space before PAYTM, because on the bank's side it was one unbroken string. A space there splits the payee name you will later want to search for. The converter here joins without a space when the break falls right after a slash or hyphen, and with one otherwise.
If you want a single signed column as well, add one yourself. With debit in C and credit in D:
=D2-C2
Why one row per entry, and the whole description in one cell
It is tempting to accept a conversion that keeps the PDF's visual lines, with a wrapped description spilling onto a second row. It looks close to the original. It breaks almost everything you would do next:
- Sorting by amount separates the second half of a description from its transaction.
- Filtering for a payee misses the rows where the name landed on the continuation line.
- Counting rows no longer counts transactions.
- A pivot table by description groups half-names.
One row per transaction, with the full narration in one cell, is what makes a statement usable as data.
Signed amounts make the arithmetic simple
With money out negative in one column, the questions people actually ask a statement become one formula each:
Net movement for the period =SUM(C:C) Money in =SUMIF(C:C,">0") Money out =-SUMIF(C:C,"<0") Spent at one payee =-SUMIFS(C:C,B:B,"*GROCERY*",C:C,"<0")
None of these work if the minus sign was lost, or if amounts arrived as text. A quick test: select the amount column and look at the status bar. If Excel shows a Count but no Sum, the values are text.
The statement details block
A statement says more than its transactions: which bank, whose account, which period, and the balances at each end. The bank statement converter puts these above the table as a short block of label and value rows:
Statement details Account holder A. SAMPLE Account number XXXX1234 Statement period 1 April 2026 to 30 April 2026 Opening balance 25,000.00 Money in 40,000.00 Money out 6,250.00 Closing balance 58,750.00 Entries 3
Each line appears only when the statement itself states it. A Bank line is added when the bank is one the converter knows (a list of about fifty US, UK, Indian and other banks), and it is read from the top of the statement and its small print, never from a payee in an entry, so a card payment to another bank does not relabel your statement. Money in and money out are added up from the entries, which gives you the check in the next section at a glance.
Bank notices, page headers, "continued on next page" lines and similar page text are left out of the table. If you need every row exactly as the PDF printed it, the converter has an "Export the raw rows instead" option. Before you send the spreadsheet to anyone, remember that the details block contains your account number; see what you give away with a bank statement.
Proving the conversion is complete
Whichever layout you have, these checks tell you whether anything was dropped or misread:
- Opening plus in minus out equals closing. Works for every layout. In the debit and credit example: 25,000.00 + 40,000.00 − 6,250.00 = 58,750.00.
- Section totals. For layout 1, the extracted deposits and withdrawals must each match the printed totals. The converter here compares them and warns you, with both figures, when they differ.
- The running balance. For layouts 2 and 3, every row's balance must equal the previous balance plus its credit minus its debit. The converter checks every row and names any that fail; the Excel formula for doing it yourself is in how to check a converted statement.
- First and last dates. They should match the statement period, which catches a skipped page that the arithmetic alone might not.
If a check fails, look for what the failing rows have in common rather than fixing cells one by one; why converters get the numbers wrong lists the usual causes.
Two cases where no layout helps
A scanned statement. If the PDF is a photograph of paper, there is no text to extract. The converter says so and points you to OCR first; better still, download the statement again from your bank's website, where it will have real text.
A password-protected statement. Many banks lock statement PDFs with a password built from your details. The converter asks for it and opens the file in your browser; more in your bank statement PDF is password-protected.
For tables that are not bank statements, such as price lists or invoices, the general PDF table to Excel tool keeps rows and columns as they are. It also recognises when the PDF you gave it is a bank statement, says so, and exports it in the statement layout; the raw rows option is there too if you want the page exactly as printed.