toolbox
Home / Business & Operations / Retail Cash Flow Calculator

Retail Cash Flow Calculator

The Retail Cash Flow Calculator estimates net cash movement and ending cash from retail cash receipts, operating payments, inventory purchases, capital spending, financing, and a starting balance. It provides a direct cash view that is separate from accounting profit.

The result can help store owners plan purchasing, identify a potential cash shortfall, or compare operating and financing scenarios. Timing matters: enter only amounts expected to be received or paid during the selected period.

Enter your assumptions

USD
USD
USD
USD
USD
USD
Result
—
Estimated ending cash
Net operating cash before capex—
Net change in cash—
Total cash outflows—

1. Enter beginning cash
Use the available cash balance at the start of the period.

2. Add expected cash receipts
Include customer collections and other operating cash actually expected during the period.

3. Enter operating payments
Add payroll, rent, utilities, marketing, and other operating cash outflows.

4. Add inventory and capital payments
Enter cash paid for stock and long-term assets separately.

5. Enter net financing
Use a positive amount for net borrowing or owner contributions and a negative amount for repayments or distributions.

6. Review ending cash
Compare the result with the minimum cash level needed to operate safely.

Formula:

Net operating cash before capex = Cash receipts − Operating payments − Inventory purchases paid Net change in cash = Net operating cash before capex − Capital spending + Net financing inflow Ending cash = Beginning cash + Net change in cash

The calculation follows cash timing, not revenue recognition or expense matching.

What the result means

The main result is the projected cash balance at the end of the selected period.

Accounts receivable, accounts payable, and unpaid commitments affect the result only when their cash timing is included in the inputs.

Given

$25,000 beginning cash, $85,000 receipts, $48,000 operating payments, $22,000 inventory purchases, $5,000 capital spending, and $3,000 financing inflow.

Calculation

Net operating cash = $85,000 − $48,000 − $22,000 = $15,000 Net change = $15,000 − $5,000 + $3,000 = $13,000 Ending cash = $25,000 + $13,000 = $38,000

Result

Estimated ending cash is $38,000.

Why can profit and cash flow differ?

Sales may be collected later, inventory can be purchased before it is sold, and capital spending may use cash without being expensed immediately.

Should credit sales be included in cash receipts?

Include only the amount expected to be collected during the period. Uncollected credit sales belong in a receivables forecast.

How do I enter loan repayments?

Enter net financing as a negative amount for principal repayments, owner distributions, or other financing outflows not included elsewhere.

What does a negative ending cash balance mean?

It indicates a projected funding gap under the entered timing assumptions. Review payment timing, financing availability, and operating assumptions.

Should sales tax payments be included?

Include tax remittances in operating payments when they are expected to be paid during the period, and avoid treating collected tax as revenue.