SUP124 - Updating Tax Rates

General Topics


With effect from 1 April 2018, the VAT rate in South Africa will be increased from 14% to 15%.
The first step in compliance, is changing to your default Tax rates in Palladium to 15%. This is not as simple as changing all your current 14% tax types to 15%, as this could have consequences on outstanding transactions that must still be processed at 14% after April 1st.The better way is to create new tax types and this article is designed to guide you through the process of creating these new tax types and updating them in the relevant areas of your system.
With Palladium we have written a function that will create a mass convert function that will update the relevant areas automatically (Available to supported clients). Our unsupported clients would be required to process this function manually using the steps below.

What Tax Types Do I Need to Create?

You will need to create a new 15% tax types for every 14% tax type that you currently have. For most businesses that would mean creating the following four new tax types for 15%, although you may have separate or additional types to cater for both Tax Inclusive and/or Tax Exclusive processing.
  1. Vat Input
  2. Vat Output
  3. Bad Debts
  4. Capital Purchases
  5. Other as required by the Revenue Services
Note – The new tax rate would not affect the Zero Rated or Tax Exempt tax types. All clients, whether supported or not, are required to perform this function.

Creating New Tax Types

  1. On the Sales Tax / VAT menu, select the Tax Codes tab and the following menu will be displayed:
  1. Enter the tax code such as "11", "12", etc. This code will appear on all documents you create inside Palladium.
  2. Enter a description such as "VAT on Sales", etc. This will help your users to determine what the code is used for.
  3. Use the “Allowed In” drop down to select the journals where the code is allowed to be used in. It is recommended you have separate codes for sales and purchases. Your exempt and non-taxable codes can be allowed in all journals.
  4. The final option is the Defaults. If selected, this code will be the default for all new customers or Suppliers (or both) when they are created (but can be changed during creation). Here you can also specify whether the code is a default for the Receipt and Payment Journal.

Adding Tax Rates to your Tax Types

  1. Click the new button to enter the taxes to be charged into this code. Once you select New you will see the following screen:
  1. The tax drop down is populated with the Tax Authorities you created earlier. In this example it is SARS for Vat. But there could be a situation where there are multiple Tax Authorities benefitting from one Tax Rate, such as State and Federal Taxes.
  2. Use the status drop down you to select whether the authority is taxable, non-taxable, or exempt.
  3. Enter the tax rate. If you use amounts on invoices that include sales taxes, you need to check the included in price check box. If your prices are exclusive of tax, then leave this clear.
  4. The last check box (refundable) signifies whether this is a Refundable or non-Refundable tax, with the latter being expensed rather than recovered.


Automatic Tax Update Option – Supported Clients

To update your new Tax Rates please perform the following steps. Remember to first make a backup of your company.

Step 1

Go to the control Panel and select the Sales Tax / VAT icon and select the Global Update option

Step 2

Select whether you would like to update Customers or Vendors, then select the Masterfiles and/or Transactions that you would like to update per the screen below.

Field Definitions

Masterfile – Default Tax and Masterfile – Withholding Tax

These are the default tax setting, as well as the Tax Exemptions, on the Taxes Tab situated on the Customer and Vendor Masterfiles (Maintenance) as seen below.

Warehouse Delivery Methods

These are the tax codes as defined on the Delivery methods relating to the tax on the delivery cost lines.

Tax Inclusive Pricelists

This function relates to the setting on Customer Pricelists as seen below. This setting merely sets the Pricelist as a Tax Inclusive Pricelist when using the Mark-up on Cost at time of receiving function as the Last Received cost is always captured as a Tax Exclusive Value so in order to Maintain the 30% margin we need to also add the tax to the price when using a Tax Inclusive pricing Model.

Processing Documents

This function will update the Tax on the Open Processing Documents where the open quantity for that line item is one or greater. Open Transactions Include:
Orders, Quotes, Freehand Quotes, Contract Billing as well as Saved Invoices, GL Journals and Receipts and payments Journals. Note the documents saved (as recurring) as per the screen below:

Displaying and Printing of Updated Open Documents

After you have changed the transaction and display an Open Document, the New Tax Code will be displayed, (say 14%) but the value would not have been adjusted. The value on the document line and total will only adapt to that of the new Rate once you adjust or convert the document (from a Sales Order to a Sales Invoice for example). Note that you will NOT be able to print a document until this function has been performed as per the warning screen below.


Manually Updating Your New Tax Types

Once your new codes are set up, you will need to populate the relevant codes to your Customers, Suppliers and Inventory items.
There are 2 areas that we need to setup in the form of the Default Tax type for your various Customers and Suppliers, then we need to setup the Tax Exceptions for Customers, Suppliers and Inventory Items.

Changing Customer and Vendor Tax Codes

To update the tax codes for Customers and Vendors follow this simple procedure:
  1. Export your existing Masterfile data to excel by going to the Control Panel, selecting Customers (and Vendors) and then Get Data.
  1. Select the Export function to Export the file to Excel.
  2. Open the file and update the strTaxCode field with the new tax code. To update the Withholding Tax field you would need to update the tax code on the bitWithholdTaxCode.
  3. Once you are finished updating save the file.
  4. In Palladium click on Load File and add the file you have just updated.
  5. Click Import to add the updated Masterfile data into Palladium.
  6. Repeat this process for your Vendor Masterfile.
Please note that these tax types are merely DEFAULT Tax Types and that you are still able to adjust the tax type on a document for ‘back-processing”.

Updating your Tax Exceptions

To update the Tax Exceptions you would be required to go into each Customer, Vendor and Inventory Masterfile, and Update each code manually, as seem below in the case of Inventory Items. In South Africa, Tax Exemptions would not apply for Customers and Suppliers (provided the correct default Tax type has been selected) but would apply to certain Vat Exempt items.

Updating Open Documents

All your open documents would need to be adjusted manually. These include your Purchase and Sales Orders, Quotes, Freehand Quotes, Contract Billing and Delivery Advices.


Updating Saved or Recurring Documents

All your open Recurring or Saved documents would also need to be adjusted manually. These include Invoices, GL Journals and Receipts and Payment Journals.

Add Feedback