A busy appointment book can sit beside an uncomfortable bank balance. Payroll may leave on Friday, the skincare order may be due on Monday, and card receipts from the weekend may arrive later than the sales report suggests. A monthly profit figure will not tell you whether those payments fit together.
A rolling 13-week cash-flow forecast gives a spa or aesthetic clinic a practical way to see that timing. It starts with cash available now, places expected receipts and payments into the weeks when they reach or leave the bank, and shows the lowest balance ahead. The useful result is a dated decision: which week needs attention, how large the gap is, and what can realistically change before then.
Build the forecast around the bank, not the appointment book
Use one column for each of the next 13 weeks and a consistent cutoff, such as Sunday night. At the top, enter the opening balance of the operating accounts included in the forecast. Reconcile it to bank activity, including payments already issued but not yet cleared. Do not include an unused credit facility as cash on hand.
Keep any legally restricted money outside available operating cash. For funds internally earmarked for taxes or another purpose, either exclude the account and its related payments consistently or include both and show a separate reserved-cash line. Mixing approaches makes the same money look available twice.
The basic calculation is straightforward: opening cash plus receipts minus payments equals closing cash. Each week's closing figure becomes the next week's opening figure. The FDIC and SBA's Money Smart curriculum treats cash-flow projections as a tool for anticipating and addressing business challenges. The weekly format here applies that principle to appointment-led businesses; 13 weeks is a working planning horizon, not a required accounting standard.
Separate receipts by how they actually arrive
Create distinct rows for card settlements, cash deposits, membership collections, gift-card or package sales, and any other material receipts. Separate new borrowing or an owner contribution from customer receipts so a financing injection cannot disguise weak operating cash generation.
For card sales, use your processor's settlement pattern rather than assuming the treatment date is the bank date. Check weekend and holiday timing, deductions and any reserves. Choose one consistent approach: forecast net deposits after processing fees, or forecast gross receipts with fees as a separate payment. Never deduct the fee in both places.
Booked appointments provide a starting point, but the full menu value is rarely the same as future cash receipts. Identify deposits already collected, prepaid package visits, gift-card redemptions, expected discounts and the amount still due. A $200 appointment with a $50 deposit received last week creates at most $150 of new payment this week, before any other adjustment.
Apply your own recent cancellation and attendance experience to the remaining bookings. Farther-out weeks will contain more estimates than the coming week. Label those assumptions rather than filling every open slot at full price. For membership billing, allow for the actual collection date and recent failed-payment experience; retrying a payment is not the same as receiving it.
Put commitments on their real payment dates
Payroll should follow the payroll calendar, including employer costs and benefits paid separately. Rent, insurance, software renewals, marketing bills, inventory purchases, equipment payments and taxes should follow their due dates. Ask the bookkeeper to check the tax and debt-payment lines against actual schedules, rather than estimating them from last month's profit.
Include the full cash amount of a loan payment, while keeping principal and interest distinguishable in supporting records. Depreciation does not create a new cash payment in this forecast. An equipment deposit does. A profitable month and a falling bank balance can therefore coexist without either report being wrong.
Stock purchases deserve their own attention. A clinic may use supplies over several months but pay for them in a single week. Put the supplier payment into that week, then use the treatment schedule to judge whether the purchase quantity is necessary. Do not place both the inventory purchase and the later accounting cost of using that same inventory into cash outflows.
Include refunds, processor deductions, owner withdrawals and known one-off costs as separate rows when material. An internal transfer between two bank accounts already included in the forecast is not a new receipt or expense for the business.
A four-week example reveals the pressure point
The following figures are hypothetical and illustrate the first four columns of a longer forecast. Assume a spa begins with $28,000 of available operating cash, with reserved funds already excluded.
Week 1: $28,000 opening cash, $18,000 receipts and $22,000 payments leave $24,000.
Week 2: $24,000 opening cash, $19,000 receipts and $29,000 payments leave $14,000.
Week 3: $14,000 opening cash, $20,000 receipts and $24,000 payments leave $10,000.
Week 4: $10,000 opening cash, $21,000 receipts and $17,000 payments leave $14,000.
Across the four weeks, $78,000 comes in and $92,000 goes out. The spa ends with $14,000, but its lowest weekly closing balance is $10,000. If the owner has chosen a $15,000 operating floor for this example, the largest shortfall against that floor is $5,000 in week 3.
That floor is a management choice, not an industry benchmark. Set it with reference to unavoidable upcoming payments, settlement variability and the business's ability to respond. A weekly closing balance can also hide a Tuesday shortfall before Friday deposits arrive. Where headroom is tight, expand the next two weeks into a daily view.
Test a downside case before relying on the base forecast
Keep a base case that reflects the most likely outcome, then change a small number of plausible assumptions in a separate version. Useful tests include lower collected sales, a settlement delay, an unexpected repair or a concentrated week of package redemptions.
In the hypothetical example, receipts that are 15% lower every week reduce four-week cash inflow by $11,700. If payments remain unchanged, weekly closing balances become $21,300, $8,450, $1,450 and $2,300. Week 3 now sits $13,550 below the chosen $15,000 floor.
That deliberately holds payments constant to expose the risk. In a more detailed version, adjust only costs that would actually fall, and place the saving in the week it would reach the bank. Lower treatment volume might reduce consumable use immediately without reducing an invoice already owed. A planned staffing change may also have contractual and operational constraints.
A timing delay needs different treatment from a lost sale. If $6,000 of settlements moves from week 2 to week 3, subtract it from one column and add it to the next. Reducing receipts permanently would overstate the loss; ignoring the delay would hide the funding need.
Keep prepaid sales and future delivery together
Gift cards, memberships and prepaid packages can bring money in before the associated services are delivered. Record the cash when received, but maintain a separate schedule of outstanding services and likely redemption timing. The future visit may bring little or no new cash while still requiring staff, supplies and room time.
For example, a hypothetical $10,000 package promotion might create $4,000 of additional delivery-related cash costs over subsequent weeks. The timing of those costs belongs in the forecast alongside the initial receipts. The figures are illustrative, and the remaining $6,000 is not automatically profit: overhead, fees, refunds and other obligations still matter.
Before using another promotion to cover a shortfall, check whether its redemption pattern makes a later week worse. Our spa gift-card planning guide explores that delivery obligation in more detail. Revenue recognition, tax treatment and any restrictions on prepaid funds belong with the accountant; the operational forecast must still capture the actual cash movement without double counting.
Turn the low point into a decision list
Sort possible actions by whether they change cash timing, total cost or both. An optional stock order can be reduced; a nonessential project can be deferred; a supplier may agree to a different payment date. Do not simply move a contractual bill to a later column without obtaining the agreement that makes the change real.
Record each action with an owner, an amount, an effective week and its status. Keep unconfirmed actions outside the base case. A hoped-for financing approval, a possible bulk sale or an unaccepted supplier arrangement should not support a decision to spend today.
Also look beyond the immediate gap. Moving $5,000 out of week 3 only helps if the receiving week can carry it. Cutting acquisition activity may improve this week's cash while weakening future bookings. The forecast makes those trade-offs visible; it does not remove them.
Refresh it every week
Replace the completed week's estimates with actual bank movements, explain the largest differences, and add a new week at the far end. Wells Fargo's projection guide similarly emphasizes realistic collection and payment assumptions and comparing forecasts with actual results. Its example is monthly; an appointment business can use the same discipline weekly.
Keep the review focused on the lowest projected balance, its date, the downside case and outstanding decisions. Investigate whether a variance reflects volume, payment timing, fees or an omitted bill before changing the forecast. Over several cycles, those explanations improve the assumptions.
The objective is a forecast that helps an owner act before a difficult payment week arrives. A simple sheet tied to real settlement dates and obligations is more useful than a polished model that treats every booking as cash already in the bank.
Illustrative photograph: the Royalton Bavaro spa reception in the Dominican Republic, by Meg von Haartman on Unsplash, used under the Unsplash License. The pictured spa is not the hypothetical business in this article.
