Amazon Seller Central Integration for QuickBooks Online

Entriwise automates accrual accounting, enables inventory tracking and provides product level profitability analytics for Amazon Seller Central sellers using QuickBooks Online. For both Amazon FBA and seller fulfilled orders.

QuickBooks versions:
Online Plus, Online Advanced
Amazon stores:
US, CA, MX, BR, UK, DE, FR, IT, ES, NL, SE, PL, JP, IN, AU, SG, AE, TR, SA

Import details Daily imports with inventory tracking

Entriwise provides daily summarized imports using accrual accounting and full inventory support.

It captures Amazon Seller Central sales, refunds, fees, adjustments, reimbursements, and more, importing them into QuickBooks Online as properly structured, fully itemized daily accounting documents.

Entriwise supports full Amazon inventory mapping, FBA inventory adjustments and returns, giving you daily accounting insights and SKU-level profitability across your catalog.

  • daily summarized imports
  • acrual accounting
  • inventory mapping*
  • FBA inventory adjustments
  • FBA returns

Item mapping Mapping for Amazon SKUs, charges, fees

Entriwise handles all expenses tied to Amazon FBA and seller fulfilled orders, including commissions and FBA fees, so your accounting stays complete and accurate. It also processes non-order charges such as storage and fulfillment fees, advertising costs, chargebacks, reimbursements, and balance adjustments. Use Entriwise’s auto-configuration or customize mappings manually to get a clear view of your true net income.
  • itemized accrual imports
  • Grouping by day
  • Daily or hourly scheduling

Advanced tracking Advanced accounting with classes

Use advanced features of QuickBooks Online such as classes and location 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
Available in plans: Lite , Standard , Professional

Inventory mapping Map Amazon SKUs to QuickBooks Online inventory products to enable inventory tracking

Map every product (SKU) you're selling on Amazon Seller Central to inventory items QuickBooks Online to see quantity sold and refunded and corresponding COGS
  • Auto-mapping by SKU
  • Mapping by CSV file upload
  • Manual mapping using Web UI
Available in plans: Standard , Professional

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

For sellers requiring advanced inventory mapping, Entriwise offers many-to-1 mapping to QuickBooks Online inventory products and creation of complex bundles
  • Many-to-1 mapping to QuickBooks Online inventory products
  • Complex bundles with price allocation rules
Available in plans: Professional

Inventory sites Inventory sites for precise inventory tracking

Benefit from support for QuickBooks 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
Available in plans: Professional

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 software
  • Define COGS manually for each product
Available in plans: Professional

Additional costs Extra-COGS to record additional expenses

QuickBooks Online 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
Available in plans: Professional

Sales fees Marketplace and processing fees as final cost component

QuickBooks Online 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
Available in plans: Professional

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
Background

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.