Blog · Territory, capacity and quota planning
Build a startup cash review from bank movements, customer collections and committed spending. Compare the operating plan with actual cash dates, then test late receipts and financing separately.
Cash management for startups matches customer collections and financing timing with committed payments, then checks the result against the operating plan. Reconcile cash first, identify the lowest dated balance and require a clear owner for each uncertain receipt. That gives management a basis for hiring, purchasing and funding decisions.
A startup can meet its revenue plan and still miss a payment because customers pay later than expected. It can also report a comfortable closing balance while depending on funding that has not closed. The review should make those dependencies visible before the company signs another commitment.
The SBA's business finance guidance identifies available cash, bank reconciliation, receivables, payables and payroll as responsibilities that need an owner. Assign finance responsibility for the complete schedule, sales or collections responsibility for customer dates, and budget holders responsibility for upcoming commitments.
Use burn rate for the established gross burn, net burn and runway formulas. Those summary measures help describe cash consumption; this review explains which dated movements change the balance and which decisions depend on them.
Begin with the last reconciled bank balance and a cash transaction export through the same cutoff. Add open customer invoices, confirmed collection dates, unpaid supplier invoices, payroll and tax dates, signed orders, lease payments and other commitments. Include material annual renewals rather than spreading them evenly across months.
The IRS recordkeeping guidance connects transaction records with supporting documents and financial statements. Keep the invoice, contract or payroll reference behind each scheduled amount so a reviewer can test the assumption.
Each movement needs an ID, cash date, category, counterparty, amount, status, source and owner. Split status into paid, committed and discretionary. Keep financing separate from customer receipts and distinguish completed funding from a discussion, term sheet or conditional agreement.
Match overlapping records. A purchase order, supplier invoice and bank payment may describe one obligation at different stages. Replace the expected movement with the actual payment when it clears; retaining both doubles cash use.
Closing cash = Opening cash + Customer and other operating receipts + Financing receipts - Cash payments
Next week's opening cash = This week's closing cash
An illustrative US software company starts with $620,000 of reconciled cash. Its base case excludes a possible financing receipt because closing remains conditional. The following four-week schedule uses whole dollars with no rounding.
| Week ending | Opening cash (USD) | Operating receipts (USD) | Financing receipts (USD) | Payments (USD) | Closing cash (USD) |
|---|---|---|---|---|---|
| October 30, 2026 | 620,000 | 90,000 | 0 | 170,000 | 540,000 |
| November 6, 2026 | 540,000 | 130,000 | 0 | 190,000 | 480,000 |
| November 13, 2026 | 480,000 | 110,000 | 0 | 210,000 | 380,000 |
| November 20, 2026 | 380,000 | 140,000 | 0 | 180,000 | 340,000 |
| Period movements and final cash | 620,000 | 470,000 | 0 | 750,000 | 340,000 |
With columns A:F and the first week in row 2, calculate F2 and the next opening balance as follows:
=B2+C2+D2-E2
=F2
The second formula goes in B3. Fill the formulas down through the remaining weeks. The summary takes the first opening balance and the final closing balance; it sums only the movement columns. Adding weekly opening balances produces a meaningless total.
For a transaction sheet named Cash, place date in A, category in B, receipts in C and payments in D. If H2:I2 contain a week's start and end dates, aggregate operating receipts using:
=SUMIFS(Cash!C:C,Cash!A:A,">="&H2,Cash!A:A,"<"&I2+1,Cash!B:B,"Operating")
Payments use the same date boundaries with Cash!D:D as the sum range. Financing uses its own category. Review dates inside any low-balance week at daily resolution, since a Friday collection cannot fund a Thursday payroll.
The full-period identity is $620,000 + $470,000 + $0 - $750,000 = $340,000. Weekly balances roll forward to that same ending amount. The cash decrease is $280,000, equal to payments of $750,000 less operating receipts of $470,000.
For completed weeks, match receipt and payment totals with bank activity and reconcile the closing amount to the ledger. For future weeks, trace commitments to their source and check that each appears once. Do not compare a reconciled actual opening balance with an old plan opening balance without displaying that difference.
Then compare actual and planned movements by collection, payroll, supplier, capital spending and financing category. Explain whether a difference changes the total amount, the payment date or both. Retain the original plan as a comparison rather than rewriting it whenever an assumption moves.
Suppose $80,000 of the November 6 receipts arrives on November 20 instead. All other receipts and payments remain unchanged:
| Week ending | Base closing cash (USD) | Closing cash with delayed collection (USD) | Difference (USD) |
|---|---|---|---|
| October 30, 2026 | 540,000 | 540,000 | 0 |
| November 6, 2026 | 480,000 | 400,000 | -80,000 |
| November 13, 2026 | 380,000 | 300,000 | -80,000 |
| November 20, 2026 | 340,000 | 340,000 | 0 |
Ending cash is unchanged, but the lowest weekly balance falls to $300,000. That is why receipt timing matters even when the period total is right. The cash management and receivables guide covers the collection work behind these assumptions.
Separately, a conditional $250,000 financing deposit on November 13 would lift the base case's final cash to $590,000: $340,000 + $250,000. Keep that scenario labeled and retain the $340,000 case until funding is completed. For the broader forecast structure, use cash flow management for startups; bring the decision and its dependencies into the regular management reporting package.
Bring a sample of your own cash movements, collection schedule, commitments and operating plan in a file or Google Sheet. Covirage maps the columns, its tools compute and check balances and plan differences, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See FP&A reporting for the supporting reporting approach.
Use a weekly review for upcoming receipts, commitments and payment dates, with more frequent checks near large payments or uncertain collections. Monthly reporting still explains performance, but a month-end balance can conceal a lower balance before payroll or a financing deposit.
Unclosed financing belongs in a separate scenario with its assumed deposit date and remaining conditions. It is not opening cash. Maintain a case that excludes it so management can see which spending commitments depend on completion and what happens if closing moves.
Burn rate summarizes cash consumption over a period. Cash management also asks when collections arrive, which payments are already committed and whether money is available on each due date. A stable burn rate can coexist with an approaching payment gap caused by timing.
Use reconciled bank balances, customer invoice and collection records, open payables, payroll and tax calendars, signed purchase commitments and financing schedules. Add the operating plan for comparison. Identify each source and cutoff so overlapping records can be matched rather than counted twice.