Bank statements

Combine four bank statements into one clean spreadsheet (US)

Combine statements from four accounts into one clean spreadsheet: shared columns, an Account tag, own-account transfers and a SUMIFS summary in dollars.

Editorial illustration for Combine four bank statements into one clean spreadsheet (US)

To combine statements from several banks, give every export the same five columns, add a column that says which account each row came from, stack the rows into one sheet and sort by date. The part people skip is handling transfers between their own accounts, which otherwise show up twice and make spending look bigger than it was.

What do the four accounts look like?

Say you hold a checking account, a savings account, a credit card and a payment wallet. Each downloads a differently shaped file: one has a Debit and a Credit column, one has a single signed amount, one lists purchases as positive numbers, and one puts the date last. You are not going to make the banks agree, so you make the sheet agree.

Step 1: choose the master layout

Create a new workbook with one sheet called Master. These columns are enough for most households:

  • Date, in YYYY-MM-DD
  • Account, such as Checking, Savings, Card or Wallet
  • Description, exactly as the bank wrote it
  • Amount, spending negative and money in positive
  • Category, left empty for now

Step 2: how do I bring each statement into the same shape?

  1. Open each export on its own tab and keep the original untouched on a tab named Raw plus the account name.
  2. On a working copy, delete any summary lines above the headers and any totals below the last row.
  3. Rename the headers to Date, Description and Amount; add the Account column and fill it down with the account name.
  4. Convert amounts. For a Debit and Credit pair in D and E, use =E2-D2. For a card file where purchases are positive, use =-D2 so spending turns negative.
  5. Check one row from each account against the bank's screen before moving on.

Step 3: stack them and sort

Copy the working rows from each tab and paste them beneath one another on Master. Say the four tabs hold 86, 12, 54 and 31 rows. Master should end with 86 + 12 + 54 + 31 = 183 rows. Then select all the data and sort by Date. A count that does not match is the earliest warning that you missed rows.

How do I stop transfers counting twice?

Moving $500 from checking to savings creates a -500 line in one account and a +500 line in the other. Neither is spending or income. Add a column called Type and mark both lines Transfer. The same goes for paying a card bill: the $640 leaving checking and the $640 arriving on the card are one event, while the purchases on the card are what you actually spent.

DateAccountDescriptionAmountType
2026-03-02CheckingTransfer to savings-500.00Transfer
2026-03-02SavingsTransfer from checking500.00Transfer
2026-03-09CardGrocery store-86.40Spend
2026-03-15CheckingCard payment-640.00Transfer

A quick way to find transfers is to sort by the absolute amount and look for matching pairs within a day or two. Not every pair is a transfer, but most matches are worth a look.

Step 4: summarise with SUMIFS

With dates in column A, accounts in B, amounts in D and types in E, spending for March by account can be built like this, with the first day of the month in H1 and the first day of the next month in H2:

  • =SUMIFS($D$2:$D$500, $B$2:$B$500, "Card", $E$2:$E$500, "Spend", $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<"&$H$2)
  • Change "Card" to Checking, Savings or Wallet for the other lines.
  • Total spend across all four accounts: drop the account condition and keep the Type and date conditions.

The Type condition keeps transfers out of the total. Use real dates in column A for the comparison to work.

When a sheet stops being enough

Monthly copy and paste is fine at 183 rows but tiresome at 1,000. SpendixAI is a different route: you pick the account before uploading each PDF, CSV or Excel statement, so every transaction keeps its account in one categorised record. It is built around India and INR, so it suits readers who also track Indian accounts rather than dollar ones.

A monthly routine

  1. Download each statement the same day each month.
  2. Add the Account tag, convert signs and paste into Master.
  3. Check the row counts and the closing balances.
  4. Mark transfers.
  5. Refresh the SUMIFS summary.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports