How To: Exclude items on a VAT return

Table Of Contents

Introduction
Steps
Notes
Steps
Notes
Steps
Steps

Introduction

Excluding items from a VAT Return is an advanced feature that allows you to remove specific transactions from a VAT submission before it is processed and committed.
This can be useful if transactions have been entered incorrectly, require further review, or should not be included in the current return.
Important: Once a VAT Return has been committed, it cannot be amended. Make sure you fully understand the impact of excluding transactions before continuing.
You can exclude transactions:
  • Individually or in groups.
  • By a specific date or date range.
For an overview of VAT processing, see How To: Process a VAT Return.

Exclude Selected Items from a VAT Return

Use this method when you want to exclude one or more specific transactions.

Steps

  1. Start the VAT Return process as described in How To: Process a VAT Return.
  2. Highlight the transaction or transactions you want to exclude.
  3. Right-click and select:
    Exclude Selected Items
  1. The selected transactions will be removed from the current grid view and excluded from the VAT Return.
  2. Continue processing the VAT Return as described in How To: Process a VAT Return.

Notes

  • When using the Advanced option with Show All selected, excluded transactions are displayed with a purple background.
  • If you process EC transactions, remember to repeat the exclusion process in the EC Transactions grid if required.

Exclude Transactions by Date

Use this method when you need to exclude all transactions from a specific day or date range.

Steps

  1. Start the VAT Return process as described in How To: Process a VAT Return.
  2. Right-click within the transaction grid and select:
    Exclude Items by Date
  1. Enter the date or date range to exclude.
  2. Click OK.
  3. The matching transactions will be excluded and hidden from the grid.
  4. Continue processing the VAT Return as described in How To: Process a VAT Return.

Notes

  • When using the Advanced option with Show All selected, excluded transactions appear with a purple background.
  • If EC transactions are included in the return, remember to apply the same exclusions where necessary.

Viewing Excluded Transactions

If you need to review excluded transactions before committing the VAT Return, you can display them within the VAT grid.

Steps

  1. Select the Advanced radio button.
  2. Tick the Show All checkbox.
  3. Click Go.
  4. Excluded transactions will be displayed with a purple background.

Reinstating Excluded Transactions

If a transaction has been excluded in error, it can be included in the VAT Return again before the return is committed.

Steps

  1. Select the Advanced radio button.
  2. Tick the Show All checkbox.
  1. Click Go.
  2. Highlight the excluded transactions you want to include again.
    Tip: You can press Ctrl + A to select all displayed transactions.
  3. Right-click and select:
    Include Selected Items
  4. The selected transactions will be reinstated and included in the VAT Return.

Including or Excluding Transactions by Date

As well as selecting individual transactions, you can manage groups of transactions by date.
After switching to Advanced mode and selecting Show All, use the context menu options:
Exclude Items By Date
or
Include Items By Date
This allows you to quickly include or exclude transactions based on a specific date or date range.

Tips

  • Review excluded transactions carefully before committing your VAT Return.
  • Use Show All to verify exactly which transactions are included and excluded.
  • Excluded transactions remain available for future VAT Returns unless they are subsequently included and committed.
  • If EC transactions are part of the return, ensure exclusions are applied consistently across both grids.


See Also


Did you find this article helpful?