Fill the totals and private evidence references in the printable PDF or editable template. The web page explains the definitions; it does not connect to your accounts or calculate results.
One complete week, one business, one stated currency. Each row uses its own event date.
Result
Which date?
What counts?
Total
Evidence / owner
New genuine enquiries
When the request first arrived
Count each distinct service request once. Exclude spam, staff tests and repeats of the same request. An existing customer can make a new request.
________
________
New appointments booked
When the booking was first created
Count each distinct booking once. Keep a reschedule linked to the original booking; note later cancellations separately. Do not substitute appointment date.
________
________
Appointments attended
When the appointment took place
Use staff-confirmed attendance, including appointments booked in an earlier week. A booking-link click or confirmation message is not attendance.
________
________
Jobs fully paid
When the final balance was received
Count each distinct job once when fully paid. Exclude unpaid invoices and deposit-only jobs; record later refunds separately. This is jobs, not unique customers.
________
________
Net receipts
Receipt and refund transaction dates
Successful customer receipts minus successful refunds in the period, in one currency. State whether deposits, tax and fees are included. Not profit or proven ad revenue.
________
________
Advertising spend
Ad account reporting dates
Record the platform-reported spend and account currency. State timezone, freshness, included accounts and any excluded fees or tax. Do not assume the figure is a final invoice.
________
________
Write Unavailable when a source cannot be checked. Use zero only after a complete check found none. These weekly totals are separate events, not a matched customer conversion rate.
Agree how the figures will be checked.
Use your existing records; a new subscription is not required. Agree who checks each number before comparing reports. The form below saves planning decisions and observed checks, not live customer totals. Enter weekly totals in the printable or editable download.
Start with one week, not a complicated dashboard
Write the business, complete date range, timezone, currency and checking time. Ask each source owner for the evidence behind their number. Keep customer names, payment details and private account exports out of a shared worksheet; record a private evidence reference instead.
Do not divide unrelated weekly totals
This week’s bookings may follow last week’s enquiries. This week’s payments may settle older jobs. The six totals describe separate events, not the same group of customers moving through stages. The editable template includes a separate way to follow the same enquiries up to a stated review date.
Give missing data and corrections an owner
Keep unknown sources visible. Record deposits, refunds, cancellations and late records with their treatment. If a figure cannot be reproduced, hold that claim for review rather than inventing a zero. Save a corrected report version and tell the same recipients what changed.
Keep the final decision with the business owner
The six checks below help you review a report. A Passed label is your observation, not an automatic account audit. Assign an owner, backup and approver. A reporting improvement does not authorize ad changes, refunds, customer messages or deletion.
Check the report before sharing it.
TEST 01
The dates and accounts match the labels
Check a record near midnight and one from a different location or currency. Compare each source date field and reporting timezone with the scorecard heading.
Expected outcome
Each total has the right date basis, account, timezone and currency; differences are disclosed.
TEST 02
Repeats do not create extra results
Use a sample request submitted twice, a rescheduled booking and a job paid in two instalments. Apply the stated identifier and counting rule.
Expected outcome
One request, one booking and one fully paid job are counted; instalments remain payment transactions.
TEST 03
A booking is not recorded as attendance
Compare a sample booking-link click, a confirmed appointment and an appointment whose attendance staff actually checked.
Expected outcome
Only the staff-verified visit enters attended appointments; clicks and confirmations stay separate.
TEST 04
Won, unpaid, deposit and refund stay distinct
Review a sample won opportunity with an unpaid invoice, a deposit-only job, a fully paid job and a later refund.
Expected outcome
Unpaid and deposit-only jobs are not fully paid; receipts and refunds follow the written money rule.
TEST 05
Missing evidence remains visible
Use a sample enquiry with no known source and a payment report that cannot be opened. Check how the draft displays both.
Expected outcome
Unknown source remains Unknown; unavailable payment data is not reported as zero or assigned to an ad.
TEST 06
One reviewer approves the report and action
Ask a backup to trace one total to its private evidence. Correct a sample mistake, record a new version and ask the owner to approve the next action.
Expected outcome
The total can be reproduced; corrections, owner approval and the next review date are recorded.
Prepared November 2, 2026 by Kashif Rehman. Original planning examples and test records; no customer results or automatic system verification are claimed.
Product information checked November 2, 2026. Confirm current settings and account-specific terms.