Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Report Designer

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.
  1. Select cell
    A7
    .
  2. Select
    Insert
    , then
    Conditional Expression
    .
  3. Select the beaker icon, then the
    [Payroll.Check.PayItems.TotalAmount]
     variable.
  4. Change
    =
      to
    >
     in the middle dropdown list.
  5. Enter
    0
     in the next field.
  6. In the Action section, select the beaker icon next to
    If true, print:
    .
  7. Select the
    [Payroll.Check.PayItems.Description]
     variable, or whichever variable the cell from step 1 currently has.
  8. 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.
  1. Select the letter
    D
     to select the whole column.
  2. Select
    Insert
    ,
    Column
    , then
    Left
    .
  3. Enter a description for the column in cell D1.
  4. Select cell
    D7
     and insert the
    [Payroll.Check.PayItems.OTHours]
     variable.
  5. Select cell
    C7
     and change the variable to
    [Payroll.Check.PayItems.RegularHours]
    .
  6. Resize the columns so none of them cross the vertical page break.
  7. 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.

This article applies to:

  • Product: Accounting CS
  • Subject: Reports

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close