Getting Net vs Gross Sales on your MarginEdge Reports
What shows up on your nightly sales email and under the Performance > Sales Reports is based upon your settings on your sales mapping screen. You will utilize the settings for the "Category Type" and "Include in Sales Reporting" to control how the sales totals are calculated within MarginEdge. They do not have any impact on what is exported to your accounting system. For Exports, any line item that is on the sales mapping page will be exported.
To adjust these settings go to Accounting > Sales Mapping. Here you will see all of the information from your POS that is imported into MarginEdge. There are two key columns to pay attention to: Category Type and Include in Sales Reporting.
You can edit any of these fields by double-clicking on them and selecting the desired option from the drop-down menu.
On this page, the column “Include In Sales Report” has two options “Include” or “Exclude”. These options are exclusive to how you see your sales data presented in MarginEdge. (Remember, changing these settings DOES NOT impact the lines export to your accounting system.)
For determining what to “Include” or “Exclude” in sales reporting in MarginEdge, the only items that should ever be set to “Include” are your sales and discount lines. Doing this shows you your Net Sales from the POS system. If you would prefer to see Gross Sales from the POS system then you would set the discount lines to “Exclude” but keep the sales lines as “Include”. Things like tax, tip, tender, or any other misc. line item should not be set to “Include” unless your POS specifically tracks this as part of your sales.
If you want to see NET SALES:
- Select "Include" for any discount and comp lines you wish to include in the calculation. By including the discounts, they will impact the Gross Sales total in order to show you Net Sales. Select "Exclude" for any line you do not want used in the calculation.
- For your "Included" sales lines, please select the appropriate Category Type so that it will accurately flow to the appropriate places in your [me] reporting. If you do not add a Sales Category from the “Category Type” column for the lines you’ve selected to “Include” in Sales reporting, those lines not show sales data on the following [me] reports: P&L, Budgets, or Food Usage Report. This will cause variances against your actual totals.
- For any discounts you set to be "Excluded" from your sales in MarginEdge, those lines do not require a Category Type.
If you want to see GROSS SALES:
- Select "Exclude" for the discount and comp lines you do not want factored into the Gross Sales calculation, allowing you to see your total sales. If there are any you may want to include, select "Include" for any of those discounts.
- For your "Included" sales lines, please select the appropriate Category Type so that it will accurately flow to the appropriate places in your [me] reporting. If you do not add a Sales Category from the “Category Type” column for the lines you’ve selected to “Include” in Sales reporting, those lines not show sales data on the following [me] reports: P&L, Budgets, or Food Usage Report. This will cause variances against your actual totals.
- For any discounts you set to be "Excluded" from your sales in MarginEdge, those lines do not require a Category Type.
Excluding a line only affects how your sales appear in MarginEdge reports and does NOT prevent it from reporting to your accounting system
Once you’ve made adjustments, don’t forget to save your changes and your reporting will reflect your new preferences.