F&B OPERATIONS CALCULATOR
13-Week Restaurant Cash Flow Planner
Plan weekly cash receipts and payments. Spot a possible shortfall before supplier bills, wages and other commitments fall due.
A free tool from QSolve — running on the Windows and Android devices already in use.
This browser simulation uses fixed formulas and rules. No AI request is made to produce these results.
Synthetic sample figures. Nothing entered here is uploaded or saved.
Enter a scenario
Example calculation
Figures and meaning
- Closing cash, week 13
- RM 14,500.00
- Lowest cash, including opening
- RM 10,000.00
- Gap against minimum reserve
- RM 0.00
- First negative balance
- None in this scenario
View comparison table
| Week | Opening | Receipts | Payments | Closing |
|---|---|---|---|---|
| 1 | RM 10,000.00 | RM 5,000.00 | RM 5,000.00 | RM 10,000.00 |
| 2 | RM 10,000.00 | RM 5,000.00 | RM 2,500.00 | RM 12,500.00 |
| 3 | RM 12,500.00 | RM 5,000.00 | RM 2,500.00 | RM 15,000.00 |
| 4 | RM 15,000.00 | RM 5,000.00 | RM 8,500.00 | RM 11,500.00 |
| 5 | RM 11,500.00 | RM 5,000.00 | RM 5,000.00 | RM 11,500.00 |
| 6 | RM 11,500.00 | RM 5,000.00 | RM 2,500.00 | RM 14,000.00 |
| 7 | RM 14,000.00 | RM 5,000.00 | RM 2,500.00 | RM 16,500.00 |
| 8 | RM 16,500.00 | RM 5,000.00 | RM 8,500.00 | RM 13,000.00 |
| 9 | RM 13,000.00 | RM 5,000.00 | RM 5,000.00 | RM 13,000.00 |
| 10 | RM 13,000.00 | RM 5,000.00 | RM 2,500.00 | RM 15,500.00 |
| 11 | RM 15,500.00 | RM 5,000.00 | RM 2,500.00 | RM 18,000.00 |
| 12 | RM 18,000.00 | RM 5,000.00 | RM 8,500.00 | RM 14,500.00 |
| 13 | RM 14,500.00 | RM 5,000.00 | RM 5,000.00 | RM 14,500.00 |
What to check next
Check the earliest shortfall and payment dates. Update estimates weekly; a positive final balance can still hide an earlier cash shortage.
How this is calculated
Enter money in the week it is collected or paid, including delivery payout delays. Put financing inflows in receipts and loan/tax payments in their column. Include only cash movements and avoid duplicate entries. No automatic borrowing, overdraft interest or tax rates are assumed. This is a weekly forecast, not a daily cash guarantee.
Closing cash = opening cash + receipts − payments. Next week starts with the previous closing balance. Cash shortfall = max(0, chosen reserve − lowest projected balance), including opening cash.
Read the result
Check the earliest shortfall and payment dates. Update estimates weekly; a positive final balance can still hide an earlier cash shortage.
Example figures. No automatic business verdict.
How each tool works & FAQ
Should I enter sales or cash collected?
Enter actual or expected cash collected. Credit sales belong in the week payment is expected.
Is the cash gap a loan recommendation?
No. It is a scenario gap against your chosen reserve, before deciding how to change operations or funding.