Please enable JavaScript to view this site.

VT Transaction+

Navigation: Universal Input Sheet

Examples using the Universal Input Sheet

Scroll Prev Top Next More

The screenshots in this topic should provide you with enough information to be able to enter transactions on the UIS. If you require further details of what data goes where on the UIS, please refer to Data format of the Universal Input Sheet.

Non-journal type transactions

i.e. PAY, CHQ, REC, SIN, SCR, PIN, PCR, PCV and CCV:

UIS_example

Screenshot of the layout of some non-journal type transactions in the Universal Input Sheet

(Note: if you are entering journal type transactions, the layout is different, as shown here)

Transaction 1: PIN transaction for a supplier invoice no. 12345 from Widgets Ltd. for £100.00 net, £20.00 VAT, £120.00 gross, for repairs and maintenance expenses.

Transaction 2: SIN transaction for a customer invoice no. 4567 to Springsteen Ltd. for IT services of £500.00 net, £100.00 VAT, £600.00 gross.

Transaction 3: PAY transaction for payment of the supplier invoice above from the current account, of £120.00.

Transaction 4: PAY transaction for a cash purchase of printer cartridges from The Paper Shop for £60.00 net, £12.00 VAT, £72.00 gross.

Transaction 5: REC transaction for receipt of payment of the customer invoice above, of £600.00.

Transaction 6: REC transaction for a cash sale to A Jones for IT services for £100.00 net, £20.00 VAT, £120.00 gross.

Split analysis

Entries with more than one analysis account, i.e. a split analysis, are entered in the same way as above except that data in the Analysis and Analysis account fields are split into subsequent rows. The subsequent rows should only contain data in the Analysis, Analysis account and Entry details (and Transaction notes if required) fields.

UIS Split

Screenshot of the layout of a PIN entry with split analysis

Entries with departments

If you have set up departments, you can analyse a transaction to a department in the Analysis account field by appending the department name to the account name with a colon ':'. For example, the Stationery and printing account, analysed to the Finance department would appear in the format: Expenses: Stationery and printing: Finance:

dep

Journal type transactions

i.e. JRN, RJN, WOF, WBK

UIS_example2

Screenshot of the layout of a journal type transaction in the Universal Input Sheet

The transaction used in the example is as follows:

Transaction 1: JRN transaction for depreciation of equipment of £333.33. and buildings of £20,000.00.