Skip to main content

Setting up Department P&L report

This guide explains how to configure the mapping and templates required for Department P and L reporting. The setup involves mapping purchase types, mapping shift types, and creating a period template that drives report generation.

Updated over 2 months ago

Section 1. Configure Purchase Type Mapping
​
Purpose
​
Ensures all purchase types flow to the correct account codes and account categories for reporting.

Process

  1. Navigate to Settings

  2. Select Billable Companies

  3. Open Purchase Types

  4. On the right side of each purchase type, assign the correct Account Category for each Account Code

  5. Confirm all purchase types are mapped before proceeding


​
​Section 2. Configure Shift Type Mapping
​
Purpose
​
Ensures labour costs flow to the correct account codes when timesheets are processed.

Process

  1. Navigate to Settings

  2. Select Shift Types

  3. Edit each shift type

  4. Assign an Account Code to every shift type

  5. Save changes before moving on

Section 3. Create a Period Template
​
Purpose
​
Defines the reporting periods used in Department P and L reports.

Process

  1. Navigate to Reporting

  2. Select Department P and L

  3. Click Manage Template

  4. Create New Period Template

  5. Enter a Title such as FYE 2025

  6. Enter a Period Name such as January 2025 or February 2025
    You can also label them Qtr 1, Qtr 2 and similar

  7. Select the date range for each period

  8. Save the template
    ​
    ​


​Running the Report

  1. Go to Reporting

  2. Select Department P and L

  3. Choose a Department

  4. Choose the Period Template

  5. Run the report

Did this answer your question?