Hours worked by branch: branch reports and comparison

Quick answer

#What it's good for

• Hours and labour costs per branch for the month, without splitting timesheets by hand.
• Day by day, you see where a branch had more or fewer hours than planned.
• A weekly workload heatmap shows which branch is busiest on which day.
• Two months side by side show whether a location is growing or shrinking.

#Who it's for

#Step by step

1. Switch on Calculate worked hours per branch.

   Go to My Company › Company Details › General Settings and turn on Calculate worked hours per branch. By default FreshQR counts each person’s day across all branches together; with this setting it also splits the day by branch. Reports are recalculated, which can take a moment.

   Without the setting, the Overview and Comparison tabs stay hidden. The Owner, Administrators and accounts with the role Company Settings: View & Edit can change it. Nothing changes in the employees’ app.

   

2. See hours and costs in Per branch.

   Open Table Reports › Per branch. Each employee’s month is split by branch into working days, weekends and holidays. The Type filter switches what you see: Worked hours, Number of Hours with absences, Absences or Expenses without bonuses. Costs need an hourly rate or salary on the employee – see Hourly rate and salary.

   If your schedules use flexible (conditional) breaks, the tab tells you so: Note: you use 'Conditional Breaks', therefore the report calculates time only for the assigned branch setting each day. Multiple branches in a single day cannot be calculated.

   

3. Find the busy days in Branches/Projects Overview.

   Branches/Projects Overview shows Branch/Project Statistics – hours, Avg Hours, Workday Hours, Weekend Hours, Number of check-ins, Total expenses – and the Branch/Project Workload Heatmap (Weekly Totals): the darker the cell, the more hours that branch has on that weekday. Use Export to PDF to keep a copy.

   Overtime in this tab is worked out per branch and can differ from the overtime in Months or Per employee. For pay, use the employee reports.

   

4. Compare months in Branches/Projects Comparison.

   Branches/Projects Comparison puts periods next to each other: two monthly calendars with the hours worked per day and a colour legend. Filter one branch to see, for example, whether the depot had a quieter October than September.

   

5. Check plan against reality in Branches detail.

   Branches detail shows each branch day by day: Expected employees, Time per employee, Total expected time, and every employee’s worked time coloured by the Color Legend – Above scheduled hours, Below scheduled hours, Exactly as scheduled, No scheduled time. Show scheduled hours only hides days without a plan.

   The expected time comes from published shifts in the shift planner. A second source, object schedules, is an Experimental setting (Beta). Without either, cells show No scheduled time. The tab uses raw scans: This report shows raw attendance data from QR code scans. Automatic breaks and time roundings are not applied.

   

#Other ways to look at branches

• Highlight one branch in employee sheetsIn Per employee, the filter Highlight branch paints the days and totals of one branch yellow – useful when people work at several locations. See Monthly employee report.
• Filter any tab by branchMost tabs accept Add filter › Branch – see Table reports – tabs and filters.
• Export to ExcelBranches detail has Export all branches to Excel; every branch also has its own button. See Export to Excel and PDF.

#Special cases and tips

The Overview tab is missing

Turn on Calculate worked hours per branch (step 1). If it is off and you have several branches, the Overview shows a reminder: You have multiple branches but the "Calculate worked hours per branch" setting is turned off.

Costs are zero

The employees have no hourly rate or salary for that period. Add one in the employee’s Salary tab – see Hourly rate and salary.

Branch hours don’t add up to Per employee

Branches detail uses raw scans without rounding and automatic breaks; Per employee uses the final worked time. Flexible breaks also limit the split to the assigned branch, as the note in Per branch says.

A Branch Manager doesn’t see Per branch

By design: Branch Manager and Project Manager accounts don’t get Per branch and Branches detail. They can still use the Overview and Comparison tabs for their own branches or projects.

#Related

Web app (administrator)Mobile app (employee)