How To: Review Items Excluded from a VAT Return


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

  1. Start the VAT Return process as described in How To: Process a VAT Return.
  2. Select the Advanced radio button.
  3. Tick the Show All checkbox.
  4. Click Go.
  5. 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

  1. Start the VAT Return process as described in How To: Process a VAT Return.
  2. Select the Advanced radio button.
  3. Tick the Show All checkbox.
  4. Click Go.
  5. Highlight the excluded transactions you want to include.
    Tip: Press Ctrl + A to select all displayed transactions if required.
  6. Right-click and select:
    Include Selected Items
  7. The selected transactions will be reinstated and the purple highlighting will be removed.
  8. 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

  1. Start the VAT Return process as described in How To: Process a VAT Return.
  2. Select the Advanced radio button.
  3. Tick the Show All checkbox.
  4. Click Go.
  5. Right-click within the grid and select:
    Include Items By Date
  6. Enter the date or date range to be included.
  7. Click OK.
  8. Any matching excluded transactions will be reinstated and will no longer appear with a purple background.
  9. Continue processing the VAT Return as described in How To: Process a VAT Return.

Understanding the Colour Indicators

ColourMeaning
Standard grid colourTransaction will be included in the VAT Return
PurpleTransaction 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.


See Also


Did you find this article helpful?