Local Payroll EOY Enter all data onto this sheet and then
use the links below to move between
Reconciliation Data Entry worksheets to check reconciliations.
Reconciliation sheets can be printed
out and retained for school records.
If changes need to be made to data
School Name: return to this sheet and enter the
changes.
PAYG Year: eg. 2001/2002
Tax Reconciliation Data
Enter figures for PAYG payment totals for each month Note: All figures should be entered
into this worksheet as positives even
Obtain the figures from Finance 4,6,6 [A]ll PAYG periods if they appear as negatives on the
Schools paying tax quarterly, only enter figures for Sept. Dec. March and June CASES reports.
PAYG SLP Compulsory WH Voluntary WH
July
August
September
October
November
December
January
February
March
April
May
June
Total of 4,6,5 All creditors, Other, 1/7/xxxx - 30/6/xxxx
Enter School Total Tax - Payroll Program 1,5,1 Check Taxation Reconciliation
Enter School Total HECS - Payroll Program 1,5,1 Monthly
Enter any addition tax deducted - Payroll Program 1,5,1 Quarterly
Vic Super Reconciliation
Enter Creditor Totals from 4,6,1 Invoice
Credit Notes
Total Outstanding Invoices 4,7,2 by Creditor Vic Super
Enter VicSuper Total from Payroll Program 1,5,1 Check VicSuper Reconciliation
Deduction1 Reconciliation
Enter Creditor Totals from 4,6,1 Invoice
Credit Notes
Total Outstanding Invoices 4,7,2 by Creditor Deduction1
Enter Deduction1 Total from Payroll Program 1,5,1 Check Deduction1 Reconciliation
Deduction2 Reconciliation
Enter Creditor Totals from 4,6,1 Invoice
Credit Notes
Total Outstanding Invoices 4,7,2 by Creditor Deduction2
Enter Deduction2 Total from Payroll Program 1,5,1 Check Deduction2 Reconciliation
Deduction3 Reconciliation
Enter Creditor Totals from 4,6,1 Invoice
Credit Notes
Total Outstanding Invoices 4,7,2 by Creditor Deduction3
Enter Deduction3 Total from Payroll Program 1,5,1 Check Deduction3 Reconciliation
Local Payroll EOY 0
Tax Reconciliation 0
Enter figures for PAYG payment totals for each month
Obtain the figures from Finance 4,6,6 [A]ll PAYG periods
PAYG SLP Compulsory WH Voluntary WH
July 0.00 0.00 0.00
August 0.00 0.00 0.00
September 0.00 0.00 0.00
October 0.00 0.00 0.00
November 0.00 0.00 0.00
December 0.00 0.00 0.00
January 0.00 0.00 0.00
To make changes to data February 0.00 0.00 0.00
return to the Data Entry March 0.00 0.00 0.00
sheet by clicking here April 0.00 0.00 0.00
May 0.00 0.00 0.00
June 0.00 0.00 0.00
Total for PAYG Period 0.00
Enter total of 4,6,5 - All creditors, Other, 1/7/xxxx - 30/6/xxxx 0.00
Enter School Total Tax - Payroll Program 1,5,1 0.00
Enter School Total HECS - Payroll Program 1,5,1 0.00
Enter any addition tax deducted - Payroll Program 1,5,1 0.00
Variance 0.00
Local Payroll EOY 0
Deductions Reconciliation 0
Vic Super
Enter Creditor Totals from 4,6,1 Invoice 0.00
Credit Notes 0.00
Enter Total Outstanding Invoices 4,7,2 by Creditor Vic Super 0.00
Enter VicSuper Total from Payroll Program 1,5,1 0.00
To make changes to
data click here
Variance 0.00
Deduction1
Enter Creditor Totals from 4,6,1 Invoice 0.00
Credit Notes 0.00
Enter Total Outstanding Invoices 4,7,2 by Creditor Deduction1 0.00
Enter Deduction1 Total from Payroll Program 1,5,1 0.00
To make changes to
data click here
Variance 0.00
Deduction2
Enter Creditor Totals from 4,6,1 Invoice 0.00
Credit Notes 0.00
Enter Total Outstanding Invoices 4,7,2 by Creditor Deduction2 0.00
Enter Deduction2 Total from Payroll Program 1,5,1 0.00
To make changes to
data click here
Variance 0.00
Deduction3
Enter Creditor Totals from 4,6,1 Invoice 0.00
Credit Notes 0.00
Enter Total Outstanding Invoices 4,7,2 by Creditor Deduction3 0.00
Enter Deduction3 Total from Payroll Program 1,5,1 0.00
To make changes to
data click here
Variance 0.00
Local Payroll EOY 0
Tax Reconciliation 0
Enter figures for PAYG payment totals for each quarter
Obtain the figures from Finance 4,6,6 [A]ll PAYG periods
PAYG SLP Compulsory WH Voluntary WH
July - September 0.00 0.00 0.00
To make changes to data October - December 0.00 0.00 0.00
return to the Data Entry January - March 0.00 0.00 0.00
sheet by clicking here April - June 0.00 0.00 0.00
Total for PAYG Period 0.00
Enter total of 4,6,5 - All creditors, Other, 1/7/xxxx - 30/6/xxxx 0.00
Enter School Total Tax - Payroll Program 1,5,1 0.00
Enter School Total HECS - Payroll Program 1,5,1 0.00
Enter any addition tax deducted - Payroll Program 1,5,1 0.00
Variance 0.00