Budgeting

Card spending: report by purchase date, bill date or payment date?

Credit card spending can land in three different months by purchase date, bill date or payment date. See one ₹40,000 example and which date to use for reviews.

Editorial illustration for Card spending: report by purchase date, bill date or payment date?

Use the purchase date for reviewing what you spent, and the payment date only for planning cash. The bill date sits in between and is mostly an accident of when your card closes its cycle. The same purchases can fall in three different months depending on which date you pick, so choose deliberately and stay consistent.

What are the three dates?

  • Purchase date: the day you swiped, tapped or paid online.
  • Bill date: the day the card's statement is generated, which closes a billing cycle. Check your own card for this date.
  • Payment date: the day you pay the bill from your bank account, normally on or before the due date.

The statement date and the due date are set by your card and are not the same for everyone, so use your own. The example below is made up.

One example of ₹40,000 in three months

Say the statement is generated on the 15th and the bill is due on the 5th of the following month. You buy ₹10,000 of items on 28 January, ₹12,000 on 8 February and ₹18,000 on 20 February. The total is 10,000 + 12,000 + 18,000 = ₹40,000.

Date usedJanuaryFebruaryMarchApril
Purchase date₹10,000₹30,000₹0₹0
Bill date₹0₹22,000₹18,000₹0
Payment date₹0₹0₹22,000₹18,000

The workings: the 28 January and 8 February purchases both fall before the 15 February statement, so that bill is 10,000 + 12,000 = ₹22,000 and is paid by 5 March. The 20 February purchase falls in the 15 March statement, so it is ₹18,000 and is paid by 5 April. February looks like ₹30,000 by purchase date, ₹22,000 by bill date and ₹0 by payment date. Same spending, three stories.

Which date answers which question?

QuestionBest dateWhy
How much did I spend on shopping in February?Purchase dateIt matches when you made the choice
Which category grew?Purchase dateCategories follow what you bought, not when you paid
Will I have enough in the bank on 5 March?Payment dateIt follows when cash leaves
What will my next statement be?Bill dateIt groups purchases by cycle

For reviews, the purchase date is closest to your behaviour. If you review by payment date, you are always looking at last month's choices and a spending spree in February would not show until March or April, long after you could have reacted.

How do you avoid counting the same money twice?

When you pay the card bill from your bank account, that payment is settling spending you have already recorded from the card statement. Do not count it as a second expense. Record card purchases as spending, and treat the bill payment as a transfer between your own accounts or as a settlement. If your tracker lists both, check that totals are not inflated by the payment.

How do you set this up in practice?

  1. Import or enter the card statement, with each transaction carrying its purchase date.
  2. Import the bank statement too, so cash flow is visible.
  3. Mark the card-bill payment as a settlement and not as spending.
  4. Review spending by purchase date, and keep a short list of upcoming card due dates for cash planning.

SpendixAI lets you pick the account before importing, and each transaction keeps its account, so you can look at card spending and bank movement separately. You can then decide for yourself how the bill payment is treated in your reports.

A rule to keep

Spending review: purchase date. Cash planning: payment date. Statement date: a reference for checking you have the full cycle. Write the rule at the top of your sheet so that you, or anyone else who opens it, follows the same one.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports