AU JobKeeper Additional Automation for Weekly Pay Frequency

Overview


Updated 27/04/2020 Midday

Updated section 1d. To clarify, you should onlyĀ  "Override bank file date" DO NOT "Override Pay Date"


Infinet Cloud have now completed our second version of AU JobKeeper automationĀ with additional automation for weekly pay frequency only and your account has already been updated on 27/04/2020 to version 20.1.04 if you had already requested and received 20.1.03.


Due to time constraints this additional automation is only for weekly pay frequencies. This is due to the fact that additional complication exists with weekly pay frequencies whereby every week can impact the over week within the fortnight. The expectation is that once fortnightly or monthly pay frequencies have caught up any back pays forĀ  April, they will be processing single pay runs for each period.Ā 


Anyway we are doing our best and it is what it is. We hope it helps you. Thanks for your patience.

Please read all the guidance below fully, you should already be well familiar with our previous articles on JobKeeper and your responsibilities...

AU JobKeeper Automation Update

AU JobKeeper FAQ



On this page

1. Processing Back Pays for April:


  • The system will now apply additional logic to back pays for April for weekly pay frequencies. You should have already completed steps 1-6 from our original JK automation article.Ā AU JobKeeper Automation Update
  • You should include ALL nominated employees who earned under $1500 for each fortnight in your back pay adjustments. Even if they were not paid in all the weeks that require back pay. This is because they should have been included and we need to review each week and top-up accordingly so their pay is minimally $1,500 per fortnight and they are taxed on a weekly basis.Ā 
  • If you have already completed back pays for April for weeklies then you don't need to apply step 1 in this guide.Ā 
  • If you want to work out your own top-ups and do in a single pay run then that is up to you. You may need to use our "IGNORE JOBKEEPER" checkbox when recalculating and also manually adjust an employees tax if you pay this in a lump sum. Check with the ATO for guidanceĀ https://www.ato.gov.au/


1a. Initiate Pay run:


The system should now automatically include any employees who are nominated in the pay run initiate screen even if they don't have timesheets to process. E.g. Casuals who are set as "Pay from NetSuite time" wouldn't normally show. All nominated weekly employees need to be processed in payroll for all weeks of the JobKeeper payment. If the employee has already received over $1500 per fortnight then there is no need to include them in an adjustment pay run. You can check this first with the employee pay summary report as below.Ā 

Employee Pay Summary

To review an employees taxable income in a defined period you can use the "Employee pay Summary" report from the Pay Reports menu. Set the "Pay Date" filter to match one of the ATO defined fortnights. Eg. 30/3/2020 - 12/4/2020 would be fortnight 01



  • Start Pay run as normal for the first week of the JobKeeper defined fortnights. IE. Any pay run with a pay date of 30/3/2020 to 5/4/2020. Pay particular attention to the following.Ā 
    • Pay run type should be "Adjustment"
    • The period start and end dates and pay date should exactly match the prior period already processed.Ā  (The period start and end date need to match so we do the incremental tax and super calcs correctly. The pay date needs to match so we can compare the pay to the ATO defined fortnights and top up accordingly. You will override the bank file date before you pay the pay run after the calculations occur)
    • Untick "Accrue leave"Ā 
    • Tick "Use period data" (This will ensure Tax and Super calcs are incremental)
    • Tick "Skip Pay components"
    • Check the list of employees and make sure you have everyone who needs a top up.Ā 
    • Submit.


1b. Enter Employee time:


"Skip" this step....the employees Top-up will occur at "Process Payslips"



1c. Process Payslips:


Process payslips as normal for each period in the original order. The additional logic should create top-up's where required for each week of the fortnight.Ā  Please note the following.Ā 

  • Any top-up that occurs in the first week of a fortnight will ensure the total fortnight pay is not over $1,500 already and the taxable income does not exceed $750 if a top-up is required. This ensures the weekly tax is as correct as possible.Ā 



Week 1 PayĀ Week 1 top-up adjustmentWeek 2 payĀ Week 2 top-up AdjustmentComment
Pay Date Range30/3/2020 - 5/4/202030/3/2020 - 5/4/20206/4/2020 - 12/04/20206/4/2020 - 12/04/2020ATO defined pay date ranges for Fortnight 01

Employee 1

$0.00$750$0.00$750Employee not paid should get $750 per week
Employee 2$200$550$200$550Employee part paid under $750 per week so top-up occurs each week
Employee 3$900$0.00$500$100Employee part paid but under $1,500 for fortnight.Ā 
Employee 4$600$0.00$1,000$0.00Employee pay is already over $1,500 for period so not top-up occurs
Employee 5$0.00$0.00$1,600$0.00Employee pay is already over $1,500 for period so not top-up occurs


  • Review the payslips at "Approve Payslips" and proceed as normal with Posting Stage.Ā 


1d. Pay Pay run:


Because we set the pay date to match the original pay run (for calculation purposes) we now need to override that so we get the correct ABA. file and update the records to the correct pay date.Ā 

You need to:

  • "Override Bank file Date" to the date you are actually paying (DO NOT OVERRIDE PAY DATE, this will cause issues with your future pay runs)
  • Select Bank Account and reference note as normal
  • "Pay"
  • Compete pay run as normal including "Email payslips" as required.Ā 


1e. Repeat for each weekly pay run in April that requires back pay:


2. Normal Weekly Processing

  • You should ensure you have completed any back pays for April as per step 1. above.Ā 
  • The system will now apply additional comparative logic to processing for weekly pay frequencies. You should have already completed steps 1-6 from our original JK automation article.Ā AU JobKeeper Automation Update
  • You should include ALL nominated weekly employees in ALL your weekly pay runs. Even if they have no normal pay.Ā  This is because we need to review each week and top-up accordingly so their pay is minimally $1,500 per fortnight and they are taxed on a weekly basis.Ā 


2a. Initiate Pay run:


Ensure you include all nominated employees in each weekly pay run regardless if they have normal pay or not. Standard settings should apply.Ā 


2b. Enter Employee time:


Complete this step as normal. NB: Top-up will be added when processing payslips.Ā 

2c. Process Payslips:


Process payslips as normal for each period in the original order. The additional logic should create top-up's where required for each week of the fortnight.Ā  Please note the following.Ā 

  • Any top-up that occurs in the first week of a fortnight will ensure the total fortnight pay is not over $1,500 already and the taxable income does not exceed $750 if a top-up is required. This ensures the weekly tax is as correct as possible.Ā 

Ā Example below.Ā 


Week 5 PayĀ Week 5 top-upWeek 6 payĀ Week 6 top-upComment
Pay Date Range27/04/2020 - 03/05/202027/04/2020 - 03/05/202004/05/2020 - 10/05/202004/05/2020 - 10/05/2020ATO defined pay date ranges for Fortnight 03

Employee 1

$0.00$750$0.00$750Employee not paid should get $750 per week
Employee 2$200$550$200$550Employee part paid under $750 per week so top-up occurs each week
Employee 3$900$0.00$500$100Employee part paid but under $1,500 for fortnight.Ā 
Employee 4$1600$0.00$0.00$0.00Employee pay is already over $1,500 for period so not top-up occurs
Employee 5$600$150$1,000-$150Employee pay goes over $1,500 for period so top-up from first week is reversed in second week


  • Review the payslips at "Approve Payslips" and proceed as normal with all other stages.Ā