QuickBooks HelpQuickBooksHelpIntuit

Integrate Amazon Marketplace into QuickBooks Online

by Intuit Updated 6 months ago

Learn how to set up Amazon Marketplace into QuickBooks Online.

Set up your QuickBooks Connector integration between Amazon Marketplace and QuickBooks Online within minutes using our simple setup process. Below is a step-by-step guide, highlighting some useful key points throughout the process.

Connect your apps

Begin by connecting your apps to QuickBooks Connector. If you haven't already connected your apps, you can follow our guides to connect Amazon Marketplace and QuickBooks Online.

Begin with the setup 

The configuration process below will present you with various options regarding exactly how you want your Amazon Marketplace and QuickBooks Online integration to work. 

Note: You'll need to have some basic accounting knowledge to make sure that the integration settings are tailored to your business and accounting practices.

  1. You will be required to set up your syncing options before you can start configuring your workflows. You'll need to set up the following:
    • Account Timezone
    • Integrations Starting Date
    • Email sync report options

      Amazon sync_3rd_All_Ext_102821.PNG
  2. You will be presented with workflows that are all optional. In this guide, these workflows will be selected to demonstrate the full capabilities of the setup process.
    • Sales from Amazon Marketplace will be sent to QuickBooks Online as an invoice.
    • Stock level updates from QuickBooks Online will be sent to Amazon Marketplace.

Create invoices workflow

When you select the When an Order is created in Amazon Marketplace, create a Sale in QuickBooks Online checkbox, you will be asked to:

  1. Set up the filters to determine which orders will be retrieved from Amazon Marketplace. You will need to set up the filters based on the order status.
  2. Determine the order number prefix to be used on your orders. The prefix you input here's added to all orders retrieved from your Amazon Marketplace account.
  3. You also have the option to select whether you want the sale to be created as a Sales Invoice or Sales Receipt to QuickBooks Online.
  4. Select the Advanced Options and set up the following:
    • Assign Sales to Class/Assign Sales to Location - These two options allow you to choose a default class or location within your QuickBooks Online system. This is an option unique to QuickBooks Online, and only if you have set up classes or locations within your QuickBooks company file.
    • Assign Sale to the - Most accounting systems require a customer record to be specified when a sales invoice is created. This particular option allows you to choose the nature of the customer record that is being created.

      The default option is Original Customer, however, if your Amazon Marketplace customers specify a company name and you prefer to have that appear within your accounting system instead, then you can opt for the Customer Organisation option.

      Alternatively, if you don't want any customer records to be created within your accounting system at all, you can select the Generic Online Sale Customer option. This means all sales will be synced to your Accounting system against a generic Amazon customer record.
    • Automatic Invoice Numbers - This option allows you to disregard the Amazon Marketplace order number completely, and use the sequential numbering convention within your accounting system.
    • Discount Product - Similar to the Shipping item option above, you can specify a dedicated discount Item so you can track your discounts on sales.
    • Rounding Off Product - Select the preferred product to be used when sending rounding discrepancies as a line item.
    • DueDate Offset - A due date type will be assigned if transactions don't have a due date. This is calculated using the transaction date, the Due Date Offset, and the type specified. If not set, the transaction date is used as the due date.
    • Allow Credit Card Payments - Select this option if you want to allow credit card payments for the transactions.
  5. You can also select how you want to match your Amazon Marketplace products with your QuickBooks Online products. You can match by either Name or SKU. In order for sales to properly integrate with your accounting system, you'll need to have all of your Amazon Marketplace items set up with unique SKUs. 

    Note: With QuickBooks Online integrations, we have two product matching options:
    • Name: We match the product's SKU field from Amazon Marketplace to the product's Name field in QuickBooks Online
    • SKU: We match the product's SKU field from Amazon Marketplace to the product's SKU field in QuickBooks Online
  6. Additionally, if you want your items from Amazon Marketplace to be created in QuickBooks Online, select the Create New Items in QuickBooks Online checkbox.

    In this section, you'll have to select the income and expense accounts to be used for your inventoried and non-inventoried items. Learn more about the integration of items.
  7. The Send Payments from Amazon Marketplace to QuickBooks Online settings will allow you to select whether you want payment data from Amazon Marketplace to be registered against your sales within QuickBooks Online.
  8. If you want to map different payment methods to different clearing accounts, this can be done once you select the Map Individual Payment Methods link.
  9. Select Save.

Turn on financial event

If you select the Financial Event workflow, you are allowing QuickBooks Connector to automatically create deposits within QuickBooks Online for the payouts sent to your account by Amazon Marketplace.

Amazon_Financial workflow_3rd_All_102921.PNG

Note: If you wish to turn on Financial Events to sync to QuickBooks Online, we recommend that you disable the Orders workflow above, which could double up your reported revenue if not set up correctly.

  1. You will be asked to fill in the Amazon Payments field. This is where we will record your Amazon Payouts as a Bank Transaction. The account to be used must be an Other Current Asset or a Bank account.
  2. In the Create a Deposit section, you will be asked to assign a Default Payment Method if you wish, for the unmapped payment methods to be diverted into the account selected here.
    • Use the Income Accounts Section. The income accounts to be selected here are where you will be able to map the different Payment Methods to specific clearing accounts.
    • Use the Expense Accounts Section. The expense accounts to be selected here are where we will map the fees, charges, and taxes part of the payout.
  3. Select Save.

Set up stock update

When you select the When Stock Levels are updated in QuickBooks Online, update stock levels in Amazon Marketplace checkbox, you will be asked to select how you want to match the items to QuickBooks Online items either by Name or SKU, then select Save.

This option should only be enabled if you have stock levels set up in QuickBooks Online prior to the integration. Otherwise, you will risk wiping out your Amazon Marketplace stock levels. Learn more about our Stock Control process.

Sync your account

Your account is now ready to sync your data across your apps. When auto-sync is on, your account should sync every hour, but you can trigger a manual sync at any time. Just select Sync Now on the Synchronisation Options on top of your Manage tab.

If you have any questions, reach out to our Support team at any time.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.