Freelance Time Tracker Spreadsheet, Billable Hours, Project and Client Log, Timesheet Template, Freelancer Hours Log, Excel Google Sheets

Freelance Time Tracker Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Get paid for every hour you work. This freelance tracker logs your time, tracks project budgets and deadlines, and shows exactly how much work you still need to invoice. ✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition. ★ WHAT'S INCLUDED ★ • Clickable Start Here cover page with quick-start steps and a colour key (yellow = you type) • Freelance Dashboard: hours this year, work value, effective hourly rate, billable share, unbilled work, outstanding invoices, hours this week vs goal, this month vs income goal, collected, overdue, active projects and projects needing attention, plus an active-project health table, invoices to chase, 7 automatic insights and 4 charts • Time Log: room for 2,000 entries. Type start and end times or just the hours, pick the project and category, mark billable or not and add the invoice #. Client, rate, value and billing status (Unbilled, Invoiced, Paid, Overdue, Fixed fee, Retainer, Non-billable) fill in automatically • Weekly Timesheet: pick any week to see hours by project and day, billable hours vs your goal, work value and every entry. Printable for clients • Projects: 80 projects with hourly, fixed fee, retainer or non-billable billing, budget hours, deadline and stage. Shows hours logged, % of budget with a progress bar, hours left, value earned, effective $/hr, invoiced, left to invoice, days left, hours per week needed and a health flag (On track, Due soon, At risk, Near budget, Over budget, Past deadline) • Clients: 60 clients with contact details and payment terms, plus hours, billable %, work value, effective $/hr, unbilled work, invoiced, paid, outstanding, last worked date and share of your income • Invoices: 300 invoices with automatic due date, balance, status (Paid, Partial, Sent, Due soon, Overdue, Draft), days overdue and the hours tagged to each invoice • Retainers: monthly fee, included hours, overage rate and optional rollover. See hours used, remaining, overage and total to bill for any month, plus a 12-month usage grid and chart • Capacity Planner: the next 12 weeks of available hours vs hours already booked by active projects and retainers, with days off, booked %, free hours, status and the weekly load of each project • Monthly Summary: hours, billable and non-billable hours, billable %, work value, effective $/hr, invoiced, collected, income goal and hours goal for every month and quarter, work value by client and month, and 3 charts • Profitability: projects ranked by effective hourly rate vs your target, clients ranked by value, and which kinds of work pay best, with 2 charts • Rate Planner: enter your income goal, costs, tax set-aside, time off and billable share to get your minimum rate, suggested rate and day rate, compare with what you're