Open each monthly CSV, remove its header and account-detail rows, add a Month label, and paste the rows under the previous month on one master sheet. Then prove nothing went missing by comparing each file's row count with the count of that month's label in the master. It is slow, but it teaches you what Power Query later automates.
How do you set up the master sheet?
- Create a new workbook with a sheet called Master.
- Type the headings in row 1: Date, Narration, Debit, Credit, Balance, Month. The Month column is yours; the statements do not have it.
- Decide the format of the Month label once, for example 2025-04 for April 2025, and stick to it. For an April to March year, the twelve labels run from 2025-04 to 2026-03.
How do you paste month by month?
For each file: open it, delete the rows above the header and any footer lines, then select only the data rows (not the heading) and copy. In Master, click a cell in column A, press Ctrl+Down to reach the last filled row, then Down once more to land on the first empty one. Paste, and fill the Month label down the new rows. Press Ctrl+Z if you pasted over data, and always look at the row you landed on before pasting.
Paste values only when the source has formulas, and always paste at the left edge of the master, never in the middle. If one CSV has a different column order from the previous month, fix the order in that file before copying. Pasting a misordered month is the commonest way for a Debit column to quietly fill with credits.
How do you prove no rows were lost?
Build a small log on a second sheet with one row per file:
| Month | Rows in file | Rows in Master | Difference |
|---|---|---|---|
| 2025-04 | 142 | =COUNTIF(Master!$F$2:$F$5000,A2) | =B2-C2 |
| 2025-05 | 131 | =COUNTIF(Master!$F$2:$F$5000,A3) | =B3-C3 |
| 2025-06 | 158 | =COUNTIF(Master!$F$2:$F$5000,A4) | =B4-C4 |
Rows in file is what you read from the file before copying: select the date column and read Count in the status bar. The 142, 131 and 158 above are invented. Every Difference should be 0. A non-zero figure points to exactly the month you must redo. After twelve files, a total check is a one-liner: =SUM(B2:B13)-COUNTA(Master!$A$2:$A$5000) should return 0.
What else should you check on the combined sheet?
- The earliest and latest date in each month: =MINIFS(Master!$A$2:$A$5000,Master!$F$2:$F$5000,"2025-04") and the same with MAXIFS. They should sit inside April. Both functions need Excel 2019 or later.
- That each month's last balance matches the next month's first balance, if your files carry a balance column.
- That no month is pasted twice: the log would show Rows in Master at double the file's count.
Is this approach worth keeping?
For twelve files once a year, yes. It needs no setup, and you can see every step. For a routine that repeats monthly, or with more than a couple of accounts, the effort grows, and a query that reads a whole folder saves time. Think of the paste method as your baseline: if a later Power Query result disagrees with this log, trust the log until you find why.
Finish with
- Save the master as a new file, with the financial year in its name.
- Convert the data to a Table with Ctrl+T.
- Keep the original CSVs in one folder, unedited.
SpendixAI is another route: you upload statements as batches and the import history shows a status for each file, instead of you maintaining a log.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

