To move a Bank of America statement to Excel, download the monthly PDF from Statements & Documents, convert it into rows, then merge the separate deposit, withdrawal, check and fee groups into one dated list with signed amounts. Finish by adding the groups and comparing each total with the account summary on page one.
Where Bank of America keeps the statement PDF
Bank of America keeps monthly statements in Online Banking under Statements & Documents. According to the bank's digital banking help page, you can view, print and download up to 18 months of statements at any time, and order copies going back up to seven years through Request statements.
That split matters for planning. If you need the last year for a budget or a loan file, the downloads are right there. If you need three or four years for a tax question or a dispute, start the request first and convert the recent months while you wait.
Saving the file so it converts well
Save the PDF itself rather than printing the page to a new PDF. The saved file keeps the bank's text layer, so each digit is stored as a character and not as a picture of one. Name each file by year and month, such as boa-checking-2026-03.pdf, so the order is obvious when you stitch a year together later.
The same help page suggests trying a different browser if a download fails. That is worth doing before you reach for a screenshot, because a screenshot throws away the text and turns the job into optical character recognition.
One account per file
If you hold checking and savings, download each account's statement on its own. Keeping one account per spreadsheet makes the balance check later in this post possible, since each account has its own opening and closing figures.
Bank of America activity export or statement PDF?
Convert the statement PDF when you need a record that ties to the bank's official figures. An activity download from the account screen can be handy for a quick look, but it reflects whatever date range you picked, may include items that later changed, and lacks the summary box that proves the month is complete.
Think about what the spreadsheet is for. A budget only needs rough categories, and either source works. A reconciliation, an accountant's request or a mortgage application needs the month as the bank closed it. Only the statement has an opening balance, a closing balance and totals per group that you can test your rows against.
If you do end up with a CSV from the bank, open it with care. Excel likes to reformat dates and long reference numbers when it opens a CSV by double-click. The guide on converting a CSV file to Excel without losing values explains the import route that keeps them intact.
Grouped sections on a Bank of America statement
A grouped statement lists transactions under headings by type instead of in one date-ordered stream. If your Bank of America PDF shows separate blocks for deposits, withdrawals, checks and service fees, each block is its own small table, and your job is to stack them into one list with a column recording which block each row came from.
Why grouping trips up a plain PDF copy
Copying a grouped page into Excel brings the block headings, the subtotal lines and the column titles along with the transactions. Each block may also repeat its column titles at the top of every page it spans. None of those rows is a transaction, yet each one can land in your sheet looking like one.
A tool that reads the layout, rather than the raw text order, can tell a heading from a row. The article on how a bank statement parser finds the transaction table explains that step if you want to know why some converters handle grouped pages better than others.
Steps to merge the groups
- Convert the PDF so each printed transaction becomes one row.
- Add a column called Section and fill it with the block name for every row, for example Deposits, Withdrawals, Checks or Fees.
- Delete the block headings and the repeated column titles.
- Keep each block's printed subtotal in a separate small table off to the side. You will use it in the tie-out step.
- Sort the whole list by date, then by Section, so same-day items stay in a predictable order.
The Section column is what saves you later. Once the list is sorted by date, it is the only record of where a row came from, and it lets you total each group with one SUMIFS.
Check lines and their numbers
Check payments often sit in a block of their own with a check number beside each amount. Keep that number in its own column, because it is the easiest way to match a check against your register. Watch for the gap markers some statements print when check numbers skip; they are notes, not rows.
Which sign does each Bank of America section get?
On the converted sheet, give every deposit or credit a positive amount and every withdrawal, check and fee a negative one. Grouped statements often print all amounts as plain positive numbers, because the heading already tells you the direction, so the sign has to come from the Section column once the headings are gone.
A worked example
The five lines below are examples with made-up payees and amounts. They show how rows from four groups become one signed list.
| Date | Description | Section | Printed amount | Signed amount |
|---|---|---|---|---|
| 03/02 | EXAMPLE PAYROLL DIR DEP | Deposits | 2,150.00 | 2,150.00 |
| 03/04 | GROCERY STORE DEBIT CARD | Withdrawals | 86.40 | -86.40 |
| 03/09 | Check 1042 | Checks | 600.00 | -600.00 |
| 03/15 | ONLINE TRANSFER FROM SAV | Deposits | 300.00 | 300.00 |
| 03/31 | MONTHLY MAINTENANCE FEE | Fees | 12.00 | -12.00 |
With the printed amount in column D and the section in column C, one formula fills the signed column:
=IF(C2="Deposits", D2, -D2)
If your statement has more than two directions, such as a separate block for returned items or refunds, list every money-in block inside the test with OR. Check the result by sorting on Section and scanning for any deposit with a minus sign.
Signed column or split columns
Some people prefer a Money in column and a Money out column instead of one signed amount. Both work. The single signed column makes running balances and pivot tables simpler, and it matches what most budgeting apps import. If you plan to compare this account with a card account, read how Capital One card and bank statements set their signs, since a card statement runs the other way.
Tying the Bank of America sheet to its account summary
The account summary near the top of the first page lists the beginning balance, a total for each group and the ending balance. Your sheet ties out when the total of each Section in your sheet equals the matching summary line, and the beginning balance plus all signed amounts equals the ending balance.
The tie-out table
Here is an example tie-out using the five sample rows above and an invented beginning balance of 1,000.00.
| Summary line (example) | From the statement | From your sheet | Difference |
|---|---|---|---|
| Beginning balance | 1,000.00 | 1,000.00 | 0.00 |
| Deposits and additions | 2,450.00 | 2,450.00 | 0.00 |
| Withdrawals and subtractions | 86.40 | 86.40 | 0.00 |
| Checks | 600.00 | 600.00 | 0.00 |
| Service fees | 12.00 | 12.00 | 0.00 |
| Ending balance | 2,751.60 | 2,751.60 | 0.00 |
The sheet column comes from formulas such as =SUMIFS(D:D, C:C, "Checks") on the printed amounts, and =1000+SUM(E:E) for the ending balance on the signed ones.
Reading a difference
A difference in one group tells you where to look. If Checks is short by 145.00, a check row was dropped or misread, and you only need to scan that block. If every group ties but the ending balance does not, a sign is wrong somewhere: a deposit marked negative throws the total off by twice its amount, so halve the gap and search for that figure.
Grouped statements are generous here. Because each block has its own subtotal, a missing line can be traced to one block in seconds instead of hunting through a whole month.
Bank of America statements that need extra care
Some Bank of America PDFs are harder sources than a single checking statement. Combined statements that cover several linked accounts, statements with check images, and requested older copies each need a small change in approach before the tie-out works.
Several accounts in one document
If one PDF carries more than one account, each account has its own summary and its own groups. Split the rows by account before you sign or total anything, either into separate sheets or with an Account column. Mixing them makes every tie-out fail even when each row is right.
Pages of check images
Image pages show pictures of paid checks. They hold no new transactions, because each check already appears as a line in the Checks group. Skip those pages when converting, or delete what comes out of them, so a misread image does not add a phantom row.
Requested older statements
Older copies that you order may arrive in a slightly different layout from this year's files. Run the tie-out on each month rather than trusting that a method that worked for March will work for a statement from four years ago.
Converting the file
Once the PDF is saved, a statement converter can do the row work for you. FastBankConvert is getting ready to open; it is meant to read the statement's layout, put dates, descriptions, amounts and balances in their own columns, and warn you before download when the figures do not add up. Join through Get started to hear when trial conversions begin. If you also bank elsewhere, the walkthrough for Wells Fargo statements in Excel walks through the same job for that bank's layout.