Four statements become one workbook when you load each into Power Query and append them, with a column naming the source account. After that, adding next month is a refresh rather than a rebuild. If you do not use Excel, the same idea works with copy and paste into one sheet, as long as every file has the same columns first.
What should I prepare before touching any formula?
- A folder called Statements with one subfolder per account.
- File names that start with the year and month, such as 2026-03 chequing.csv.
- One master workbook, kept separate from the downloads.
- A note of each account's opening balance for the first month.
Say your four sources are a chequing account, a savings account, a credit card and a line of credit. Each has different column names, so keep a small mapping table somewhere: for each account, which of its columns means date, description and amount.
| Account | Date column | Description column | Amount rule |
|---|---|---|---|
| Chequing | Posted date | Details | Debit and Credit, so credit minus debit |
| Savings | Date | Memo | Signed already |
| Card | Transaction date | Merchant | Purchases positive, so multiply by -1 |
| Line of credit | Date | Details | Withdrawals positive, so multiply by -1 |
How does the Power Query route work?
- In Excel, choose Data, Get Data, From File, From Folder, and point to the chequing subfolder. Combine and load the files.
- Rename the columns to Date, Description and Amount using the table above.
- Add a custom column called Account with the text Chequing.
- If the amount needs flipping, add a custom column that multiplies it by -1.
- Repeat for the other three accounts as separate queries.
- Choose Data, Get Data, Combine Queries, Append, and select all four.
- Load the result to a sheet called Master and sort by date.
When a new month's file lands in a subfolder, Data, Refresh All pulls it in. That is the whole point of the folder method: no pasting.
How can I find duplicates when the periods overlap?
If you download the 1st to the 31st and later the 15th to the 15th, the lines from the middle of the month appear twice. In Master, add a helper column that joins the key parts, such as =TEXT(A2,"yyyy-mm-dd")&"|"&B2&"|"&C2&"|"&D2, and then count it with =COUNTIF($F$2:$F$800, F2). Any row with a count above one is a candidate. Hypothetically, a C$14.20 lunch charged twice on the same day by the same merchant can be genuine, so look at the descriptions or reference numbers before deleting.
How do I confirm the combined sheet is right?
Use an account-by-account reconciliation. Say the chequing account opens March at C$2,310.00, receives C$4,200.00 and pays out C$3,785.40. Then 2310 + 4200 - 3785.40 = 2,724.60 should equal the closing balance. Do the same for each account. If one fails, the difference points to a missing or doubled row.
Where do transfers and card payments go?
Mark them with a Type column, using Transfer, not Spend. A C$900 card payment from chequing is the settlement of purchases that already sit on the card account, so counting both would inflate spending by C$900. A pivot table on Master, with Type in the filter and Month in the rows, then gives you honest monthly totals.
SpendixAI takes a different route: pick the account, upload a PDF, CSV or Excel statement, review the rows and everything stays in one categorised record. It is built around India and INR, so it suits readers who also hold Indian accounts, not Canadian dollar ones.
Monthly checklist
- Save each download into its folder.
- Refresh the workbook.
- Compare each account's closing balance.
- Mark new transfers.
- Look at the duplicate flags.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
