Importing data as a CSV file and comparison of Sage 50 and Xero
Please can I check some things out. This is for a client who is looking at Sage and Xero.
First a very basic question relating to Sage 50 - there is a monthly subscription version (I think) and a 'software licence bought' version. Am I right in saying this and if so, are both versions identical in functionality?
I appreciate there are different levels of Sage 50, but am uncertain about the cloud version.
Next part. The client has an online business and all the sales data is collected in the bespoke online software. The client's business involves managing online sales for customers, and our client charges are a mixture of standing charge and percentage of customer sales handled. At present the sales information is tranferred to Excel via a CSV file, and sales invoices are raised individually via Excel on a monthly basis, with a fair bit of copying and pasting of data within Excel.
The aim is to cut out Excel entirely and instead transfer the relevant data (in CSV format) directly to Sage, where the invoicing is carried out. Is this possible or is add on software required to do this? I had thought it was possible to import CSV data direct to Sage, but then I've noticed that there are quite a few Sage developers listed who provide applications to do this, so maybe it's not possible without an add on. If an add on is required is there a recommendation on which works best and which is the most cost effective please?
As more information, there are three basic sales service 'products' at the moment, and these would need separating in sales within Sage.
The next stage would be batch email invoicing directly from Sage. Presumably this is perfectly possible?
Final question is whether Sage 50 is the best product for this, or whether Xero could do the job equally well. Has anyone any observations on this point please?
That's it at the moment I think! Thanks very much in advance for any advice anyone can provide.