Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsA 13-week cash flow forecast is a rolling, week-by-week schedule of when money should enter and leave your bank accounts. Build it with the direct method: start with actual available cash, place each credible receipt and payment in the week it is expected to clear, calculate the closing balance, and revise the remaining 12 weeks whenever actual results differ. The result is a short-term liquidity view—not a profit forecast—that can reveal a cash squeeze early enough to investigate it.
What a 13-week cash flow forecast measures
The model answers one operational question: “How much cash should be available at the end of each of the next 13 weeks?” It follows bank timing rather than accounting recognition. An invoice may count as revenue when issued under accrual accounting, but it belongs in the forecast only in the week the customer is expected to pay. The U.S. Small Business Administration illustrates this timing distinction with a January sale whose cash payment arrives in February (SBA guidance on managing your business).
As an Amazon Associate I earn from qualifying purchases.
The basic roll-forward is:
- Closing cash = opening cash + cash receipts − cash payments
- Next week’s opening cash = the prior week’s closing cash
That arithmetic is simple. The work is identifying realistic dates and amounts, making the lines specific enough to investigate, and updating the schedule as facts change. A direct-method model uses collected cash, not sales, invoices, EBITDA, or accounting profit. Hemrock describes the model as using the same underlying information as financial statements—sales, costs of goods sold, operating expenses, investments and financing—but arranging it around cash timing (Hemrock, “How to Build a 13 Week Cashflow Model”).
Why the 13-week horizon is useful
Thirteen weeks is long enough to include several payroll cycles, recurring bills, tax remittances, inventory purchases and debt payments, while remaining close enough that many receipts and obligations can be estimated from current records. The first few weeks may contain near-term commitments; the later weeks are more assumption-driven and should be treated as estimates that will improve as information arrives.
#1 Best Overall
- [Ultra-Lightweight Ear Buds Designed for Small Ears] Each earbud weighs only 3.7g and features a compact, ergonomic in-ear design made especially for small ears. Secure, low-profile, and comfortable for workouts, all-day wear or overnight sleeping.The ultra-slim profile sits flush in your ear with no hard edges poking or rubbing, so you can even sleep on your side without discomfort.
- [Immersive Stereo Sound with TOZO OrigX Technology] TOZO OrigX tuning delivers clear vocals, balanced mids, and natural stereo sound for music, podcasts, and videos.
- [Long Battery Life for Daily Use] Get up to 7 hours of playtime on a single charge, with up to 32 hours total using the charging case—ideal for workdays, commuting, and extended listening sessions.
- [Bluetooth 5.3 & Stable Connection] Bluetooth 5.3 provides fast pairing, stable wireless performance, and reduced dropouts as you move around home or office.
- [Deep Bass with Clear Vocals] High-performance drivers produce punchy bass while keeping vocals clean and detailed for everyday listening.
The forecast is an early-warning instrument. A low projected balance tells you where to inspect the assumptions and obligations behind the number. It does not decide whether to borrow, delay a payment, change purchasing, or take another action; those decisions depend on your records, agreements, cash requirements and professional advice.
Choose the spreadsheet structure before entering numbers
Create one column for each consecutive week and label every column with a clear week-ending date. A practical workbook has a forecast sheet plus an actual-versus-forecast area or a separate worksheet that preserves the old estimate for comparison. One rolling-forecast guide uses fourteen columns when the additional column is reserved for week-one actuals; the forecast horizon itself remains 13 future weeks (IMEG Online rolling 13-week forecast guide).
| Section | What to include | Why it matters |
|---|---|---|
| Opening cash | Actual accessible cash at the start of week one | Anchors the entire roll-forward |
| Cash receipts | Customer collections, cash sales and other credible inflows by expected week | Shows when money should reach the bank |
| Cash payments | Payroll, payroll taxes, vendors, inventory, rent, utilities, taxes, debt and other disbursements by expected week | Shows the obligations that consume liquidity |
| Net cash flow | Total receipts minus total payments | Shows the weekly increase or decrease |
| Closing cash | Opening cash plus net cash flow | Becomes the next week’s opening balance |
Keep material categories separate. A single “operating expenses” total can conceal the fact that payroll is due Monday, rent is due Friday and a vendor payment moved to the following week. Detail makes a low balance traceable.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Step 1: Set the 13-week horizon
- Choose a consistent week boundary, such as a specified week-ending day.
- Enter 13 consecutive week-ending dates across the forecast columns.
- Record the date and definition of the opening balance (for example, available bank cash at the start of week one).
- Add rows for opening cash, receipts, payments, net cash flow and closing cash before adding detailed categories.
- If you will compare results, add an actuals column or worksheet without overwriting the original forecast.
Do not mix weekly periods of different lengths or silently move a transaction between weeks. Consistent boundaries are essential when comparing forecast and actual results.
Step 2: Reconcile the opening cash balance
Use the cash that the business can actually access, not an unreconciled accounting figure. Decide which bank accounts are included and how you will treat uncleared deposits, outstanding checks and transfers. Apply that definition consistently every week. Enter the balance and its date so another person can reconcile it to the bank statement or online balance.
If a deposit is recorded in the ledger but will not clear until later, either exclude it from available opening cash and schedule it as a receipt in its expected clearing week, or use another consistent treatment. The important control is avoiding both an inflated opening balance and a second count of the same receipt.
Step 3: Forecast receipts by collection week
Start with customer-level evidence
Review open invoices, promised payment dates, recurring contracts, point-of-sale history and known customer arrangements. List customers or receivable groups when that detail is available, then place the expected amount in the week the cash should arrive. An invoice date is not a collection date. If a customer normally pays 30 days after billing, use the expected clearing week rather than the week revenue was recorded.
Rank #2
- 【IP68 Waterproof Multifunctinal Smart Watch】Torjalph fitness activity tracker smart watch is IP68 waterproof technology ,you can wear it when swimming,handwashing,it's rain-proof which means that you perform multiple exercise modes outside without worrying about sweat or rain corroding your fitness smart watch,and this watch equipped with a 230 mAh large capacity battery magnetic charging ,and this sports activity tracker watch can be used 5-7 days If fully charged.
- 【Larger 1.83'' Full Screen Watch & Multi-dial Selection】1.83 inch full HD color touch screen smart watch for men / women provides excellent 240*284 resolution image quality ,This Bluetooth smart watch offers a better touch experience and remarkable immersion and ,more than 200 watch faces for you to choose from App"Da Fit ", you can change the dial style according to your mood to wear keeping the world on your wrist
- 【Accurate Activity Tracker Smart Watch 】sports watch activity tracker uses sweat and dust resistant breathable silicone strap, our Fitness Tracker Smart Watch for Android iOS Phones supports 12 sports modes,walking,running,bicycle,swimming,badminton,basketball,football,rope skipping. This bluetooth calls smart watch for men women is lightweight and stylish, bringing more convenient and relaxing sports experience while also providing more protection.
- 【Your 24 Hour Personal Daily Health Monitor】Fitness watch for women men full touch screen IP67 waterproof bluetooth smartwatch for Android iOS Phones with heart rate blood pressure monitor multifunction Andriod smart watch with steps counter sleep monitor sports fitness watch, monitoring blood oxygen saturation allows you to understand your physical condition in real time to track fitness progress ,to know your health status in time.
- 【More Functions Bluetooth Call Smart Watch】This fitness activity smart watch full screen for iPhone and Android phones includes a bunch of new features including:The bluetooth smart watch can hang up the phone, receive and display WhatsAPP /Text /Facebook /Twitter /Messenger reminder.Support sedentary reminder, alarm clock, stopwatch, timer,weather information,music control, remote camera control compatible with Android 5.0 and above or iOS 9.0 and above smartphones.
Add cash sales and other inflows
Include cash sales, owner contributions, confirmed financing proceeds, refunds and other credible sources only when their timing is supportable. Separate ordinary collections from unusual or one-time inflows so a later reviewer can see which assumptions are repeatable.
Label uncertainty
Near-term receipts supported by a customer confirmation are different from a distant estimate based on a sales target. Add a note, confidence label or assumption field outside the arithmetic rows. Do not treat an estimate as a guaranteed collection. As each week closes, replace the estimate with the actual deposit and revise the remaining customer dates.
Step 4: Forecast payments by payment week
Use the accounts-payable detail, payroll calendar, tax schedule, lease terms, purchase plans and debt agreements. Put each amount in the week it is expected to leave the bank, including known one-off payments. Adapt the categories to the business; a sample layout in the Holdings template includes the following lines (Holdings 13-week cash flow forecast template):
- Employee and contractor payroll
- Payroll taxes and other payroll-related remittances
- Rent or other facility costs
- Inventory or cost-of-goods purchases
- Software and insurance
- Utilities and professional services
- Loan or other debt payments
- Estimated taxes, without assuming a jurisdiction-specific due date unless verified
- Capital purchases
- Travel
- Owner distributions
The sample lines are not a mandatory chart of accounts. Add categories that matter to your business and remove irrelevant ones. Keep a payment separate when its timing or size could change the decision about the low-cash week.
Free tools Windows power users keep installed
One-click scans. No signup required.
Step 5: Calculate the weekly roll-forward
For every week, calculate total receipts and total disbursements, then apply the same formulas:
- Net cash flow = total receipts − total disbursements.
- Closing cash = opening cash + net cash flow.
- Next week’s opening cash = current week’s closing cash.
In a spreadsheet, the closing-cash formula in each column should reference that column’s opening cash and net cash flow. The opening-cash cell in the next column should reference the preceding closing-cash cell. Add a check row that flags a missing opening balance, a negative closing balance or a total that does not equal the visible detail rows.
Review the model for double counting. A customer deposit should not appear both in opening cash and week-one receipts; a loan payment should not be included in both debt service and a broad “other payments” line.
Rank #3
- [Low Noise High Fidelity] New bee guitar cord with 22AWG oxygen-free-copper center conductors provides enhanced signal transfer, the PVC insulation material and the high-density stranded copper double shield provide noise rejection for quiet operation
- [Ideal for Choice] New bee 1/4 straight and right angle metal connectors, ensures a secure connection in any instrument, pedal, or amp jack. L shape great fro on stage guitar stands
- [Wide Compatible] Suitable for mixer, power amplifier, microphone, effector, decoder, equalizer, electoronic organ, electric guitar, electric bass and other electronic equipments. Widely used in the installation of smart home, karaoke speaker, professional stage audio, etc
- [Easy Disassemble] Making incidental repairs quick and easy! Very nice, flexible cable
- [Dont Hesite to Order] 24 hours customer services and professional technology team are standing by
Step 6: Locate and investigate the low week
Scan the closing-cash row for the lowest projected balance and for any week in which the business may not meet an obligation. Then trace that week back to its receipts and payments.
Recommended Free Tools
- Which customer collections are assumed, and what evidence supports their dates?
- Which payments are fixed, contractually due or movable?
- Is a payroll, tax, rent, inventory or debt item missing or placed in the wrong week?
- Does the opening balance include cash that is restricted, held in another account or not yet cleared?
- Is the low point caused by one unusual item or by a recurring structural shortfall?
Test the assumptions rather than simply changing the low number. A later-week collection may move, while a scheduled payroll run may be comparatively certain. Record the reason for each material change so the next update reflects what actually happened.
Worked illustration of the math
The following figures are illustrative only. Suppose week one begins with $25,000 available. Expected receipts are $12,000 and expected payments are $18,500:
| Week | Opening cash | Receipts | Payments | Net cash flow | Closing cash |
|---|---|---|---|---|---|
| 1 | $25,000 | $12,000 | $18,500 | −$6,500 | $18,500 |
| 2 | $18,500 | — | — | — | — |
Week two must begin at $18,500, regardless of whether the accounting books show a different profit or revenue figure. Replace the dashes with week-two receipts and payments; the same sequence continues through week thirteen. In your live sheet, use “0” for a confirmed zero and leave a cell blank only when your spreadsheet design clearly distinguishes “not entered” from “none expected.”
Step 7: Compare actuals and roll the forecast forward
When a week closes, enter the actual deposits and payments, retain the original forecast, and calculate the variance. Note material differences—such as a customer paying late, a vendor invoice arriving early or payroll changing—then use those facts to revise the remaining weeks.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →- Close the completed week using bank activity and other reliable records.
- Compare actual receipts and payments with the prior forecast by category and date.
- Explain material variances in a notes column or log.
- Move the former week two into the new week one position, preserving its now-known actual result.
- Continue the sequence through the remaining weeks and add a new week thirteen.
- Recheck the low projected balance and all obligations after the update.
The rolling guide notes that a two-week update cycle can also suit some businesses, but the cadence should match how quickly collections, payments and risks change (IMEG Online rolling forecast guide). The farther a week is from the present, the more likely its assumptions are to change; rolling the horizon prevents an old estimate from becoming a forgotten promise.
Blank spreadsheet or downloadable template?
Both are legitimate starting points. Choose based on how much structure you need and how unusual your cash categories are.
Rank #4
- Digital Family Calendar: BSIMB digital calendar wall touch screen puts an end to your chaotic life. Designed for busy families, the digital calendar keeps you organised and in step with your family. Assign different colours and tasks to each family member to make family scheduling easier and more intuitive.
- Easy Setup and Auto-Sync: Plug in, connect to WLAN and auto-syn your electric calendar in minutes. Digital wall calendar compatible with Google calendar, iCloud calendar, Outlook calendar, Cozi calendar and Yahoo calendar. Add events directly on the device or through the ecalendar app. Electronic calendar stays current whether you're at work or traveling—no manual updates needed.
- All-In-One Home Assistant: Smart calendar builds habits and encourage independence with personalised chores. Display daily meal plan to reduce the daily ‘What's for dinner?’ stress. To-do lists keep track of everything you want. Turning chores into valuable achievements with stars and rewards, making life easier and more enjoyable.
- Manage Anytime Anywhere: BSIMB electronic calendar for family stay connected with the powerful ecalendar app. Access and manage your digital wall calendar anytime, anywhere with free features like stars & rewards, photo screensaver, chore charts, meals plans, to-do lists etc. Electronic planner paid features like Magic Import tailor advanced tools for users with special needs.
- Stay in Touch with Loved Ones: Share photos or videos from your phone to electronic wall calendar with app, instantly update your life moment, and keep in touch with your family, especially those who are far away; you can also surprise your smart calendar digital wall by sending him a wish card; it's also great for keeping tech-illiterate elders in touch with the youngsters.
| Starting method | Setup effort | Tailoring | Formulas and structure | Best fit |
|---|---|---|---|---|
| Blank/custom spreadsheet | More initial design and checking | Complete control over rows, departments, accounts and notes | You create and test the roll-forward formulas | Businesses with unusual payment timing or existing spreadsheet controls |
| SCORE “13 Week Cash Flow Analysis” XLSX | Lower initial setup | Adapt the supplied layout to your own receipts and payments | Provides a downloadable starting file for analysis | Owners who want a ready-made workbook to customize |
| Holdings PDF layout | Useful as a category reference | Sample rows are illustrative, not mandatory | Shows common receipt/disbursement rows and basic formulas | Owners designing their own sheet and checking whether major categories are missing |
SCORE lists its downloadable file as “13 Week Cash Flow Analysis” and says it can be used for the owner’s analysis or with a financial advisor (SCORE template page, March 28, 2020). It is a digital XLSX resource, not a physical product. Neither a template nor a spreadsheet removes the need to reconcile opening cash, verify dates and update actuals.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Controls that keep the forecast useful
Use one definition of available cash
Document which accounts and clearing items are included. If the definition changes, record the change and its effect rather than allowing the opening balance to jump without explanation.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchKeep assumptions beside the numbers
For each material receipt or payment, note the customer, vendor, contract, payroll date, expected clearing date or other basis. This turns a spreadsheet cell into an auditable assumption.
Separate actuals from estimates
Color, columns, labels or separate worksheets can distinguish completed bank activity from forecast amounts. Never overwrite the old forecast; otherwise you lose the information needed to understand recurring variance.
Check completeness every update
- All relevant bank accounts are included.
- Customer collections are dated by expected receipt, not invoice date.
- Payroll, payroll taxes, vendors, inventory, rent, utilities, taxes and debt are reviewed.
- One-time capital purchases, travel and owner distributions are included when planned.
- Every closing balance links to the next opening balance.
- No transaction appears in two categories.
Common mistakes and how to correct them
Using sales or profit as cash
Symptom: the forecast shows healthy revenue but the bank balance still falls. Correction: replace accrual revenue with the amount expected to be collected in each week and document the collection assumption.
Putting every receipt in the invoice week
Symptom: cash appears earlier than it can clear. Correction: use customer terms, payment history and confirmed dates to move the receipt to its expected bank week.
Hiding payments in one total
Symptom: the low week cannot be explained or challenged. Correction: split material payroll, vendor, inventory, rent, tax, debt and one-off lines so the timing can be investigated.
Failing to carry closing cash forward
Symptom: each week appears to start with the same balance or an unexplained number. Correction: link every week’s opening cash to the preceding closing-cash formula.
Overwriting the previous forecast
Symptom: you cannot tell whether a miss came from timing, amount or a missing item. Correction: preserve the prior forecast, enter actuals separately and record variances.
Treating week thirteen as certain
Symptom: distant receipts are defended as guaranteed while near-term obligations are overlooked. Correction: label later estimates, revisit them at each roll and use the newest customer and vendor information.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Ignoring a low projected balance
Symptom: management notices the cash problem only when a payment is due. Correction: investigate the assumptions and obligations behind the low week as soon as it appears, then obtain appropriate business-specific advice before making financing or payment decisions.
When to involve an accountant or bookkeeper
You can build the schedule yourself when the business has reliable bank, receivable, payable and payroll records. Consider outside help when transactions are complex, reconciliations are behind, several entities or accounts are involved, or the forecast will support a consequential financing or operating decision.
The SBA explains that a business can consider a CPA, bookkeeper or online accounting service for help. It characterizes CPA advice as generally more tailored and higher cost, while bookkeeping focuses on basic day-to-day work at lower cost (SBA business-management guidance). The choice does not transfer responsibility for validating the cash assumptions: management still needs to confirm expected receipts, payment commitments and the definition of available cash.
How this forecast fits with longer-term planning
A 13-week schedule is a short-term liquidity tool, not a replacement for a business plan or annual budget. SBA business-plan guidance calls for longer financial projections and says the first year should be more specific, typically quarterly or monthly (SBA planning guidance). Use those longer projections for strategic planning, but continue to use weekly cash dates when deciding whether the business can meet near-term obligations.
Quick Recap
Operating checklist
- Label 13 consecutive week-ending dates.
- Reconcile the opening balance to actual accessible cash and record the date and definition.
- List customer collections, cash sales and other credible receipts by expected clearing week.
- List payroll, payroll taxes, vendors, inventory, rent, utilities, taxes, debt and relevant one-off payments by expected payment week.
- Calculate receipts, payments, net cash flow and closing cash for every week.
- Link each closing balance to the next opening balance and check for double counting.
- Identify the lowest projected week and inspect the assumptions behind it.
- At each update, enter actuals, preserve the old forecast, explain material variances and add a new week thirteen.
- Use professional advice for business-specific tax treatment, contractual obligations and financing decisions.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
