SYSPRO Ribbon bar > Setup > General Setup > Tax Options

Tax Options

You use this program to configure the tax system you require, as well as to capture and maintain the tax codes required within the system.

Toolbar and menu

Field Description
Tax Codes Take on and maintain specific tax codes required within the system.
Nationalities Define the nationality codes for the countries in which your suppliers and customers are located.
Withholding Tax Codes Take on and maintain the withholding tax codes required within SYSPRO (EC VAT only).

Withholding tax is an advance payment of company tax that is collected by the company when paying a supplier.

Tax Effective Rates Maintain historical rates for VAT and GST tax codes.
Tax Return Periods Define the start and end dates for each of your tax periods and years.

These dates are ignored if you enabled the Use GL periods for Tax Returns option (Options tab).

Tax return periods must be defined before running the Tax Return Setup conversion program.

[Note]

If you de-select the Use GL periods for Tax Returns option and select the Tax Return Periods function, the system notifies you that the periods you enter using the Tax Return Period Maintenance program will be ignored (because you have not yet saved the de-selection of the Use GL periods for Tax Returns option). In this instance, you can ignore the message because when you save the de-selection of the Use GL periods for Tax Returns option, the dates entered in the Tax Return Period Maintenance program will be used by the Tax Return program.

Descriptive tax codes Use the Descriptive Tax Code Browse/Maintenance program to define tax codes of up to 20 characters long to comply with legislation where tax codes longer than three characters are required.

This function is only enabled when the Use descriptive tax codes option is enabled.

Save

Select this to save the selections you made on all the tab pages and to exit the program.

Print

Select this to print a report of your tax setup options.

It is advisable to keep this report for disaster recovery purposes.

Cancel

Select this to exit the program without saving any changes you made.

Help

Select this to view the latest online Help documentation for this program.

General

Field Description
Tax system  
Basic tax system The tax code held against a stock item determines the rate of tax applied to a stocked order line.

GST code options defined against geographic areas (Browse on Geographic Areas) are ignored.

Tax by geographic area The tax code held against a customer's geographic area determines the rate of tax applied to a stocked order line.
USA tax by advanced geocodes The tax code assigned to a customer's geographic area determines the rate of tax applied to a stocked order line.

Each tax code is divided into state, county and city rates - the total of which is used to calculate sales tax on an invoice.

This option is enabled if your nationality code is set to USA or CAN.

USA AVP sales tax system The tax code assigned to each postal/zip code (broken down by state, county and city) determines the rate of tax applied to a stocked order line. The total of these rates is used to calculate the sales tax on an invoice.

This option works in the same way as the USA Tax by advanced geocodes system, except that you import a file that contains all the rates for the country instead of maintaining them manually (useful to anybody who sells in many locales).

The system automatically inserts the city name and state code into the address fields when maintaining customer details.

This option is enabled if your nationality code is set to USA or CAN.

Company for tax codes file Indicate the company's tax code file you intend using.

This is only enabled for the USA Tax by advanced geocodes or USA AVP sales tax system options.

EC VAT system required If you are a member of the European Community (or trade with countries that are EC members) then various programs throughout the system will prompt you to enter EC details.

This information is used to generate the statistical and tax reports required by EC regulations, as well as to generate a tax audit trail of all purchases and sales between EC countries.

Canadian GST required Tax is levied according to a two-level system - GST (federal level) and PST (provincial level).

Although most provinces charge PST besides GST, some provinces charge PST on GST.

[Note]
  • If you enable this option together with Tax by geographic area and the tax code held against a stock item is blank, then the program assumes that the item is exempt from tax and disregards the tax code assigned to the geographic area when calculating tax for that item on a sales order.
  • If you enable this option after you defined your product classes, then you will need to create the _GST product class manually.
Australian GST required Tax is levied on the supply of goods and services in Australia and on goods and services imported into Australia.

It is essentially a value added tax (VAT) system where tax is paid at each step along the chain of transactions involving goods or services, until the end-user is reached.

This is enabled when your nationality code is set to AUS.

USA third party tax system required Tax is calculated using a third party system. Details are captured on the USA 3rd Party tab which are passed as XML to the query business object supplied by the designer of the third party tax system.

This option only applies if you selected the USA tax by advanced geocodes or USA AVP sales tax system options.

Sales tax integration to general ledger

Branch level Integrates sales tax to General Ledger according to the branch code of the sale.

The sales tax ledger account held against the AR branch is used for tax distribution.

Tax code level Integrates sales tax to General Ledger according to the ledger account held against each tax code.

This does not apply to Canadian GST because GST is always integrated at branch level.

Sales tax calculation

Invoice level

Calculates tax at the end of an invoice for each tax rate used in the invoice calculation.

The taxable amount for each invoice line is accumulated and the tax is calculated for the total invoice amount to give the invoice level tax value.

Line level

Calculates tax for each line on an invoice before it is accumulated into a total invoice tax value.

You must select this option if your nationality code is USA and you want sales order programs to calculate tax based on tax limits.

[Note]

A maximum of five different tax codes can be printed on each individual invoice document.

This is not a limit on the number that can be entered for an order, but a limit to the number that can be catered for in the final document.

Therefore, if you processed two separate delivery notes and invoices from an order, you could have 5 different tax codes on each document.

Reduce tax base by terms discount

Allow when inclusive tax exists Allows you to reduce the taxable portion of lines by the settlement discount percentage for tax codes which are defined as inclusive (i.e.

reduces the tax base by the terms discount prior to the tax being calculated).

This option allows you to assume the discount is being taken prior to calculating tax.

[Note]

If any tax code is defined as inclusive, then you must select this option before you can reduce the taxable portion of merchandise, freight and miscellaneous charge lines.

Merchandise lines

Reduces the taxable portion of merchandise lines according to the settlement discount percentage, before tax is calculated.

Freight lines

Reduces the taxable portion of freight lines according to the settlement discount percentage, before tax is calculated.

Miscellaneous lines

Reduces the taxable portion of miscellaneous lines according to the settlement discount percentage, before tax is calculated.

GST calculation

Invoice level

Calculates GST at the end of an invoice for each tax rate used in the invoice calculation.

Line level

Calculates GST for each line on an invoice before it is accumulated into a total invoice tax value.

Options

Field Description
Default sales tax codes
[Note]
  • These options only apply if you are using the Basic taxsystem or Tax by geographic area.

    When using the Tax by geographic area and a tax code is held against the geographic area, then that code is used (i.e. the codes defined here are only used if no corresponding tax code is held against the geographic area).

  • If you are using the USA tax by advanced geo codes or USA AVP sales tax system, then an entry in any of the Default sales tax code fields indicates that the default state of the corresponding line is taxable.

Miscellaneous charges

Assign a default tax code for miscellaneous charges or leave blank to default to non-taxable.

The Descriptive tax code must be used if defined (Descriptive Tax Code Browse/Maintenance).

Freight charges

Assign a default tax code for freight charges or leave blank to default to non-taxable.

The Descriptive tax code must be used if defined (Descriptive Tax Code Browse/Maintenance).

Non-stocked items

Assign a default tax code for non-stocked items or leave blank to default to non-taxable.

The Descriptive tax code must be used if defined (Descriptive Tax Code Browse/Maintenance).

Credit notes

Assign a default tax code for credit notes or leave blank to default to non-taxable.

The Descriptive tax code must be used if defined (Descriptive Tax Code Browse/Maintenance).

Use GL periods for Tax Returns Uses the period end dates defined for your General Ledger as the tax return periods for generating the Tax Return report (you will need to run the Tax Return Setup conversion program).

Otherwise you need to use the Tax Return Period Maintenance program to define the tax return period dates for the Tax Return report.

Use descriptive tax codes

Enables the Descriptive Tax Codes function to define tax codes of up to 20 characters long.

When you enable this option, the descriptive tax codes must be used in the tax code fields in SYSPRO.

[Note]
  • Descriptive tax codes cannot be used together with any of the following tax systems:

    • USA tax by advanced geocodes

    • USA AVP sales tax

    • EC VAT

    • Canadian GST

    • Australian GST

    • Withholding tax

This option only applies when running SYSPRO in a SQL environment.

Refer to Notes and warnings in the Descriptive Tax Code Browse/Maintenance program for additional information.

Rounding options
[Note]

These options only apply to Sales (including Point of Sales), Quotations and RMA.

Tax/invoice rounding required Rounds your tax and invoice values to the nearest monetary unit of your currency.
[Note]

Rounding occurs on the total tax amount and total invoice amount (i.e. values at line level are ignored).The rounding values are output to _RND (for the document value) and _TAX (for tax value).

Round tax value Applies rounding to the total tax amount which is applied to the net invoice value.

Tax rounding is typically only necessary if required by legislation in your country.

Round invoice value Applies rounding to the total invoice amount.

You would typically use this if rounding is required because of the non-existence of small denomination coins (e.g. if the smallest denomination in your currency is 5, rather than 1 or 2).

If you select to round both the tax value and the invoice value, then rounding is first applied to the tax value.

Include foreign invoices Applies tax and/or invoice rounding to invoices for foreign currency customers.
Round values
Field Description
Up Round tax and/or invoice values up to your nearest monetary unit of currency (e.g. if invoice rounding is required to the nearest 5 cents and the invoice value is 101.84, then the invoice value is rounded up to 101.85).
Down Round tax and/or invoice values down to your nearest monetary unit of currency (e.g. if invoice rounding is required to the nearest 5 cents and the invoice value is 101.84, then the invoice value is rounded down to 101.80).
Off Round tax and/or invoice values to the nearest required value where 0-4 is down and 5-9 is up.
Invoices to round
Field Description
All Apply tax rounding to all invoices produced from Sales Orders or Dispatch Notes.
Payments Apply tax rounding only to invoices processed using the SO Counter Sales program.
Cash payments Apply tax rounding only to invoices processed using the SO Counter Sales program, where the Payment type for A/R is set to Cash for the Payment code used (Browse on Payment Codes).
Round to nearest

Enter the monetary or local unit of currency to which you want to round tax and invoice values.

For example, if your smallest monetary unit of currency is 5 cents, then you would probably enter 5 in this field. If you are using the Point of Sale system, you may need to give change to customers. You can therefore not round invoices to a monetary unit that is less than the smallest coin available (e.g. you would not round to 1 or 2 cents if the smallest available coin is 5 cents).

Field Description
Decimal

Select this if the value entered in the Round to nearest field represents the nearest monetary unit of currency (e.g. if you entered 1 in the Round to nearest field and you select Decimal, then rounding is done to the nearest cent, not to the nearest 1 decimal place).

Unit

The value entered in the Round to nearest field represents the nearest local currency unit (e.g. if you entered 1 in the Round to nearest field and you select Unit, then rounding is done to the nearest dollar).

Withholding Tax

Field Description
Withholding tax options

Withholding tax required

Indicate if withholding tax is required.

Withholding tax is where the purchaser is responsible for remitting the tax portion of the purchase to the tax office (i.e. the purchaser makes one payment to the supplier of the goods/services purchased and another payment to the tax office for the withholding tax portion of the transaction).

Automatic calculation of withholding tax

Calculates the value of withholding tax automatically at the time of making a payment in the Accounts Payable module (Taxable Amount * Withholding Tax Rate)/100).

You should not select this option if you are disbursing tax over multiple general ledger tax accounts. For each invoice processed using the AP Invoice Posting program, the withholding tax system recognises only the first tax code entered.

  • If this option is enabled, then the taxable amount is:

    Gross payment less Tax amount on invoice less Discount amount (where Tax amount on the invoice is calculated from the tax code assigned to the first GL Distribution entry against the invoice).

  • If this option is not enabled, then the taxable amount is:

    Gross payment LESS Discount amount (the Tax amount on the invoice cannot be calculated as it is assumed that multiple tax codes were used and therefore the total tax value cannot be calculated).

AP withholding accounting basis

Indicate when withholding tax should be calculated.

Field Description
Payment

Withholding tax to be calculated when the actual invoice payment is made.

Tax will be calculated after the following transactions have been posted:

  • AP Payment Run

At point of capture

Withholding tax to be calculated when capturing the supplier invoice.

Tax will be calculated after the following transactions have been posted:

  • AP Invoice Posting

  • AP Credit Note

  • AP Debit Note

  • AP Adjustment

  • AP Permanent Entries Posting

  • AP Initial Invoice Capture

AP withholding tax applicable to

Select the companies/suppliers to which withholding tax is applicable.

Field Description
Foreign companies

Apply withholding tax to foreign companies/suppliers only.

Local companies Apply withholding tax to local companies/suppliers only.
Individual

Apply withholding tax to an individual supplier.

This can include contractors or consultants.

AP withholding tax applicable to

Select the relevant expense type against which withholding tax must be applied.

Field Description
Goods

Withholding tax to be calculated on goods only.

Service

Withholding tax to be calculated on services only.

Both

Withholding tax to be calculated on both goods and services.

AP withholding tax calculation basis

Select the basis for the withholding tax calculation.

Field Description
Tiered

Calculate withholding tax on a tiered basis.

This option is not available yet.

Fixed rate

Base the withholding tax calculation on the fixed rate defined in the Withholding Tax Codes program.

Currently only the Fixed rate is used, and is selected by default.

Fixed value

Calculate withhholding tax using a fixed value.

This is similar to tax brackets in which a different % is used depending on the amount e.g. from 0 to 1000 it is 1%, from 1001 to 9999 it is 5% etc.

Base value plus percentage

Calculate withholding tax using a base value plus percentage.

This is like a fixed rate, but if the amount is over a certain number e.g. over 1 million, then an additional % tax is withheld.

AP withholding tax calculation based on

Select the base invoice amount on which witholding tax is to be calculated.

Field Description
Gross invoice value less tax

Withholding tax is calculated on the net invoice value (gross invoice value less tax and less QST if applicable) of the good or service.

Invoice value after trade discounts

Withholding tax is calculated on the invoice amount less any trade discounts.

Invoice value after trade and settlement discounts

Withholding tax is calculated on the invoice amount less any trade and settlement discounts.

This option is not available if the accounting basis is set to At point of capture as the settlement discount cannot be determined at the time of capturing the invoice.

This option is not available yet.

Intrastat

This refers to the method of collecting information and producing statistics on the trade in goods between countries of the Member States of the European Union (EU).

Nature of transaction codes and delivery terms are used when receipting a purchase order or raising a sales order for an EC Member State (excluding local transactions) and are ultimately used when generating supplementary declarations.

Field Description
Default nature of transaction codes

This indicates the type of transaction declared on the Supplementary Declaration (e.g. sales, acquisitions, goods sent for processing or free of charge goods).

[Note]

The Default nature of transaction codes options are disabled if you have not enabled the EC VAT system required setup option under the General tab.

Dispatches

Enter the default code for dispatches (goods going to other EC Member States).

Field Description
Invoices

Enter the default code for invoices.

Credit notes

Enter the default code for credit notes.

Arrivals

Enter the default code for arrivals (acquisitions).

Default delivery terms This indicates the default three-character alphanumeric Incoterms code, denoting the terms of delivery.
[Note]

The Incoterms code indicates the portion of costs and risks agreed to by the parties in a contract of purchase or sale.

For example, the Delivery term CIP (Carriage and Insurance Paid) indicates that the seller pays the cost of carriage and insurance necessary to bring the goods to a named destination (i.e. Shipping location).

Dispatches

Enter the default Incoterms code for dispatches (goods going to other EC Member States).

Field Description
Invoices

Enter the default code for invoices.

Credit notes

Enter the default code for credit notes.

Arrivals Enter the default Incoterms code for arrivals (goods arriving from other EC Member States).
FieldDescription
ArrivalsEnter the default code for arrivals (acquisitions).
Capture delivery terms for non EC members Enable this option to allow the entry of Delivery Terms and Shipping Locations into sales order/purchase order documents for customers/suppliers who are non-EC members.
[Note]

This option is not dependant on the EC VAT system required setting.

USA 3rd Party

Field Description
Tax interface  
Interface type The name of the third party tax system.
Business object The six character name of your query business object that will be called to interface to the selected third party routine.

This business object must take XML from SYSPRO, call the third party process and pass the results back to SYSPRO as XML.

SORQT3.XML is provided as a sample XML instance to demonstrate the use of the Extended Tax Calculation Query Business Object provided. The file is located in the Base\Schemas folder.

SORQT3OUT.XML is provided as a sample XML instance returned by the Extended Tax Calculation Query Business Object (which also resides in the Base\Schemas folder).

The relevant .XSD files are also located in the Base\Schemas folder.

Tax setup Optionally enter the six character name of the NetExpress program that must be called to maintain information specific to the third party routine used. The program must reside in SYSPRO's Programs folder and is only used to define additional options (i.e. specific customer parameters required which do not form part of the core SYSPRO) which may be required by the third party tax system.

You define these parameters using the Third Party Setup function.

An area of 200 bytes is available on the tax record that is passed to the program and saved on return if non-blank. This area is reserved for the use of the developer calling the 3rd party routine.

Default ship from information The default 'ship from' fields required for non-stocked and miscellaneous lines.
Apply USA 3rd party tax calculation in Sales Orders Uses the third party tax system for all calculations relating to order and line totals in Sales Order Entry and Point of Sale Entry.
[Note]

If the Business object indicated above is not found, then the SYSPRO tax calculation is used.

Third Party Setup

Loads the program entered at the Tax setup field, enabling you to indicate additional setup options which are interface or customer-specific to your tax program.

Identification level Indicates the level of identification required by the tax process.
Update tax for this company Determines whether this is a test company or a company that requires updates.

If enabled, a flag is passed to the business object at the appropriate time to update the tax information in the third party system. Otherwise, the flag passed is always N.

Notes and warnings

USA tax considerations

  • Don't switch between using the USA tax by advanced geocodes and USA AVP sales tax system as the tax code key formats differs between the systems.

    • The key for the USA tax by advanced geocodes is 4 characters for the country code and 3 characters for the city code (e.g. AABBBB CCC).

    • The key for the USA AVP sales tax system is 5 characters for the zip code and 2 characters for the city code (e.g. AABBBBBCC).

  • When USA tax is in force, tax is always excluded from credit checking calculations.

Intrastat considerations

  • Delivery Terms and Shipping Location's can only be captured if:

    • a valid Nationality code has been entered, and EC Vat is in force, or

    • the option Capture non EC members delivery terms is enabled in the Intrastat Setup program.

  • The Delivery Terms and Shipping Location defaults defined in Suppliers and Customers take precedence over those defined in the Intrastat Setup program.

  • To reflect the Delivery Terms and Shipping Location on sales order and purchase order documents, ensure that these fields are enabled in the document format setup programs (only available with Word and SRS document printing).

  • Delivery terms are maintained using the Intrastat Delivery Terms program.

  • Shipping locations are maintained using the Shipping Locations program.

  • Nature of transaction codes are maintained using the Intrastat Transaction Nature program.

Withholding tax considerations

  • You cannot activate this system if you have configured tax amounts to be requested for settlement discounts (Accounts Payable Setup) or that the tax portion of invoice adjustments/discounts must be requested (Accounts Receivable Setup). Tax on settlement discount cannot currently be used together with Withholding tax.

  • A valid tax code must be defined against the withholding tax options of your suppliers (Supplier Maintenance).

  • Before changing this option you must complete all Accounts Payable payment cycles and generate all ledger journals for Accounts Payable. Otherwise you may encounter imbalances in the Cash Book and General Ledger.

  • Withholding tax Payment accounting basis example:

    Say the Outdoors Company sells you goods for 1000.00 (plus 10% tax):

    When you pay for goods
    • debit the full 1100.00 to the supplier account for The Outdoors Company
    • deduct the withholding tax portion of 100.00 from your payment and remit 1000.00 to The Outdoors Company
    • remit the 100.00 tax to the tax office
    When you supply goods
    • debit your customer with the full amount of the goods, including the tax.

    When you receive payment from your customer
    • credit the full invoice amount to your customer's account
    • debit the tax portion to the tax control account
    • debit the actual payment amount received (which excludes tax) to your bank account
  • Withholding tax At point of capture accounting basis example:

    Invoice Amount 2000.00

    If the invoice is inclusive of 14% VAT and the WHT Tax applicable for this transaction is 5%, then the following:

    1. Net amount before VAT is 2000.00/1.14 = 1754.39

    2. Vat amount is 1754.39*14% = 245.61

    3. Withholding tax is 1754.39*5% = 87.92

    4. Total Accounts Payable will be 1754.39 + 245.61 = 2000.00

    Description Debit Credit
    Expense account 1754.39  
    Input VAT 245.61  
    Account Payable   2000.00
         
    Accounts Payable 87.92  
    Withholding Tax Provision   87.92

    If the invoice is exclusive of 14% VAT and the WHT Tax applicable for this transaction is 5%, then the following:

    1. Net amount before VAT is 2000.00 = 2000.00

    2. Vat amount is 2000.00*14% = 280.00

    3. Withholding tax is 2000.00*5% = 100.00

    4. Total Accounts Payable will be 2000.00 + 280.00 = 2280.00

    Description Debit Credit
    Expense account 2000.00  
    Input VAT 280.00  
    Account Payable   2280.00
         

    Accounts Payable

    100.00  
    Withholding Tax Provision   100.00
    [Note]

    The provision for the WHT will be invoked as per the WHT configuration:

    1. At point of capture the transaction will be recorded immediately after capturing the supplier invoice.

    2. At point of payment the transaction will only be recorded when the actual payment is made.

Rounding considerations

  • Invoice rounding is typically required in countries where small denomination coins have been phased out or specific legislation on rounding of tax on invoices exists in your country.

  • When an invoice is produced using the Document Print program and the Sales tax calculation option is set to Invoice level, then:

    • a _RND" entry is written to the discount column (DiscValue) in the AR Detail transaction table (ArTrnDetail) with any rounding difference between the discount calculated at line level and the discount calculated at invoice level.

    • a _TAX entry is written to the tax column (TaxValue) in the AR Detail transaction table (ArTrnDetail) with any rounding difference between the tax calculated at line level and the tax calculated at the invoice level.

    These entries balance the rounding differences in discount and tax entries when the AR Sales Distribution report is produced.

  • All monetary values in SYSPRO are rounded to 2 decimal places by default, so you should not need to use these rounding options to achieve this (e.g. if the amount to be rounded is 2.18763, then SYSPRO automatically rounds this to 2.19. If you enter 2 in this field, then the value is rounded to 2.20).

    For example:

    Order line details Calculations
    Quantity 1.2345
    Price 10.9876
    Total line value 1.2345 * 10.9876 = 13.5641922
      = 13.56 (rounded automatically)
    Tax rate 8.253%
    Tax value ((13.56 * 8.253) / 100 ) = 1.1191068
      = 1.12 (rounded automatically)
    Total line value 13.56 + 1.12 = 14.68

    Tax and invoice rounding is only done on the total tax amount for the order and on the total invoice amount including tax.

    Assume rounding is required on both the tax and the invoice to the nearest 5 decimals (e.g. 5 cents, because 5 cents is the lowest coinage denomination in use in your country) and values must be rounded up.

    The tax is rounded first.

    In this example, 1.12 is not divisible by 5, so the tax portion is rounded to 1.15 (i.e. a rounding of 3 units is applied).

    The total invoice value including tax is now 13.56 + 1.15 = 14.71.

    This is not divisible by 5, so further rounding is applied on the invoice to round it up to the nearest value divisible by 5.

    The invoice value then becomes 14.75 (because we are rounding up) which is divisible by 5. This means that if you were processing the invoice for a cash sale and your customer gave you 15.00 you would be able to give the change of 0.25 cents.

    If you had selected to round off, then the invoice value would have been rounded to 14.70 (which again is divisible by five).

    If, however, the total invoice value had been divisible by five (say it was 14.75), then it would not have been left as that and not rounded further.