Exports · Deputy
Deputy timesheets export to dashboard
Upload the file you already download from Deputy. Every Number reads it with no setup, picks a screen, and puts a receipt on every number.
The question behind this fileHow many hours and how much labour cost did each location and area run this pay period, including leave?
What you get
By person
One row per person, with their numbers side by side.
Employee Name says who worked each timesheet, so total hours and total cost are compared person by person.
Click any number for its receipt: the rule, the rows it used, and the rows it left out.
Getting the file
Download it from Deputy
When you export timesheets in Deputy, pick CSV/EXCEL - All fields, click Export, then Download.
Know what a row is
One row is one approved timesheet (person x shift).
Upload it as it is
No cleanup first. Title rows, totals rows and repeated headers are skipped and listed in each receipt.
The 18 columns we tested with, from Deputy's documentation
Employee Export Code · Employee Name · Date · Start · End · Mealbreak · Total Hours · Total Cost · Employee Comment · Area Export Code · Area Name · Location Code · Location Name · Leave · Manager's Comment · Firstname · Lastname · Rollover
How we know
This file is one of the 100 in our reading test. The column names are Deputy's; the rows were generated to fit them, since we don't have your file. Your export may have more or fewer columns, and Every Number shows how it read each one before you build.