Step 1: Download the PDF from Bank of America
Log in to bankofamerica.com or the Bank of America mobile app. Go to your account, tap Statements & Documents, select the statement period, and click Download. The file is typically named eStmt_YYYY-MM-DD.pdf.
Download the official statement PDF, not a transaction list export. The full statement produces better conversion results.
Step 2: Upload the PDF to pdftoxlsx
Go to pdftoxlsx.com and drag the PDF into the upload area. No account is required for a first conversion. For password-protected PDFs, enter the password when prompted.
pdftoxlsx processes Bank of America statements in about 15 seconds. Files are encrypted in transit and deleted within 24 hours.
Step 3: Review the auto-detected layout
pdftoxlsx auto-detects the Bank of America statement template (checking, savings, credit card, or business). A preview shows extracted columns: Date, Description, Amount, Balance, and Currency.
Bank of America checking statements have a distinctive two-column layout with deposits on the left and withdrawals on the right. pdftoxlsx normalizes this into a single transaction ledger with positive amounts for deposits and negative for withdrawals — no manual cleanup needed.
Step 4: Download the Excel file
Click Download .xlsx (or .csv for tools that require CSV import). The output is ready for Excel, Google Sheets, QuickBooks Online, Xero, FreeAgent, or Sage.
For year-long conversions, upload up to 12 BofA PDFs at once — pdftoxlsx consolidates them into one .xlsx with a Month column.
What the output looks like
Your Excel file includes standardized columns:
- Date — formatted as Excel dates
- Description — full transaction description (ACH, purchases, direct deposits, ATM withdrawals)
- Amount — negative for withdrawals, positive for deposits
- Balance — running balance after each transaction
- Currency — USD
Example rows: 2026-03-01 ONLINE TRANSFER FROM SAV REF#ABC123 +2,000.00 | 2026-03-03 PURCHASE AUTHORIZED WHOLE FOODS #1234 -87.42 | 2026-03-07 DIRECT DEPOSIT ACME CORP PAYROLL +3,100.00
Common edge cases for Bank of America statements
Two-column checking layout: BofA prints deposits and withdrawals in separate columns on the same page. Copy-paste from Adobe breaks here because column boundaries are lost. pdftoxlsx maps both columns into a single ledger with signed amounts.
Scanned statements: pdftoxlsx runs OCR on scanned BofA PDFs. Accuracy averages 99%+ at 200 DPI. BofA's older pre-2016 templates are denser — re-scan at 300 DPI if you see drift.
Password-protected PDFs: Enter the password at upload. pdftoxlsx does not store the password.
Credit card statements (Cash Rewards, Travel Rewards, Premium Rewards): Fully supported. Payments are positive, purchases negative. Reward summary on a separate sheet.
Business accounts (Business Advantage): Distinct template with wire transfers, ACH debits, and returned items captured with reference numbers.
Merrill Edge brokerage statements: Supported. Trades, dividends, and fees extracted into separate sheets.
Frequently asked questions
Is pdftoxlsx safe for Bank of America statements?
Yes. Files are encrypted in transit with TLS 1.3 and deleted within 24 hours. pdftoxlsx does not share data with third parties and is GDPR compliant.
How accurate is the conversion on BofA PDFs?
On native Bank of America PDFs, pdftoxlsx matches totals to the cent in 99.6% of cases across our benchmark of 200 real BofA statements. Scanned PDFs at 200+ DPI average 99.0%.
Why does copy-paste from Adobe break on BofA statements?
Bank of America's two-column layout causes Adobe's generic table extractor to merge or interleave columns. pdftoxlsx is specifically trained on BofA's column structure.
Can I convert BofA credit-card statements?
Yes. pdftoxlsx handles all BofA consumer and business credit cards with the same upload flow.
Can I import the output into QuickBooks?
Yes. Export as .csv and use QuickBooks' bank rules import.
Convert your Bank of America statement now — free
No signup. Files deleted in 24 hours. GDPR compliant.
Convert your Bank of America statement now — free →