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?
| Column | Heading | What goes in it |
|---|---|---|
| A | Client | Name as on the invoice |
| B | Invoice no. | Your own running number; for a tutor, the month and student |
| C | Invoice date | The day you raised it |
| D | Amount billed | The invoice total in rupees |
| E | Tax deducted | Amount the client held back, as per their payment advice |
| F | Amount received | What actually reached your account |
| G | Date received | The credit date on your statement |
| H | Status | Pending, Part paid or Paid |
| I | Outstanding | Billed 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.
| Client | Invoice no. | Billed | Tax deducted | Received | Status | Outstanding |
|---|---|---|---|---|---|---|
| Studio Alpha | D-014 | ₹40,000 | ₹4,000 | ₹36,000 | Paid | ₹0 |
| Brand Beta | D-015 | ₹25,000 | ₹0 | ₹10,000 | Part paid | ₹15,000 |
| Student: Riya | Oct-01 | ₹3,000 | ₹0 | ₹3,000 | Paid | ₹0 |
| Student: Kabir | Oct-02 | ₹3,000 | ₹0 | ₹0 | Pending | ₹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?
- Add the row when you raise the invoice, not when the money arrives.
- Match each credit to your bank statement and fill the date received from the statement.
- Mark anything older than the agreed payment period as overdue and send a reminder.
- Keep a copy of each invoice and the client's payment advice in a folder with the same invoice number.
- 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

