Company: Link Technologies
Case No: L12547 Project: 13.10: LinkSOFT version 13.10 - Improvements and stabilisation.
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 02 Sep 2021 02:39PM
Priority: Medium
Product: Payroll & HR
Group: Enhancement
Time Taken: 8.00 (Weight: 10.00)
Version: 13.10.1011
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: 10 Oct 2021 [48 days since logged date]
Status: Closed
Subject: Variance in the "Tax Reconciliation Report" for the YTD pay.
Summary:    

Variance in the "Tax Reconciliation Report" for the YTD pay.
Setup

  1. Employee E069 has an annual pay of $65000. The employee does not qualify for SRT and ECAL.
  2. However, when we upload the YTD figures for the employee, the "Tax Reconciliation Report (Fiji PAYE >= 2013)" shows variances for SRT and ECAL. Refer to Figure 1.
  3. It seems like the system assumes that the uploaded "Normal Hours" is standard for the employee. Is there a way we can eliminate or justify the variance to the clients?

Environment Details

  1. Server - QA4
  2. Database - UAT-LINSKOFT
  3. Version - 13.01
  4. URL - http://10.0.0.13/LinkSoft

Figure 1: Tax Reconcilation Report

Audit Notes:Edited by sanjay on 13/10/21 10:49. Edited by sanjay on 11/10/21 16:32. Edited by sanjay on 07/10/21 14:04. Edited by sanjay on 07/10/21 14:03. Edited by sanjay on 07/10/21 14:02. Edited by sanjay on 05/10/21 08:24. Edited by sanjay on 02/09/21 14:39. Edited by sanjay on 02/09/21 14:11. 
02 Sep 202102:36PM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Follow up Date: 03/09/2021 Time Taken: 1.00

Development Meeting: Sitla, Rashna, Vineshwar, Alvis, Sanjay


Notes:

  1. The report is designed to identify any issues on individual pay runs. If the YTD bulk figure is updated, this variance will exist in the pay year
  2. Options:
    1. Add notes to this report to explain why there is a variance when Opening Balance is uploaded - Rashna
    2. Look at adding an "Opening Balance" Upload - Sanjay
    3. Upload individual pay history data

09 Sep 202102:10PM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Follow up Date: 10/09/2021 Time Taken: 1.00

Hi Alvis,

Update the report section in the report (we want this to be part of printed copies for management reporting) to include:

  1. "Actual Tax" is the tax calculated in LinkPAY. This is updated in all payroll reports.
  2. "Tax Table" is the expected tax based on the FRCS formula.
  3. The "Variance" needs to be investigated before a "Normal Pay" is updated. 
  4. There will always be a variance for a "Year to Date" pay. This is because the uploaded "Gross" is a cumulative sum of history pays which is used as the input for the "Tax Table" calculations. 

Thanks
Rashna


13 Sep 202102:48PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Follow up Date: 14/09/2021 Time Taken: 1.00

Hi Rashna,

I have written the first three items as discussed. Please review.

Can you add the 4th item again considering the following:

  1. We cannot say "There will Always" be a variance
  2. The Gross upload needs to be used correctly, if a bulk figure I uploaded, the system correctly shows a variance.

**************************************
Hi Alvis,

Add the following notes to the "Report Notes" section on the report header:

  1. "Actual Tax" is the tax calculated when a Pay is processed in LinkPAY. This tax is shown in all Payroll reports.
  2. "Tax Table" is the expected tax amounts based on the configured Tax Tables in LinkPAY
  3. The "Variance" needs to be investigated before a "Normal Pay" is updated. 

Thanks
Rashna
****************************************


30 Sep 202110:20AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Follow up Date: 01/10/2021 Time Taken: 1.00

Hi Sanjay, 

The 4th statement can read: 

  1. In a case where cumulative gross (YTD) is uploaded, the report will reflect a variance. This is correct as the uploaded gross is not the standard pay for the employee. 

Thanks
Rashna


05 Oct 202108:24AM Comment 5 by Sanjay (Link Technologies) Case L12547 added to project 13.10
05 Oct 202108:38AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Follow up Date: 10/10/2021 Time Taken: 2.00 Notes: ETC extended from: 03/09/2021 to 10/10/2021
PART A - Development work for this case has been completed.

1. The change will be available in version:13.10

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. Added report description as requested.

3. Affected Areas:

  1. Tax Recon Report

4. The issue was caused by:

  1. Improvement to report variance

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation):UAT


05 Oct 202104:50PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development (Link Technologies) Follow up Date: 06/10/2021
Assigned to Development fot Testing

06 Oct 202101:19PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Follow up Date: 07/10/2021 Time Taken: 2.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1Generate Tax Reconciliation Report (Fiji PAYE >= 2013) for full-year 2021 and confirm Text displays
Pass
 

Environment Details

  1. OS version: Win10
  2. Application version: 13.31
  3. Setup on:
    1. Server:LinkQA4
    2. Database: LINKSOFT
    3. LinkSOFT URL: HTTP://10.0.0.14/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


07 Oct 202102:02PM Comment 9 by Sanjay (Link Technologies) ETC was changed from 10/10/2021 to 10/10/2021
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12547 in the subject line of all emails regarding this issue.

Document size: 122.5 KB
For call complaints, please contact the Managing Director of the company using this form