If some of your categories aren't defined in a data dictionary, you will need to categorize them through the Shogo POS Data Mapping process. When A POS/Datasource doesn't provide a data dictionary, Shogo requires the customer to define the categories for those transaction types so they are treated correctly in Shogo and in your accounting system.
Perform POS Data Mapping
POS Data Mapping involves mapping each "Category" to a section of the Shogo Sales Summary Page. Therefore POS Data Mapping must be complete in order to see any of your sales data in Shogo reports/screens.
To access your data mapping, navigate to Settings>POS Data Mapping
Each location that needs POS Data Mapping will appear along with the categories that need to be defined. Once a category is defined in one location, the data definition will copy/cascade to all locations. Each time a category is defined, it will disappear from the location you are working on and on any location that also has the category in it's mapping.
Please use care with this step; data definitions are set initially for all stores at the same time, but can only be undone/changed one location at a time once they are set.
Once all of the items in the POS Data Mapping have been defined, you will see no items on the POS Data Mapping list. Shogo will begin the loading process which can take between 5-30 minutes depending on the amount of sales data.
Most Common POS Data Mapping Categories
There are many POS Data Mapping Categories available but 99% of the time you only need to use:
| Category | Definition |
| Sales | Income/Revenue |
| Discounts | Discounts and Sales Offsets |
| Service Charges | Such as Tips Collected, Gift Cards Sold |
| Credit Card | Use this Category to identify credit card payments that are expected to batch/deposit at a later date |
| Other Tender | Use this Category for any other payment methods such as Gift Cards, Loyalty, Integrated 3rd Parties, etc. |
| Cash | Use this Category for any Cash/Cash equivalent payment methods such as Checks |
| Sales Tax | Use this category to identify Taxes |
| Statistical | Use this category to identify non-financial statistical activity |
| Ignore | Use this category to complete ignore certain types of activity from the file |
Review your Sales Summary
Upon reloading your sales data, ensure your categories have been properly defined by viewing a Sales Summary for a specific date.
To do so, navigate to Reports>Sales Totals
Select your Store/Location, Date Range & Click the Refresh button
View the Sales Summary verifying that:
Grand Total of the Total Receipts=Grand Total of the Total Payments
If your Total Payments and Total Receipts do not match, it is likely due to one of two issues:
1) Most likely, one of the POS Data Mapping items is in the wrong category. I.e. a discount was mapped to 'Sales' by accident. If this is the case, you can update the store mapping (one at a time) and then reload your sales to see the update Shogo Sales Summary.
To correct a single category for one item:
Click on Settings>Stores>View Details (select your location if there are multiple locations)
Find the item in the list that needs to be recategorized and choose a new category in the dropdown
Reload the sales for the date that was out of balance. Use the article below to assist you in reloading your sales:
Reloading Sales & Regenerating Accounting
2) Your report/file could be unbalanced. If this is the case, you can utilize a POS Data Discrepancy Plug
Once you have verified that the Total Receipts and Total Payments balance, the accounting must be mapped. The items that had POS Mapping are new, so they will now need to be mapped to the appropriate GL Account/Item in the Accounting Mapping.
Map Your Accounting
All items that were defined in POS Data Mapping now must be mapped in your accounting settings.
To map your accounting, do the following steps:
Log into your account at app.shogo.io
Click on Settings>Accounting>View Details (if there are multiple locations)
Each Category that needs mapping will have a red badge. All items that need to be mapped in that category will be highlighted in yellow.
The article linked below gives general guidelines about accounting mapping:
To map the category globally (in this example listed as All Sales), click the Edit button and select an account. You can also select a Location/Class/Department/Revenue Center based on the integration options with your POS and accounting software. If you map the category globally, you will not see when a new item comes into this category. Do not use this method for mapping Payments or Cash Drawer.
To map individual items (in this example, listed as Oracle NetSuite item), click the Edit button for each item and select an account. You can also select a Location/Class/Department/Revenue Center based on the integration options with your POS and accounting software. You will need to update the mapping when a new item is added to the category if using this method to map.
When your mapping is complete, you will not see red badges or yellow highlighted items. Upon completion of all of your mapping, click the green Activate button to turn on the accounting portion of your Shogo integration.