Journal

A journal lists all transactions. The data are retrieved from the cash/bank, sales and purchase day books.

In addition to the transaction amount, you can display the following amounts onto the form by using the Columns button:

Tip: To see the name as well as the creditor or debtor code, click the Columns button and drag 'Description' next to the 'Debtor' or 'Creditor' column header.

The journal allows you to check whether all entries made during a particular period have been included in the return, and to see the individual elements of the return. Different form settings are available for this purpose.

Add the following columns: VAT Return Code, VAT, VAT Description, VAT Return Category, VAT Basic Amount.
Grouping the details by VAT return code will show the lines included in the VAT return.
You can also filter or group by VAT return category.
Add totals or group totals to calculate the VAT basic amount and the VAT amount.
Save the view for future checks.

The form also allows you to perform the following checks:

You can check whether the correct VAT code has been used for turnover postings.
You can see the individual elements of the VAT return: use the filter row to make a selection of all lines that have the same VAT return code. Press CTRL+F5 to see the journal entries corresponding to a line.
Lastly, you can check whether any direct postings were made to VAT accounts.

Add the following columns: EC Sales List Code, VAT, VAT Return Category.
Grouping the details by EC Sales List code will show the lines included in the EC Sales List.
You can also filter or group by VAT return category.
Add totals or group totals to calculate the VAT basic amount and the VAT amount.
Save the view for future checks.

The form also allows you to perform the following checks:

You can check whether the correct VAT code has been used for the ECL deliveries and services.
You can also check whether the EC Sales List is consistent with the amount you have entered both in VAT Return Category 3B and in the journal.

Column	Description
Period	The period defined on the Fiscal Periods form.
Date	The date of the posting.
Account	The ledger account the amount was posted to.
Debtor	The debtor name or code.
Creditor	The creditor name or code.
Invoice/reference	The invoice code or the reference of the purchase or sales invoice.
Cost center	The ledger account the amount was posted to.
Transaction description	The name of the transaction.
Amount	The transaction amount for each account number. The amount is expressed in the company currency.