Freelancer Work Hours Ledger | Timesheet with Client Rates (Google Sheets)

Form to sheet: log it in-the-moment on a Google Form on your phone, and the entry lands organized in your Google Sheet. No app, no re-typing. That's how every Ledger & Light tool works.

Every hour you put into a client's project becomes a priced line in one record.

Log it in-the-moment from the "Log Work" form on your phone: the date, the project, the kind of work, the hours (1.5 or 1:30) and a note. Each project already knows its client and its rate, so your Freelancer Work Hours Ledger prices the entry, rounds billable time up to the quarter hour, and adds it to that client's running total.

Give a project an hours budget and the Dashboard draws a bar of the hours used against it, with the hours left or the hours over. Unbilled amounts stay in view until you mark them invoiced, and Admin time stays on the record without ever reaching a client's bill.

✓ KEY FEATURES:
• Hours priced by project — each project carries its client and its hourly rate
• An hours budget per project, drawn as a bar with hours left or hours over
• Unbilled amount, billable amount, hours this year and effective $/hr on the Dashboard
• This month by client, and the year's hours by kind of work
• A rate set on a kind of work wins wherever it is logged; leave it blank and the project's rate applies
• Every entry keeps the rate it was logged at, so a later rate change leaves past work as it was
• Kinds of work ready to edit: Client work, Meetings and Revisions billable, Admin logged but not billable
• Billable rounding on Setup: none, a tenth of an hour, a quarter hour or a half hour
• Billing day on the Invoice Summary tab: pick the client, narrow it to one project if needed, set From and To, and tick Unbilled only
• Each client's bill-to block above the line items and totals, with your payment instructions underneath — print it from Google Sheets or save it as a PDF
• "Mark shown entries invoiced" in your custom Ledger & Light menu dates those rows, and the next unbilled view starts clean
• Works on any device with a free Google account

✓ WHAT YOU GET:
• Your Freelancer Work Hours Ledger for Google Sheets — your private access link arrives in your instant download
• Setup instruction PDF — delivered with your Etsy download
• A mobile-friendly "Log Work" form (opens in any browser, no app required)

✓ HOW IT WORKS:
1. Purchase — download your instruction PDF from Etsy right after checkout
2. Open your Freelancer Work Hours Ledger (link in the PDF) and click Make a Copy into your Drive
3. Add your clients, projects and rates, then log each block of client work in-the-moment

✓ MADE FOR:
• Freelance designers, writers, developers, editors and consultants who bill clients by the hour
• Anyone working across several clients and projects who wants each hour priced and totaled by client
• Freelancers who set an hours budget on a project and like to see where it stands

Your instruction PDF is available immediately after purchase.

Your Freelancer Work Hours Ledger keeps your own record of your work and the amounts it adds up to. It is not tax, legal or accounting advice, and it does not file, send or collect anything.

The spreadsheet system and formulas are my own original design; AI tools assisted with the decorative illustrations.