Amazon QuickBooks Integration: Your Step-by-Step Setup Guide

Amazon QuickBooks Integration: Your Step-by-Step Setup Guide

As an Amazon seller, having access to apps and tools that streamline your business operations is crucial for achieving success. When it comes to cloud accounting, QuickBooks Online stands out as one of the top choices. It provides comprehensive accounting solutions for businesses, enabling you to effortlessly track revenue and sales, manage cash flow, and conduct month-end financial processes.

However, for QBO to be an asset for your ecommerce business, you first need to integrate it with your Amazon account so that all of your Amazon transactional data is correctly accounted for. Amazon sellers have three options for an Amazon QuickBooks integration:

  • Amazon and QuickBooks integration with an ecommerce accounting automation tool like A2X that will categorize and reconcile your payout data.
  • Integrate Amazon and QuickBooks with a data-syncing app that puts individual orders into your accounting software for manual categorization.
  • Manually enter data from Amazon reports into QuickBooks.

This guide will give you a total overview of all three methods for an Amazon QuickBooks integration. By the end of this article, you’ll have all the information you need to make an informed decision about whether doing it manually, using a data-syncing app, or a reconciliation-focused tool like A2X will best help with your Amazon accounting needs, including what will work best as the business grows.

Use the integration app recommended by specialist Amazon accountants

A2X auto-categorizes your Amazon sales, fees, taxes, and more into accurate summaries that reconcile perfectly in QuickBooks – saving you hours.

Try A2X today
Amazon and QuickBooks Integration – B (Question)

Amazon QuickBooks integration with ecommerce accounting automation tool, A2X

A2X works between Amazon and QuickBooks

A2X is an ecommerce accounting automation tool created for businesses using sales channels including Amazon, Shopify, eBay, Etsy, Walmart, and BigCommerce and cloud accounting software like QuickBooks, Xero, or Netsuite.

A2X serves as an Amazon and QuickBooks integration, automating and streamlining the accounting process for users of both platforms. It works by taking raw data from Amazon and organizing it all into neat summaries, which it then sends through to QuickBooks. The data A2X takes from Amazon matches perfectly to the lump sum settlements you receive in your bank from Amazon, so your settlements can be reconciled with just one click.

Watch this video for a quick overview of how A2X integrates Amazon Seller Central and QuickBooks Online:

A2X makes life much easier for Amazon sellers by creating accurate, accrual entries. Amazon’s two-week settlement schedule often crosses two months, which can make bookkeeping a nightmare. . For example, a settlement period might run June 25 - July 9. This means a seller receives a single payment for sales made in both June and July. The seller then needs to split that payment out to figure out what fees and sales occurred in June versus July so their books stay accurate. A2X splits the settlement data, eliminating the need for a business owner or accountant to do it manually.

The Amazon QuickBooks integration process with A2X is straightforward and takes only minutes. You can manually configure your Chart of Accounts, or you can automate this process by using A2X’s recommended settings. If you get stuck during the process, there are numerous resources available to help, including a comprehensive support center and a dedicated support team.

How to do a QuickBooks Amazon integration using A2X

  • Sign up for a free A2X trial: Start the process by getting a free trial of A2X for Amazon to QuickBooks.
  • Select Create an Account and enter your details.
    • There is the option for single sign-on (SSO) using your QuickBooks account or you can use Google to authenticate your email address and set up your A2X account. 
    • You will land on the A2X dashboard.
  • Connect to Amazon: There are two options for connecting to Amazon, depending on whether you have access to the Amazon Seller Central account or if you need to request access. If you are an accountant, bookkeeper, or third party managing this process on behalf of a seller, you can select the ‘I need to request access’ option. You will then be able to enter a name, email address, and marketplace, and an email will be sent prompting this person to connect their Amazon to A2X.  
    • When connecting, you will be prompted to select your primary region and marketplace. You will be prompted to select your primary Amazon marketplace. Keep in mind that by selecting a region, all marketplaces in that region will be covered by that one A2X connection. For example, if you selected the United Kingdom as your primary region, A2X would also fetch settlements from any European marketplaces you sell on, provided they are connected to the same Merchant ID. The marketplaces you sell on will determine how many A2X accounts you need.
  • Connect to QuickBooks: Click the QuickBooks logo and then the ‘Connect to QuickBooks’ button on the A2X dashboard. to.
    • Connect A2X to QuickBooks by logging into your QuickBooks account when prompted.
    • Now, A2X can sync with your chart of accounts. However, it will only do this once you’re ready. 
    • Within A2X, you can select which bank accounts you receive your Amazon deposits in. 
    • After connecting, A2X will return you to your dashboard.
  • Check the Connections screen in A2X to check both your accounts have been correctly linked to A2X.

With your QuickBooks and Amazon accounts connected to A2X, the first stage of the integration is complete. The following steps properly map your accounts and taxes so that A2X can categorize your Amazon data correctly and send it through to QuickBooks in neat summaries. This involves pulling your QuickBooks Chart of Accounts into A2X or creating new ones.

  • Map your accounts and taxes: This is the process of selecting which General Ledger account you want each transaction type to be posted to in QuickBooks, for example, sales to an Amazon Sales account. A2X can automate this whole process for you or you can map it yourself.
    • Start by clicking on ‘Setup Accounts and Taxes’. 
    • The first time you visit the accounts and taxes page, A2X will prompt you with a few questions about your business. Once you’ve answered these questions, you will be presented with two options, Assisted Setup or Custom Setup
      • Assisted setup: A2X will automatically apply best practice recommendations to your new A2X account for accurate ecommerce accounting. These recommendations include creating the Chart of Accounts in QBO and mapping the transactions to these accounts.
      • Custom setup: If you prefer to map your own transactions, you can choose your own accounts and taxes for each transaction type rather than an A2X generic default. To do this, click the down arrow next to a transaction type and find the account you want from your Chart of Accounts list.
    • Once you’ve finished the process or made any other changes, click the Save Mapping button at the bottom of the page.

Note: If you create new accounts in your QuickBooks after connecting A2X, you will need to refresh your cache by going to SettingsConnections.

  • Review and post: Before sending an entry to QuickBooks, you should review the entry in A2X by going to Settlements and clicking review. Use the dropdown to review all information that will be posted to QuickBooks.
    • You have control over when you send the entry, so only post when you’re ready, and don’t be worried about swamping your QuickBooks.
    • Auto-posting is available to you when you’re ready to use this
    • Your QuickBooks Journals can be found if you click into the search bar (this will show the most recent journal entries in QuickBooks). They should automatically appear as a match in the banking screen.
  • Reconcile 
    • In QuickBooks, on the right-hand side, go to Banking. You’ll see the journey entry sent by A2X in the For Review category. 
    • Next to the payout from your sales channel, in the Action column, will be the word match. The A2X entry will be there and match perfectly, Click match to reconcile in one click.

A2X Pros

A2X was developed to get transaction data from sales channels, such as Amazon, into cloud accounting software like QuickBooks. Over the years, A2X has kept up as Amazon implemented new features and practices, ensuring a seamless user experience.

Understands Amazon transaction types 
Amazon has many transaction types that could appear on your settlement statements and must be properly accounted for. With A2X’s long history working with Amazon sellers, it can easily detect and accurately classify these transactions. Once the correct transaction type is sorted into the proper category, it’s sent to QuickBooks to be reconciled with one click.

Reconciles without the need for clearing account 
A2X simplifies the reconciliation process by directly syncing with your bank account and QuickBooks, ensuring that everything balances to the last penny and negating the need for a clearing account. This not only saves you time but gives you confidence it’s accurate. 

Order details are attached to the entry
When doing your finances, it’s not necessary to bring in invoices for each individual sale. Doing this can swamp your accounting software, especially when your sales volume increases and you’re dealing with thousands of monthly invoices. Rather than bringing across each invoice, A2X saves your accounting software from this onslaught of data by attaching the order details to each entry so that you can still look up individual orders if you need to, and the bulky, unnecessary data doesn’t come with it.

Leaves no room for error 
Because A2X is an automation, there’s no potential for human error, which can often plague financials and make reconciling difficult. Instead, it will match perfectly to your Amazon statement the first time—and every time.

Customizable to what you need
A2X is customizable to help you dig deep into your numbers exactly how you need to. Using A2X, you can split your sales by SKU or product type if you need to. When setting up your A2X account, there’s no need to change anything if you’ve already mapped your chart of accounts. However, if you need help, A2X can take care of this for you, the choice is yours.

Ability to split out transactions
A2X can split out the taxed, not taxed, and tax-exclusive transactions, which is crucial for ensuring you don’t over or understate your income and remain tax compliant. This can be a fiddly manual process, but A2X does it automatically.

The best support team around
A2X is renowned for its knowledgeable and helpful support team, all of whom have experience in the bookkeeping and accounting space. The team is qualified and equipped to help users find a solution, and they never follow unhelpful or inflexible scripts. In addition, there’s also a support center with articles on completing an Amazon QuickBooks integration and a blog and ecommerce accounting hub where you can learn more about ecommerce accounting in general.

Inventory reports available
A2X also has a feature to automatically fetch month-end stocktake data from Amazon for FBA inventory and use uploaded cost data (from your Cost of Goods Sold cost file) to calculate an inventory valuation for the stock held by Amazon, keeping you up to date on your stock and its value.

A2X Challenges

Initial set up
As A2X is an ecommerce accounting tool, it’s able to do more for the users than standard data-syncing apps, but due to this it does require a little more set up time. Custom mapping is one area users find themselves spending more time on. That said, A2X also offers assisted setup to guide users through the process, and the support team is always available to help.

The good news is that once setup is complete, A2X can start automating, which saves you time and results in accurate books you can rely on.

Very detailed
If your bookkeeping has been less detail-rich in the past, the level of detail that A2X provides can seem overwhelming at first. That said, the detail is there to demonstrate the accuracy of your numbers, and it allows you to dig in and do a full analysis of how your business is performing. This is an area where an accounting professional could provide one-off or ongoing guidance on how to read and extract the most pertinent information that A2X provides. 

End of month close off 
Due to Amazon settlements occurring every two weeks, you may need to wait for your end of month close off. For example, if a settlement period started on November 30, it wouldn’t finish until December 14, delaying your November month-end close. That said, once the settlement period ends, you can complete your month-end close with total accuracy.

Start the integration process today by getting a free trial of A2X for Amazon now.

Integrate QuickBooks and Amazon with an order-syncing app

Amazon sellers can also use various data-syncing apps to integrate with QuickBooks, including QuickBooks Connector. These apps are designed to bring in transaction data from Amazon through to QuickBooks and may provide a simplified view of daily sales as a summarized invoice. You can find various app options on the QuickBooks app store.

These data-syncing apps are often sufficient for new or smaller businesses but might cause issues as a business expands, due to the sheer volume of sales data, which can bog down accounting software. Additionally, these apps are generally less customizable, may not work for international businesses, and likely won’t give the level of detail that growing businesses need for in-depth financial analysis.

How to integrate Amazon with QuickBooks using a data-syncing app

You can use a data-syncing app with Amazon and QuickBooks

The setup process for data-syncing apps is generally similar to A2X, first linking your Amazon account and then your QuickBooks account with your login credentials. The following steps will give you the general overview of what the setup process looks like, however this will differ depending on the app you choose.

  • Pick the data-syncing tool of your choice and create an account.
  • Connect Amazon: Select and connect Amazon as the platform that should send data to your data-syncing app.
  • Connect QuickBooks: Select and connect QuickBooks as the place where the data should be received. At this stage, double check that data won’t be automatically synced as soon as you connect QuickBooks. You should have everything set up properly before you switch on the app so you don’t create journal entries in QuickBooks that you later need to delete.
  • Choose what data the app should transfer: Configure the necessary syncing actions, e.g., making sure sales data is mapped to the right place in QuickBooks.
  • Test the action and turn it on: After everything is connected and you have chosen the action, test the action to ensure the data-syncing app is running as expected. These apps can have limited control of what data you sync. Bear this in mind before you start the app, as it can be hard to reverse once you’ve set it up. If everything looks good, turn it on and start automating the process of creating daily summaries in QuickBooks for new orders in Amazon.

Data-syncing app pros

Can be cheap or free
If you want an Amazon QuickBooks integration, and don’t want to pay a lot, a data-syncing app can be a practical solution as they often offer free or low-cost plans. This allows a new business to invest money elsewhere where it can help build a strong foundation for a business to grow.

All order details are in QuickBooks
Most of the data-syncing apps available will import invoices into QuickBooks, enabling you to look up an order within your accounting software, and without having to go to Amazon. For some sellers, this could be more convenient than going directly to Amazon or using an operations tool. 

However, in the long-term this could cause issues. As your sales volume increases and more invoices are brought over to QuickBooks, your account could get overwhelmed, causing your account to work very slowly.

Fast month-end close
Using a data-syncing app can allow you to close off your month-end sooner, as you won’t be waiting for the settlement period to finish. The trade off to this is that it can create inaccurate financials that may over or understate your income.

Suitable for smaller businesses
Using a data-syncing app is an adequate, cost-efficient solution for smaller, less complicated businesses who are not yet doing a large volume of transactions. However, as a business grows, you may need a more comprehensive solution that can handle large volumes of sales and give you deeper financial insights.

Data-syncing app challenges

May not cover all transaction types
As mentioned above, Amazon has a huge number of transaction types, including some that appear monthly and are not linked to specific orders. A data-syncing app is unlikely to pick up these less common transaction types, which can lead to frustration trying to get your entries to reconcile.

Limited tax functionality
These apps often have limited tax functionality, which can compromise the accuracy of your data during tax filing season. For instance, they may not accurately track the tax collected versus tax paid for Marketplace Facilitator Tax. And if they do offer tax functionality, it might be primarily focused on larger markets such as the USA, potentially complicating the process for international sellers.

Can be difficult to reconcile (depending on transaction cut-off)
These apps will have a set transaction cut-off time, which could be daily, hourly, or weekly. This can make it challenging to reconcile, depending on when the cut-off is, as it becomes complicated to match settlement payments to particular entries. This will result in you spending time trying to work out which entry applies to which payout, which is the exact opposite of why you integrated the app in the first place.

Can be limiting for expanding businesses
Apps like these are often limited to handling one country or tax rate, such as sales tax for the US. While this might be fine when your business is small and new, it will become an issue when you expand into new markets and have other tax considerations such as VAT in Europe or GST in Australia and Canada.

Clearing account difficulties
It’s common for these tools to use clearing accounts, which could leave a balance unaccounted for. If you find you have a clearing account that isn’t clearing, you would be forced to investigate where the money came from.

Potential to swamp QuickBooks with excess data
You don’t actually need to have individual sales data in your accounting software, rather just the numbers associated with it. If you use a data-syncing app that brings each individual invoice into your QuickBooks, you may find yourself having to sift through all the unimportant information to get the data you actually need. Not only is this frustrating but it can also impact the functionality of your accounting software when business picks up. If the app is bringing over 1000s of invoices, your QuickBooks will get bogged down with data and slow down. In fact, it’s not unheard of for business owners to abandon a clogged account to start fresh. 

Varying degrees of support
Depending on which app you’ve chosen, getting the help you need could be hard. Sometimes, you may find that the support team doesn’t quite comprehend the problem you’re facing. The support you receive might also hinge on the type of plan you’re on. In the end, if the support isn’t up to par, you could end up spending more time troubleshooting the app than actually benefiting from it. This defeats the whole purpose of having the app in the first place.

Manually enter data from Amazon reports into QuickBooks

You can download reports from Amazon and manually enter it into QuickBooks

After reading about using apps to integrate Amazon and QuickBooks, you might be wondering if there’s a way you can just do this process yourself, and there is. You can manually transfer the data from transaction reports in Amazon and enter it into QuickBooks. Depending on your sales volume, the manual option can require more time and effort from you, but that may be an acceptable tradeoff if you’re a new or small business looking to save money.

How to “integrate” Amazon with QuickBooks manually

  • Log into Amazon: After your Amazon settlement hits your bank account you can start the process by logging into Amazon Seller Central.
  • Download the Amazon Settlement Report: There are three reports that appear to be OK to use. However, only one of them is comprehensive enough to guarantee accurate accounting. Here we quickly summarize all of them and explain why the Settlement Report is best:
  1. The summary statement: Many sellers use this report because it’s what they see in Amazon, however it is not detailed enough to complete accurate accounting. For example, if you watch the video in the A2X section, you’ll see that A2X is accounting for numerous Amazon transaction types (refunds, returns, tax, adjustments, advertising, promotions, commissions, fulfillment and warehousing, discounts, reimbursements, shipping, etc). Not all of these transactions are included in the settlement report. The summary also won’t match the payment period you’ve been paid for. 
  2. A Date Range Report: This is more accurate for month-end totals, however, it still doesn’t tie back to what you’ve been paid. This means transactions will be missing and you may not be able to link the correct transactions to the right payout. 
    1. To download this report, go to your Amazon Seller Central dashboard, navigate to ReportsData Range Reports. Click Generate Report and click Download when it’s completed. Finally, select either summary or transaction, then pick what reporting range you want to see.
  3. The Amazon Settlement V2 file Report: This is the most accurate report, but it does contain lines and lines of data. This information is part of what A2X takes and organizes into summaries. While this report is very accurate, it contains so much data that it might cause lag problems when using a spreadsheet. 
    1. To download this report, go to your Amazon Seller Central dashboard, navigate to ReportsPayment. Select the report for the settlement amount you want to reconcile, click Print Statement, and export the report.

Note: The Amazon Settlement V2 file Report is the only report that matches what you’ve been paid. It’s important to use this document rather than the numbers in your Seller Central dashboard. 

Here is an example Settlement Report which shows a $24,041.65 deposit resulting from sales totaling $39,713.28 minus the Amazon deductions (various expenses and refunds).​​​​​

Amazon settlements

  • Consolidate the data from the report: Now that you’ve downloaded the report, you need to enter the data into QuickBooks. The aim is to get your records to match exactly what was deposited in your account. To get started, go to QuickBooks, find your deposit, and click Add details. Then you need to enter all accounts and the exact amounts to ensure the total exactly matches the deposit. This step can be difficult and requires care because it needs to balance to the penny.

Here’s an example of how the Settlement Report from above needs to be broken down into transaction types and carefully accounted for to ensure everything balances correctly:

Amazon with A2X

  • Create the entry in your QuickBooks
    • Open your QuickBooks account, click New in the top left corner and then select Journal Entry.
    • Open the files you’ve downloaded and begin the journal entry by mapping the data from the report to the corresponding accounts in your journal entry. If you still need to create a Chart of Accounts, do this before making a journal entry.
  • Review: Check the data mapping and make any adjustments before importing the data to QuickBooks.

Commonly cut corners with manual integration

If you’re manually inputting your Amazon data into QuickBooks there are a few common mistakes to be aware of and avoid for your own finances.

Not including tax because MFT covers it
Amazon is a Marketplace Facilitator, meaning it collects and remits your sales tax for nearly all US states as the Marketplace Facilitator Tax (MFT). Because Amazon takes responsibility for this, it can be tempting not to include it in your books. However, you are still responsible for ensuring the amount Amazon collects and remits is correct, so you must have it in your books. Please do so to avoid being over or understating your income, meaning you might pay too much in tax, taking money you could spend elsewhere, or not enough, leaving you with a bill.

Not covering all transaction types
Amazon has a lot of different transaction types and while some are hard to miss (as they’re attached to sales), others might only occur monthly, making them easy to miss or skip. If you miss a transaction type in a particular settlement period, your books won’t balance or will be incorrect if you account for the amount under the wrong transaction type.

Fudging the books
As we discussed above, while Amazon has several different reports that seem as though they could be used to do your finances, only the settlement report has the detail you need. When a seller uses data from Seller Central, there may be money they can’t account for. Faced with books that don’t balance, the additional funds are often allocated to an accounts receivable account under the assumption that the money will come from Amazon eventually. However, this causes inaccurate books because you have no record of knowing what the money actually is, and no plan if that balance increases over the months. Not to mention, there’s also the irregular transaction types to account for, such as those that occur monthly. All of this will compound and the books will only get more and more inaccurate.

But why should I care about this detail?
If you’ve been managing your books using the seller central summary and haven’t encountered issues thus far, you might be inclined to brush off the warnings in this article. But here are a few reasons you should place greater importance on keeping accurate books:

  • Tax is still your responsibility: Although Amazon collects and remits sales tax on your behalf, it’s still the seller’s responsibility to check the accuracy and make sure the correct amount has been remitted.
  • Business forecasting: your sales might increase, but if you aren’t properly tracking them, you don’t have visibility on your actual costs and may not be making as much profit as you could be. An estimated 29% of ecommerce businesses fail due to cost and pricing imbalances, with others failing when they try to scale too quickly. 
  • Tax deductions: you should do everything possible to reduce your tax burden. Make sure you claim your expenses!
  • For potential buyers or investors: By having accurate and tidy financials you’ll have the necessary information on hand if you ever want to sell your business. If you have a more relaxed approach to your books, you’ll need to tidy them before handing them over, which could result in a buyer walking away or offering a price lower than your business is worth.

Manual pros

It doesn’t cost anything
Unlike using a data-syncing app or A2X, this method doesn’t cost anything, aside from what you pay for your QuickBooks plan. The only other cost is the time you take to manually enter the data, which may or may not take a lot of time depending on how big your business is. So, if you’re a newer, smaller business, this is another reason the manual approach can be worth it.

You control what you post
As you’re not using an application to transfer the data to QuickBooks, you’re the one in control of what you do and don’t post to QuickBooks. As mentioned in the data-syncing app section, these apps can drag over unnecessary volumes of data that can clog up your QBO. You’ll be able to avoid this and only use the data necessary for your books. 

You can customize entries
Using this method also allows for full customization of entries to meet your specific needs. While this process may be time-consuming, the end result will be perfectly tailored entries that reflect your unique business requirements.

Manual challenges

A lot of data, including various transaction types
To emphasize again, Amazon has hundreds of transaction types that all need to be accounted for using the settlement report. Additionally, the terminology Amazon uses isn’t always intuitive, with names like ItemPrice, ItemFee, Commission, Chargeback, and OtherFee. Depending on your sales volume, you might find yourself bogged down in a lot of data that you need to comb through if you want accurate books. 

High risk of cutting corners
Coupled with all that data is the high risk that corners will be intentionally or unintentionally cut to get your books to balance. While the “close enough” approach might work short-term, it makes your books unreliable for financial purposes, including if you want to sell or get investment.

Amazon’s settlement schedule = month-end crossover
The different settlement and payment schedules are part of what can make ecommerce accounting so difficult. Amazon pays sellers every two weeks. If you have a lot of sales, this means there is a lot of data to process at one time. On top of that, because a settlement period runs for two weeks, it may have started in one month and ended in another, resulting in a month-end crossover. What this means is that you need to be meticulous about your tracking to ensure you account for the right sales in the correct month they were made.

Challenging if you sell on multiple marketplaces
As part of growing your business, you might also sell on other marketplaces. This expands your reach to new countries and continents. This means accounting for different taxes and currencies in your books. If you’re doing your books manually, this could become overwhelming really quickly and could require a lot more of your time than you have to give.

Tax is still your responsibility
Amazon may collect and remit your tax on your behalf, but it’s still up to you to ensure it’s tracked and accurate. This is why you need to have rock solid books that stand up to scrutiny and can be relied on during tax time.

Balancing the books is difficult
Working with bulk settlement payments, a large volume of sales data, and the various transaction types, getting your books to balance perfectly will be a challenge every month. It’s something that will only get harder as your business becomes more successful. Some sellers will resort to cutting corners to get the books to balance, which will cause more and more issues the more it happens.

Extremely time-consuming
As you’ve probably gleaned, manually entering data from Amazon reports into QuickBooks can take a lot of time. Moreover, it’s a task that requires your full attention and focus, which means carving out regular and dedicated time to sit and work through your finances.

As with any sort of data-entry, doing your Amazon bookkeeping manually makes it susceptible to errors. With so many numbers and various transaction types, including some that are very similar, it’s not hard to understand how mistakes can happen. And once a mistake is made, you then need to check and recheck your entries to try and find where the mistakes were made so your books have a chance of remaining accurate.

May not be reliable for tax and accounting
In order for your books to be reliable enough for tax and accounting purposes, you need to have 100% confidence in them. This means that once you’ve entered the data, you need to be completely certain you’ve accounted for all Amazon’s transaction types and checked and rechecked for any errors. If there is any inkling that the books may have errors then they shouldn’t be used for tax purposes. And if they are used, you might find yourself needing to employ a professional to redo them at a later date.

What about your COGS? 
If you’re handling the transfer of data from Amazon to QuickBooks yourself, you’ll also need to allocate time to manage your COGS, a task that some accounting automation tools, such as A2X, can handle for you.

QuickBooks Amazon integration FAQs

Does Amazon connect to QuickBooks?
Yes, you can connect your Amazon account to QuickBooks in three different ways:

  1. Using a specialized accounting automation like A2X
  2. Using downloaded Amazon reports and manually entering the data into QuickBooks
  3. Using a data-syncing tool. 

Read more on each of these methods above.

How do I link my Amazon FBA to QuickBooks?
If you’re an Amazon seller using QuickBooks as your accounting software, you can integrate the two using an accounting automation like A2X. Other options include using data-syncing apps, or manually entering data into QuickBooks from an Amazon report. Scroll to the top of this article to read more on all three options.

How do I set up QuickBooks for ecommerce?
To set up your QuickBooks accounting:

  1. Choose your QuickBooks plan 
  2. Connect your bank accounts
  3. Connect your A2X account to your QuickBooks. Once you receive Amazon settlements you can begin bringing in Amazon summaries to QuickBooks.

For more detailed instructions, scroll to the top of this article.

Does A2X work with QuickBooks Online?
Yes, A2X works with QuickBooks Online. There are many different plans available depending on how many Amazon shops you have, your order volume, and how many other channels you also sell on. Additionally, A2X can also be used with QuickBooks Desktop, Xero, and Netsuite.

How much is the A2X app?
Amazon sellers can try A2X for free with plans starting from $19 per month. A2X pricing differs depending on factors such as your order volume, how many marketplaces you sell on, if you need historical data, and whether you have FBA inventory locations.

How do I connect my A2X to QuickBooks?
Connect A2X to your QuickBooks account in four steps:

  1. Sign up for A2X and create your A2X account.
  2. Connect to Amazon by clicking Continue with Amazon.
  3. Connect to QuickBooks by clicking Connect to QuickBooks and logging in with your QBO account details.
  4. Check the Connections screen to make sure both are linked

For more detailed step-by-step instructions, scroll up to the “How to integrate Amazon with QuickBooks using A2X” section of this article.

Also on the blog

Use the integration app recommended by specialist Amazon accountants

A2X auto-categorizes your Amazon sales, fees, taxes, and more into accurate summaries that reconcile perfectly in QuickBooks – saving you hours.

Try A2X today
Amazon and QuickBooks Integration – B (Question)

Master your ecommerce accounting

Subscribe to receive a wealth of ecommerce accounting and bookkeeping insights, articles, and resources in your inbox.