Spreadsheets

Append two bank accounts into one table with an Account column

Append a savings and a current account statement in Power Query, add an Account column to each first, and check that column names match before combining.

Editorial illustration for Append two bank accounts into one table with an Account column

Load each account's statement as its own query, add a custom column called Account with a fixed label such as Savings or Current, then use Home, Append Queries as New to stack them. The label added before the append is what lets one combined table still be filtered by account.

Why add the Account column before appending?

Once two statements are stacked, nothing in the rows says which account a payment came from. Two identical-looking ₹500 debits could belong to different accounts, and a balance column that makes sense for one account is meaningless when mixed with another. Tag first, append second, and you never need to guess.

How do you build it?

  1. Clean each statement as its own query: promote headers, set types and remove footers. Name them clearly, for example Savings and Current.
  2. In the Savings query choose Add Column, Custom Column, name it Account, and type "Savings" with the quotation marks. Repeat in Current with "Current".
  3. Home, Append Queries, Append Queries as New. Choose Two tables, select Savings and Current, and press OK.
  4. Name the new query All Accounts, and Close & Load To a table.

The same append in code is =Table.Combine({Savings, Current}); for three accounts, add a third name inside the braces. Appending is not merging: appending stacks rows, while merging joins columns by a matching key, which is not what you want here.

Do the column names have to match?

Yes, exactly. Power Query lines columns up by name, not by position. If one table calls it Narration and the other Description, the result has both columns, with nulls where a row has no value. Trailing spaces and capital letters also count, so Date and date are different columns.

CheckHowWhat to expect
Same column namesOpen each query and compare the headings by eyeIdentical spelling, spacing and capitals
Column count after appendLook at the All Accounts previewThe number of columns equals one table, plus Account
Rows add upGroup by Account and Count RowsEach count equals that account's own rows
Types agreeCheck the icon beside each headingSame type in both queries

What if one account uses a different layout?

Rename columns in the query for that account until both match. If one statement has separate Debit and Credit columns and the other has a single Amount plus a Dr or Cr marker, convert one to the other's shape before appending. For example, make a Debit column with an if statement on the marker, so that the combined table has a single consistent meaning for each column. Credit card statements add another wrinkle: some show purchases as positive numbers, so check the sign convention on each before you trust totals.

How do you check the result?

Say Savings has 120 rows and Current has 85, invented numbers. The combined table should have 205, because 120 plus 85 is 205. Group by Account, count rows and compare. Then filter Account to each label and confirm the first and last dates match the files you loaded. A difference means one query is not fully loading, or a filter step inside it removed rows by mistake.

Capitals and spacing matter, so make one more check after appending: compare the column names in the result with the headings you expect. Any heading you did not expect is a sign that one of the queries uses a slightly different spelling, and the fix is to rename it in that query, not in the combined one.

Next steps

  • Add a pivot table with Account in Columns and Category in Rows.
  • Create a slicer on Account for quick views.
  • Add a third query for a credit card, applying the same check.

Within SpendixAI, you choose the account (bank, card or wallet) before importing, and each transaction keeps its account, which is the same idea built in.

SPENDIXAI JOURNAL

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

Explore your reports