ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Restaurant Cash Flow Templatehttps://www.smartsheet.com/try-it?trp=12338&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Restaurant+Cash+Flow-google-sheet-12338&lpa=Restaurant+Cash+Flow+google-sheet+12338
3
Restaurant Name Manager Completed By Date Completed
4
NameNameNameMM/DD/YY
5
6
Current PeriodPrevious PeriodINCREASE (or DECREASE)
7
BeginEndBeginEnd
8
MM/DD/YYMM/DD/YYMM/DD/YYMM/DD/YY
9
10
Beginning Balance | Cash on Hand $ - $ - $ -
11
12
( + ) Cash Inflows - Restaurant Sales Revenue
13
Revenue SourceCurrent PeriodPrevious PeriodIncrease (or Decrease)
auto-populates
14
Dine-in Sales $ - $ - $ -
15
Takeout and Delivery Sales $ - $ - $ -
16
Catering Revenue $ - $ - $ -
17
Gift Card Sales $ - $ - $ -
18
Alcohol Sales $ - $ - $ -
19
Other Restaurant Revenue $ - $ - $ -
20
Total Cash Inflows $ - $ - $ -
21
22
( – ) Cash Outflows
23
( – ) Cost of Goods Solds (COGS)
24
Expense SourceCurrent PeriodPrevious PeriodIncrease (or Decrease)
auto-populates
25
Food Costs (ingredients and supplies) $ - $ - $ -
26
Beverage Costs $ - $ - $ -
27
Liquor, Beer and Wine Costs $ - $ - $ -
28
Packaging and Takeout Supplies $ - $ - $ -
29
Kitchen Supplies $ - $ - $ -
30
Total COGS $ - $ - $ -
31
32
( – ) Operating Expenses
33
Expense SourceCurrent PeriodPrevious PeriodIncrease (or Decrease)
auto-populates
34
Rent/Lease $ - $ - $ -
35
Utilities $ - $ - $ -
36
Payroll - Management $ - $ - $ -
37
Payroll - Hourly Staff $ - $ - $ -
38
Payroll Taxes and Benefits $ - $ - $ -
39
Insurance (Property, Liability, Workers' Comp) $ - $ - $ -
40
Marketing and Advertising $ - $ - $ -
41
POS System Fees $ - $ - $ -
42
Delivery App Commissions $ - $ - $ -
43
Cleaning and Sanitation Supplies $ - $ - $ -
44
Restaurant Equipment Maintenance $ - $ - $ -
45
Licensing and Permits $ - $ - $ -
46
Miscellaneous Expenses $ - $ - $ -
47
TOTAL OPERATING EXPENSES $ - $ - $ -
48
49
( – ) Additional Expenses
50
Loan Repayments $ - $ - $ -
51
Interest Expenses $ - $ - $ -
52
Taxes Paid $ - $ - $ -
53
Owner Draws / Distributions $ - $ - $ -
54
TOTAL ADDITIONAL EXPENSES $ - $ - $ -
55
Total Cash Payments
56
Total Expenditures (COGS + Operating + Additional Expenses) $ - $ - $ -
57
Net Cash Change
58
Cash Inflows - Cash Outflows $ - $ - $ -
59
Month-End Cash Position
60
Cash-on-Hand + Cash Inflows - Cash Outflows $ - $ - $ -
61
62
CLICK HERE TO CREATE IN SMARTSHEET
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100