If you use Class or Location tracking in QuickBooks - or want part of your sales or cost of goods recorded to different accounts - MyWorks can send the lines of each Daily Summary to a QuickBooks Class, Location, Income Account and COGS Account based on your Shopify tags. Your Profit & Loss by Class or by Location stays accurate even though the day's orders sync as a single journal entry.
Overview
This feature is available on our Scale and Soar plans. Open MyWorks Sync > Settings > Order and, with Sync Shopify Orders as set to Daily Summary or Based on Order Tag, scroll to QuickBooks Class, Location and Accounts in the Summary settings. You'll find two tables and a set of defaults:
Order tags: best when whole orders belong together - retail vs. wholesale, a sales channel, a store location. The day's orders are grouped by matching order tag, and every line in a group carries that row's Class and Location.
Product tags: best when the split follows your products - separate brands or product lines sold together in the same orders. Each product's income and Cost of Goods Sold lines follow that product's row.
Defaults: the Class and Location for anything the tables don't cover.
Each row has the same five columns: the Shopify tag(s), QuickBooks Class, QuickBooks Location, Income Account and COGS Account. Fill in only the columns you need - a blank column falls back to the defaults - and leave a whole table empty to skip it. Click Add Field for another row, then save.
Order tags
Enter the order tag(s) for each row. Here's how it works:
Multiple tags can be comma separated in a row - an order matching any of them joins that row's group. If an order matches more than one row, the first matching row wins.
Every line in the group - income, shipping, tax, discounts, payments, refunds and COGS - carries the row's QuickBooks Class and Location, and each group balances on its own, so a Profit & Loss filtered by Class or Location stays accurate.
The row's Income Account replaces the Default Sales Account for that group's product sales, and its COGS Account replaces the Default COGS Account for the group's Cost of Goods Sold lines. Shipping, discounts, tax and the other lines keep the accounts set at the top of the Summary settings.
Orders that match no row are still included - under the Default QuickBooks Class and Location if set, or with none if not. Nothing is ever left out of the summary.
These rows apply only to the Daily Summary. They're separate from the Order Tag to Class or Location mapping used when syncing individual orders, so the same tag can carry a different Class in each.
💡 Tip: the free Shopify Flow app can automatically add tags to your orders - including based on the order's POS or fulfillment location, sales channel, or customer type - so you can drive this without tagging orders by hand.
Product tags
Enter the product tag(s) for each row. Here's how it works:
Multiple tags can be comma separated, and the first matching row wins when a product matches more than one.
Each product's sales (income) line and Cost of Goods Sold line follow its row's Class, Location, Income Account and COGS Account - even when one order contains products from several rows.
A row's Income Account takes priority over a Shopify Collection mapping. A product whose row leaves Income Account blank still follows its collection mapping, then the Default Sales Account.
The other lines - shipping, tax, discounts, payments, gift cards and tips - can't be attributed to one product, so they use the Defaults and the default accounts.
Refunds: refunded product sales and the other refund lines use the Defaults, while the Cost of Goods Sold reversal for a refunded product follows that product's row.
Products that match no row are still included, under the Defaults.
Using both tables together
Order tag rows group the day's orders first; inside each group, product tag rows route that group's product lines. A column a product row leaves blank falls back to the order tag row it sits in, and then to the Defaults. For example, an order tag row for your wholesale channel can carry a Wholesale class while a product tag row sends one brand's sales to its own income account inside that class.
Defaults
Default QuickBooks Class and Default QuickBooks Location are used by any order or product that matches no row, by any row that leaves that column blank, and by the order-level lines when you route by product tag. Leave either blank to post those lines with no Class or Location. Income and COGS fall back to the Default Sales Account and Default COGS Account in the same settings.
Helpful notes
Routing doesn't change the totals - it's still one journal entry per day (or per month) with the same amounts, organised into more lines.
Class and Location tracking must be turned on in QuickBooks (Settings > Advanced > Categories) for them to be available to select in MyWorks. QuickBooks may call Locations Departments, Divisions, Stores or Territories, depending on the label chosen in your company.
Refunds and payments follow the current tags on their order, so a refund processed days later is grouped with the rest of its order's group when routing by order tag.
If you're also syncing Cost of Goods Sold in your summaries, the COGS lines follow the same rows - by group with order tags, or per product with product tags - and post to the row's COGS Account when one is set.
Outside the US, every routed line also carries its QuickBooks tax code - see Syncing VAT and GST tax codes in Daily Summaries.