Freelancer Invoice and Timesheet System

For freelancers who bill by the hour and lose track between the timesheet, the invoice and the payment.

Log time per client and project with start and end times (overnight shifts and breaks handled) or plain hours. Each row picks up the right rate automatically: the project's rate if you set one, otherwise the client's. The Invoice sheet builds a one-page invoice for any client and date range: choose the projects, and their billable hours for the period are pulled from the timesheet. Add fixed fees or re-billed costs, and tax is applied only to clients marked taxable. The Invoice Register calculates due dates from each client's terms, then shows balance, status (Paid, Overdue, Due within 7 days, Open), days overdue and days to pay. The Dashboard shows monthly hours, billable %, billable value, unbilled work, outstanding and overdue totals, and a per-client table with a chart.

Included: worked-example and blank workbooks (6 sheets, 12,734 formulas, 1,996 timesheet rows, 30 clients, 50 projects), plus a 6-page PDF in US Letter and A4 with a quick start, an invoice checklist, payment-terms and four-step reminder wording, and blank and filled printable invoice and weekly timesheet pages.

General information, not legal or tax advice.