eBay, Amazon, Shopify - Accounting Ltd Company

[Mirko]

Hello,

Thank you very much, I appreciate your help beacuse I am very worried about this problem.

I have an LTD company and I have my own accountant (which i do not want change).

In last days my E-commerce is upgrading so fast so I need to register my accounts on Amazon, eBay as a business, and I am going to use my LTD company.

Since I am selling many items each day (100+), I cannot send so many invoices to all of customers, but at the end of the month (or quarterly) I need to give some information to my accountant for the tax return (item sold, amount, vat amount, billing address of the client).

Where can i find this list report on my Ebay, Amazon(or Paypal) account?

Since I am using also my personal Shopify website do you suggest some tools (software) who can help me with this information?? As each month I can collect all invoices from these platform to be clean with accountancy.

I am looking for simple and economic solution since I own a startup.

Thank you

 

[lesliedocherty]

Hi,

You will need to keep a copy of the sales invoices generated for a number of years as part of your records, just print off a copy of all the Amazon invoices, do the same with Ebay.

Then i would split amazon into non EU & non EU invoices, tally them up weekly and enter it on your accounts as 1 weekly Amazon transaction Vatable and 1 Non-Vatable transaction, same for eBay, it can be that simple.

HMRC are only really interested in Billing address if you are sending outside of EU and not charging VAT, then you also need to keep all the proof of postage and such you get from Post office or Courier. Aslong as you are paying the correct level of vat, they are happy.

 

[Tradebox]

Hi Mirko

Tradebox provide accounts integration with Sage 50 for all of the channels you have mentioned. However, Sage 50 may not be a good fit for you at this time as you are a start up.

Tradebox have just launched a beta of our new software Tradebox One which can work independently of Sage, download your online orders, calculate VAT based on what you sell and where it is being shipped and provide you with the ability to generate and print invoices. The beta will also provide stock control, if required. Of course it also has optional integration with Sage and we are working on integration with Xero, albeit it sounds like Tradebox One can fulfil your needs without accounts integration, at the moment. The beta is completely free and when we launch (poss end of March 2017) there will be a free community edition. We are actively looking for beta testers; https://tradebox.zendesk.com/hc/en-gb/articles/217029206-Tradebox-One-Beta-Conditions-READ-THIS-FIRST-

Regards


Stephen

 

[antropy]

I am looking for simple and economic solution since I own a startup.

Have a look at Sage and Tradebox.

 

[lesliedocherty]

We have used Kashflow for 11 years now, used Sage before that, Kashflow always gets my recommendation

 

[Cathey]

Another option for you would be to look at Xero and Expandly.

Expandly would provide you with the capability to centrally manage all your online orders from across Ebay, Amazon and Shopify. Expandly would allow you to collate all these orders and automatically push them to Xero when shipped. You would find that there is very little for your accountant to do with regards to your orders.

Your Expandly account would cost you £25 a month and your Xero account £22 a month depending on which price plan you chose with them.

Expandly would give you a lot of additional benefits like being able to manage your online listings from a central location (write the listing once and push to Amazon and Ebay). You could centrally create picklists across your sales channels, bulk process your orders, and even connect to your shipping carrier (dependent on the carrier you use).

 

[MarekBober]

Which ERP is used by you accountant, some e-commerce solutions can generate EPP files or push the data trough API integration. Regarding automatic invoicing- I would suggest omnichannel profesional merchant solution with advanced warehouse management system. This will solve your issues and let you provide much better customer experience to your buyers. Some of them have automated payment synchronisations and since are offered in SaaS you can get them around GBP50 a month.

 

[Raw Rob]

just print off a copy of all the Amazon invoices

No need to physically print them all, you can store them electronically, although you must make sure they are securely backed up.

 

[MarekBober]

Well, it is common practice to have redundant backups. Invoices can be provided to customers by logging into their personal accounts within the store. For accounting purpose can be pushed trough API to ERP system. This is quite common functionality within professional merchant systems.