Tax and GST

Business expense log template for freelancers in Google Sheets

A freelancer expense tracker for Google Sheets: columns, dropdowns, a business or personal flag and formulas for monthly totals.

Editorial illustration for Business expense log template for freelancers in Google Sheets

A good freelancer expense log in Google Sheets has eight columns: date, category, description, amount, client tag, business or personal flag, account paid from, and whether the bill is saved. Add dropdowns to the category, client and flag columns so entries stay consistent, then use SUMIFS to total anything by month, category or client.

What does the sheet layout look like?

Name the first tab Log and put these headers in row 1.

  1. A: Date (format as a date)
  2. B: Category (dropdown)
  3. C: Description
  4. D: Amount in rupees
  5. E: Client tag (dropdown, plus Overhead for costs not tied to a client)
  6. F: Business or Personal (dropdown)
  7. G: Paid from (dropdown of your accounts and cash)
  8. H: Bill saved (Yes or No)

To add a dropdown in Google Sheets, select the cells, such as B2:B500, choose Data, then Data validation, add a rule of type Dropdown, and type the choices. For categories, a short list works: Software, Equipment, Travel, Workspace, Internet and phone, Learning, Professional fees, Marketing, Bank charges, Other.

What does a filled sample look like?

The rows below are made up.

DateCategoryDescriptionAmountClientFlagPaid fromBill saved
03-Jun-26SoftwareDesign tool monthly plan₹1,650OverheadBusinessCardYes
05-Jun-26TravelCab to client office₹420Orchid HotelsBusinessUPIYes
09-Jun-26WorkspaceCo-working day pass₹600OverheadBusinessUPIYes
12-Jun-26OtherLunch with family₹850OverheadPersonalUPINo
18-Jun-26EquipmentMouse and cable₹1,200OverheadBusinessCardYes

The Personal flag is deliberate. If you sometimes use one account for everything, flagging the personal rows keeps your business total clean. Business total in the sample: 1,650 + 420 + 600 + 1,200 = ₹3,870.

Which formulas do you need?

Put a month start date, such as 01-Jun-2026, in cell K1 on a Summary tab. Then use these, adjusting the sheet name if yours differs:

  • Business spend for the month: =SUMIFS(Log!$D$2:$D$500, Log!$F$2:$F$500, "Business", Log!$A$2:$A$500, ">="&$K$1, Log!$A$2:$A$500, "<"&EDATE($K$1,1))
  • One category: =SUMIFS(Log!$D$2:$D$500, Log!$B$2:$B$500, "Software", Log!$F$2:$F$500, "Business")
  • One client: =SUMIFS(Log!$D$2:$D$500, Log!$E$2:$E$500, "Orchid Hotels")
  • Bills still missing: =COUNTIFS(Log!$H$2:$H$500, "No", Log!$F$2:$F$500, "Business")
  • Totals by category in one go (Google Sheets only): =QUERY(Log!$A$2:$H$500, "select B, sum(D) where F = 'Business' group by B label sum(D) ''", 0)

QUERY is a Google Sheets function and does not exist in Excel, so if you use Excel, build a small table with the SUMIFS formula for each category instead.

How do you keep the sheet accurate?

  • Enter expenses within a day, while you still remember the client.
  • Fill the flag every time, even if it seems obvious.
  • Once a week, compare the Log against your bank and card statements for missing rows.
  • Do not delete rows; strike them out or mark them in a Notes column so the history stays visible.

When does a sheet stop being enough?

Typing every row gets tiresome around the second month, and a sheet cannot read your statements. If you find that you are re-entering what the bank already knows, a tracker that imports statements is simpler. In SpendixAI you upload a statement as PDF, CSV or Excel, review the rows, and let rules and history categorise them. You can still export a CSV to your sheet or hand it to a CA. It does not file GST or tax for you.

A practical tip for the Client tag column: keep the dropdown list on a separate tab called Lists, and point the validation at it. When you win a new client you add one line to the list and every row in the Log can use it. Do the same for Paid from, so that a new card or wallet appears everywhere at once.

Before you share it

Ask your CA which columns they want and in what format, whether a column for tax shown on the bill is useful, and whether they treat mixed-use costs in a particular way. Rules and limits change, so confirm the current position with them rather than with a template.

SPENDIXAI JOURNAL

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

Explore your reports