Subject: | Payroll Tax Calculations for "Additional Tax" does not work. Tax scales are based on Country Specific Pay Codes |
Summary: | Payroll Tax Calculations for "Additional Tax" does not work. Tax scales are based on Country-Specific Pay Codes. This was done as each country had specific requirements. We are changing this design so that the system can be configured to each country-specific requirement without hard-coding the codes. Proposed changes are: - Use the "tax scales" allocated to Employees to determine Payroll tax
- Store the breakdown of each tax code used in the "Pay Detail -> Transactions" table
- Refactor the tax calculation formula to break it into smaller testable units
- Remove hardcoded rules for FPAYE, FPAYESRL, FPAYEOTH and FPAYEECAL
Important Notes: - Customisations are not part of this process. Each customer-specific customisation will need to be tested during the trial upgrade. We do not expect there to be any issues arising from customer-specific customisations as they are Paycode specific and the configuration would not change.
- Upgrade scripts will autocorrect customer setup, however, we recommend consultants review the change and verify this during the trial upgrade
- OLD country-specific Reports utilising specific Pay Codes will not be changed as these are rarely used and the values s not expected to change since the pay codes are already setup
For all Upgrades - please ensure you perform the Trial Upgrade and verify any customisations and calculations to match with required values. |
Audit Notes: | Edited by sanjay on 05/08/21 11:24. Edited by sanjay on 05/08/21 11:24. Edited by alvis on 23/07/21 14:22. Edited by alvis on 23/07/21 14:10. Edited by alvis on 23/07/21 14:10. Edited by sanjay on 23/07/21 11:54. Edited by sanjay on 23/07/21 11:53. Edited by sanjay on 23/07/21 09:30. |
23 Jul 2021 | 11:53AM Comment 1 by Sanjay (Link Technologies) ETC was changed from 30/07/2021 to 30/07/2021 |
23 Jul 2021 | 05:02PM Comment 2 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-07-2021 10:58 PM Time Taken: 2.00 |
| The following has been completed: - Added company ID separation to payroll tax maintenance
- Data migration to cross apply the data to all companies
- Changed tax maintenance dependencies to refactor and use company separation.
Next Step:' - Remove hardcoding of tax codes in pay calculations
- Show breakdown of tax calculation in payroll using the main and additional tax setups.
|
|
05 Aug 2021 | 11:12AM Comment 3 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-08-2021 02:47 PM |
| The following areas are hardcoded to use paycodes: FPAYE, FPAYEOTH, FPAYESRL, FPAYEECAL - FRCS Employee PAYE Certificate
- Fiji Tax Reconciliation Report > 2012
- FRCS Tax Submission Output File
- Papua New Guinea Tax Report
- Fiji Tax Reconciliation Report < 2012
- Samoa Tax Report
- Australia Tax Report by State
|
|
06 Aug 2021 | 12:06PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 06-08-2021 05:48 PM Time Taken: 75.00 |
| Hi Rashna, can you run the Fiji Payroll verification on this version to confirm the calculations.
In addition, please note the following for testing: - Superannuation Fund - Menu: "Payroll and HR Maintenance ~> Superannuation Fund". Changes are:
- Added a DEFAULT option. This option will allow users to automatically ADD super funds to new employees. Previously this was handled through configuration
- Added Pay Code Mapping. When creating a Superannuation Fund, the 5 entries are automatically created and allocated a Pay Code with the relevant abbreviations. Default Contribution Percentages are also allocated.
- User has the option to EDIT a Fund Paycode and select the option to "Update all Active" employees
- Changes to menu "Employee Profile ~> Employee Pay Setup"
- Added Superannuation "Super Details" where each employee can have different amounts for Super Contribution
- Super settings have been removed from the Employee Profile and allocated at Employee Pay Setup
- Primary Tax is available at Employee Profile, and additional tax has been moved to the Detail Level
- Changes to Pay Calculations
- Payroll Tax is based on Tax Scales located at Employee Profile level, Plus any additional Tax setup on the employee Profile
- Super is calculated based on Standard Pay and can be amended in the Current Pay
- All HARD CODING of Pay codes for SUPER has been removed. Pay codes are used purely from the configurations
- All HARD CODING of TAX Scales has been removed. Tax scales are used purely from the configurations
- Pay Processing will display the tax breakdown for each tax scale
- Pay processing will display a line for each Super contribution
|
|
06 Aug 2021 | 12:59PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-08-2021 06:06 PM Time Taken: 4.00 |
| Additional Notes - Upgrade scripts will convert the relevant Super and Tax setup for existing clients
- Fiji Payroll Reports requiring specific Tax Codes and Super Codes have not been changed. These are Statutory reports and will be re-designed in the next release. This will not affect report content
|
|
13 Aug 2021 | 04:27PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 06:50 PM Time Taken: 3.00 |
|
The following tests were performed: Table 1 - Test Results
# | Test Case Details | Pass/Fail | Comments | 1 | - Create an employee profile and set the superannuation as below
- Employee contribution - 8 %
- Employer Contribution - 10 %
- Employee Access - 2 %
- Employer Access - 3 %
| Pass | | 2 | - Create standard pay and validate that the super components are included
| Pass | | 3 | - Employee rate is 35000, validate PAYE of $76 is deduction in the standard pay
| Pass | | 4 | - Add a fringe benefit to the standard pay with a value of $20. The fringe benefits tax should calculate to $5.00
| Pass | | 5
| - Validate that the standard details are correct
| Fails
| The "Deductions" and "Net Pay" on the screen is incorrect | 6
| - Create the normal of the employee and verify the pay details
- Update Pay
| Pass
|
| 7
| - Test below items:
- PAYE Reconciliation Report
- Superannuation Report - Validate all 4 components from 1 above are included in the pay.
- Tax Submission File
- Super Submission File - Validate all 4 components from 1 above are included in the pay.
| Pass
|
| 8
| - Test the PAYE scenarios for Fiji Accreditation
- Tested pay 1 and 2
| Pass
|
| Environment Details - OS version:
- Application version: 12.51.0812
- Setup on:
- Server:LinkQA4
- Database: LINKSOFT-DEMO-RASHNA
- LinkSOFT URL: HTTP://10.0.0.13/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Review
|
|
16 Aug 2021 | 08:06AM Comment 7 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-08-2021 02:04 PM Time Taken: 1.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version:12.51.0813 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Corrected the deduction summary in standard pay menu
3. Affected Areas: - Standard pay
4. The issue was caused by: - coding refactor
5. Other Relevant Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT
|
|
16 Aug 2021 | 08:14AM Comment 8 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 16-08-2021 02:11 PM Time Taken: 1.00 |
|
The following tests were performed: Table 1 - Test Results
# | Test Case Details | Pass/Fail | Comments | 1 | - Validate the "Standard" pay for employee E001.
- Verify that the "Total, Deductions, and Net Pay" are correctly calculated.
| Pass | | Environment Details - OS version:
- Application version: 12.51.0813GA
- Setup on:
- Server:LinkQA4
- Database: LINKSOFT-DEMO-RASHNA
- LinkSOFT URL: HTTP://10.0.0.13/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: - Documentation
|
|
16 Aug 2021 | 02:29PM Comment 9 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-08-2021 08:22 PM Time Taken: 4.00 |
| Documentation completed and published. |
|