Shogo Configuration Simphony to QuickBooks Online Daily Sales

Introduction

Shogo is a tool that automatically syncs data through configuration.

Here, we are syncing Simphony sales to QuickBooks

There’s no way to sync old orders from Simphony, only daily transactions after the activation date.

Always click here to refresh Chart of accounts, products etc required for the configuration

QuickBooks integration status showing last refreshed date, activated date, and option to refresh current accounting reference data.

In Shogo, there are 3 ways to sync orders. I’ve listed them below with screenshots.

1. Journal Entry

This doesn’t have a customer setup, since Journal Entry doesn’t need it.

We have another option that records a journal entry. It will create one journal covering all sales with configured class and location.

General settings screen showing sales posting method, class, location, and memo configuration in accounting dashboard.

2. Summary Sales Receipt

General Settings screen showing selected Summary Sales Receipt option and Symphony Daily Sales customer field highlighted.
  1. Connected the Simphony account (MAHER) with the QuickBooks Online Sandbox account in Shogo.
    Store Info and Oracle Symphony connection settings showing store details, POS connection status, loading dates, preferences and POS entities.
  2. Configured it to run daily and create summarized records for the selected QuickBooks customer.
    QuickBooks connection screen showing linked Dara Testing account with refresh time, activation date, export settings and company menu.
    General Settings screen showing Summary Sales Receipt, Symphony Daily Sales customer selection, memo options and QuickBooks sync settings.
  3. Created all the required charts of accounts and items in QuickBooks.
    QuickBooks item list showing service items such as Amex credit, beverage sales, cash deposit, cash drawer, charge tips and discounts.
  4. Mapped Simphony items to QuickBooks items across all modules.
    Oracle Symphony major groups mapped to QuickBooks items with edit options and module menu showing sales and related configuration sections.
  5. Since orders are automatically created in Simphony from the POS system (and test orders can’t be created), I’ll wait until tomorrow to confirm if the orders sync to the selected QuickBooks customer.
    QuickBooks customer profile for Symphony Daily Sales showing customer details, financial summary, transaction tabs and invoice options.

3. Itemized Sales Receipt

General Settings screen with Itemized Sales Receipt selected and Symphony Daily Sales set as the customer for QuickBooks syncing.
  1. Created a new customer in QuickBooks and Configured it.
    General Settings screen with Itemized Sales Receipt selected and customer set to Simphoney Itemized Sales Receipts for QuickBooks sync.
    QuickBooks customer profile for Customer - Simphoney Itemized Sales Receipts showing details, financial summary, and transaction tabs.
  2. As of now, All the sales will be recorded as “All Sales” Item.
    Oracle Symphony items mapped to QuickBooks items with default All Sales settings and editable item mapping list for syncing.

    However, there is an option to map individual items.

    Do you want us to map them, or should they be synced as ‘All Sales’? The item will still be added in the description.

    Each time a product is added, you need to map it here (optionally).

    Oracle Symphony items listed alongside unmapped QuickBooks items in the item mapping table for All Sales configuration.
  3. Same for Discounts, Do we need to map default or each individual item?
    Oracle Symphony discount items mapped to QuickBooks discount items with default All Discounts settings and editable mappings.
  4. Configuration for “Other Charges”, Here we need to choose Vendor as well.
    Oracle Symphony other charges mapped to QuickBooks expense accounts with vendor assignments shown in the item mapping table.
  5. Configuration for “All Taxes”, Here we need to choose Vendor as well.
    Oracle Symphony tax items mapped to QuickBooks tax expense accounts with vendor assignments under Default for All Taxes settings.
  6. Configuration for “Payments”, Here we need to choose Vendor as well.
    Oracle Symphony credit card and other payment items mapped to QuickBooks accounts with vendor assignments in the payment mapping table.
  7. Configuration for “Cash Drawer”, Here we need to choose Vendor as well.
    Oracle Symphony cash-related items mapped to QuickBooks accounts with vendor assignments for payouts, cash over short, drawer and deposit.
  8. Example of how the sales will be synced.
    QuickBooks sales receipt showing Simphoney Itemized Sales Receipts customer, cash deposit, and product lines including All Sales and 5% SC.
    QuickBooks sales receipt showing multiple All Sales lines and a Discount items entry with negative amount applied to the total.
    QuickBooks journal entry showing Cash, Charge Tips, Sales Tax, credit card accounts, and Cash Deposit linked to Simphoney Itemized Sales Receipts.

Article by

Chintan Prajapati

Chintan Prajapati, a seasoned computer engineer with over 20 years in the software industry, is the Founder and CEO of Satva Solutions. His expertise lies in Accounting & ERP Integrations, RPA, and developing technology solutions around leading ERP and accounting software, focusing on using Responsible AI and ML in fintech solutions. Chintan holds a BE in Computer Engineering and is a Microsoft Certified Professional, Microsoft Certified Technology Specialist, Certified Azure Solution Developer, Certified Intuit Developer, Certified QuickBooks ProAdvisor and Xero Developer.Throughout his career, Chintan has significantly impacted the accounting industry by consulting and delivering integrations and automation solutions that have saved thousands of man-hours. He aims to provide readers with insightful, practical advice on leveraging technology for business efficiency.Outside of his professional work, Chintan enjoys trekking and bird-watching. Guided by the philosophy, "Deliver the highest value to clients". Chintan continues to drive innovation and excellence in digital transformation strategies from his base in Ahmedabad, India.