Bookkeeping and P&L Spreadsheet for Lawn Care Businesses

Lawn care is seasonal: mowing routes, fertiliser programmes, spring and fall clean-ups and sometimes snow, with fuel, crew and equipment repairs swinging with the weather. You need monthly profit and per-visit costs to price next season properly.

This workbook is set up for lawn care businesses. It has 7 income categories (Mowing contracts, Fertilisation & weed control, Spring & fall clean-ups, Aeration & overseeding, Landscaping & mulch installs, Hedge & shrub trimming, Snow removal) and 11 expense categories (Fuel (mowers & truck), Equipment purchases, Equipment repairs & blades, Fertiliser, seed & chemicals, Mulch & landscape materials, Crew wages, Truck & trailer costs, Disposal & dump fees, Licences & insurance, Routing & invoicing software, Advertising), each with a note on what goes there, plus spare lines for your own. Fees kept by your card processor or platform are entered next to each sale and reported as their own expense line (card & invoicing-app fees).

The Monthly P&L totals every category by month, then shows net profit, margin, a tax set-aside at the rate you choose and your monthly property visits. The Dashboard compares any month with the year to date and tracks 6 trade KPIs against your targets: revenue per property visit; fuel cost per visit; crew labour % of revenue; materials % of treatment & install revenue; mowing contract share of revenue; equipment repairs % of revenue. The Annual Summary gives quarterly totals, your best month, the largest cost and the receipts still missing.

Included: a worked-example copy filled with a fictional lawn care business year, a blank copy, and a 6-page quick-start guide in US Letter and A4 (category map, KPI guide, worked example, tips for the trade). 7 sheets, 6,731 formulas, room for 1,000 income and 1,500 expense entries a year.

General information, not tax or accounting advice.