Job records

Tracing a cleaning estimate from search to paid invoice

Connect a carpet estimate to its inquiry, work order and payment, with a record of how much you actually know about the first search.

Start with a reference that the office can carry from the first inquiry into the estimate, booking and invoice. Add a separate entry for how the customer found the business and where that information came from. A paid invoice can confirm that a job produced revenue. It cannot, on its own, tell you what someone searched before picking up the phone.

Leave room for what you did not observe

Suppose a homeowner calls after looking up a company's name. The office asks how they found it. "My sister gave me your name and I looked for you online" contains two useful pieces of information. The referral introduced the business. Search helped the customer find a way to contact it. Recording just "Google" loses the introduction, while recording only "family" loses the later search. Both observations can fit in a short note.

Keep the original note separate from any category used for monthly reporting. For example, the office might categorize this as a referral and mark search as an assisting contact. Another company might track first known source and last known contact route in separate columns.

Either approach can work if a second employee can apply it consistently. Do not convert a visit to a carpet service page into an asserted search phrase. A page topic describes the page, and the route the visitor took may be unknown.

Follow one estimate through its changes

For a hypothetical residential job, imagine an inquiry for three bedrooms that becomes a quote for two bedrooms and a flight of stairs. The customer later books only the stairs and one bedroom. The original inquiry, quoted scope and booked scope are three different records of the conversation. Keep them connected under one job reference. Comparing the first request with the paid job can show whether the original estimate still describes the sale you are counting.

The reference can be the existing estimate number if the software keeps it when a new version is issued. If revisions create new numbers, record which version replaced the previous one.

An older, greater amount left in a spreadsheet can make a successful booking look more valuable than the agreed work. Keep a short revision note and show which amount the customer accepted. A canceled version should be traceable for the office without appearing as a second lost opportunity.

Decide how the office handles a second unrelated visit. A customer booking upholstery next spring can use the same customer record and a new job reference. Grouping everything under an email address alone makes the spring upholstery visit look like another stage of the first carpet estimate. At the other extreme, generating a new customer for every cleaning request obscures repeat business.

Reconcile the invoice and payment

Record the date a job was booked, the date the crew completed it, the invoice date and the date payment arrived when those dates matter to your reporting. They answer different questions. A dispatch manager planning work needs the appointment date.

Someone checking unpaid invoices needs the due and payment information already kept in the billing system. A marketing review of leads received in March may have to wait until April to see what happened to a large March estimate.

If the hypothetical customer accepts a $240 scope and pays a $60 deposit, the business has $240 of agreed work and $60 received. When the remaining $180 arrives, the collected amount reaches $240.

Counting both the accepted scope and the two payments in a single revenue total would double it. Record the components using your own bookkeeping definitions, including adjustments where applicable. Give the person doing the marketing review a clean total for the measure they requested.

A credit, refund or reduced final scope should flow back to the same job record. Consider a carpeted room the crew could not access. If the final amount changes, keep the reason where the office can explain the difference later. Leave customer identities and payment information in the systems that need them. A marketing summary can use a job reference, dates, service category, source evidence and totals.

Decide what the monthly number means

A question such as "What did search bring us in April?" needs a more precise version before anyone adds figures. One view starts with inquiries received in April and follows them to the latest outcome.

Another starts with payments received in April and looks backward to each job's recorded source. They can produce different totals from exactly the same records. Put the chosen date and measure in the report heading so that the next person can repeat the calculation.

Check the rows behind the largest amounts and a few modest jobs too. Can you trace a paid row through a real invoice and work order to a genuine inquiry? Are you counting a quoted job that is still awaiting approval?

Is a split deposit showing twice? Are several rooms in the same house listed as several new leads? When the original source is unknown, keep it unknown and include it in the total set of jobs being reviewed.

To get started without rebuilding the office system, trace the last few closed estimates by hand. Circle the first place you lose the connection. It might be the appointment booked by phone, a revised estimate without its predecessor, or a deposit listed under a different contact.

Fix the missing reference at that point and repeat the walk with the next job that closes. Once the chain is reliable, use actual booking and ticket figures as inputs to the carpet cleaning visibility calculator. Keep the calculator's modeled change separate from the payments you can already trace.

Contact usFree analysis