Freelance Time Tracking Spreadsheet & Invoice Template

This freelance time tracking spreadsheet and invoice template helps you track every hour, invoice on a schedule, follow up on late payments and see your real hourly rate against a yearly goal.

Who it's for: Freelancers and solo consultants who bill by the hour or by project, juggle a few clients at once, and want one simple place to log time, track invoices and see how the year is going.

The problem it solves: Unlogged hours, uninvoiced time and late payments can quietly cut freelance income. This workbook follows each hour from the Time Log to an invoice to PAID, flags OVERDUE invoices, shows your value per hour logged (admin time included), tracks collected income month by month against an even pace toward your yearly goal, and estimates a tax set-aside from your own %.

What's inside

• Time, Invoice & Income Workbook (EXAMPLE + BLANK, .xlsx)
• Freelancer Money Playbook (PDF)
• Invoice Template and Client Time Report (DOCX + PDF)
• Payment Terms and Late-Payment Clauses TEMPLATE (DOCX + PDF)
• Payment Reminder Emails and Monthly Money Review Checklist (DOCX + PDF)
• AI Prompt Pack: 25 prompts (PDF + TXT)
• Start Here guide and license

How it works

1. On Settings, enter the year, your income goal, default rate and payment terms, and your tax set-aside %.
2. Add clients with their own rate and terms.
3. Log every block of work on the Time Log; type the invoice number on the rows you bill.
4. Add each invoice; time adds up automatically and status shows OPEN, OVERDUE or PAID.
5. Do the Monthly Money Review with the Dashboard and Income vs Goal tabs.

Good to know

• Every number in the EXAMPLE file belongs to a made-up business; it isn't a market rate or a recommendation.
• Templates aren't legal advice; tax lines are placeholders. Have your own professionals review them.
• The tools help you run your business; they don't guarantee income or results.
• Excel .xlsx workbook, no macros; formulas tested in LibreOffice (Google Sheets and Excel open-tests pending).
• The tax set-aside is a % you choose, not a tax calculation. Ask a tax professional what to set aside and when to pay estimated taxes.
• Some states and cities, including New York and Illinois, have freelance worker laws with written-contract and payment-timing rules. The payment terms clauses are a template to have an attorney review.
• Texting or emailing clients: message only people who gave you their number or email, honor every STOP or unsubscribe request right away, and get a client's written consent before sending marketing texts with an automated tool. Marketing emails need your postal address and an unsubscribe option (CAN-SPAM). Some states, including Virginia, add rules such as allowed texting hours. This isn't legal advice.

Need a website? Bought any kit from the Archive? You get a $39 credit toward any website package from The Collective if you request it within 60 days of your purchase (one credit per website project). The credit applies only to website services, not to kits or other products. To request it, email ryanviabusiness@gmail.com with your order number.

Refunds: All sales are final. This kit is an instant digital download, so we don't offer refunds once your order is placed. If a file is broken, missing or not as described, email ryanviabusiness@gmail.com with your order number and we'll send you a working replacement file; if we can't provide a working file that matches this description, we'll refund your order. If you bought the same kit twice by mistake, email us within 14 days of the second order and we'll refund the duplicate order. Nothing in this policy limits any rights you have under law that can't be waived.

License: one business; no resale, redistribution or sharing.

Cover images are illustrations created with AI. The people shown are fictional, not customers.