Share this content

Importing data to VT Transaction +

Is it possible to import customer data to VT Transaction + ?

Didn't find your answer?

I have a client who has decided to move from Sage to VT Transaction + (long overdue in my view but I might regret saying it).

I have extolled the virtues of the Universal Input Sheet for importing a trial balance and bank transactions from csv files, but I am, strangely, stumped when it comes to customer (and supplier) data. Is it possible to to use the input sheet for this, is there a workaround or will I have to tell them to input their 100+ accounts data from scratch? 

Replies (7)

Please login or register to join the discussion.

avatar
By andy.partridge
03rd Oct 2018 09:34

Any takers? I means givers.

Thanks (0)
avatar
By ohgoodgodno
03rd Oct 2018 09:51

why not ask VT support?

Thanks (0)
Replying to ohgoodgodno:
avatar
By andy.partridge
03rd Oct 2018 10:40

Fair point, but not really in the spirit. All technical tax questions, then, the answer is simply 'call Croner' or 'read the legislation'.

Edit. I've taken your advice. Life's too short.

Thanks (0)
By Moonbeam
03rd Oct 2018 11:11

Let us know the answer if you ever find out!

Thanks (0)
Replying to Moonbeam:
avatar
By andy.partridge
03rd Oct 2018 11:23

The answer is 'No', I'm afraid. Manual input required.

Thanks (0)
avatar
By duncanphilpstate
11th Mar 2021 18:25

Solution:
I know this is an old question but not only having found it but also having a solution, I thought I'd add to it.

You *can* use the Universal Input Sheet to import sales ledger transactions fro ma CSV file. First thing is, when you open CSV import dialog*, choose "General Options" rather than the default "Bank Statement Options". I think if the first column of the CSV is recognised as a VT transaction type ( eg SIN for sales invoices), the dialog will take a stab at identifying each CSV column with a VT data element. you can also (or and then) manually specify which column represents what.

Part of the less-documented trickery is to mark your customer account name or reference as the "Primary Account" in VT terms. And the name/code needs to be preceded by "Customer: " so that VT knows which "Ledger" they relate to.

You also need to specify the "Analysis account" - which in my case is simply "Income: Sales". Again, the prefix "Income: " points VT to the correct categorisation.

Next trick is that after you've aligned the CSV columns to VT fields, any customers that don't exist will be highlighted in blue on the Univ Input Sheet (UIS). you can right-click on these and tell VT to set them up for you, or (more rigorously perhaps) you could make a note of them, press Cancel and do that customer set up yourself before restarting the import process (bearing mind that the transaction file setup doesn't need to be done again).

FYI, I'm using this as a routine procedure because for complicated reasons my invoicing application doesn't have a decent sales ledger functionality built in and VT is providing this in a neat, uncomplicated way.

If anyone wants more info on how to prepare a CSV file from some other data source; how to extract data from a random system; and how to automate setting up the Customer accounts if you have too many to handle conveniently by keying in data, please contact me - that's my stock in trade so to speak. Either reply to this thread or use email: [email protected]

I hope that's useful.

* Edit, Import transactions..., Import from CSV file

Thanks (1)
Replying to duncanphilpstate:
avatar
By paulwakefield1
12th Mar 2021 09:05

Thank you. That is indeed useful for future reference.

Thanks (0)
Share this content