The Wash Book was built inside a working fleet wash company, to replace the setup most of them start with: the schedule in one place, the units on paper or in a text, a rate sheet, a weekly numbers sheet assembled by hand, and invoices typed into QuickBooks from all of the above. It works, until the company grows and keeping it true becomes a second job.
Signs you have outgrown the spreadsheet
- The same fact is typed more than once. The crew text the units, someone types them into the sheet, someone else types them into the invoice. Every retyping is time and a chance to get it wrong.
- Invoicing takes a day. Friday (or Monday) disappears into matching logged units to rate sheets and building invoices one yard at a time.
- Only one person understands the workbook. When they are on vacation, the invoices wait.
- The crew cannot see what they need. Gate codes, contacts, excluded units and last month's complaint live in the office's head or a file the crew cannot open on a phone, or can open and see the prices too.
- The weekly numbers are a month late, because assembling them is an evening nobody has.
- Two versions disagree. The schedule says a yard was washed; the log does not; the invoice says something else.
What fleet wash software should actually do
General field-service software is built around jobs at addresses: one technician, one visit, one invoice. Fleet washing is different. A yard has a roster of units, a rate per unit type, a weekly or biweekly pattern, add-ons on their own cycles, crews of two or three, and a weekly invoice per yard listing units by number. Software for it should:
- Keep one record. The scheduled visit, the units logged, the invoice line and the weekly numbers should all be the same data, not copies of each other.
- Work on the crew's phone at the stop: a roster to tap units off, the yard's notes at the gate, add-ons that must be answered, and no prices on screen.
- Build the invoices from the log and the rate card, weekly, and send them to your accounting system after you have read them.
- Compute the numbers: revenue by the week worked, units, revenue per unit, minutes per unit. See the weekly numbers every fleet wash business should know.
- Hold quality and people to a standard: inspections scored per unit, conduct kept on its own record, hours clocked from the phone.
- Let you leave. Export everything, any time, in a format you can open.
How to switch without losing your history
- Start with the yards and rate cards. They are the backbone; everything else hangs off them.
- Bring in your units and your schedule from the workbook you already have, rather than retyping.
- Import your past weekly numbers so the trend line starts a year back, not on the day you switched.
- Run one or two routes on it first, in parallel with the old way for a week or two, and check the invoices match.
- Then move the crew. The crew phone is where the time savings come from; the office benefits only once the units arrive logged.
When to stay on the spreadsheet
If you run one truck, wash a handful of yards, and invoicing takes an hour a week, a good spreadsheet may be all you need. Software earns its cost when the retyping, the reconciling and the missing numbers start costing you hours or revenue every week.
How The Wash Book does it
The Wash Book imports from one workbook: people, trucks, accounts, contacts, yards, units, equipment, wash history, schedules and pipeline, with a plan of what will be created and updated, and every row it could not read listed with the reason, before anything is written. Re-uploading a corrected file updates rather than duplicates. You can export the same workbook, or a complete copy of every record, any time. The Basic plan covers three users, crew included; there is a 14-day free trial with no card.