Add VAT Taxes/Withholding Tax Entries

VAT taxes are calculated by your SAP system at the time of posting. VAT taxes are calculated by SAP configuration that is not available to GLSU. While GLSU cannot calculate European VAT taxes inside the spreadsheet, it can allow transactions which contain VAT taxes to be successfully posted.

Header Field XMWST is the Calculate Tax field. This field can be added to your spreadsheet using the GLSU Ribbon > Choose Fields button.

A user can add the field XMWST to their spreadsheet and populate it with an X (see below). Once populated, the Calculate Tax field will disengage the standard GLSU balancing functionality that prevents GLSU from posting entries where debits do not equal credits. Once populated the balancing formula in the line item header will be changed to "– tax calc – (see below).

The user is given the responsibility of sending GLSU and SAP an entry which will be properly balanced after VAT taxes are calculated and added to the posting.

Withholding taxes entered with customer/vendor entries are supported as of version 23.4

To add withholding tax fields, from the Choose Fields option, you can search for any fields beginning with “WT_” and the supported withholding tax fields will be shown. It is important to note, like with other selected fields in Choose Fields, just because the field is placed on the sheet, does not necessarily mean the field is supported in your instance of SAP, or for that company code, customer/vendor account, etc. There are no field status groups for withholding tax fields in GLSU, so it is up to you to properly select and populate only available fields in your system. When in doubt, perform a manual entry first to verify fields available for input for the master data you have selected.

Withholding tax fields introduce a 3rd dimension of input in GLSU, which means you can have multiple withholding tax records for one customer/vendor line. This is represented as follows in the GLSU sheet. You will have one customer/vendor line and then 1 to many tax lines that immediately follow but are not on the customer/vendor line.

Withholding tax fields are available for customer/vendor account types only. If you place withholding tax lines following any line item other than a customer/vendor line, you will receive a validation error when validating.