13-Week Cash-Flow Forecast for Service Firms

Your bank balance tells you what is available today. It does not tell you whether next month’s contractor payments, software bills, and payroll will fit alongside the client payments you are expecting.

That is where a short cash-flow forecast helps. A 13-week cash-flow forecast is a rolling view of the money you expect to come in and go out, week by week. It gives you a simple way to see a tight week while you still have time to respond, and the numbers are estimates rather than a guarantee of what will happen.

For a service business, the forecast is especially useful because the timing of cash can be uneven. You may finish a large project in one week, wait for approval, and then receive payment later. Your expenses, meanwhile, may continue on their normal schedule.

What a Cash-Flow Forecast Is and Is Not

A cash-flow forecast tracks when cash is expected to move. Xero’s cash-flow guide describes it as an estimate of future inflows, outflows, and cash position. It is different from a profit and loss statement, which shows revenue and expenses for a period according to your accounting method. It is also different from a budget, which describes what you planned to spend and earn.

The forecast answers a narrower question:

If the expected money arrives when we think it will, can the business cover what is due over the next several weeks?

That answer will not be exact. Clients pay late. Projects move. A new expense appears. The value comes from updating the forecast regularly and making the assumptions visible.

Start With Your Actual Cash

Begin with the current cleared balance in each business checking account. A reconciled account gives you a checked starting point for cash planning. If you keep money in a separate savings account for a known obligation, list it separately instead of treating every dollar as available operating cash.

Do not start with the balance shown in your accounting software if the bank accounts have not been reconciled recently. A forecast built on an unverified starting number can create false confidence. Reconcile the accounts first, or clearly mark the balance as an estimate until you can verify it.

Next, set a minimum cash floor. This is the amount you want to keep available for ordinary operations and unexpected timing changes. The right amount depends on your business, so the point is not to copy someone else’s number. Pick a figure you can explain and review it as the business changes.

List Expected Cash Inflows by Week

Write down the money you reasonably expect to receive in each of the next 13 weeks. For a service business, that may include:

Payments on invoices that are already outstanding
Deposits or milestone payments for scheduled work
Recurring client payments
Other business income you can support with a clear expectation

Use your accounting software’s accounts receivable aging report as a starting point, but do not treat every open invoice as cash that will arrive on its due date. A current invoice with a reliable payment history is a different forecast assumption from an invoice that is already overdue or waiting on a client approval.

Give each expected payment a likely week and a confidence level. If you are unsure, put it in the later week or create a conservative version of the forecast that excludes it. A forecast is more useful when it shows uncertainty than when it quietly assumes everything will go perfectly.

Add Every Meaningful Cash Outflow

Now list what the business expects to pay each week. Include both regular and occasional obligations:

Payroll and contractor payments
Rent, software, insurance, and other recurring bills
Credit-card payments and loan payments
Vendor bills that are already due or scheduled
Owner draws or contributions, if you plan to make them
Equipment, hiring, or other one-time purchases already under consideration

The goal is to capture the payments that could change your decision about hiring, taking on work, delaying a purchase, or following up with a customer. Small, routine purchases matter less here.

For expenses that vary, use a reasonable estimate and label it. If contractor costs depend on how much work comes in, show the expected cost alongside the work that creates it. That makes the forecast easier to update when a project changes.

Calculate the Weekly Ending Balance

Each week’s basic calculation is simple, following the standard cash-flow forecast structure of starting cash, expected inflows, expected outflows, and ending cash described by AICPA & CIMA:

Starting cash + expected inflows - expected outflows = estimated ending cash

The next week starts with the previous week’s estimated ending balance. Compare that balance with your minimum cash floor. If a week falls below it, you have found a planning problem, not necessarily a crisis.

The next step is to investigate the assumption behind the shortfall. Is a large client payment too uncertain? Did a contractor payment get placed in the wrong week? Is a planned purchase optional? Is there an invoice that needs a clear follow-up today?

A useful habit: Keep a base forecast and a conservative forecast. The base version uses your best estimate. The conservative version delays uncertain customer payments and keeps committed expenses in place. Seeing both gives you a more honest range than one precise-looking number.

Use the Forecast to Make Decisions

Review the forecast once a week and write down the action connected to any tight spot.

That action might be:

Confirming the payment date for a large invoice
Sending a reminder before an invoice is due
Asking a vendor whether a payment date can be moved
Waiting to make a discretionary purchase
Checking whether a new project will require contractor costs before its first payment
Moving money between business accounts while keeping the purpose of each account clear

None of these actions changes the underlying facts. They give you time to respond to them deliberately instead of discovering a problem when an automatic payment is declined.

Keep It Current Without Making It a Second Job

A spreadsheet with one column for each week and rows for starting cash, inflows, outflows, and ending cash is enough to begin. Xero’s forecasting guide uses the same basic structure.

Once a week, replace estimates with what actually happened. Mark payments that arrived late, expenses that were higher than expected, and invoices that moved to a different week. Then extend the forecast by one more week so it always covers the next 13 weeks.

Your bookkeeping system remains the source for recorded transactions. The forecast is a planning view built from those records and from what you know about upcoming work and obligations. Keeping those roles separate makes both tools easier to understand.

The Point Is Fewer Surprises

A 13-week forecast will not make clients pay faster or remove the natural uncertainty of running a service business. It will show you which assumptions your cash position depends on and give you a chance to act before a tight week arrives.

Start with the bank balance you can verify. Add the customer payments you can explain. Include the bills you know are coming. Review the difference every week, and update the plan when reality changes.

That is enough to turn cash flow from a daily worry into a short, useful planning conversation.

Bat City Books helps service-based small businesses keep their books current and turn the numbers into practical decisions. If you want a clearer view of what is coming next, let’s talk.