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.
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.
|
||||
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. |
||||
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. |
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.
|
||||
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.
|
||||
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.
|
||||
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. |
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Default sales tax codes |
|
||||||||
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.
Refer to Notes and warnings in the Descriptive Tax Code Browse/Maintenance program for additional information. |
||||||||
Rounding options |
|
||||||||
Tax/invoice rounding required | Rounds your tax and invoice values to the nearest
monetary unit of your currency.
|
||||||||
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 |
|
||||||||
Invoices to round |
|
||||||||
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 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
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.
|
||||||||||
AP withholding accounting basis |
Indicate when withholding tax should be calculated.
|
||||||||||
AP withholding tax applicable to |
Select the companies/suppliers to which withholding tax is applicable.
|
||||||||||
AP withholding tax applicable to |
Select the relevant expense type against which withholding tax must be applied.
|
||||||||||
AP withholding tax calculation basis |
Select the basis for the withholding tax calculation.
|
||||||||||
AP withholding tax calculation based on |
Select the base invoice amount on which witholding tax is to be calculated.
|
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).
|
||||||
Dispatches |
Enter the default code for dispatches (goods going to other EC Member States).
|
||||||
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.
|
||||||
Dispatches |
Enter the default Incoterms code for dispatches (goods going to other EC Member States).
|
||||||
Arrivals | Enter the default Incoterms code for arrivals (goods
arriving from other EC Member States).
|
||||||
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.
|
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.
|
||||
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. |
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.
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.
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 |
|
When you supply goods |
|
When you receive payment from your customer |
|
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 |
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. |
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.