Convert Bank of America statement to QBO — accurate & reconciled

How Bank of America statements are structured

Bank of America statements print separate Withdrawals and Deposits columns in the transaction detail, and the account header — account number and statement period — repeats at the top of every page. Activity is grouped into labeled sections such as Deposits and other additions, ATM and debit card withdrawals, Checks, and Service fees, each with its own subtotal, and most pages carry no running balance column at all. Because the sign of a row depends on which section and which column it sits in, our parser reads the section headers and column positions rather than applying one global rule, then assigns debits and credits accordingly. The repeated page headers are detected and discarded so page breaks never turn into phantom rows. Checks are matched by number and kept in sequence. Once everything is extracted, we total each section and reconcile beginning balance plus deposits minus withdrawals against the ending balance printed in the account summary. If the statement's own numbers do not line up with what we extracted, the discrepancy is surfaced on the results page with the amount we are off by — nothing is silently adjusted.