A credit card creates two moments that feel like spending. The first is the swipe or the card payment at the shop. The second is the UPI or NEFT you send days or weeks later to pay the bill. If both sit in your Expense tracker as expenses, the month is fiction and you will cut real life to fix a number that is wrong. Kharch Log reads the SMS your bank and card issuer already sent to your Android phone. There is no bank login. Your Google Sheet should show the purchase once, and the bill payment as a transfer that clears what you already recorded.
The swipe is the expense
When a card purchase SMS arrives, that is the expense. File it under food, fuel, travel, or whatever you bought. The date is the purchase date, not the bill due date. If you wait for the statement, you will forget the shop and the category will become misc. The SMS often includes a truncated merchant name. Add a plain note the same day if you will not recognise it later. Kharch Log can drop that alert into the Sheet you already use for UPI. The card is just another SMS source on the same phone.
Some cards notify you, and some only show the purchase inside the bank app with no SMS. Do not invent a feed the app does not have. If there is no SMS, add the row from the statement once a week, still on the purchase date. A weekly statement check is short if you only add what the SMS missed. Daily app-hopping is how people quit. Keep one rule: every purchase enters the Sheet in the week it happened. The bill payment later does not create the expense again.
- Category the purchase on the day the SMS arrives
- Use the purchase date, not the due date
- Add a shop note if the merchant text is cut short
- If a card sends no SMS, add those rows once a week from the statement
The bill payment is a settlement
When you pay the card bill from your savings account, the bank sends a debit SMS and often a card SMS that the bill was received. Neither of those is a new restaurant meal. Label them Transfer or Card payment. Put the statement month in the note, such as card bill Sep. If you pay the full amount, the transfer should be close to the sum of card purchases you already logged, plus fees, minus refunds. If it is much larger, you missed purchases. If it is much smaller, you paid only part of the bill, and the rest is still debt, not savings.
Paying from PhonePe, Google Pay, or netbanking does not change the rule. The source of the rupees is your account. The destination is the card. People who track only UPI see a huge bill payment and none of the swipes, so they think one day exploded. People who track both and count both think the month exploded twice. You want the swipes as life and the bill as settlement. Kharch Log will not know this unless you set the category. The SMS text rarely says settlement. You do, in the Sheet.
Minimum due, EMI, and fees
The minimum due is not the bill. If you pay only that, the unpaid purchases remain spent, and interest will arrive as its own SMS later. Log the minimum payment as a partial transfer, and leave the unpaid balance visible in a note. Do not delete the original purchases to make the month look smaller. Interest and late fees are real expenses. File them as fees, not as food. An EMI conversion is still the purchase you made, sliced into months. Log the EMI debit as the spend for that month if you did not log the full purchase on day one.
Pick one EMI method and stick to it. Either log the full purchase on swipe day and treat later EMI debits as transfers, or skip the full amount and log each EMI as the monthly spend. The first shows the shock on the day you bought the phone. The second spreads it the way your account feels it. Mixing them doubles the phone. Write the choice in the note on the first EMI. Fees for the conversion are an expense on top. They are not part of the gadget price you remember from the shop.
- Full swipe on day one, later EMIs as transfers
- Or skip the full swipe and log each EMI as that month's spend
- Never both
- Interest, late fees, and conversion fees are expenses
Match the statement on bill day
On the day you pay, filter card purchases for that statement period. Add them. Add fees. Subtract refunds you already matched. Compare with the amount you are about to pay. A small gap is a tip, a fee, or a purchase SMS you never got. A large gap means a missing swipe or a double row. Fix the Sheet before you pay, while the statement is on screen. This is a twenty minute job once a month, not a daily hobby. After you pay, the only new row is the transfer.
If you have two cards, use a card name in the note, not two Sheets. Two Sheets break the habit. The account that pays the bill may be the same savings account that pays rent, so the bill transfer must not be labelled as rent either. Read the payee. Card bill payees look like the issuer, not like your landlord. When the labels are right, your real monthly spend is the swipes, the UPI, and the cash, without the settlement. That is the number to compare with your salary. The bill date is only cashflow.
Questions people actually ask
I paid the full bill. Why does the month still look high? Because the purchases were real. Paying the bill did not make the dinners free. The high number is the swipes. The payment is a transfer and should not add on top. If the month looks high after you removed the payment, you spent that much. Look at categories, not at the bill row. Refunds that are still missing will also keep the total high until you match them.
What about a card bill that is auto-debited? Treat the auto-debit SMS like any other bill payment. It is a transfer if the purchases are already in the Sheet. It is the expense only if you never logged the swipes and you are using the debit as a monthly total, which is a weaker method. Check the auto-debit amount against the statement the first time so a wrong mandate does not hide.
Should I track a card I pay in full every month? Yes. Paying in full avoids interest. It does not tell you whether the swipes were food, shopping, or fuel. The statement total is one number. The Sheet is the split. You still mark the full payment as a transfer so it does not double. People who only archive the PDF never see which week the card ran away. The purchase SMS is the useful row.
Log the swipe as the spend and the later bill UPI as a transfer. That single habit stops a double count. A login-free way to capture bank SMS is explained in tracking without a bank login. See Kharch Log features for how those alerts reach your Google Sheet. On bill day, match the statement to the rows before you pay.