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.
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
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.
RoyD
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.
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.
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
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.
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.
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.