Amazon Seller Connector by QuickBooks: Setup, Reconciliation and Limits

What is Amazon Seller Connector by QuickBooks?

Amazon Seller Connector by QuickBooks is an ecommerce accounting integration developed by Intuit for QuickBooks Online users with an Amazon Seller Central account. It moves Amazon financial activity into the Integration Transactions or App Transactions workspace, where users can review, categorize, confirm or exclude imported activity.

The connector is designed to explain how Amazon activity becomes the net amount paid into the seller's bank account. It imports the underlying sales, refunds, fees and adjustments, then creates a payout deposit that can be matched against the bank feed.

For the accounting system around the connector, including QuickBooks structure, COGS, tax and month-end reporting, use Thelonex's complete Amazon seller accounting guide.

Why does the connector have several names?

Intuit currently uses several labels for the same new-generation Amazon integration:

• Amazon Seller Connector by QuickBooks on app listings.
• Amazon Connector by QuickBooks in help documentation.
• Amazon Marketplace Connector by Intuit in installation and migration instructions.

These labels should be treated as product-name variations for the current Amazon Seller Central connector. They should not be confused with the separate Amazon Business Purchases app.

What does Amazon Seller Connector import?

The current connector imports the financial components needed to review Amazon activity and explain a payout. Depending on the transaction, imported details can include:

• Amazon sales and payment-received activity.
• Refunds and returned-order amounts.
• Amazon fees and line-level fee details.
• Shipping, discounts and tax amounts.
• Products, services, SKUs and item-level details.
• Payouts, reserves, adjustments and other fund movements.

Transaction review statuses

Imported activity is managed through three review states:

What the native connector does not do

It does not support QuickBooks Desktop

The native connector requires QuickBooks Online. Sellers using QuickBooks Desktop or Enterprise need another import method, a third-party connector that explicitly supports Desktop, or a planned migration to QuickBooks Online.

It does not provide two-way inventory synchronization

The app can match Amazon products to QuickBooks items by SKU and name. That allows imported sales to use the correct QuickBooks product or inventory item. Intuit's current documentation says the connector does not synchronize inventory quantities in both directions. Sellers may need to maintain inventory levels separately in Amazon and QuickBooks.

It cannot currently import orders as unpaid

The connector is not designed for an open-order, accounts-receivable or unpaid-invoice workflow. Intuit says the new ecommerce connectors cannot currently import orders as unpaid.

It does not create individual Amazon buyer records

Buyer phone numbers, email addresses and other personal information are not supplied to QuickBooks through this integration. Amazon transactions are therefore associated with a generic Amazon customer profile unless the user changes the customer during review.

It imports individual transactions rather than one settlement summary

The current connector imports individual transaction-level activity. This provides detail, but it can also create more records to review and maintain than a settlement-summary tool. This difference is central when comparing the native connector with A2X for QuickBooks.

Who should use Amazon Seller Connector by QuickBooks?

The native connector is usually a practical starting point when the seller:

• Already uses QuickBooks Online.
• Wants an included connector without a separate app subscription.
• Needs Amazon sales, refunds, fees, products and payouts in QuickBooks.
• Wants transaction-level detail and is prepared to review imported records.
• Does not require QuickBooks to update Amazon inventory quantities.
• Does not need Amazon orders imported as unpaid.

A specialist connector or different workflow deserves consideration when the seller:

• Uses QuickBooks Desktop.
• Prefers one compact settlement summary instead of individual transactions.
• Operates high transaction volumes that may make the QuickBooks file harder to review.
• Needs complex multichannel, multicurrency, VAT, GST/HST or inventory workflows.
• Requires a specific accounting output chosen by an ecommerce accountant.

Requirements before connecting Amazon

Intuit lists three basic prerequisites: a QuickBooks Online account, Amazon Seller Central login credentials and Seller Central permission to install third-party applications. A safe accounting implementation also requires several decisions before the first sync.

• Identify the bank account that receives Amazon payouts.
• Identify the payment account used when money is owed to Amazon.
• Record the final Amazon transaction already entered manually or through another connector.
• Record the final payout already reconciled.
• Review existing Amazon income, refund, fee, reserve, tax and clearing accounts.
• Review product names and SKUs in Amazon and QuickBooks.
• Decide whether automatic posting should remain off during initial testing.

Complete the QuickBooks setup for Amazon FBA sellers before importing data. The connector cannot correct a poorly structured chart of accounts after transactions have already been posted.

How to connect Amazon Seller Central to QuickBooks Online

1. Sign in to QuickBooks Online with permission to install and manage integrations.
2. Open Integrations and select the option to find integrations or apps.
3. Search for Amazon Marketplace Connector by Intuit. Product wording may differ by region, so confirm that the provider is Intuit and the connection is for Amazon Seller Central.
4. Select Get app now and continue to Amazon authorization.
5. Sign in to Amazon Seller Central and approve the requested connection.
6. Select the transaction start date. Use the day after the final Amazon activity already recorded through another method.
7. Select the deposit account that receives Amazon payouts.
8. Select the payment account used if Amazon charges the business rather than issuing a payout.
9. Choose whether to add high-confidence transactions automatically. Leave this off during the first test unless the existing mappings have already been verified.
10. Choose whether to enable product tracking. The connector will attempt to match products by SKU and name.
11. Review fee, reserve, adjustment and tax mappings.
12. Select Sync now and open Integration Transactions to monitor the import.

Intuit says the initial import can take from 10 minutes to three hours, depending on transaction volume. Transactions arrive in batches, so a partial first batch does not automatically mean the connection failed.

How Amazon activity becomes QuickBooks entries

The connector does not treat the bank deposit as gross revenue. It records the underlying Amazon activity first and then uses that activity to explain the payout.

When a sale is confirmed

Intuit states that QuickBooks creates a sales receipt for the sale details and an expense for the related fees. The entries remain connected to the payout workflow rather than being treated as an unexplained cash deposit.

When a payout is confirmed

QuickBooks creates a deposit that links the included sales, refunds, fees and adjustments. The resulting deposit is then available to match against the Amazon amount downloaded from the bank.

How to reconcile an Amazon payout in QuickBooks

Step 1: Review the component transactions

Open Integration Transactions and review every sale, refund and fee included in the payout. Complete missing product or account information and confirm that the required items reach Categorized status.

Step 2: Review and confirm the payout

Open the payout and verify that:

• Every included sale and refund is categorized.
• Fees and adjustments use the intended accounts.
• Reserves, gift cards, disputes and taxes are not left unmapped.
• The selected deposit account is the account that actually receives the funds.

Confirming the payout creates the connected QuickBooks deposit.

Step 3: Match the bank transaction

Open Bank Transactions, locate the Amazon deposit and match it to the deposit created by the connector. If no match appears, return to the payout and component transactions before creating anything manually.

This workflow is different from settlement-summary bookkeeping. Sellers using A2X should follow Thelonex's separate Amazon settlement reconciliation guide for A2X.

Worked Amazon payout example

The figures below are hypothetical and are used only to demonstrate the accounting logic.

Recording only the $730 deposit as revenue would hide $1,000 of gross sales, $100 of refunds and $150 of fees. Correct reconciliation preserves each component and explains how the business arrived at the net cash received.

Product tracking, inventory and COGS

When Product Tracking is enabled, the connector attempts to match Amazon products with existing QuickBooks products or services. Intuit says matching uses SKU and product-name information. Close matches appear for review, allowing the user to choose the correct item instead of automatically creating a duplicate.

Using a QuickBooks inventory item on a sales receipt can support quantity-on-hand and cost-of-goods-sold entries according to the item's QuickBooks configuration. However, three separate issues must not be confused:

For the complete cost process, including inventory purchases, landed cost and month-end adjustments, follow the guide to track Amazon FBA COGS in QuickBooks.

Sales tax, marketplace tax and Form 1099-K

Marketplace tax collection

Amazon explains that marketplace facilitator laws can make Amazon responsible for calculating, collecting, remitting and refunding supported marketplace taxes in applicable jurisdictions. Intuit states that the new connector automatically handles U.S. marketplace taxes through Sales Tax Payable and maps merchant-liable taxes to the relevant tax agency. Outside the United States, tax treatment generally depends on user-defined mappings.

The connector does not determine every registration, filing, sales-tax, GST/HST or VAT obligation. Review Thelonex's Amazon FBA sales tax guide and obtain jurisdiction-specific professional advice where required.

Form 1099-K

The IRS states that Form 1099-K reports gross payment activity and should be used with other records to determine and report the correct income. The gross amount is not reduced for fees, credits, refunds, shipping, cash equivalents or discounts. This is why Amazon gross sales, deductions, payouts and any information return must be reconciled rather than compared only with net bank deposits.

Migrating from the old Amazon connector, OneSaas or Commerce

Intuit rebuilt its ecommerce connectors and states that the new connections replace legacy OneSaas apps and Commerce connectors. Important changes include:

Safe migration checklist

1. Complete pending reviews and open reconciliations in the old connector.
2. Document the last imported transaction and last reconciled payout.
3. Record current product and account mappings.
4. Disconnect the legacy connector only after the cutoff is documented.
5. Choose a new start date that does not overlap.
6. Review the first import and re-establish any unmatched products.

Intuit says disconnecting the legacy app does not remove transactions already recorded in QuickBooks. Pending items may require separate review.

Common Amazon Seller Connector problems

Transactions appear to be missing

• Confirm that the transaction falls after the selected import start date.
• Allow for the documented sync interval of every few hours.
• Allow up to three hours for a large first import.
• Check For Review, Categorized and Excluded.
• Confirm that the intended Amazon marketplace and authorization are active.

The Amazon bank deposit will not match

• Confirm all included sales and refunds.
• Map every payout adjustment.
• Confirm the payout itself.
• Verify the selected deposit account.
• Check whether the bank deposit was already added manually.
• Review whether an included transaction was excluded.

Duplicate sales appeared

The most common preventable causes are an overlapping historical start date, running two connectors over the same period, manually recording the same Amazon activity and adding the net bank deposit as income after the underlying sales were posted.

If the existing QuickBooks file already contains months or years of unreconciled or duplicate Amazon entries, use Thelonex's professional ecommerce catch-up bookkeeping service before adding another data source.

A product does not match

Compare the Amazon SKU, QuickBooks SKU, product name, item type, currency and active status. Review whether the Amazon listing represents a bundle, parent-child variation or duplicate identifier.

The app was disconnected

Transactions already added to QuickBooks remain in the books. Disconnecting stops future synchronization but does not automatically reverse existing entries.

Amazon Seller Connector vs A2X vs manual entry

The right choice depends on the required accounting output. The native connector imports individual activity and provides a QuickBooks-controlled payout workflow. A2X is designed around summarized marketplace settlement accounting. Manual entry provides control but requires the user or bookkeeper to build and reconcile every entry consistently.

Decision table

For a detailed A2X workflow, read the complete A2X tutorial for QuickBooks. For a direct automation-versus-manual comparison, read A2X vs manual entry for Amazon bookkeeping.

Implementation and month-end checklists

Before the first sync

• Confirm that the app is the Intuit connector for Amazon Seller Central.
• Complete the ecommerce chart of accounts.
• Document the final historical transaction and payout already recorded.
• Select the correct bank deposit and payment accounts.
• Review fee, reserve, adjustment and tax accounts.
• Standardize major product SKUs.
• Leave auto-add off for the first controlled test.
• Process one complete payout from transaction review to bank match.

Every month

• Confirm that all expected Amazon activity has synchronized.
• Clear the For Review queue.
• Review excluded transactions.
• Confirm every completed payout.
• Match every Amazon bank deposit.
• Investigate unmatched deposits and negative payouts.
• Review Amazon fee, reserve and adjustment balances.
• Reconcile refunds and reimbursements.
• Review inventory and COGS.
• Compare QuickBooks revenue with Amazon reports.
• Review sales-tax, GST/HST or VAT mappings where applicable.
• Save payout and supporting reports for the close file.