How Line-Item Totals Work on Estimates and Invoices
The standard formula is line amount = quantity × rate; subtotal = sum of lines; tax = subtotal × (tax rate ÷ 100); amount due = total − deposits paid. Check that chain before you send any PDF—one wrong quantity can skew an entire job when labor hours mix with lump-sum materials.
Key takeaways
- Line amount equals quantity multiplied by rate.
- Tax equals subtotal times tax rate divided by one hundred when all lines are taxable at one rate.
- Deposit equals total times deposit percent divided by one hundred when you collect an upfront percentage.
The core formula
Line amount equals quantity multiplied by rate. Subtotal equals the sum of line amounts. Tax equals subtotal times tax rate divided by one hundred when all lines are taxable at one rate. Total equals subtotal plus tax.
Deposit equals total times deposit percent divided by one hundred when you collect an upfront percentage. Amount due on an invoice equals total minus amount already paid.
When a line uses lump sum, set quantity to one and put the full price in the rate column so the math chain stays consistent in spreadsheets and generators.
Mixed units and lump sums
Labor may be hourly while materials are lump sum and flooring is per square foot. The math is the same per line; only the unit label changes. Do not put a full package price in the rate column and also set quantity above one unless you mean multiple packages.
Label tax-exempt lines when your state exempts certain labor or products. Generators may apply one rate to the subtotal you enter; adjust lines before export if you need split tax.
Rounding and client-facing PDFs
Round money to cents on the PDF your client sees. Tiny floating-point differences in spreadsheets should not change the printed total. If your tool shows extended amounts per line, verify each line equals quantity times rate before trusting the subtotal.
When deposit percent produces fractional cents, round deposit to cents and state that the final invoice reconciles any penny difference.
Deposits vs partial payments
A deposit line on an estimate is informational until you invoice it. On an invoice, move paid amounts into amount paid so balance due reflects reality. Multiple partial payments sum into amount paid.
Receipts document each payment event without replacing running balance on the next invoice.
When a client pays deposit by check and progress by card, amount paid should show both methods on the final invoice or attach two receipts—AP teams reject vague paid in full with no trail.
Worked example: remodel subtotal
Three lines: twenty-four hours labor at seventy-five dollars equals eighteen hundred dollars; materials lump sum forty-two hundred dollars; flooring two hundred twenty square feet at two dollars fifty equals five hundred fifty dollars. Subtotal six thousand five hundred fifty dollars. Tax at eight point three one percent equals about five hundred forty-four dollars thirty-one cents. Total about seven thousand ninety-four dollars thirty-one cents.
Thirty percent deposit is about two thousand one hundred twenty-eight dollars twenty-nine cents. Change any rate in the construction estimate generator and the live preview recalculates the same way.
Formula reference
Keep this table near your desk when training new office staff.
Line-item math chain
| Step | Formula | Notes |
|---|---|---|
| Line total | Qty × rate | One row at a time |
| Subtotal | Sum of line totals | Before tax |
| Tax | Subtotal × rate% | Confirm exempt lines |
| Grand total | Subtotal + tax | What client owes if nothing paid |
| Deposit | Total × deposit% | Often on estimates |
| Balance due | Total − paid | On invoices after payments |
Teaching crews and clients the same math
Field staff who understand quantity times rate catch typos before clients do. Post a one-page cheat sheet near the office printer with your standard tax rate and deposit percent.
When clients ask why the total changed, walk them line by line rather than debating the bottom number. Export PDFs from the same generator for estimates and invoices so formatting stays familiar. If you import CSV from suppliers, round only at the line level you show the client to avoid penny drift.
Retainage and holdbacks
Commercial construction sometimes shows retainage withheld from each progress invoice. Amount due may be line total minus retainage percent until substantial completion. Your generator may show amount paid including retainage tracked off-document in your ledger.
Explain retainage in cover email so clients do not think you forgot to bill the last ten percent.
Shipping and fees as lines
Freight and rush fees should be their own lines with quantity one and a lump rate so clients see them before tax. Bundling freight into material lines hides margin and complicates change orders when delivery fails.
Discount lines work best as negative amounts with a label like loyalty credit so subtotal math stays transparent.
Checking math before export
Sort lines by dollar amount and verify the top three manually each time you send a large PDF. Typos in quantity—twenty instead of two—hide until the client pays.
When you import supplier CSVs, confirm unit of measure matches your template. Sheets sold by the box should not use per-sheet rates without converting units.
FAQ
Should labor and materials be separate lines?
Yes when tax treatment or client comparison benefits. Separation also makes change orders clearer when material cost swings. Combined lines are fine for small residential jobs when your accountant treats the package as one taxable total.
Does the generator file my taxes?
No. It multiplies and sums the numbers you enter. Confirm rates with your accountant or local rules.
What if tax rates change mid-project?
Use the rate effective on invoice date for billed work. Note the rate on each PDF.
Can I discount after subtotal?
Apply discounts as negative lines or adjust subtotal before tax per your accountant's preference. Be consistent across jobs.
Why does my spreadsheet total differ by a penny?
Rounding order matters. Round per line or per total consistently with your generator settings.
How do I show multiple tax rates?
Split lines by rate or show separate subtotals per jurisdiction if your generator supports one rate at a time. Manual PDFs may need two tax lines labeled city and state.
What if quantity is fractional?
Hours often use decimals such as two point five. Round extended amounts to cents on the client PDF even when internal timesheets use minute precision.
How do I verify the generator total?
Spot-check one line manually, then compare subtotal to your spreadsheet sum. Fix the line with the largest dollar amount first when totals disagree.
Should I show unit prices on lump-sum lines?
Use quantity one and the lump amount as rate so extended total equals the package price. Hiding math inside description-only lines makes change orders harder to audit.