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

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

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

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
****************************************

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

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

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