Catching Clouds is honored to be A2X’s first guest blogger. As an accounting firm specializing in ecommerce accounting, we have dozens of clients using A2X’s services and use it for all of our Amazon clients. We LOVE it.
Since we use this tool so much, A2X asked if we could give their readers some pointers on the process we use for setting up and mapping the exhaustive list of Amazon fees to Xero’s chart of accounts. We were happy to oblige.
Let’s start at the beginning and make sure the basics are taken care of:
1. Create your Xero account.
This should go without saying, but if you want the data to land in your Xero accounting file, you need to have the account set up and ready to receive information. Here are a couple of items you’ll want to check in your Xero Settings:
Foreign Currencies – make sure that if you have an Amazon store operating outside of your home country (i.e., for those of us in the United States, that would be Amazon.ca, Amazon.mx, Amazon.co.uk, and so on), you have set up your Xero file to manage foreign currencies. You’ll have to be on the highest level plan for Xero ($70/mo at the moment) for this functionality, but it’s worth every penny.
Make sure that you’ve set up all the currencies you’ll need for each country.
Tracking Categories – we recommend that you set up a tracking category in Xero called “Channel” and include an option for each sales channel on which you sell.
A2X invoices can be mapped to particular channels which will result in a Profit and Loss Statement that can be shown by channel. It’s awesome.
Chart of Accounts – this is literally the list of accounts your accounting file uses for classifying income, expenses, and so on. Most of it should be pretty standard regardless of the industry your business is in, but Amazon sellers should have a few other ones. Following are accounts we commonly use for our Amazon clients:
- Sales (revenue)The amounts that land here are the total amounts collected for the product sales. Pretty straightforward.
- Sales Discounts (revenue)Any promotions, sales, or other discounts that are run can be recorded to this account.
- Sales Returns (revenue)Products that are returned to Amazon are coded to this account.
Don’t be confused by the fact that it’s a “revenue” account. It’s really a total of refunds paid out. But it still belongs in the revenue section.
- Shipping Income (revenue)This is where we record income charged by Amazon for shipping as well as any chargebacks or holdbacks on shipping.
- Amazon Reserve Account (current asset)We use this account for any money that Amazon holds back and that will be disbursed at a later date.
We’ve had clients who have had their credit card compromised and their $39 monthly fee therefore rejected who subsequently had hundreds of thousands of dollars held up for an extra couple of weeks. Ugh. But yeah, we’d put that money in this account until it’s released by Amazon.
- Amazon Lending (current liability)Some clients will borrow funds from Amazon, and the repayments are automatically pulled from disbursements. Both the loans and the repayments would hit this account.
- FBA Inventory Reimbursement (revenue)It’s pretty darn common for Amazon to regularly lose or damage products, but Amazon takes responsibility and will provide reimbursement. This is where we report all the ins and outs related to that.
- Amazon Seller Fees – FBA (direct costs)This is where we put the vast majority of the fees our clients pay to Amazon for fulfillment of their orders.
- Amazon Seller Fees – Other (direct costs)This is where we put all the rest of the tons of Amazon seller fees.
Fees for Amazon providing tax collection services go here… NOT under sales tax liability.
- Seller Service Fees (expense)There is a regular monthly amount charged for the subscription use of Amazon’s services (something like $39 or $79 per month). Since this isn’t a fluctuating cost based on sales, we typically record this as a monthly overhead expense.
- Storage Fees (expense)The overhead cost of storage products at Amazon until sale are recorded to this account.
- Sales Tax Liability (current liability)Money collected for sales tax needs to be collected from the customers and later paid out to various government agencies. This account keeps track of those totals.
Again, pay attention to sales tax service fees… those are actually Amazon Seller Fees and don’t belong here.
Ok, so now that your Xero file is ready to go, let’s move on to A2X.
2. Create your A2X account.
A2X is nice enough to provide us with a step-by-step guide, so just sign up and follow that process.
3. Request Amazon Settlement Statement Reports (in Amazon Seller Central)
Now we’re getting Amazon’s data ready to be pulled in by A2X.
Just log into your Amazon Seller Central account and go to Reports / Payments / All Statements.
Take a look at the Actions column on the right, and if you see buttons that say “Download Flat File V2” for all of the batches you want to import, you’re done and good to go.
However, if you don’t see that button, click on the Request Report button instead.
Make sure to repeat this for all batches on all pages.
Give the system 5 – 15 minutes to change status to the Download Flat File V2 button. Proceed when it’s done.
4. Complete the A2X Setup
Now it’s time to complete the setup in A2X.
Request Amazon History in A2X – log into A2X and going to Settings / History and clicking on Request More History.
Settings / Account Settings
Go ahead and change the name on the account. This is particularly important if you have multiple Amazon accounts (i.e., Acme Co vs. Acme Co – UK vs Acme Co – CA).
Settings / Connections
Refresh everything by clicking the Xero Cache button. This is make sure that everything is updated and ready to go.
Invoice Settings – specifies tracking code mapping
Go to Settings / Invoice Settings and set a different tracking code for each marketplace.
Accounts & Taxes – specifies accounting code mapping
Now it’s time to get down to business. This is where things get real, and we tell A2X exactly how we want everything to be reported in Xero. Basically, we’re just matching up Amazon data to the accounts we have in Xero. “A2X” if you will.
Important Note: You do NOT have to map every single fee to a separate line item in your Chart of Accounts. In fact, that methodology is pretty horrible. Only group the fees that you really care about and are useful to you in managing your business.
When you first go to the Accounts and Taxes screen, most everything should be blank.
You just need to go through all of the accounts and tell the system where you want the data to end up in Xero as well as the related tax code.
Click on the + on the right side to expand the list of accounts to map.
Following is an example of how we do it, but again, review the transaction types and map them to the account codes that make the most sense for how your manage your business.
|A2X Transaction Type||Xero Account||Tax|
|Adjustments||Amazon Seller Fees||Tax on Sales (0%)|
|Amazon Delivery and Transport||Amazon Seller Fees – FBA||Tax on Sales (0%)|
|Commissions and Selling Fees||Amazon Seller Fees||Tax on Sales (0%)|
|Fulfillment and Warehousing||Amazon Seller Fees – FBA and/or Storage Fees||Tax on Sales (0%)|
|Lending||Amazon Lending||Tax on Sales (0%)|
|Other||Amazon Seller Fees||Tax on Sales (0%)|
|Promotions||Sales Discounts||Tax on Sales (0%)|
|Refund and Return Fees||Amazon Seller Fees and/or Amazon Seller Fees – FBA||Tax on Sales (0%)|
|Reimbursements||FBA Inventory Reimbursement||Tax on Sales (0%)|
|Sales||Sales and/or Sales Returns||Tax on Sales (0%)|
|Shipping||Shipping Income and/or Sales Tax Liability||Tax on Sales (0%)|
|Subscription and Service Fees||Amazon Seller Fees and/or Seller Service Fees||Tax on Sales (0%)|
|Tax||Sales Tax Liability (actual tax) and Amazon Seller Fees (service fees)||Tax on Sales (0%)|
Transfer Invoices to Xero
Once you’ve completed the setup, you are ready to push the invoices over to Xero. Just go to the Settlements screen and click the “Send to Xero” button for each settlement statement you want to push into Xero.
If you want all invoices to automatically push to Xero when the batch settles going forward, you can go to Settings / Auto Invoicing and select the Auto-Posting Invoices button.
And that’s all there is to it!