Changes to MOE Roll Returns for MSD Initiative

The New Zealand Ministry of Education  released a new specification for the Roll Returns on 7th May 2012. Schools were notified of these changes relating to Youth Services and the Ministry of Social Development.

The changes have resulted in additional field being added to the MOE file. These changes relate to provision of additional details on student contact details. Students have the right to request that these details not be released to MSD, in which case PCSchool will pass blank fields instead of the actual address data. Should a student wish their information withheld then schools will need to add this election to the Student User Defined area of PCSchool.

Tagging students to withhold address details

Schools will be required from time to time to submit a csv file to the MSD. This can be done at any time using the standard MOE Return routine. To create such a file go to Roll Returns and select a Roll Period of MSD.

Creating the MSD file

This facility is shipped in Scholastic Version 2011.2.0.655 or higher. The followup is available from here

Change to ESCT Processing for Payroll

Payroll  New Zealand

 Followup

Finance Version  2011.2.0.128

PCSchool has seen a need to alter the mechanism by which we calculate the ESCT tax deduction associated with Superannuation in New Zealand. In 2012 the IRD changed the method of calculation and we have made the changes to fall  in line with this. The calculation is based on a percentage deduction the rate determined by either a prior knowledge of the annual earnings for the previous 12 months, or on an estimated annual earning by extrapolating the current pay over a full year. This extrapolation has caused some inconsistencies where employees have varying earnings from on fortnight to the next and where ESCT is reported on a fortnightly basis. In the current version of PCSchool Payroll this calculation is performed at month end and the figure produced here may be at variance to the figures produced in individual fortnights. To avoid this we have change the calculation to a fortnightly basis and am now storing these calculations as transactions. When the IRD345 calculations are done they will merely collect the transactions for the pays through the month. This ensures consistency and also a permanent record of the calculation associated with individual pays.

In light of the new method of storing this data we have had to make some alterations to some of the payroll reports.

If an SQL School Download new SQL reports here  Extract the files to \pcschool\reports\sql on your server

If a Non SQL School Download new NON SQL reports here  Extract the files to \pcschool\reports on your server

For the most consistent calculation of ESCT you can record the estimated annual earnings of the employee over the previous 12 monts. This figure will be used to calculate the rate used in the ESCT calculation. This method is best used for employees where their wage per pay varies from pay to pay.

Setting an annual salary

As an interim measure we have provided you the means to recall pays for the year to date, since April 1st and to have PCSchool create the new ESCT Payroll transactions on these payments. This will ensure that the new reports will be able to find suitable transactions for these pays that preceeded this change. This method is only an interim measure and only needs to be performed on pays run prior to installing this update. Pays generated in the future will have the ESCT automatically calculated.

Creating Back dated ESCT transactions

Reports will now be based on the actual ESCT transactions stored and you will be able to review or report on these transactions. Should you wish to have your customized payslips altered to show the ESCT calculated you will need to contact john@pcschool.net to get your report altered.

Review ESCT as a Payroll Transaction

Enhanced Attendance Audit Report for New South Wales Schools

Available Followup 2011.2.0.668  Release 27/5/2012

PCSchool has altered the NSW Attendance Audit report to bring it  in line with the 2012 audit requirements for roll marking. We have now added the absence status in the Roll Report.

Attendance Roll Report

The printout is laiunched via Absence & Behaviour Reports

Launching the report

You can download the report files at

For SQL clients   Download and extract the .rpt file to \pcschool\reports\sql on your server

For Non SQL Clients    Download and extract the .rpt file to \pcschool\reports on your server

If you don’t see the report as an available Report Style then you will need to add it as below.

Adding the Report Style

If you are running the SQL version of this report and it runs but comes up with no data then firstly check your selection criteria. If OK then you may need to update some report engine files. Download here  Should this step be necessary download the file and extract contents to C:\Program Files\PCSchool\Programs or the directory from which you are launching the PCSchool Admin program.

SportSCID and Other CSV File Outputs

Available Followup Curric Ver 2011.2.0.668 release 28/5/2012

PCSchool has altered the way NZ schools can produce their SPORTSCID file as well as generally enhancing the csv file production process.  To produce a csv file based on either a Student Tagset or based on the subjects studied go into Subject CSV.

Selecting Students to be included in file

Next Select the fields to be included in the csv.

Predefined formats exist for STAR and Gateway, SelNet and SPORTSCID

Selecting Fields

Click Begin to create file.

Result Entry Sensitive to Exclude from Reports option

Available in Spider Version 2012.04.30.xxx and above.

PCSchool has now made the Spider Result Entry control sensitive to the ‘Tag to Exclude from Reports’ option for the subject.

Subjects can be set as ‘Tag to Exclude from Reports’ in the System Functions – Curriculum Control Files – Subject Codes – Subjects tab:

There is then an option in the System Functions – System File Maintenance – Assessment Defaults tab to ‘don’t show Subject Excluded from Reports in Result Entry’:

Subjects set to ‘Tag to Exclude from Reports’ will now not appear in the Result Entry view in Spider or the Back Office:

 

NZ Payroll April 2012 Update

The IRD has altered the requirements associated Student Loan deductions and has removed the ESCT Exemption associated with Employer Contributed Kiwi Saver

For details of the IRD changes see  the Payroll Specification Document – Final V2.00

If you intend to apply this followup it is important that you have produced you IRD 345 and associated file for payrolls up to 31/3/2012 prior to installing the followup. This will ensure that the Kiwi Employer Super will not have ESCT applied to the initial 2%. Once this report and file has been produced then install the followup.

Changes to Student Loans

Employees can now elect to accelerate their Student Loan deductions as a % rate of their gross income. This option is only available to employees currently with the standard Student Loan deduction. The additional deductions can be from 1 to 5%, and is referred to as “SLCIR”. Contributions to this additional deduction must be tracked and reported separately in the EMS file submission. There has been a new field created in the employee record for this purpose.

Assigning SLCIR additional deductions

Employees may also elect to has an additional $ amount deducted from their pay and apply this to additional Student Loan payments. This is referred to as SLBOR and it too needs to appear separately in the EMS file submission. There has been a new field created in the employee record for this purpose.

Adding additional SLBOR as $ value

The IRD has initiated legislation that enables them to set an alternate rate for the collection of Student Loan from a specific employee. As shipped PCSchool has a single Student Loan Rate Table ie SFSS where the rate is 10 % provided the weekly threshold of $367 has been reached.

Standard Student Loan Table

Standard Student Loan Table

If the IRD issues alternate rates for a specific employee then this rate will need to be established as a table under the headings of either:

SFNTFE, SFSSFE or SFSSNT

Setting up an alternate Student Loan Table

Setting up an alternate Student Loan Table

For specific employees, where advised by the IRD, these alternate rate tables can be selected in the Employee View.

Selecting alternate Student Loan Rate Table

the tax calculations as below:

Displaying student load deduction types

Displaying student load deduction types

Changes to ESCT deductions and Employer Kiwi Saver


Previously the IRD allowed an exemption from ESCT  for the initial 2% of Employer contributed Kiwi Saver. This has now been removed and the ESCT will be calculated on the full amount.  While the PCSchool calculations now take this into account the IRD has also given the option enabling employees to elect to have this employer contribution to be added to standard salary and taxed accordingly. This method enables the Kiwi Saver contribution to be submitted to IRD as a gross amount as an Employee contribution in that the tax has ablreay been paid as part of the standard pay run.

To enable the automated processing of this latter option PCSchool has created a new type of Superannuation deduction namely KIWI/EMPT

Selecting the desired types of Superannuation

If employees elect to have their Employer Kiwi Saver added to normal pay and taxed accordingly, then they need to change the super type from KIWI/EMP  to KIWI/EMPT

The way that PCSchool handles this type of KIWI/EMPT is to give the employee an Allowance Before Tax (AB) equal to the % or $ rate specified (in the diagram above 3%). The employee will also be assigned a Deduction After Tax (DA) of the same amount. While these two additions will cancel out, so that the actual take home pay will not be impacted, the fact that one is an allowance Before Tax will increase the gross pay by this amount prior to the tax calculation being performed. This will increase that tax paid on the payroll. The subsequent Kiwi Saver deduction is assigned and reported as Employee contributed.

Payroll Preparation Report

Important: If using SLCIR or SLBOR you may find that some payroll reports are not sensitive to these new initiatives. If this is the case then contact the Help Desk to arrange for your reports to be modified.

If you intend to apply this followup it is important that you have produced you IRD 345 and associated file for payrolls up to 31/3/2012 prior to installing the followup. This will ensure that the Kiwi Employer Super will not have ESCT applied to the initial 2%. Once this report and file has been produced then install the followup.