Entriwise Documentation
  • Entriwise Documentation
  • Getting Started
    • Connect Entriwise
    • Configure QuickBooks Desktop
      • Amazon Balance Account
      • Track Amazon Orders
      • Track Amazon Fees
      • Entriwise Connector
    • Configure QuickBooks Online
      • Amazon Balance Account
      • Track Amazon Orders
      • Track Amazon Fees
  • User Guide
    • Item Mapping
      • Manual Item Mapping
      • Inventory Tracking
      • CSV Inventory Mapping
    • Transaction Import
      • Amazon Orders
      • Amazon Refunds
      • Amazon Fees
      • Amazon Other
      • Amazon Ignored
  • FAQ
Powered by GitBook
On this page
  • Item Mapping Types
  • Amazon SKUs
  • Amazon Charges
  • Amazon Fees
  • Amazon Promotions
  • Amazon Other
  • Mapping with CSV Files
  • Mapping Subitems
  1. User Guide

Item Mapping

Mapping Amazon SKUs, fees and other services to QuickBooks inventory, non-inventory and service items in Entriwise

PreviousUser GuideNextManual Item Mapping

Last updated 5 years ago

To import Amazon Seller Central transactions into QuickBooks using , it is necessary to configure Amazon to QuickBooks item mapping.

There are five types of items that may require mapping in : amazon-sku, amazon-charge, amazon-fee, amazon-promotion, amazon-other (see for more info).

If you use QuickBooks Online and lack a good understanding of accounting principles, we strongly advise to opt-in for Entriwise auto-configuration of Amazon fees, charges and promotions in your QuickBooks company file.

If you don't use Entriwise auto-configuration for or if you use , item mapping must be manually configured for amazon-fee, amazon-charge item types.

Additionally, if SKU of some or all of your is not set equal to corresponding QuickBooks inventory item name, it is necessary to configure amazon-sku mapping for inventory items.

Item Mapping Types

There are four types of mapping items

Amazon SKUs

amazon-sku item mapping is created between Amazon inventory SKU and QuickBooks Inventory (non-Inventory) Item Name.

If your Amazon inventory SKUs don't have corresponding inventory items in QuickBooks, you must create them.

Contact Entriwise support for instructions on creating inventory item in QuickBooks in bulk.

Amazon Charges

Amazon charges (item type amazon-charge) are services for which Amazon charges buyers on behalf of Amazon sellers. Examples of amazon-charge items include Shipping, GiftWrap, etc.

amazon-charge item mapping is created between Amazon Charges and QuickBooks Other Charge items (in QuickBooks Desktop) / Service Items (in QuickBooks Online), associated with income accounts.

Amazon Fees

Amazon fees (item type amazon-fee) are fees that Amazon charges Amazon sellers. Examples of amazon-fee items include Commission, ShippingChargeback, FBAPerOrderFulfillmentFee, etc.

amazon-fee item mapping is created between Amazon Fees and QuickBooks Service Items, associated with expense accounts.

Amazon Promotions

amazon-promotion item mapping is created between Amazon promotions and QuickBooks Service Items, associated with income accounts.

Amazon Other

amazon-other item mapping is created between Amazon Other and QuickBooks Service Items, associated with income and expense accounts.

Mapping with CSV Files

For example, to map Amazon SKU iphone-5-wt-32gb to QuickBooks Inventory Item named Apple iPhone 5 32GB white you will need to have the following line in the CSV file:

iphone-5-wt-32gb,Apple iPhone 5 32GB white

Mapping Subitems

Applies to QuickBooks Desktop and QuickBooks Desktop Enterprise

Amazon SKUs (item type amazon-sku) are listed and sold in .

Amazon promotions (item type amazon-promotion) are promotions that Amazon gives to the buyers. Examples of amazon-promotion items include ShippingPromotions. Amazon uses ShippingPromotions items for promotional shipping to give the buyers discounted or free shipping. To account for such situations, both full shipping charges and promotional credits must be shown as positive and negative amounts on the Sales Receipt documents created by .

It is possible to upload and download mapping using , containing Amazon Inventory SKU in the first column and QuickBooks Item Name in the second column.

For more info see

If you use subitems (parent and child items) in , QuickBooks Item Name in mapping table for a subitem must be specified as <parent-item-name>:<child-item-name>, using parent item and colon symbol.

For example if in you have a parent item called iphone-5 and a number of subitems / child items called iphone-5-wt-16gb, iphone-5-bk-32gb, iphone-5-bk-64gb, QuickBooks Item Name of these subitems / child items in Entriwise mapping must be specified as iphone-5:iphone-5-wt-16gb, iphone-5:iphone-5-bk-32gb, iphone-5:iphone-5-bk-64gb.

Amazon inventory
Amazon Seller Central
Entriwise
CSV files
CSV Inventory Mapping
QuickBooks Desktop
QuickBooks Desktop
Entriwise
Entriwise
QuickBooks Online
QuickBooks Desktop
Amazon Inventory
Item Mapping Type Details