13-Week Cash Flow Forecast: Build One From Your Sales Data

On this page 7 sections

1. Why a 13-Week Cash Flow Forecast Beats an Annual Budget
2. Setting up Your Cash Flow Forecast Template
3. Projecting Inflows: Card Deposits, Cash, ACH, and Invoice Collections
4. Accounting for Fees, Holds, Refunds, and Deposit Lag
5. Projecting Outflows: Payroll, Rent, Inventory, Taxes, and Debt
6. Updating Weekly and Reading the Warning Signs
7. Next Steps

Key takeaways

• Forecast card receipts from actual deposit timing and amounts, not gross sales on your POS report.
• Calculate a deposit ratio from recent weeks to capture fees, refunds, and other deductions automatically.
• Enter reserves, chargebacks, tips, and collected sales tax explicitly, because they change what you can spend.
• Roll the forecast forward every week and act early when any week drops below your minimum cash buffer.

A 13-week cash flow forecast projects, week by week, how much cash will enter and leave your bank account over the next quarter. It is the most practical tool a small business owner has for spotting a shortfall before it happens. This guide shows you how to build one from your own sales data. You will learn how to project receipts from actual card deposit timing, processing fees, and reserves, so your forecast matches what lands in the bank and not just what rang up at the register.

Why a 13-Week Cash Flow Forecast Beats an Annual Budget

An annual budget tells you whether the year should be profitable. It does not tell you whether you can make payroll on the 15th when rent, a large inventory order, and a quarterly tax payment all hit the same week.

A 13-week forecast fills that gap:

• It runs on cash, not accruals. Revenue counts when the money arrives and expenses count when the money leaves.
• It is short enough to be accurate. You know your payroll dates, vendor terms, and loan payments for the next quarter. You don't know them for next October.
• It is long enough to act. Thirteen weeks gives you time to delay a purchase, collect a receivable, or arrange financing before a tight week arrives.
• It rolls. Each week you drop the oldest week and add a new one, so you always look a full quarter ahead.

For card-heavy businesses, the biggest source of forecasting error is treating gross sales as cash. A Saturday sale on your POS report may not reach your account until midweek, and it arrives net of fees, refunds, and any reserve. The steps below build that reality into the model.

Setting up Your Cash Flow Forecast Template

You don't need special software. A spreadsheet works well. If you keep your books in QuickBooks, export your bank and sales data to fill it. MannyPay supports a QuickBooks integration for merchants who want processing data and accounting in one place.

Columns: 13 Weeks With Consistent Dates

Set up 13 columns, one per week. Pick a fixed week definition, such as Monday through Sunday, and keep it the same throughout. Label each column with its start date. Bills and deposits rarely fall on week boundaries, so the dates are what make the forecast usable.

Opening Cash

Start week one with your actual bank balance, not the balance in your accounting software. Uncleared checks and pending transfers can make those two numbers differ. Each later week opens with the prior week's ending cash.

Row Categories

Keep the structure simple:

Add a line under ending cash that flags any week where ending cash falls below your buffer. That flag is the reason the whole exercise exists.

Projecting Inflows: Card Deposits, Cash, ACH, and Invoice Collections

This is the core of building a small business cash flow projection. The goal is to forecast deposits, not sales.

Card Deposits: Start From Settlement, Not Sales

Pull 8 to 13 weeks of history and put two numbers side by side for each week:

1. Gross card sales from your POS or gateway report
2. Actual card deposits from your bank statement

Divide total deposits by total gross card sales over that period. The result is your deposit ratio. It captures fees deducted from deposits, refunds, and other routine adjustments in one number. If you haven't matched deposits to sales before, start with our guide to matching card deposits to sales every month.

Next, map timing. Note which day's sales land on which deposit day. Sales from late in the week, especially Friday through Sunday, often deposit in the following week. Your processor's batch cutoff and funding schedule determine the exact lag. Our article on how long credit card deposits take around batches, weekends, and holidays explains the mechanics. To weigh faster funding options, see our guide to same-day funding and instant payouts and whether the fee is worth it.

Here is how one week converts. All figures are illustrative:

To forecast future weeks, estimate gross card sales from the same weeks last year or from recent trends, apply your deposit ratio, and shift the late-week portion into the following week.

Cash Sales

Forecast cash by the day you actually take it to the bank, not the day you collect it. If you pay some expenses or tip-outs from the drawer, forecast only what is deposited.

ACH and Invoice Collections

For B2B sales and invoiced work, forecast collections from your receivables aging, not from invoice due dates. If customers typically pay 10 days after the due date, forecast that. Be conservative with past-due invoices.

How Inflows Differ by Industry

• Restaurants and bars: Sales concentrate on weekends, so deposit lag has an outsized effect. Card tips arrive in your deposits but go back out to staff, either nightly in cash or through payroll. Forecast both sides.
• Retail stores: Seasonal peaks drive deposits, and post-holiday returns reduce them. Use last year's same weeks as your baseline, not last month.
• E-commerce stores: Refunds trail sales by days or weeks as returns come back, so your deposit ratio may dip after a promotion. Marketplace or platform payouts may follow their own schedule, separate from your gateway deposits.
• Contractors: Receipts are lumpy. Forecast each job's payment schedule individually: a deposit at signing, progress payments at milestones, and a final payment at completion. Card payments taken through a virtual terminal for keyed and remote payments follow card deposit timing. Checks and ACH follow your customers' habits.

Accounting for Fees, Holds, Refunds, and Deposit Lag

These items are the difference between a forecast you trust and one that surprises you.

Processing Fees: Daily vs. Monthly Deduction

Check your statement to see how fees are collected:

• Daily discount (net funding): Fees come out of each deposit. Your deposit ratio already captures them.
• Monthly billing (gross funding): Deposits arrive at full value, and fees are debited in one lump, often early in the following month. Enter that debit as an outflow in the right week. Forgetting it is a common source of first-week-of-the-month surprises.

If your fees seem to drift up without an obvious reason, look at your pricing model. Our comparison of interchange-plus vs. flat-rate pricing explains what drives the difference. If you use a cash discount or dual pricing program, your deposit ratio will change after enrollment, so recalculate it from fresh data. You can review how a cash discount program works and confirm whether it suits your business and complies with the rules in your state.

Reserves and Holds

If your merchant agreement includes a rolling reserve, a portion of each deposit is held for a set period and then released. Forecast two lines: the reduced deposit now, and the release later as a separate inflow. Use the exact percentage and hold period in your agreement.

Unplanned holds are harder to forecast, but you can reduce the odds. Large tickets far above your normal average, sudden volume spikes, and rising disputes can trigger reviews. If funds have been held before, read why processors hold funds and how to resolve it. Contractors taking a large deposit or an e-commerce store launching a big promotion should consider telling their processor in advance. For more on avoiding holds on large orders, see our guide to jewelry merchant accounts and high-ticket sales without high holds.

Refunds and Chargebacks

Refunds usually reduce deposits directly. Chargebacks are typically debited from deposits or your account, sometimes with a fee. If disputes are a regular part of your business, forecast a weekly allowance based on recent history. Our walkthrough of the full chargeback dispute lifecycle explains when money leaves and when a won dispute may return it.

Deposit Lag Around Weekends and Holidays

Bank holidays push deposits back. Mark every bank holiday in your 13-week window and shift the affected deposits. A Monday holiday after a busy weekend can move a large share of a week's receipts into the next week.

Money That Arrives but Isn't Yours

Your deposits include sales tax you have collected and, for restaurants and bars, card tips owed to staff. Neither is spendable. Either subtract them from inflows or, better, show them as outflows on the dates you remit or pay them.

Projecting Outflows: Payroll, Rent, Inventory, Taxes, and Debt

Outflows are usually easier to predict than inflows. List each one by its actual payment date.

1. Payroll and payroll taxes. Use your pay schedule. Watch for months with an extra pay period.
2. Rent and occupancy. Include common-area or utility charges billed separately.
3. Inventory and materials. Forecast by vendor payment terms, not delivery date. Retailers often pay for seasonal stock weeks before it sells. Restaurants buy food several times a week. Contractors may need to fund materials before a job's first progress payment.
4. Sales tax remittances. Enter them on your filing schedule. Requirements vary by state and locality.
5. Estimated income taxes. Enter payments on your estimated tax schedule. Confirm amounts and dates with your accountant.
6. Loan, line of credit, and lease payments. If you have a merchant cash advance, remittances may come out daily or weekly. Our guide to how a merchant cash advance works and what it costs explains how those payments affect cash flow.
7. Recurring operating costs. Include insurance, software subscriptions, utilities, advertising (for e-commerce, ad spend charged to a business card hits when you pay the card), and equipment leases.
8. Owner draws. Forecast them explicitly so they don't quietly erode your buffer.

Tax timing and amounts are general information here, not tax advice. Confirm your filing and payment obligations with a qualified tax professional.

Updating Weekly and Reading the Warning Signs

Knowing how to forecast cash flow is only half the job. The forecast earns its value through a short weekly routine.

The Weekly Update

1. Replace last week's forecast with actuals from your bank statement.
2. Compare forecast to actual for each line and note the variance.
3. Recalculate your deposit ratio every month or two, or after any pricing or program change.
4. Drop the completed week, add a new week 13, and update known payments.
5. Check every week's ending cash against your minimum buffer.

A 20-minute review each Monday is usually enough.

Warning Signs to Watch

• A week below your buffer. This is the signal to act now, while you still have options.
• Deposits consistently below forecast. Look for rising fees, refunds, chargebacks, or a change in funding timing.
• Receivables aging longer. Customers paying slower is an early stress signal.
• New or larger reserves. Ask your processor why, and update the forecast immediately.
• Repeated reliance on short-term financing to cover routine weeks.

Actions When a Gap Appears

• Move a discretionary purchase to a later week.
• Ask for deposits upfront on large orders or jobs.
• Send invoices sooner and follow up on past-due accounts.
• Negotiate payment terms with key vendors.
• Arrange financing before you need it. Our comparison of a business line of credit vs. a term loan can help you choose.

Next Steps

Start with your last 8 to 13 weeks of POS reports and bank statements. Calculate your deposit ratio, map your deposit timing, and fill in known outflows by date. Your first version will be imperfect. After a few weekly updates, it will become a reliable view of the quarter ahead. To see why lenders are paying closer attention to bank account activity, read our coverage of cash flow underwriting and Prism Data's $20M raise.

If your statements make it hard to see how deposits are funded or what you are paying, a clearer processing setup makes forecasting easier. You can request a free quote from MannyPay, and a specialist will respond within one business day to walk through your current deposits, fees, and options.

ME

About the author

MannyPay Editorial Team

Beyond the Swipe's editorial desk researches the publication's guides and news and cites its sources in every article. Articles reviewed by a named MannyPay editor carry that editor's byline.

This article is for general educational purposes and is not legal, tax or financial advice. Card network rules and state laws change; confirm current requirements for your business.