Find a Week-One Cash Gap Even When Week Two Recovers

A positive two-week result can hide the temporary shortage when payroll comes first. The worksheet for this decision tracks minimum draw to cover weekly cash shortfalls and keeps the other amounts visible so you can reconcile the estimate with your own paperwork. The worked example uses fictional figures in U.S. dollars. Replace them with confirmed values for your own business cash flow and financing decision before relying on the comparison.

Start with the documents you can reconcile

Write cash available at the start, then separate confirmed receipts and required payments into the two weeks. Carry week one’s ending balance into week two. Check both endings rather than looking only at the total across both weeks. For a business, use cash receipts instead of invoice dates when deciding whether a payment can be covered. Mark whether cash is unrestricted, whether a draw has actually funded and whether a supplier requires payment before delivery. Ask whoever maintains your ledger to reconcile the amounts to bank activity. Keep a separate operating reserve if payroll or taxes must be protected.

Keep an estimate column and a confirmed column while you gather the inputs. A blank line should mean you are still waiting for a number, while a zero should mean you confirmed no amount applies. If the number is unsettled, run a range or a separate downside case instead of entering zero in a way that makes the decision appear cheaper. Record the date of each figure so it is clear when to refresh the worksheet.

Worked example with two scenarios

The reference case uses the calculator’s starting values. This guide tests what happens when you change week two confirmed receipts from $12,000.00 to $18,000.00. All unchanged inputs are kept at their reference values, so the difference below reflects the specified changes. The table shows the inputs to compare before you interpret any of the totals.

In the reference case, minimum draw to cover weekly cash shortfalls is $2,000.00, with week-one ending cash without borrowing of -$2,000.00 and week-two ending cash without borrowing of -$1,000.00. In the scenario for this guide it stays at $2,000.00. Week-one ending cash without borrowing is -$2,000.00, and Week-two ending cash without borrowing is $5,000.00. The difference in the first row is $0.00 at the displayed precision. Use the secondary rows to see where that difference comes from. They represent components or additional checks, so adding every result together would combine amounts that can describe the same money from different angles.

Carry the first week’s ending cash forward. Use the lowest weekly position as the initial draw estimate and review the days within each week.

Find the low point before the final balance

One week can end in a cash deficit even when the next week recovers. The starting balance carries from one week to the next, so inspect both ending positions. A draw sized only from week two can miss the first deficit. This worksheet assumes you can fund the bridge before the low point and excludes draw costs and repayments. If receipts tend to post after payroll, a daily ledger may show a larger need than either weekly result. Use cleared cash and dated obligations to decide whether the weekly estimate is detailed enough.

Check which inputs move the result

If week one payments ($) changes from $14,500.00 to $15,950.00, minimum draw to cover weekly cash shortfalls rises to $3,450.00. In the same run, week-one ending cash without borrowing becomes -$3,450.00 and week-two ending cash without borrowing becomes $3,550.00. This comparison holds every other entry constant, so it isolates that input. If your offer changes more than one amount at once, put all the revised amounts into a separate scenario and compare the complete set of results.

If week one confirmed receipts ($) changes from $8,000.00 to $8,800.00, minimum draw to cover weekly cash shortfalls falls to $1,200.00. In the same run, week-one ending cash without borrowing becomes -$1,200.00 and week-two ending cash without borrowing becomes $5,800.00. This comparison holds every other entry constant, so it isolates that input. If your offer changes more than one amount at once, put all the revised amounts into a separate scenario and compare the complete set of results.

If opening cash ($) changes from $4,500.00 to $4,950.00, minimum draw to cover weekly cash shortfalls falls to $1,550.00. In the same run, week-one ending cash without borrowing becomes -$1,550.00 and week-two ending cash without borrowing becomes $5,450.00. This comparison holds every other entry constant, so it isolates that input. If your offer changes more than one amount at once, put all the revised amounts into a separate scenario and compare the complete set of results.

A small change that produces no movement in the headline result can still be worth noting. Some worksheets apply a cap or floor, and the first row may stay flat until an input crosses it. Look at the secondary amounts and test the actual limit rather than extrapolating from one small change. Save the reference settings first so that a later comparison starts from the same assumptions.

What this worksheet assumes

Models cash at two week ends, without interest or fees. Receipts and payments within each week are grouped. Daily shortfalls can be larger than weekly totals imply.

The output uses the values you supply and rounds displayed amounts for readability. A lender, school, vendor or other party may use different dates, fees, credit treatment or rounding. If a statement and the estimate disagree, first check that the figures refer to the same dates and the same underlying balance. Then separate formula differences from missing cash items. This makes it easier to ask a targeted question about a particular line rather than trying to reconcile a single total.

Before you act on the estimate

Build a daily ledger when payroll or vendor payments are due before expected receipts in the same week. Confirm timing for funding, receivables and deposits before committing to the draw size.

Take the scenario closest to your actual situation and put the opening cash, dated receipts and dated obligations in order. Flag any entry you cannot confirm and identify the first payment that depends on it. If a supplier, lender or other party changes that figure, update that entry first and rerun the comparison. Save both versions with the dates they were prepared so another person can see what changed and which documents support the revision.

If two alternatives are close, check what would make their order switch. For example, one alternative may depend on an unconfirmed fee or receipt, while the other depends on a date or rate you already have in writing. The sensitivity runs above help distinguish a difference that survives a small revision from one that disappears when the input moves. In your final notes, state what you verified and which assumptions still need a quote or statement.

What should I do if I only have a rough figure?

Use the rough amount as a labeled starting point and run a second version using a plausible less favorable amount. Keep the exact written quote when it arrives and replace the estimate. If the updated figure changes the headline result but leaves the earliest payment unchanged, still check that the cash is available by the relevant date. If both the amount and the date change, update the payment calendar as well as the worksheet.

When should I run the numbers again?

Recalculate when a fee, installment, credit, cost or payment date changes, and once more when you have the paperwork that will govern the decision. Use the same units and time window in both versions. If the only change is timing, keep the amount the same in your first comparison so you can see that effect separately. Compare the new result with the written figures rather than carrying forward an older estimate.

Open the Business Two Week Cash Draw Calculator to substitute your own inputs. Model a Bigger Draw When Vendor Payments Cluster in Week Two covers another scenario for the same worksheet. See also the SBA small-business loan programs for background on business cash flow and financing.