How To: Review Items Excluded from a VAT Return
Table Of Contents
Introduction
Reviewing excluded VAT transactions is an advanced feature that allows you to check which transactions have been removed from a VAT Return before it is committed.
You can review excluded items, reinstate individual transactions, or include transactions by date if they need to be added back into the return.
Important: Once a VAT Return has been committed, it cannot be amended. Ensure you have reviewed all included and excluded transactions before processing the final return.
For information on excluding transactions, see How To: Exclude Items from a VAT Return.
Overview
During the VAT Return process, transactions can be excluded from the return either individually or by date.
Before committing the return, you can:
- View excluded transactions.
- Re-include selected transactions.
- Re-include transactions by date range.
Excluded transactions are displayed with a purple background when viewed in Advanced mode.
View Excluded Transactions
Use this option to review transactions that have been excluded from the current VAT Return.
Steps
- Start the VAT Return process as described in How To: Process a VAT Return.
- Select the Advanced radio button.
- Tick the Show All checkbox.
- Click Go.
- Excluded transactions will be displayed with a purple background.
Tip: Untick Show All to hide excluded transactions. This can make it easier to compare the grid totals with the values shown on the VAT Return.
Include Previously Excluded Transactions
Method 1: Include Selected Transactions
Use this method when you want to reinstate specific transactions.
Steps
- Start the VAT Return process as described in How To: Process a VAT Return.
- Select the Advanced radio button.
- Tick the Show All checkbox.
- Click Go.
- Highlight the excluded transactions you want to include.Tip: Press Ctrl + A to select all displayed transactions if required.
- Right-click and select:
Include Selected Items - The selected transactions will be reinstated and the purple highlighting will be removed.
- Continue processing the VAT Return as described in How To: Process a VAT Return.
Method 2: Include Transactions by Date
Use this option when you need to reinstate transactions from a specific date or date range.
Steps
- Start the VAT Return process as described in How To: Process a VAT Return.
- Select the Advanced radio button.
- Tick the Show All checkbox.
- Click Go.
- Right-click within the grid and select:
Include Items By Date - Enter the date or date range to be included.
- Click OK.
- Any matching excluded transactions will be reinstated and will no longer appear with a purple background.
- Continue processing the VAT Return as described in How To: Process a VAT Return.
Understanding the Colour Indicators
| Colour | Meaning |
|---|---|
| Standard grid colour | Transaction will be included in the VAT Return |
| Purple | Transaction has been excluded from the VAT Return |
Tips
- Always review excluded transactions before committing a VAT Return.
- Use Show All to verify exactly which transactions are included and excluded.
- Compare the transaction totals against the VAT Return values before committing.
- If EC transactions are included in the return, remember to review excluded items in the EC Transactions grid as well.
Related Articles
See Also
- How To: Process a VAT return
- How To: Exclude Items from a VAT Return
- How To: Use the Advanced Processing Method for VAT Returns
- Accounts overview