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 (4)
Please login or register to join the discussion.
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
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
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.
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.