Convert Bank of America statements to Excel, CSV or QBO

• Bank of America publishes a statement reconciliation worksheet that compares the statement ending balance with the account register.

Below the summary, transactions are not in one long table. Each kind of activity has its own section with its own subtotal: Deposits and other additions, Withdrawals and other subtractions, Checks, and Service fees. The amounts are printed as plain figures, and what tells you whether money came in or went out is the heading the row sits under. When the converter reads the statement it remembers which section it is in, so a payroll deposit lands in the export as a positive number and a card payment, a paid check or a monthly fee lands as a negative one.

There is no running balance next to each row. That changes how a conversion can be checked. With a per-row balance you could test every line against the previous one. Here the test is done on the whole statement: the beginning balance plus everything in the addition sections, minus everything in the subtraction sections, should equal the ending balance. If one row is missed or read with the wrong sign, the total stops matching, and the converter reports the gap before you export. Bank of America publishes its own reconciliation worksheet for comparing the statement ending balance with your register, and the same arithmetic is what the converter runs.

At the end of the statement there is usually a Daily ledger balances table, a list of dates paired with end-of-day balances. These lines look a bit like transactions, but they have no description and they are not money moving. The converter leaves them out of the export so you do not end up with phantom rows or doubled totals in your spreadsheet.

Service fees deserve a word of their own. Because they sit in a separate section, it is easy to overlook them when copying a statement by hand. In the export they appear as ordinary debit rows, which is what your bookkeeping software expects.

Bank of America is shown as Beta here. The layout notes come from the bank's older reading guide, its reconciliation worksheet and third-party descriptions, and support for it has been tested on synthetic replicas rather than on real customer statements. The official guide PDF could not be read as text, so details such as the MM/DD/YY date format are not confirmed by Bank of America itself. Credit card statements, business accounts and statements that cover several months use different layouts and are not covered for now.

Online Banking can give you recent activity as a download, but older months are kept only as PDF statements. If you need a full tax year, a loan file or a year of history for an accountant, converting the monthly PDFs is often the only route to a single workbook.