Convert a Bank of America Statement to Excel

How Bank of America structures its statement PDFs, which blocks are real transactions, and how to confirm your Excel export is complete.

Bank of America statements follow a sectioned structure similar to Chase: deposits and other additions, withdrawals and other subtractions, checks, and service fees, each with its own subtotal.

Section subtotals are the main trap

Each section ends with a subtotal line — "Total deposits and other additions", for example. These sit in the same columns as real transactions and are the single most common source of inflated totals in a converted BofA file.

The giveaway is that subtotal rows have no date. Any row carrying an amount but no transaction date is a summary line, not a transaction, and belongs in the verification data rather than the transaction list.

Getting the sign right

Bank of America prints amounts without a sign in most sections. Whether a row is money in or money out is determined entirely by which section it sits under. Lose the section context — as happens when a converter merges tables blindly — and every amount becomes ambiguous.

Section heading	Treat as
Deposits and other additions	Credit
Withdrawals and other subtractions	Debit
Checks	Debit
Service fees	Debit

Confirming the result

Bank of America prints beginning and ending balances plus per-section totals. That's enough to verify a conversion completely: each section's extracted rows should sum to its printed subtotal, and the balance chain should carry from beginning to ending.

Step by step

Download the PDF from online banking Bank of America statements from online banking carry a clean text layer.
Upload the whole file Do not split it by section — the section headings are what say whether each block is money in or money out, and the printed totals that check it cover the whole statement.
Check the section totals Each section's extracted rows should sum to the subtotal printed at the end of that section.
Export as Excel or CSV You get the rows as Bank of America printed them, each amount in the column it was printed in, with a Completeness sheet saying what the figures were checked against.

Multi-line descriptions

Bank of America ACH descriptors are long and frequently wrap onto a second line — the originator name on one line, a trace number and company identifier on the next. Only the first line carries the date and the amount.

If your converted file has rows with a description but no date, no amount and no balance, those are continuation lines being emitted as separate transactions. They belong joined onto the row above.

Frequently asked questions

Are check images in the PDF a problem?

No. Embedded check images are ignored; only the text layer is read.

Why does my export have fewer rows than the statement?

Most often because only the first section was extracted. Bank of America splits transactions into several blocks, and a converter that finds only the first returns a fraction of the file while looking complete.

Does it work with Bank of America credit card statements?

Yes. Credit card statements carry no running balance, so verification compares extracted totals against the printed summary.

Can I convert several months and combine them?

Yes. Convert each statement, then stack the exports. Each keeps Bank of America's own columns, so months printed in the same layout append cleanly.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.