Shopify: Post Revenue by Product Type or Item Name

Categories and Subcategories in Journal Entries

When completing a journal entry mapping, we have categories and subcategories. Categories are required to be mapped, or else the journal entry will fail to post to accounting. See below for an example showing Gross Sales as the category and the subcategories beneath it:

The subcategories can be located for a specific journal entry line by clicking the caret on the right, as shown below. If this caret is not present, it means this line does not have any subcategories:

Optional Subcategory Mapping

The subcategories are optional to map. In the case of the Shopify Summary, we offer the product type or product name from Shopify as subcategories for Gross Sales and Returns. This means you have the option to break down sales and returns by product types or item names.

Creating Accounts with the Magic Wand

If you don't have accounts set up in your accounting platform, click on the "Magic Wand" button to the right, as shown below, which is visible per line. This will create an account in your accounting platform and map that line to this newly created account:

Once this account is created and mapped, the gross sales will be posted to the account in your accounting platform. Returns or refunds can be similarly mapped and posted to the same product type or item name accounts to give you insight into performance.

Changing the Default Posting Method

The default posting method for Shopify is by product type. However, if you would like to change this rollup to per item name, visit the "Connections" page and "App" tab. From here, locate the Shopify connection and expand the setup to locate "Configure," as shown below. When clicking "Configure," this will open a modal to change the "Rollup Method."

Below is the view with the Rollup Method option where you can select product category (default) or item name, which will impact the subcategories for gross sales and refunds as discussed above:

As always, feel free to contact [email protected] if you have any questions.