Excel Invoice Template for Landscaping
Landscaping bills in two completely different rhythms, and most invoice templates only understand one of them. There is the maintenance side, where the same forty customers get the same invoice on the same day every month, and the work is measuring your time against a price you set last spring. And there is the install side, where one customer gets a four-thousand-dollar quote for a patio and plantings, pays a deposit, and the job runs three weeks. One document format cannot do both well.
What a landscaping invoice needs that a generic template does not
The same invoice, forty times, every month. This is the defining problem of maintenance work. If producing one monthly invoice takes five minutes of retyping the customer, the address, and the standard service line, then invoicing day costs you three and a half hours. Multiply that by twelve months. The fix is not typing faster, it is having last month’s document as a starting point instead of a blank sheet.
Seasonal work arrives on top of the recurring line. The monthly maintenance invoice is predictable until March, when it also has spring cleanup on it, or November, when it has leaf removal and irrigation blowout. Those extras need to sit alongside the contract amount without making the customer think their monthly rate went up. Labeling matters more than it sounds like it does.
A crew hour is not a labor hour. Landscaping runs crews, and a three-person crew on a property for ninety minutes is four and a half labor hours. If your invoice thinks in hours but your cost thinks in crew time, the two never reconcile, and you end up guessing whether a route is profitable. Worse, mowing routes fail slowly: a property that took forty minutes in April takes fifty-five by July, at the same monthly price, and nothing tells you.
Three kinds of landscaping work, three different documents
Recurring maintenance
Mowing, edging, blowing, bed maintenance, shrub trimming. Billed monthly at a flat contract rate regardless of how many visits fell in that month, or per-visit for smaller accounts. The customer barely reads these after the first one, which is exactly why the risk here is not disputes — it is silent margin erosion on a route you have not repriced in two years.
Seasonal and one-off services
Spring and fall cleanups, aeration and overseeding, mulch installation, irrigation startup and winterization, storm cleanup, tree and shrub work. Some of these go to existing maintenance customers as an addition to the monthly invoice, some go to people who only ever call you once a year. Both need pricing that holds up, because a mulch job quoted from memory is a mulch job that loses money on delivery.
Design and installation
Patios, retaining walls, planting beds, sod, irrigation systems, lighting, drainage. These are quoted before the work, often at several thousand dollars, and the customer is comparing your proposal against one or two others. Money moves in stages — deposit, progress, final — and material is a real cost that has to be tracked, because plant material and hardscape both have losses that a quote does not anticipate.
Line items landscaping companies actually bill
- Recurring maintenance — monthly maintenance contract, per-visit mowing by property size, bed maintenance, shrub and hedge trimming, seasonal color rotation
- Crew time — two-person crew hour, three-person crew hour, foreman or operator rate, equipment time for skid steer, aerator, stump grinder
- Seasonal services — spring cleanup, fall cleanup, leaf removal, aeration, overseeding, dethatching, mulch install by yard, pre-emergent and fertilizer applications
- Irrigation — spring startup and inspection, winterization and blowout, head and nozzle replacement, valve and controller repair, zone troubleshooting
- Materials — mulch and soil by yard, sod by pallet or square foot, plant material, hardscape block and pavers, base and sand, edging, irrigation parts
- Disposal and hauling — debris haul-off, dump fees, storm debris removal
Maintenance is where saved pricing pays for itself twice. Once because you are not retyping the same six lines forty times a month, and once because when fuel or labor moves you can see every account that is priced against the old numbers.
What a monthly maintenance invoice looks like
A residential account in November — the standard contract line plus the seasonal work that only happens once. The four columns on the left are what the customer receives. The three on the right stay in your workbook and never print.
| Description | Qty | Price | Amount | Taxable | Cost | Margin |
|---|---|---|---|---|---|---|
| Monthly maintenance contract — November | 1 | 240.00 | 240.00 | ☐ | 168.00 | 72.00 |
| Fall cleanup — leaf removal, bed clearing | 1 | 385.00 | 385.00 | ☐ | 210.00 | 175.00 |
| Irrigation winterization — 6 zones | 1 | 125.00 | 125.00 | ☐ | 48.00 | 77.00 |
| Mulch install — shredded hardwood | 4 | 78.00 | 312.00 | ☑ | 42.00 | 144.00 |
| Debris haul-off and dump fee | 1 | 95.00 | 95.00 | ☐ | 62.00 | 33.00 |
| Subtotal | 1,157.00 | — | 656.00 | 501.00 | ||
| Tax (6.5%, taxable lines only) | 20.28 | — | — | — | ||
| Total | 1,177.28 | Profit $501 (43.3%) | ||||
November service: 3 mowing visits, bed maintenance, shrub trim. Fall cleanup completed 11/14 — 2-person crew, 5 hrs. Irrigation system blown out and controller set to off. 4 yds hardwood mulch installed in front and side beds.
The two right-hand columns are worth a moment. The maintenance contract cleared 30 percent; the winterization cleared 62. Both are fine numbers, but they are not the same number, and the only reason you know that is that the cost is sitting next to each line. Do that across a season and you can see which parts of the business are carrying the rest — and which routes have quietly stopped working. The customer’s copy is the four columns on the left; none of this prints.
Where the template approach breaks down
Maintenance billing is the clearest case against templates in any trade, because the inefficiency repeats on a schedule.
Forty invoices, every month, each one rebuilt from a file you copied and renamed. Customer details retyped or copy-pasted wrong. A price you set two seasons ago that nobody has revisited because there is nothing to revisit it in. An install quoted in April, accepted in May, and rebuilt by hand as an invoice in June. A deposit that exists only in your memory until the final invoice, when you have to work out what is still owed. And in January, when you want to know what maintenance actually earned versus install work, the answer is in five hundred files.
What we built instead
EG Quote & Invoice is a macro-enabled Excel workbook that turns Excel into an actual quoting and invoicing application. It keeps a client list and a priced catalog of your services, so next month’s forty invoices start from last month’s rather than from nothing — duplicate, adjust, send. It converts a won install quote into an invoice in one click, records deposits and progress payments against it, and shows your margin on every line so a route that has stopped working does not stay hidden.
It runs on your own PC. No account, no cloud, no subscription. The free edition has no limit on how many quotes or invoices you create and does not expire.
See EG Quote & InvoiceFree edition · Windows Excel · 32-bit and 64-bit
Other trades: Browse all invoice templates by trade →
★★★★★
“Excellent in every way. Saved me so much time with his automation of my spreadsheets!”
Karyn M. · repeat client · via PeoplePerHour, 2011
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →