Cash Timing Worksheet: Explain Receipts, Payments and a Funding Gap

A funding request is easier to understand when it shows exactly when cash is needed. A month-end balance alone can hide a difficult payroll week or a supplier payment that falls due before a customer collection. Use this cash timing worksheet to explain the size, timing and cause of a shortfall, then show how it could unwind.

Define the worksheet before entering figures

State the business or project entity, currency, starting date and forecast period at the top. Use weekly columns for near-term detail and extend the horizon when the operating cycle requires it. BDC identifies a rolling 13-week cash forecast, updated weekly, as a useful planning tool: https://www.bdc.ca/en/articles-tools/money-finance/manage-finances/making-projection-coming-year

This worksheet is a planning method, not a lender’s approval calculation. Prepare an initial view before new funding, then a separate view including proposed drawdowns, interest, fees and repayments. Keeping those views distinct makes the underlying need visible instead of making the forecast balance through an unexplained financing assumption.

Use seven rows for each week

Start with opening usable cash. Add expected cash receipts and subtract scheduled cash payments to obtain closing cash before new financing. Add a row for your chosen minimum cash balance, another for the gap to that balance, and a notes row explaining the largest assumptions. Carry each week’s closing balance into the following week’s opening balance.

The arithmetic is: closing cash before new financing = opening cash + receipts − payments. The cumulative funding gap for a week = the greater of zero or minimum cash balance minus closing cash before new financing. The peak gap is the largest of those weekly figures; do not add all the weekly cumulative gaps together.

BDC’s cash planner guidance uses expected inflows, outflows and a running bank balance, and suggests bank and credit-card records as a starting point. See: https://www.bdc.ca/en/articles-tools/start-buy-business/start-business/managing-working-capital-10-tips

Attach evidence to collection and payment dates

For each material receipt, record the customer or source, amount, expected clearing date, supporting invoice or contract, and the person who confirmed the timing. Separate an expected payment from money already received. Explain disputed invoices, milestone approvals and uncertain dates rather than giving them the same confidence as confirmed collections.

For each material payment, record its amount, due date and supporting schedule. Examples to examine include payroll, supplier invoices, rent, taxes and existing debt service. Add planned capital purchases separately so the operating need is clear. A proposed payment deferral belongs in a scenario until it is agreed; moving a date in the worksheet does not change the underlying obligation.

Worked example: four weeks, one peak gap

The following USD figures are fictional and exclude new borrowing, financing fees and interest. Assume opening usable cash of $800,000 and a management planning minimum of $300,000. The minimum is an example, not a universal reserve requirement. Negative balances below represent unmet cash needs, not permission to overdraw an account.

Week 1: $800,000 opening cash + $400,000 receipts − $1,000,000 payments = $200,000 closing cash. Gap to the $300,000 minimum: $100,000.

Week 2: $200,000 opening cash + $300,000 receipts − $1,300,000 payments = negative $800,000 closing cash. Cumulative gap: $1,100,000.

Week 3: negative $800,000 opening cash + $500,000 receipts − $1,000,000 payments = negative $1,300,000 closing cash. Cumulative gap: $1,600,000.

Week 4: negative $1,300,000 opening cash + $2,200,000 receipts − $600,000 payments = $300,000 closing cash. Gap: zero.

The peak modeled gap is $1.6 million in week 3. Funding would first be needed in week 1 to preserve the assumed minimum. In a separate, cost-free illustration, incremental draws of $100,000, $1 million and $500,000 would hold week-end cash at $300,000 through week 3. Week 4’s net receipt of $1.6 million would then match those accumulated draws. Real financing adds costs, conditions and its own repayment timetable.

A positive week-4 balance does not solve the earlier shortfall. Also examine large payments within each week: a Monday outflow followed by a Friday collection can create a larger temporary need than the week-end figures show. Use daily detail around those pressure points.

Test what happens when a receipt arrives late

Move the example’s $500,000 week-3 receipt to week 5, leaving payments unchanged. Week-3 closing cash becomes negative $1.8 million and its gap rises to $2.1 million. Week 4 then closes at negative $200,000 before new funding, leaving a $500,000 gap to the minimum. Extend the forecast into week 5 and beyond before describing when borrowing could be repaid.

This single timing change increases the modeled peak by $500,000 without changing the total value of the expected receipt. Prepare a short explanation of the delay assumption and what evidence would change it. Separately test cost increases or lower collections; keep timing changes distinct from amounts that may never be collected.

Review the worksheet before a funding discussion

• Reconcile opening usable cash to current records and explain restricted balances.
• Trace large receipts and payments to evidence and realistic dates.
• Check carry-forward formulas and confirm that cumulative gaps are not added together.
• Show the first cash pressure date, peak gap and expected recovery period.
• Test collection delays and examine material movements within each week.
• Add a separate financing scenario including fees, interest and repayment obligations.
• Date the forecast, assign an owner and explain material changes from the previous version.

Turn the numbers into a clear request

Summarize the need in one paragraph: the amount and currency, when access is required, the operating payments it supports, the evidence behind expected receipts and the proposed repayment source. Distinguish a forecasted need from confirmed financing availability. Update actual receipts and payments as time passes, retaining an explanation of significant differences.

For facility types and the terms to compare after identifying the need, read the CGFS working capital financing guide: https://www.creativeglobalfundingservices.com/working-capital-financing-options-terms/

Cash timing worksheet FAQs

Is the peak gap automatically the loan amount to request?

No. It is a starting point under stated assumptions. Financing costs, timing within a week, existing cash restrictions and the provider’s criteria can change the appropriate structure. The worksheet does not establish collateral eligibility, repayment capacity or approval.

Can I include an unapproved loan as a receipt?

Show it only in a clearly labeled proposed-financing scenario. Keep the unfunded view available so the reviewer can see the need if the loan does not close on the assumed date.

How long should the forecast run?

Long enough to show the pressure point and the expected repayment cycle. A 13-week view can be useful for near-term operations, but seasonal or project cash flows may require a longer horizon. Avoid ending the model just before a large obligation becomes due.

Discuss your working capital requirements

Creative Global Funding Services connects qualified businesses and project sponsors with potential capital providers for requests of USD $1 million or more. Bring a dated cash timing worksheet and supporting records to explain the funding need. Financing remains subject to independent review, due diligence, acceptable terms and final capital-provider approval. Start a discussion: https://www.creativeglobalfundingservices.com/request-funding.php

This article provides general funding education and hypothetical planning examples. Featured image: original AI-generated CGFS campaign illustration; it does not depict a real client, financed business or completed transaction.