Company: Link Technologies
Case No: L13001. Project: 15.20: LinkSOFT Version 15.20
Logged By: Sitla (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 13 Feb 2024 04:21PM
Priority: High
Product: Payroll & HR
Group: Enhancement
Time Taken: 33.00 (Weight: 8.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Sitla, Vineet
Resolve By: Thursday, 22 February 2024 07:41 PM [282 days since logged date]
Status: Closed
Subject: PAYE Output file for PayDay. 2024 Format Changes
Summary:    

Hi Sanjay,

During the budget announcement last year, SRT & ECAL were removed so FRCS has launched a new output file based on the new table settings we have.

We need to get the new file format out so that clients can lodge PAYE successfully.

This change is under the following menu:

Payroll Processing> Tax Submission> 


Step 1 - Update of Tax Table - ( User Maintained as per our instructions)

Chargeable Income ($)

Resident Individual

Non-Resident Individual

Income Tax ($)

Income Tax ($)

0 – 30,000

Nil

20% of excess over $0

30,001 – 50,000

18% of excess over $30,000

$6,000 + 20% of excess over $30,000

50,001 – 270,000

$3,600 + 20% of excess over $50,000

$10,000 + 20% of excess over $50,000

270,001-300,000

$47,600 + 33% of excess over $270,000

$54,000 + 33% of excess over $270,000

300,001-350,000

$57,500 + 34% of excess over $300,000

$63,900 + 34% of excess over $300,000

350,001- 400,000

$74,500 + 35% of excess over $350,000

$80,900 + 35% of excess over $350,000

400,001- 450,000

$92,000 + 36% of excess over $400,000

$98,400 + 36% of excess over $400,000

450,001- 500,000

$110,000 + 37% of excess over $450,000

$116,400 + 37% of excess over $450,000

500,001 – 1,000,000

$128,500 + 38% of excess over $500,000

$134,900 + 38% of excess over $500,000

1,000,001 +

$318,500 + 39% of excess over $1,000,000

$324,900 + 39% of excess over $1,000,000

Step 2 -  2024-Paye_Reg 6-Template - (Users use this table to identify if the software is making the right calculations as per the table in Step 1. 

Note: This is just a guide for us to use to ensure we are properly in compliance with the PAYE deductions.

Step 3: PAYE out Put File (This needs to be actioned from our end and applied to all Customer sites)

  1. Pay Day Reporting Manual Template -  Refer Attached
  2. Pay Day Reporting Template 2024 (Auto) - Refer Attached

Let me know if you need any other details.

Sitla.


Audit Notes:Edited by sanjay on 23/02/24 11:35. Edited by sanjay on 22/02/24 13:24. Edited by sanjay on 21/02/24 11:59. Edited by sitla on 13/02/24 16:21. 
13 Feb 202404:16PM Comment 1 by Sitla (Edge Business Solutions) Assigned To: Sitla (Edge Business Solutions) Followup Date: 14-02-2024 02:57 PM Notes: ETC extended from: 09/02/2024 to 14/02/2024

Hi Sanjay,

As discussed, I have attached the comparison file for both MAnula and Auto calculation on the payday reporting format.

Change is simple, just remove the 4 fields from Manual and 2 fields from Auto format.

I have removed the extra field columns from existing files to match with the 2024 file format and uploaded them for both formats and it was successfully accepted but the FRCS portal.

Figure 1: Manual Format


Figure 2: Auto Pay Day Format


Transfering this case to development.

Sitla.


13 Feb 202404:19PM Comment 2 by Sitla (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-02-2024 08:18 PM Notes: ETC extended from: 13/02/2024 to 16/02/2024

Hi Sanjay,

Appreciate a new File Format at the earliest, please.

Sitla.


15 Feb 202411:44AM Comment 3 by Sanjay (Link Technologies) Case L13001 added to project 15.20
16 Feb 202403:29PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sitla (Edge Business Solutions) Followup Date: 21-02-2024 07:08 PM Time Taken: 3.00

Hi Sitla, 

You havent clearly stated which File format needs to be changed. I have pasted the "Tax Submission" selection below. Can you confrm the two identified are the ones to be changed?

Also confirm the other formats remain un-changed.

Figure 1 - Tax Submission Formats



20 Feb 202401:48PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-02-2024 05:33 PM Time Taken: 12.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.20

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

  1. Removed ECAL and SRT from Manual and Auto File generation

3. Affected Areas:

  1. Tax Submission Attachment

4. The issue was caused by:

  1. Legislation Change

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


20 Feb 202403:55PM Comment 6 by Sitla (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 22-02-2024 07:41 PM Notes: ETC extended from: 16/02/2024 to 22/02/2024

Hi Sanjay,

Please do not replace the existing file formats but rather ADD the new file formats for 2024 uploads.
Older formats will still be used by clients for reconciliation and submission purposes.

Format Names for  new 2024 files

  1. Auto -PayDay Template 2024
  2. Manual Pay Day Template 2024

Regards,
Sitla.


21 Feb 202410:10AM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-02-2024 01:13 PM Time Taken: 6.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.20

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

  1. Added two options for Pay Day Reporting, PayDayManual2024 and PayDayAuto2024

3. Affected Areas:

  1. Tax File Submission

4. The issue was caused by:

  1. Legislation Change

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


PART B -
Development Reference (Place descriptor for objects changed)
:


Figure 1 - Integration for Pay  Reporting - Added Options



Figure 2 - Pay Day Reporting Formats available in "Tax File Submissions


21 Feb 202410:13AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-02-2024 02:11 PM Time Taken: 12.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create a Tax File submission for PayDay and PayDayManual (pre 2024 Format)
File format should not change
Pass

2Create a Tax File submission for PayDayAuto2024
Verify with new Pay Day Auto format
Pass

3Create a Tax File submission for PayDayManual2024
Verify with new Pay Day Manual format
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 15.20
  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


Attachments:
General Documents - Case: L13001:2024-PAYE-Reg-6-Template (reference Use Only).xlsx
Auto-Calculate Payday Report File Format Comparision Existing Vs. 2024.xlsx
Manual Pay Day Reporting file format Comparision Existing Vs. 2024.xlsx
PAYDAY_MANUAL-Calculation-2024.xlsx
PAYDAY-2024-template(Auto).xlsx
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L13001 in the subject line of all emails regarding this issue.

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