Restaurant Finance System for Operators Who Hate Doing Inventory
A daily system designed to remove dread, stress, and avoidance from restaurant finances
I run my restaurant finances without taking inventory or doing per-item costing. Instead, I rely on a three-spreadsheet system to know exactly how my business is doing.
One logs every expense daily, from rent to a carton of milk. I enter invoices, receipts, and purchases manually on purpose. That daily contact gives me a real sense of where money is going, something I never had when I was just scanning invoices and sending bank statement PDFs to another company.
The other two are P&Ls. One combines daily sales and daily expenses so I can see daily profit, with a running monthly P&L at the bottom and a year-to-date P&L on the next tab that updates daily. The other is a final monthly income statement, where operational expenses are categorized in more detail.
For daily and weekly decision-making, all operational expenses are grouped as one category to see overall cost percentage, with month-to-date performance shown at the bottom that updates daily, just like the year-to-date P&L on the next tab. The more detailed operational categories are something I work on at the end of the month for tax and reporting purposes.
For cash flow clarity, I also use a three-bank-account system that I learned through my Chapter 11 restructuring process, along with a Japanese practice called 業務日誌 (gyômu nisshi), a daily operational log that captures what was happening day to day so numbers don’t lose their meaning later.
After 14 years of running a restaurant, through growth, the COVID shutdown, restructuring, and bankruptcy, this is the system I arrived at. It’s the clearest way I know to understand the health of a restaurant without inventory counts, without per-item costing, and without handing everything off to software or a CPA and receiving reports I can’t act on.
Inventory and per-plate costing were never systems I could sustain. I would start, stall, and stop, and still not see the information I was actually looking for. QuickBooks didn’t solve that problem for me. When questions came up weeks later, I often couldn’t remember what expenses were tied to which decisions.
This system keeps me close to the business. I know what we made, what we spent, and why, every day.
If you’re running a food business on your own or in a very small team, especially in the early years, and feeling overwhelmed by finances, this is the system I wish I had. It doesn’t add tools or software. It uses Google Sheets, your existing sales data, and your bank accounts.
Want to learn the system?
I’m putting together a small paid workshop where I walk through this system step by step, using my actual spreadsheets and explaining how I use them day to day.
We’ll cover:
• how I track daily expenses without falling behind
• how I see daily profit and rolling monthly performance
• how the three-bank-account structure works in practice
• how 業務日誌 (gyômu nisshi) adds context that numbers alone miss
• how to adapt this system to your own operation
This is for operators who want clarity and control, not perfect accounting. It’s a finance system you can maintain even when you’re tired, understaffed, or running the business alone.
If you’re interested, subscribe to this Substack as well as sign up for the waitlist for the workshop.