Business & selling
Side Hustle Income Expense Tracker | Profit Invoice Mileage Planner (Excel Google Sheets)
Keep your side-hustle numbers in one organised place without turning your evenings into bookkeeping admin.
Keep your side-hustle numbers in one organised place without turning your evenings into bookkeeping admin.
The SheetSmithery Side Hustle Income & Expense Tracker is an 11-sheet Excel workbook designed for freelancers, creators, Etsy and online sellers, consultants, service-based side hustles and anyone managing income outside their main job.
Record money actually received, genuine business costs, unpaid invoices, working time and business mileage. The Dashboard and Monthly Review then bring those records together so you can see your recorded income, costs, profit, outstanding invoices, hours and practical planning figures clearly.
WHAT YOU CAN TRACK
- Income by source, client or platform
- Gross income, fees or refunds and net received
- Business expenses and optional business-use percentage
- Invoice amount, amount paid and outstanding balance
- Invoice due dates and payment status
- Working sessions and recorded hours
- Effective hourly return based on recorded profit and hours
- Business mileage
- 12-month income, expense and profit performance
- Profit margin
- User-defined reserve planning percentage
- Actual reserve transfers and withdrawals
- Dated notes and follow-up actions
11 WORKSHEETS
1. Start Here
2. Dashboard
3. Setup
4. Income Log
5. Expense Log
6. Invoice Tracker
7. Time & Hourly Rate
8. Mileage Log
9. Monthly Review
10. Reserve Planner
11. Notes
BUILT FOR PRACTICAL DAY-TO-DAY USE
The workbook includes realistic sample records so you can see how it works before replacing them with your own information.
Dropdown fields help keep sources, expense categories, payment methods, invoice statuses and notes consistent. Conditional formatting highlights important statuses and balances. Working sheets include filters and freeze panes, while the dashboard gives you a visual monthly performance chart.
INCOME AND INVOICES ARE KEPT SEPARATE
Invoice Tracker records money you have billed. Income Log records money you have actually received. This helps stop unpaid invoices being counted as received income.
Income Log also separates Gross Income, Fees/Refunds and Net Received. If you subtract a platform fee there, do not enter the same fee again in Expense Log.
TIME, MILEAGE AND RESERVE PLANNING
Time & Hourly Rate uses your recorded profit and logged working hours to show an effective recorded return.
Mileage Log records journeys and miles only. It does not assume an HMRC, tax or reimbursement rate.
Reserve Planner applies a percentage chosen by you to recorded profit and separately records transfers or withdrawals you actually make. It is a planning tool, not a tax calculator.
COMPATIBILITY
Microsoft Excel: XLSX workbook.
Google Sheets: upload the same XLSX file into Google Drive or Google Sheets and open it there.
The workbook uses standard formulas and common spreadsheet features selected for normal Google Sheets import. It was not live-tested inside Google Sheets during production. Minor visual differences in fonts, table styling, charts, conditional formatting, column widths or print layouts may occur after import.
WHAT YOU RECEIVE
- One master XLSX workbook
- Quick Start Guide PDF
- Read Me First
- Personal Use Licence
This is a digital download. No physical item will be posted or shipped.
IMPORTANT
This workbook is a record-keeping and planning tool. It does not connect to banks, payment processors, marketplaces or invoicing systems. It does not calculate tax liability, allowable expenses, National Insurance, VAT, mileage relief or tax-return figures and does not provide accounting, tax, legal or financial advice.
PERSONAL USE
Your purchase is licensed for your own personal or individual side-hustle / small-business use. Resale, redistribution, sharing, marketplace upload and use as the basis of another product for resale are not permitted.
- finance tracker
- simple budgeting
- savings
- savings tracker
- savings spreadsheet
- money saving plan
- subscription tracker
- side hustle tracker
- income tracker
- second business
- expense tracker
- entrepreneur
- freelance tracker