Common changes to Payroll Journal — Detailed report
Take the following steps to change the default Payroll Journal — Detailed report. You can apply similar steps to other reports in the Report Designer.
To open the report, select
File
, Report Designer
, then double-click Payroll Journal — Detailed report
.Exclude pay items with zero amounts
The following steps use conditional expressions on specific cells to only show when there is a non-zero amount.
- Select cellA7.
- SelectInsert, thenConditional Expression.
- Select the beaker icon, then the[Payroll.Check.PayItems.TotalAmount]variable.
- Change=to>in the middle dropdown list.
- Enter0in the next field.
- In the Action section, select the beaker icon next toIf true, print:.
- Select the[Payroll.Check.PayItems.Description]variable, or whichever variable the cell from step 1 currently has.
- Repeat these steps for cells B7, C7, and D7 in the Main region, and the corresponding cells in the Employee Totals and Company Totals regions, if desired.
note
If a conditional expression is present on a cell or row, the top-right corner will be colored green.
Insert columns for overtime hours
Use the following steps to add a column for overtime hours worked.
- Select the letterDto select the whole column.
- SelectInsert,Column, thenLeft.
- Enter a description for the column in cell D1.
- Select cellD7and insert the[Payroll.Check.PayItems.OTHours]variable.
- Select cellC7and change the variable to[Payroll.Check.PayItems.RegularHours].
- Resize the columns so none of them cross the vertical page break.
- Format cells D1 and D7 so they match the surrounding cells.
note
If you've conditional expressions that prevent the zero amounts from showing, you'll need to use the steps above to insert a conditional expression on the new cell in row 7.
