2. Forecast Weekly Cash Using Actual Collection and Payment Dates
Build a short-horizon cash forecast that follows evidence-supported collection and payment dates, not invoice totals or hoped-for sales. Use it to surface questions early, not to declare that the business is safe.
By the end of this lesson, you can prepare a four-week cash forecast with opening cash, dated receipts, dated payments, assumptions, and a weekly ending-cash calculation.
Forecast cash movement, not accounting revenue
A weekly cash forecast is a timing tool. Start each week with a reconciled or clearly labeled provisional opening bank cash figure. Then place cash receipts in the week they are expected to clear or be received, based on a customer commitment, processor payout schedule, deposit record, or other evidence. Place payments in the week they are actually scheduled or contractually due, including payroll, tax-related amounts, rent, vendors, debt payments, subscriptions, and other known outflows. A sale invoiced this week belongs in a cash forecast only on the expected collection date; it remains an accrual accounting item on the invoice date if the business uses accrual accounting. The SBA distinguishes accrual recording at sale from cash recording when payment is received.
Use a transparent calculation: Ending cash = Opening available cash + scheduled cash receipts − scheduled cash payments. Carry that ending cash into the next week as its opening cash, and visibly label every assumption. A hypothetical mini-example: opening cash is $5,200; evidence-supported receipts expected this week total $2,000; scheduled payments total $3,700. The estimated ending cash is $5,200 + $2,000 − $3,700 = $3,500. This is not a profitability measure, a lending ratio, a debt-service coverage ratio, or assurance that all obligations can be met. It simply exposes the timing implied by the current inputs.
Make the forecast a weekly learning loop
Accuracy improves when the forecast is compared with actual bank activity every week. At the end of each week, record what arrived, what was paid, what moved, and why. Replace a vague “customer usually pays” entry with a revised date only when a credible new fact supports it. Do not fill a gap by counting the same invoice twice, assuming new sales will convert immediately, or treating a loan possibility as cash before funds are actually available. The FDIC’s cash-flow materials describe a cash flow statement as showing how much cash is available, where it comes from and goes, and when it moves or needs to move.
Forecasting does not authorize nonpayment or provide a legal payment-priority rule. If the forecast identifies a possible shortfall, flag the date, affected obligation, evidence quality, and question for qualified help. Payroll, tax, contractual, and legal matters may require prompt professional review. A forecast can also reveal operational levers to examine in later lessons: collection timing, recurring-cost commitments, contribution from offers, and external risks. Keep the weekly sheet small enough to update, but retain the supporting invoices, statements, and contracts outside the sheet. The value comes from repeated comparison with actual dates, not from a complicated template.
Create a Four-Week Dated Cash Forecast
- Choose four consecutive weekly periods and enter the best currently available opening bank cash, labeling it reconciled or provisional.
- List each expected receipt once, with the expected collection date, amount, evidence source, and confidence label.
- List each expected payment once, with its scheduled or stated payment date, amount, evidence source, and confidence label.
- For every week, calculate ending cash as opening cash plus receipts minus payments; carry the result to the next week.
- Circle unknowns, possible shortfalls, and payroll, tax, legal, or contractual dates for factual follow-up or qualified escalation; schedule the actual-versus-forecast review.
WEEKLY CASH FORECAST — BLANK Formula: Ending cash = Opening cash + receipts dated for the week − payments dated for the week Week | Opening cash | Receipt date / amount / evidence | Payment date / amount / evidence | Ending cash | Assumptions or unknowns ____ | __________ | __________ | __________ | __________ | __________ ____ | __________ | __________ | __________ | __________ | __________ ____ | __________ | __________ | __________ | __________ | __________ ____ | __________ | __________ | __________ | __________ | __________ Actual-versus-forecast review date: __________ Items requiring qualified review: __________ No personal or business identifiers are needed on this printable worksheet.
Keep actual account/report numbers, Social Security numbers, passwords and confidential loan documents outside Renewra. You can complete the worksheet privately in your own secure records.
A real-world decision.
A step forward, on your terms.
Mark this lesson complete after reading and working through the exercise. This is self-reported progress, not proof of mastery or a professional credential.
U.S. scope checked October 6, 2026. This is self-paced education, not individualized legal, tax, accounting, insolvency, lending, debt-settlement, creditor-negotiation, payroll, or credit-repair advice or a professional service. Renewra does not assign advisers and is not endorsed by the SBA, FTC, CFPB, or FDIC. The course does not recommend ignoring payroll, taxes, court papers, contracts, regulatory duties, or other legal obligations; urgent uncertainty or distress should be taken promptly to an appropriate qualified professional. It makes no guarantee of deletions, score increases, funding, a turnaround, business survival, or any particular result. Consumer credit-report disputes for inaccuracies are a free consumer right, while accurate negative consumer-report information generally cannot simply be removed; do not use a false identity or frivolous disputes. Those consumer rules do not automatically apply to commercial reports or business debts. This course is not a loan application, debt settlement program, creditor-negotiation service, or paid repair program.
US educational context where applicable. Sources checked October 6, 2026; check official current requirements before acting.