--- title: "13-Week Cash Flow Forecast for Small Businesses | MCC" description: "Learn to build a rolling 13-week cash flow forecast: what to include, how to estimate collections and payments, and how to update it each week." url: "https://mcc-solutionsnj.com/bookkeeping/guides/13-week-cash-flow-forecast-for-small-business" --- Bookkeeping guide · Updated October 12, 2026 # 13-Week Cash Flow Forecast for Small Businesses A 13-week forecast is a short-range cash plan that rolls forward every week. Unlike a yearly budget, it is about timing: when money will actually arrive and leave. It is a favorite tool when cash is tight or growth is fast. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** A 13-week forecast is a short-range cash plan that rolls forward every week. Thirteen weeks is one quarter, long enough to see problems coming. Each week you drop the week that passed, add a new one at the end and compare actual to expected. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [Closing entries and retained earnings](/bookkeeping/guides/closing-entries-and-retained-earnings) · [Void vs delete a transaction](/bookkeeping/guides/voiding-vs-deleting-transactions) · [NJ 1099 contractor rule (ABC test)](/bookkeeping/guides/nj-independent-contractor-rule-abc-test-2026) **Free tools:** [Do I need to send a 1099?](/bookkeeping/do-i-need-to-send-a-1099) · [Bank reconciliation not matching?](/bookkeeping/bank-reconciliation-difference-finder) [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## Why thirteen weeks Thirteen weeks is one quarter. It is long enough to see problems coming and short enough that your guesses are reasonably good. Each week you drop the week that passed, add a new one at the end, and compare what happened to what you expected. Because it is a rolling view, it keeps you honest about customer payment timing and big bills. ## Build the layout Use a spreadsheet with weeks across the top. Rows start with the opening bank balance, then cash coming in, cash going out, and the closing balance. The closing balance of one week is the opening of the next. Under cash in, list customer collections, deposits, loan proceeds and owner contributions. Under cash out, list payroll, taxes, rent, supplier payments, loan payments, owner draws and planned purchases. ## Estimate collections realistically Use the aging report. For each large open invoice, put the amount in the week you think it will really be paid, based on how that customer pays, not on the due date. For sales not yet invoiced, estimate using normal collection time. Be cautious here. Optimistic collections are the main reason forecasts fail. If a customer is usually two weeks late, plan for it. ## List payments by due date Use the unpaid bills list and the calendar. Payroll and payroll taxes, sales tax, insurance renewals, quarterly estimated tax payments and loan payments often land on fixed dates. Put each in the right week. Include a small cushion for surprises. Remember money that leaves monthly or quarterly rather than weekly. A forecast that only shows weekly bills will look fine until a large quarterly item arrives. ## Use it to decide Watch the lowest closing balance. If it dips below a minimum you set, act early: ask customers to pay sooner, delay a purchase, negotiate with a supplier or arrange credit. Doing it weeks ahead costs less than doing it in a crisis. Update every week with actuals. Over a few weeks, you will learn where your estimates are weakest and improve them. Software reports help, but the forecast itself is a thinking tool, so keep it simple. ## A tip on scenarios Run two versions: the expected case and a cautious case where your three largest customers pay two weeks late. Comparing the lowest balances in each shows how exposed you are to a single late payment. If the cautious case dips below your minimum, you know exactly how much credit or reserve cash would solve the problem, and you can arrange it while banks and suppliers are still willing to listen. Do not worry if the first version is rough. The value comes from the weekly update, when you compare what you expected with what happened and ask why. After a month, you will notice which customers pay on time, which bills you forgot, and how much cushion the business really needs. ## Common questions **Is this the same as a budget?** No. A budget plans profit by month. A cash forecast tracks the timing of money by week. **Do I need accounting software for it?** Software provides the inputs such as aging and bills, but a spreadsheet is usually used for the forecast. **How long does it take to maintain?** Once built, many owners need less than an hour a week. This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online)[### FreshBooks Bookkeeping, invoice clean-up and reconciliation in FreshBooks for New Jersey freelancers and service businesses. FreshBooks →](/bookkeeping/software/freshbooks) More guides - [Financial Ratios Small Business Owners Should Know](/bookkeeping/guides/financial-ratios-small-business-owners-should-know) - [Month-End Adjusting Entries Every Owner Should Know](/bookkeeping/guides/month-end-adjusting-entries-checklist) - [Year-End Bookkeeping Close: Steps Before Tax Time](/bookkeeping/guides/year-end-bookkeeping-close-steps) - [What Is an Audit Trail in Bookkeeping?](/bookkeeping/guides/audit-trail-in-bookkeeping) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). ## Try a quick 13-week cash flow Enter a few numbers to see 13 weeks of cash and your lowest week. It is deliberately simple: sales come in the same each week (or grow by a percent you set), payroll goes out every other week, and rent and a loan payment go out every fourth week. Nothing is sent or saved. A rough guide. It ignores when customers actually pay you, taxes due on set dates and surprises. The [13-Week Cash Flow Forecast workbook](/toolkits/cash-flow-forecast-13-week) spreads customer payments over the weeks they usually arrive, puts monthly and quarterly bills in the week they fall due, and adds a stress case. Not financial advice. Excel workbook ### 13-Week Cash Flow Forecast List what you expect to collect and pay, and see your cash balance each week, the lowest point and when it happens. [See what is inside ($29)](/toolkits/cash-flow-forecast-13-week) [Try the free starter](/toolkits/cash-flow-forecast-13-week#free-starter) Also in the [Business Planning Bundle](/toolkits/business-planning-bundle): 4 products for $79 instead of $106 separately. Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)