To track Bandhan Bank spending with your other accounts, treat each source of money as its own account, import its statement separately, and keep two things out of your spending totals: money you move between your own accounts and the payment you make towards a credit-card bill. Then, once a month, check that each account's rows add up to the closing balance printed on its statement. The rest of this page is a worked setup you can copy.
Start with a list of sources, not a list of categories
Say Meera's salary arrives in her Bandhan Bank savings account. She pays rent and electricity from an account at another bank, and she uses one credit card for groceries and online orders. That is three sources. Write them down before you open any tracker, because every later step hangs on this list.
- Bandhan Bank savings account: salary comes in, UPI and card spending goes out.
- Second bank account: rent, electricity and the broadband bill.
- Credit card: groceries, online orders and one or two subscriptions.
A wallet balance or a cash envelope would be a fourth source, entered by hand.
What should each source look like in the tracker?
| Source | How the data gets in | What to watch for |
|---|---|---|
| Bandhan Bank account | Download your own statement from the bank's statement or e-statement area, upload it, review the rows, save | Salary credits and transfers to your other account |
| Second bank account | Same route with that bank's statement, picked against its own account | Transfers from the Bandhan Bank account showing up as credits |
| Credit card | Upload the card statement as a separate account | Payments towards the card, which also appear in a bank account |
| Cash | Add expenses by hand, several at once if you wish | Round figures and forgotten days |
In SpendixAI you pick the account before importing, and each transaction keeps that account, so a Bandhan Bank row never gets mixed into the card's rows. Do the same in any sheet: keep an Account column and never merge sources into one anonymous list.
How do you stop transfers and card bills counting twice?
Suppose Meera moves ₹20,000 from her Bandhan Bank account to the second account for rent. The statement of the first account shows ₹20,000 going out and the statement of the second shows ₹20,000 coming in. Neither is spending. Spending happens later, when the rent is actually paid from the second account.
Card bills work the same way. When she pays ₹15,000 towards the credit card from the Bandhan Bank account, that payment is a settlement. The real spending is the individual card purchases that made up the bill. If both the payment and the purchases are counted, the same ₹15,000 is counted twice.
- Create a category such as Own transfers and one called Card bill payment.
- Put the matching row from each account into those categories as you review.
- When you run a report or filter, leave those two categories out so only real purchases remain.
What does the monthly balance check look like?
Each statement shows an opening balance and a closing balance for its period. Use them as a proof. For the Bandhan Bank account, say the opening balance is ₹38,000, total credits for the month are ₹72,000 and total debits are ₹61,500. The expected closing balance is 38,000 + 72,000 - 61,500 = ₹48,500. If the tracker's rows give a different closing figure, a row is missing, doubled or tagged in the wrong direction.
Run this check for each account separately, because a mismatch then tells you where to look.
Where an app helps, and where it does not
SpendixAI takes statements as PDF, CSV or Excel, lets you review rows before saving, flags possible duplicate imports, and keeps the import history with a status for each file. It does not connect to your bank and never asks for net-banking logins, so the monthly download is your job. It also does not read SMS, so cash and anything missing from a statement is a manual entry.
What if the numbers do not match?
Work backwards in a fixed order. First confirm the statement period is the same in the tracker and on paper: a statement that starts on the 2nd instead of the 1st leaves out a day of rows. Second, look for a large row and see whether it was imported twice. Third, check that a credit was not read as a debit. Most gaps turn out to be one of these three, and each takes less than a minute to test.
Month-end checklist
- Download the latest statement of each account for the same date range.
- Upload each against the right account and review before saving.
- Tag transfers and card bill payments.
- Compare each account's closing balance with the statement.
- Add cash spending, then read the category report.
If the numbers still refuse to match after two attempts, look at the statement date range first. Overlapping or missing days cause most mismatches.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

