Excel Invoice Template for Cleaning Services
Cleaning is the trade with the highest invoice count and the lowest price per invoice. Forty houses on a two-week rotation is eighty documents a month, most of them identical to the last one, most of them for under two hundred dollars. Nobody is disputing them and nobody is reading them closely — which is exactly why the risk here is not billing errors. It is spending six hours a month producing paperwork for revenue that took a fraction of that to earn.
What a cleaning invoice needs that a generic template does not
The same document, over and over, at speed. If producing one invoice takes four minutes of retyping the client, the address, the service line, and the date, then eighty invoices is more than five hours. That is a full working day every month spent on data entry, and it is the single largest hidden cost in a residential cleaning business. The fix is not a faster typist. It is starting from last cycle’s invoice instead of a blank one.
Discounts are a retention tool and they need to be visible. Recurring clients get a better rate than one-offs. Weekly clients get a better rate than monthly. Refer-a-friend credits, prepaid-month discounts, first-clean promotions — these are how cleaning companies hold on to accounts, and a discount the customer cannot see on the invoice is a discount doing none of that work. Showing the standard rate and the discount separately means every invoice quietly reminds them what the relationship is worth.
Add-on services are where the margin is. The recurring clean is priced to be competitive and the margin on it is thin by design. Interior windows, oven, fridge, baseboards, garage, post-party turnaround — these are priced properly and they are what makes a route profitable. If your invoice does not separate the base service from the extras, you cannot tell which clients are actually worth having, and you have no structure for offering the extras in the first place.
Three kinds of cleaning work, three different documents
Recurring residential
Weekly, biweekly, or monthly cleans on a fixed rotation. Predictable revenue, predictable scope, and thin margin per visit. The invoice is nearly identical every cycle, which makes it the clearest case in any trade for duplicating rather than rebuilding. The real risk is silent: a house that took two hours when you priced it now takes two and a half, and nothing tells you.
Deep cleans and one-time jobs
Move-in and move-out, post-construction, spring cleaning, hoarding and estate cleanouts, post-event. Priced individually, often several times a recurring clean, and usually quoted before the work. These need a scope that is written down, because “deep clean” means something different to every customer and the gap between expectations is where the unpaid third hour comes from.
Commercial and janitorial
Offices, medical, retail, gyms. Contracted monthly against a scope of work, billed on a purchase order, and paid on terms rather than on the day. Supplies are often part of the contract, staffing is scheduled rather than ad hoc, and the client is a business that expects an invoice it can hand to accounts payable without questions.
Line items cleaning services actually bill
- Recurring service — weekly, biweekly, and monthly cleans by home size, per-visit rate, monthly contract rate
- One-time cleans — deep clean, move-in and move-out, post-construction, post-event, spring or seasonal clean
- Add-ons — interior windows, oven, refrigerator, cabinet interiors, baseboards and trim detail, blinds, garage, patio, laundry, dish service
- Labor — cleaner hourly, team rate by number of cleaners, extra hour beyond scope, weekend or holiday premium
- Commercial — monthly janitorial contract, per-visit office cleaning, restroom service, floor care and buffing, carpet extraction, supply restocking
- Discounts and credits — recurring client rate, prepaid month, referral credit, first-clean promotion, multi-service bundle
The services barely change from client to client. What changes is which combination each one gets, which is why having them saved as priced items matters more here than in trades with fifty parts — you are assembling the same six lines in different arrangements eighty times a month.
What a recurring residential invoice looks like
A biweekly client’s monthly invoice, two visits plus one add-on, with the recurring-client discount shown. 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 |
|---|---|---|---|---|---|---|
| Biweekly clean — 3 bed / 2 bath (7/08, 7/22) | 2 | 165.00 | 330.00 | ☐ | 108.00 | 114.00 |
| Interior windows — main floor | 1 | 85.00 | 85.00 | ☐ | 34.00 | 51.00 |
| Refrigerator interior detail | 1 | 45.00 | 45.00 | ☐ | 16.00 | 29.00 |
| Subtotal | 460.00 | — | 266.00 | 194.00 | ||
| Discount — recurring client rate | -30.00 | — | — | — | ||
| Total | 430.00 | Profit $164 (38.1%) | ||||
Service dates 7/08 and 7/22. Standard scope: kitchen, baths, living areas, bedrooms, floors, dusting, trash. Add-ons performed 7/22. Recurring client discount applied. Payment due on receipt; card on file charged 3 business days after invoice date.
Look at the two add-ons. They came to $130 of the $460 and carried $80 of the $194 in margin — more than 40 percent of the profit on under a third of the revenue. The recurring clean is what keeps the client; the add-ons are what make the route worth running. That is not visible on the customer’s copy and it is not visible on any invoice that lumps everything into one service line. The discount is deliberately on its own row, where the client sees it every cycle.
Where the template approach breaks down
This is the trade where template overhead is worst, because the cost is multiplied by volume.
Eighty invoices a month, each one a copied file with the name and dates changed by hand. Addresses retyped and occasionally typed wrong. A rate set eighteen months ago on a house that has since had a dog and a baby added to it, still billing the same number. Add-ons that were performed and never made it onto the invoice. And at the end of a year, no way to answer which clients are profitable, which routes are eroding, or whether the commercial accounts are actually worth the early mornings — because the answer is in a thousand separate 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 and add-ons, so this cycle’s invoices start from last cycle’s — duplicate, adjust the dates, send. It tracks what has been paid and what is overdue across every account, and shows cost and profit on every line, so a house that has quietly stopped being worth the drive does not stay hidden for another year.
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 →
★★★★★
“Fantastic work from David. Right from the start David took a consultative approach to this project and completed it within 24 hours with no changes needed. I would recommend Excel Gurus for any excel related projects.”
Glen F. · via PeoplePerHour, 2017
5.0★ across 230+ client reviews · 100% Job Success on Upwork · Building Excel tools since 2010 · Read the reviews →