Blog · Finance metrics and formulas · Hospitality
Calculate restaurant working capital and turn the balance into a dated cash review. Work through card settlements, perishable inventory, supplier payments and payroll using a checked weekly example.
Working capital for restaurant teams is current assets minus current liabilities, followed by a dated check of receipts and payments. Calculate the balance first, then test whether cash actually arrives before payroll, suppliers and taxes need to be paid.
A positive balance can coexist with a cash shortage because food in the walk-in and prepaid insurance cannot pay employees today. The general working capital formula explains the balance; the restaurant job is to connect it to card settlement, perishable stock and the weekly payment calendar.
Start with a balance sheet for a single cutoff date. Add the bank reconciliation, unsettled card settlement report, inventory count, supplier aging and payroll calendar. Include scheduled tax, debt and occupancy payments, including amounts not yet appearing as opening liabilities.
The SEC's financial statement guide describes current assets by their expected conversion to cash and current liabilities by their payment horizon. Those classifications support a liquidity overview, but their broad horizon does not reveal a shortage on a particular payday.
Use two views with different purposes:
| View | Rows to include | Question answered |
|---|---|---|
| Balance-sheet working capital | All current assets and current liabilities at the cutoff | What is the net current position? |
| Dated cash schedule | Opening available cash, expected receipts and scheduled payments | Can the restaurant make each payment when due? |
Do not subtract every balance-sheet liability again from the cash schedule. Enter its actual payment once, on its expected payment date. A payroll payment may settle wages already accrued and wages earned after the opening cutoff.
Consider a fictional US restaurant with the following opening balances. Amounts are USD. This example has no current lease liability or other current balances beyond the rows shown; a restaurant that has them must include them.
| Current assets | Amount (USD) | Current liabilities | Amount (USD) |
|---|---|---|---|
| Available cash | 42,000 | Supplier payables | 26,000 |
| Unsettled card receipts | 18,000 | Accrued payroll | 14,000 |
| Food and beverage inventory | 16,000 | Taxes payable | 8,000 |
| Prepaid operating expenses | 4,000 | Current debt principal | 10,000 |
| Total | 80,000 | Total | 58,000 |
Working capital = Current assets - Current liabilities
Restaurant working capital = 80,000 - 58,000 = 22,000 USD
The current ratio is $80,000 / $58,000 = 1.38, rounded to two decimal places. Neither the positive $22,000 balance nor that ratio establishes whether Wednesday's payroll can clear.
The restaurant expects $78,000 of receipts: the opening $18,000 of unsettled card receipts and $60,000 from transactions settling during the week. It schedules the following cash payments. Purchases and wages arising during the week explain why payments can exceed the opening liabilities.
| Payment category | Scheduled payment (USD) | Relationship to opening balance |
|---|---|---|
| Suppliers | 32,000 | 26,000 opening payables plus 6,000 of new purchases paid |
| Payroll | 42,000 | 14,000 opening accrual plus 28,000 of newly earned wages paid |
| Rent and utilities | 12,000 | Payments scheduled during the week |
| Taxes | 8,000 | Settlement of opening taxes payable |
| Debt principal | 10,000 | Settlement of opening current debt principal |
| Total payments | 104,000 | 32,000 + 42,000 + 12,000 + 8,000 + 10,000 |
Management sets an illustrative $20,000 minimum cash reserve. That is an internal assumption, not an industry standard. The timing makes the risk visible:
| Day | Opening cash (USD) | Receipts (USD) | Payments (USD) | Payment detail | Closing cash (USD) | Gap below reserve (USD) |
|---|---|---|---|---|---|---|
| Monday | 42,000 | 8,000 | 9,000 | Suppliers | 41,000 | 0 |
| Tuesday | 41,000 | 8,000 | 12,000 | Rent and utilities | 37,000 | 0 |
| Wednesday | 37,000 | 10,000 | 42,000 | Payroll | 5,000 | 15,000 |
| Thursday | 5,000 | 10,000 | 23,000 | Suppliers | -8,000 | 28,000 |
| Friday | -8,000 | 16,000 | 18,000 | Taxes plus debt principal | -10,000 | 30,000 |
| Weekend combined | -10,000 | 26,000 | 0 | None | 16,000 | 4,000 |
These are projected balances before corrective action. A negative number represents an unresolved funding gap; it does not assume that an overdraft is available. The restaurant needs $30,000 of additional available cash at Friday's trough to maintain the assumed reserve, although its ending reserve shortfall is only $4,000.
The weekly reconciliation is $42,000 + $78,000 - $104,000 = $16,000. Every day's opening balance must equal the preceding day's close. Keep daily rows in the working file; the table combines the weekend only for presentation.
In Excel, put the cash movement date in A, the type in B and the positive amount in C. Use Receipt or Payment consistently. In the daily summary, E holds the date, F opening cash, G receipts, H payments and I closing cash.
=SUMIFS($C$2:$C$1000,$A$2:$A$1000,E2,$B$2:$B$1000,"Receipt")
=SUMIFS($C$2:$C$1000,$A$2:$A$1000,E2,$B$2:$B$1000,"Payment")
=F2+G2-H2
Place the first formula in G2, the second in H2 and the third in I2. Set F3 to =I2 and fill the daily rows down. If J2 holds the chosen reserve, the shortfall is:
=MAX(0,J2-I2)
Microsoft's SUMIFS documentation supports summing by multiple criteria, here date and movement type. Covirage is not affiliated with Microsoft.
Use settlement dates rather than sales dates. Split a card batch into the amounts actually expected to reach the bank, and record withheld fees or other deductions consistently. Otherwise the schedule can count revenue that is not yet spendable.
Finance owns the reconciled opening cash and receipt dates. Operations owns the purchase schedule and staffing assumptions. Payroll confirms the payment file date, while purchasing confirms which supplier terms are agreed rather than merely hoped for.
Reduce avoidable purchases before changing supplier payment dates. Smaller deliveries may reduce cash tied up and spoilage risk, but a stockout can interrupt sales. The IRS inventory discussion emphasizes adequate counts and pricing when establishing closing inventory; stale counts undermine both the balance and the purchasing decision.
Track the cash requirement across seasons rather than applying a single permanent reserve. Working capital days provides a longer-period view, while initial working capital addresses opening a new operation. Neither replaces the dated payroll check.
Upload your balance and dated receipts-and-payments workbook, including card settlements and payroll dates. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.
See Covirage for hospitality teams for the industry context.
Yes. Inventory, prepayments and unsettled card receipts are current assets, but they are not all available cash today. Payroll can fall due before weekend receipts settle. A dated cash schedule identifies that timing gap even when current assets exceed current liabilities.
Buying usable inventory with cash generally exchanges one current asset for another, leaving working capital unchanged at the purchase date. Buying on supplier credit increases inventory and current liabilities together. Later consumption, waste, payment timing and inventory valuation can change the picture.
Set the requirement from your own payment calendar, settlement delays and operating risks rather than a universal percentage of sales. Identify the lowest projected cash balance, add the reserve management requires, and compare the result with available cash and confirmed funding.