QBO App First Look: A2X for Amazon

by

A2X makes it easy for you to accurately account for your Amazon marketplace sales.  You will find A2X for Amazon in the Intuit App Center (A2X IAC webpage) and you can sign-up for it by following the Learn More link which takes you to the A2X website.

One thing that seemed odd to me was that they do not offer the ability to sign-up using your Intuit log-in, you must first sign-up from the A2X website using Google.  Even though they say there is a path to sign-up using your own email, when you attempt to do this it takes you to instructions to ‘set-up a Google login’.

After you have a Google account you can connect to Amazon’s One Marketplace, and then after your A2X is connected to Amazon, you can connect to QuickBooks Online.  That process follows the standard ‘OAuth’ methodology Intuit uses for allowing any 3rd-party App to connect to a QBO account.

After connecting QuickBooks Online with A2X you will be redirected back to the A2X Connections ‘settings’ window in which you configure the specifics of how your data will flow from Amazon-to-A2X-to-QBO.  This includes the bank account(s) into which the A2X postings of your Amazon transactions will occur.

A2X has the ability to configure exactly how each transaction type should be posted in terms of the accounts and taxes to be reported within your finances. A2X provides a convenient mapping methodology within their ‘Accounts & Taxes’ settings as part of the connection set-up.

You decide how you want your data summarized by A2X.  You can configure A2X to summarize your sales by product type, product SKU, by a group of sales, all sales together, or even sales by country if you are selling ‘all around the world.’

Once everything is set just the way that works best for you, A2X automatically imports your Amazon sales, fees, inventory and COGS into QuickBooks Online so that you can easily reconcile your payments received from Amazon with your bank and QuickBooks ledger.  Each time that Amazon creates a new settlement for your account,  A2X fetches it and then analyzes your data in order to generate a summary of your revenue, expenses and all related transactions.

A2X then gives you the details you need in the way you want them and displays each of your Amazon settlements so you can review each settlement before it is posted into QBO. 

This means you can easily insure that your sales, fees, reimbursements and adjustments are all properly being posted within your accounting because it’s easy to check out any one of the settlement transactions and all the details related to it.

Simply click the Review button on any settlement file to get started. Then click the Show Invoice Detail option to look at the specifics of the transaction you want to see.

When you are ready A2X uses journal entries to post your Amazon settlements to QBO, and each journal entry will match, to the penny, the amount paid by Amazon. If you look in the bank account you have associated with A2X for the posting of these entries will appear similar to the one shown below.

If you looked at a report of the journal entry details which A2X posted it would appear similar to the one shown below.

If you happen to have an Amazon settlement that crosses over a month-end into two months, then A2X will post two journal entries to QBO so that your monthly sales and expenses are recorded into the proper months in which they actually occurred. 

All in all this looks like a great App to give a 'once over' review of your own if you use Amazon and are attempting to insure that your Amazon transactions are properly reported within QuickBooks Online.

You can review the pricing options from either the A2X or Intuit App Center A2x webpage. For more information about A2X see their webpage.

By the way, A2X for Amazon has been named one of the ten finalists in the 2017 QuickBooks Connect App Showdown, so congratulations are obviously in order.