ipayroll.co.nz

Organisation Set Up

When you set up an organisation you will be led through a series of steps to set up all the necessary information, people, tax options, etc. etc.

Most of the fields on the Organisation Set Up page are fairly self explanatory. Where necessary you can follow the links on that page for more information.

If you are setting up a new Organisation, you should go to the Getting Started page. (If you are setting up your own organisation rather than looking at our Sample Company, this page will contain a series of steps to follow rather than a story about our Sample Company).

Other useful help information to get you started includes:-

When setting up an organisation, you can also set up the following details:-

Account Codes

Account Codes are an optional feature that allow you to analyse your payments and deductions and transfer journals to a General Ledger (Accounting program), providing an electronic interface to your financial system.

Note: To use account codes, costing must be enabled. (In Angling Adventures (Demo), costing is currently enabled).

For an example of a journal see the sample GL Postings Report.

Setting Up Account Codes

Follow these steps to set up Account Codes.

  1. Review your Account Codes page, and enter the relevant account codes. (The full account code, as you wish to transfer to your financials package).
  2. For each account code that deductions will be posted to, Add a new Cost Centre using the account code as the cost centre code.
  3. For each deduction in your organisation, select the appropriate Account Code from the Cost Centre box.
  4. For each person, enter the account code against every relevant deduction in their Standard Timesheet.
  5. Check Set Up of all your GL Accounting Transactions.
  6. When you are processing a payroll, review the financial reports.

General Ledger Clearing Accounts

In your Account Codes page there are a number of Clearing Accounts that are used by the accounting features.

Payroll Clearing Note: Leave this account blank if you do not operate a Payroll Clearing Account in your General Ledger.

Enter the account code for your Payroll Clearing Account. The GL Postings will then contain an extra debit and credit transaction to this account. The credit will be for the total charged to each cost centre, and the debit will be the total of all deductions (including tax and nett pay, etc). These will almost certainly be for the same amount, leaving a balance of zero in your Payroll Clearing account. (Any residual balance will need to be investigated and cleared).

Bank Account This is a 'catch-all' account code for any bank deductions that do not have a specific account code specified.
Tax Account This is a 'catch-all' account code for any tax deductions that do not have a specific account code specified.
Cheque Account This is a 'catch-all' account code for any cheque deductions that do not have a specific account code specified.
Cash Account This is a 'catch-all' account code for any cash deductions that do not have a specific account code specified.
Employer's Superannuation Contribution (ESC)
DR: ESC Gross Enter the account code to charge superannuation subsidies to. Tip: If you leave this account code blank, superannuation subsidies will be charged to each persons default cost centre. This is useful if your organisation charges superannuation against each cost centre rather than to a single specific account.
CR: Employer's Superannuation Contribution Tax (ESCT) Enter the account code to credit the Employer's Superannuation Contribution Tax (ESCT) to. (See Superannuation Subsidy help for more information).

Note: This is part of the "contra" entry to ESC Gross. The remainder (i.e. the ESC Nett amount) is credited to the Cost centre defined on the ESC Deduction.

Overpayments Clearing Enter the account code to post any Overpayments Raised to.

Overpayments are raised when you reverse out transactions, (using a negative quantity on the timesheet), resulting in a net debt rather than a net pay to a person. (See Overpayments and Recovery for more information).

Cash Roundings Clearing Note: You can leave this account blank if you do not make any Cash payments.

If you make any Cash payments, the person pay will be rounded to avoid you having to handle small denominations. The amounts advanced for these cash roundings will be posted to this account.

Leave Provision Note: You must tick the "Post Leave Provisions" checkbox to enable this feature.

Leave Provisions can be posted on your GL Postings report if desired. Enter the Account Code to debit the leave provision to here. The credit entries will be posted to the account codes for your AL-ENT - Annual Leave Entitlement transactions.

Tax Split Note: Usually leave this account code blank. The Gross Pay will be credited to each cost centre.

Gross Payments debited to each Cost Centre can split between Nett and Tax amounts. Enter the Account Code to debit the tax split portion to here. (A template can be used to split the Tax to different cost centres). The Nett pay portion will still be debited to the accounts specified against each payment. The credit entries will be posted to the account codes for your Tax Deductions.

Tip: Generally, if you leave one of these accounts blank, any postings to that account will go to the Payroll Clearing Account instead. (However, read the description above for each account, as some have special rules).

Cost Centres

Costing is an optional feature thats allows you to track and report payroll costs in various categories called Cost Centres. The Costing features also allow the transfer of journals to a General Ledger (Accounting program), providing an electronic interface to your financial system.

Note: In Angling Adventures (Demo), costing is currently enabled

For an example of the various costing reports available, see these sample reports:-

Setting Up Costing

Follow these steps to set up Costing:

  1. For each cost centre that payments will be charged to, Add a new Cost Centre.
  2. For each payment in your organisation, enter the appropriate Default Cost Centre.
  3. For each person in your organisation, go to their personal file and set up their Cost Centre.
  4. For each person, also enter the cost centre against every relevant item in their Timesheet Template.
  5. When you are processing a payroll, review the costing reports.
  6. If you are interested in sending information to a financials program, or additional reporting options for costing deductions, please read the Account Code set up.

Costing Options

When you enter timesheets, a drop-down list of cost centres is displayed so you can easily pick the correct cost centre. However this can get unwieldy when you have lots of cost centres.

The Timesheet Input Method lets you change the timesheet entry page so that you can type in a cost centre instead of selecting it from the list. This can be much faster if you have lots of data entry. Using this option (called "Pop-Up Window"), you can still get a list of all cost centres by clicking the '...' link after the input box.

Deductions

You can set up your own special Deductions to supplement the many standard deductions that are set and and maintained for you by iPayroll®. Your own special deductions allow you to easily calculate and deduct any unique deductions that are used within your organisation.

Tip: Before setting up your own deduction, please check that no standard deductions already do what you need.

Adding a Deduction

To set up a special deduction follow these steps:-

  1. Go to your Deductions.
  2. Press the Add Deduction button.
  3. Enter a Deduction Code and Description.
    The Deduction Code appears in the drop-down list when you add transactions to timesheets. You should use a short, easy to type, code that you can remember easily. (If you are used to another payroll system that has deduction codes or numbers, you may like to use those for your deduction code).
  4. Press the Add Deduction button.
  5. Complete the information on the Deduction form and press the Save this Deduction button.

Information on a Deduction

Each Deduction contains a number of pieces of information that control how the deduction is calculated and paid.

Description Enter a description that will clearly describe to a person what this deduction is for. This is displayed on peoples timesheets and payslips.
Note: If you include %rate% in your description, it will be replaced by the transaction's rate on the person's payslip.
Calculation Rule Select the appropriate type from the list. This is the main way to determine how a deduction is calculated.
  1. For a deduction with a Fixed Rate, select use Rate Amount from Deduction and then enter the defined Fixed Rate in the Rate Amount box.
  2. For an ad-hoc deduction that varies each time it is set up against a person select use Rate Amount from Deduction, and then enter 0.0 in the Rate Amount box. (e.g. PBA - Personal Bank Account).
  3. For a calculation that depends on a percentage of a persons earnings, select the appropriate percentage Calculation rule from the list, and enter the actual percentage in the Rate Amount box.
  4. The PAYE and other Tax calc's options are reserved for standard deductions that are set up and maintained for you.
Rate Amount This entry depends on the Rate Type selected (above).
  1. For a Fixed Amount, enter the actual rate to make this deduction at - if it is always for a fixed amount. (e.g. Union Fees often have a fixed amount).
  2. For an Ad-Hoc Deduction, made at different rates, enter 0.0. (e.g. PBA - Personal Bank Account).
  3. For a Percentage based rate type, enter the percentage to apply, (e.g. enter 6.5 for 6.5%)
    tip To override the percentage on individual people, enter the Rate Amount as 1.0 and then enter the actual percentage for each person into the Quantity on their timesheet transaction.
Priority Leave this blank, and an appropriate priority will be generated for you. (You will only rarely have to change the default priority).

The priority determines the order in which deductions are calculated, paid and displayed on timesheets and payslips. This order is quite important for standard deductions - for example tax must be deducted at the appropriate point and a remaining pay deduction must be made right the the end. Fortunately, the order of your special deductions is not too important and you will often just accept the default priority.

If you are concerned about the order that deductions are made, review the priority numbers on your deduction page and change them as required. Priorities are significant when a person doesn't have enough pay to make all their deductions, ones with smaller priority numbers will be made first.

Payment Method Select an option to determine how the actual money for this deduction is paid.
  • Bank - Select this to include the deduction on the Bank Schedule. (Suggestion: Use this option whenever possible).
    Leave the Consolidate box empty - it should only be selected when a separate schedule is sent to the organisation receiving this money.
  • Cheque - Select this option if you prepare a cheque (or otherwise make payment outside of the payroll system) to send to the organisation receiving this deduction. The deduction will be reported on the Cheque Schedule.
  • Cash - This is reserved for the standard CASH deductions set up and maintained for you. these are reported on the Cash Schedule.
  • Tax - This is reserved for the standard Tax deductions set up and maintained for you. (e.g. PAYE - PAYE).
Bank Details Enter the Bank Account, Payee Particulars, Payee Code and Payee Reference required for this deduction. (Obviously this is only required where the Payment Method is Bank). This information will be available from the organisation you are making this deduction for.
Cost Centre Note: This is only displayed if you have the costing features turned on.
Select how this deduction is to be costed. You have four options:-
  1. Schedule - The deduction will be costed to the Bank, Tax, Cheque or Tax account code depending on the Schedule Method chosen (above).
  2. Fixed - Select here the cost centre that will always be used, (unless you override it when you are setting up a deduction on a timesheet).
  3. Template - This allows you to set up a rule that will direct the deduction to the appropriate cost centre, taking part of the code from the person's cost centre and the remainder from the template. Enter a ? in each position that should come from the person's home cost centre.
    For example, ????XYZ will construct a cost centre from the first 4 characters of the person's home cost centre, and append XYZ onto the end.
  4. None - Select this option and you will always be required to enter the cost centre setting up a deduction on the person's Timesheet Template. (Note: This option is not usually necessary, the other options can cater for almost all requirements).
Deduction Type Select the one that best describes this deduction:-
  • Tax - This is reserved for the standard tax deductions that are set up and maintained for you.
  • Super Subsidy - Select the appropriate option if this deduction is for a subsidised superannuation scheme. (If the scheme is not subsidised, use the 'Standard Deduction' option instead). For more information on superannuation schemes, subsidies and employer's superannuation contribution tax (ESCT), see the Superannuation Help.
  • Other - Select the appropriate option.
    • Standard Deduction - You will almost always use this for any special deductions that you set up.
    • Pre-Tax Deduction - This deduction will be made before tax is deducted (i.e. it will reduce the Taxable Pay).
    • Remaining Pay - This is used internally for the final Bank, Cash or Cheque deductions on a person's timesheet.
    • Donation (Payroll Giving) - This is a Payroll Giving deduction that pays an immediate tax credit back to the person
Allow Partial Deduction Tick this box if part of the amount should be deducted, even if the person doesn't have enough remaining pay to make the entire deduction. (Note: Always tick this for a reducing balance deduction, otherwise the final deduction made to clear the balance may not be made).
Reducing Balance Deduction Tick this box to make this deduction a Reducing Balance deduction.

These deductions require that you enter a Balance when setting up the deduction. The deduction will be made as usual, and the balance will reduce. When the balance reaches zero, the deduction will automatically stop. (Read the Tax Arrears help for an example of a reducing balance deduction).

Holidays Act 2003

iPayroll® fully complies with the Holidays Act 2003 (in force from 1-Apr-2004) and allows you to correctly calculate and record all entitlements, leave taken and payments.

What you need to do

Follow these steps to ensure you are complying with the Act
  1. Available Leave Pay Rate options Choose the appropriate Pay Rate when recording Leave - new options will be displayed when you enter a leave transaction on a person's timesheet. In essence, instead of striking an Annual Leave Average leave rate on a person's anniversary iPayroll® will now pay annual leave at the higher of the person's current rate and the average of the last 52 weeks earnings.
  2. Note that as Angling Adventures (Demo) appears to have Less than 12 months history the Annual Average Pay Rate will only be an average across the history recorded in iPayroll®. (You can still use the annual average option when recording Annual Leave).
  3. Use the appropriate Bonus payment code (BON - or BON2 - ) when making Bonus payments to ensure the average rates are calculated correctly.
  4. Record time worked on Public Holidays, using ALT-CR - and PHW - . (Note that PHW pays at time-and-a-half as required by the Act).
  5. Record Bereavement Leave, using the new BL - code.
  6. You may wish to review your Leave Liabilites Report. During April 2004 this report will show "old" and "new" leave liabilites so that you can see the differences caused by the new Act.
  7. Review your Special Payment codes to ensure that the Accumulates into Holiday Pay Liable Earnings flag is set correctly - refer to the HP column.

Summary of Changes to iPayroll®

  1. Bereavement Leave can now be recorded using the standard BL - code.
  2. Alternative Holidays can now be recorded using the standard ALT-CR - and ALT - codes.
  3. Work on Public Holidays can now be recorded using the standard PHW - payment code.
  4. Sick Leave The Standard SICK - code is now intended for Sick Leave only (instead of Sick or Special Leave).
  5. Leave Pay Rates can now be viewed for any person to help you see how the various leave rates are calculated. For an example, see Leave Pay Rates for John Matthews in our Sample Company. The Liable Pay and Liable Hours figures are calculated in accordance with the new Act.
  6. Available Leave Pay Rate options Timesheet Entry has been changed to let you select the appropriate pay rate when recording leave.
  7. Two Bonus Codes are now available. The old BON - code is for a bonus that is NOT liable for Holiday Pay and BON2 - code is for a bonus that IS liable.
  8. Leave Calendar. This is displayed at the bottom of a person's timesheet Timesheet Leave Calendar when you have entered leave. This will make it much easier for you to double check that you have entered the correct leave dates. For an example see Timesheet for John Matthews in our Sample Company.

If you are interested in details on the new Act, The Employment Relations Service has a very clear set of Holiday Fact Sheets.

For more information please Contact Us. Leave Set Up
ipayroll.co.nz


Leave Set Up

You can set up your own special Leave to supplement the many standard leave types that are set and and maintained for you by iPayroll®. Your own special leave allows you to easily calculate and pay any unique leave types that exist in your organisation's employment contracts.

Tip: Before setting up your own leave, please check that no standard leave already does what you need.

Adding Leave

To set up special Leave follow these steps:-

  1. Go to your Leave.
  2. Press the Add Leave button.
  3. Enter a Leave Code, Description and Type (Entitlement or Taken).
    The Leave Code appears in the drop-down list when you add transactions to timesheets. You should use a short, easy to type, code that you can remember easily. (If you are used to another payroll system that has Leave codes or numbers, you may like to use those for your leave code).
  4. Press the Add Leave button.
  5. Complete the information on either the Leave Entitlement or Leave Taken and press the Save this Leave button.

Information on Leave

Each Leave page contains a number of pieces of information that control how the leave is calculated and reported. What appears depends on whether you are setting up a Leave Entitlement or Leave Taken. Select the appropriate link for details.

Leave in Days

Sick Leave, Bereavement Leave and Alternative Holiday leave balances may be recorded in days. There are several additional features for Leave in Days.

Long Service Leave

Additional infiormation is available on setting up Long Service Leave.

Leave Entitlement

Description Enter a description that will clearly describe to a person what this leave is for.
Note: If you include %rate% in your description, it will be replaced by the transaction's rate on the person's payslip.
Default Cost Centre Note: This is only displayed if you have the costing features turned on.
Select how this leave is to be costed. You have three options:-
  1. Person's default - The person's default cost centre (set up on their personal file) will always be used.
  2. Fixed Cost Centre - Select here the cost centre that will always be used.
  3. Template - This allows you to set up a rule that will direct the leave to the appropriate cost centre, taking part of the code from the person's cost centre and the remainder from the template. Enter a ? in each position that should come from the person's home cost centre.
    For example, ????-AL will construct a cost centre from the first 4 characters of the person's home cost centre, and append -AL onto the end.
Leave Type Select the leave type that best describes this entitlement.
Note: If you require separate balances for different "Other Leave" types, enter a Balance Name.

Entitlement Rules

Entitlement Rules control how and when a person is given additional leave entitlements. Correctly setting up leave rules can automate a lot of leave recording and balancing. To set up Leave Rules:
Enter the appropriate details and press the Add button.
OR select a line to change, and follow the instructions on that screen.
Entitlement Given After This is how long a person must be employed before getting this leave entitlement. For example, often people must be employed for 6 months before receiving a Sick/Special leave entitlement.
And Then Every Often leave entitlements are given on a regular basis (e.g. annually). Enter the frequency here.
Entering 0-0 means that this entitlement is given only once.
Entering 1-0 means that this entitlement is given every year.
Entitlement Due This is the actual amount of leave entitlement that is given to the person by this rule.
Maximum Entitlement This is the maximum leave entitlement that will be allowed when a new entitlement is given. For example, often Sick/Special leave has a maximum value (e.g. 5 days given each year, non-accumulating, or sometimes 5 days per annum to a maximum of 40 days).

Accrual Details

The accrual fields are usually only required for Annual Leave. Usually enter No Accrual and 0%. See Annual Leave Entitlement for more details.
Basis for Accrual The hours accrued each pay period is always based on the actual number of hours recorded on the timesheet.
Hours Accrued = Leave Liable Hours Hours from the person's Timesheet.

Actual: The "Actual" method uses this figure when performing a leave anniversary rollover.

Standard: The "Standard" method ignores the accrual figure on the person's rollover (except when the rollover is for less than a full year) and instead gives the person the entitlement due figure.

Accrual % This is the percentage at which the accrual is valued at. (It is used for Annual Leave liability calculations).
Note:  3 weeks / 15 days Annual Leave equates to a 6% accrual.
4 weeks / 20 days Annual Leave equates to an 8% accrual.

Leave Taken

Description Enter a description that will clearly describe to a person what this leave is for. This is displayed on peoples timesheets and payslips.
Note: If you include %rate% in your description, it will be replaced by the transaction's rate on the person's payslip.
Multiplier Enter 1.0. The amount calculated is multiplied by this multiplier, and it should always be 1.0 for practically any leave.
Calculation Rule Select the appropriate type from the list. This is the main way to determine how leave taken is paid.
  1. For a calculation that depends on a persons pay rate, select an Employee Rate (1 to 5). (e.g. SICK - Sick Leave).
  2. For a rate specific to this payment select use Rate Amount from Payment, and then enter the actual rate in the Rate Amount box.
    Note: This option is also used for LWOP - Leave without Pay. In that case, enter 0.0 in the Rate Amount.
  3. Annual Leave is paid using the 'use built in Annual Leave Calculations' rule that performs annual leave calculations according to the Holidays Act 2003. (See AL - Annual Leave).
  4. Some other leave types (e.g. Bereavement Leave) are paid using the 'use Relevant Rate Calculations' rule that performs leave calculations according to the Holidays Act 2003.
Rate Amount This entry depends on the Rate Type selected (above).
  1. For a Fixed Amount, enter the actual rate to pay this payment at. Alternatively, enter 0.0 if the amount is to keyed when entering timesheets.
  2. For a Percentage based rate type, enter the percentage to apply, (e.g. enter 6.5 for 6.5%)
Priority Leave this blank, and an appropriate priority will be generated for you. (The default priority is rarely changed, in practice).

The priority determines the order in which transactions are calculated, paid and displayed on timesheets and payslips. Often this order isn't important, but sometimes calculations depend on other payments in the same timesheet. (e.g. a payment that is calculated on a percentage of Taxable Earnings must be calculated after all Taxable Earnings have been calculated).

Default Cost Centre Note: This is only displayed if you have the costing features turned on.
Select how this leave is to be costed. You have four options:-
  1. No default - A cost centre will have to be entered every time you include this leave in a timesheet.
  2. Person's default - The person's default cost centre (set up on their personal file) will be always be used, unless you override it when you are entering timesheets.
  3. Fixed Cost Centre - Select here the cost centre that will always be used, unless you override it when you are entering timesheets.
  4. Template - This allows you to set up a rule that will direct the deduction to the appropriate cost centre, taking part of the code from the person's cost centre and the remainder from the template. Enter a ? in each position that should come from the person's home cost centre.
    For example, ??-LVE will construct a cost centre from the first 2 characters of the person's home cost centre, and append -LVE onto the end.
Leave Type Select the category that best describes this leave.
Note: If this is an "Other Leave" type, you can select the appropriate leave balance to update from the Balance Name drop-down list. (Set up the Leave Entitlement first to create a new Balance Name).
Tax Type Select the one that best describes this payment type.
  • Taxable - This applies to almost all leave.
  • Extra Pay - This will tax the leave payment at the extra pay (emolument) tax rate.

Leave in Days

Sick Leave, Bereavement Leave and Alternative Holiday balances are recorded in days rather than hours, in line with the Holidays Act 2003. For example, see the Leave Balances reports:-

Timesheets


Leave Taken

Enter any sick leave, bereavement leave or alternative holiday payments in both hours and days i.e. enter hours to pay (quantity) and days taken to reduce leave balance. The number of days are required for part time staff where details of their exact working patterns aren't recorded.

Alternative Holiday credits

Enter the number of days to credit to the Alternative Holiday balance. The hours quantity is optional and has no affect on the balance.

Timesheet Upload

Enter both hours to pay (quantity) and number of days for sick, bereavement or alternative holiday payments or alternative holiday credits.

Sick Leave Anniversary

When a person reaches their sick leave anniversary, 5 days are added to their balance.

Leave Balances, Leave History and Leave Reports


All leave is shown in days for sick leave, bereavement leave and alternative holiday balances and leave history.

For more information or if any of your leave balances are incorrect, please Contact Us.

ipayroll.co.nz

Multiple Users

Multiple Users can be set up within each organisation, with differing security access as required.

Security Options for User Names

  1. Every organisation is initially created with a default User Name that has full access to view, add, change and delete all information.
  2. Enquiry-only User Names allow full access to view all information, but cannot add, change or delete anything.
  3. User Names can be restricted to some Personal Files only. This is based on the User Defined Field so that you can set up access by department or location, for example.
  4. We can also set up which users have permission to Confirm Pays. Please contact us if you want to set up a "two-step process" to confirm pays.
  5. Other security roles are also available, contact us for details.

For security purposes, we set up additional users on your behalf. Please contact us if you want us to set up additional users for your organisation.

Payments

You can set up your own special Payment elements to supplement the many standard payments that are set and and maintained for you by iPayroll®. Your own special payments allow you to easily calculate and pay any unique allowances or other payment types that exist in your organisation's employment contracts.

Tip: Before setting up your own payment, please check that no standard payments already do what you need.

Adding a Payment

To set up a special payment follow these steps:-

  1. Go to your Payments.
  2. Press the Add Payment button.
  3. Enter a Payment Code and Description.
    The Payment Code appears in the drop-down list when you add transactions to timesheets. You should use a short, easy to type, code that you can remember easily. (If you are used to another payroll system that has allowances codes or numbers, you may like to use those for your payment code).
  4. Press the Add Payment button.
  5. Complete the information on the Payment form and press the Save this Payment button.

Information on a Payment

Each Payment contains a number of pieces of information that control how the payment is calculated and reported.

Description Enter a description that will clearly describe to a person what this payment is for. This is displayed on peoples timesheets and payslips.
Note: If you include %rate% in your description, it will be replaced by the transaction's rate on the person's payslip.
Multiplier Enter 1.0, unless the Payment is for overtime or penal time. The amount calculated is multiplied by this multiplier, and it should always be 1.0 except for overtime / penal time payments. (e.g. T1.5 - Time and a Half).
Calculation Rule Select the appropriate type from the list. This is the main way to determine how a payment is calculated.
  1. For a calculation that depends on a persons pay rate, select an Employee Rate (1 to 5). (e.g. T1 - Ordinary Time).
  2. For a rate specific to this payment select use Rate Amount from Payment, and then enter the actual rate in the Rate Amount box.
    Note: This option is also used when ad-hoc payments are made that vary each time they are entered. In that case, enter 0.0 in the Rate Amount. You can then enter the actual rate to pay when entering a timesheet. (e.g. RED - Redundancy Payment).
  3. For a calculation that depends on a percentage of a persons earnings, select the appropriate percentage Calculation rule from the list, and enter the actual percentage in the Rate Amount box. (e.g. HP8 - Casual Holiday Pay (8%)).
Rate Amount This entry depends on the Rate Type selected (above).
  1. For a Fixed Amount, enter the actual rate to pay this payment at. Alternatively, enter 0.0 if the amount is to keyed when entering timesheets.
  2. For a Percentage based rate type, enter the percentage to apply, (e.g. enter 6.5 for 6.5%)
Priority Leave this blank, and an appropriate priority will be generated for you. (You will only rarely have to change the default priority).

The priority determines the order in which payments are calculated, paid and displayed on timesheets and payslips. Often this order isn't important, but sometimes payment calculations depend on other payments in the same timesheet. (e.g. a payment that is calculated on a percentage of Taxable Earnings must be calculated after all Taxable Earnings have been calculated). See the Payments page for a list, in priority order.

Default Cost Centre Note: This is only displayed if you have the costing features turned on.
Select how this payment is to be costed. You have four options:-
  1. No default - A cost centre will have to be entered every time you include this payment in a timesheet.
  2. Person's default - The person's default cost centre (set up on their personal file) will be always be used, unless you override it when you are entering timesheets.
  3. Fixed Cost Centre - Select here the cost centre that will always be used, unless you override it when you are entering timesheets.
  4. Template - This allows you to set up a rule that will direct the payment to the appropriate cost centre, taking part of the code from the person's cost centre and the remainder from the template. Enter a ? in each position that should come from the person's home cost centre.
    For example, 01??? will construct a cost centre starting with 01 and then containing the 3rd, 4th and 5th characters of the person's home cost centre.
Liable Earnings Tick all that apply to this payment type.
  • Employer ACC Levy - Tick if this payment is to be included in the Total Liable Earnings for Employer ACC Levy calculations.
  • Superannuation - Tick if this payment is to be included in a persons Superable Earnings. This is important if you have another Payment that has a Rate Type of '% of Superable Pay', and you want this payment to be included in the calculation.
  • Holiday Pay - Tick if this payment is to be included in a persons Holiday Pay Liable Earnings (Tip: Taxable Earnings generally are). This affects the amount paid for Casual Holiday Pay and Annual Leave.
Earnings Type Select the one that best describes this payment type.
  • Salary/Wages - Select the appropriate earnings type to report this payment in the appropriate place on the Payroll Control and Payroll Hours reports.
  • Allowance - Select the appropriate option. This largely determines how the payment is taxed, but it also affects how it is presented on reports, including the Payroll Control reports.
Reporting Groups
ipayroll.co.nz


Reporting Groups

Reporting Groups are a powerful feature that allow you to set up your own table-driven reporting fields for your people. Once you have set up your reporting groups, you can record them against each person by going to their details.

Reporting Options

User Defined Fields

  • Used for location, branch, department, sorting payslips, multi-user security and sorting reports.
  • Only one User Defined field available.
  • Maintained on each person's main Personal Details page.
 

Reporting Groups

  • Used for Human Resources reporting, e.g. demographics, ethnicity, training, competencies, skills, etc.
  • Any number of different categories / tables can be set up.
  • Each category maintained on separate pages within each person's Personal Details.

Reporting Groups are often used for Human Resource related reporting. For example they could be used for these purposes:-

When you set up a new category of Reporting Groups, a new report is automatically created on your Personal Reports.

You can view and change your own Reporting Groups. You can then record them against each person on your Current People.

Benefits of Reporting Groups

The power of Reporting Groups is that you can define exactly what information is recorded on Personal Files. Only reporting groups that you have previously set up can be used.

This information is then an ideal basis for reporting, as the details on your staff's personal files are consistent.

Special Reporting Groups

Special pre-defined Reporting Groups have additional fields to let you manage extra information.

Contacts / Next of Kin

To record Emergency Contact Details against your people:-

  1. Add a new Reporting Group called, for example, NK - Next of Kin, with a Category of Contact.
  2. Note: It is important that you enter the category name exactly as above.
  3. Now, when adding that Reporting Group to a person, you will be able to enter additional information - including the contact's name, address and other contact details.
  4. Position Details

    To record additional Position Details against your people:-

    1. Add a new Reporting Group for each position, with a Category of Position.
    2. Note: It is important that you enter the category name exactly as above.
    3. Now, when adding a Position Reporting Group to a person, you will be able to enter additional information - the position FTE (Full-Time Equivalent), Hay Profile and Hay Points.
    4. Remuneration

      To record Emergency Contact Details against your people:-

      1. Add a new Reporting Group for each Remuneration Benefit Type that you wish to maintain, with a Category of Remuneration.
      2. Note: It is important that you enter the category name exactly as above.
      3. You can select the type of Benefit from a Dollar figure, a Percentage, Yes/No or a Comment
      4. Now, when adding that Benefit Reporting Group to a person, you will be able to enter the additional remuneration information.
      5. Termination Reason

        To record a Termination Reason when a person finishes:-

        1. Add a new Reporting Group for each termination reason, with a Category of Termination.
        2. Note: It is important that you enter the category name exactly as above.
        3. Now, when a person finishes, you will be able to optionally select a termination reason from the list.
        4. Variable Pay Rates

          To calculate Pay Rates that vary from person to person iPayroll® contains a powerful feature to let you define your own pay rate tables based on a Reporting Group:-

          1. Add a new Reporting Group and the various items that fall within it.
          2. Add a new Payment, and select the Calculation Rule "use a Rate based on a Reporting Group".
          3. (Alternatively, use person's rate times Multiplier based on Reporting Group).
          4. Follow the instructions on the Payment set up page to add a table defining the different rates according to the Reporting Group.
          x

          Tip

          • We suggest you Contact Us to discuss your requirements before setting up this feature.

          ipayroll.co.nz

          Superannuation

          You can set up special deduction codes to manage any personal or company superannuation schemes.

          Note: KiwiSaver deduction codes are already set up for you with the appropriate rules. See KSE - KiwiSaver and KSR - KiwiSaver Employer Contribution.

          Personal Superannuation Contribution

          Simply set up a deduction to record details of the person's superannuation deduction.

          Note: Select the 'Standard Deduction' Deduction Type when creating this deduction.

          Company Contribution (Subsidy)

          Where the organisation makes a contribution (subsidy), it is necessary to set up a second deduction code to record details of the subsidy. The person will be given two deductions on their Timesheet Template - one for their contribution and one for the subsidy.

          Note: Select the appropriate 'Super Subsidy' option for this deduction's Deduction Type. As well as identifying this as a superannuation subsidy, it also ensures that the correct Contribution Tax (ESCT) is calculated.

          Superannuation Reports

          Superannuation information can be found on several reports:-

          Multiple Superannuation Rates (Tip)

          Often people contribute at different percentage rates into the same superannuation scheme. If this occurs, set up the superannuation deductions to calculate at 1% (i.e. enter 1.00 into the Rate Amount field). Then enter the person's individual percentage in the Quantity field on the person's deduction on their Timesheet Template.

          User Defined Field

          User Defined fields allow you to choose your own sort field for your people. Once you have set up your user defined fields, you can record them against each person by going to their Personal Details.

          Reporting Options

          User Defined Fields

          • Used for location, branch, department, sorting payslips, multi-user security and sorting reports.
          • Only one User Defined field available.
          • Maintained on each person's main Personal Details page.
           

          Reporting Groups

          • Used for Human Resources reporting, e.g. demographics, ethnicity, training, competencies, skills, etc.
          • Any number of different categories / tables can be set up.
          • Each category maintained on separate pages within each person's Personal Details.

          User Defined fields are often used for Locations, Branches or Departments. For example, in our sample company the User Defined field is called Workplace, and the following have been created:-

          Workplace Description
          AR Arrowtown
          QN Queenstown
          WN Wanaka

          You can view and change your own User Defined Fields. You can then record them against each person on your Current People.

          Sorting Payslips

          You have the option to sort your payslips by your User Defined Field. This may make it quicker and easier to distribute them - especially if you have a reasonable number of them.

          To sort your payslips, go to the User Defined Fields page, tick the Print Payslips in Workplace order box, and then press the 'Save User Defined Field Options' button.


          ipayroll.co.nz