Business Administration Kit · sample
Answer every inquiry, book every job, know your week
Four working spreadsheets (open them in Google Sheets, Excel or Numbers; the formulas calculate on their own), the messages a small business sends every week, and three short procedures so nothing slips when it gets busy.
1 · The spreadsheets
| File | What it does | Formulas |
| Inquiry tracker | Every question that could become a sale, with its next step and follow-up date | Days open; open inquiries; open value; follow-ups due; wins |
| Booking sheet | Appointments with service, price, status and paid | Total of completed bookings |
| Invoice | A clean invoice with line items and totals | Line totals, subtotal, tax, total |
| Weekly worksheet | Planned vs actual sales, costs, hours and inquiries | Differences, gross margin, inquiry-to-order rate |
2 · Follow-up templates
- F1 · Two days after a quote. "Hi [name], just checking you got the quote for [item/service] ($[price]). Happy to change anything. If it works, reply 'yes' and I'll book it in."
- F2 · One week, no reply (last one). "Hi [name], I'll close this quote on [date] so I can plan the week. If you'd still like [item/service] after that, just message me and I'll check availability."
- F3 · After the job. "Thanks again, [name]. If you were happy with [item/service], a short review on [Google/Facebook] really helps a small business. Here's the link: [link]."
- F4 · Unpaid invoice, friendly. "Hi [name], a quick reminder that invoice [#] for $[amount] was due on [date]. You can pay by [method]. Let me know if anything's wrong with it."
One follow-up after a quote, one last note, then stop. If someone says no or asks you to stop, mark them Lost and don't message again.
3 · Appointment templates
- A1 · Booking confirmed. "You're booked, [name]: [service] on [day, date] at [time], at [place]. The price is $[price]. Reply here if you need to change it."
- A2 · Reminder, the day before. "A reminder about your [service] tomorrow at [time]. See you then! If something's come up, please let us know today."
- A3 · Reschedule. "No problem, [name]. We have [option 1] or [option 2]. Which works better?"
- A4 · Cancellation by the business. "I'm sorry, [name], I have to cancel your [service] on [date] because [short reason]. Could you do [option 1] or [option 2] instead? [Any deposit will be refunded in full.]"
- A5 · No-show. "We missed you today, [name]. Would you like to rebook? Here are the next openings: [options]."
4 · Simple operating procedures
New inquiry (5 minutes)
- Add it to the inquiry tracker: date, name, channel, what they want.
- Reply the same day with a price or one clarifying question.
- Set the follow-up date two days out.
- Use F1, then F2. Then stop.
Booking (3 minutes)
- Add the booking to the booking sheet.
- Send A1 straight away.
- Send A2 the day before.
- After the job, mark it done and paid, and send F3.
End of week (15 minutes, Friday)
- Fill in the Actual column of the weekly worksheet.
- Chase unpaid invoices with F4.
- Close inquiries older than 10 days.
- Write one improvement for next week.