Restaurant ownership (dummies guide)

jw01

New member
Jul 3, 2005
317
0
0
Hey all

My uncle and aunt run a ma & pa restaurant that does relatively well, however they are old school and asked me for help to implement inventory controls and accounting systems to do daily cash flow statements or weekly rather, and other reports.

I do not have much experience in this field and they are great people so i want to help them out.

does anyone have any suggestions on how to implement or programs or practices to implement for spreadsheets and recording daily expenditure and sales etc?

any help would be truly appreciated.

cheers
 
check out amazon.com for books... i'm pretty sure i've seen books on how to run a successful restaurant there, anything from food to keeping track of finances/payroll etc.. might even have softwares for that
 
The easiest would be to buy a POS that integrates with your accounting system. Even if it doesn't integrate, you can generate daily reports from even a basic POS.

The bigger question is, if there are no other owners, you trust each other and are all involved in the business, why do you want to create a paper trail for a cash business?
 
The easiest would be to buy a POS that integrates with your accounting system. Even if it doesn't integrate, you can generate daily reports from even a basic POS.

The bigger question is, if there are no other owners, you trust each other and are all involved in the business, why do you want to create a paper trail for a cash business?

In case of an audit?
 
In case of an audit?

I'm not saying not to keep accounting records. I'm asking why the OP wants front and back of store systems that would presumably record everything. No need to gift-wrap an audit for the CRA......
 
I'm assuming it would be easier to see profit / loss if everything is digital? nothing beats an accurate accounting and see if you're making more than you thought or losing.
 
buy a POS system like Smart vendor.
 
I have a friend who is the franchisee for one of Ontario's leading diner businesses. In spite of placing CCTV everywhere throughout the restaurant, and particularly at the till, he was still having problems with his profit and loss. After monitoring the business for a couple of weeks I determined that his problem was that his staff would give out freebies to customers - one specific example was juice refills. Another issue was portion control, again where beverages were concerned. The staff would enter the original drink (say orange juice) as a small but then give the customer a medium or large. This is great for customer service, and many of the servers get good tips from their regulars. Unfortunately for my friend, beverages are one of his biggest profit margins, since it costs him about 30 cents for a small glass of juice and he charges $2.59 for it.

POS and computerized entry systems are great, and can provide you with up-to-date reports and in some cases inventory control. But if data isn't entered (like the beverages) into the customers check, than you take a loss for each entry not recorded.

This was not so much of an issue for my friend with respect to the kitchen, as the kitchen works from order tickets generated by the order system. However, if a customer returns food for any reason it was not noted anywhere. I recommended that in cases where food was returned, it should be re-entered into the order system with a no charge code to ensure the waste is recorded. Systems like this allow you to focus in on areas where staff may need more training, etc.

The restaurant business is a hard go. The biggest problem experienced is generally portion control. Many restaurants go out of business because when you actually break down a plate of food, and identify all costs involved both fixed and variable, it is often determined that the plate of food is costing more than what is being charged for it.

Good luck to your friends.
 
This is the best book on the subject.

Principles of Food, Beverage and Labour Cost Controls by Dittmer/Keefe.
It's available at George Brown book store, 200 King St. East.
Do yourself a favour, take the 3 month course at G.B. and then find an accountant specializing in this type of business
to help you implement the system.
I've seen busy places go tits up because they don't take cost controls seriously.
 
hey all

thanks for the input and advise.

they do have a POS system, however they dont have any P&L or financial statements. I think it would benefit to see how the business is running.

i realize the potential of the POS, so i will need to figure that out for them, however i think a graet tool is the P&L, more specifically the cash flow (COGS). that is something they want to consider. i have my background in accounting, however not sure how to introduce such a system in restaurant. i will go to chapters to check some books out, but thought there might be some tool online that can help as well.

i tried simply accounting back in a univ project, long back. i saw in walmart recently it now called SAGE or something - any recommendation? will that help?
thxs
 
I have a friend who is the franchisee for one of Ontario's leading diner businesses. In spite of placing CCTV everywhere throughout the restaurant, and particularly at the till, he was still having problems with his profit and loss. After monitoring the business for a couple of weeks I determined that his problem was that his staff would give out freebies to customers - one specific example was juice refills. Another issue was portion control, again where beverages were concerned. The staff would enter the original drink (say orange juice) as a small but then give the customer a medium or large. This is great for customer service, and many of the servers get good tips from their regulars. Unfortunately for my friend, beverages are one of his biggest profit margins, since it costs him about 30 cents for a small glass of juice and he charges $2.59 for it.

POS and computerized entry systems are great, and can provide you with up-to-date reports and in some cases inventory control. But if data isn't entered (like the beverages) into the customers check, than you take a loss for each entry not recorded.

This was not so much of an issue for my friend with respect to the kitchen, as the kitchen works from order tickets generated by the order system. However, if a customer returns food for any reason it was not noted anywhere. I recommended that in cases where food was returned, it should be re-entered into the order system with a no charge code to ensure the waste is recorded. Systems like this allow you to focus in on areas where staff may need more training, etc.

The restaurant business is a hard go. The biggest problem experienced is generally portion control. Many restaurants go out of business because when you actually break down a plate of food, and identify all costs involved both fixed and variable, it is often determined that the plate of food is costing more than what is being charged for it.

Good luck to your friends.

Excellent advice!
 
Another good piece of advice would be to tell them to spend a couple days talking with any people they personally know who own or operate restaurants. From experience I've found that the food business is a pretty tight community that is very willing to help each other out when asked.

For example, if they know someone (an owner,a general manager) at a restaurant that already has a POS system, inventory and ordering system and other such processes, go ask if they (or you) can observe a few shifts or watch how they open/close the restaurant.

Stuff like that is not top-secret, and there are 100 different systems out there that all do basically the same things. Learning the "how" and the "why" is what you want to get out of it, as you can them translate that into your aunt/uncle's unique situation.

It's not rocket science, but it does take a little time and patience to learn.
 
I don't think you understood someone's previous remark:

This is a CASH business and so a fully detailed POS system is just gonna get in the way.

I worked for a bar in Toronto that had a cash register that had no date, no time, just the totals. Every day the owner would come and total out the machine at 10 PM. Do you think this was for accounting purposes? I think not.

Cash sales are the best way to run a business. particularly for something like a restaurant where not every inventory purchase need be recorded with an invoice.

'Nuff said
 
Another good piece of advice would be to tell them to spend a couple days talking with any people they personally know who own or operate restaurants. From experience I've found that the food business is a pretty tight community that is very willing to help each other out when asked.

For example, if they know someone (an owner,a general manager) at a restaurant that already has a POS system, inventory and ordering system and other such processes, go ask if they (or you) can observe a few shifts or watch how they open/close the restaurant.

Stuff like that is not top-secret, and there are 100 different systems out there that all do basically the same things. Learning the "how" and the "why" is what you want to get out of it, as you can them translate that into your aunt/uncle's unique situation.

It's not rocket science, but it does take a little time and patience to learn.
There are plenty of restauranteurs who would be happy to help you out - and then send you an invoice for their intellectual property.

Ask your Aunt & Uncle what they would like to see first. Start there and build up.

For bar inventory, at least once a day measure every bottle and keg. You can go by "fill level", or more commonly by weight (you'll learn the weight of the empty bottle). You can buy a scale specifically for the purpose. Or, to start simple just have a manager "estimate" how much is left in each bottle (1/16, 1/8, 7/8, etc). Track what's added (new bottles brought to the bar), what's left, and what's sold (via the POS).

Have staff mark down "exceptions" (eg made wrong drink, customer sent it back, etc).

Your accounting background can figure out breakage from that.

Similarly, in the kitchen, take a weekly count of the key ingredients (I think you can skip the inventory of things like salt). The POS will tell you how many units were sold, and you can figure out the difference. Have staff mark down when there was a loss (e.g. food not up to quality so it didn't leave the kitchen but instead was re-made).

Make sure that petty cash expenses are tracked. Make sure major expenses are similarly controlled.

You have the sales, you have the expenses. You can do the financials from there.
 
EXCEL is a weapon of mass destruction. I would suggest that before you jump into any software you take a good old pencil and some paper and really do the work necessary to understand the metrics of the business . Focus first on the costs, variable, fixed, overheads ... get as detailed as you can and make sure that you are spending money wisely. Then focus on the revenues. Where are the real margins? Are you capturing them efficiently? selling more of high margin product?

Once you have this understood and you have communicated this knowledge to EVERYONE who can impact costs/ revenues and ultimately profits , look at a system to monitor performance and provide accurate reports.
 
I don't think you understood someone's previous remark:

This is a CASH business and so a fully detailed POS system is just gonna get in the way.

I worked for a bar in Toronto that had a cash register that had no date, no time, just the totals. Every day the owner would come and total out the machine at 10 PM. Do you think this was for accounting purposes? I think not.

Cash sales are the best way to run a business. particularly for something like a restaurant where not every inventory purchase need be recorded with an invoice.

'Nuff said

Not sure how long ago you worked in that bar, but such practices today would likely run afoul of AGCO. Not to mention a CRA audit. Records are not just a benefit to CRA, they protect the business owner as well. CRA isn't just going to pack up and go home if there aren't any records, they'll fill in the gaps with their own assumptions on how the business should be going, and those assumptions are never beneficial to the business owner.
 
Having accurate financials is necessary when you want to sell the business. Maybe that's why they want to install an accounting system.
 
I've personally spent many years in the restaurant industry and recently opened my own place.

First off - if you're running the business correctly, you should be making money and won't need to worry about going the 'cash' route. I worked at one place that got audited. The auditor sat in the restaurant for two weeks to see how much business came in. It did not turn out well for the owners.

Secondly - Nothing beats experience in this business... I can't count the number of times I've heard people say they want to open a restaurant because they like the idea, having no experience. I put them in their place. It's hard work, with different challenges every single day. The only way to avoid problems, and solve others is through experience. if neither yourself, nor your aunt and uncle have the experience, get someone that does to come in and help you out for a while. There are restaurant management companies that will help you out.

Third - You have to be there all the time. There is NO WAY to succeed without being present the majority of the time, the only exception is if you have a strong experienced GM that cares just as much as you. Your employees/servers will not care about cost control as a previous poster stated.

Labour - Don't over staff, for obvious reasons. Don't understaff to save money at the expense of service. This may seem common sense, but figuring out that balance is difficult for most people.

More directly to your question. There are quite a number of computer systems that could work for you restaurant. What will suit best will depend on budget, complexity, and size of the restaurant. Though most systems will be able to print daily reports and export that info into some format usable by your accounting software.

As far as inventory control, there are quite a number of things to take into consideration other than counting what coming in and going out. Controlling wastage, mistakes, portion control. Knowing how to sell items as well as proper menu design are essential for this.


I could go on and on, but I won't.