Displaying VAT overview
Menu path
Finance ➔
VAT / Statistics ➔
VAT overview
Introduction
You can view the
information about the VAT that has been booked in the system through the VAT
overview. The VAT entries are reflected by the types of VAT that include VAT to
claim and VAT to pay, the corresponding VAT codes, and the number of VAT
transactions that have been created. With the VAT overview, you can obtain a
clear picture on the VAT entries and the balance amount of VAT to be paid or
VAT to be claimed to or from the tax authorities.
What version are you using?
The information in this document is applicable to product
update 411 and higher. If you have versions lower than this, certain features
explained here will not be applicable.
How do I view the VAT overview?
- In the VAT overview screen, define the search
criteria.
- Click Display.
How do I print the VAT overview?
- In the VAT overview screen, define the search
criteria.
- Click Display.
- Click Print.
How do I export the VAT overview to a Microsoft Excel sheet?
- In the VAT overview screen, define the search
criteria.
- Click Display.
- Click Export.
How do I assign a tax period to the VAT transactions?
- In the VAT overview screen, define the search
criteria.
- Click Display.
- Select the required VAT transaction(s) to assign to a tax
period.
- Click Assign.
- Select the Year, Type and Return
period.
- Click OK.
How do I view an overview of the created VAT returns?
- In the VAT overview screen, define the search
criteria.
- Click Display.
- Click VAT return. For more information, see
Overview of VAT
return.
Fields
Date / Reporting date / Fulfillment date
Select Date, Reporting date, or Fulfillment
date to display the VAT overview by date, reporting date, or fulfilment date.
Date / Reporting date / Fulfillment date
Depending on your selection, you will see Date, Reporting
date, or Fulfilment date here. Type or select the date,
reporting date, or fulfilment date range to display the VAT overview within the
defined period range. Select the All check box to display the VAT
overview for all the dates.
Note: Typing or selecting only the start date will
display the VAT entries that are recorded on and after the selected date.
Typing or selecting only the end date will display the VAT entries that are
recorded on or before the selected date.
VAT return
Select the type of VAT return you want to view. There are
four options available:
- All – Select this option to view all types of VAT
transactions.
- No – Select this option to view the VAT transactions that
have not been assigned tax periods.
- Assigned – Select this option to view the VAT transactions
that have been assigned to specific tax periods.
- Final – Select this option to view the VAT transactions
where a final declaration has already been made.
Group by
Select the required option to group the VAT transactions:
- VAT box – Select this option to group the VAT transactions
by the VAT boxes.
- VAT code – Select this option to group the VAT transactions
by the VAT codes.
- VAT box / VAT code – Select this option to group the VAT
transactions by the VAT boxes and VAT codes.
- Return period / VAT box – Select this option to group the
VAT transactions by the return periods and VAT boxes.
- GL account – Select this option to group the VAT
transactions by the general ledger accounts.
- OSS – Select this to display the list of VAT returns that uses VAT codes designated for OSS. Note that the Print button is unavailable when this is selected.
Columns
Box
This column displays the VAT box that is linked to
the VAT code used in the entry. For more information, see Creating
and maintaining VAT return boxes.
Note: This column is available only if you have
selected VAT box / VAT code, VAT box, or Return period
/ VAT box at Group by.
Return period
This column displays the return period assigned to the
entry.
Note: This column is available only if you have
selected Return period / VAT box at Group by.
VAT code
This column displays the VAT code that is used in the
entry. For more information, see Creating
and maintaining tax codes.
Note: This column is available only if you have
selected VAT box / VAT code or VAT code at Group by.
VAT box description
This column displays the description of the VAT box
that is linked to the VAT code used in the entry. For more information,
see Creating
and maintaining VAT return boxes.
Note: This column is available only if you have
selected VAT box / VAT code, VAT box, or Return period
/ VAT box at Group by.
VAT code description
This column displays description of the VAT code that
is used in the entry. For more information, see Creating
and maintaining tax codes.
Note: This column is available only if you have
selected VAT box / VAT code or VAT code at Group by.
GL account
This column displays the general ledger account in which the
VAT is registered.
Note: This column is available only if you have
selected GL account at Group by.
Description
This column displays the description of the general ledger
account in which the VAT is registered.
Note: This column is available only if you have
selected GL account at Group by.
Exclude from VAT return
This column will display a checkmark when the Exclude
from VAT return setting of the VAT box that is linked to the VAT
code used in the entry is selected.
Note:
- This column is available only if you have selected VAT box / VAT
code, VAT box or Return period / VAT box at Group by.
- For the Malaysian legislation, this column will be displayed by
default. For other legislations, this column will be hidden by default. You can
display this column via the column settings.
Excl. from total in VAT overview
This column will display a checkmark when the Excl. from
total in VAT overview setting of the VAT box that is linked to the VAT
code used in the entry is selected.
Note: This column is available only if you have
selected VAT box / VAT code, VAT box, or Return period
/ VAT box at Group by.
Basis: To pay
This column displays the base amount on which the amount at VAT:
To pay is based.
Note: This column is available only if you have
selected Return period / VAT box or GL account at Group by.
Basis: To claim
This column displays the base amount on which the amount at VAT:
To claim is based.
Note: This column is available only if you have selected
Return period / VAT box or GL account at Group by.
VAT: To pay
This column displays the VAT amount that has to be paid.
This amount is based on the Basis: To pay amount and the VAT percentage.
Note: This column is available only if you have
selected Return period / VAT box or GL account at Group by.
VAT: To claim
This column displays the VAT amount that has to be claimed.
This amount is based on the Basis: To claim amount and the VAT
percentage.
Note: This column is available only if you have selected
Return period / VAT box or GL account at Group by.
Type
This column displays the type of VAT which can be To
claim, To pay or non-deductible VAT.
Note: This column is available only if you have
selected VAT box / VAT code or VAT code at Group by.
VAT basis
This column displays the base amount on which the amount at VAT
is based.
Note: This column is available only if you have
selected VAT box / VAT code, VAT box, or VAT code at
Group by.
VAT
This column displays the total VAT amount. This amount is
based on the VAT Basis amount and the VAT percentage.
Note: This column is available only if you have
selected VAT box / VAT code, VAT box, or VAT code at
Group by.
Calculated VAT %
This column displays the calculated VAT percentage. This is calculated
based on the amounts in the VAT basis and VAT columns. Depending
on how you group the overview and how you set up your company, this can be used
as a control mechanism to compare the calculated VAT against the actual VAT
percentage.
VAT %
This column displays the actual VAT percentage. Depending on
how you group the overview and how you set up your company, this can be used as
a control mechanism to compare the calculated VAT against the actual VAT
percentage.
Quantity
This column displays the numbers of entries on which the
amounts in the specific row in the overview are based. You can view the
underlying entry lines by clicking the Zoom button.
0: Basis / 1: Basis / etc
The names of these columns are based on the VAT codes in
your company. For every VAT code, a column is available that displays the VAT
basis amount for that VAT code. For more information, see Creating
and maintaining tax codes.
Note: This column is available only if you have
selected VAT box, Return period / VAT box, or GL
account at Group by.
Buttons
Refresh
Click this to display the VAT overview based on the defined criteria.
Print
Click this to generate the print preview of the VAT
overview.
Zoom
Click this to view the transaction details of the selected
VAT row in the overview.
Export
Click this to export the data in the overview to Microsoft
Excel.
Assign
Click this to assign the selected VAT transaction(s) to a
tax period.
VAT Return
Click this to view the VAT returns that have been created in
the system. For more information, see Overview of VAT return.
Close
Click this to exit.
Related documents
| Main Category: |
Attachments & notes |
Document Type: |
Online help main |
| Category: |
|
Security level: |
All - 0 |
| Sub category: |
|
Document ID: |
17.686.601 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |