Accounting Mapping Tables

Once you "Apply" your General Settings, you can move on to the subsequent mapping section.

Sales

If you selected the a Summary posting method, you can map your sales at the Point of Sale department or category level by selecting an income account from a dropdown list.  You can also search for accounts by backspacing over the "None" and start typing an account name or number (if you are using account numbers or codes).  If you selected the Itemized Posting Method, the sales mapping will be at the item/SKU Level,

Tracking categories (in this case “Class” and “Location”) may also be specified for each line.  Other accounting systems such as NetSuite and Sage Intacct have additional tracking category options.  

You can assign defaults in the top section to apply to all unmapped line items. 

Please ensure that your accounts chosen for mapping sales are income accounts accounts.

You can assign different accounts to specific line items. All other items will be assigned your default and any new line item will automatically have the defaults applied. 

Discounts, Returns and Offsets

This step will contain all of your sales offsets for mapping purposes: primarily, discounts and returns.  Depending on your Point of Sale solution options, discounts will either be mapped at the discount type or sales category level.  Discounts will typically be mapped to accounts where the account type=Income in the accounting system or, in some cases, you may opt to map a discount to an expense such as Employee Meals or Promotions expense.

Sample Discount types may include:

•    Employee Discounts
•    VIP Discounts
•    Birthdays

Other Charges

Other Charges may include Tips Collected, Gift Cards Sold and other service charges.

Click Here for information on mapping Gift Cards

Click Here for information on mapping Cash Tips

Sales Taxes

If your Point of Sale supports multiple sales taxes, each sales tax collected in the POS will be reflected as its own line item for mapping purposes.  For QuickBooks, you should also assign the each sales tax to the QuickBooks Vendor associated with the sales tax collected.

Payments

Map your payments to mirror how you receive payments from your POS partner. If all payments are combined into one deposit, group all credit cards together. If one card is broken out, break out that card individually. During setup, each individual payment/tender type as defined on your Point of Sale will be be displayed as a line item in your payments mapping.

Credit Card tender types (tender types that will be part of a merchant services processor batch) may be grouped together in whole or in part or mapped individually.  To group, select the Toggle All Credit option and map the All Credit Cards line.  Then, if you still wish to have a specific tender type create its own line, simply map only that line. 

The above configuration would produce the following entry:

Mapping each credit card type individually would result in the following entry:

Mapping all credit card types only would result in the following entry:

Mapping other tender types:

Your payments may include those from gift cards. Please see the article below for guidance on mapping gift cards:

Accounting for Gift Cards and Gift Certificates

Your accounting posting may include payment exceptions. Please see the article below for information on how Shogo handles these transactions:

What are payment exceptions? How Shogo handles payment exceptions

Your Point of Sale Provider may or may not provide their fees to Shogo. Please also note that Third Party Partners like Door Dash, UberEats, GrubHub, etc may be reporting their gross charges to your Point of Sale Partner. See the article below for guidance on fees below:

Credit Card Processor and Third Party Payment Fee Information in Shogo

Cash Drawer

 Depending on your Point of Sale solution, Cash Drawer events may include the following:

• Paidins
• Paidouts
• Purchases 
• Drawer
• Over/Short

For more information about mapping the Cash Drawer Click Here

For additional information and more accounting settings and features, see Accounting General Preferences.

Inventory COGS

If your Point of Sale transmits Inventory & COGS data to Shogo, you may want to post that data to your accounting system. Click on the General Settings section

Click on the Accounting Options tab and Enable Book Inv/COGS 

Map the correct COGS and Inventory accounts in your accounting system

For more information on Inv/Cogs, Click Here

Purchase Orders

If your Point of Sale transmits Purchase Order data to Shogo, you may want to post that data to your accounting system. Click on the General Settings section

Click on the Accounting Options tab and select how you would like to sync your Purchase Orders:

Next, map where the Purchase Order items and the Vendors:

For information on Purchase Orders Click Here

Accounts Receivable

For more information on mapping Accounts Receivable Click Here