Freelancer tracker sheet: income, expenses, and the tax tabs that matter

A 5-beat faceless video outline for “Freelancer tracker sheet: income, expenses, and the tax tabs that matter” in the Side hustle breakdowns niche, derived from caption timing of 2 reference videos.

Angles

• Open on yellow-input cells and auto-calculating dashboards — both templates lead with that workflow
• Name the tabs that matter: income, expenses, home office, deductions checklist
• Show goal vs actual profit on a simple dashboard beat
• Honesty: a sheet is not tax advice — flag when something applies but nothing is logged

Beat-by-beat structure

1. Hook (0:00–0:30): twelve tabs, yellow cells only — promise a usable map, not a product ad.
2. Core tabs (0:30–3:00): income rows, expense categories, business-use percent.
3. Dashboard (3:00–5:00): cashflow summary and goals vs actual.
4. Deductions hygiene (5:00–6:30): checklist flags when a deduction applies but has no log.
5. Recap. Not tax advice; original narration only.

Reference videos

• Freelancer & Self-Employed Tax Tracker 2027 — Google Sheets + Excel template walkthrough (5 min) O46iDRhONDE
• Freelancer Income & Expense Tracker Template Google Sheets Template | Complete Walkthrough Tutorial X2bClFWV9Ho

Method

yt-dlp VTT captions (manual/uploader only) → timed beat heuristics → editorial topic synthesis (no ASR). Structure only; write original narration.