Contractor Work Hours Ledger | Quoted vs Actual Labor Timesheet (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.

A trip to the site is a flat charge. Time spent on a bid is yours. Hours on the job run against the hours you quoted.

That is how the Contractor Work Hours Ledger comes set up. Before you pack up the site, log it in-the-moment on the "Log Work" form — date, job, kind of work, hours as 1.5 or 1:30, and a note. The sheet prices it from there: Labor and Material runs at the hourly rate, rounded up to the half hour; a Site visit as one flat trip charge; an Estimate/bid on the record, billed to no one.

Put the hours you quoted on each job. Logged labor fills a bar against that quote, and any hours past it show as the overrun.

✓ KEY FEATURES:
• Quoted hours on every job, with logged hours set against the quote and the overrun shown
• Site visit priced as a flat charge per visit — a trip charge, whatever the hours
• Estimate/bid time kept on the record and never billed
• Labor and Material run priced by the hour, rounded up to the half hour
• Each job names its client and its labor rate; a rate set on a kind of work wins wherever you log it
• The rate is stamped on each entry as you log it — raise your rate next season and finished jobs keep theirs
• Hours, billed and unbilled amounts and effective $/hr for the year
• Each client's month at a glance, plus labor, trips and bid time totaled by kind of work
• Kinds of work, rates and billable settings all yours to edit on Customize Forms
• An Invoice Summary tab for any client, job and date range, with Unbilled only for the open work
• Bill-to block, labor and trip lines, totals and your payment instructions — print it or save a PDF from Google Sheets
• From your custom Ledger & Light menu, mark the shown entries invoiced; they carry today's date from then on
• Works on any device with a free Google account

✓ WHAT YOU GET:
• Your Contractor 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 Contractor Work Hours Ledger (link in the PDF) and click Make a Copy into your Drive
3. Enter your jobs, the hours you quoted and your labor rate, then log every job day in-the-moment

✓ MADE FOR:
• Remodelers, handymen, electricians, plumbers, painters and other trades who bill labor by the hour
• Contractors who charge a flat trip fee for a site visit
• Anyone who quotes hours on a job and wants to see the overrun before the job is done

Your instruction PDF is available immediately after purchase.

Your Contractor 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.