Table of Contents
Introduction
The VAT Return Report helps you check and review VAT values based on your nominal ledger transactions for a selected period. It is typically used to make sure your VAT figures are correct before submitting a return to MTCA, or to review what has already been processed, particularly for audits and compliance checks.
You can run the report in two formats, depending on how much detail you need:
Summary reports are for a quick overview of VAT amounts per VAT code.
Detailed reports show each transaction so you can trace where the figures are coming from, typically grouped by VAT type (input or output) and code.
In the steps below, we’ll walk through how to run the report in Indigo Business and explain the available options.
Running the Report
To run the report:
Go to Nominal > Reporting > Nominal VAT Return Report.
The Nominal VAT Return Report page will open.
Set up the Report Options:
Choose to run a Summary or Detailed report in the Report dropdown.
In the Type dropdown, select whether to report on:
Current: VAT transactions not yet included in a processed VAT return.
Processed: VAT transactions already included in a processed VAT return.
In the Up until date field, enter the cut-off date for the VAT returns to include.
Use the checkboxes to:
Group By Nominal Accounts: report results are grouped by account.
Include Unallocated Payments: includes any received payments which is not allocated against any invoice or credit note yet.
Include Unprocessed Entries: includes transactions relating to the selected VAT Return period that were entered after the corresponding VAT Return was processed.
Filter and select the data you want to report on in the left grid, as needed.
Choose the report format and generate the report at the bottom right of the page.
⚠️ Important: User permissions and active system record filters influence the data displayed in the report selection grid and the resulting report. Excluded records may cause incomplete figures or unexpected totals.
The Result
The VAT Return Report can be generated in either PDF or Excel format, for both the Summary and Detailed versions.
Summary
After a successful run, a summary report will display the the following columns: VAT Code, Name, Amount, VAT Amount, Non Refundable VAT Amount, Refundable.
Excel
Detailed
Successfully generated detailed reports include the following columns: VAT Ref, Tran Date, NA Code, Name, Tran ID, BA Code, BA Name, VAT Return Ref, VAT Code, Tran Ref, Tran Extra Ref, D/C, Amount, VAT Amount, Non Refundable VAT Amount.
Excel
Related Articles