Convert a Bank of America statement to QBO
Bank of America downloads start with a summary block before the transactions, and PDF statements split money in and money out into separate sections. We handle both and give you one clean QBO file.
Columns (only if we guess wrong)
Column numbers in your CSV or Excel file, counting the first column as 1.
No sign-up. Files are deleted after 24 hours. Credits never expire. Download a sample file to try it.
How it works
- Step 1
Upload
The CSV or Excel download from online banking, or a PDF statement.
- Step 2
Check
Free preview of every transaction as QuickBooks will read it: date, payee, signed amount.
- Step 3
Import
QuickBooks Online: Banking > Upload transactions. Desktop: File > Utilities > Import > Web Connect Files.
What you get
Description,,Summary Amt. Beginning balance as of 03/01/2026,,"2,000.00" ... Date,Description,Amount,Running Bal. 03/04/2026,"STAPLES 00123 DES:PURCHASE","-45.10","1,954.90"
| Date | Payee | Amount |
| 2026-03-04 | STAPLES 00123 DES:PURCHASE | -45.10 |
Getting your transactions out of Bank of America
- Recent activity: in Online Banking open the account, choose Download, set the dates and pick the spreadsheet (CSV) option.
- Older history: go to Statements & Documents and download the monthly PDF statements.
What makes Bank of America files tricky
- The CSV opens with summary lines (beginning balance, total credits, total debits, ending balance) before the real header
Date, Description, Amount, Running Bal.. We skip the summary and start at the transactions. - The first transaction row is often a "Beginning balance as of" line with no amount. It is not a transaction, so it is left out.
- PDF statements group transactions into Deposits and other additions, Withdrawals and other subtractions, Checks and Service fees, with no running balance. We read every section and check that the beginning balance plus all sections equals the ending balance.
Pricing
Preview every file free: see the transactions exactly as QuickBooks will read them before you pay. Credits never expire. No subscription needed. Prices are in US dollars; sales tax or VAT is added at checkout where it applies.
1 file
$9 per file
$9
10 filesBest value
$2.90 per file
$29
Unlimited files every month
$0.08 per file, billed monthly, cancel any time, fair use 500 files a month
$39/mo
Deleted after 24 hours
Your upload and the result are removed automatically.
Never used for training
Files are processed only to make your result.
Refund if it is wrong
If a result is unusable, we fix it or refund you.
Questions
Can I convert a Merrill or Bank of America business account?
Business checking downloads and statements work the same way. Investment statements are not bank transactions and are not supported.
Why does my Bank of America PDF have no balance column?
Its statements list sections instead of a running balance. We check the totals for each section against the statement summary instead.
Is my statement kept?
No. Files are deleted automatically 24 hours after upload and never used to train AI.
How much does it cost?
The preview is free. $9 per file, $29 for 10 files, or $39 a month for unlimited files.
Does it work with QuickBooks Online and QuickBooks Desktop?
Yes. The same QBO (Web Connect) file imports in both. QFX for Quicken and OFX for Xero download from the same conversion.
Is this made by Intuit or my bank?
No. This is an independent tool. QuickBooks and Quicken are trademarks of Intuit Inc.; bank names are used only to describe their files.