Bank of America lets you download account activity as a CSV file from bankofamerica.com. Here are the steps, and the columns the file carries.
Download the file
- 1
Sign in at bankofamerica.com and open the account.
- 2
Select Download near the top of the transaction list.
- 3
Choose a date range and the Microsoft Excel format file type, which saves a .csv file.
- 4
Select Download.
What the file carries
Columns: Date, Description, Amount, Running Bal..
Sheetful reads Date as the date, Description as the description and Amount as the amount.
The file opens with a few summary lines (beginning balance, total credits, total debits) above the row that starts with Date.
Sheetful skips those summary lines and reads the file as downloaded.
Money out is a negative Amount.
See your file on /try
The preview shows up to 100 rows, newest first, with the name and category Sheetful gives each one.
On /try the file is read in your browser tab, with no account.
Try it with your Bank of America CSVTo sync a bank account into a sheet instead, see the Google Sheets sync guide or the Microsoft Excel sync guide.