How do I create a VAT report?

The VAT overview provides a summary of your revenue within a specific period and the associated VAT. Based on your account settings, this overview is generated based on invoice date (invoice based VAT system) or payment date (cash based VAT system). You can use the VAT overview to file your VAT returns. This article explains how to create a new VAT overview and how to close a VAT period.

Before you start

This is box title
You need permission to be able to create a VAT report. Permissions can be adjusted by practice administrators in General Settings > Role Management.

Step-by-step instructions

This is box title

Once you have closed the VAT period it is final and you cannot edit the invoices in the closed period anymore. You can only add and edit the payments of these invoices.

  1. Go to > Financial > VAT Overview.
  2. At the bottom of the list, click the button New VAT Period.
    This is box title
    Don’t worry, clicking this button will simply generate an overview, nothing is finalized yet.
  3. Select whether you are filing your VAT return monthly, quarterly, or annually by clicking the respective radio button.
  4. On the right-hand side, select the period (month or quarter) and the year using the drop-down menus.
    This is box title
    Note: All invoices up to the end of this period will be included in this VAT period.
  5. Click Show. Please wait until the “job progress” notification disappears and do not close the screen.
  6. You will now see the VAT overview of the selected period. The orange notification at the top will remind you that this is a temporary overview and has not been finalized yet.
    This is box title
    Note: if the VAT period that you want to close is still current (for example you want to close March but it is still the 31st of March) you can see the overview but do not close it yet as the month is not over yet.
  7. Verify the overview by clicking on Details on the right side of each line to see all individual invoice lines that make up the total amount.
    This is box title
    Note: If you did not close the previous VAT period, everything of the previous period will be included in the current period.
  8. The amount shown in bold, next to ‘difference’ is what you need to pay/receive.
  9. Once you are agree, click Book VAT And Close Period at the top.
    This is box title
    Clicking this button will finalize and close this VAT period.
  10. Wait until the “job progress” notification disappears.

The VAT period is now closed.

More about this

How can I see where the figures in the VAT overview come from?

  1. Go to > Financial > VAT Overview.
  2. Click on the VAT period you want to see the details for.
  3. Once the VAT overview is open, click on Details next to the amount and ledger number. VAT overview details
  4. You will see a breakdown of the invoice details belonging to that ledger. By clicking on the Details button again, you’ll be directed to the invoice involved.
  5. If desired, you can export the results to Excel or PDF by clicking one of the export icons at the bottom of the table.

How can I view a created VAT overview?

Go to   > Financial > VAT Overview. Here, you will see a list of created VAT overviews. The name is automatically generated based on the year and period of the overview. Click on the name to open the respective VAT overview.

Can I reopen a VAT period that was closed by mistake?

If the VAT period was accidentally closed, you can contact our Customer Support Team. They will assist you in reopening the VAT period.

How can I see foreign sales figures?

  1. Go to > Financial > VAT Overview.
  2. Click on the VAT period you want to see the foreign sales figures for.
  3. Once the VAT overview is open, click on ICP Sale Details at the bottom of the page.
  4. Click on the Back at the bottom of the page to return to the VAT overview.

How can I see foreign purchase figures?

  1. Go to > Financial > VAT Overview.
  2. Click on the VAT period you want to see the foreign sales figures for.
  3. Once the VAT overview is open, click on ICP Purchase Details at the bottom of the page.

  4. Click on Back at the bottom of the page to return to the VAT overview.

How can I see the VAT per client?

  1. Go to > Financial > VAT Overview.
  2. Click on the VAT period you want to see the foreign sales figures for.
  3. Once the VAT overview is open, click on VAT Per Client at the bottom of the page.

  4. Select an option in the drop-down menu.
    The available options are:

    • Sales with VAT number: an overview of all sales to clients with a VAT number.
    • Purchases with VAT number: an overview of all purchases from suppliers with a VAT number.
    • Customers and suppliers with VAT number: an overview of all sales and purchases from clients/suppliers with a VAT number.
    • Sales only: an overview of all sales.
    • Purchases only: an overview of all purchases.
    • All: an overview of all sales and purchases from all clients/suppliers.
  5. Click on Show.
  6. Click on Back, at the bottom of the page, to return to the VAT overview.

All VAT Per Client reports, can be exported to Excel and PDF, by clicking on the icons at the bottom of every report.

Related articles

Updated on 5 October 2023

Was this article helpful?