Keep one expense list and give every purchase an account: the credit card, or the bank account your debit card draws from. Record each purchase on the day you make it, and treat the credit card bill payment as money moving between your accounts, not as another expense. Do that and one filter splits your spending by card.
Why does the same money show up twice?
A credit card swipe is spending on the day you swipe. The bill payment next month is only you settling that earlier spending. The trouble is that your bank statement shows the bill payment as a big debit, and it is easy to enter it as an expense on top of the swipes already recorded.
Say you swipe the credit card for ₹30,000 across a month and pay the ₹30,000 bill from savings the following month. If you record both the swipes and the bill payment as expenses, the list says ₹60,000 went out for ₹30,000 of actual living. Debit card purchases do not have this problem, because the money leaves your bank account at the moment of purchase.
How do I set up one list for both cards?
- Make one account per card that you use: for example a credit card account, and the savings account behind your debit card. A debit card is not a separate pot of money, so its purchases belong to the bank account it draws from.
- Give every expense an account. If your sheet or app has no account field, add a column called Card and fill it on every row.
- Add a Type column or a category called Card bill payment, so that the payment can be left out when you total your spending.
- Enter refunds against the same card that was charged, as a negative amount or a reduction in that category.
- Enter fees and interest charged by the card as their own expense lines, because they are real costs.
What do I do with the card bill payment?
Record it, because it explains why your bank balance dropped, but keep it out of the spending total. The table shows how common entries should be treated.
| Entry | Account affected | Counts as spending? |
|---|---|---|
| Dinner swiped on the credit card | Credit card | Yes, on the swipe date |
| Medicines paid with the debit card | Savings account | Yes, on the purchase date |
| Credit card bill paid from savings | Both accounts | No, it only settles earlier swipes |
| Refund credited back to the credit card | Credit card | Reduces the original category |
| Late fee or interest on the card | Credit card | Yes, as a charges line |
How do I compare debit and credit card spend?
Once every row carries an account, add up each account for the month and divide by the total. Suppose debit card purchases come to ₹14,200 and credit card purchases to ₹23,800 in a month. The total is ₹38,000, so the credit card carries ₹23,800 ÷ ₹38,000, about 63 percent, and the debit card about 37 percent.
The share is only the start. Look at which categories sit on each card. If groceries and fuel are on the debit card while travel and online shopping are on the credit card, you can see where a swipe feels like free money. Sheets users can do the split with =SUMIFS($C$2:$C$500, $B$2:$B$500, "Credit card", $D$2:$D$500, "Spend"), where column C holds amounts, B the card, and D the type.
Should I enter purchases by hand or import statements?
Both work. Statement import is quicker for the volume, and a quick manual note is useful for cash and for swipes you want recorded the same day. SpendixAI lets you pick the account, such as a bank, card or wallet, before importing a PDF, CSV or Excel statement, and each transaction keeps that account. Rows are shown for review before they are saved, which is the moment to spot the card bill payment row and give it its own category.
A short monthly routine
- Import or enter every card's activity for the month.
- Confirm the card bill payment is not counted as spending.
- Compare each card's total with its statement.
- Note the share of spend on each card and which categories drive it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
