Tax and GST

Advance tax payment tracker: a simple sheet for every payment

Build an advance tax payment tracker with instalment, planned and paid amounts, challan reference, bank debit date and file link, plus a filled example.

Editorial illustration for Advance tax payment tracker: a simple sheet for every payment

An advance tax payment tracker is a small sheet with one row per payment. Each row holds the instalment label, the amount you planned, the amount you paid, the challan reference, the date the bank debited it and a link to the saved receipt. It does not decide what you owe or when; your CA or the official site does that. It simply proves what you paid.

Which columns does the sheet need?

Seven columns are enough. Add them in this order so the sheet reads like a story from plan to proof:

  1. Instalment label, such as Instalment 1, written the way your CA names them.
  2. Due date as given by your CA or the official source, typed in by you.
  3. Amount planned, in rupees.
  4. Amount paid, in rupees.
  5. Challan reference, copied exactly from the payment receipt.
  6. Bank debit date, taken from your statement and not from memory.
  7. File link or file name for the saved challan PDF.

The due date column is typed in, not calculated, because those dates and amounts are not mine to state, and they are not guessable. Copy them from your CA's message or the official site once a year.

What does a filled example look like?

Everything below is hypothetical. Say your CA suggested four instalments of different sizes, and you paid the first two.

InstalmentPlanned (₹)Paid (₹)Challan refBank debitFile
Instalment 130,00030,000ref copied from receiptdebit date from statementChallan-Inst1.pdf
Instalment 245,00050,000ref copied from receiptdebit date from statementChallan-Inst2.pdf
Instalment 345,000pendingpendingpendingpending
Instalment 440,000pendingpendingpendingpending

Add the planned column: 30,000 + 45,000 + 45,000 + 40,000 = ₹1,60,000. Paid so far: 30,000 + 50,000 = ₹80,000. Planned for the two paid instalments was 30,000 + 45,000 = 75,000, so you overpaid by ₹5,000, which you can note rather than hide. Remaining against the plan: 1,60,000 minus 80,000 = ₹80,000.

Which formulas help?

Assume your headers are in row 1, planned amounts are in column B and paid amounts in column C, rows 2 to 5. These work in Excel and Google Sheets:

  • Total planned: =SUM(B2:B5)
  • Total paid: =SUM(C2:C5)
  • Remaining against plan: =SUM(B2:B5)-SUM(C2:C5)
  • Variance for one row (paid minus planned): =IF(C2="","",C2-B2)
  • Count of payments made: =COUNT(C2:C5)

COUNT ignores text such as the word pending, so it counts only rows with a real amount. If you prefer, leave unpaid cells blank instead of typing pending, and the formulas behave the same way.

How do you check each row against the bank?

Open the statement for the account the payment left from and find the debit for that amount. Copy the date into the bank debit column. If the debit is missing, or the amount differs, flag the row in a notes column before you move on. A challan without a debit, or a debit without a challan, needs looking into.

When does a sheet stop being enough?

If self-employed income comes into several accounts and tax payments leave from different ones, the debit dates become tedious to hunt down. Importing each statement into SpendixAI against its own account lets you search the debit by amount, and a receipt can be kept with its transaction. The tracker stays the place where payments are explained.

If you pay more than planned, as in the second row above, write the reason in a notes column the same day: a rounded-up figure, a late income that arrived, or advice from your CA. An overpayment with no explanation tends to puzzle you a year later, while one with a one-line reason takes seconds to read.

A last look before you rely on it

  • Every paid row has a challan reference and a file name.
  • Every paid row has a bank debit date taken from the statement.
  • Planned and paid totals are visible at the top of the sheet.
  • Due dates came from your CA or the official source, not from memory.
  • The sheet has been shown to your CA at least once, so they can tell you what else they would like to see.
SPENDIXAI JOURNAL

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

Explore your reports