BankStatementToExcel.com
Bank walkthroughs

Convert a Bank of America statement to Excel

Check deposit and withdrawal sections, combined accounts, and the final workbook before importing.

Updated 2 min read

Begin with the original statement PDF for the Bank of America account and period you need. If a transaction CSV is available and suits your task, use it directly instead of converting a PDF.

Get the right source document

Locate statements in the official banking app or Online Banking. Confirm the document covers the correct account and all pages are present. Consult Bank of America's online banking guidance for account-specific access questions.

Keep a bank-downloaded PDF in its original form when possible. Making screenshots or printing an existing PDF to a new file can change its layout or text quality.

Convert and review

  1. Open the Bank of America converter.
  2. Upload the unlocked PDF and start conversion.
  3. Download the workbook and inspect the Summary and Transactions sheets.
  4. Compare the result with the PDF before importing it elsewhere.

The standard transaction columns are Date, Description, Debit, Credit, and Balance. Missing source information may leave cells blank.

Check deposits and withdrawals separately

Where the statement groups deposits and withdrawals into different sections, compare each section total with the matching spreadsheet column. Do not assume the output order alone proves that every transaction was captured.

Watch for fees, returned payments, and continuation pages. Check the first and last entry in each section, then compare overall totals with the original document.

Handle combined accounts carefully

A combined PDF can contain more than one balance and account number. Our standard export does not provide a separate worksheet per account. Use separate account PDFs where possible, and never combine balances from different accounts to force a reconciliation.

For your next step, compare CSV and QBO, or read the Xero import guide.

Published . Updated October 7, 2026 to reflect the current converter and the provider guidance linked in this article.

Prepared with AI assistance and checked against the application's export formats. These are product instructions, not a substitute for checking your records. Tell us about a correction.

Ready to work with your statement?

Convert a PDF, then check the result with your original.

Open converter