The 13-Week Cash Forecast

1Receipts payments and future balances

A managed services provider (MSP) earns money from technology services and products. A cash receipt is money arriving in a bank account. A cash payment is money leaving a bank account. A cash forecast estimates future receipts, payments and balances. The forecast should use payment timing rather than the dates revenue or expense is recorded.

A thirteen-week cash forecast places the expected movements into weekly columns. Thirteen weeks is roughly a quarter and provides a practical short-term planning horizon. The business updates the forecast regularly and adds another week as an old week becomes actual. The chosen horizon is a planning structure, rather than a prediction that every future payment is certain.

QuickBooks Online supplies accounting records and outstanding balances. Syncro supplies invoice, contract and payment information. Excel can assemble the dated forecast. The admin manager prepares the source schedules and reconciles actual movements. The CEO reviews the cash outlook and leads decisions about new commitments, financing and changes to the plan.

The forecast needs two kinds of information: the cash available at the start and the movements expected afterward. A profit and loss statement alone supplies neither completely. Loan principal, equipment purchases, owner distributions and the settlement of old invoices can change cash without appearing as current operating expense or current earned revenue.

2The opening cash balance

Opening cash is the balance used at the beginning of the forecast. Reconciled cash is supported by a comparison between bank records and accounting records, with timing differences and errors resolved or explained. Available cash is the amount that can actually be used for the planned payments after restrictions and relevant commitments are considered.

The supplied October 6, 2026 balance sheet reports bank balances totaling $312,490.80. Use that figure as a reported starting reference, rather than a confirmed available-cash amount. The supplied records do not include bank reconciliation status, restrictions, cleared transactions or the complete dated commitments. The admin manager must obtain those details before the CEO relies on a spending conclusion.

Define which accounts the forecast includes. If a transfer moves money between two included company bank accounts, the transfer changes the individual balances but not the combined cash total. Counting the transfer as an external receipt would overstate cash. A payment to an account outside the included scope needs its own treatment and explanation.

Record the forecast start date and the cutoff for source records. If a receipt already appears in opening cash, do not include it again as a future receipt. If a payment has already cleared, the opening balance already reflects the outflow. Checks and other payments in transit require reconciliation so the forecast does not omit or double count them.

The company financial reference records the supplied aggregate figures, reporting periods and missing supporting records. Use that reference when checking this lesson's company calculations.

3Expected client collections

Accounts receivable is money recorded as owed by customers. A receivables aging report identifies balances by due status or age. The forecast needs an expected collection date for each relevant invoice or a documented group of invoices. The due date is a useful starting record, but a disputed or late invoice may require another expected date.

The supplied October 6 receivables balance is $128,891.43. That total does not establish when the money will arrive. The company bills on the first day of the month, so early-month balances must be interpreted with the billing cycle. Obtain the detailed aging, payment terms, disputes and known payment commitments. Do not put the entire receivables total into the next week solely because the invoices exist.

Separate existing invoices from expected future invoices. Existing invoices may produce cash after the forecast starts. Future recurring billing may also produce collections within the thirteen weeks. Check the cutoff so the first-day invoice batch is not counted once as opening receivables and again as forecast future billing.

A client deposit is cash received before the relevant work may be earned. Include the cash when expected to arrive, while keeping the accounting recognition separate. If the deposit creates an obligation to deliver or refund under the agreement, preserve that obligation in the commitments review. Cash received for work still to be performed may support delivery costs that have not yet been paid.

Mark collections by evidence: a cleared or scheduled payment, a client-confirmed date, a contractual due date or an estimate. Use these descriptions to discuss uncertainty. The forecast should make a doubtful large collection visible rather than hide the assumption in a total.

4Payment obligations and commitments

Accounts payable is money recorded as owed to suppliers. An outstanding supplier balance is only one source of future payments. Payroll, taxes, card settlements, debt principal, rent, subscriptions and approved purchases may also require cash. A commitment is an agreement that will require payment or work, even when no supplier bill has yet been posted.

Gather actual payment dates and terms. The CEO says payroll synchronizes after the fifth and fifteenth. Synchronization moves payroll records into accounting; the cash forecast needs the bank payment dates for wages, tax remittances and benefits. Confirm those dates with the payroll provider and relevant bank records.

Credit card purchases and credit card payments need a consistent method. If the forecast includes the bank payment to settle a card balance, do not also include every underlying card purchase as an immediate bank outflow. Future purchases may increase a later card payment. The method should reflect how the account is actually settled and identify any interest or minimum-payment assumptions.

Loan interest and principal both require cash when paid, but principal reduces debt rather than becoming an operating expense. An equipment payment can require cash before depreciation expense occurs. Owner distributions can reduce cash without becoming an operating expense. Include the actual approved payment commitments in the cash schedule using their correct descriptions.

A future payment should have an amount, date, source and approval status. Keep proposed purchases separate from approved commitments. The CEO can then see which payments can still be changed and which agreements already require performance. Check contract and legal obligations before assuming a payment can simply be postponed.

5Weekly cash calculations

For each week, closing cash equals opening cash plus receipts minus payments. The next week's opening cash equals the prior week's closing cash. Net cash movement is receipts minus payments. The lowest projected closing balance helps identify the period of greatest pressure under the forecast's assumptions.

Practice example: opening cash is $40,000. The simplified four-week schedule contains all the receipts and payments included in this exercise. There are no transfers, restrictions, financing or additional commitments.

Week	Receipts / payments	Closing cash
1	$20,000 / $18,000	$42,000
2	$10,000 / $35,000	$17,000
3	$15,000 / $12,000	$20,000
4	$20,000 / $10,000	$30,000

Week two is the lowest weekly closing balance at $17,000. The four-week ending balance is $30,000. A comfortable ending balance does not describe every earlier week. The sequence matters because payments require cash when they occur.

A weekly closing balance can also conceal an earlier shortage within the week. If payroll leaves on Monday and a large receipt arrives Friday, inspect daily timing for that week. The weekly model identifies the period needing a closer look. The CEO should see the lowest relevant balance and the particular receipts and payments that create it.

6Collection delays and response options

A downside cash case changes assumptions to test a less favorable timing or amount. Keep the original forecast available and explain the difference. The purpose is to understand which event creates a cash problem and how much time remains to respond.

Practice example: the $10,000 receipt in week two is delayed to week four. Week two closing cash falls from $17,000 to $7,000. Week three closes at $10,000. Week four still closes at $30,000 because the money arrives within the four-week horizon. The same final balance therefore contains a much lower interim balance.

The CEO can investigate earlier collection, an agreed supplier schedule, a smaller purchase or financing. Compare those options using actual terms, cost and feasibility. A promised client payment should be confirmed. A supplier schedule should be agreed. A borrowing plan should be available before the payment date. An unsupported expectation belongs in the forecast as an assumption rather than as a completed solution.

A minimum cash requirement is a floor chosen by the business for a stated purpose. The floor may reflect payroll, taxes, financing terms or other needs. The CEO establishes the rule using the actual obligations. This course does not turn an illustrative cash amount into a company policy. When a forecast crosses the approved floor, show the size and date of the gap and the decisions required.

7Actual cash and forecast updates

Actual cash movements are the receipts and payments that occurred. Replace completed forecast weeks with actual movements from reconciled records. A cash variance is the difference between an expected movement and the actual movement. Identify whether the difference reflects amount, timing, omission or classification.

If a client pays one week late, move the remaining forecast receipt to the supported new date. Avoid leaving the old receipt in place while adding another expected receipt. If a supplier payment was missed in the forecast, add the obligation and investigate why the source process omitted it. The variance review improves the next version's inputs.

Roll the forecast forward by one week so the future horizon remains thirteen weeks. Refresh the aging, payroll schedule and commitments. Preserve the prior version so the CEO can see whether low cash improved because money arrived, a payment moved or an assumption changed. Those explanations support different decisions.

The admin manager prepares the update and checks the formulas. The CEO reviews major assumptions and approves new cash commitments. An accountant or payroll adviser resolves technical obligations as needed. The forecast should remain a working decision record that both people can explain, with sources and uncertainties visible.

8Cash timing practice

Use the four-week practice schedule above. Then delay the week-two $10,000 receipt to week four and add a previously omitted $5,000 payment in week three. Assume no other changes.

Recalculate the four closing balances.
Identify the lowest balance and its week.
Compare the new week-four ending balance with the original.
Separate the effect of the delayed receipt from the effect of the omitted payment.
List the evidence needed before the CEO selects a response.

Check your work

The revised closing balances are $42,000 in week one, $7,000 in week two, $5,000 in week three and $25,000 in week four. Week three is the lowest closing balance. Daily timing within that week may require another check.

The delayed receipt lowers interim balances but does not change ending cash because it arrives in week four. The added $5,000 payment lowers ending cash from $30,000 to $25,000. The forecast should show both causes rather than describe the full change as poor collections.

The response needs a supported collection date, the payment obligation and available options. An actual decision also needs the company's approved cash floor, financing availability and complete commitments. Keep those inputs separate from this hypothetical exercise.

9Your company weekly cash forecast

The admin manager reconciles opening cash and gathers the receivables aging, supplier balances, payroll dates, taxes, card payments, debt schedule and approved commitments. The October 6 reported bank total can be a reference while reconciliation is completed. Do not describe the reported total as freely available cash without the supporting checks.

Build thirteen weekly columns in Excel. Link every significant receipt and payment to a supporting schedule. Mark estimated dates and uncertain receipts. Prepare a downside timing case for an important uncertain collection. The CEO chooses the assumptions and approves any changed commitment or financing response.

The deliverable is a thirteen-week cash forecast with a source schedule, lowest-balance explanation and decision list. The admin manager should be able to trace the numbers. The CEO should be able to explain which obligations are funded, which assumptions need confirmation and which actions must occur before the week of greatest pressure.

10Going deeper

Going deeper

A revolving credit facility can provide cash when a timing gap occurs, but only under its actual availability, borrowing limits and terms. Show drawdowns as financing receipts and repayments as financing payments. Interest and fees need their own payment rows. The forecast should also show cash before financing so the CEO can see the operating gap the borrowing is intended to fund.

Foreign currency, restricted deposits and accounts outside the forecast scope need explicit treatment when present. A combined company total can hide a shortage in the account used to pay payroll. Review both total cash and account-level funding when transfers require time or approval. The simple forecast structure remains useful when its scope and limits are clear.

11The completed work

A thirteen-week cash forecast with dated sources, a lowest-balance explanation and decisions for CEO review.

Keep approved company work in your finance workspace. The course records study progress in this browser; it does not store your reports or forecast files.

13Glossary

Cash forecast: An estimate of future cash receipts, payments and balances.
Cash receipt: Money arriving in an included bank account.
Cash payment: Money leaving an included bank account.
Opening cash: The cash balance used at the beginning of a forecast period.
Available cash: Cash usable for planned payments after relevant restrictions and commitments are considered.
Closing cash: Opening cash plus receipts minus payments for a period.
Net cash movement: Cash receipts minus cash payments during a period.
Cash variance: The difference between an expected cash movement and the actual movement.
Minimum cash requirement: A cash floor chosen by the business for a stated purpose.
Downside cash case: A forecast with less favorable receipt or payment assumptions used to test cash pressure.
Forecast cutoff: The date and scope separating opening records from future forecast movements.

14Sources

Company examples use the accrual reports supplied on October 6, 2026. Report periods, selected totals and limits are recorded in the company reference. Examples labeled practice use hypothetical inputs.

SEC: Financial statements: Cash flow, operating results and the distinction between financial statements.
Syncro: Invoice payments: Invoice payment records supporting collection schedules.