Summary
How to see a list of unreconciled VAT transactions.
Description
How to see a list of transactions that have not been included on a VAT return.
There are two ways you can check your unreconciled transactions, before you create your VAT return using the Audit trail report or from the VAT return.
- Check the report when you run your VAT return to see details of transactions dated in the previous VAT period but not included on your last VAT return.
- Export the Audit Trail report to see which transactions are not VAT reconciled (included on a VAT return) without having to create a new VAT return.
Resolution
From the VAT return
- Create the VAT return for your next period.
- When you have transactions dated in a previous VAT period, a message will show.
- Select the View Previous Transactions link. A PDF report opens in a new browser window.
Use the Audit trail report
This is useful if you want to check your transactions before running your next VAT return.
Run the Audit Trail report
- From Reporting, choose More then Audit Trail.
- Enter the Period you want to report on.
- To add a column to show whether transactions have been included on a VAT Return, click .
- Select VAT Reconciled and Save.
- Click Calculate. The report is updated and a new column is added to show whether transactions are on a VAT return.
Export the report
If you export the report as a CSV file, you can open it in Excel and sort and filter the data to show the transactions included or not included on a VAT return.
- Click Export and choose CSV.
TIP: The report is ready when a notification displays on the main navigation bar, to the left of Profile.
- Select the notification bell then Download to save a copy of the report to your device. You can then open this from your Downloads folder.
- Select the VAT reconciled column header row, and select Sort & Filter then Filter from the menu.
- To only see transactions not included on the VAT return, open the drop-down arrow on the VAT reconciled column and remove the tick from the Yes option, then select OK.
You will then be able to see all your non-VAT reconciled transactions.