The VAT Reconciliation module allows users to accurately reconcile VAT transactions within a specific reporting period.
In this tutorial, you will learn how to use the VAT Reconciliation module. By following the step-by-step guide, you will gain the ability to reconcile VAT transactions, verify VAT amounts on sales and purchases, and identify discrepancies between your accounting records and VAT submissions. This guide will walk you through the process of preparing for VAT returns and reviewing VAT reports.
Navigation: Main Menu > Accounting > VAT Reconciliation.
Table of Contents
Click the New (button).
Select the Period Dates, if applicable.
Note: This step is only necessary when creating the first reconciliation. After the first reconciliation is created, the Period Dates will be selected automatically based on the VAT Reporting Frequency (Months) setting. If this is your first VAT Recon, you need to enter a Start Date, otherwise, the Start Date will automatically be set to the next day following the End Date of your last VAT Recon. The End Date will be set according to your VAT Reporting Frequency (Months) setting. You are able to override the Start and End Dates, for instance, to create two one-month VAT Reconciliations if your VAT Period is split over your financial year-end.
Select the Entity (if applicable).
Multi-select (Ctrl + A) transactions in the Outstanding (Transactions) section.
Click Add (button).
Click Done (button). The transaction is now read-only.
Once complete, Summaries are displayed on the left and the Transactions that are included in the Reconciliation are displayed on the right.
Double-click to open a Reconciliation.
Set the Reconciliation Status to Pending > Click Save (button).
Note: The Status can be changed back to Pending if the From Date is after the Accounting Close-off Date.
Add or remove Transactions.
Remove records by selecting a record in the Included (Transaction Items) grid view > Click Remove (button).
Add records by selecting a record in the Outstanding (Transactions) grid view > Click Add (button).
Once complete, click the Done (button). The transaction is now read-only.
Tick the Out-of-period checkbox above the Outstanding grid view.
Click on the transaction > Click Add (button).
Tick the Zero-VAT checkbox above the Outstanding grid view.
Click on the transaction > Click Add (button).
In the VAT Reconciliation, click Output (button).
Select Print / Preview / Email.
Select the relevant Document to Output.
Note: To output the Included grid view in Excel format, click on Menu (button) > Email Excel.
If you are upgrading from an earlier version and you already have many accounting transactions in your database, you need to create historical VAT Reconciliations for all the VAT Periods included in your database. This can be done by executing this Script (follow the instructions at the top of the script).