Aantar Books
Payroll costs, liabilities and year-to-date reports
Deductions and benefits, employer costs, labour cost by department, location or job, year to date as at any day, vacation and time-off owed, liability history, workers' compensation, employer health tax and the payroll journal, with their filters and saved layouts.
Where: Reports ▸ Employees & Payroll · Reports ▸ Report Centre ▸ Employees & Payroll
These reports answer the questions asked after the pay is out: what each person really costs, where the labour went, what is owed in vacation and time off, what the agencies were owed and paid, and how the payroll reached the books. They sit beside the Payroll Register and Payroll Summary by Employee.
Where to find them
- Reports ▸ Employees & Payroll.
- Reports ▸ Report Centre, category Employees & Payroll.
- On an employee's record, Reports… opens Payroll Summary, Payroll Detail (the register), Year to Date and Vacation and Time-Off Detail for that person.
Like the other payroll reports, they count approved, posted and paid pay runs by payment date, leave out runs still being built (a note says how many), and need payroll on your plan and a role that may read pay runs, remittances, or vacation and banked time.
Filters
Above the report, the filters it honours appear as buttons: Employee (everybody, or one person on the payroll), Group by (department, location or job), Pay run and Split by. Choosing one runs the report again. They travel with the report when you memorise it.
Saving the layout for everyone
Every Employees & Payroll report can keep one layout for the whole company: under Columns, hide the columns you do not need, choose the filters and click a column heading to sort, then click Save layout for everyone. Everybody then opens the report that way. The dates are never saved, so the report still opens on the period you pick.
- Your own choice of columns on this computer still wins over the company's layout.
- Remove the saved layout (under Columns) puts the report back the way it comes.
- Saving or removing a layout needs the right to change payroll setup.
Print, Excel (XLSX), CSV, PDF and e-mail work as on every report; see Print, export and e-mail a report.
Costs
Payroll Deductions and Benefits
What it answers: every deduction, taxable benefit and employer contribution in the period, item by item.
Date: a period. Filter: Employee.
Columns: Item, Code, Employees (how many people had it), Pays and Amount.
Rows: four sections, each with its total: Statutory deductions (income tax, CPP/QPP, EI/QPIP), Other deductions (union dues, RRSP, court orders and the rest of your payroll items), Taxable benefits (paid in kind and taxed, not paid in cash) and Employer contributions (on top of pay, withheld from nobody).
Payroll Employer Costs
What it answers: what each person costs the business on top of their gross pay.
Date: a period. Filter: Employee.
Columns: Employee, Gross, CPP/QPP, EI and QPIP (the employer's shares), Other contributions (the employer's part of pay items), Workers' comp (the premium), Health tax (employer health tax or Quebec's Health Services Fund), Total employer cost and Total cost (gross plus all of it).
Rows: one per employee, costliest first, then a Total. Double-click a line to open that person's Payroll Register.
Labour Cost by Department
What it answers: where the labour went: hours, pay and employer cost by department, location or job.
Date: a period. Filter: Group by Department, Location or Job.
Columns: Department / employee, Employees, Hours, Gross, Employer cost, Total cost and % of total.
Rows: a heading for each department (or location, or job), its people under it, a total for each and a grand total. People with none set are under No department.
Note: Each pay is costed to the department, location and job set on the employee's record when the pay was calculated, so moving somebody today does not move what they cost last month. Pays calculated before October 2026 did not record this; they are costed to where the person is set up today, and a note says how many.
Year to date and what is owed
Payroll Year to Date by Employee
What it answers: each person's year so far, on any day you choose.
Date: as of a day. The year is that day's calendar year, from 1 January. Filter: Employee.
Columns: Employee, Pays, Gross, Income tax, CPP/QPP, EI/QPIP, Other, Net pay and Employer cost.
Year-to-date amounts brought in for pay before Aantar Books ran the payroll (see Year-to-date amounts) are included in the totals but not in Pays; a note says how many entries were added.
Tip: As of 31 December, Gross and Income tax are the figures the T4 will carry.
Vacation and Time-Off Liability
What it answers: what the business owes its people in vacation pay, time off and banked overtime on a day: the figure your books carry as vacation payable.
Date: as of a day.
Columns: Employee, Vacation pay owed, Time off (hours), Time off value, Banked overtime (hours), Banked overtime value and Total owed.
Hours are valued at each person's hourly rate today (for a salaried person, the salary over 52 weeks of their standard hours). A time-off policy kept in dollars is added as it is. Double-click a line for that person's Vacation and Time-Off Detail.
Vacation and Time-Off Detail
What it answers: how a vacation or time-off balance came to be what it is.
Date: a period. Filter: Employee.
Columns: Date, Movement, Hours, Amount, Balance and Note.
Rows: for each employee, vacation pay and then each time-off policy: the balance brought forward to the start of the period, every accrual, payment, adjustment and time taken, and the balance after each. Vacation pay is in dollars; each policy in its own unit.
Liabilities and levies
Payroll Liability History
What it answers: each agency's account: what the pay runs made owing, what was paid and adjusted, and the balance.
Date: a period.
Columns: Date, Transaction (owed for a period with its due date, a payment, or an adjustment with its reason), Period, Owed, Paid, Balance and Reference (method, cheque number, confirmation).
Rows: a section per agency (the CRA, Revenu Québec, each workers' compensation board and health tax), a total for each and a grand total. Payments made in the period for earlier periods are included. See Pay Payroll Liabilities.
Workers' Compensation Assessable Earnings
What it answers: the figures the board's annual return asks for.
Date: a period.
Columns: Province / employee, Gross, Assessable earnings (gross up to the board's yearly maximum per worker) and Premium.
Rows: a section per province, each worker under it, totals. Nothing shows until the rates are set in Employer Levies.
Employer Health Tax
What it answers: remuneration and the employer health tax by province, Quebec's Health Services Fund included.
Date: a period.
Columns: Province / employee, Gross, Remuneration and Tax.
Note: The tax is worked on the year's total after the exemption, so pays early in the year can carry none until the exemption is used up.
The books
Payroll Journal
What it answers: the journal each pay run posted to the ledger, account by account, to tie the payroll to the books or to enter it in another ledger.
Date: a period. Filters: Pay run (all, or one), Split by (no split, department, location or job).
Columns: Account, Number, Split, Debit, Credit and Memo.
Rows: a heading for each posted pay run with its payment date and period, its lines, and a total that balances; then a grand total. An approved run that is not posted yet has no journal; a note says how many.
With a split, each account line is shared out by each department's (or location's, or job's) share of the run's gross pay plus employer cost. The last share takes the rounding, so each run still balances to the cent. Export it to Excel or CSV for another ledger.
Common problems
Labour cost shows everybody under "No department". Set the department, location and job on each employee's record (see Employee record). Pays calculated after that are costed to them.
Vacation liability shows hours valued at nothing. The employee has no hourly rate or salary on their record. A note says how many.
The Payroll Journal is empty. The runs in the period are approved but not posted. Post them from Pay Employees.
Related articles
- Employees & Payroll reports
- Payroll Calendar
- Pay Payroll Liabilities
- Employer levies
- Vacation and banked time
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.