Tax and GST

Freelance income tracker for April to March: columns to include

A freelance income tracker spreadsheet for India: the columns to include, sample rows for a designer and a tutor, and formulas for an April to March year.

Editorial illustration for Freelance income tracker for April to March: columns to include

A freelance income tracker needs one row per invoice or payment and these columns: client, invoice number, invoice date, amount billed, tax deducted by the client, amount received, date received and status. Add one more column for what is still outstanding. With that, you can answer who owes you money, what has arrived and what the April to March year looks like so far.

Which columns should the sheet have?

ColumnHeadingWhat goes in it
AClientName as on the invoice
BInvoice no.Your own running number; for a tutor, the month and student
CInvoice dateThe day you raised it
DAmount billedThe invoice total in rupees
ETax deductedAmount the client held back, as per their payment advice
FAmount receivedWhat actually reached your account
GDate receivedThe credit date on your statement
HStatusPending, Part paid or Paid
IOutstandingBilled minus deducted minus received

If you are registered for GST and add it on invoices, put the amount before GST, the GST and the total in separate columns. Whether you must register, and how to treat each amount, is for your CA.

What do the rows look like for a designer and a tutor?

Both examples use invented numbers. A designer bills ₹40,000 to a studio. The studio pays ₹36,000 and shows ₹4,000 as tax deducted. The tutor charges monthly fees by UPI, so there is no deduction, and each student is a row.

ClientInvoice no.BilledTax deductedReceivedStatusOutstanding
Studio AlphaD-014₹40,000₹4,000₹36,000Paid₹0
Brand BetaD-015₹25,000₹0₹10,000Part paid₹15,000
Student: RiyaOct-01₹3,000₹0₹3,000Paid₹0
Student: KabirOct-02₹3,000₹0₹0Pending₹3,000

The outstanding formula for row 2 is =D2-E2-F2, filled down the column. For row 3 it gives ₹25,000 minus ₹0 minus ₹10,000, which is ₹15,000, matching the table.

How do you total an April to March year?

Put the date on which you received money in column G, and use SUMIFS with start and end dates. The same formulas work in Excel and Google Sheets. For the year starting April 2026:

  • Received this financial year: =SUMIFS($F$2:$F$500, $G$2:$G$500, ">="&DATE(2026,4,1), $G$2:$G$500, "<="&DATE(2027,3,31))
  • Billed this financial year, by invoice date: =SUMIFS($D$2:$D$500, $C$2:$C$500, ">="&DATE(2026,4,1), $C$2:$C$500, "<="&DATE(2027,3,31))
  • Received from one client: =SUMIFS($F$2:$F$500, $A$2:$A$500, "Studio Alpha")
  • Number of pending invoices: =COUNTIF($H$2:$H$500, "Pending")
  • Total still outstanding: =SUM($I$2:$I$500)

Check the SUMIFS argument order: the first range is what you add up, then each condition range is followed by its condition.

What habits keep the sheet honest?

  1. Add the row when you raise the invoice, not when the money arrives.
  2. Match each credit to your bank statement and fill the date received from the statement.
  3. Mark anything older than the agreed payment period as overdue and send a reminder.
  4. Keep a copy of each invoice and the client's payment advice in a folder with the same invoice number.
  5. Once a month, check that the sum of received amounts matches the credits on your statement.

Add a Notes column at the far right for anything the other columns cannot hold: a revised amount, a disputed invoice, a promised payment date. Freeze the header row and keep one tab per financial year, so that last year's rows never mix with this year's totals.

When does a sheet stop being enough?

The sheet covers income well. Your business costs are another matter: they come from many card and bank rows and are tedious to type in. SpendixAI can take the expense side, with statements uploaded, rows reviewed before saving and receipts kept with each transaction, while this sheet carries on holding the income. Keep both, and give your CA the income sheet and the expense reports together.

SPENDIXAI JOURNAL

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

Explore your reports