| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | W | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 |  | |||||||||||||||||||||
2 | Cashflow Tool | |||||||||||||||||||||
3 | Note: All fields highlighted in purple need your input in order to paint an accurate picture of your specific cashflow scenario. Be sure to also edit the "restaurant assumptions" tab. | |||||||||||||||||||||
4 | Here's a video on how to use this sheet. | |||||||||||||||||||||
5 | Date | |||||||||||||||||||||
6 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Notes | |
7 | Covers | 450 | 420 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | Number of Guest per week |
8 | Check Average | $45 | $55 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | Average total of bill |
9 | % Change in Revenue | - | 14.07% | 36.36% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | Change from previous week |
10 | Beginnging Cash | 150,000.00 | 150,049.83 | 160,476.37 | 175,138.14 | 189,799.92 | 204,461.70 | 219,123.47 | 233,785.25 | 248,447.02 | 263,108.80 | 277,770.58 | 292,432.35 | 307,094.13 | 321,755.91 | 336,417.68 | 351,079.46 | 365,741.23 | 380,403.01 | 395,064.79 | 409,726.56 | |
11 | Cash In | |||||||||||||||||||||
12 | Discounts | -177.19 | -202.13 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | -275.63 | Service Recovery, Comps, etc. |
13 | Employee Discount | -71.68 | -79.58 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | -102.87 | Staff Meals |
14 | Total Discounts | -$ 248.87 | -$ 281.71 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | -$ 378.49 | |
15 | Restaurant Sales | |||||||||||||||||||||
16 | Beverage Sales | |||||||||||||||||||||
17 | Beer Sales | 1,518.75 | 1,732.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | 2,362.50 | |
18 | Liquor Sales | 3,037.50 | 3,465.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | 4,725.00 | |
19 | NA Beverage Sales | 506.25 | 577.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | 787.50 | |
20 | Wine Sales | 5,062.50 | 5,775.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | 7,875.00 | |
21 | Total Beverage Sales | $ 10,125.00 | $ 11,550.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | $ 15,750.00 | |
22 | Food Sales | 10,125.00 | 11,550.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | 15,750.00 | |
23 | Total Restaurant Sales | $ 20,250.00 | $ 23,100.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | $ 31,500.00 | |
24 | Meals Tax In | $ 1,417.50 | $ 1,617.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | $ 2,205.00 | |
25 | Loan Advances | Money recieved from LOC or loan dispersement | ||||||||||||||||||||
26 | Total Cash In | $ 21,418.63 | $ 24,435.29 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | $ 33,326.51 | |
27 | Cost of Goods Sold | |||||||||||||||||||||
28 | Restaurant Cost of Goods Sold | |||||||||||||||||||||
29 | Beverage Purchases | |||||||||||||||||||||
30 | Beer Purchases | 288.56 | 329.18 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | 448.88 | |
31 | Liquor Purchases | 577.13 | 658.35 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | 897.75 | |
32 | N/A Beverage Purchases | 121.50 | 138.60 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | 189.00 | |
33 | Wine Purchases | 1,164.38 | 1,328.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | 1,811.25 | |
34 | Total Beverage Purchases | $ 2,151.56 | $ 2,454.38 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | $ 3,346.88 | |
35 | Delivery Charges | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
36 | Food Purchases | 2,784.38 | 3,176.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | 4,331.25 | |
37 | Total Restaurant Cost of Goods Sold | $ 4,935.94 | $ 5,630.63 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | |
38 | Total Cost of Goods Sold | $ 4,935.94 | $ 5,630.63 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | $ 7,678.13 | |
39 | Gross Profit | $ 16,482.69 | $ 18,804.67 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | $ 25,648.38 | |
40 | Expenses | |||||||||||||||||||||
41 | Direct Operating Costs | |||||||||||||||||||||
42 | Booking Commissions | 450.00 | 420.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | 700.00 | OpenTable, Rezi, SevenRooms |
43 | Cleaning Supplies | |||||||||||||||||||||
44 | Consumable Supplies | |||||||||||||||||||||
45 | Credit Card Processing | % of sales, typically on first of following month | ||||||||||||||||||||
46 | Decor and Ambiance | |||||||||||||||||||||
47 | Garden | Farm Garden | ||||||||||||||||||||
48 | Equipment Repairs | |||||||||||||||||||||
49 | China, Flatware & Glassware | |||||||||||||||||||||
50 | Laundry, Linen & Uniforms | |||||||||||||||||||||
51 | Menus & Printing | |||||||||||||||||||||
52 | Music & Entertainment | |||||||||||||||||||||
53 | Office Supplies | |||||||||||||||||||||
54 | POS System | |||||||||||||||||||||
55 | Smallwares & Kitchen Tools | |||||||||||||||||||||
56 | Total Direct Operating Costs | $ 450.00 | $ 420.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | |
57 | General Administrative Expenses | |||||||||||||||||||||
58 | Auto Expense | |||||||||||||||||||||
59 | Auto Repair | |||||||||||||||||||||
60 | Auto Insurance | |||||||||||||||||||||
61 | Gasoline | |||||||||||||||||||||
62 | Total Auto Expense | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
63 | Bank Service Charges | |||||||||||||||||||||
64 | Charitable Contributions | |||||||||||||||||||||
65 | Dues & Subscriptions | |||||||||||||||||||||
66 | Finance Costs | |||||||||||||||||||||
67 | Marketing | |||||||||||||||||||||
68 | Advertising Expense | |||||||||||||||||||||
69 | Promotional Expense | |||||||||||||||||||||
70 | Total Marketing | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
71 | ME&T | |||||||||||||||||||||
72 | Entertainment | |||||||||||||||||||||
73 | Meals | |||||||||||||||||||||
74 | Travel | |||||||||||||||||||||
75 | Comparitive Dining | |||||||||||||||||||||
76 | Total ME&T | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
77 | Total General Administrative Expenses | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
78 | Occupancy Costs | |||||||||||||||||||||
79 | Real Estate Taxes | 750.00 | ||||||||||||||||||||
80 | Rent Expense | 5,000.00 | ||||||||||||||||||||
81 | Repairs & Maintenance | 191.31 | ||||||||||||||||||||
82 | Cleaning | 46.75 | ||||||||||||||||||||
83 | Pest Control | 82.00 | ||||||||||||||||||||
84 | Refuse Removal | 110.00 | ||||||||||||||||||||
85 | Total Repairs & Maintenance | $ 430.06 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
86 | Utilities | |||||||||||||||||||||
87 | Electric | 1,295.12 | ||||||||||||||||||||
88 | Heating Oil | 396.69 | ||||||||||||||||||||
89 | Natural Gas | 707.67 | ||||||||||||||||||||
90 | Telecommunications | 235.22 | ||||||||||||||||||||
91 | Total Utilities | $ 2,634.70 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
92 | Total Occupancy Costs | $ 8,814.76 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | $ 0.00 | |
93 | Payroll Expenses | |||||||||||||||||||||
94 | BOH Wages | 3,240.00 | 3,696.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | 5,040.00 | |
95 | BOH Overtime | |||||||||||||||||||||
96 | Total BOH Wages | $ 3,240.00 | $ 3,696.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | $ 5,040.00 | |
97 | FOH Wages | |||||||||||||||||||||
98 | Bartender | 303.75 | 346.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | |
99 | Busser / Runner | 303.75 | 346.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | 472.50 | |
100 | FOH Minimum Wage Adjustment | |||||||||||||||||||||