Do I Have to use SAGE???!!

Do I Have to use SAGE???!!

Didn't find your answer?

I have a client who runs an internet company and process over 500 invoice a month through their website.  They can download the information as a .csv file and so far I have only found the new SAGE release(which cost and customer service record put me off) that claims to upload all invoice data to individual customer accounts! (VT and Quickbook admit that they can only get half the way there - ie one journal for all sales (VT) or upload customer details but manually input all invoices (Quickbooks))

Any other solutions or experience of .csv uploads to SAGE out there?

I have tried the .csv upload on older sage versions and it isn't as easy as they make out

Replies (13)

Please login or register to join the discussion.

avatar
By User deleted
10th Sep 2009 13:02

What are you trying to acheive?

You don't say what you are trying to acheive eg is this to run a sales ledger, produce sales invoices manually, create new customers, or just import sales/vat info to nominal ledger.

Thanks (0)
avatar
By 3569787
03rd May 2016 19:28

If it's in the CSV ClearSEAs can do it!

Thanks (0)
avatar
By Fleur Firth
10th Sep 2009 21:08

Do I Have to use SAGE???!!

I am trying to create customer accounts, with sales ledger history by product code ideally, without having to key in vasts amounts of data each month.  From this data the client/I can run sales and product reports for management information.  We could just do a weekly sales journal with no customer identification and manipulate the customer sales elsewhere (eg excel) however, since they have only been trading 7 months and have reached significant volumes already I don't feel this to be a robust solution.  I am open to any ideas or suggestions!

Thanks (0)
avatar
By james_associates
11th Sep 2009 10:42

Do I Have to use SAGE???!!
Yes you can, procedure is the same for all versions of Sage as long as I can remember- file, import, audit trail transactions
Fields for the .csv file are in this order:
Transaction Type, Sales Account Ref, Nominal Code, Department Number, Transaction Date,Transaction (Invoice) Reference, Transaction Details, Net Amount, Tax Code, Tax Amount, Extra Reference, User Name,
Transaction type is SI for invoices and SC for credits, Sales Account ref must be exactly the Sage reference, Nominal is 4000 unless you put sales elsewhere, department number is 0 unless you have departments, date field is dd/mm/yyyy, inv ref is the invoice number, transaction details the text of the invoice, net and tax amounts are formatted NNNN.NN tax code is T1 for a VAT invoice. Extra ref and user name are both 0 or free text.

Take a backup before you start.

Thanks (0)
avatar
By 3569787
03rd May 2016 19:27

1 idea - Use XML e-mail automatically generated by the web site

Thanks (0)
avatar
By andyprentice
11th Sep 2009 11:29

VT does have some programming tools beyond the journal import facility - when I get time, I had been wondering about how to use and implement them.  I don't know but I would think Quickbooks will have some capacity for this via an add on (probably from USA) that may do the trick.

 

Anyone have any experience of either VT or Quickbooks in this regard?

Thanks (0)
avatar
By PeterGrimley
11th Sep 2009 11:29

using sage

As far as using sage, if the customer ref didn't already exist in sage then you may have to do two downloands into sage, one to create a new customer account, and a seperate one for the transactions. I know this as I import supplier and customer payments in csv format to sage from bank statement downloads, and if customer ref doesn't exist, audit trail transaction import fails. Hope this helps

Thanks (0)
avatar
By User deleted
11th Sep 2009 14:02

eSHOPCONNECT might be an answer

Lerryn Data Technology I know this company were talking about this facility for Sage and suggest you have a look at this product and perhaps speak with them.

http://www.pluginsforinterprise.com/plugins/eShopConnect/eShopConnect.asp?dh=-1

Wish you luck with this one.

Thanks (0)
avatar
By Fleur Firth
11th Sep 2009 20:24

Do I Have to use SAGE???!!

I checked directly with the technical teams at both VT and Quickbooks.  VT would import the sales as a journal but not to customer files and quickbooks can import the customer details but not the transaction information.  It will all depend finally on what the customer can live with verus what they want to pay for!  A decsion we all face daily!

Thanks (0)
avatar
By AngelTech
14th Sep 2009 10:39

Interprise Suite - www.interprise.co.uk has functionality in excess of Sage Line 50 and with its' excellent Transaction Broker plugin can process any files into its ledgers etc.

That said any decent system can import .csv files

do give me a ring if you would like more information

-- Keeping IT Simple

http://www.angeltech.it

[email protected]

Thanks (0)
avatar
By paul.k2
14th Sep 2009 13:16

I was going to say check Interprise

I was going to suggest Interprise, but I have been beaten to it.

I have integrated other products using the basic SAGE CSV facility, but it seems to be very limited.

When you consider the flexibility of a fully integrated system, and you put this along side the Interprise webshop that willl even allow you to run Credit Accounts, it might be worthwile reconsidering your approach.

 

Paul Kelly

www.kellysolutions.co.uk

 

Thanks (0)
avatar
By Fusion Accounts
29th Sep 2009 14:39

import

Hey,

Can I suggest that you send us a sample of the CSV file that your client is using.  We may well be able to import these into Fusion Accounts for you.

Kind Regards

Fusion Accounts

http://www.fusionaccounts.com

Thanks (0)
avatar
By User deleted
02nd Oct 2009 08:54

What Sage software are you using?

Hi

I might have missed it but I'm not sure what Sage software you're using. I know that Sage CRM or Sales Logix linked to Sage 200 or higher can do this automatically  as they link to your website but if you're using 50 accounts then you might struggle. If you are on 50 Accounts then I'd suggest you look at something larger to handle such a large amount of transactions. Lots of solutions out there.

 

Thanks (0)