Getting started

Combine multiple bank statements into one spreadsheet

Combine multiple bank statements into one spreadsheet: standardise columns, stack the CSVs, tag the account and remove duplicate transfers, in dollars.

Editorial illustration for Combine multiple bank statements into one spreadsheet

To combine multiple bank statements into one spreadsheet, export each account as CSV, rename the columns so they match, add an Account column, paste or stack the rows into one sheet, and sort by date. Then check the row count and remove transfers that appear on both sides.

Step 1: export, do not retype

Download each account's transactions as CSV for the same date range, for example 1 October to 31 October, so the pieces line up. Open each file and write down its row count and the closing total of debits and credits. You will compare these with the merged sheet later.

Step 2: make the columns match

Each file will arrive in its own shape. Some give Debit and Credit columns, others one Amount column, some show purchases as positive numbers. Pick one master layout and convert everything to it.

Master columnRuleExample
DateOne format, for example YYYY-MM-DD2026-10-14
AccountShort name you type once per fileChecking
DescriptionText as it appearsGrocery market
AmountMoney out negative, money in positive-84.20

For two-column files, a helper column does the merge: =C2-D2 gives credits minus debits if C holds credits and D holds debits. Fill it down, then copy and paste as values into the Amount column.

How do I stack the files into one sheet?

  • Copy and paste: paste file two under file one, then file three under that. Quick, and fine for a handful of files.
  • Google Sheets: in a blank sheet, =SORT({Checking!A2:D; Savings!A2:D; Card!A2:D}, 1, TRUE) stacks the three ranges and sorts by the first column. The semicolon inside the braces stacks vertically.
  • Excel with a recent Microsoft 365 version: =SORT(VSTACK(Checking!A2:D200, Savings!A2:D200, Card!A2:D200), 1, 1) does the same. Older Excel does not have VSTACK, so paste instead.
  • Blank rows from an oversized range sort to the end or show as zeros; filter them out.

A worked example with invented rows

Say checking has 38 rows, savings has 4 and the card has 21. The merged sheet should have 38 + 4 + 21 = 63 rows. Count them with =COUNTA(B2:B500) on the Description column. If you get 62, a header line or a row was lost; if 64, a header line was pasted in the middle.

Now handle the transfer. Checking shows a card payment of -450.00. The card file shows a payment received of +450.00. In spending reports both look like activity, though together they net to zero. Add a Category column, label both rows Transfer, and exclude that label from spending totals.

What about overlapping dates and duplicates?

If your October export runs to 31 October and your November export starts on 31 October, that day is in both. Sort by date, then use a helper =COUNTIFS($A$2:$A$500, A2, $C$2:$C$500, C2, $D$2:$D$500, D2) to count rows with the same date, description and amount. A result of 2 deserves a look, though two identical coffees on one day can be genuine.

What are the limits?

  • Date formats vary: US-style month first versus day first can silently scramble sorting; test with a date like 03/04 you know.
  • Descriptions rarely match across banks, so categories need a manual pass or your own rules.
  • A merged sheet is a snapshot; next month you repeat the steps.

This guide covers the method only, using dollars; rules and bank features differ, so check your own bank's export options. SpendixAI is built around India and INR, so it is not designed for dollar accounts.

SPENDIXAI JOURNAL

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

Explore your reports