Landscaping Business Bookkeeping Spreadsheet

About this template

This landscaping bookkeeping spreadsheet puts a weekly round and larger project work into the same books. It suits gardeners, landscapers and lawn care business owners who want a clear profit and loss without paying for accounting software.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

Materials, on-charged or absorbed

Materials you pass on to the client are tracked separately from materials you absorb yourself. That split is where many garden jobs quietly lose money, and here it is visible on every line.

How the books fit together

You record money in on the Income tab and money out on the Expenses tab, choosing a tax rate on each line. Everything else reads those two registers: the monthly and quarterly views, the profit and loss statement, the sales tax worksheet and the dashboard. Nothing is entered twice, so the reports always agree with the ledger.

16 connected tabs

Every tab below works from the same two registers, so it doubles as an income tracker and an expense tracker for the year:

• Income: 500 rows, with the tax split out on every line
• Expenses: 500 rows, split the same way
• Setup: your categories, your tax rates and your set-aside percentage
• Monthly, Quarterly and Profit & Loss: all calculated, nothing typed
• Sales Tax: collected against paid, by rate and by quarter
• Estimated Tax: four quarterly set-asides at your own rate
• Custom Range: pick any two dates and every figure follows
• Comparison: this year against last, month by month
• Balances: what each account took in and paid out
• Dashboard: six live figures and the four quarters
• Start Here: setup in a few minutes

Real files, filled and blank

You get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled with a worked example and each blank and ready for your own numbers. The filled copy is the file in the photos, with two full years of demo data so the Comparison tab has something real to compare.

It is a straightforward small business ledger: no invoicing software to learn, and the Start Here tab shows you where to begin.

Works with

• Microsoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.
• Google Sheets with a free Google account. No Google account is needed for the Excel files.
• No add-ins, no macros, no subscription and no bank connection

What you download

• The Excel workbook filled with a worked example, and the same workbook blank and ready for yours
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for use in your own business; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Can I use it in Google Sheets instead of Excel?

Yes. The download includes Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own Google Sheets copy with a free Google account.

How does it handle materials I charge back to the client?

On-charged materials are tracked separately from materials you absorb, so you can see where a job is losing money on materials.

Can I see a single quarter or a custom period?

Yes. The Quarterly tab shows each quarter, and the Custom Range tab recalculates everything for any two dates you choose.

Does it set money aside for tax?

The Estimated Tax tab works out four quarterly set-asides at the rate you enter on Setup. It does not tell you what rate to use.

Do I need Microsoft 365?

No. It runs on Excel 2016, 2019, 2021 or 365 and on LibreOffice, with no macros or add-ins.