Creating Individual SKUs for Amazon Charges in NetSuite

Creating individual SKUs in NetSuite for various Amazon fees enhances financial tracking and reporting accuracy.

·4 min read·View Oracle Docs

Creating individual SKUs in NetSuite is crucial for representing various Amazon fees and credits accurately, especially when automatic SKU creation is not used. This procedure allows users to manage charges effectively in their cash sales and refunds related to Amazon settlements.

Manual SKU Creation

When not utilizing automatic SKU processes, manual creation of SKUs becomes essential. Be cautious to avoid errors, especially if certain SKUs have already been created automatically. Users should follow these steps:

  1. Only create SKUs for fees or credits not generated by the automatic process.
  2. Use other charge for sale items as the specific category for these SKUs. Ensure that the Can be Fulfilled option is unchecked and set the items as nontaxable.

Important Guidelines for Manual Entry:

  • Ensure no trailing spaces are present in SKU names.
  • Pay special attention to the assignment of income accounts relevant to each SKU.
  • If operating under multiple subsidiaries, ensure the recorded subsidiary matches those on your Amazon transactions to avoid discrepancies.

SKUs to Create

Below is a comprehensive list of the SKUs that should be created as other charges for sale items, ensuring all prerequisites mentioned above are followed:

SKU Name
A2ZGuaranteeRecovery
Adjustment
Amazon Capital Services
Amazon Shipping Charges
Amazon Shipping Reimbursement
BalanceAdjustment
BuyerRecharge
ChargeBackRecovery
COD
COD Tax
CODFee
Commingling VAT
Commission
Commission Adjustment
Commission IGST
CommissionCorrection
COMPENSATED_CLAWBACK
Cost of Advertising
CouponRedemptionFee
CRETURN_WRONG_ITEM
CS_ERROR_ITEMS
CS_ERROR_NON_ITEMIZED
Current Reserve Amount
Customer Return
Customer Service Issue
Customs Reimbursement
Damaged:Inbound
Damaged:Outbound
Damaged:Warehouse
Discount Not Applied
DisposalComplete
Early Reviewer Program fee
ExportCharge
FBA Inventory Storage Fee
FBA Pick & Pack Fee
FBA transportation fee
FBACustomerReturnPerOrderFee
FBACustomerReturnPerUnitFee
FBACustomerReturnWeightBasedFee
FBAInboundDefectFee_BAGGING
FBAInboundDefectFee_LABEL_ISSUE
FBAInboundDefectFee_SUFFOCATION_STICKER
FBAInboundDefectFee_TAPING
FBAInboundTransportationFee
FBAInboundTransportationProgramFee
FBAPerOrderFulfillmentFee
FBAPerUnitFulfillmentFee
FBAWeightBasedFee
Fee correction
Fixed closing fee IGST
FixedClosingFee
FREE_REPLACEMENT_REFUND_ITEMS
GiftWrap
GiftwrapChargeback
GiftWrapTax
Grade and Resell Charge
Goodwill
Imaging Services Fee
INBOUND_CARRIER_DAMAGE
INCORRECT_FEES_ITEMS
INCORRECT_FEES_NON_ITEMIZED
Inventory Placement Service Fee
Inventory Storage Overage Fee
Item Not Received
LightningDealFee
LightningDealFee Special
Lost:Inbound
Lost:Outbound
Lost:Warehouse
LowValueGoods-Principal
LowValueGoods-Shipping
LowValueGoodsTax-Principal
LowValueGoodsTax-Shipping
Manual Processing Fee
Manual Processing Fee Reimbursement
MarketplaceFacilitatorTax-Giftwrap
MarketplaceFacilitatorTax-Other
MarketplaceFacilitatorTax-Principal
MarketplaceFacilitatorTax-RestockingFee
MarketplaceFacilitatorTax-Shipping
MarketplaceFacilitatorVAT-Principal
MarketplaceFacilitatorVAT-Shipping
MiscAdjustment
MISSING_FROM_INBOUND
MISSING_FROM_INBOUND_CLAWBACK
MULTICHANNEL_ORDER_LOST
NonSubscriptionFeeAdj
Paid Services Fee
PAYMENT_RETRACTION_ITEMS
POS_NOSKU
PREPFEE_REFUND
Previous Reserve Amount Balance
Principal_Promotion
Premium Experience Fee
Premium Placement Service Fee
RE_EVALUATION
RefundCommission
RemovalComplete
REMOVAL_ORDER_DAMAGED
REMOVAL_ORDER_LOST
RestockingFee
Return Adjustment
ReturnShipping
REVERSAL_REIMBURSEMENT
SAFE-T reimbursement
SalesTaxServiceFee
Shipping
Shipping label purchase
Shipping label purchase for return
Shipping Reimb.
Shipping tax
ShippingChargeback
ShippingHB
ShippingServicesRefund
ShippingTax
Storage Fee
StorageRenewalBilling
Subscription Fee
SubscriptionFeeCorrection
Tax
TaxDiscount
TCS-CGST
TCS-IGST
Unplanned Service Fee - Barcode label missing
VariableClosingFee
WarehousePrep
WAREHOUSE_DAMAGE
WAREHOUSE_DAMAGE_EXCEPTION
WAREHOUSE_LOST
WAREHOUSE_LOST_MANUAL

Key Takeaways

  • Manual SKU creation allows for comprehensive management of Amazon-related charges in NetSuite.
  • Ensure SKUs created do not conflict with existing items to avoid errors.
  • Pay close attention to inventory settings and subsidiary assignments during the creation process.

Source: This article is based on Oracle's official NetSuite documentation.

Frequently Asked Questions (4)

What category should I use for manually created SKUs representing Amazon fees in NetSuite?
When manually creating SKUs for Amazon fees in NetSuite, use 'other charge for sale items' as the category. Ensure that the 'Can be Fulfilled' option is unchecked and set the items as nontaxable.
Are there any special considerations for creating SKUs manually when operating with multiple subsidiaries in NetSuite?
Yes, when creating SKUs manually in multi-subsidiary environments, ensure that the recorded subsidiary for each SKU matches those on your Amazon transactions to prevent discrepancies.
What precautions should I take to avoid errors when manually creating SKUs for Amazon charges in NetSuite?
Avoid creating SKUs that may have already been generated automatically. Ensure there are no trailing spaces in SKU names and correctly assign income accounts. Additionally, verify that the SKUs align with organizational structures like subsidiaries, especially in multi-subsidiary setups.
How can I ensure that manually created SKUs do not conflict with existing items in NetSuite?
To prevent conflicts, review existing SKUs to ensure that any new SKUs do not duplicate or clash with those already generated by automatic processes. Pay attention to naming conventions and subsidiary assignments when creating new SKUs.
Source: Creating Individual SKUs Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Accounting

View all Accounting articles →