Four statements merge in Excel 365 by turning each export into a table with identical column names, then combining them with the VSTACK function or Power Query's Append. Before either, fix the number format, since many European exports write amounts with a decimal comma and a semicolon between columns.
Start with the awkward parts: separators and decimal commas
If a file opens as one long column, use Data, From Text or CSV and pick the semicolon as delimiter. If amounts such as 1.204,50 arrive as text, convert them before combining. A reliable helper is =VALUE(SUBSTITUTE(SUBSTITUTE(D2,".",""),",",".")), which drops the thousands full stop and turns the comma into a full stop. If your Excel is already set to a comma-decimal region, VALUE may read the original directly, so test on one cell.
Do all four accounts need the same layout?
Yes, before you stack them. Use Date, Account, Description and Amount. Make each one an Excel table with Insert, Table, and name them tblCurrent, tblSavings, tblCard and tblShared in the Table Design tab. Named tables expand automatically when you paste next month's rows beneath them.
Option A: VSTACK
VSTACK exists only in Microsoft 365 and recent Excel versions. On a Master sheet, in A2, enter:
- =VSTACK(tblCurrent, tblSavings, tblCard, tblShared)
- Sort it with =SORT(VSTACK(tblCurrent, tblSavings, tblCard, tblShared), 1, 1) to get the oldest first.
- If VSTACK shows a name error, your Excel version does not have it; use option B.
Option B: Power Query Append
- Select a cell in the first table and choose Data, From Table or Range.
- In the Power Query window, choose Home, Close and Load To, and pick Only Create Connection. Repeat for the other three tables.
- Go to Data, Get Data, Combine Queries, Append, and add all four queries.
- Check that the data types are Date for the first column and Decimal Number for Amount.
- Close and Load. When you paste new rows, use Data, Refresh All.
Power Query is stricter about types. If one table has a text amount, the whole column may show errors, and that is useful: it tells you which file still needs converting.
How do I count own-account transfers only once?
Say you move €300 from the current account to savings and later pay €412.35 on the card. In Master those are minus and plus pairs and a card settlement. Add a Type column and mark them Transfer, then leave them out of spending totals. For a monthly spending figure with dates in A, accounts in B, amounts in D, types in E, the first of the month in H1 and the first of the next in H2:
- =SUMIFS($D$2:$D$800, $E$2:$E$800, "Spend", $A$2:$A$800, ">="&$H$1, $A$2:$A$800, "<"&$H$2)
| Check | What to compare | What a mismatch means |
|---|---|---|
| Row count | Sum of the four tables against Master | Rows lost or double-pasted |
| Balance | Opening balance plus sum of amounts against closing balance | A missing or duplicated line, often equal to its amount |
| Dates | Earliest and latest date per account | A statement period gap |
What about overlapping periods?
If one export runs from the 25th to the 25th and another covers calendar months, lines near the border can appear in both after a re-download. Sort by Account, then Date, then Amount; identical lines next to each other on the same day deserve a look. A genuine repeat, like two identical coffees, is possible, so check the descriptions or a reference column before deleting.
When maintaining the workbook becomes a chore, SpendixAI offers an alternative: pick an account, upload a PDF, CSV or Excel statement, review rows and keep everything in one categorised record. It is built around India and INR rather than euro accounts, so treat it as relevant only for readers who also hold Indian ones.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


