Freelance Command Center

Freelance Command Center puts the whole admin side of freelancing into one Excel workbook. Log your hours, track projects and tasks, issue invoices and record expenses, and the dashboard shows where your business stands: active projects, open and overdue tasks, hours this week and this month, and what you have invoiced, collected, are still owed, spent and kept as profit this year.

Every project calculates its own value, budget used, progress, days left and health (On Track, At Risk, Overdue, On Hold or Done). Bill by the hour or by a fixed fee. The hourly rate comes from the project first, then the client, then your default rate, so you set it once. Tasks flag themselves as overdue, due today or due soon, and compare the hours you logged with your estimate.

The Time Log takes a start and end time with a break, or just a number of hours, and handles overnight work. Rate, amount, client, week and month fill in on their own. Invoices track Paid, Partial, Sent, Overdue and Draft, with days late, so you always know who owes you what.

White cells are for your input. Grey cells under violet headers hold the formulas and are locked, so a stray keystroke cannot break a calculation, and filters keep working on protected sheets. Protection has no password, so you can unprotect any tab when you want to customise it. Dropdowns for clients, projects, statuses and priorities come from lists you can edit on the Settings tab, and they grow as you add more.

Sample data from an example business is included so you can see every tab working, then clear it and start with your own. Built for Microsoft Excel (desktop or Excel for the web) and contains no macros. It can be imported into Google Sheets, but sheet protection does not carry over there, so Excel is recommended.