Products / Contractor Job Books
See what each job quoted, cost and paid.
List each job with its quoted price. Log every cost against a job and a category, and every payment a client makes. The Job summary shows the money received, the costs by category, gross profit and margin for each job, and turns red when costs are above the quote.
Who it's for
Owners of renovation, remodeling and handyman businesses with 1 to 10 people who want one book for what each job quoted, cost and paid.
It holds records and arithmetic only. It has no contract, lien or change-order wording and gives no licensing guidance.
A look at the actual file

What's inside
Six tabs, in this order. A Quick Start PDF is in the zip.
| Tab | What it does |
|---|---|
| Start here | Five setup steps, a colour key, the disclaimer and a checks line. |
| Jobs | One row per job: Job ID, Client, Address, Quoted price, Status, Start, End and Notes. Room for 50 jobs. |
| Costs | Date, Job, Category (Materials, Labor, Subcontractor, Permit, Equipment or Other), Vendor or worker, Amount, Receipt ref and Note. The client's name fills itself. Room for 2,000 rows. |
| Payments | Date, Job, Amount, Method and Reference or note for each payment a client makes. The client's name fills itself. Room for 1,000 rows. |
| Job summary | For each job: quoted price, received, still to receive, costs by category, total costs, gross profit, margin and received less costs. Red when costs are above the quote. A Checks block at the bottom says if a cost or payment is not reaching a job. |
| Monthly overview | For the year you type: money received, costs paid, received less costs, costs by category and jobs started for each month, with a chart. |
A look at the file
| Job ID | Client | Quoted price | Received | Materials | Labor | Subcontractor | Permit | Equipment | Total costs | Gross profit | Margin |
|---|---|---|---|---|---|---|---|---|---|---|---|
| J-001 | R. Holloway (example) | 14,800.00 | 14,800.00 | 8,562.35 | 4,200.00 | 1,250.00 | 185.00 | 160.00 | 14,357.35 | 442.65 | 3.0% |
| J-002 | M. Park (example) | 9,600.00 | 9,600.00 | 2,982.40 | 3,000.00 | 2,150.00 | 140.00 | 95.00 | 8,367.40 | 1,232.60 | 12.8% |
| J-003 | S. Delgado (example) | 7,200.00 | 7,200.00 | 3,120.00 | 2,600.00 | 1,500.00 | 220.00 | 100.00 | 7,540.00 | (340.00) | -4.7% |
Gross profit is the quoted price less total costs. The third job went over its quote, so its profit and margin are negative and the row turns red in the file.
Format
- File
- 1 Excel workbook (.xlsx), 6 tabs, and a Quick Start PDF
- Software
- Microsoft Excel. Designed to open in Google Sheets.
- Limits
- 50 jobs, 2,000 cost rows and 1,000 payment rows. Six example jobs are included, marked (example), and step 1 on the Start here tab clears them.
- Delivery
- Instant download after purchase. Nothing is shipped.
- Price
- US$17.99, one-time. Launch price until 15 Nov, then US$24.99. No subscription.
What it does not do
- It does not make quotes, invoices, contracts or change orders.
- It does not track hours or connect to a bank.
- It holds no contract, lien or licensing wording and gives no tax guidance.
Questions
Which version of Excel do I need?
Excel 2010 or later on Windows, Excel 2016 or later on Mac, or Excel for the web. We checked every formula in this workbook against the version of Excel that first supported it: the newest thing it uses arrived in Excel 2007, so it needs no Microsoft 365 subscription. There is nothing in it that only newer Excel can run, such as XLOOKUP, LET, IFS or TEXTJOIN, and there are no macros or add-ons. Excel 2003 and earlier are not supported.
The totals look blank when I open it. What is wrong?
Nothing. Excel opens a downloaded file in Protected View and does not calculate until you click Enable Editing. The figures appear as soon as you do.
Does it work on a Mac?
Yes, in Excel for Mac. There are no macros, so nothing in the file is Windows-only. It is also designed to open in Google Sheets in a browser.
Can I use it in Google Sheets?
The workbook is made in Excel and designed to open in Google Sheets: upload it to Drive and open it with Google Sheets. It uses no macros, scripts or add-ons. If something does not work as described there, email hello@goodcolumns.com and we fix it or refund you.
What if I want a refund?
No change-of-mind refunds on digital files. If a file is faulty or not as described, email hello@goodcolumns.com within 30 days and we fix it or refund you.
Is this tax, legal or financial advice?
No. It holds records and arithmetic only: quotes, costs, payments and the profit that follows. It has no contract, lien or licensing wording, and your tax preparer decides how anything is reported.
The small print
Good Columns templates help you organise records. They are not tax, legal, accounting or financial advice, are not endorsed by the IRS or any government body, and may not suit your situation. You are responsible for the figures you enter.
Licence: use within your own business; no resale or redistribution.
No change-of-mind refunds on digital files. If a file is faulty or not as described, we fix it or refund you.
Full terms: Terms and refunds.