Invoice Template Excel & Google Sheets, Freelance Hours Log, Contractor Billable Time Tracker, Client Payment Register, Consultant

Seller's description

This invoice template fills itself in from your hours log. Track time by client and project. Pick a client and a date range, and the invoice is built for you. Then record what's been paid and what's overdue. It's made for freelancers, consultants and contractors who bill by the hour. It works in Excel and Google Sheets.

WHAT IT DOES
- Time Log: one row per block of work, with date, client, project (optional), description, hours, and billable yes/no. Rate and amount fill in for you. Up to 2,000 rows. The Check column flags missing fields, unknown clients or projects, a project picked for the wrong client, impossible hours, and billable work with no rate.
- Rates: a default hourly rate per client, with an optional project rate that overrides it.
- Invoice: choose the client, the dates, and the invoice number and date. You get a printable invoice with your business details, the client's bill-to details, a line for each entry (date, project, description, hours, rate, amount), total hours, subtotal, an optional tax line, the total due, the due date and your payment instructions. Up to 30 lines. Print it or save it as a PDF.
- Invoice Register: record each invoice you send and when it's paid. It shows the due date, Open / Overdue / Paid, and days overdue.
- Summary: for each client, hours (billable and non-billable), billable amount, invoiced, paid and outstanding. For each project, hours against budget, highlighted at 80% and again over 100%.
- Up to 25 clients and 50 projects.

WHAT YOU GET
- 1 Excel file (.xlsx): Contractor-Hours-Invoice.xlsx
- 1 PDF with your link to make your own copy in Google Sheets, plus quick-start steps
- A built-in "Start Here" tab with instructions, and sample data you can clear in a minute

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download your file. Etsy also emails you a download link.
2. Unzip it. Google Sheets: open the PDF, click the copy link and choose "Make a copy". The copy is saved to your own Google Drive.
3. Excel: open the .xlsx file in Excel 2010 or newer.
4. Follow the Start Here tab: add your business details, clients and rates, then log your time.

GOOD TO KNOW, PLEASE READ
- It makes the invoice. It doesn't send it or take payments. Print it or save it as a PDF and send it yourself.
- The tax line is simply the rate you enter. The file doesn't work out what tax you owe or charge. It is not tax, legal or accounting advice.
- Up to 30 lines per invoice. If more entries match, it warns you, so pick a shorter date range.
- Entries aren't marked as invoiced. Use date ranges that don't overlap an earlier invoice.
- One currency ($ by default; you can change the cell format). Time entries only, no expense or materials lines.
- This is a digital download. Nothing physical will be shipped.
- Compatible with Google Sheets (needs a free Google account) and Microsoft Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- Because this is a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.

HOW THIS WAS MADE
I designed this spreadsheet with help from AI tools, which assisted with building the formulas and layout. I chose the features, and before listing it I tested every calculation against an independent check (a 22-point test plan covering rates and overrides, rounding to the cent, which entries land on the invoice, date-range edges, tax, due dates, overdue status, client and project summaries, bad log rows, and 25-client / 2,000-row capacity).