Products can only have a single income account, but you can track sales by class and item. You can group products by the class and income account using the sales by class summary.
You must set up a rule that assigns a class, based on a store name. In this example, the store name is Shopify US:
- After logging into Connex for QuickBooks, hover over the gear and click rules engine.
- Click add new rule.
- Add this rule:
Connex will create classes, if they do not exist. You must enable class tracking in QB:
- In QuickBooks, go to edit > preferences > accounting.
- Under the company preferences tab, click use class tracking for transactions:
In QuickBooks, you will see online in the class field. Here is an example transaction. In QB, go to reports and click profit and loss. Select profit and loss by class. Here is the end result: