Answer
The Pay Report Builder lets you pick any combination of columns and export them to CSV. This article lists every available column and explains exactly what each one contains. You will find it under Reports >> Pay Report Builder.
How the Pay Report Builder sources its values
The report produces one row per completed pay whose pay date falls inside the date range you set at the top of the screen (or whose processed date falls in range, if you have switched the report to use processed dates). Every column reads from that one pay, or from the employee attached to it. Most "Total ..." columns are simply the matching lines on that pay added together, so a column shows zero when the pay has no lines of that kind.
Please note: column labels that mention Holiday or Sick leave follow whatever you have named those leave types for your company (for example "Annual" and "Personal"). Columns marked (AU) only appear in Australian companies and columns marked (NZ) only appear in New Zealand companies; all other columns appear in both.
Employee and pay identification
- Employee Number: the payroll number on the employee attached to the pay.
- Employee Id: the employee's internal database ID.
- Employee Gender: the gender recorded on the employee.
- Tax Treatment Code (AU): the employee's STP Phase 2 tax treatment code.
- First Name, Last Name, Middle Name: the name fields on the employee.
- Status: the pay's status (a report row only exists once the pay is complete).
- Pay Period: the pay's pay period (weekly, fortnightly, monthly, etc.).
- Payslip Note: the note saved against that particular payslip.
- Pay Date Start: the first day of the pay's period.
- Pay Date: the pay's payment date.
- Processed Date: the date the pay was processed.
- Processed Pay Method: how the pay was paid out (cash, cheque, direct entry, etc.).
- Pay Period Number: which pay number this is within the financial year, counted from the financial-year start up to this pay run's end date.
Gross, tax and net
These are the headline money figures for the pay. Gross, net and raw gross are built from the pay's individual lines as follows.
- Gross: total earnings for the pay. It adds together:
- hours and rates (all worked hours at their rates), leave taken, and leave loading;
- allowances, bonuses/commissions and back payments;
- any termination payout (for a termination pay), and the NZ minimum-wage top-up where it applies;
- then subtracts salary sacrifice and pre-tax deductions.
- Raw Gross: gross with salary sacrifice and pre-tax deductions added back on. In other words, earnings before sacrifice and pre-tax deductions are taken out.
- Net: take-home pay. This is gross less tax, less post-tax deductions. For New Zealand it also subtracts student loan, the employee's KiwiSaver and any post-tax super. Cash pays are rounded to the nearest 5 cents.
- Tax / PAYE: the PAYG withholding for the pay. The column is labelled "PAYE" in New Zealand, where it is PAYE only (student loan is reported separately).
- Tax Label (AU): the tax scale label applied to the pay.
- Student Loan (NZ): the student-loan deduction for the pay.
- PAYE + Student Loan (NZ): the pay's PAYE and student loan added together.
- Student Loan (CIR) (NZ): the Commissioner-deduction portion of the student loan for the period.
- Student Loan (BOR) (NZ): the borrower-initiated extra-deduction portion of the student loan for the period.
- Ordinary Time Earnings: the super base (OTE) for the pay. It is the ordinary (non-overtime) hours, plus the allowances, bonuses, back payments and leave that are flagged as super-eligible, plus leave loading where the employee includes loading in super, plus any payment in lieu of notice. Overtime is excluded.
Earnings by type
These break the pay's earnings down by where they came from. Each is a dollar figure.
- Total Hours/Rates Earnings: every hours/rates line on the pay (ordinary and overtime), each at its own rate.
- Ordinary Time Hours Earnings: only the ordinary-time hours/rates lines.
- Time And Half Hours Earnings: only the time-and-a-half hours/rates lines.
- Double Time Hours Earnings: only the double-time hours/rates lines.
- Total Overtime Earnings: all overtime hours/rates lines added together.
- Total Leave Taken Earnings: every leave line taken, at the leave rate (before any leave loading).
- Total Bonus/Comm./Misc.: every bonus, commission and miscellaneous line (directors' fees, return-to-work payments, and similar).
- Total Back Payments: every back-payment line on the pay.
- Total Termination Gross: for a termination pay, the whole payout: payment in lieu of notice, unused holiday/sick/long-service leave, unused leave loading, ETP and non-ETP amounts, and redundancy. Zero for a normal pay.
Allowances and deductions
- Total Allowances: every allowance line, each amount multiplied by its units; taxable and non-taxable allowances alike.
- Total Deductions: every deduction line, pre-tax and post-tax together. Salary sacrifice and reimbursements are not deductions and are not counted here.
- Total Pre-tax Deductions: only the deduction lines flagged as pre-tax (taken out before tax is worked out).
- Total Post-tax Deductions: only the deduction lines flagged as post-tax (taken from net pay).
- STSL/HELP (AU): the study and training support loan (HELP) component withheld on the pay.
Superannuation
- Total Super (AU): all super for the pay. This is the compulsory guarantee, any reportable extra (RESC), member (post-tax) contributions, and super salary sacrifice, added together.
- Super Levy (AU): the compulsory super guarantee amount only.
- Resc (AU): Reportable Employer Super Contributions, being super above the compulsory rate plus super salary sacrifice.
- Super Member Contribution (AU): post-tax member super contributions deducted from the pay.
- Salary Sacrifice: every salary-sacrifice line on the pay, whether it goes to super or to another benefit.
KiwiSaver
- KiwiSaver Employee (NZ): the employee's own KiwiSaver contribution for the pay.
- KiwiSaver Employer (NZ): the employer's KiwiSaver contribution for the pay.
- KiwiSaver ESCT (NZ): the Employer Superannuation Contribution Tax on the employer contribution.
- Total KiwiSaver (NZ): the employee and employer KiwiSaver added together (ESCT is not included).
Leave loading and tax-method components
- Leave Loading (AU): the leave loading paid on leave taken in the pay, added across all leave lines.
- Leave Loading Ote (AU): the pay's leave loading, but shown only when the employee is set to include leave loading in super; otherwise zero.
- Leave Loading Overtime (AU): the pay's leave loading, but shown only when the employee is not set to include leave loading in super; otherwise zero.
- Method B1 Gross, Method B1 Tax, Method B1 STSL/HELP (AU): the gross, tax and HELP components calculated under tax Method B1 for the pay (used for back pays and lump sums).
- Method B2 Gross, Method B2 Tax, Method B2 STSL/HELP (AU): the same three components calculated under Method B2.
Termination
These all read from the pay's termination details and are zero unless the pay is a termination pay.
- Termination Pay?: True or False for whether the pay is a termination pay.
- Termination Reason: the reason recorded on the termination.
- Termination Unused [Holiday] Hours (AU): unused holiday-leave hours paid out on termination.
- Termination Unused LSL Hours (AU): unused long-service-leave hours paid out on termination.
- Termination [Holiday] Leave Paid / Termination Annual Holidays Paid (NZ): the dollar value of unused holiday leave paid on termination.
- Termination Long Service Paid (AU): the dollar value of unused long-service leave paid on termination.
- Termination Sick Leave Paid (AU): the dollar value of unused sick leave paid on termination.
- Leave Loading Paid On Termination / Termination Alternative Holidays Paid (NZ): the unused leave-loading amount paid on termination (alternative holidays in New Zealand).
- Termination [Holiday]/Loading Tax / Holiday Extra Pay Tax (NZ): the tax on the unused holiday and loading paid on termination.
- Termination LSL Tax (AU): the tax on unused long-service leave paid on termination.
- Termination ETP Total (AU): the total Employment Termination Payment amount on the termination.
- Termination Non-ETP Total (AU): the total non-ETP termination amount.
- Termination Tax Total / Termination Extra Pay Tax (NZ): the total tax on the termination.
- Termination Normal Earnings (AU): the annualised normal-earnings figure used in the termination calculation.
- JobKeeper Total (AU): the JobKeeper amount for the pay (zero unless the pay is JobKeeper-ready).
- JobKeeper Allowance Total (AU): the total of the pay's allowances flagged as JobKeeper top-up.
Hours
- Hours Worked: every hours/rates line measured in hours (ordinary and overtime), plus all leave hours taken on the pay. This is broader than just ordinary hours, and it does include leave.
- Actual Hours Worked: only the worked hours/rates lines (ordinary and overtime). Leave is not counted, so this is usually lower than Hours Worked.
- Ordinary Time Hours: the hours on the ordinary-time hours/rates lines.
- Overtime Hours Worked: the hours on all overtime hours/rates lines.
- Double Time Hours: the hours on the double-time lines.
- Time And Half Hours: the hours on the time-and-a-half lines.
Leave balances (carried on this pay)
These read the running balance recorded on this pay, not the whole-of-year figure.
- [Holiday] Leave Balance Hours: the holiday-leave balance carried on this pay.
- [Holiday] Leave Balance Dollars: that balance in hours multiplied by the employee's current hourly pay rate.
- [Sick] Leave Balance Hours: the sick-leave balance carried on this pay.
- [Sick] Leave Balance Dollars: that balance multiplied by the employee's current hourly pay rate.
- LSL Balance Hours (AU): the long-service-leave balance carried on this pay.
- LSL Balance Dollars (AU): that balance multiplied by the employee's current hourly pay rate.
- LSL Balance Days (AU): the long-service balance in hours divided by the employee's award hours per day.
Leave taken, cashed out and accrued
For each leave type below, Taken is the hours on the pay's leave lines of that type, and Taken Amount is the dollar value of those lines. Cashed Out and Cashed Out Amount count only the lines flagged as cash-outs. Accrual is the hours added to that balance on this pay.
- [Holiday] Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount, and [Holiday] Leave Accrual.
- [Sick] Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount, and [Sick] Leave Accrual.
- LSL: Taken, Taken Amount, Cashed Out, Cashed Out Amount, and LSL Accrual.
- Other Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount.
- Paid Parental Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount.
- Workers Comp Leave: Taken, Taken Amount.
- ACC / Workers Comp Leave (NZ): Taken, Taken Amount, and ACC / Workers Comp Reference Amount, the memo-only reference amount recorded on those leave lines (ACC pays the employee directly, so this leave is not paid through payroll).
- Compassionate Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount.
- Ancillary Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount.
- Paid Public Holiday Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount.
- Unpaid Leave: Taken, Taken Amount, Cashed Out, Cashed Out Amount.
- Custom Leave: Taken (Custom Leave Taken), Amount (Custom Leave Amount), Cashed Out, Cashed Out Amount, and Custom Leave Accrual.
A note on grouping by department
When you tick Group by department, Lightning Payroll splits each money column across the employee's departments using their department percentages, so a single pay can appear under more than one department, each showing its share of the figures.
