Prepare for the VAT return

Set a cut-off date by which you must enter invoices relating to a VAT period/quarter. This allows time to analyse and process the VAT claim. After the cut-off date, set the VAT period/quarter to Manual so the system does not enter automatic transactions into the period/quarter while you analyse it. This topic describes how to achieve this and how to sense check your VAT data.

We have also produced a video to guide you through this process — go to Prepare for a VAT return (video).

  1. Select Maintenance, then select Accounts from the menu.
  2. Double-select to select the VAT ledger in the Select a ledger dialog.
  3. The Account Maintenance window opens labelled according to the selected ledger. Select the applicable VAT period, then select the Tax tab. select EDIT.
  4. Select Manual from the Status list to prevent any further automatic postings to this VAT period/quarter, then select SAVE.
  5. Next, you need to review the postings in the selected VAT period. select LINKS, then select Details from the Details panel.
  6. The Detail Enquiry window displays the transactions posted to the VAT period/quarter. Select CRITERIA.
  7. The Detail Enquiry Criteria dialog opens. Select the Periods tab, select Period Range, then select All from the Period Range list. select OK.

    This makes sure the Detail Enquiry window shows all documents that apply to the VAT period.
  8. To check the data makes sense, make sure the following columns appear. If required, right-select the column header then select the required columns
    Column NameDescription
    Document Type

    Displays the document type the VAT has been posted to.

    Number

    Displays the document number the VAT has been posted to.

    Nominal

    Displays the VAT input or output nominal the VAT has been posted to.

    Date

    Displays the tax date of the VAT.

    Period

    Displays the accounting period the VAT was posted to. You can post documents in different accounting periods to the same VAT period. This typically happens when invoices arrive later and you have already closed the accounting period. This does not cause any issues with the VAT return but may mean that your VAT period does not match your trial balance for the same accounting period.

    Account

    Displays the VAT period/quarter the document is posted to. This should be the same period across all documents on the Detail Enquiry dialog when checking the VAT return.

    Value

    Displays the VAT amount posted against the document. These values appears in the VAT to reclaim on purchases and all other inputs or VAT due this period on sales and other output boxes on the VAT return form.

    User Value

    Displays the Net value associated with the VAT document. If the tax type is set to X - Outside the scope, this is zero. A value should be present for all other standard tax types. These amounts appears in the Total value of purchases and all other inputs in this period or Total value of sales and all other outputs this period boxes on the VAT return form.

    Tax Type

    Displays the tax type set on the detail line of the document.

  9. Check that the relevant tax type and VAT amounts are correct. If required, you can use EDIT to make any required changes to the documents before reconciling with the VAT 100 report. For more information, refer to Editing and Reposting Documents.

Next steps

Reconcile a VAT period with a trial balance