Hi Vineet,

Further to the discussion, when comparing our Pay Day Reports Taxable components to that of Pay Analysis, PayCode Accumulator and Pay History, there are big variances. This is happening for most months. Below is an analysis that I did for one month

We need to lodge our Levy which is based on Gross submitted to FRCS and we really need to know what is correct. Seek your teams urgent assistance.

We have done the following checks from our end:

1. Verified the Classification of all components that have been tagged Normal and Bonus. These are the only 2 columns in the report giving the sum.
2. Verified the pay classification for each pay code
3. Levy report gross is also showing Gross payable for levy as   2,316,290.90. However, the levy is based on gross submitted to FRCS hence needs to identify this discrepancy in total.

The difference between Gross in Pay Analysis, Pay Code Accumulator, Levy Report, and Gross submitted to FRCS is overstated by  $27,136.40. This total is not a direct sum of any component.

We will diagnose this with our development team and let you know by this afternoon

Regards
Vineet Ram
222 0085

Bula Sanjay

The setup details for this as below:

URL:             http://10.0.0.18/XXX/
Credentials: Default admin credentials
Version:      13.40
Server: QA8
Database: LINKSOFT-XXX-Training

For the purpose of this case, we will generate: 

1. Pay Analysis
   1. Company: 1001
   2. DateFrom: 01/01/2022
   3. DateTo: 31/01/2022
   4. ReportLevel: Hide Employees
   5. Gross+Taxable Allowance = 2316290.90
2. PayCode Accumulator Levy
   1. Company: 1001
      
   2. DateFrom: 01/01/2022
      
   3. DateTo: 31/01/2022
      
   4. ShowEmployee: N
      
   5. ShowDetails: N
   6. Gross+Taxable Allowance = 2316290.90
3. Pay History
   1. Company: 1001
      
   2. DateFrom: 01/01/2022
      
   3. DateTo: 31/01/2022
   4. Gross+Taxable Allowance = 2264752.91
      
4. Tax Employer Monthly Schedule
   1. Company: 1001
   2. DateFrom: 01/01/2022
      
   3. DateTo: 31/01/2022
      
   4. ConsolidateAllCompany: No
   5. TaxableGross: 2,343,427.30

For the period 01/01/2022 to 31/01/2022 and compare the Taxable Gross Figures in each of these reports.

Definition of Taxable Gross is (Gross+Taxable Allowance+ Cash Benefit + Excess Super Paid by the Employer in access of 10%). 

Problem: Gross submitted for Fiji Revenue and Customer Services as PAYE lodgement does not reconcile with Taxable Gross in Pay Analysis, PayCode Accumulator, and Levy Report. When Levy is lodged we use the Levy Report from the system, however, the Department of Levy calculates employers levy based on Gross submitted to FRCS. These 2 need to reconcile with each other for correct lodgement to both authorities.

Regards
Vineet Ram
222 0085

Hi Vineet,

I have tidied up comment 2 so it is easier to identify the reports and the issue. Which company is this for?.

Also, I checked the Gross calculations in DEMO and our calculations are correct. You have not stated the report parameters and expected values so I cannot verify this on CLIENT database yet.

Can you bring this to a meeting so we can discuss what the expected values are and what needs to be done next?

We can meet this afternoon, or send a meeting request for tomorrow morning at 10 am AEST or 2 PM aest whichever one suits you.

1. We are unable to replicate the issue in DEMO

Next Steps:

1. Provide details on how Gross and Taxable Allowance is calculated in the reports "Pay Analysis" and "Pay History" and why there is a difference - Sanjay
2. Provide a list of Components in this database that contributes to Gross and Taxable Allowance - Sanjay
3. Do a pivot analysis on "Pay Analysis" and "Pay History" to identify which employees have incorrect amounts - Vineet
4. Identify which amount is correct based on 3. above. - Vineet

Once we have the above 4 items we can work out the next steps.

Hi Vineet, in response to items 1 and 2 of comment 4, here is my response:

1. Both reports use the exact same functions to compute Gross and Taxable Allowances
2. The report uses User access to Employees, and I noticed that the "Admin" user on the report does not have access to all Pay Teams. This could be the reason for the difference

Can you give all Pay Teams access to the Admin user and review the report? 

Hi Vineet,

Here is a list of Pay Teams the ADMIN user needs access to:

1. CAS
2. CAS1
3. CREST
4. SAL
5. SALNU
6. SALO
7. TUCK
8. WAGEO

Bula Sanjay

With all pay teams' access provided to role administrators below is the analysis:

Levy Report Gross Total: 2,342,325.63
Tax Employer Monthly Schedule Report Total: 2,343,427.30
Difference: $1101.67

Regards
Vineet Ram

Hi Sanjay

Please disregard the Employee by Employee Analysis in comment 9. We did a lookup using the employee's name between the Levy report and Tax Employer Monthly Schedule however, there are many employees with the exact same name. This Analysis would be difficult for now unless we add Employee ID in the data grid view. However, there is a total difference of  $1101.67 between the 2 reports.

Regards
Vineet Ram
222 0085

Hi Vineet, The issue you are having is related to the Employees Tax ID. For testing purposes, I have updated the TAXID of the employees with the EMPLOYEE code. This now makes all reports line up,

These Tax Reports rely on the TIN No to be accurate and completed, therefore it is important to check this diligently.

We can do a team session to see what the issue is with TIN numbers and how we can make it easier to reconcile.

1. The change will be available in version:14.00 and 13.40.0531

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

1. Changed the report "Tax Employer Monthly Schedule" to allow the same Employee TIN No within one company and across multiple companies.

3. Affected Areas:

1. Report: Tax Employer Monthly Schedule 

4. The issue was caused by:

1. The function did not account for the same Employee TIN in Multiple companies with the same Company FTN

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

LinkSOFT 13.40.0531 PATCH is available at this link.

Bula Sanjay

I have done the test after applying the updates. Below is the result for the Year 2021. It reconciles for all months except March 2021 where the Tax Employer Monthly schedule is now understated by $947.36. The Taxable Gross for Pay Analysis, Levy, and Employee Payment History is reconciling now.

Figure 1.1 Analysis of the 4 Reports

The Filters used for the 4 rep

1. Pay Analysis
   1. Company: 1001
   2. DateFrom: 01/03/2021
   3. DateTo: 31/03/2021
   4. ReportLevel: Hide Employees
   5. Gross+Taxable Allowance = 1,765,565.02
2. Levy Report
   1. Company: 1001
      
   2. DateFrom: 01/03/2021
      
   3. DateTo: 31/03/2021
      
   4. Gross+Taxable Allowance = 1,765,565.02
3. Employee Payment History
   1. Company: 1001
      
   2. DateFrom: 01/03/2021
      
   3. DateTo: 31/03/2021
   4. Group By: Pay Calendar Year
   5. Gross+Taxable Allowance = 1,765,565.02
4. Tax Employer Monthly Schedule (Fiji)
   1. Company: 1001
   2. DateFrom: 01/03/2021
      
   3. DateTo: 31/03/2021
      
   4. ConsolidateAllCompany: No
   5. TaxableGross: 1,764,617.66

Please review what could have caused this and let me know so we can discuss this further

Regards
Vineet Ram
222 0085

Bula Sanjay

Comment 14 has been corrected with the dates of March 2021.

Thanks
Vineet

Hi Vineet, the difference is caused by TAX_NO "185958204"

Since this report groups by TIN No, when having employees with the same TAX_NO, they need to be exactly identical. 

I used this script to correct the data: 

-- UPDATE HR_EMPLOYEE SET TAX_ID = '185958204' WHERE EMPLOYEE_ID IN ('S0384','C0055', 'W0816')

Hi Sanjay

After this change, the reports for the Year 2021 are in reconciliation. If there are such data issues in the Year 2022, how can we handle them? Please do share so we can document and get the support team to handle these in the future

Regards
Vineet Ram
222 0085

1. The change will be available in version: 14.00

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

1. Added validation on TAX No to enforce AlphaNumeric characters only
2. On Save, any spaces before, after or in-between Tax number is removed
3. These changes have been made in the following areas:
   1. Employee Maintenance
   2. Applicant Maintenance
   3. Dependant Maintenance

3. Affected Areas:

1. Employee Maintenance
2. Applicant Maintenance
3. Dependant Maintenance

4. The issue was caused by:

1. Validation on TAX No required as Tax reports group by Tax No

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

Notes: You can use this script to correct any spaces on existing clients.   

UPDATE HR_Employee SET TAX_ID = [dbo].[LT_SYS_RemoveSpecialCharacters_fx](TAX_ID)

Environment Details

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

Next Step: Closure