Excel Invoice Template for Painters

Painting has the widest gap in the trades between what the customer thinks they are buying and what the work actually is. They are picturing color on a wall. You are pricing masking, caulking, patching, priming, two coats, cut lines around forty feet of trim, and two days of drying time you cannot compress. When the quote comes back higher than they expected, the difference is almost always prep — which is invisible in the finished result and most of the labor in the job.

What a painting invoice needs that a generic template does not

Three kinds of painting job, three different documents

Interior repaints

Rooms, ceilings, trim, doors, cabinets. Usually quoted by room or by surface, occupied by people who live there, and heavily dependent on prep condition — a wall with three patches and a wall with thirty are the same square footage and not the same job. The quote needs to state what condition it assumes, because that is where change orders come from.

Exterior work

Siding, trim, soffits, fascia, decks and fences, pressure washing. Weather-dependent, height-dependent, and prep-heavy — scraping, sanding, priming bare wood, replacing failed caulk. Exterior quotes carry more risk than interior ones because you cannot fully see the substrate until you are on the ladder, and the invoice sometimes has to reflect what was actually found.

Commercial and property work

Offices, rentals between tenants, common areas, apartment turns. This work is repetitive, scheduled, and often billed against a purchase order rather than a homeowner’s credit card. Volume matters more than margin per job, turnaround time is the thing being bought, and the buyer usually wants a single number per unit rather than a surface-by-surface breakdown.

Line items painters actually bill

• Prep — surface cleaning and degreasing, pressure washing, scraping, sanding, patching by size, caulking, masking and floor protection, wallpaper removal
• Priming — spot prime, full prime, stain-blocking primer, bare wood or masonry primer
• Interior finish — walls by coat, ceilings, trim and baseboard by linear foot, doors and door frames, closets, cabinets and built-ins
• Exterior finish — siding by square foot, trim and fascia, soffits, shutters, decks and railings, fences, garage and entry doors
• Labor — painter hourly, two-person crew rate, height or ladder work, weekend or after-hours for occupied commercial space
• Materials — paint by product line and sheen, primer, caulk, patching compound, masking and drop cloths, sundries

Painting prices move with product cost more than most trades, and the paint you quoted last spring is not the price you pay this spring. Saved pricing means you can see every service line still built on old material costs instead of finding out one job at a time.

What an interior repaint quote looks like

A two-room interior repaint with trim, priced by surface. The four columns on the left are what the customer receives. The three on the right stay in your workbook and never print.

Living room and dining room. Walls two coats eggshell, ceilings one coat flat, trim and baseboard semi-gloss. Quote assumes existing surfaces in sound condition; wall repair beyond normal patching quoted separately. Furniture moved to room center and covered by us.

Notice how much of the money is above the paint. Prep, masking, and priming come to $965 before a single finish coat, which is exactly the part a customer does not picture and exactly why the itemized version of this quote closes better than a one-line version. The green profit figure and the cost column beside each line stay in your workbook — the customer’s copy is the four columns on the left.

When you want the opposite: one number, no breakdown

The same job for a property manager doing six apartment turns does not need any of that detail. They want a price per unit and a date. Itemizing seven lines per apartment makes the document worse for the person reading it and slower for you to produce.

So the useful version is being able to switch: keep the line detail for your own pricing and margin, and print the customer a single contract figure. Same job, same underlying numbers, a document shaped for whoever is receiving it.

Where the template approach breaks down

A blank template gives you a grid and no opinion about any of this.

Your per-square-foot rates live in your head and drift. Paint costs move and nothing tells you which quotes are still built on last year’s number. A repaint quoted in April becomes an invoice in May and the whole document gets rebuilt by hand. The repeat customer who had the living room done last year gets their address retyped. And at the end of a season, the question of whether interior or exterior work actually pays better has no answer, because it is spread across two hundred files.

Other trades: Browse all invoice templates by trade →