12 MONTH BUDGET TEMPLATE BAR AND RESTAURANT SPECIFIC
Budgeting shouldn't be approached as something to do when you have time, but instead as a priority and part of your overall business financial management plan. Breaking your budget into monthly increments will ease the process, making it less overwhelming. Prepare some general goals for your financial budget for the year, then see how you can achieve that goal--one month at a time--through this 12 month budget template. Budgeting doesn't have to be an overwhelming task. We'll often use the excuse that we don't know "how" to do a budget because our income and/or expenses are too hard to predict. Don't you want to have an idea of where you're going? The challenge for the new year is for you to be more proactive with your business financial picture. Here are some instructions for using this template:
There are two ways for you to use this template:
Option 1 – Enter in your projected sales for the first month and then enter in your projected costs as a percentage of your revenue. i.e: Food Cost 30%, Utilities 12% etc. The template will then automatically calculate the amounts in fiscal terms for each percentage.
Option 2 – Enter in your projected sales for the first month and then enter your projected costs in money amounts i.e: Food Cost 24,060, Utilities 12, 954. In this case the template will not automatically calculate the corresponding percentages.
To assist you, you will find a small red triangle in the corner of the cells.  Hover over this triangle to get instructions on how to fill in the cells. You will also see an example has already been done for you in the month of January which you can edit as needed.

Not yet a Member? Register Here. It only takes a minute and you'll have instant access to more than 2000 business tools to drive profits, reduce costs and manage a successful hospitality business.
Other articles you're sure to like... Harassment Investigation GuideDo you know what your obligations are as an employer, should your staff advise that they feel they are being harassed?
Pub owners have a responsibility to provide and maintain a safe working environment. The Cellar of any bar is a high risk location. Best Practice Hospitality
With the hospitality industry larger and more competitive than ever, what can you do to set your establishment apart from the others? Maximising your Pub Site Potential
John Ryan from CB Richard Ellis, Hotels and Licensed Trade Division, argues viewing the pub as a piece of property and not just a business.
|