A spend-by-account report puts accounts down the side and categories across the top, so you can see which account pays for what. The point is to find categories that are paid from three different accounts and give each a home account, which makes budgets and statement checks far simpler.
A sample household with three accounts
Say the household has a salary account, a credit card and a wallet or UPI-linked account, and last month's numbers look like this (all made up).
| Category | Salary account | Credit card | Wallet | Total |
|---|---|---|---|---|
| Rent | ₹18,000 | ₹0 | ₹0 | ₹18,000 |
| Groceries | ₹3,000 | ₹7,500 | ₹2,500 | ₹13,000 |
| Fuel | ₹0 | ₹4,000 | ₹0 | ₹4,000 |
| Dining out | ₹1,500 | ₹5,000 | ₹1,500 | ₹8,000 |
| Medical | ₹2,000 | ₹1,000 | ₹500 | ₹3,500 |
| Total | ₹24,500 | ₹17,500 | ₹4,500 | ₹46,500 |
Rent and fuel each have one home. Groceries, dining out and medical are spread over all three accounts, so a groceries total means adding three places.
What should you look for?
- Categories paid from three accounts: a sign nobody decided where they should be paid from.
- An account that mixes bills and daily spending, which makes the balance hard to read.
- A card carrying essential spending you would not want to carry if you could not pay the bill in full.
- A small account with a few random categories that could be closed or reduced.
How do you build the report?
Your list needs the account on every row. In a sheet, put the account in column B and category in D, then a pivot table with categories in rows, accounts in columns and the sum of the amount in values. Without a pivot, one cell is =SUMIFS($C$2:$C$1000,$B$2:$B$1000,F$1,$D$2:$D$1000,$E2), with account names in F1 across and categories in E2 down.
Giving each category a home
Pick one account per category, and write it next to the budget line. For example, groceries and fuel on the credit card if you pay the bill in full each month, rent from the salary account, small daily items from the UPI account. These choices are about your comfort, not a rule: choose the one you can reconcile most easily.
Should every category have exactly one account?
Not necessarily. A realistic aim is that each category has one main account carrying most of its spending, with an occasional exception you can explain. In the sample, groceries could settle on the card, taking ₹7,500 of ₹13,000 already, and dining out on the wallet account. You do not need to move past spending, only the next month's habits.
Be careful with credit cards. A card is only a payment route; the real cost is the same whichever account pays. If you have ever carried a balance, or might, check the bill date and the amount due before moving a large category onto it.
- Write the home account beside each budget line.
- Agree it with anyone who shares the household.
- Re-run the grid after two months to see whether it stuck.
What changes after the simplification?
Budgets get simpler, because the amount spent on groceries is all in one place. Checking the statement is quicker, because you know that one account should show groceries and nothing else. Fewer accounts mean fewer statements to import.
In an app
In SpendixAI you pick the account (bank, card or wallet) before importing a statement, and each transaction keeps its account. You can group by account and category in the Report builder to get the same grid without a pivot table.
Next step
- Build the grid for last month.
- Circle every category with more than two accounts.
- Choose a home account for each circled category.
- Review the grid again in two months.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


