Bank statements

Combining statements from four banks into one clean sheet

Gig workers paid into several accounts can merge bank statements into one clean sheet with a standard column layout, an account tag and no double-counting.

Editorial illustration for Combining statements from four banks into one clean sheet

To combine statements from several banks, force every one of them into the same five columns (date, account, narration, money in, money out), paste them under each other in one sheet, add an account label to each row, and sort by date. The hard part is not the pasting; it is making the columns mean the same thing, and not counting your own transfers twice.

Why do gig workers end up with four statements?

Platforms pay into whichever account you registered, a delivery wallet cashes out to a second bank, the savings account is a third, and the credit card that buys your fuel and phone data is a fourth. None of the four exports the same way. One gives debit and credit in separate columns, another uses a single signed amount, another prints the date as a day-month-year text string. Pasting them straight together produces a sheet that looks complete and adds up wrongly.

What layout should the combined sheet use?

ColumnHoldsNote
A: Datea real date, not textconvert before merging
B: Accountbank or card nameadd this yourself
C: Narrationwhat the bank printedkeep it unedited
D: Money incredits as positive numbersblank when nothing came in
E: Money outdebits as positive numbersblank when nothing went out

Keeping money in and out separate avoids the sign confusion that comes from mixing statements where debits are negative with statements where they are positive.

How do you merge them step by step?

  1. Download each statement as Excel or CSV for the same date range, and keep the PDFs as a backup.
  2. Open each file and delete the header block, the opening balance line and the totals at the bottom so only transaction rows remain.
  3. Rearrange the columns of each file into the layout above. If a file has one signed amount column, split it with =IF(F2<0,-F2,0) for money out and =IF(F2>0,F2,0) for money in.
  4. Type the account name once in column B and fill it down for every row of that file.
  5. Paste all four blocks into one sheet, one under the other, and sort by column A.
  6. Check each block's totals against the bank's own closing and opening balances before trusting the merge.

How do you avoid counting your own money twice?

This is where gig income gets overstated. Suppose a delivery platform pays ₹14,200 into account one, and you move ₹12,000 of it to your savings account. The first statement shows ₹12,000 going out and the second shows ₹12,000 coming in. If you total all credits across the sheet you will count ₹14,200 plus ₹12,000, which is ₹26,200, when you really earned ₹14,200. Add a column F called Type and mark such pairs as Transfer, then total income using only the rows that are not Transfer.

A simple way to flag them is to filter column D and column E for equal amounts on the same or next day across different accounts, then confirm by eye.

When does the spreadsheet stop being enough?

A four-bank sheet works until the month you have to repeat it, and then repeat it again. SpendixAI is one place to import per account instead: you pick the account, upload the PDF, CSV or Excel statement, review the rows and save. Every transaction keeps its account, categories apply across all of them, and a report can show them together. There is no bank connection, so uploads remain a monthly task, but the merging and de-duplicating described above stops being manual work. Possible duplicate imports are flagged too.

A monthly routine for statements

  • Download all four statements within the first three days of the month.
  • Merge, tag the account and mark the transfers.
  • Reconcile each block with the bank's closing balance.
  • Save the finished sheet with the month in the file name.
SPENDIXAI JOURNAL

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

Explore your reports