Space for pervasive banner when authenticated
Connect Amazon Seller Central to QuickBooks Online
Learn how to connect Amazon Seller Central to QuickBooks Online.
Connect Amazon Seller Central to automatically import sales transactions (such as sales, fees, sales tax, and shipping costs), refunds, and payouts into QuickBooks Online. This helps you reconcile your Amazon sales and expenses accurately and efficiently.
Prerequisites
Before you connect the Amazon Connector by QuickBooks app, make sure you have the following ready:
Your Amazon Seller Central user ID and password.
Permissions in Amazon Seller Central to install third-party apps.
Connect the app
Follow these steps to connect the Amazon Seller Central.
Select Integrations
, then Find integrations (Take me there).Search and select Amazon Marketplace Connector by Intuit, then select Get integration now.
Enter your Amazon Seller Central username and password, then select Login.
You'll be redirected to the Review your app settings page in QuickBooks. Review and complete the following app settings:
Add transactions automatically: Turn this on to automatically add high-confidence transactions (such as downloaded bank or credit card transactions) to your books. You’ll find them in the Categorized tab under Integration transactions.
Deposit account: The bank account where Amazon sends your payouts.
Payment account: This is the account (usually a credit card) used to pay any balance you owe to Amazon.
Note: You can change these later by selecting Settings in the Amazon tile.
Select Approve to authorize Amazon to send data to QuickBooks.
Select the date you want the app to start importing orders from. When you’re ready, select Done.
Note: Transactions import in batches and may take between 10 minutes to 3 hours, depending on the volume. You can import up to 12 months of transactions.After reviewing all settings on the Review your app settings page, select Sync now to finish the connection.
Once connected, select Go to Integration Transactions.
Note:
QuickBooks integration with Amazon Seller Central keeps buyers’ personal details private.
QuickBooks Online can’t import individual Amazon customer records. Instead, all Amazon transactions are linked to a single, generic Amazon customer profile, which you can update when reviewing transactions.
Track and match products
Track and match each Amazon product to a product you already have in QuickBooks.
Note: Turn on Product tracking in your Amazon settings to track products from your Amazon sales and refunds in QuickBooks Online.
If QuickBooks can't find matching products
How Amazon products match to QuickBooks products depends on how you set up your automatic product settings.
If Add products automatically is on: QuickBooks creates a new product automatically and maps the Amazon product to it.
Note: QuickBooks may not create a new product if it finds a partial match with an existing one. If you need to, you can create a new product in QuickBooks and map it to your Amazon product.If Add products automatically is off: QuickBooks uses a generic product for this transaction. You can map your Amazon product to an existing one in QuickBooks, or create a new product and map it.
Match Amazon products in bulk
Go to the Product tab to map multiple Amazon products to products in QuickBooks Online.
Go to the Unmatched tab to view any Amazon products from your transactions that need to be connected.
Select the correct QuickBooks product from the dropdown menu for each item, and then select Save.
Note: After you save, transactions in your For review tab will update with the right QuickBooks product. Review and add them to your books.
Use the app
Check and manage your Amazon sales under the Integration transactions tab. Transactions are organized into three tabs:
For review: You have imported transactions that need your review before they’re added to your books.
Confirm: Transactions with all the details are ready to be added. With auto-add, many will skip this step.
Review: Transactions missing details like customer name, product name, or account mapping. Enter the missing info, then confirm the transaction.
Categorized: Your transactions have been imported and added to your QuickBooks books. You’ll see them in your reports.
Excluded: You manually excluded these imported transactions. They won’t show up in your books or reports, as the app doesn’t automatically exclude transactions.
Understand transaction types
Check each transaction type to understand where your money goes.
Payment Received: Each sales transaction, whether it’s a card, cash, or gift card, shows the payment type in the description. You’ll see details like fees, gross amount, shipping, discounts, taxes, and products or services.
Note: Select Review or the transaction row to view more info.Refund: Refund transactions are imported with details like amount, taxes, and products or services.
Payouts: Amazon sends payouts for sales every 14-calendar-days or sooner. They collect your sales, take out any fees or adjustments, and deposit the rest. Use these sections to track transactions statuses and adjustments:
Included transactions: See each sale in your payout and its status (For review, Categorized, or Excluded).
Funds in this payout: See the adjustments Amazon made. Some are mapped to accounts automatically, while others need you to select where they go.
Note: You can update how payouts are mapped at any time.
Reconcile Amazon transactions in QuickBooks
Follow these steps in order to reconcile Amazon transactions, and to avoid duplicate revenue.
Step 1. Review and confirm individual transactions:
Go to All apps
, then Accounting, then Integration transactions (Take me there).Select any transactions in the row and review them, and then select Confirm to add the transaction to your books.
For transactions marked as Review, add any missing details like customer or product, then select Confirm.
When a Payment received transaction is confirmed, QuickBooks creates a Sales Receipt (for sale details) and an Expense (for fees). Both are recorded in the undeposited funds or payments to deposit account.
Note: This account acts as a temporary holding account until the payout is processed.
Step 2. Review and add the payout:
Go to All apps
, then Accounting, then Integration transactions (Take me there).Check and make sure every transaction in the payout is marked as Categorized.
Review and make sure every adjustment line in the Funds in this payout section has an account selected.
Select Add or Confirm for the Payout transaction.
Note: QuickBooks moves your net payout from undeposited funds (or payments to deposit) into your bank account as a deposit. This deposit includes all the Sales Receipts and Expenses you confirmed in Step 1.
Note: Any changes from the Funds in this payout section show up at the bottom of the Deposit transaction.
Step 3. Match in bank transactions:
Important: If you don’t see a match, double-check steps 1 and 2 to make sure all transactions are entered correctly. Otherwise, reach out to support.
Go to All apps
, then Accounting, then Bank transactions (Take me there).QuickBooks will automatically match the bank deposit from Amazon with the deposit transaction you created in Step 2.
Important: Check or add transactions in the App transactions tab before you work with them in the Bank transactions feed.Select Match to reconcile the bank transaction.
Important: Avoid adding deposits manually in the bank feed, always use Match.
Contact Support
Contact Support in the Amazon app through:
Live Chat: Select the chat icon in the Amazon app tile on the Integration transactions tab.
Feedback: Select the Give Feedback option on the Integration transactions tab, and then select the Amazon app.
Disconnect the app
You can disconnect the Amazon app if you don’t need it anymore.
Go to Integrations, and select Explore integrations, and then select Manage integrations (Take me there).
Find the Amazon Seller Connector by QuickBooks card.
Select the more options icon
, and then select Disconnect.Select the reason you’re disconnecting from the Amazon app, and then select Disconnect.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
Call Sales: 1-800-365-9606
