SampattiTrackTo reconcile a credit card statement, compare it with your records for the same billing cycle, tick off every matching line, then explain each line that is on only one side. When the lines you have matched and explained add up to the statement total, your ledger is right. The usual causes of a mismatch are refunds, fees, forex markup, EMI interest and timing.
What reconciliation means
Reconciling is checking that your own records agree with the bank's. For a credit card, the bank's record is the monthly statement and yours is the card account in your ledger. Spending shows up at different speeds in each place, and the bank adds charges you never typed in. A reconciliation finds the differences and settles each one.
It is worth doing because a card is a liability, and the balance owed should match what the bank says you owe. If it does not, either you have missed a charge or recorded one twice. The sooner you find out, the easier it is to remember what the charge was. Our guide to credit card accounting explains why a card sits on the liability side and why paying the bill is a transfer, not an expense.
The method, step by step
- Fix the period. Use the statement's billing cycle, from the statement date of the last bill to the statement date of this one, and not the calendar month.
- Check the opening balance. Last cycle's closing balance, less the payment you made, should be your starting point. If you paid the previous bill in full, it should be zero.
- Tick off each line. Match every statement line to a transaction of the same amount and date in your records.
- List what is left on each side. Items only on the statement are usually things you have not recorded. Items only in your records are usually timing differences or mistakes.
- Fix, then compare totals. Add the missing items, remove duplicates, and compare again. The totals should now agree.
A worked example
Your billing cycle runs from 16 September to 15 October, and last month's bill was paid in full. Here is every line, with what your records showed before you reconciled. The figures are made up.
| Item | Statement | Your ledger | What to do |
|---|---|---|---|
| Food delivery | ₹1,240.00 | ₹1,240.00 | Matches |
| Online shopping | ₹3,499.00 | ₹3,499.00 | Matches |
| Fuel | ₹2,000.00 | ₹2,000.00 | Matches |
| Overseas software (US$20 at ₹85) | ₹1,700.00 | ₹1,700.00 | Matches |
| Forex markup (3.5% of ₹1,700) | ₹59.50 | none | Add as a fee |
| GST on markup (18%) | ₹10.71 | none | Add as a fee |
| EMI interest | ₹100.00 | none | Add as interest |
| GST on EMI interest | ₹18.00 | none | Add as a fee |
| Annual fee (₹500 + 18% GST) | ₹590.00 | none | Add as a fee |
| Refund for returned item | −₹899.00 | none | Add as a refund |
| Coffee on 16 Oct | none | ₹350.00 | After the statement date |
| Total | ₹8,318.21 | ₹8,789.00 |
Start with the raw gap. Your ledger shows ₹8,789.00 and the statement says ₹8,318.21, so they are ₹470.79 apart. Now explain it:
- The ₹350 coffee was bought on 16 October, after the statement date. It is correctly in your records and will appear on next month's statement. Take it out for this comparison: ₹8,789.00 − ₹350.00 = ₹8,439.00 for the cycle.
- Four charges you had not recorded: ₹59.50 + ₹10.71 + ₹100.00 + ₹18.00 + ₹590.00 = ₹778.21. These are the markup, its GST, the EMI interest, the GST on it and the annual fee.
- One refund you had not recorded: −₹899.00.
Apply the fixes: ₹8,439.00 + ₹778.21 − ₹899.00 = ₹8,318.21. That matches the statement exactly. Your ledger, including the coffee, now owes ₹8,668.21, which is ₹8,318.21 on this bill and ₹350.00 to come. The refund also matters for your spending reports: if it is credited against the original shopping category, your shopping total is ₹899 lower than the purchase alone suggested.
Common mismatches and what causes them
- Refunds and reversals: a refund reduces what you owe and should reduce the spending in the original category. It often arrives days after the return, and sometimes as a statement credit with a different description.
- Fees, interest and GST: annual and late fees, finance charges and the GST on them are posted by the bank. Record them as expenses, in a category such as bank charges, so they are visible.
- Foreign currency: the bank converts at its own rate on its own date, and may add a markup and GST on it. Use the rupee amount on the statement, not the price you saw at checkout.
- EMI conversions: if you turn a purchase into EMIs, the full purchase was already recorded when you made it. Each instalment's principal is that purchase being paid down over time, so only the interest and the GST on it are new expenses. The EMI calculator shows the instalment and total interest for a given loan, so you can check the bank's figures.
- Timing: a purchase may be dated one day in your records and posted the next day on the statement. Compare the posting date, and expect items close to the cut-off to fall on either side.
- Duplicates: entering a purchase by hand and then importing the statement is the classic way to count it twice.
- Payments in transit: a bill payment made just before the statement date may not be reflected until the next one.
- Cashback and reward credits: these reduce the bill and are easy to miss.
After you reconcile: pay the bill correctly
Once the figures agree, pay the bill and record the payment as a transfer from your bank to the card, not as an expense. The purchases were already counted as spending when you made them. Recording the payment as an expense counts the same money twice, which is the second most common reason a card does not reconcile. The total due is not always what you must pay to avoid charges, so also check the minimum due and the due date on the statement. For where this fits in your wider picture, see how to track your net worth.
How to do this in SampattiTrack
SampattiTrack records a card as a liability. Open the Cards tab, tap your card, and you see the balance owed, the billing cycle and the due date. The balance should match your card app when the dates line up. If it does not, compare the transactions one by one with the statement. The details are in Credit cards and bills.
- When you add the card, enter the Statement Day and Due Day, so the billing cycle matches the bank's.
- Record purchases as expenses paid from the card. Record fees and interest the same way, in a suitable category.
- If you import the statement, open More, then Import Statement, choose the card as the account, and review the staged transactions before you tap Import. A card statement treats an unsigned amount as a purchase, so check that refunds are shown in the right direction. Rows marked Possible duplicate look the same as something already in the account. Leave them out if you have already entered them. See Import a CSV statement.
- Pay the bill from the card's pay button or from Bills & Obligations, which records the transfer. This only records the payment, so pay the bank first.
To be clear about the limits: the app does not match your statement for you. The reconciliation is the comparison above, with the app giving you a reliable ledger to compare against. After the statement date, the closing balance in the app should equal the statement total plus anything bought since.
Key takeaways
- Reconcile one billing cycle at a time: match lines, explain what is left on each side, then compare totals.
- In the example, a gap of ₹470.79 was a ₹350 timing difference, ₹778.21 of unrecorded fees and interest, and an unrecorded ₹899 refund.
- Fees, interest and GST on them, forex markup and refunds are the most common missing items.
- For an EMI conversion, only the interest and its GST are new expenses; the principal was already recorded.
- Record the bill payment as a transfer, never as an expense.
Frequently asked questions
How often should I reconcile my credit card?
Once per statement is enough for most people. Doing it soon after the statement arrives makes it easier to remember what each charge was.
Why does my card balance not match the statement?
The usual causes are fees or interest you have not recorded, a refund not yet entered, a purchase dated after the statement date, a duplicate entry, or a bill payment recorded as an expense.
Should a refund be recorded as income?
No. A refund reverses part of an earlier purchase. It should reduce the amount you owe on the card and reduce spending in the original category.
How do I record the forex markup on a foreign purchase?
Use the rupee amount shown on the statement for the purchase, and record the markup and the GST on it as separate fee expenses.
Putting it into practice
SampattiTrack keeps credit cards as liabilities with balances, billing cycles, due dates and reminders, and can import card statements from CSV for you to review before anything is saved. Everything is stored on your device, with optional private iCloud sync and no sign-up. It is available on the App Store.
This article is for educational purposes only. It is not investment, tax, legal or financial advice. Examples use made-up numbers, and past returns do not predict future results.