A system that is used throughout the restaurant industry is POS which stands for Point of Sale. This computer-operated system allows business owners to track sales, cash flow, food inventory and can help make your bookkeeping simple enormously. A POS system is a necessity because of the great magnitude of cash and credit cards that pass through a restaurant each day. A POS system not just tracks every penny of your sales but many POS programs also function as credit card processors. The orders go through the computer, directly to the printer present in the kitchen. Since the POS system acts as a time clock, it can also help in preparing the payroll.
The objective for this case study is to check the POS data for integrity, look for variances and its justification and ways to reconcile it, consequences on financial reports and explain why auditing these data are of utmost necessity before starting the bookkeeping function. POS is the system in which the day to day restaurant transactions data is stored and gives the bookkeeper/accountant access to all data in a meaningful manner so that they can record the transactions appropriately in the accounting software and use it for further analysis. We have referred to the data of one of our clients, a franchisee of Papa John’s Pizza to elaborate our case.
Firstly, let’s first look at the various categories of data which can be extracted from the POS and is of significance from an accounting perspective.
In this case study, we will describe issues related to Sales. In Part 2 of this case study, we will take up Purchases, Inventory Transfer & labour.
Here is an excerpt of sales data taken from a monthly store report. Ideally, the Net sales should be the sum of the taxable and non-taxable sales. However, in this instant case, the Net sales is $46,811.61 and the sum of Taxable/non-Taxable sales is $46,761.61. Well, the difference is just $50. But for a restaurant franchisee having 30 odd stores, this small difference will cause wrong sales data being recorded in the books of accounts and wrong sales tax calculation. These minute errors could lead to huge time-consuming reconciliations at the end of the year. It is important that Taxable sales and non-taxable sales be recorded separately so that sales tax reconciliation can be prepared with ease. Therefore, it is necessary that we confirm the numbers before recording it in the accounting software and figure out a way to reconcile it (if necessary) at the very beginning.
Below is a sample Monthly store report pulled from the POS.
In this instant case, we pulled the taxable sales report from the POS which provides us breakup of daily sales for a particular month. Here it is:
Tran Date | Total Sales | Taxable Sales | Tax Exempt Sales | Delivery Fees | Total Net Sales | Tax Collected |
1/1/2020 | 1484.31 | 1397.15 | 0 | 136.5 | 1400.15 | 84.16 |
1/2/2020 | 1020.69 | 958.83 | 0 | 84.5 | 962.83 | 57.86 |
1/3/2020 | 1868.36 | 1726.1 | 37.5 | 120.25 | 1764.6 | 103.76 |
1/4/2020 | 2098.36 | 1976.39 | 0 | 185.25 | 1979.39 | 118.97 |
1/5/2020 | 1509.38 | 1422.79 | 0 | 123.5 | 1423.79 | 85.59 |
1/6/2020 | 1309.67 | 1233.37 | 0 | 110.5 | 1235.37 | 74.3 |
1/7/2020 | 1141.92 | 1074.17 | 0 | 61.75 | 1077.17 | 64.75 |
1/8/2020 | 1280.93 | 1093.1 | 120 | 81.25 | 1215.1 | 65.83 |
1/9/2020 | 1336.72 | 1234.26 | 27.21 | 110.5 | 1262.47 | 74.25 |
1/10/2020 | 2387.05 | 2212.79 | 37.5 | 175.5 | 2253.79 | 133.26 |
1/11/2020 | 2309.97 | 2176.96 | 0 | 172.25 | 2178.96 | 131.01 |
1/12/2020 | 1417.59 | 1333.17 | 0 | 107.25 | 1337.17 | 80.42 |
1/13/2020 | 841.02 | 791.33 | 0 | 58.5 | 793.33 | 47.69 |
1/14/2020 | 1067.32 | 1006.79 | 0 | 87.75 | 1006.79 | 60.53 |
1/15/2020 | 1409.64 | 1215.52 | 120 | 100.75 | 1336.52 | 73.12 |
1/16/2020 | 1196.23 | 1024.53 | 109.08 | 71.5 | 1134.61 | 61.62 |
1/17/2020 | 2095.58 | 1948.4 | 30 | 198.25 | 1978.4 | 117.18 |
1/18/2020 | 2192.28 | 2067.92 | 0 | 182 | 2067.92 | 124.36 |
1/19/2020 | 1914.25 | 1805.65 | 0 | 162.5 | 1805.65 | 108.6 |
1/20/2020 | 1030.96 | 970.49 | 0 | 81.25 | 972.49 | 58.47 |
1/21/2020 | 1465.84 | 1382.68 | 0 | 110.5 | 1382.68 | 83.16 |
1/22/2020 | 1596.02 | 1392.33 | 120 | 104 | 1512.33 | 83.69 |
1/23/2020 | 1271.36 | 1197.25 | 0 | 104 | 1199.25 | 72.11 |
1/24/2020 | 2484.67 | 2306.91 | 37.5 | 178.75 | 2345.91 | 138.76 |
1/25/2020 | 2092.36 | 1969.71 | 0 | 172.25 | 1973.71 | 118.65 |
1/26/2020 | 1744.05 | 1644.16 | 0 | 143 | 1645.16 | 98.89 |
1/27/2020 | 1107.27 | 1044.45 | 0 | 87.75 | 1044.45 | 62.82 |
1/28/2020 | 1323.77 | 1179.03 | 71.74 | 100.75 | 1252.77 | 71 |
1/29/2020 | 1441.54 | 1244.6 | 120 | 97.5 | 1366.6 | 74.94 |
1/30/2020 | 1589.17 | 1499.05 | 0 | 94.25 | 1499.05 | 90.12 |
1/31/2020 | 2543.47 | 2330.45 | 70.75 | 195 | 2403.2 | 140.27 |
49571.75 | 45860.33 | 901.28 | 3799.25 | 46811.61 | 2760.14 |
We then compared it with the store report.
In Sales Report | In Store report | |
Total Sales | 49571.75 | 49571.75 |
Sales Tax | 2760.14 | 55.52+2704.62 = 2760.14 |
Net Sales | 46811.61 | 46811.61 |
Taxable Sales | 45860.33 | 41141.76+929.07+3789.50 = 45860.33 |
Tax Exempt Sale | 901.28 | 891.53 + 9.75 = 901.28 |
Delivery Charge | 3799.25 | 3799.25 |
The result is that the numbers of the sales report are consistent with that of the store report. However, the sum of the taxable and Non – Taxable sales is not equal to the net sales in both the reports. The only likely reason we can ascertain is a technical error in the POS. However, we need to find a way out to reconcile this in our accounts.
Therefore, what we suggest is to create a Sales Discrepancy Ledger (Type -sales) and Credit the account with an amount equal to the difference of the net sales and sum of taxable and non-taxable sales. This is to make sure that the total is equal to Net sales because that is what will be reported to the Franchisor. Refer to the screenshot below:
WhatsApp us