Try as I might and, even though I thought I knew VT reasonably well, I cannot work out how to enter a journal using the VT Universal Input Sheet. I just get error messages such as "A journal should consist of two or more rows" and not completing certain columns. Please can someone give me an idiot's guide or a screenshot.
Replies (14)
Please login or register to join the discussion.
Why do you want to do this instead of just posting as a journal?
I assume if the data you import has all the fields completed you can import anything but you will need to choose the account where the transactions are being booked as one side of the entry and the other side to the analysis account.
The easiest way to enter a TB is using the Trial Balance Style Journal function
There is also an import Journal dialog which I have not used
I am not sure how o insert a screen shot here - but To display the trial balance style journal dialog, choose the Transaction>Journal>Trial Balance Style command, or
click on the down arrow to the right of the JRN button on the main toolbar.
mainly because I have a very long TB from another system that I would rather not type in.
You don't have to type journals into VTT+. You can paste them from the clipboard by selecting: Transaction>Journal>Import and then select "Clipboard (eg copied from a spreadsheet)" in the "Import via:" box.
Similar to you I have been using VTT+ for years. Just recently I 'discovered' and actually started using the Journal import feature (to do a weekly import from a spreadsheet in my case).
Once you have got your mind around how it works and set it up it is yet another case of how amazingly powerful VTT+ is.
I agree. Universal the Input Sheet may be, but it's a lot easier to enter it as a journal.
I don't like the UIS - I'd rather enter all the receipts together, then all the payments. But that's just my preference.
I am sure it can be done. Choose Opening Balances Contra as the account where you want to post it all.
I've had a lot of trouble with this, I needed it to post a long set of data that i had on an excel sheet. The error message doesn't seem to explain, however plausible it seems.
Try this:
On the first line, in the first column under type, put JRN, then enter the date under the date column. Leave primary account, details, total, and vat columns all blank.
Still on line 1, enter an amount in the analysis column, put an account in the analysis account column (eg Sales : sales) and enter relevant details in the last column.
Then on line 2 onwards, fill in just the analysis amount, analysis account, and details columns . This should work provided your amounts column sums to zero!
Good luck
The easiest way to enter a TB is using the Trial Balance Style Journal function
There is also an import Journal dialog which I have not used
I am not sure how to insert a screen shot here - but To display the trial balance style journal dialog, choose the Transaction>Journal>Trial Balance Style command, or
click on the down arrow to the right of the JRN button on the main toolbar.
A peruse of the user manual page 11 may also be of some help http://www.vtsoftware.co.uk/support/tranplusguide.pdf
I've tried to create a journal with the UIS but encountered the same problem.
I find if there's a long journal like a full TB to input, it's easiest to use the Journal Import function (drop down arrow next to JRN button).
In excel, copy to clipboard an area of exactly 4 columns ABCD where A is the source nominal code, B is the account narrative, C debit amount, D credit amount.
Then set 'import via' to clipboard, 'data format' to Journal and 'conversion table' to custom names.
Then click the converter button on the right. This window allows you to map the each of your lines to a VT account.
The mapping will be saved for future use, and if you name the codes (col A) the same as the VT account names e.g. "Creditors: Corporation tax", it'll automatically map.
Once all the lines are mapped, 'OK' the converter window and save the journal.
It sounds like a lengthy process but if it's a whole TB to copy over it's definitely quicker.
Thanks for this - I too have been trying to work out how to use the UIS for journals for years (on & off obviously). Now I know