white board, startup, start-up, presentation, board, diagram, present, show, explain, school, plan, sketch, draw, teacher, education, college, hand, strategy, idea, project, design, drawing, business, planning, creativity, vision, solution, management, development, marketing, engineering, structure, whiteboard, marker, guy, man, office, white board, teacher, teacher, teacher, teacher, teacher. How a tutoring center tracks cash flow week to week for new owners
Photo by StartupStockPhotos on Pixabay

Guides

How a tutoring center tracks cash flow week to week for new owners

Tutoring center bookkeeping around prepaid hours: three ledgers, the unearned balance, and a thirteen-week cash view that shows the summer trough early.

What to take away

  • The one thing that makes tutoring center bookkeeping different from most small businesses: money for prepaid hours arrives before the work, so cash received is not revenue earned.
  • Keep a separate running total of hours owed. Without it, your bank balance will tell you the business is doing well during exactly the period when it has taken on the most obligation.
  • Plan cash thirteen weeks ahead, not monthly, because the school year moves in blocks and a monthly view hides both the enrollment surge and the trough.
  • This is operational bookkeeping, not tax or accounting advice; where the law decides a question, the authority is named so that the conversation with a qualified adviser is a short one.

Three ledgers, not one

Most of a tutoring center's bookkeeping is ordinary. Three things need separate attention.

Three Ledgers: Cash, Hours, Revenue

Cash

Package sold
Up
Session delivered
Unchanged
Missed, forfeited
Unchanged
Make-up delivered
Unchanged
Hours refunded
Down
Hours expire
Unchanged

Hours owed

Package sold
Up
Session delivered
Down
Missed, forfeited
Down
Make-up delivered
Down
Hours refunded
Down
Hours expire
Down

Earned revenue

Package sold
Unchanged
Session delivered
Up
Missed, forfeited
Up
Make-up delivered
Up
Hours refunded
Unchanged
Hours expire
Up

Cash. What actually moved, when. Straightforward, and the one most owners track.

Hours owed. Every hour sold and not yet delivered. This is a liability, and it lives in the same place your cash does, which is what makes it dangerous.

Delivered work. Sessions actually taught, which is what converts an obligation into earned revenue.

The relationship between the three is the whole of it.

EventCashHours owedEarned revenue
A package is soldUpUpUnchanged
A session is deliveredUnchangedDownUp
A session is missed without noticeUnchangedDown, if your policy forfeits itUp, on the same condition
A make-up is delivered laterUnchangedDownUp
Unused hours are refundedDownDownUnchanged
Unused hours expireUnchangedDownUp, per your agreement

Cash does not move at all when the work is done, which is precisely why a center can feel prosperous in September and be short in July.

Put the bank balance and the hours-owed balance on the same line of the same weekly sheet. Read together they describe the business; read apart, the first one flatters it for most of the school year.

The unearned balance

Track it as a single number, updated weekly, alongside the bank balance. Never look at one without the other.

Cash Minus Hours Owed Test

Subtract hours owed from cash held

Yes

Positive -> you are financing from earnings

No

Negative -> you are financing from families

A practical test: subtract the value of hours owed from the cash you hold. If the result is negative, you spent money for work you have not done, and that work still needs staffing and delivery.

That does not always mean trouble, but it means you are financing the center from your families rather than your earnings. Know that deliberately rather than discover it.

Expiry dates matter here. Hours with no expiry never leave the liability, and a balance built up over three years is presented to you at the worst possible moment, usually when a family is leaving. Whatever expiry you set has to be in the agreement and applied consistently.

The thirteen-week view

Monthly cash planning is standard advice and it is not enough for this business, because the important variation happens inside months.

Thirteen-Week Rolling Cash Sheet

  1. Every week
    Update cash in, cash out, hours owed, delivered hours
  2. Two or three weeks
    Enrollment cash arrives
  3. Mid-term
    Delivered hours peak
  4. Term end
    Delivery stops, fixed costs continue
  5. March
    Summer trough deficit is knowable
  6. June
    Same deficit becomes a problem

Build a rolling thirteen-week sheet with four lines: cash in, cash out, hours owed at the end of the week, and delivered hours. Update it every week. Thirteen weeks is roughly a term, which is the natural unit here.

A monthly view misses the two or three weeks when enrollment cash arrives.

It also misses the point in the term when delivered hours peak, and the exact week the term ends and delivery stops while fixed costs continue.

Read the sheet as a sequence, not a snapshot: cash in spikes first, hours owed peaks just behind it, delivered hours peak in the middle of the term, and the lowest combined position arrives in the weeks after delivery stops while fixed costs carry on.

Extend the same sheet across the trough before you get there. The deficit is knowable in March, and a deficit known in March is a plan while the same deficit discovered in June is a problem.

What has to be documented

The IRS guidance on the records a business should keep — Publication 583, Starting a Business and Keeping Records — describes the general expectation: a system that clearly shows income and expenses, supported by documents for purchases, sales, payroll, assets and other transactions.

Records to Keep Per Package

  • Quote or agreement behind each package
  • Hours delivered against it
  • Payroll records for every tutor
  • Receipts for fit-out and materials
  • Consistent quote template from first family

The link between the agreement and the attendance record gets tested, usually by a family querying a balance months later. A quote template keeps the agreement and its arithmetic slots consistent from the first family onward.

How those transactions get captured week to week is a systems question. Common choices for the books are QuickBooks Online, Xero and Wave; the hours-owed line and the thirteen-week sheet usually fit best in a spreadsheet such as Excel or Google Sheets, which is also where the KPI numbers come from.

Payroll is weekly, revenue is seasonal

Tutor pay is the largest cost and it is due every pay period regardless of what is happening in the term.

Payroll Weekly, Revenue Seasonal

  1. Every pay period
    Tutor pay due regardless of term
  2. Spring
    Recruitment round recurs yearly
  3. Before revenue
    Recruitment cost lands
  4. Ongoing
    Employee or contractor decided by law

Two consequences. Rostering to actual bookings, not the block's shape, is a cash and operational decision.

The spring recruitment round recurs yearly because student tutors finish their year. That cost lands before the revenue it enables. Put it in the thirteen-week sheet, not as a surprise, and start recruiting early enough that new tutors are ready before the fall block starts.

Whether tutors are employees or contractors is decided by law rather than preference, and it changes what you withhold and what you report. The federal test is the IRS common-law test, explained in Publication 15-A and in the instructions to Form SS-8; a center that wants an official answer files Form SS-8 with the IRS. Have your own arrangement determined by a qualified adviser and keep the determination with your other records.

Refunds, credits and write-offs

Decide the policy before you need it and account for each one the same way every time.

Refund, Credit, Write-Off Handling

Cash

Refund
Down
Credit
Unchanged
Expired hour
Unchanged

Hours owed

Refund
Down
Credit
Moved, not removed
Expired hour
Written off per agreement

A refund reduces cash and reduces hours owed. A credit moves an obligation between families or between services but does not remove it. An expired unused hour is written off according to whatever your agreement says, and it should say something.

Strictness here is not about accounting purity. Inconsistent handling of unused hours is the most common source of disputes in this trade.

A dispute with one parent spreads to other parents at that school fast, and it costs referrals long before it costs the balance in question.

Protecting the financial records

A tutoring center's books sit alongside data about minors, often in the same systems, and the security question covers both.

Individual logins, access by role, and removal of access when somebody leaves are the basics, and in this trade people leave every spring. NIST's Small Business Information Security: The Fundamentals (NISTIR 7621 Rev. 1) and CISA's Cyber Essentials toolkit are the two public starting points written for organizations without a technology function; the first covers risk management and privacy, the second covers the same ground from the threat side.

Payment fraud aimed at small businesses usually arrives as an urgent instruction to change bank details. Decide now that any change to payment details is verified by a phone call to a number you already had, and tell whoever handles payments that this rule has no exceptions.

A monthly closing routine

Reconcile the bank. Reconcile delivered sessions against what was billed. Update hours owed. Roll the thirteen-week sheet forward. Note anything unusual in one sentence.

An hour a month, done consistently, is worth more than a full day done quarterly, because the errors this business generates are small, frequent, and easy to fix while they are recent.

Common questions

The four questions new owners ask most often when they set this system up.

Should prepaid packages be recognized as revenue when they are sold?

Cash received and revenue earned are different things, and how that is presented in your accounts is a question for a qualified accountant in your jurisdiction. Whatever the accounting treatment, track hours owed separately for management purposes.

How much cash should a tutoring center hold?

Enough to carry fixed costs through the trough plus a margin, and the number comes from your own sheet rather than from a rule of thumb. Take the deepest week the sheet shows, subtract the hours owed in that week from the cash you expect to hold, and hold enough that the result stays positive. A figure borrowed from another center will not fit your rent, your pay rates or your mix of packages.

Do we need an accountant, or will software do?

Software records; an accountant advises. The questions in this trade that most need advice are worker classification and how prepaid hours are treated, and neither is answered by software.

What is the earliest financial warning sign?

Hours owed rising while delivered hours are flat. It means you are selling faster than you can teach, and the cash that looks available is already committed.

More in Guides

Latest from Policy Desk