Amazon Seller Central Integration for QuickBooks Desktop
Entriwise automates accounting, enables inventory tracking and offers per-product profitability for Amazon Seller Central sellers using QuickBooks Desktop. For both Amazon FBA and seller fulfilled orders.
- QuickBooks versions:
- Desktop Pro, Desktop Premier, Enterprise, Advanced Inventory
- Amazon stores:
- US, CA, MX, BR, UK, DE, FR, IT, ES, NL, SE, PL, JP, IN, AU, SG, AE, TR, SA
Import details Proper accounting without journal entries
Entriwise imports everything, including sales, refunds, and fees, as proper accounting documents. Schedule imports hourly, daily or initiate them manually - all transactions will be imported as correct and fully itemized documents.
- ✔ Fully itemized imports
- ✔ Individual or grouped by day
- ✔ Daily or hourly scheduling
Item mapping Itemized mapping to record all income and expenses
Handle all expenses associated with Amazon FBA and seller fulfilled orders and refunds, including commissions, refund & return fees. Process non-order fees and charges, such as storage & fulfillment fees, advertising charges and chargebacks, reimbursements, balance adjustments, etc.
- ✔ Fully itemized imports
- ✔ Grouping by day
- ✔ Daily or hourly scheduling
Advanced tracking Advanced accounting with classes
Use advanced features of QuickBooks Desktop such as classes to classify Amazon FBA and seller fulfilled sales by fulfillment method, marketplace and country
- ✔ Income and expense tracking by class
- ✔ Tracking by marketplace / country and fulfillment method
- ✔ Per document classes and locations, per line classes
Inventory mapping Mapping Amazon SKUs to inventory products to enable inventory tracking
Map every product / SKU sold on Amazon Seller Central to inventory items in QuickBooks Desktop / Enterprise to see quantity sold and refunded and corresponding COGS
- ✔ Auto-mapping by SKU
- ✔ Mapping by CSV file upload
- ✔ Manual mapping using Web UI
Advanced inventory Assemblies, bundles, many-to-1 mapping for advanced inventory integration
Use many-to-1 mapping, mapping to QuickBooks Desktop / Enterprise inventory assemblies and creation of complex bundles.
- ✔ Many-to-1 mapping to QuickBooks Desktop inventory
- ✔ Mapping to QuickBooks Desktop inventory assemblies
- ✔ Complex bundles with price allocation rules
Inventory sites Inventory sites for precise inventory tracking
Benefit from support for NetSuite Advanced Inventory using separate inventory sites for different fulfillment methods and marketplace / countries.
- ✔ Inventory sites per fulfillment method
- ✔ Inventory sites per Amazon marketplace / country
- ✔ Product specific inventory sites
Cost of goods sold Actual COGS to calculate your product profitability
To track your product profitability, start with cost of good sold (COGS) defined in one of the two ways
- ✔ Use actual COGS as reported by accounting / ERP software
- ✔ Define COGS manually for each product
ADDITIONAL COSTS Extra-COGS to record additional expenses
QuickBooks Desktop doesn't allow expenses like advertising to be tracked as per-product COGS. With Entriwise you can factor in various expenses as COGS to per product profitability calculations.
- ✔ Fixed extra COGS in your marketplace currency
- ✔ Extra COGS as percentage of actual COGS, fees or total sales
SALES FEES Marketplace and processing fees as final cost component
QuickBooks Desktop cannot allocate your marketplace and processing fees to each product sold. With Entriwise you will be able to see your true marketplace, fulfillment and processing fees as costs of sales resulting in correct product profit and margin analytics.
- ✔ Amazon service fees & commissions
- ✔ Amazon fulfillment fees & shipping cost
- ✔ Amazon advertising expenses
Your numbers will be reconciled to the penny!
Our unique automatic reconciliation algorithm guarantees 100% correct imports. Whether you process 1,000 or 1,000,000 orders per month, Entriwise imports will reconcile to the penny.
Looking for something else? Talk to our in-house CPA and advisors
professionals who understand the e-commerce needs.
Together we will find a solution that works exactly for your company, allows up and running quickly, with less disruption to your business.