Report Data Sources
Coinage
Returns a record for each payee with a cash payment, including payees whose net pay was not cash, but who had a deduction that has a cash disbursement. The fields Denom1 to Denom12 and Coin1 to Coin12 give the denominations defined in the Payroll setup screen, and the calculated number of coins for each denomination respectively. The data source is normally in the sequence of net pays, followed by pay item deductions.
Costing
This data source returns a row for:
- each payee net pay where the cost code is the defalt cost code defined in the Costing Report Options screen.
- each pay item that makes up the gross pay, where the cost code is either the cost code entered in the pay calculation screen, the pay item setup cost code, or the payee default cost code.
Each row comprises the cost code and description, expense code and description, payee name, pay item description, number of units and either a debit or credit cash amount. The cash amount is a debit for pay item payments and a debit for pay item deductions and net pay amounts.
The data source is normally in the sequence of net pays, followed by pay item deductions.
Diary
This lists each of the payee notes in ascending note date then payee name sequence.
Leave Balances
This is a subreport data source included with the pay advices data source. It returns a list of the leave type balances where the leave type is flagged as printed on pay advices in the Leave Type Edit screen.
Leave History
Returns a list of leave pay items, where each item is a payment that has a leave type defined in the pay item edit screen.
Leave Liability
This is a two level heirarchical data source, where the top level is a row for each employee leave balance containing the employee name, leave type, daily and hourly pay rates, leave balance and leave liability, and the second level is a total of leave accrued, taken and earnings for each leave year for each of the top level's payee leave types.
Net Pay
Returns a record for each payee with a specified pay method, including payees whose net pay was not the specified pay method, but who had a deduction that has a disbursement defined as that pay method. The data source is normally in the sequence of net pays, followed by pay item deductions.
Pay Advices
This is a complex data source, being a two level heirarchy, with multiple child data sources. The top level is a row for each payee who has a net pay on a pay day in the selected range of dates. For each top level row, there are sub data sources:
- Pay items a list of the pay items that make up the pay for the payee.
- Bank details a list of the direct credit transactions generated from the pay,including one for the net pay, plus one for each direct credit deduction.
- Leave balances has a row with the current balance for each leave type that is flagged as being printed on pay advices.
The default sort sequence for the data source is payee last name, then first name.
Payees
This is another complex data source, being a two level heirarchy, with multiple child data sources. The top level is a row for each payee in the database. For each top level row, there are sub data sources:
- Miscellaneous data a list of the miscellaneous data items for the payee, including all country specific statutory data fields.
- Leave balances has a row with the current balance for each leave type.
- Pay rates contains the pay rate history for the payee, showing all pay rate changes.
- Notes lists all the notes recorded for the payee.
The default sort sequence for the data source is payee last name, then first name.
Pay History
Contains a row for each payee's pay slip with a pay date in a specified date range. Each row contains full payee details plus summary totals and net pay calculated for the payslip.
The default sort sequence for the data source is payee last name, then first name, then pay date.
Pay Item History
This data source contains a row for each pay item recorded in each payee payslip with a pay date with a specified date range.
The default sort sequence is pay item description, then pay date, then payee name.
Payment Summary
This returns a row for a specified payment summary type where selected payees have payments that are reported on the payment summary type. Each row contains all the information required to print a payment summary.
Pay Register
This is complex data source, being a two level heirarchy, with multiple child data sources. The top level is a row for each pay group in the database. For each top level row, there are sub data sources:
- Payee payslips a list of the payee payslips with pay dates in the specified date range. This sub data source has it's own sub data source, containing a list of pay items for each payslip.
- Grand totals this is a single row containing summary totals for all payslips selected in the first sub data source. This sub data source itself contains a sub data source which lists the grand totals for each pay item included in the pay items sub data source of the payee payslips sub data source..
- Disbursements is a sub data source containing a summary total of all net pays and deductions for each disbursement type: direct credit, cheque, cash and retained.
The default sort sequence for the data source is pay group name, then payee last name, then first name.
Payroll Tax
This contains, for each state, a list of the pay items that are reportable for payroll tax, with summary totals for each tax category: income, allowances and fringe benefits.
Scheduled Items
This lists each of the scheduled transactions in ascending date then payee name sequence.
Signature List
Returns a record for each payee with a specified pay method, including payees whose net pay was not the specified pay method, but who had a deduction that has a disbursement defined as that pay method. The data source is normally in the sequence of net pays, followed by pay item deductions.
Superannuation
This data source provides a row for each employee with a superannuation contribution. As well as basic payee data, each row contains the total of company superannuation contributions, employee contributions and the total contributions.
Survey
This data source provides a row for each hours type for each payee who received a pay in the specified date range. The hours type is either 'ordinary' or overtime, as defined in the Pay Item Edit screen. As well as basic payee data, each row contains the number of hours worked for that hours type and the amount paid.
Tax Period
Returns a row for each reportable pay item for each pay date within the specified date range. Each row provides basic payee information,the amount paid for each tax category, with the tax category columns being defined by the permissible values for the 'TaxCategory' pay item prooperty defined in the Properties screen.
Tax Year End
Returns a row for each reportable pay item for each pay date within the specified date range. Each row provides basic payee information,the amount paid for each tax category, with the tax category columns being defined by the permissible values for the 'TaxCategory' pay item prooperty defined in the Properties screen.