Weekly cash flow: before vs after with Masterestaurant

When the income statement stops telling you enough?

Here is the number that exposes the limit of any income statement: you close August with a 7% net margin and on September 5 there is no money for payroll.

Nothing was miscounted there, two different clocks are simply running at once, because the P&L is built on accrual —revenue booked the moment it is invoiced— while the bank moves on cash, which lands when it lands. Between those two clocks sit the 45 days of credit your meat supplier granted you, the rent deposit, the sales tax you collected in cash three weeks ago and already rolled into purchases, and a payroll that will not wait a single day. According to the U.S. Bureau of Labor Statistics, roughly 45% of independent restaurants never reach their fifth year, and in most of those closures the last quarterly P&L was showing black ink. A weekly cash flow is a thirteen-week board where you record what truly LANDED in the register and the payment gateway, plus what will go out on a committed date, and nothing more.

What the thirteen-week board actually is?

No double entry, no replacement for your accountant, no pretense of being accounting: it is a treasury instrument you close every Monday with the previous seven days already collected.

Thirteen weeks because that is the horizon where something can still be moved —renegotiate a term, delay an equipment purchase, run a high-margin promotion on alcohol, which 46% of operators surveyed by Technomic name among the highest-margin menu categories. The output is one defensible figure per week: 4,200 USD of slack for the 14th, 900 USD for the 21st, negative on the 28th if the corporate event goes uncollected. With that figure you negotiate; without it you improvise and pay late. For an operator with one location, monthly sales under 60,000 USD and the willingness to sit down for forty minutes every Monday, the homemade spreadsheet still wins. Switching cost: zero in licenses, about four hours to build it and ninety minutes of weekly discipline.

Option 1: your own spreadsheet, for the single-location owner

In its favor, you understand every cell because you wrote it, and that understanding beats any pretty dashboard the day you must decide whether to postpone a protein order. Against it: nobody validates the data, copy-pasting the bank statement introduces silent errors, and the file dies the month you fall ill. I recommend it as almost everyone's FIRST board, with one hard condition, which is that inflows be pulled from the bank statement and the gateway settlement, never from the POS sales report, which shows billing rather than available money. Once you pass two locations or monthly sales climb above 150,000 USD, the treasury module of accounting software —QuickBooks, Xero, Siigo, Alegra— buys something a spreadsheet cannot: automatic bank reconciliation and a history that survives turnover in your back office. It runs 30 to 90 USD a month depending on plan, and the real switching cost sits not in the price but in the eight to twelve hours of mapping expense categories and linking accounts.

Option 2: the treasury module inside your accounting software

The catch runs deeper: these modules project forward by extrapolating history, so a restaurant with sharp seasonality —December against February— gets forecasts that look scientific and are not. Use them for an impeccable record of the past; keep writing the thirteen-week projection by hand, over events only you know: the town festival, the double payroll week, the maintenance shutdown. The newest route connects your POS to an engine that learns from your history and projects daily revenue, and when it works it works well: TimeForge reports forecast accuracy above 90% and labor cost reductions of 8 to 12% in AI-driven scheduling, which is the same family of models. Who it fits: chains of three locations or more, with at least eighteen months of clean data and someone on staff who understands what they are looking at. Switching cost is steep —integration, catalog migration, two or three months before the model stops missing badly— and there is a trap almost nobody flags, which is that the model forecasts SALES, not collection.

Option 3: AI cash forecasting wired into the POS

In a business with 35% of revenue through aggregators, where 37% of adults order delivery at least once a week per UpMenu, fourteen days and a 22 to 30% commission stand between forecast sales and available cash. No board invents the money your cost structure is eating, and someone should say it before another owner buys software expecting a miracle. If your prime cost —food cost plus loaded labor— lives above 65% of sales, the weekly flow will only show you the exact DATE the air runs out, which is valuable information and not a solution. Diego F. Parra holds to a non-negotiable order in Masterestaurant audits: first per-plate costing with food cost capped at 32%, then menu engineering on the dishes that actually leave margin, then break-even with payroll and rent kept off the plate, and weekly cash flow last, as the instrument that verifies the first three are truly happening in the bank account.

Sequence matters more than the tool

Reversing that order is buying a thermometer to cure a fever. A two-week cushion of operating expense was prudent through 2019; today it falls short, and the cost data explains why. The producer price index for all food in the United States closed May 2026 some 35% above its February 2020 level according to USDA ERS with BLS data, while the producer index for services rose 3.2% in 2025 against 2.5% for goods, meaning maintenance, insurance and software are pushing too. In Colombia, ACODRÉS reported a 9.8% increase in menu prices since February 2025 to sustain 98,000 jobs. When inputs climb faster than you can reprice the menu without scaring off traffic, treasury slack stops being a conservative owner's luxury and becomes the room to maneuver that lets you buy well instead of buying under pressure. Stay where you are if your current board, however crude it looks, is warning you about the gaps three weeks ahead and you act on that warning.

When NOT to switch?

That is the only thing a cash flow is asked to do, and an ugly sheet filled in every Monday is worth infinitely more than an elegant platform nobody has fed since March.

Migration carries a real cost: eight to twenty hours of administrative work, a two or three month stretch with data living in two places, and the very concrete risk of losing the habit during the handover. Do not switch under pressure from a software vendor in high season either, nor the month you open a second location, because your attention belongs on the operation. The legitimate signal to migrate is different, and it is when your projection error exceeds 15% two months running, or when you are no longer the person filling in the board. The first difference is the UNIT OF TIME. A month is an accounting convention matching no real restaurant cycle: payroll lands biweekly, the protein supplier bills at 30 days, the gateway settles at 3 and delivery at 14.

Four differences that move the result

Measure in weeks and those cycles stop blending into a deceptive average, surfacing instead as concrete peaks you can move. Owners who project thirteen weeks discover their problem was never profitability but calendar, and a calendar is negotiable. Second comes the NATURE OF THE DATA. Your P&L books revenue when the invoice is issued; cash flow books it when the money is available. In a house running 35% of sales through aggregators that distance can stretch two weeks and 22 to 30% of commission that never arrives at all. Modeling real net by channel —rather than gross POS sales— is what prevents the classic mistake of feeling rich on a packed Thursday. Third is CONTROL GRANULARITY. A weekly board forces you to compare theoretical against actual consumption every seven days, and seven days is a window where correction still works: mis-portioned recipes, waste in cold prep, a supplier who raised the kilo without telling you.

Four differences that move the result — in practice

At thirty days the variance has already become a loss, and all that's left is documenting it. The fourth, rarely discussed, is OWNER PSYCHOLOGY. Once you hold a projected headroom figure, you negotiate differently: with the landlord, with the bank, with the partner pushing for a second location. The conversation stops being a request and becomes a proposal with dates. That shift in posture is worth more than the two EBITDA points the exercise usually recovers.