Tax Reporting Tab of Tax Codes Configuration

Use this tab to enter information for tax codes that are used in XML tax reports.

Contents

VAT Reporting Grid

The information that you enter on this tab is used to calculate taxes for XML files that you generate in Accounting > Tax File Generation, such as the VAT Declaration XML.

For Belgian taxes, you specify the gridnumbers that are associated with a tax code. This enables the base amount, tax amount, and non-recoverable tax amount to be calculated correctly in the VAT Declaration XML file.

For example, some tax codes need only the base amount in a single gridnumber and the tax amount in a single gridnumber. You would enter these two gridnumbers into the respective columns of one row. If a tax code needs the base amount entered into gridnumbers 81 and 86 and you must also enter their tax amount into gridnumbers 55 and 59, you would enter two rows in the VAT Reporting grid.

VAT Reporting Grid Toolbar

Field Description
VAT Reporting Drop-Down
  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Insert Click this toolbar option to insert a new row in the grid and add VAT gridnumber information.

In each row, you enter the base amount, tax amount, or non-recoverable amount that goes into a gridnumber.

Delete Select a row in the grid to delete. Then click this toolbar option to delete the row.

VAT Reporting Grid Fields

If you need to enter 0 as the gridnumber for the base amount, tax amount, or non-recoverable tax amount, enter 999 in the Base Amount, Tax Amount, or Non-Recoverable Tax Amount field in the grid. DPS interprets 999 as 0 for the XML tax reports.

Field Description
Base Amount Enter the gridnumber code for the base amount.
Tax Amount Enter the gridnumber code for the tax amount.
Non-Recoverable Tax Amount Enter the gridnumber code for the non-recoverable tax amount.