Search Site     
HOME >> TIP OF THE MONTH     
Back Office
Home Office
Central Price Book
POS Interfaces
Hand-held Scanning
EDI Conversion
Fuel Distribution
Work Orders/ALLDATA
Work Orders/Mitchell 1
Sunray - ASP
Digital Dispatch
Training
Support
System Administration
POS Conversion
General Information
Employment
Sales
Support
Tip of the Month
Press Releases
Product Versions
Trade Shows
Tip of the Month

How to Buy Coffee Supplies and
Expense Them

Tip

Expense coffee-related components to their own expense account in order to provide an accurate net profit for coffee sales.

The accounting principle based on determining net profit (and used on the Income and Expense Statement) is:

Sales - Cost of Goods Sold = Gross Profit - Expenses = Net Profit

Trying to associate a cost of goods sold value for coffee cups, lids, napkins, stirrers and other related components on a per sale basis using the coffee PLU does not provide an accurate cost of goods sold (and, therefore, gross profit or net profit) since different customers use different amounts of said components.  To book an accurate net profit, record the components that are directly related to a coffee sale PLU as an expense to an expense account created for that specific purpose.  For example, an expense account named "COFFEE."  Then set up your coffee sale PLUs with zero cost (and, therefore, zero cost of goods sold). This way, when the coffee sale is recorded, the gross profit will equal the sale amount.  Then, if you record the cups and other coffee components as an expense, your Income and Expense Statement will show the difference between gross profit and expenses and, as a result, give you an accurate net profit.

When, as described above, the coffee department sells only zero cost items, it is reported by CDB as a 100% gross profit department.  You then can compare the coffee department against the COFFEE expense account to analyze the difference between how much you sold and how much you spent on the same items in the date range specified—to the penny.

Please submit your ideas for Tip of the Month

Do you have a question, comment, or idea for Tip of the Month? Please complete this quick web form and we might use your submission for future updates!

Past Tips of the Month...

December 2006: How to Get a PLU Report without Bar Coded Items

November 2006: How to Create a Reorder Using the Hand-Held Terminal (HHT)

October 2006: Reorder Items in Selected Department Range

September 2006: Reorder Quantities Based on Minimum Purchase Quantity

August 2006: Reorder Quantities Based on Sales History

July 2006: How to Reconcile Inventory

June 2006: How to Reconcile Inventory After a Promotion...

May 2006: Reordering the Correct Number of Items

Home  |  About Us  |  Products  |  Services  |  What's New?  |  Contact Us