How to Filter Your VAT 100 Report

Filtering the VAT 100 report allows you to verify the balances and ensure accuracy in your VAT submissions. Follow these steps to filter and confirm your VAT report:

Steps to Filter the VAT Report

1. Access the Full VAT Report:

   • Navigate to the Full VAT Report in your Navigator system.

2. Filter by Transaction Type:

   • Locate the Type column in the report.
   • Apply a filter to display only the relevant types:
     • Input transactions (purchases and other inputs).
     • Output transactions (sales and other outputs).

3. Review the VAT Totals:

   • Calculate the total for the VAT column in the filtered view.
   • Cross-check the totals for both Input and Output VAT against the corresponding boxes on your VAT 100 form.

Key Points

• Box 1: Confirm Output VAT totals align with sales VAT reported.
• Box 4: Confirm Input VAT totals align with purchase VAT reported.
• Box 5: Net VAT payable or reclaimable can be calculated as the difference between the two.

Additional Tips

• Regularly verify these balances to ensure compliance and identify discrepancies early.
• Use export options to save the filtered data for record-keeping or further analysis.
• If discrepancies arise, investigate adjustments or manual entries that could affect the VAT totals.