Use the transaction date when you want to know when you spent, and the posting or value date when you want your totals to agree with the bank's running balance. Pick one for all monthly totals, keep the other as a reference column and say which you used.
What do the date columns usually represent?
Banks and card issuers label dates differently, so check your own statement's headings and any notes at the end. As a rough guide:
| Column | Usually means | Good for |
|---|---|---|
| Transaction date | The day you made the payment or swiped the card | Tracking when you spent |
| Posting date | The day the bank recorded it in the account | Matching the statement |
| Value date | The day the entry counts for the account, often the same as posting or a day or two off | Reconciling to the balance |
For a UPI payment from a savings account, all dates are often the same day. The dates drift apart on cards, cheques, NEFT and anything that settles later.
How can they land in different months?
Say you swipe a card at a shop on 30 January 2024 for ₹3,600. The merchant's settlement reaches the card issuer on 1 February, so the statement shows transaction date 30 January and posting date 1 February. The same row belongs to January if you ask when you spent, and to February if you add up what the statement recorded in February.
| Row | Transaction date | Posting date | Amount |
|---|---|---|---|
| Shop A | 30 Jan 2024 | 1 Feb 2024 | ₹3,600 |
| Shop B | 31 Jan 2024 | 31 Jan 2024 | ₹1,200 |
| Shop C | 1 Feb 2024 | 2 Feb 2024 | ₹800 |
By transaction date, January is 3,600 plus 1,200, which is 4,800, and February is 800. By posting date, January is only 1,200 and February is 3,600 plus 800, which is 4,400. Same three purchases, two very different monthly pictures.
Which should I choose?
- For a spending view, such as a budget or a category analysis, choose the transaction date. It matches how you think about the month.
- For reconciling to a statement, a balance or a card bill, choose the posting or value date, because the printed balance follows it.
- If a statement gives only one date, use it and note the limit.
- Whatever you choose, use it in every month and for every account, or comparisons between months will not mean much.
How many rows are affected in my data?
Count them. With transaction dates in A and posting dates in B, both real dates, this formula counts the rows where the two fall in different calendar months:
- =SUMPRODUCT(--(TEXT($A$2:$A$200,"yyyymm")<>TEXT($B$2:$B$200,"yyyymm")))
Set the ranges to exactly your data, because blank rows would be compared as dates too. If the answer is small, the choice barely changes monthly totals. If it is large, as for a card with a lot of end-of-month use, the choice matters and deserves a note on the sheet.
Reconciling is where the choice bites. Using the three rows above, a bank's January closing balance includes only what was posted by 31 January. Shop B's ₹1,200 is in it, but Shop A's ₹3,600 is not, even though you spent it in January. Add up January by transaction date and you will not match the closing balance. Add up by posting date and you will. Neither is wrong; they answer different questions.
Keep both columns
- Do not delete the unused date. Rename the columns plainly, such as Spent on and Posted on.
- Add a note naming the column used for monthly totals.
- If you import data into any tool, find out which date it takes and check a boundary-day row against the statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


