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.
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?
Are there any special considerations for creating SKUs manually when operating with multiple subsidiaries in NetSuite?
What precautions should I take to avoid errors when manually creating SKUs for Amazon charges in NetSuite?
How can I ensure that manually created SKUs do not conflict with existing items in NetSuite?
Was this article helpful?
More in Accounting
- Intelligent Close Manager Portlet in NetSuite
The Intelligent Close Manager portlet offers a centralized view for managing tasks and exceptions in NetSuite, enhancing close processes.
- Applied Trans Date and Period Enhancements in NetSuite 20...
Latest updates in NetSuite 2024.1 enhance Accounting SuiteApps with transaction line distribution features.
- Deployment Considerations for NFP SuiteApps in NetSuite
Understand key deployment considerations for NFP SuiteApps in NetSuite, ensuring a smooth installation and update process.
- Release Notes for Enhancements and Features in NetSuite
Explore the latest release notes highlighting enhancements and features in NetSuite, focusing on the areas of accounting, banking, and AI updates.
