The transaction date is the day the payment or deposit was made. The value date is the day the bank counts the amount for its own purposes, such as interest or clearing, which can be the same day or later. For your own records of spending, use the transaction date, the day you actually paid, and keep to it.
What do the two date columns mean?
- Transaction date: when the transaction was carried out or recorded on the account.
- Value date: the date from which the bank treats the money as moved, for example for interest or clearing.
- Posting date: some statements show a third date, when the item was entered in the bank's books. Cards often show only this.
Banks label these columns differently, and a given statement may show one, two or three. Check the headings on your own statement before relying on any of them.
Which date should you record in your books?
For personal and small-business expense tracking, the day you made the payment is the most useful: it reflects when you decided to spend. That usually matches the transaction date for a debit-account payment. When the two dates differ, pick one rule, write it down and apply it to every entry. A mix of both makes month-end totals unreliable.
For formal accounts or tax purposes, the date to use is something to confirm with your CA, because rules and practice vary.
A card payment that lands in the wrong month
Hypothetical example. On 31 October at 11.50 pm you pay ₹3,200 for a software subscription on a card. The card statement lists it under 1 November, because that is when it was posted.
| Date | What it is | Month it falls in |
|---|---|---|
| 31 October | You made the payment | October |
| 1 November | The bank posted it | November |
| Your records using the posting date | Entry dated 1 November | November |
| Your records using the payment date | Entry dated 31 October | October |
Use the posting date and October's spending is understated by ₹3,200 while November's is overstated by the same amount. If October's total was ₹52,000 by payment date, it would show 52,000 minus 3,200, which is ₹48,800 by posting date. Across a year, this evens out, but any month-by-month comparison or budget check will mislead you.
What about deposits and cheques?
For money coming in, the same question arises: the day the customer paid or the day the bank credited it. A cheque deposited on Friday may show a transaction date of Friday and a value date later, after clearing. For income, many people prefer the date the money was actually credited to their account. Pick a rule and apply it to every deposit.
The same logic applies to recurring payments. An EMI or subscription debited on the 1st may be dated the 30th by one bank and the 1st by another. If your budget runs from the 1st to the 30th, such an item can jump between months. Fix your rule first, then adjust the odd ones, and note the original date in the description.
How do you apply the rule consistently?
- Decide on the date you will use for payments and for deposits, and write both rules in your notes.
- Copy the right column from the statement for each row.
- Review the first and last days of every month against the statement.
- If you have to adjust a date, note the original in the description.
- Keep the rule the same from one year to the next.
How does a tracker treat dates?
When you import a statement into SpendixAI, you review the rows before saving, which is the moment to check the date column against the original, especially for entries near a month boundary. If you add expenses by hand, you choose the date yourself, so the payment date is the natural pick.
A short checklist
- One date rule for payments, one for deposits.
- Month-end rows checked against the statement.
- Corrections noted, never silent.
- Rule written down where you will find it again.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


