Entering sales adjustments

Bar Cop takes your product usage and compares it to your sell prices to calculate theoretical sales (or what should have been rang into your register based on the amount of product used). You want the theoretical sales to be as accurate as possible, so at times you might need to make some adjustments.

What are sales adjustments?

Adjustments are made for discount pricing, spillage, comps, voids, or anything else that would adjust a product's calculated theoretical sales. If a product was used (poured or served), and charged a price other than the regular price in setup or not charged for at all, the retail price needs to be adjusted so it is not included in the calculated theoretical sales. Product size variations that are not cost out correctly based on each product's standard pour and regular price using the pricing tool (see using the pricing tool) should also be adjusted to avoid getting inflated variance numbers (see variance analysis reports).

Bar Cop making adjustments 1

Enter sales adjustments at the end of each inventory period.

Let's look at price discounts. If you run a special on Absolut shots, enter the discounted price you will be selling them for and then enter the number of drinks you sold at the discounted price. Bar Cop will then calculate the adjustment that needs to be made to the theoretical sales. If you keep a spill sheet, you will also want to enter the number of products spilled. You can also make miscellaneous adjustments plus or minus as needed.

Adjustments are entered by clicking the notepad icon or directly by clicking on the cell and typing (or using voice command).

Bar Cop adjustments 2

Any adjustments made here will automatically carry over and adjust the calculated theoretical sales in the analytical metrics and variance analysis reports. When you are finished making adjustments, save the file.

Things to know:

1) Adjustments effect the final calculated theoretical sales in analytical and variance reports. For precise usage data and a true comparison between theoretical and register sales, adjustments need to be entered as accurate as possible.

2) Pour size variations and mixes that are not cost out correctly (ie. are discounted) should be adjusted. To cost out drink mixes, food plates, and size variations correctly use the pricing tool (see using the pricing tool).