Creating Individual SKUs for Amazon Charges in NetSuite
Creating individual SKUs in NetSuite for various Amazon fees enhances financial tracking and reporting accuracy.
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:
- Only create SKUs for fees or credits not generated by the automatic process.
- Use
other charge for sale itemsas 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.
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
- Applied Trans Date and Period Enhancements in NetSuite 20...
Latest updates in NetSuite 2024.1 enhance Accounting SuiteApps with transaction line distribution features. Introduction
- Journal Line Sublists Standardized for NetSuite 2026.1
With NetSuite 2026.1, journal line sublists are standardized to keyed configurations, allowing precise line updates and enhancing financial accuracy.
- Deployment Considerations for NFP SuiteApps in NetSuite
Understand the key deployment considerations for NFP SuiteApps to ensure successful installation and updates.
- Automatic Approval for Reclassification Journal Entries
NetSuite now automates the approval process for reclassification journal entries, enhancing efficiency and preventing duplicates.
