Give payroll and the agency the same hours

Payroll gets its hours one way, the staffing agency gets them another, and the two are reconciled by hand. When the numbers differ, nobody can say which is right, because neither came from the devices your crew actually used.

In Agromigo every hour your crew records lands in one place. Payroll, the hours your staffing agencies invoice and labour costs are different views of the same data, so the agency invoices exactly the hours your crew recorded.

In this video

Migo shows you how to run a saved report, build your own, and export the hours for one staffing agency.

The page. The Analytics Gallery holds your saved reports, one card each with its name and what it shows. This week you need last week’s hours twice: once for payroll, once for an agency to invoice from.

1. A saved report. The payroll report opens on a page of its own, with paid time spread across the dates.
2. A period first. The period picker opens by itself, because a report needs one. Pick Last week from the presets, then Apply. It runs on live data.
3. Shaped for payroll. Employees down the left, shift dates across the top, the period’s total in the same row.
4. Build your own. When no saved report answers your question, the report builder opens with its three steps across the top: Dataset, Start and Design.
5. A template. It chooses the dataset for you: here, the Time Entry Log.
6. A name. Type one so everyone who opens Analytics knows what the report answers.
7. Values. On the Design step, they decide what gets counted. Add Gross Cost from the list beside Values, remove Unpaid Time, and set each value’s format with the gear: hours and minutes for time, euros for cost.
8. Rows. Below the values, they decide what each line is. Keep staffing agency, employee and date.
9. Filters. Further down, they narrow the report before it runs.
10. Filter a saved report instead. Open the Time Entry Log for last week, open Filters, and choose one agency.
11. The chip proves it. The active filter sits above the table, and only that agency’s people remain, with hours per activity and per day.
12. Export. Download as Excel, named so the agency recognises it.

The agency gets exactly the hours your devices recorded, from the same data as your payroll, to invoice from. The same report also goes out by email, straight from the table, to payroll or the agency.

Tips

• Set the period before anything else. A report with no period is the usual reason one looks empty or impossibly slow.
• Name a report for the question it answers. Everyone else sees that name in the gallery, not the fields behind it.
• Prefer filtering a saved report to building a new one. Most one-off questions are an existing report plus one filter.
• Set the format on each value. Hours that read as a decimal are the quickest way to lose an argument about a timesheet.
• Cost columns need the HR role. A manager building a labour report sees hours, output and rates, and no money at all.
• Already on Power BI, Tableau or Qlik? With the BI add-on, your BI tool reads the same data live and read-only, next to your other sources, for richer visuals and storytelling. See connecting BI tools.

Read more

The user guide covers reports, analytics and every field an entry carries.

Book a Demo.