Skip to main content

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:

Screenshot showing Gross Sales category and subcategories

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:

Screenshot showing caret to reveal 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:

Screenshot showing magic wand button for account creation

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."

Screenshot showing Configure option for 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:

Screenshot showing Rollup Method selection

As always, feel free to contact support@bookkeep.com if you have any questions.