Tracking Shopify product sales in Daily Summaries

Review how to track Shopify product sales in the daily summary synced to QuickBooks - either to a single QuickBooks income account, or multiple.

Written by the MyWorks Team

Updated at July 18th, 2025

As MyWorks syncs Daily Summaries into QuickBooks from the Shopify sales that occured from a specific day; there's several ways to control how product sales are recorded to Income Accounts in the journal entry we create in QuickBooks.

Default Sales Account

In MyWorks Sync > Settings > Order, you can select a QuickBooks Sales Account, which we'll use by default for the product sales we sync in to QuickBooks.

Mapping Shopify Collections

Additionally, you can map Shopify Collections to different QuickBooks Income Accounts, which can be quite helpful if you'd like some product sales recorded to different income accounts than other product sales. 

Visit MyWorks Sync > Map > Collections to easily map each Shopify Collection to a QuickBooks Income Account of your choice. If a Collection is left unmapped, MyWorks will use the default Income account set above when syncing a daily summary.

Example

Below is an example that shows how the Shopify order product sales would reflect in the QuickBooks Daily Summary - along with any shipping, tips, sales tax and discounts in those Shopify orders.