Note both. When you log income, give the invoice date and the date the money reached your account their own columns, because they are different facts and your CA may need either one. Which of the two a particular figure is counted under is a question for your CA, not something to guess; your job is to hand over a record that shows both clearly.
Why are the invoice date and the payment date different?
The invoice date is the day you issued the bill. The payment date is the day the credit appeared in your bank statement. For a freelancer with thirty-day terms, a gap of a few weeks is normal, and with a slow client it can stretch across months. When the gap crosses 31 March, the two dates even fall in different financial years.
A tracker that keeps only one date quietly throws away the other. If you keep only the invoice date, you cannot tell what has actually landed in your account. If you keep only the credit date, you lose the link back to the work and the client, and an invoice that is still unpaid simply disappears from view.
What columns should an income log have?
Keep it plain. One row per invoice, with these columns in this order:
- Invoice number, so the row can be matched to the PDF you sent.
- Client name, written the same way every time.
- Invoice date.
- Amount billed, in rupees, as written on the invoice.
- Payment date, left blank until the money arrives.
- Amount received, which may be less than billed if the client deducted something.
- Bank account the credit landed in.
- Notes, for anything odd such as a part payment or a deduction.
A blank payment date is useful in itself. Filter that column for empty cells and you instantly have your list of unpaid invoices, which is also the list you chase on the first of every month.
A worked example with hypothetical numbers
Say you raise three invoices in a quarter. Invoice 14 for ₹40,000 is dated 12 February and paid on 9 March. Invoice 15 for ₹25,000 is dated 20 March and paid on 11 April. Invoice 16 for ₹30,000 is dated 28 March and still unpaid in mid-April.
| Invoice | Invoice date | Billed (₹) | Payment date | Received (₹) |
|---|---|---|---|---|
| 14 | 12 Feb | 40,000 | 9 Mar | 40,000 |
| 15 | 20 Mar | 25,000 | 11 Apr | 25,000 |
| 16 | 28 Mar | 30,000 | not yet | 0 |
Billed in the period: 40,000 + 25,000 + 30,000 = ₹95,000. Received before 31 March: only invoice 14, so ₹40,000. Received by mid-April: 40,000 + 25,000 = ₹65,000. Three different totals, all true, and each answers a different question. Your CA will tell you which of them belongs in which year; the sheet only has to make each one easy to read off.
How does having both dates help your CA?
Whenever a CA asks when something was earned, they may mean the date of the work or bill, or the date of receipt. Rules on this depend on how you earn and how you are assessed, and they change, so I will not pretend to state them. What I can say is that with both columns filled in, your CA can pick either date without having to come back to you with questions.
- Invoices dated in one year and paid in the next show up at once.
- The gap between the two dates shows which clients pay slowly.
- The payment date lets the CA match each row against a bank credit.
- Part payments appear as a received amount lower than the billed amount.
Does a spreadsheet stop being enough at some point?
For a handful of clients, a sheet is fine. The harder part is the bank side: matching dozens of credits to invoices by eye. SpendixAI can take a bank statement you upload and keep each transaction with its account, which gives you a clean list of credit dates to compare against your payment-date column.
A short routine to follow
- Fill the invoice columns the day you send the invoice.
- On the day the credit appears, fill the payment date and the amount received.
- If the amount differs from the billed amount, write why in the notes column.
- At month end, filter for blank payment dates and follow up.
- Before sending anything to your CA, ask which date they prefer to see first, and sort the sheet that way.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


