i cannot finalise my year in STP(does not balance to employee's YTD) and to be perfectly frank i've mucked it up trying to fix it & confused myself in the process.
I paid a staff member's April pay on 1/5 - $640, i paid their May salary on 31/5 ( I have been overseas until last week & only just realised my mistake).The May Salary was overpaid as it picked up the April salary ($640) paid on 1/5 as i used Payroll totals for May rather than running payroll totals only for 2/5 - 31/5. I exported STP for 1/5 & 31/5 so what has gone through to the ATO is correct. However i overpaid the $640 in the May pay so could not reconcile May in Reckon.
When i created the payslip for the employee i put in the hours she had worked for May (83.75 hours) but paid her based on the Nett pay on the Payroll Totals report which was an extra 16 hours (99.75 hrs). I did not realise at that point that when i created the payment (for the 83.75hrs) that this was the amount that would appear in my reconcilliation and not the amount that was actually paid to her through the bank account - hence why i could not balance May.
With approval from the employee i adjusted her June salary by the 16 hours overpaid - she had worked 148 hours in June and i paid her for 132 hours. So far so good except that i could not reconcile June (still out by $640). I then realised that the extra payment ($640 - 16hrs)) that had gone through my bank account did not match the payslip generated on the 31/5 (for 83.75hrs). As far as the employee was concerned we were all balanced which was good.
So i decided the best way to reconcile the balance was to go back into the May payslip and adjust it to reflect what had gone through the Bank account. This enabled me to reconcile June in Reckon. I thought all was ok as i had previously exported the 31/5 May STP, however when i checked the finalise year amount it had now updated to reflect the adjusted 31/5 payslip which means that when it gets exported to ATO it will not reflect the correct YTD Gross pay.
I've really confused myself and not sure how to fix it!!
Any help at this point would be most appreciated.