QuickBooks Accounting for Groupon

I’m almost finished with Groupon articles!  I’ve got two more, then, I think we’re done.  I’ve been writing these articles, because there is a lot of confusion surrounding the accounting for Groupon certificates and how to enter them in QuickBooks.  The resources for learning about these areas are poor (and often contradictory), but that’s nothing compared with the confusing, and often downright incorrect, information that has been written about the tax implications of using Groupon!  I hope these articles will help accountants, bookkeepers and restaurant owners set up their books and account for these transactions properly.
Today’s article explains how to account for a restaurant’s Groupon transactions in QuickBooks.  Previous articles have covered the POS system set up for Groupon transactions, accounting for Groupon transactions (in general), and the very important tax implications of using Groupon in a restaurant.
Continue reading “QuickBooks Accounting for Groupon”

Groupon POS Implications

This is the second article in a series about Groupon coupons for restaurants.  The first article covered accounting for Groupon transactions.  This piece covers how to set up your Point of Sale (POS) system to record POS systemredemptions of coupons.  Failing to do so properly could result in the restaurant being on the hook for a lot of sales tax, penalties and interest!
In the first article, we learned that HST applies to the “promotional value” of the Groupon coupon.  In our example, the coupon was worth $100 of meals, and the customer purchased it for $50, which was paid directly to Groupon.  The promotional value of the coupon is the $50, even though the restaurant does not receive this amount from Groupon.  So, when the customer orders $100 worth of meals and drinks at a restaurant, she will have to pay tax on $50, but she will receive a credit for $100 (face value of the coupon).
Restaurants that use Groupon (or other similar programs) may need to update their POS systems to properly account for these transactions.  Many POS systems can be easily modified by the user to make these changes, but some require programming by the developer (which can take time).  Here are the changes you will need.
Continue reading “Groupon POS Implications”

Accounting for Groupon Coupons

While I’m not a fan of Groupon coupons, at least for restaurants, I felt compelled to write a few articles about it.  Today’s piece covers accounting for Groupon coupons, because I’ve seen some really weird accounting recommendations and far-from-best-practices.  As far as I know, none of the more unusual accounting has been suggested by real accountants!
Future articles will cover how to generate the proper entries in QuickBooks, how to set up your Point of Sale (POS) system to properly account for redemptions of Groupon certificates, and why you may be in for a huge shock when the tax man comes a knocking.
For what it’s worth, if you really, really think you need to use Groupon (or Living Social) coupons at your restaurant, at least get the accounting right.  There are four types of entries that need to be made in your accounting system, which are:
Continue reading “Accounting for Groupon Coupons”

Restaurant Fraud & Theft – Part IV

The first three posts in this series covered fraud and theft of products entering the establishment, food theft, and alcohol theft.  Now, we’re going to look at outright theft of sales receipts.  While it’s unlikely that your servers are grabbing handfuls of dollars on their way out the door, today’s post looks at several more sophisticated methods of achieving the same result.
Continue reading “Restaurant Fraud & Theft – Part IV”

Restaurant Fraud & Theft – Part III

“What I like to drink most is wine that belongs to others.”
Diogenes.

Today’s post looks at alcohol related thefts once the alcohol has made its way to the coolers and shelves in the bar.  These types of alcohol theft are broad categories.  Within each there are many scams, too many to list.  As I have discussed many times on this blog and my tax blog, alcohol theft has dire tax consequences for a restaurant.  In Canada, the total cost of the theft can easily be twice the cost of the stolen alcohol.  That’s why it is so important to minimize theft in your operation.
Continue reading “Restaurant Fraud & Theft – Part III”

Restaurant Fraud & Theft – Part II

Part I in this series focused on fraud and theft up to the point your inventory becomes available for sale.  As we found out, lots can go wrong during the purchasing, receiving and inventory safeguarding processes.  These frauds and thefts involved uncooked food or unpoured alcohol.  Now, let’s uncork a bottle and turn up the heat.
Today, I want to discuss some of the major thefts that happen during “normal” operations.  These thefts involve cooked food or poured alcohol.  These are the ones that take place “right under your nose”.  Today’s post examines food theft.
Continue reading “Restaurant Fraud & Theft – Part II”

Restaurant Fraud & Theft – Part I

IT NEVER HAD A CHANCE TO BE SOLD
Today’s post covers fraud and theft of stock items before they are sold or used in your establishment.  These types of fraud relate to purchasing, receiving and inventory stock keeping.  Subsequent posts will cover additional types of fraud and theft.  These posts discuss one of the most important issues facing restaurateurs.
Any theft of product for sale can result in significant sales and income tax liabilities.  So significant, in fact, that it could put your restaurant or bar out of business.  My restaurant tax blog, Canadian Restaurant Tax Advisor, has a wealth of information about restaurant tax audits and their dire implications for you.
Continue reading “Restaurant Fraud & Theft – Part I”

Restaurant Theft Findings

Most restaurateurs know that theft is a problem in the hospitality industry, but very few know how much is going on in their own establishments. According to the U.S. National Restaurant Association, approximately 4% of all revenue is lost to in-house theft.  The latest figures from Statistics Canada, NPD Group and the CRFA, indicate that the average profit margin for Canadian restaurants was only 4.4% of operating revenue!  Based on these figures, approximately one-half of your profit is lost to employee theft.
As if that isn’t bad enough, the cost of missing alcohol is only half of the story.  Increasingly, restaurants and bars are learning that they have substantial tax liabilities resulting from stolen alcohol.  I urge you to learn more about this insidious practice, here.  It’s no wonder that 35% of restaurants fail because of employee theft!
Continue reading “Restaurant Theft Findings”

Make Butchered Inventory Perpetual

The majority of the cost of most entrées comes from the “protein” component – meat or fish.  Chefs try to maintain a consistent portion size, usually based on weight.  Despite consistent portions, the cost will fluctuate depending on the raw purchase cost and the butchering yield.  Even if you don’t have recipes fully documented and costed for every menu item, as a bare minimum, you should know the portion cost of the protein component of every plate.  Also, you need to track the number of portions in inventory at all times.  This will allow you to identify major cost problems that may be occurring.
Continue reading “Make Butchered Inventory Perpetual”