๐Ÿ“–

Cash Flow Tracker
User Guide for Restaurant Owners

Track your restaurant's financial health โ€” month by month
Version 2.0 ยท August 2026

What Is This Tool?

The Cash Flow Tracker is a simple dashboard that shows you the financial health of your restaurant at a glance. You enter your monthly numbers, and the tool calculates important metrics like:

๐Ÿ”’ Your data is private

All your numbers are saved in your browser. Nothing is shared with anyone. No internet connection needed after opening the tool.

Getting Started

Opening the Tool

  1. Open the HTML file in any web browser (Chrome, Safari, Edge, or Firefox work best)
  2. The tool works entirely on your computer โ€” no internet connection needed

What You'll Need

Before you start, gather your best estimates for:

๐Ÿ’ก Don't worry if numbers aren't exact

Estimates are perfectly fine โ€” the tool is designed to give you a clear picture, not an audit.

The Dashboard Overview

When you open the tool, you'll see several sections. Here's what each one does:

1. Input Panel (Top Section)

This is where you enter your monthly numbers. As you type, the dashboard updates automatically.

FieldWhat to Enter
Sales ($)Total revenue for the month
Food Cost ($)What you spent on food and ingredients
Labor ($)Employee wages and salaries
Rent ($)Monthly rent payment
Other ($)Insurance, credit card fees, repairs, etc.
Debt Service ($)Monthly loan payments
Owner Dist. ($)Money you took out of the business
Ending Cash ($)Cash balance at month end

2. Cash Section

3. Operations Section

4. Cost Metrics

Shows your key percentages with benchmarks for comparison:

MetricHealthy RangeWhat It Means
Food Cost~30%Food costs as a % of sales
Labor Cost~30%Employee costs as a % of sales
Prime Cost55-60%Food + Labor combined
Rent~20%Rent as a % of sales
Other Expenses~15%Other bills as a % of sales
Healthy range
Watch closely
Needs attention

5. Prime Cost Banner

๐Ÿ”‘ Prime Cost = Food Cost + Labor Cost

If prime cost gets too high (over 60%), the restaurant can struggle to generate cash even if it looks profitable on paper.

6. Liquidity Section

7. Financing Section

8. Charts and Trend Table

Shows your performance over the last 12 months:

How to Use the Tool Month by Month

1
Select Your Month

At the top of the dashboard, click the month picker and select the current month.

2
Enter Your Numbers

Type your monthly numbers in the input fields at the top. The dashboard updates immediately as you type.

3
Review the Dashboard

Look at the key metrics:

  • Is your cash increasing or decreasing?
  • Are your costs within healthy ranges?
  • How many months of cash do you have?
4
Save Your Month's Data

Click ๐Ÿ’พ Save Month at the top right.

A file will download: cashflow_YYYY-MM.json (e.g., cashflow_2026-08.json)

๐Ÿ“ Important: Move this file to a dedicated folder
  1. Open your File Explorer (Windows) or Finder (Mac)
  2. Go to your Downloads folder
  3. Move the file to a folder you create for your restaurant finances
๐Ÿ’ก Suggested folder structure
๐Ÿ“ Restaurant Finances
   โ””โ”€โ”€ ๐Ÿ“ Cash Flow Tracker
       โ”œโ”€โ”€ cashflow_2026-01.json
       โ”œโ”€โ”€ cashflow_2026-02.json
       โ”œโ”€โ”€ cashflow_2026-03.json
       โ””โ”€โ”€ ...
5
Next Month
  1. Change the month picker to the new month
  2. Enter your new numbers
  3. Save again to create a new file

Over time, you'll build a collection of monthly files you can look back on.

Monthly Data Management

Buttons at a Glance

ButtonWhat It Does
๐Ÿ’พ Save MonthDownloads a JSON file with this month's data
๐Ÿ“‚ UploadLoads one or more previously saved months
๐Ÿ“ฅ Export CSVCreates a spreadsheet of all your months
๐Ÿ–จ๏ธ Print / PDFPrints the dashboard or saves as PDF
๐Ÿ”„ Set to Sample DataShows sample numbers (for learning)
๐Ÿ—‘๏ธ Clear All DataSets ALL numbers to ZERO and clears trend history
โš ๏ธ Important: Clear All Data

"Clear All Data" sets everything to zero and removes all trend history โ€” use this only when you want to start completely fresh with your own numbers from scratch. A confirmation dialog will appear to prevent accidental data loss.

Saving a Month

  1. Select the month in the month picker (top right)
  2. Enter all your numbers
  3. Click ๐Ÿ’พ Save Month
  4. A JSON file will download to your computer
  5. Move it to your dedicated folder

Uploading Previous Months

  1. Click ๐Ÿ“‚ Upload
  2. Select one or more JSON files from your folder (hold Ctrl/Cmd to select multiple)
  3. The tool will load all selected months into your trend history
  4. The dashboard will show the data from the last uploaded month
๐Ÿ’ก Tip: Upload multiple files at once

You can upload multiple months at once to quickly build your history. Hold Ctrl (Windows) or Cmd (Mac) while selecting files.

Understanding Your Numbers

What Each Color Means

ColorMeaningWhat to Do
๐ŸŸข GreenHealthyKeep doing what you're doing
๐ŸŸ  OrangeCautionMonitor closely, look for trends
๐Ÿ”ด RedNeeds AttentionTake action to improve

Key Metrics Explained

Runway

How many months your cash will last at current spending. If you have $30,000 in the bank and lose $5,000 per month, you have 6 months of runway.

Prime Cost

Food + Labor. Most restaurants aim for 55-60% of sales. If yours is higher, look at reducing food costs or optimizing staffing.

Food Cost %

If this is above 30%, look at:

Labor %

If this is above 30%, look at:

Saving Your Work

Your numbers are automatically saved in your browser. When you close and reopen the tool, your current numbers will still be there.

โš ๏ธ We strongly recommend using ๐Ÿ’พ Save Month

Create backup files on your computer. This way, if you switch browsers or clear your browser data, you won't lose your history.

Frequently Asked Questions

Q: Do I need to be good at accounting to use this?

A: No. The tool asks for simple numbers you already know: sales, costs, cash. It does all the calculations for you.

Q: What if I don't know an exact number?

A: Give your best estimate. The tool is for planning and insight, not for tax filing.

Q: Where are my numbers stored?

A: In your browser only. They are not sent to any server or shared with anyone.

Q: Can my accountant see my numbers?

A: Yes, you can print the dashboard as a PDF or export a CSV file to share with them.

Q: What's a JSON file and how do I open it?

A: It's a data file that stores your numbers. The tool uses it to load previous months. You don't need to open it โ€” just save it and upload it later when you need it.

Q: What's the difference between "Set to Sample Data" and "Clear All Data"?

A: "Set to Sample Data" fills the dashboard with example numbers so you can see how the tool works. "Clear All Data" sets everything to zero and clears your trend history so you can start fresh with your own numbers.

Q: Why does the trend table show "No data yet"?

A: This appears when you haven't entered any numbers or uploaded any months yet. Start by entering your numbers above, and the table will populate automatically.

Troubleshooting

The numbers aren't updating
I can't find my saved file
I uploaded a file but nothing changed
The charts look strange

Quick Reference Card

ButtonWhat It Does
๐Ÿ’พ Save MonthDownloads a JSON file with this month's data
๐Ÿ“‚ UploadLoads one or more previously saved months
๐Ÿ“ฅ Export CSVCreates a spreadsheet of all your months
๐Ÿ–จ๏ธ Print / PDFPrints the dashboard or saves as PDF
๐Ÿ”„ Set to Sample DataShows sample numbers (for learning)
๐Ÿ—‘๏ธ Clear All DataSets ALL numbers to ZERO and clears trends