Bank of America Statement to Excel, Step by Step

TL;DR: Download your Bank of America statements as PDFs, convert them with a tool that understands statement layouts, and check that the beginning balance plus deposits minus withdrawals equals the ending balance. Use the online activity download only when the period is recent and you don't need the official document.

Bank of America statements are well organized, which makes them easier to convert than some. But "easier" isn't the same as "copy and paste works." Deposits, withdrawals, checks and service fees sit in separate sections, often across several pages, and the job of getting them into a single chronological sheet is where most people get stuck.

We'll walk through the process we use, from getting the files to producing an Excel workbook you can hand to an accountant.

Two sources of data

Bank of America, like its peers, offers:

• Statements: monthly PDFs with a summary box (beginning balance, deposits and other additions, withdrawals and other subtractions, checks, service fees, ending balance) followed by itemized sections.
• Transaction downloads: account activity you can export from online banking in a few formats, including spreadsheet-friendly ones, for a limited lookback.

The summary box on the statement is genuinely useful for verification. It gives you section totals you can check your conversion against, which is better than just an ending balance.

Getting the statements

General steps (the exact labels can change):

1. Sign in to Bank of America online banking or the mobile app.
2. Choose the account.
3. Look for Statements & Documents.
4. Select the period and download the PDF.

Bank of America keeps years of statements online for most accounts. If you need something older, the bank can order copies.

Save each file with a consistent name, and keep checking, savings and credit card statements in separate folders. It sounds fussy. It saves real time when you're working through a year.

When the activity download is enough

If you only need recent transactions for budgeting or a quick analysis, the activity download is fine:

1. Open the account activity.
2. Look for a download option.
3. Pick a date range and a spreadsheet format such as CSV or Microsoft Excel-compatible.
4. Open in Excel.

Remember the limits: there's no opening balance row, pending items may appear, and it covers only a limited period. For anything formal, convert the statements.

Converting the PDF

Here's the process with SheetStatement:

1. Upload the Bank of America PDF (or several).
2. The converter reads each section, deposits, withdrawals, checks and fees, and merges them into one list ordered by date.
3. It recalculates the balance and compares it to the beginning and ending balances on the statement.
4. Any mismatch is flagged in the review table so you can fix it before exporting.
5. Export to Excel.

The Bank of America bank page lists the statement types we've tested, including personal checking, savings and business accounts.

Check against the summary box

Because Bank of America prints section totals in the account summary, you can verify more than just the ending balance. We build a small check table next to the data:

Check	Statement says	Our sheet	Match?
Deposits and other additions	(from summary)	=SUMIFS(Amount,Amount,">0")
Withdrawals and other subtractions	(from summary)	sum of non-check debits
Checks	(from summary)	sum of rows where description begins "Check"
Service fees	(from summary)	sum of fee rows
Ending balance	(from summary)	beginning + all amounts

When everything matches, you're done. When one section is off, you know exactly where to look. That's much faster than hunting through 200 rows for a difference.

For a more general walkthrough, see our bank reconciliation in Excel guide.

Cleanup that makes the workbook useful

One table, real dates, signed amounts

Convert the range to an Excel Table (Ctrl+T). Make sure the date column contains real dates, not text. Add a signed Amount column if your export has separate debit and credit columns: =[@Credit]-[@Debit].

Shorten the descriptions

Bank of America descriptions often include a long processor string with IDs and dates. Keep the original column, and add a "Payee" column with a shortened version. A simple first pass is =TRIM(LEFT([@Description],30)). Then correct the frequent ones by hand once; your categorization rules will reuse them.

Categorize

Add a Category column. For recurring payees, a lookup table works well: one sheet with keywords and categories, then a formula that finds the first matching keyword. We cover a few approaches in Excel formulas for categorizing transactions.

Summarize with a pivot table

Insert a pivot table with Category in rows, month in columns and Amount as values. In under a minute you have a monthly spending or expense report. For tax prep, this is often exactly what an accountant wants alongside the statements.

Converting a full year

If you're doing a year (or several), a few additional habits help:

1. Convert each month and verify it individually.
2. Check continuity: each month's beginning balance must equal the previous month's ending balance.
3. Combine into one table with a "Statement" column holding the period.
4. Keep the monthly PDFs alongside the workbook. An auditor or lender may ask for them.

If the year spans multiple accounts, tag internal transfers. A transfer from checking to savings is neither income nor expense, and counting it twice is one of the most common errors we see in DIY bookkeeping.

Bank of America credit card statements

Credit card statements follow a different pattern: payments and credits, purchases and adjustments, fees, and interest charged, with a new balance at the end. In accounting terms, the card is a liability, so a purchase increases what you owe and a payment decreases it.

When converting, make sure:

• Payments appear with the opposite sign of purchases.
• Interest and fees are separate rows, not folded into purchases.
• The previous balance plus purchases, fees and interest, minus payments and credits, equals the new balance.

Our credit card statement converter handles these, and the same verification idea applies.

Sending the data to accounting software

If Excel is only an intermediate step, export to the target format directly:

• QuickBooks: a QBO file imports like a bank feed. See bank statement to QuickBooks.
• Xero: use a Xero-ready CSV. See bank statement to Xero.
• Others: a clean CSV usually works. Our CSV format guide explains the common layouts.

Troubleshooting

The total for checks doesn't match. Check images pages sometimes repeat check numbers and amounts. If your converter picked those up as transactions, you'll have duplicates. Delete the rows from the image pages.

A deposit appears twice. Look for a deposit that appears both in the itemized list and in a daily balance or summary table. Only the itemized one is a transaction.

Year is wrong in January. Statements that cross a year boundary often print dates without the year. Confirm the dates near the start and end of the period.

Descriptions contain page headers. Some tools merge "Page 3 of 6" or the account number line into a description. Filter descriptions for "Page" and clean them up.

The balance check fails by a small amount. Often a rounding or a misread digit, such as 8 read as 3 on a scan. Compare the flagged row with the PDF.

A quick worked example

Here's how the section checks play out on a typical (invented) month. The summary box shows:

• Beginning balance: 8,940.12
• Deposits and other additions: 12,300.00
• Withdrawals and other subtractions: 9,812.47
• Checks: 2,150.00
• Service fees: 15.00
• Ending balance: 9,262.65

After converting, we check each section. Deposits match. Checks match. Service fees match. Withdrawals come to 9,752.47, which is 60.00 less than the statement says.

A 60.00 gap on withdrawals is a strong clue. We filter the withdrawal rows for amounts of exactly 60.00 and find one ATM withdrawal. Then we look at the PDF and find a second 60.00 ATM withdrawal on the same day, at the same machine. Our converter merged them because they looked identical; actually they were two separate withdrawals. We add the second row and everything balances.

This is a real pattern worth knowing: identical transactions on the same day are legitimate. Two coffees, two ATM withdrawals, two identical subscription charges. Any cleanup step that removes "duplicates" automatically will break your statement. Only remove duplicates you can prove came from the conversion, such as rows read off a check image page.

Choosing columns for the final workbook

People often ask what columns the "right" spreadsheet has. There's no single answer, but this set covers bookkeeping, tax prep and loan files:

Column	Why it's there
Date	Posting date from the statement
Description	Original text, untouched, for audit trail
Payee	Shortened, cleaned name for grouping
Amount	Signed: positive in, negative out
Balance	Running balance where the statement shows it
Category	Your chart of accounts or a simple list
Statement	Period or file name the row came from
Notes	Anything you had to fix or explain

Keeping the original description alongside a cleaned payee is the important bit. Clean names make reports readable. Original text proves where each number came from.

Working on statements someone else sent you

Bookkeepers, tax preparers and attorneys often receive statements by email or in a shared folder rather than downloading them. A few things to check first:

1. Is the set complete? List the statement periods you received and look for gaps. Twelve months with August missing is common.
2. Are they all the same account? Check the last four digits on each statement. Clients sometimes mix a personal account into a business folder.
3. Are they originals or scans? Downloaded PDFs convert most accurately. Scanned printouts work, but run the balance check carefully.
4. Are any password protected? Ask for the password or an unprotected copy before you start.

Sorting this out before converting means you don't discover in month nine that you've been working on the wrong account.

Excel versus CSV for the final deliverable

If a person is going to read and work in the file, give them Excel (.xlsx). It keeps number formats, dates, multiple sheets and the summary pivot. If a system is going to import it, give it CSV, or better, the system's native import format. We usually deliver both: an Excel workbook for the human and a CSV or QBO file for the software.

Using the workbook for a loan, tax return or audit

Different readers want different things from the same data, so it helps to know who the workbook is for before you polish it.

Your accountant or tax preparer wants totals by category for the year, a clear separation of business and personal items, and the ability to trace any total back to individual rows. A pivot table plus the underlying data sheet is ideal. Mark anything you're unsure about in the Notes column rather than guessing a category; it's far easier for them to answer a flagged question than to discover a wrong guess.

A lender usually wants the original PDF statements, not your spreadsheet. The workbook is still useful to you, though: it lets you spot large deposits the underwriter will ask about, recurring payments that count as debts, and any overdrafts. Having an explanation ready for each large deposit speeds things up. Our guide on bank statements for a mortgage application covers this.

An auditor wants completeness and an audit trail. Keep the Statement column populated on every row, keep the original descriptions, and keep the PDFs in the same folder. If you corrected something, say so in Notes. Auditors are far more comfortable with documented corrections than with numbers that are mysteriously perfect.

You probably want a monthly view of where money goes. A pivot with months across the top and categories down the side, plus a simple chart, is enough. Resist the urge to build a forty-tab dashboard; the one you'll actually maintain is the simple one.

How long should this take?

With a decent converter, a typical single-account monthly statement takes a few minutes end to end: upload, review the check, export, and paste into your template. A year of statements for one account is usually an hour or so including categorization, assuming the statements are digital PDFs. Scans and multiple accounts with lots of transfers take longer, mostly in the review step. If you're spending much more time than that, the bottleneck is usually categorization rules, and that's worth fixing once rather than redoing every month.

Keeping the data safe

Statements contain personal data. Use a converter that encrypts files and deletes them after processing; our security page explains our approach. Store the final workbook somewhere access-controlled, not in a shared folder with open links.

Our take

Bank of America's statement layout is friendly to verification because of that summary box, so use it. Convert, check each section total, then clean. The result is a workbook you can stand behind, not just a list of numbers that looks plausible.

Troubleshooting Bank of America conversions

Deposits and withdrawals are in separate sections. Statements commonly group deposits, withdrawals, checks and fees in separate sections. Combine them into one table sorted by date, with a signed amount.

Checks listed without payees. Add payees from your records in a notes column.

Totals don't match. Make sure every section was captured, including fees and checks. A section that runs onto a second page is the most common thing to miss. Compare the count of transactions per section with the statement's own section totals, which many statements print at the end of each section.

A second worked example

A small business owner needed a year of statements in Excel for a loan application. Converting twelve statements, he checked that each statement's sections added up to the change in balance, combined them, and tagged deposits by customer. The lender's analyst got a clean deposit history instead of 60 pages of PDFs.

FAQ

Can I download Bank of America statements in Excel format?

Statements come as PDFs. Online banking lets you download recent activity in spreadsheet-friendly formats, but the official statement must be converted to get it into Excel.

How do I convert multiple Bank of America statements at once?

Upload several PDFs to a converter that supports batch processing, verify each month's balances, then combine them into one table with a column for the statement period.

Why don't my converted checks match the statement total?

Check image pages can create duplicate rows if a tool reads them as transactions. Remove those rows and compare again with the checks total in the account summary.

Does this work for Bank of America business accounts?

Yes. Business statements follow a similar structure with summary totals and itemized sections, sometimes with a daily balance table. Convert and verify the same way.

Can I convert a Bank of America credit card statement to Excel?

Yes. Make sure payments and purchases carry opposite signs and that the previous balance plus charges minus payments equals the new balance.

Is the activity download the same as a statement?

No. The download lists transactions for a recent window; the statement is the official monthly record with beginning and ending balances that third parties typically require.