Know exactly who owes you what.
Log your hours by client and the amounts work themselves out. Invoices add up your hours, and anything unpaid, due soon or overdue is flagged. No macros.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Date | Client | Start | Finish | Hours | Amount | Status |
|---|---|---|---|---|---|---|
| Mon 14 Sep | Harbor Coffee | 08:00 | 12:00 | 4.00 | $180.00 | Invoiced |
| Wed 23 Sep | Brightside | 09:00 | 12:30 | 3.50 | $227.50 | Unbilled |
| Thu 24 Sep | Oak & Pine | 09:00 | 17:30 | 7.50 | $412.50 | Unbilled |
| Sat 26 Sep | Northfield | 14:00 | 16:00 | 2.00 | $100.00 | Unbilled |
| Mon 28 Sep | Harbor Coffee | 22:00 | 01:30 | 3.50 | $157.50 | Unbilled |
Freelancing is hard enough without chasing money
Hours on scraps of paper
Notes, calendars and memory don’t add up to an accurate invoice.
Forgetting to bill work
A couple of hours here and there, never invoiced, adds up to real money over a year.
Awkward chasing
Without a clear list, it’s hard to know which invoices are late and by how much.
Log your time. The invoices follow.
Add your clients
Each one can have their own hourly rate and payment terms, or use your defaults.
Log your hours
Date, client and a start and finish time (or just the hours). The rate and amount fill themselves in.
Invoice and get paid
Give an invoice a number and tag the hours it covers. The total adds up, and it tells you when it’s due or overdue.
See what’s overdue at a glance
Every invoice gets a due date from the client’s payment terms. Unpaid invoices show Awaiting payment, Due soon or Overdue, and overdue ones are tinted red. Type the date paid and it turns green.
- Totals added up from your logged hours
- Other costs and sales tax or VAT
- Payment terms per client
| Invoice # | Client | Total | Due | Status |
|---|---|---|---|---|
| INV-001 | Brightside | $1,007.50 | 11 Sep | Paid |
| INV-002 | Oak & Pine | $685.00 | 19 Sep | Overdue |
| INV-003 | Northfield | $450.00 | 02 Oct | Due soon |
| INV-004 | Harbor Coffee | $292.50 | 08 Oct | Awaiting payment |
| INV-005 | Brightside | $552.50 | 05 Oct | Paid |
Every client’s rate, hours and balance
Give each client their own rate and terms. The Clients tab adds up their hours, the work you’ve done, what’s been invoiced, what’s been paid, and what they still owe you.
- Hourly rate per client, or your default
- Hours, work done, invoiced and paid
- Work not yet invoiced, so nothing slips
| Client | Rate | Hours | Work done | Owed to you |
|---|---|---|---|---|
| Brightside Marketing | $65 | 27.50 | $1,787.50 | $227.50 |
| Oak & Pine Studio | $55 | 19.50 | $1,072.50 | $1,097.50 |
| Northfield Dental | default $50 | 11.25 | $550.00 | $550.00 |
| Harbor Coffee Co | $45 | 10.00 | $450.00 | $450.00 |
Your business in one page
See the work you haven’t invoiced yet, what you’re waiting to be paid, what’s overdue and what you’ve been paid this year, plus unpaid invoices by due date and a month-by-month chart.
- 4 key numbers at the top
- Unpaid invoices by due date
- Work done vs paid in, by month
| Month | Hours | Work done | Paid in |
|---|---|---|---|
| Jul | |||
| Aug | 36.8 | $2,118 | |
| Sep | 31.5 | $1,743 | $1,560 |
| Oct |
For anyone who bills by the hour
Freelancers
Designers, writers, developers, VAs and consultants tracking time across several clients.
Contractors & tradespeople
Hours on each job, with invoices and payment dates in one place.
Tutors & coaches
Sessions logged by client, with what each family or client still owes.
Everything you get
- Room for 500 time entries, 200 invoices and 30 clients
- Hours from start and finish times, night work included
- Rate per client or your default rate
- Billable and not-billable work
- Invoices that add up the hours tagged to them
- Due dates from payment terms, with Overdue and Due soon warnings
- Other costs and sales tax or VAT
- Clients tab: hours, work done, invoiced, paid and owed
- Dashboard with key numbers, unpaid invoices and a monthly chart
One-off payment. Yours to keep.
Get instant access $12.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.
This log uses the same time formulas as my timesheet tutorials, plus SUMIF by client, to take the admin out of freelancing.
Questions
Does it create the invoice document?
No. It tracks your invoices, what they add up to and whether they’ve been paid. Use it alongside the invoices you send.
Can each client have a different rate?
Yes. Set a rate per client on the Clients tab, or leave it blank to use your default.
What if I work past midnight?
Times like 22:00 to 01:30 work out correctly.
Can I add sales tax or VAT?
Yes. Set your rate on the Settings tab and it’s added to every invoice. Leave it at 0% if you don’t charge it.
Does it use macros?
No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Is this a subscription?
No. You pay once and the file is yours to keep.
Get paid for every hour you work.
Hours, clients, invoices and overdue warnings, all in one simple spreadsheet.
Get the log $12.99Not ready yet? Try the free Freelance Hours Log.