Generating Accurate Daily Sales Reports

Protect the integrity of your POS data and prevent discrepancies that could cause trouble at tax time.



ThinkStock

QUESTION:

How can I make sure that my POS system generates an accurate daily net sales report?

ANSWER:

We frequently come across discrepancies between tax filing records and POS reports while gathering details for an audit. Does this matter, and should you care?

Yes, you should care. The daily net sales calculations generated from your POS system should accurately reflect your restaurant’s operational activity for that day. Therefore, from open to close, all transactions entered into the POS during the day should be scrutinized and any errors or adjustments identified before the final close-out at the end of the workday.

Since the POS results are captured electronically, any possibility of corrupted files or unauthorized manipulation should be considered, and procedures should be in place to monitor and curtail such activity. Since your POS system is the source of original documentation that’s frequently requested in an IRS audit—as well as for a restaurant sale, banking analysis or any outside request for verification of net sales—it’s paramount to preserve the integrity of this data. You need to always be able to rely on it and know that the data hasn’t been altered in any way.

If discrepancies emerge due to accidental or intentional corruption of your POS data, countless hours may be consumed as you try to figure out what happened. If this happens during an audit or when a potential buyer is analyzing your financial statements, it can tarnish your credibility. In addition, since most ratios used in analyzing your business operations involve a percentage of net sales, the figure is imperative to ensure accuracy in many areas of your business.

What should you do to ensure that you’re always working with accurate data? Here are three suggestions:

1. Back up your data. Be diligent in backing up this important POS data on a regular basis so you’ll have an extra copy if something goes wrong with your POS system or if data somehow gets altered at a later date.

2. Control access to the data. Limit the ability of individuals—whether they’re owners or managers—to alter transactions after the daily close sequence has occurred. Follow this procedure consistently—it will save time and protect everyone’s credibility in the long run.

3. Generate monthly statements. Create a system that exports data electronically from your POS system so that you can access it at a later date. Use this data to create monthly financial statements and memorialize your operational statistics.

In short, this data is vital to evaluating your pizzeria’s profitability and net worth, and it also helps keep you out of trouble with the IRS. Don’t wait until tax time to determine if your POS system generates accurate results—that’s a recipe for trouble!

Edit Module

Tell us what you think at or email.

Edit Module
Edit ModuleShow Tags
Edit ModuleShow Tags

Related Articles

Recipe of the Month: Roasted Cauliflower and Prosciutto Pizza

Polly-O crafts a flavorful treat with this pie featuring roasted cauliflower, prosciutto, garlic and Parmesan

Pizza Without Borders - Competition Heats Up in the Eastern Bloc

As more pizza competitions and associations pop up in Russia, Bulgaria and Poland, the quality of pizza and prestige of the pizzaiolo continues to rise.

The Chef's Corner: Scott Wiener Q&A

PMQ test chef Brian Hernandez discusses the ins and outs of Scott Wiener's pizza tours, his experience with the pizza industry, and what's next for the pizza-crazed entrepreneur.

From the Editor - A New Year and a New Look For PMQ

This month we focus on the explosive growth of Artichoke Basille and roll out a new look for the magazine!

Product Spotlight: January-February 2018

Dough trays, tomato strips, yeast, menus, ovens and more.

Extra! Extra! Read all about the Pizza Press, a unique fast-casual chain in Southern California

At the Pizza Press, pizza makers are the “editors” and customers get to “publish” the pie of their choice.

Take a hike: How to cope with a higher minimum wage

A pizzeria owner in Washington state offers a four-pronged strategy for staying profitable in an era of rising labor costs.

10 tips for adding a take-and-bake option

Tom “The Dough Doctor” Lehmann walks you through the steps for modifying your dough formula and procedure.

The Chef’s Corner: Scott Wiener and the Mo-Heato

The popular owner of Scott’s Pizza Tours isn’t a professional chef, but this recipe will make you think otherwise.

All ‘Choked Up: How a couple of East Village pizza guys became Food Network stars

Artichoke Basille’s has boomed from a shoebox-size Manhattan underdog to a 12-store media magnet—and now sets its sights on franchising.
Edit ModuleShow Tags
Edit ModuleShow Tags
Edit Module
Edit Module
Edit ModuleShow Tags
Edit ModuleShow Tags
Edit Module
Edit ModuleShow Tags
Edit ModuleShow Tags