Shogo supports the following posting methods for posting your Point of Sales data to QuickBooksSales:
- Journal Entry
- Summary Sales Receipt
- Itemized Sales Receipt
Creates a single journal entry with the sales grouped based on the Point of Sale department or category, depending on your Point of Sale's naming convention.
Summary Sales Receipt
Creates a single Sales Receipt (net-to-cash) based on the Point of Sale department or category, depending on your Point of Sale naming convention.
Itemized Sales Receipt
Creates a single Sales Receipt (net-to-cash) based on the Point of Sale item (SKU/PLU).
The individual options are as follows and will vary, depending on what your Point of Sale supports.
Customer: Only applies for Sales Receipts and optionally allows you to associate the Shogo posting with a QuickBooks Customer. Please note that the Shogo integration is not based on each Point of Sale transaction, so this customer you be something like "Walk-In" or "Point of Sale" not an individual customer who purchased a product or service.
Deposit Account: Only applies to Sales Receipts. Unlike a QuickBooks Invoice, Sales Receipts will create a net balance which will represent the amount of the cash deposit, which will be recorded into this "Deposit Account." This will, typically, be a Cash on Hand account, the Undeposited Funds account, or (not recommended) an actual bank account.
Track Sales Tax in QuickBooks: If this is checked, Shogo will use the sales tax rates as defined in QuickBooks, allowing you to match the Point of Sale tax rates with QuickBooks. You can also optionally specify a non- taxable rate, if applicable.
Book Inventory/COGS: Creates a journal entry representing Inventory and Cost of Goods Sold offset value amounts based on products sold net of returns. Inventory and COGS accounts are specified at the category level. Please note that this option is a VALUE based not a QUANTITY based integration (i.e. Shogo will post the cost of how much was sold not how many) . If you are applying your vendor invoices directly to a COGS account in QuickBooks as you are paying your bills, you do not want to enable this option as it will result in duplicate COGS amounts as well as reduce an Inventory Asset account balance that does not exist.
Book Purchase Orders: Currently only available for Lightspeed Retail. When a PO is marked as Completed in Lightspeed, this option will create a Purchase Order in QuickBooks. The PO Vendor is auto-created if it doesn’t already exist in QuickBooks. The PO is itemized, using inventory accounts specified in the Inventory/COGS settings.
Deposit Checks with Cash: If you deposits checks together with your cash in the same deposit (as recorded on your bank statement), this option will group all cash and check tenders processed on a given date on the Point of Sale into one amount to facilitate matching with the actual bank deposit.
Ignore Over/Short: Depending on your store operations, you can select to ignore any over/short reported by your Point of Sale and instead book the expected cash amount. This is most often used when the merchant knows that the cashiers will frequently not close the drawer properly.
Auto-Payout Tips: Auto-Payout of Tips can be used if you are paying out credit card tips at the end of the day in cash. Turning this on will create an accounting line item in the opposite direction of your Credit Card tips accounting line - and the two are, typically, mapped to the same account and net to zero in that account on a daily basis.
The Auto-Payout will also reduce the amount of the theoretical cash deposit by the amount of the calculated payout.
With Auto-Payouts turned on, your cash deposit will be calculated as:
Cash Sales - POS reported Payouts - AutoPayouts + Payins +/- Over/(Short)=Cash Deposit
If the above calculation results in a negative number, your Cash Drawer mapping will be used for posting the negative amount rather than your Cash payment mapping.