On a credit card statement, Cr usually marks money that reduces what you owe: a payment you made, a refund, a reversal or a cashback credit. Plain lines are purchases. Because the balance on a card means what you owe, not what you have, the signs need care when you combine a card with a bank account in one sheet.
What does Cr usually flag?
Layouts differ, so confirm on your own statement. As a rule of thumb, a line with Cr is a credit to your card account. Look at the narration to tell which kind:
- Payment received: you paid the card bill, normally from a bank account.
- Refund or merchant credit: a shop returned money for something you bought.
- Reversal: a failed or cancelled transaction was undone.
- Cashback or a reward credit, if your card offers one.
Lines without Cr are mostly purchases, fees and interest charges. The statement total is what you owe, so purchases increase the balance and Cr lines reduce it.
Why is the sign opposite to a bank account?
In a bank account, the balance is your money, so a credit raises it and a debit lowers it. On a card, the balance is what you owe, so a purchase raises it and a Cr line lowers it. A card statement therefore tends to print purchases as plain positive amounts, with only the credits labelled. If you copy that straight into a sheet that treats positive as money in, spending will look like income. That is how a Rs 2,350 purchase ends up as a Rs 2,350 credit.
A clean way to normalise both
Pick one convention for the whole sheet: money out negative, money in positive. Then convert each account with its own rule.
| Source | Printed as | Rule | Signed result |
|---|---|---|---|
| Bank account | 18,000.00 Dr | Dr is negative | -18,000 |
| Bank account | 52,000.00 Cr | Cr is positive | 52,000 |
| Card purchase | 2,350.00 | No flag is negative | -2,350 |
| Card refund | 1,299.00 Cr | Cr is positive | 1,299 |
For the card sheet, with the amount in C and any Cr flag in D, the formula is =IF(UPPER(TRIM(D2))="CR",C2,-C2). Notice it is the mirror of the bank rule: on the card the flagged line is positive and the plain line negative. Keep each account on its own sheet or tab with its own formula, rather than one formula for everything.
How do you stop card payments looking like income?
The line that says "payment received" with Cr is real money, but it is not income. It is you moving money from the bank to the card. Add a Type column and mark it Transfer, mark the matching bank debit as Transfer too, and leave Transfer out of spending and income totals. Your actual spending is already in the card purchases, so counting the payment as well would double it.
Refunds belong with the purchase they reverse
A Cr refund for a Rs 1,299 shoe purchase should reduce shopping, not appear as extra income. Give it the same category as the original purchase. Then your category total for the month shows what you really spent after the return. A refund can land in a later month than the purchase, so look at both.
Worked example with hypothetical figures
Say a card statement holds three purchases of 2,350, 1,299 and 4,500, one refund of 1,299 Cr and one payment of 7,000 Cr. Signed, they are -2,350, -1,299, -4,500, +1,299 and +7,000, totalling +150, so the amount you owe fell by 150. Spending is 8,149 gross and 6,850 after the refund; the 7,000 payment is not spending.
Before you build on it
- Read your statement's own legend for Cr.
- Write down your sign convention.
- Add a Type column for transfers.
- Tie the net total to the change in the card balance.
SpendixAI asks you to pick the account (bank, card or wallet) before importing, so each transaction stays attached to its account; you still review how directions look before saving.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


