LedgerPortConvert a Bank of America CSV to QBO
Download your Bank of America transactions as CSV, drop the file below, and get a QBO file QuickBooks can import. The file is converted in your browser and never uploaded.
Confirming your payment…
Your licence key. Keep it: it unlocks your other computers, and it is printed on your invoice.
Your file is read on this device. It is never uploaded.
| File | Transactions | Status |
|---|
More than one account? Give each its own number, and reuse it every time, so your software files each statement under the right account.
More file details (optional)
These only label the file. The default bank ID 3000 is one QuickBooks recognises; you still choose your real account during import.
Columns (change these if the preview looks wrong)
| Date | Description | Amount |
|---|
Not reading your file correctly? Send us the column names
Your pass has ended. Lifetime keeps you going for good, and the pass you bought is deducted from its price.
Your 10 free documents have been used. Unlock this file, and every file after it:
Pay with CardApple PayGoogle PayLink
14-day refund if it does not work with your file. Secure checkout by Stripe: card, Apple Pay or Google Pay, with an invoice by email. Your file stays open here while you pay.
Buying for a team? Firm plans start at 3 users, at $69 per user a year.
Your licence
- Never uploaded. The file is converted on your device; it works with the internet off.
- See it before you pay. Every transaction is previewed for free.
- 10 documents free. No card, no account, no key.
- 14-day refund if it does not work with your file.
Getting the CSV from Bank of America
Sign in on the Bank of America website, open the account, and look for the option to download or export activity. Choose the date range you need and pick CSV (sometimes labelled "Spreadsheet" or "Excel CSV") as the file type. Mobile apps often lack this option, so use a desktop browser.
How the Bank of America file is read
Bank of America checking exports start with a short summary block (beginning balance, total credits, total debits, ending balance), followed by the columns Date, Description, Amount and Running Bal.
- The summary block and the "Beginning balance" line are recognised and left out; they are listed under the rows left out so you can see what was skipped.
- Amounts are already signed, so leave Reverse signs unticked.
- The last running balance becomes the closing balance in the QBO file.
Importing the QBO file
QuickBooks Desktop: choose File → Utilities → Import → Web Connect Files, select the file, and pick the account. QuickBooks Online: go to Transactions → Bank transactions, open the menu next to Link account, and choose Upload from file. The import guide has the full steps, and there is a page on fixing import errors.
Need a different output? The same file converts to QFX for Quicken, OFX or QIF.
Questions and answers
Does Bank of America see or approve this?
No. LedgerPort is an independent tool and is not affiliated with Bank of America. It only reads the file you downloaded, on your own device.
What if my export looks different from the one described?
Banks change their exports from time to time. The converter works from the column names and the data rather than a fixed template, and you can reassign any column in the Columns panel.
Is it free?
Your first 10 documents are free, whatever their size, with no card and no licence key. After that, plans start at $9. See pricing.