When goods arrive in a different month from the one on the bill, record both dates: the invoice date and the date you actually received the goods. The two dates can put the same purchase in different months in your summaries. Which date counts for tax or accounts is the CA's decision, so your job is to capture both, clearly, on the same row.
Why can the two dates differ?
Suppliers often bill when they dispatch, and goods then spend days or weeks in transit. A bill dated 29 October for stock that reaches your shop on 4 November is an ordinary case. Festival rushes, transport strikes, partial deliveries and goods sent by truck from another state all widen the gap.
What should the row contain?
- Supplier and bill number.
- Invoice date, as printed on the bill.
- Goods receipt date, from your own gate or stock register or a delivery note.
- Amount on the bill.
- Payment date, if you have paid.
- A note on partial deliveries, with what arrived on which date.
Keep each date in its own column. Do not put two dates in one cell, because you cannot sort or total on them later.
How do the dates show up in monthly summaries?
Take a hypothetical bill of ₹60,000 dated 29 October, with the goods received on 4 November. Total your purchases by invoice date and by receipt date, and the same bill lands in different places.
| Summary by | October total | November total |
|---|---|---|
| Invoice date | Includes the ₹60,000 bill | Does not include it |
| Receipt date | Does not include it | Includes the ₹60,000 bill |
If October's other purchases were ₹1,40,000, then by invoice date October shows ₹2,00,000. By receipt date it shows ₹1,40,000. Same business, same bill, two honest totals. That is why a sheet that stores only one date can mislead.
What are the spreadsheet formulas for each view?
Assume Invoice date in column A, Receipt date in column B and Amount in column C, rows 2 to 500, and the first day of the month in cell F1, for example 1-Oct-2026 typed as a date. These work in Excel and Google Sheets.
- Total by invoice date: =SUMIFS($C$2:$C$500, $A$2:$A$500, ">="&$F$1, $A$2:$A$500, "<"&EDATE($F$1, 1))
- Total by receipt date: =SUMIFS($C$2:$C$500, $B$2:$B$500, ">="&$F$1, $B$2:$B$500, "<"&EDATE($F$1, 1))
Leave the receipt date blank until the goods come. Blank rows are simply excluded from the second formula, and filtering for blanks gives you a list of bills for goods still on the way.
Which date counts for tax or accounts?
That depends on your registration, the type of purchase and rules that change. It is not something to settle by choosing the date that looks better in a report. Capture both and ask your CA which they use.
How can a tracker help?
SpendixAI works with the transaction date from your statement, which is the date money moved. That makes it a useful third date: when you paid. Upload the statement, review the rows and attach the bill to the transaction as a receipt. Keep the goods receipt date in your own stock register or sheet.
A short rule for every purchase
- Write the invoice date the day the bill arrives.
- Write the receipt date the day the goods arrive.
- Note short or partial deliveries on the same row.
- At month end, list bills with no receipt date.
- Show the list to your CA with the question of which date they want to use.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
