Blogger
Share this content
0
4
10525

Linking Amazon sales to accounting software

We have a client who sells predominately via Amazon (although also through their own website). They want to be able to automate the process of getting information from the Amazon settlement reports and stock reports into their accounting system so that there is a rich source of management information in one place.

We are aware that we could

a) type it all in again, but with hundreds of sales a month, that's not attractive

b) just enter summary data from the settlement reports, but that doesn't keep accurate stock records or allow analysis of profit per item etc.

We can't seem to find a way to do better than this. With thousands of people selling on Amazon I can't believe that one of the accounting software providers hasn't jumped at the opportunity to offer some sort of link / automatic upload facility. The client (and we) are flexible as to which system they use, so any ideas very welcome - cloud software providers, please take up the challenge!

Thanks in advance

Replies

Please login or register to join the discussion.

avatar
30th Mar 2011 21:22

Xero

I'm not sure of the format of the data from Amazon but Xero has excellent import facilities from bank accounts and from PayPal.  It's even possible to set it up so that these feeds come in automatically.  If you can get the data from Amazon in CSV format, then it should be fairly simple to import manually

Most other online software, such as KashFlow, has the import facilities but not as far as I know the automated facility.

Having looked at half a dozen alternatives, nearly all of which were OK, I decided that Xero had most to offer and after 12 months of using it myself and with clients I'm more than happy with the choice

Thanks (0)
avatar
30th Mar 2011 23:40

Amazon orders into Sage Accounts

Tradebox Finance Manager www.tradebox.uk.com can automatically download order files from Amazon and process those orders directly into Sage 50, Sage 200 and Sage Instant Accounts giving both stock control and financials.

John 

Thanks (0)
avatar
31st Mar 2011 10:42

ERP system integration

To broaden out the scope a bit, several ERP system suppliers (including ourselves at PRIAM Software (www.priamsoftware.com)) offer full order processing and stock control systems with integrated financials that include a facility to upload Amazon order files and also send back the order status files that Amazon require. 

Thanks (0)
avatar
12th Jun 2014 12:51

Acknowledging the blog

 That is such a kind and nice way that a company with no hesitation has raised doubts to solve their client's problem. I appreciate that.

Thanks (0)