VT Transaction Plus "Universal Input Sheet

VT Transaction Plus "Universal Input Sheet

Didn't find your answer?

Hi folks - I know VT have taken up half the screen with instructions on how to use this feature, but I am still totally confused? I thought it might be useful for importing bank statements in some way (like way Quicken and online packages can automate this for you) but I can't really understand how this might be actioned. VTT+ is a great package for the bookkeeper and shortens data entry time no end - but if I could get it set up to import clients bank statements and allocate automatically to the appropriate income, expense or supplier/customer account that would save even more time!

Any suggestions most gratefully received!

Tim.

Replies (11)

Please login or register to join the discussion.

avatar
By vtsoftware
04th Jul 2013 13:39

Import

There is no automatic bank feed in VTT+ like some of the on-line packages (and no monthly fee either).

You can import transactions into the universal input sheet from a csv file, a text file or from data copied from another application. So you need your bank transactions in one of those formats first. For instance, if you can display your bank transactions in a web browser, select them, right click and choose Copy.

Analysis accounts can be AutoCompleted based on the transaction details.

The instructions pane can be hidden once you have read it.

If you need more help, do contact our support department on 020 8995 1142.

Philip Hodgson
VT Software

Thanks (0)
avatar
By cparker87
04th Jul 2013 14:27

UI Sheet is great

Its only flaw is the inability to post in multi-currency.

Thanks (0)
Replying to JasonRodwell:
avatar
By RoyD
17th Jul 2013 14:05

Muliti Currency Support

This is a major headache for us - I have been told that this is unlikely to ever be supported but it represents a major problem for us...

Would be very intrested if anyone else has a similar problem - may consider using a product such as "Automate" to input transactions other than the base currency.

Thanks (0)
Replying to Montrose:
avatar
By cparker87
17th Jul 2013 14:40

RoyD

RoyD wrote:

This is a major headache for us - I have been told that this is unlikely to ever be supported but it represents a major problem for us...

Would be very intrested if anyone else has a similar problem - may consider using a product such as "Automate" to input transactions other than the base currency.

 

I must admit I resorted to similar. I use Automation Anywhere (which is quite costly) but I can guarantee it works.

Thanks (0)
avatar
By timiambeing
04th Jul 2013 22:49

Thanks Philip I will call support when I have a chance to try it out for real, I thought perhaps someone who had managed it might do a step-by-step tutorial for me! :0)

Thanks (0)
avatar
By chatman
17th Jul 2013 15:33

Not that tough
I think it is quite easy, except working out which is the primary account and what text ends up where in the resulting journal, but once you have a template set up you can forget about all that.

Thanks (0)
avatar
By vtsoftware
05th Jul 2013 06:02

Try a few dummy transactions

Try manually entering a few dummy payments or something and then it should be easy to see what is going on. The universal input sheet is a bit like a spreadsheet version of the Payments & Receipts input screen.

Importing is slightly more complicated as the import dialog gives you the ability to say which column in the imported data goes to which column on the universal input sheet.

Although you can do journals, they are a bit more fiddly as Chatman points out. The universal input sheet was really meant for payments, receipts and invoices (which are dead easy).

Remember too that you can manipulate data a bit like a spreadsheet; you select a range cells and do something to them - like AutoComplete the analysis account or calculate VAT.

Philip Hodgson
VT Software

 

Thanks (0)
avatar
By timiambeing
05th Jul 2013 08:30

Thanks everyone...
I'm going away for the weekend otherwise I would leap in and have a go today - sounds a lot easier than I thought! :0) I'm familiar with import routines in other software so basd on what everyone has said here it looks like a very useful time saving feature - now all I have to do is persuade my clients to furnish me with CSV downloaded bank statements. I only know of one bank that offers an accountant's login facility to statements, some clients are happy to provide me with login details but some accounts require PIN machines. Looking forward to giving it a try anyway :0)

Thanks (0)
Img
By MissAccounting
05th Jul 2013 13:55

Is it possible to copy data from a pdf bank statement to import via the Universal Input Sheet?  Ive had a quick go but it ended up all in one column.

Thanks (0)
avatar
By chatman
06th Jul 2013 07:24

pdf to csv
You can copy pdfs into an Excel spreadsheet but you need a pdf that is OCRd and you often have to play around with your cursor starting point in order to get your data in the right columns. I have done it but I wouldn't want to rely on it for getting my data.

Thanks (0)
avatar
By chatman
17th Jul 2013 17:40

Copying Bank Statements from pdf to Excel

@MissAccounting - When copying pdf bank statements to Excel you have to select the "Copy as table" option in Adobe Acrobat.

Thanks (0)