SAMPLE made by CONE SUPREME for a fictional business (Maple & Rye Bakery). Portfolio · Ask for one

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

FileWhat it doesFormulas
Inquiry trackerEvery question that could become a sale, with its next step and follow-up dateDays open; open inquiries; open value; follow-ups due; wins
Booking sheetAppointments with service, price, status and paidTotal of completed bookings
InvoiceA clean invoice with line items and totalsLine totals, subtotal, tax, total
Weekly worksheetPlanned vs actual sales, costs, hours and inquiriesDifferences, gross margin, inquiry-to-order rate

2 · Follow-up templates

  1. 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."
  2. 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."
  3. 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]."
  4. 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

  1. 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."
  2. 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."
  3. A3 · Reschedule. "No problem, [name]. We have [option 1] or [option 2]. Which works better?"
  4. 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.]"
  5. 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)

  1. Add it to the inquiry tracker: date, name, channel, what they want.
  2. Reply the same day with a price or one clarifying question.
  3. Set the follow-up date two days out.
  4. Use F1, then F2. Then stop.

Booking (3 minutes)

  1. Add the booking to the booking sheet.
  2. Send A1 straight away.
  3. Send A2 the day before.
  4. After the job, mark it done and paid, and send F3.

End of week (15 minutes, Friday)

  1. Fill in the Actual column of the weekly worksheet.
  2. Chase unpaid invoices with F4.
  3. Close inquiries older than 10 days.
  4. Write one improvement for next week.

What a real kit costs: $79, set up with your business name, services and prices, delivered in 2 days, with one round of edits. Ask for one.