TBL: DEDSTAT - Statutory Deductions

The statutary deductions (taxes) collected by various federal and provincial governments.

In addition, certain statutary deductions apply to specific earnings codes (Tables AMTOPT, ABSENCE, PRIME, TIMEOPT, MISCBANK). A deduction is only applied to an earning code if the DEDSTAT code is listed in TBLM1 of that earning code.

If there are entries in this DEDSTAT table that you never use (maybe they are for other provinces), you can just mark them [x]Obsolete (inactive).

SUPPLEMENTARY INFO

TBLC1 - EmployEE share

Normally, leave this empty, particularly for taxes.

If necessary, you can enter a numeric percentage (or an expression which calculates the percentage). This percentage is applied to LNAMT = the employee's earnings (and benefits) for the period to which this tax is applicable, to calculate the employEE contribution.

• You might do this if your company has its own unique rate.
• The expression can invoke a custom function or dated expression.

Examples:

• 25
• iif(years(pers.E_BIRTHDT, ldAsOf) < 18, 0, loDedstat.nCPPpctEE)

TBLC2 - EmployEE annual max

The employEE annual maximum. This overrides the standard calculation, so normally LEAVE THIS FIELD unless your company has an individual rate. (Such as for CNESST, WSIB)

Leave this field blank for EI (Employment insurance). Enter it in the EMPRNO table, because it varies by employer number.

TBLC3 - GL accounts

One or two GL accounts, separated by a comma if there is a second one. *** NOTE that these are the REVERSE ORDER of how two accounts are coded in the earnings codes tables (TIMEOPT, AMTOPT, etc.) ***

• The 1st account (before the comma) is the account to CREDIT -- the liability account.

  If the first account is empty, the CASH IN BANK account is used

• The 2nd account (after a comma) is the account to DEBIT -- the expense account for the employER share only.

  Only enter a 2nd account if there is an employer share it is the SAME ACCOUNT FOR ALL EMPLOYEES.

  If you don't enter a 2nd account the GL export uses the benefits expense account defined in the selected GLGRP table.

  You can also put a code that is inserted into the account number in the GLGRP, by preceeding it with ">".

• For example, if you put "...., >156" (the ... is the credit account), then "156" will replace a "?" in the GL account specified in the GLGRP for benefits and statutory deductions (employer overhead).

• If you want to put a DEBIT (2nd) account but no account to credit, just put a comma (,) at the beginning of the field.

TBLC4 - EmployER share (%)

Normally, leave this empty, particularly for taxes.

• DO NOT enter a rate for UIC or EI - these go in the EMPRNO table.

If necessary, you can enter a numeric percentage (or an expression which calculates the percentage). This percentage is applied to LNAMT = the employee's earnings (and benefits) for the period to which this tax is applicable, to calculate the employER contribution.

• You might do this if your company has its own unique rate.
• The expression can invoke a custom function or dated expression.

Examples:

• 25
• iif(years(pers.E_BIRTHDT, ldAsOf) < 18, 0, loDedstat.nCPPpctEE)

TBLC5 - EmployER annual max.

The employER maximum. This overrides the standard calculattion, so normally LEAVE THIS FIELD EMPTY.

TBLC8 - Applicable Provinces

This field indicates the provinces where it is applicable.

• Leave this empty if it applies to all provinces.
• Don't put anything here for FTAX or PTAX.
• Example: for CNESST you would put QC, because it only applies in Quebec.

When the net is calculated, the employee's province of taxation is determined for that period. (See options: C_TXPROV). If you have specified certain province(s) in this field, and the employee's province of taxation is NOT one of the provinces specified, this tax is not applied.