Amazon QuickBooks Desktop Integration

Amazon Seller Central to QuickBooks Desktop integration: automated accrual accounting, advanced inventory sites, assemblies and group items, detailed fee mapping, and per-SKU COGS for Amazon sellers using QuickBooks Desktop Enterprise.

Using QuickBooks Desktop? See Amazon → QuickBooks Online.

Back to: all integrations | Amazon integrations | QuickBooks Desktop integrations

QuickBooks versions:
Desktop Pro, Desktop Premier, Enterprise, Advanced Inventory
Amazon stores:
US, CA, MX, BR, UK, DE, FR, IT, ES, BE, NL, SE, PL, JP, IN, AU, SG, AE, EG, TR, SA

Import details Proper accounting without journal entries

Amazon QuickBooks Desktop integration: Entriwise implements accrual accounting, recording sales when orders are shipped. 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. Entriwise supports daily summaries with daily imports for efficient high-volume processing.
  • ✔ Sales receipts and invoices with line items
  • ✔ Single transaction or daily batch import
  • ✔ Daily summaries with daily imports
Available in plans: Professional , Enterprise

Item mapping Itemized mapping to record all income and expenses

Configure your QuickBooks Desktop chart of accounts to capture every Amazon transaction detail. Map Amazon's complex fee structure to specific QuickBooks items and maintain full audit trails for reconciliation with Amazon settlement reports.
  • ✔ Fee mapping to QuickBooks items
  • ✔ Flexible import timing and grouping options
Available in plans: Professional , Enterprise

Advanced tracking Class-based reporting for Amazon channel analytics

Organize Amazon transactions using QuickBooks Desktop's class tracking system. Separate FBA from merchant-fulfilled sales, track performance by marketplace, and use Customer:Job functionality to manage multiple brands—all within your existing QuickBooks reporting structure.
  • ✔ Class tracking for FBA and merchant-fulfilled
  • ✔ Separate classes per Amazon marketplace
  • ✔ Customer:Job tracking for multi-brand sellers
Available in plans: Professional , Enterprise

Inventory mapping Link Amazon SKUs to QuickBooks Desktop inventory items

Map every Amazon SKU to inventory items in QuickBooks Desktop Enterprise to see quantity sold, refunded, and corresponding COGS.
  • ✔ Match by SKU to QuickBooks item list
  • ✔ CSV upload for bulk inventory mapping
  • ✔ Interactive mapping interface with item lookup
Available in plans: Professional , Enterprise

Advanced inventory Assemblies, bundles, many-to-1 mapping for advanced inventory integration

Map Amazon multipacks and bundles to QuickBooks Desktop Enterprise inventory assemblies with flexible many-to-1 relationships.
  • ✔ Group items and assemblies for multipacks
  • ✔ Map bundle SKUs to assembly components
  • ✔ Flexible pricing distribution across bundle items
Available in plans: Professional , Enterprise

Inventory sites Inventory sites for precise inventory tracking

Utilize the Advanced Inventory module in QuickBooks Desktop Enterprise to replicate Amazon's logistics structure. Map specific Inventory Sites to handle FBA stock, inbound shipments, removal orders, and merchant-fulfilled inventory. This configuration provides exact visibility into where your stock resides and ensures accurate asset valuation across all fulfillment stages.
  • ✔ Sites for FBA, inbound, removal, and merchant-fulfilled
  • ✔ Marketplace-specific site segmentation
  • ✔ Real-time quantity on hand per site
Available in plans: Professional , Enterprise

Cost of goods sold Actual COGS to calculate your product profitability

Track actual item costs from QuickBooks Desktop's inventory records, including purchase costs, landed costs from bills, and assembly build costs. Entriwise matches each Amazon sale to the correct QuickBooks inventory valuation method (Average, FIFO) for precise per-product profitability reporting.
  • ✔ Import item costs from QuickBooks inventory
  • ✔ Set custom COGS per SKU for what-if analysis
Available in plans: Professional , Enterprise

ADDITIONAL COSTS Extra-COGS to record additional expenses

While QuickBooks Desktop tracks item costs effectively, it doesn't allocate indirect expenses like prep fees, labeling, or freight to individual products. Entriwise lets you add these costs to profitability calculations—either as fixed amounts per unit or percentages of item cost, total sales, or Amazon fees.
  • ✔ Add flat fees per unit sold
  • ✔ Apply percentage of item cost, sales, or Amazon fees
Available in plans: Professional , Enterprise

SALES FEES Marketplace and processing fees as final cost component

QuickBooks Desktop records Amazon fees as general expenses, not allocated to products. Entriwise breaks down referral fees, FBA fees, storage costs, and advertising spend to each SKU, showing you which products are truly profitable after all Amazon charges. Compare margins across your catalog to optimize your product mix.
  • ✔ Per-item Amazon commission tracking
  • ✔ FBA pick, pack, and storage fee attribution
  • ✔ Ad spend mapped to advertised products
Available in plans: Professional , Enterprise

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.

Entriwise app screenshot

Looking for something else? Talk to our in-house CPA and advisors

professionals who understand 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.