ipayroll.co.nz

Reporting

Reporting in iPayroll® is very flexible. There are a number of standard reports available, that contain many powerful features.

Reporting Groups

Reporting Groups are a powerful feature that allow you to set up your own table-driven reporting fields for your personal files. Once you have set up your reporting groups, and recorded them against each person you can produce a range of Human Resource Reports.

Additional Details

Select an item to find out more about it:-

Payroll Reports

Statutory Reports

Your Reports are divided into these categories:-

x

Tips

  1. We recommend that you remove the page headers and footers that are displayed by your browser by Choosing "Page Setup..." from the "File" menu in your browser.
  2. Some Reports (e.g. the Leave Calendar) require that background colors and images are printed. Select "Tools|Internet Options..." in Internet Explorer, select the "Advanced" tab and make sure that the "Print background colors and images" option is checked.
  3. If you find yourself running the same reports on a regular basis, add them to your Favorites menu in Internet Explorer.
  4. Some versions of Internet Explorer crash when opening Microsoft Excel files. Configure them to always open in a new window. Run Windows Explorer, select menu entry "Tools | Folder Options...", select the "File Types" tab, select the "Microsoft Excel Worksheet" (XLS) item, select the "Advanced" button, and make sure that the "Browse in same window" checkbox is not checked.

Payroll Reports
ipayroll.co.nz


Payroll Reports

Detailed help is available for these reports:-

General Ledger
Payroll Control
Payroll History

Overall there are a number of standard payroll reports, to let you analyse and report many details about your payroll payments.

Payroll Reports

Payroll Control  Payroll Reconciliation / Summary
Payroll Hours  Payroll Hours Worked Summary
Payroll Summary  One line summary for every person paid
Payroll Transaction List  List of all Timesheet Transactions
Payslips  Payslips (those differing from the Timesheet Template)
Payslips (All)  Payslips (print all, even if same as the Timesheet Template)
Schedule - All Payments  Schedule of all Payments
Schedule - Bank Pays  Schedule of Bank Payments
Schedule - Cash Pays  Schedule of Cash Payments
Schedule - Cheques  Schedule of Cheque Payments
Schedule - Deductions  Schedule of Deduction Payments
Schedule - GSF Interface  Schedule of Govt. Super. Fund Employee Deductions
Schedule - Overpayments  Identifies all Overpayments raised in a Payroll
Schedule - SSRSS  State Sector Retirement Savings Scheme
Schedule - Super Subsidies  Schedule of Superannuation Subsidies

General Ledger

If you are using Costing, you may wish to produce an electronic file of accounting transactions to load directly into your General Ledger program.

To use this feature:-

  1. Set up Costing
  2. Set up Account Codes
  3. Review your General Ledger Report.
  4. Follow the instructions in General Ledger Interface to download the interface file to your computer.

Payroll Control

The Payroll Control Report provides an overall reconciliation of your payroll. This report is the starting point for getting an overview of your payroll, and contains a number of links that you can follow to explore other reports. This is a very handy feature, try it now!

The report is broken into three sections:-

  1. The Total Value of this payroll:-
    Processing Fees, Superannuation Subsidies and Gross Pay.
  2. Total Deductions, broken down into:-
    Pre-Tax Deductions, Tax, Superannuation, Standard Deductions and Remaining Pay
  3. Total Payments showing all amounts to be paid by various methods:-
    Bank, Cash , Cheque and Tax Payments.

Payroll Control

Angling Adventures (Demo)

Pay Day: 17-Feb-2012 (Friday)
Total Value of Payroll     $1,243.29
Processing Fees Invoiced   $13.17  
Superannuation Subsidies (Gross) $24.12
KiwiSaver $24.12
Gross Pay Costed $1,206.00
Ordinary Time Worked $1,206.00
 
Total Deductions     -$1,243.29
Processing Fees Invoiced -$13.17
Tax Deductions and Donations -$290.48
PAYE -$197.95
Tax Credits (Payroll Giving) $3.33
Donations (iPayroll Giving) -$10.00
Student Loan SLD -$19.90
KiwiSaver KSE -$41.84
KiwiSaver Employer Contribution KSR -$24.12
Remaining Pay Deductions -$939.64
 
Total Payments to be Made     -$1,243.29
Direct Debit to iPayroll     -$1,243.29
Bank Schedule  Tip  -$952.81
Processing Fees -$13.17
Bank Deductions -$939.64
Tax Schedule -$290.48

Payroll History

The Payroll History Report provides a one line summary of each payroll. This report is the starting point for getting additional details about each payroll, including the ability to print copies of old reports.

Payroll History

Angling Adventures (Demo)

1. For Pay Days From:
  To:  
     
 
2. Select the appropriate "Reports" link for Historical Payroll Reports  
Pay Day Total Hours People Taxable Pay Non-Tax Allows Gross Pay Tax Dedns Donations Tax&Donations Nett Pay Fees  More...
17-Feb-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
10-Feb-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
3-Feb-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
27-Jan-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
20-Jan-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
13-Jan-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
6-Jan-2012 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
30-Dec-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
23-Dec-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
16-Dec-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
9-Dec-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
2-Dec-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
25-Nov-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
18-Nov-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
11-Nov-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
4-Nov-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
28-Oct-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
21-Oct-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
9-Sep-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
2-Sep-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
26-Aug-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
19-Aug-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
12-Aug-2011 80.00 2  $1,206.00 $0.00 $1,206.00 -$256.36 -$10.00 -$266.36 $939.64 $13.17  Reports
TOTALS - - $27,738.00 $0.00 $27,738.00 -$5,896.28 -$230.00 -$6,126.28 $21,611.72
 
KSR: -$554.76 -$554.76  
Tax Totals:  Tip -$6,451.04  Tip -$230.00  Tip -$6,681.04  

x

Tips


ipayroll.co.nz
Statutory Reports
ipayroll.co.nz

Statutory Reports

Select an item to find out more about it:-

Department of Statistics
Housing
Work and Income NZ

Department of Statistics

To complete Quarterly Employment Survey, go to your Quarterly Survey report.

Enter the appropriate details and press the Go button.

For example, here is the report for Angling Adventures (Demo):-

Quarterly Survey

Angling Adventures (Demo)

Notes:

Pay Date:
Workplace:
Pay Period: week fortnight month other→
Men Women
Number of Working Proprietors 1      0     
Number of Full Time Employees 0      1     
Number of Part Time Employees 0      0     
Ordinary Time Payout $0.00 $566.00
Ordinary Time Hours in Pay Period 0.00 40.00
Overtime Payout $0.00 $0.00
Overtime Hours in Pay Period 0.00 0.00

Casual Staff

Note that casual staff will be excluded from this report if they haven't been paid in the selected period. A person will only be counted if they have some hours worked, or some taxable pay.

Housing

To display information for a Housing New Zealand Income Statement, select the person from your Personal Files, select the 'Payroll History' entry from the sub-menu, and then the 'Housing NZ Income Statement' link.

For example, here is the report for MATTHEWS, John William in Angling Adventures (Demo):-

 
1. Copy details onto a Housing NZ Income Statement form

INCOME STATEMENT

for Wages, Salaries and Accident Compensation
 
1.  EMPLOYEE CONTACT DETAILS (employee to complete)
Employee last name Matthews
Employee first names John William
Home address Queenstown
NEW ZEALAND
 

EMPLOYER TO COMPLETE

 
1. EMPLOYMENT DETAILS (employer to complete)
Employer's organisation name Angling Adventures (Demo)
Employer's postal address P O Box 12345
Queenstown
NEW ZEALAND
 
2. INCOME DETAILS
In the last 52 weeks, the employee was employed
full time   part time   casually (PLEASE TICK ONE)
for the period 11-Feb-2011 to 10-Feb-2012
Pay Periods: weekly   fortnightly   4 weekly   monthly
 
3. During this period they earned
Gross ordinary pay $14,080.00
Overtime $0.00
Other payments and allowances $0.00
Sub-total $14,080.00
less PAYE $-2,336.40
Net pay $11,743.60
 
4. Last pay
The last pay made to this employee was for the period
  -   -     to 10-Feb-2012
PLEASE TURN OVER

5. Details of this last pay are:
Gross ordinary pay $640.00
Overtime $0.00
Other payments and allowances $0.00
Sub-total $640.00
less PAYE $-106.20
Net pay $533.80
If the last net pay is not the normally expected net pay for each pay period (as shown in section 2) please summarise why:
 
 
 
Normally expected net pay: $533.80
 
6. Does the employee receive any fringe benefit?
No Yes (please complete the details below)
TYPE OF FRINGE BENEFIT GROSS VALUE TO EMPLOYEE PER PAY PERIOD
   $
   $
 
7.  Your contact details are?
Employer Contact webmaster@iPayroll.co.nz Date 10-Feb-2012
Phone Number  
Employer's signature  
 

Work and Income NZ

To display information for Work and Income Information Requests, select the person from your People, and select the 'Payroll History' entry from the sub-menu.

Note: We have seen many different requests, in different formats, from Work and Income, so we can't provide a standard report to suit their exact requirements.

See the Work and Income NZ website.


ipayroll.co.nz

ipayroll.co.nz