Use the Work Log Summary report to add up the hours your team logged, by Meld or by technician. This helps with payroll and with billing labor back to owners or residents.
- Who this is for: Maintenance Supervisor, Property Manager, Accounting
- Applies to: All customer types
- Access needed: your role must be able to generate reports.
- Why it matters: you see where labor time goes and can bill it back.
Step 1: Run the Work Log Summary report
- Click Reports in the left menu. Reports is not available on a phone.
- Under Available Reports > Maintenance Technicians, click Work Log Summary. The Labor Summary panel opens.
- Under Filter Report Period by, choose Check In or Check Out. Check In is the default.
- Pick a Report Period, such as 30 days, 90 days, 180 days, 1 year, or Custom to set start and end dates. To see some property groups, pick them in Property Group.
- Click Generate Report.
- The file has only the columns shown in the table. 10 of 15 columns show by default. To add Property Name, Address line 1, City, State or Postal Code, click Columns and turn them on.
- Click Export as CSV. Property Meld emails you a link to the file. Export as CSV shows only after you generate a report with rows.
If you leave a generated report without exporting, Export Report Before Leaving? opens. Click Return to Export to stay, or Leave Without Exporting.
Step 2: Total the hours
Open the file in a spreadsheet. Each row is one work log entry. By default the columns are Agent, Meld, Work Category, Work Type, Unit, Title, Description, Check In, Check Out and Hours.
- By Meld: make a pivot table with Meld as rows and the sum of Hours as values. Or sort by Meld and add up each group.
- By technician: do the same with Agent.
Hours is in decimal hours. For example, 1.5 is an hour and a half.
Is there a quicker way?
For total hours per technician without Meld details, use the Labor Summary Report, also under Maintenance Technicians. The Technicians Labor Summary panel opens. Pick a Report Period and, if you want, Property Group or Work Category (Include Work Category Breakout). Click Generate Report. It shows Technician Name, Hours Logged and Melds Completed.
Limitations and things to know
- The report has work logs from your team only, including managers and technicians.
- A work log with no check out shows 0 hours. It is left out when you filter by Check Out.
- Edited logs show their current values. Deleted logs are not included.
- Dates use your time zone from your notification settings.
- The table on screen shows up to about 1,000 rows. The emailed file has all rows.
- The Labor Summary Report always counts by check in date and leaves out logs with 0 hours, so its totals can differ from the Work Log Summary.