Spreadsheets

Spreadsheet or app for freelancers: tracking client income

Spreadsheet or app for freelancer expense tracking? Compare invoice, TDS and GST columns, business versus personal spends, and quarter-end totals.

Editorial illustration for Spreadsheet or app for freelancers: tracking client income

As a rough rule, a spreadsheet is enough while you have a few clients, a separate business account and a manageable number of payments a month. An app that imports your statement starts to pay for itself when you have many small clients, one bank account carrying both business and personal spends, or a quarter-end that you dread. The real question is how much of the typing and tagging you are willing to do by hand.

What does a freelancer need to track?

Two separate things get mixed up: money you are owed and money you spend. A freelancer's record needs both.

  • For each invoice: number, date, client, amount before GST, GST shown on the invoice, TDS the client deducted, the amount you expect to receive and the date it actually arrives.
  • For each expense: date, what it was, amount, category, payment mode and whether it was business, personal or mixed.
  • A line for anything that sits between the two, such as a laptop bought personally but used for work.

Whether you charge GST, and whether a client deducts TDS, depends on your own situation. The sheet only records what the invoice and the payment actually say. Rules and limits change, so confirm the current position with your CA or the official source.

How does a spreadsheet handle invoices, GST and TDS?

One row per invoice works well. Say you invoice a client ₹50,000 before GST, the invoice shows ₹9,000 of GST, and the client deducts ₹5,000 as TDS before paying. Money you should receive is 50,000 + 9,000 - 5,000 = ₹54,000.

ColumnHeadingExample or formula
AInvoice no.INV-014
DAmount before GST50000
EGST on invoice9000
FTDS deducted5000
GExpected receipt=D2+E2-F2
HReceived54000 (enter when it lands)
IBalance=G2-H2

To list unpaid invoices in Excel 365 or Google Sheets, use =FILTER($A$2:$A$200,$I$2:$I$200>0). Older Excel versions do not have FILTER, so a simple filter on column I does the same job by hand. Add a note column for TDS, because you will want to match it with the TDS statement your client's accounts team sends later.

Can one bank account be split into business and personal?

Yes, with discipline. Add a Purpose column with a dropdown of Business, Personal and Mixed, and tag every statement row. Business spend for a month is then =SUMIFS($D$2:$D$500,$E$2:$E$500,"Business",$B$2:$B$500,">="&$K$1,$B$2:$B$500,"<="&$K$2), where K1 and K2 hold the first and last date of the month.

The weakness is the tagging. A hundred statement rows a month means a hundred decisions, and Mixed rows such as a phone bill need a rule you write down once, for instance a fixed share you decide with your CA. If you fall behind for two months, the cleanup is what makes people abandon the sheet.

What does a quarter-end summary look like?

Indian freelancers usually think in financial-year quarters: April to June, July to September, October to December, January to March. Keep two cells with the quarter's first and last date, then reuse the SUMIFS above for income received, expenses by Purpose and unpaid invoices. A small summary of four numbers is enough: invoiced, received, TDS deducted, business spend. Ask your CA which dates matter for your own filings.

Which one should you choose?

Your situationWhat tends to work
1 to 3 clients, under about 10 payments a month, separate business accountSpreadsheet
4 to 10 clients, 10 to 30 payments a month, some mixingSpreadsheet if you update weekly; consider an app if you fall behind
More than 10 clients, or over 30 statement rows a month, or one account for everythingApp that imports statements, plus a sheet for the invoice register

These cut-offs are a judgement, not a measured figure. Move them to suit how patient you are with typing.

Where an app helps, and where it does not

SpendixAI takes a bank or card statement as PDF, CSV or Excel, lets you review rows before saving, and categorises them. It has custom categories with GST and tax-deductible settings, and its reports estimate GST inside your spending, which you should check against invoices and with a CA. It does not do invoicing, GST filing, TDS tracking or tax computation, so the invoice register stays in your sheet.

A short checklist before you decide

  1. Count last month's statement rows and how many were business.
  2. Note how long tagging them took.
  3. If it took over an hour, try importing one statement into an app and compare.
  4. Whichever you pick, tag business and personal spends from the first day of a quarter, not at its end.
SPENDIXAI JOURNAL

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

Explore your reports