Amazon: Post Revenue by Fulfillment Channel 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:
The subcategories are optional to map. In the case of the Amazon Seller Summary, we offer the Fulfillment Channel (Amazon Fulfilled - AFN or Merchant Fulfilled - MFN) or Item Name from Amazon Seller as subcategories for Gross Sales and Returns. This means you have the option to break down sales and returns by fulfillment channels 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 fulfillment channel or item name accounts to give you insight into performance.
Changing the Default Posting Method
The default posting method for Amazon Seller is by fulfillment channel. However, if you would like to change this rollup to per item name, visit the connections page and app tab. From here, locate the Amazon Seller 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 Fulfillment Channel (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.