Excel template

Side Hustle Income & Expense Tracker

Log what each platform or client pays you, the fees they took and what you spent. Net income, profit and a tax set-aside at a % you choose are summed by month and year.

Get it on Gumroad · USD 9

Opens the Gumroad product page. The price shown there is the one that applies.

Need more than one template? This one is also in the Excel Templates Bundle (all 4) on Gumroad: $19 instead of $30 bought separately.

See how it works

Animated demo in 3 steps: 1. Log a payment: net income and tax set-aside calculate. 2. Log business expenses by category. 3. Monthly profit, set-aside and year total add up. Fictional sample data.
3 steps, loops. Real sheet, recalculated in LibreOffice. Sample data is fictional.

What the sheets look like

Profit and tax set-aside, all 12 months, Summary sheet (screenshot, fictional sample data)
Profit and tax set-aside, all 12 months (Summary sheet). Sample data is fictional.
Each payment: net income and set-aside calculated, Income sheet (screenshot, fictional sample data)
Each payment: net income and set-aside calculated (Income sheet). Sample data is fictional.
Business expenses by category, Expenses sheet (screenshot, fictional sample data)
Business expenses by category (Expenses sheet). Sample data is fictional.
Expenses by category, Oct-Dec and year, Summary sheet (screenshot, fictional sample data)
Expenses by category, Oct-Dec and year (Summary sheet). Sample data is fictional.

What it does

What it does not do

How to use

  1. On Settings, set your tax set-aside % and edit the expense categories and platforms if you like.
  2. On Income, enter one row per payment: date, platform or client, description, gross amount, fees.
  3. On Expenses, enter one row per business expense; pick the category from the list.
  4. If the Check column shows text, fix that row (it is highlighted).
  5. On Summary, enter a year to see every month and the year total.

Sheets in the file

Compatibility

Free guide and tool

FAQ

Is the set-aside the tax I owe?

No. It is a simple savings rule: the % you choose times net income. It is not your actual tax; ask a tax professional what fits your situation.

Does it total by platform?

No. Income is summed by month and year, not by platform.

Does it work with my currency?

Amounts use #,##0.00 with no currency symbol, so any currency works. Dates are YYYY-MM-DD.

Side Hustle Income & Expense Tracker

Excel file (.xlsx), no macros. USD 9 on Gumroad.

Get it on Gumroad · USD 9

Digital download. If the file doesn't work for you, email within 30 days for a full refund.

Good to know