The Vendor Remittance Report tracks earnings of BC employees and generates a BC EHT remittance amount, for the BC EHT employer health tax set up by the BC government. When you installed the Vendor Remittance Report, you chose an import file based on your payroll thresholds. But what if your thresholds change?
If your remittance report for BC EHT changes throughout the year, please adjust your current report. If you’re expecting changes in the new year, you can just import the new report.
Important Information
Your remittance payments are tracked through the system and the report can be easily adjusted to accommodate for payrolls changes. If you delete an old report, you will need to enter remittances again.
To change payroll thresholds, two columns must be changed to update your threshold exemptions and rate.
Step 1: Open Avanti Desktop and navigate to Vendor Remittance Setup.
By default, it is located in Canadian Payroll >> Installation & Maintenance.
Step 2: Select the remittance setup you would like to adjust by either double-clicking on the remittance.
Step 3: Select Columns.
Step 4: Select Column 5 by either double-clicking on the remittance form or selecting it and clicking Modify.
Step 5: Column 5 will change the exemption value. In Formulas, change F1’s value based on your threshold.
If your payroll is lowering to between $1,000,000.01 and $1,500,000 for the calendar year, change F1 to 1000000.
If your payroll is rising over $1,500,000 for the calendar year, change F1 to 0.
Step 6: The Visible Column will hide your exemption column. Change its visibility based on your new threshold.
If your payroll is between $1,000,000.01 and $1,500,000 for the calendar year, check the Visible Column.
If your payroll is over $1,500,000 for the calendar year, uncheck the Visible Column.
Step 7: Click OK.
That’s the first column changed. Now, for the next.
Step 8: Still in Columns, select Column 15.
Step 9: In Formulas, change F1’s value to the appropriate value. This will change depending on what import file you chose.
If your payroll is between $1,000,000.01 and $1,500,000 for the calendar year, your rate is 5.85%. Change F1 to C10 * 0.0585.
If your payroll is over $1,500,000 for the calendar year, your rate is 1.95%. Change F1 to C10 * 0.0195.
Step 10: Click OK, then OK again to finalise.
You will now be able to see your updated remittance amounts logged in Vendor Remittance.