A UPI transfer from your savings account to your own other account or wallet is not spending, because the money is still yours. Give such rows a Transfer tag, and exclude it from your spending totals, otherwise every move between accounts inflates your month.
Which movements count as transfers?
- Savings account to another of your own bank accounts, by UPI, NEFT or IMPS.
- Bank account to your own wallet, and back.
- Bank to credit card, when you pay the card bill; the later purchases on the card are the real spending.
- Moving money into a savings goal pot or a fixed deposit that is in your name.
- Withdrawing cash from an ATM; the spending is counted when the cash is spent, not at the machine.
A move to a family member is different. If you send ₹5,000 to a parent, decide whether it is household support you want to track as spending, or a transfer you want to leave out, and stay consistent.
How do you spot both halves of a transfer?
A transfer has two legs: a debit in one account and a credit in another, on the same day, for the same amount. Say ₹20,000 leaves your salary account and ₹20,000 arrives in your second account. If both statements are in your tracking, both rows exist. The debit is flagged as spending and the credit as income unless you tag them. That is how a ₹20,000 shuffle can look like ₹20,000 of spending and ₹20,000 of earnings in one go.
A worked example
Say your real spending in a month is ₹38,000. You also move ₹20,000 from your salary account to a second account, and top up a wallet with ₹3,000. Without tagging, the debits total ₹38,000 + ₹20,000 + ₹3,000 = ₹61,000, which is 60% more than what you truly spent: 61,000 divided by 38,000 is about 1.6. With the two transfers tagged and excluded, the total stays at ₹38,000.
How do you tag them in a sheet?
Add a Category column and write Transfer on these rows. Then total spending with a formula that skips the tag. Assuming amounts are in column C, categories in column D and a Debit or Credit marker in column E:
- =SUMIFS($C$2:$C$500, $E$2:$E$500, "Debit", $D$2:$D$500, "<>Transfer")
- =SUMIFS($C$2:$C$500, $D$2:$D$500, "Transfer", $E$2:$E$500, "Debit") gives the total moved out, useful for checking that it matches the credits.
These work in both Excel and Google Sheets. Arguments run: the range to add, then each range-and-criterion pair.
Can SpendixAI help with this?
Each imported transaction keeps its account, so a debit from one account and a credit in another are both visible. Create a custom category called Transfers, correct the rows once, and your corrections become history for next time. Reports can then be filtered so that this category is left out.
What about the grey cases?
Some movements are not clearly a transfer or spending, and each household decides for itself:
- Money sent to a parent or sibling to run a shared home: treat it as spending if you want a full picture of household cost, or as a transfer if the other person tracks the spending.
- Paying a friend back for a dinner they covered: it is spending in your own category, the same as if you had paid the restaurant.
- A joint account: decide who tracks it, and import it once, not once per holder.
- Moving money into a recurring deposit or a savings goal: usually a transfer, since the money is still yours, but record it so your savings picture is right.
Whatever you choose, write the rule down in one line and use it every month. Consistency matters more than the choice itself.
A short closing routine
- Import every account you actually move money between, not just the main one.
- Search your own name, and your other bank's name, in the narration to find transfers quickly.
- Tag them, check that outgoing and incoming totals match, then read the report.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


