Labor report for 5.7.14 time clock

V5 Question
1

These reports will work with Metrik

Hello here is a useful labor report that works with the new time clock in 5.7.14

image
image973×605 39 KB

[Labor Report:1,1,1,1,1,1]
>Net Sales|Checks|Check Avg|Labor Hrs|Labor $|Labor $/Net
{TIMECLOCK DETAILS:T.TotalHours.sum,T.TotalWage.sum::{REPORT TICKET DETAILS:T.PlainSum.sum:(TS.Status=Paid)}|{REPORT TICKET DETAILS:T.TicketNumber.count:(TS.Status=Paid)}|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum:(TS.Status=Paid)}')/TN('{REPORT TICKET DETAILS:T.TicketNumber.count:(TS.Status=Paid)}'))]|{0}|{1}|[=F(TN('{1}')/TN('{REPORT TICKET DETAILS:T.PlainSum.sum:(TS.Status=Paid)}')*100)] %}
2 Likes
2

Here is another one that you may find useful. Reminder that you must have 5.7.14 for this to work and you must be using the new built in time clock.

[Payroll Summary:2,1, 1, 1, 1,1] 
>Name|Role|Card Tip|Total Hours|Total Wages
{TIMECLOCK DETAILS:T.Name.asc,T.RoleName,T.CardTip.sum,T.TotalHours.sum,T.TotalWage.sum::{0}|{1}|${2}|{3}|${4}}

@{TIMECLOCK DETAILS:T.Name.asc,T.Date,T.TotalHours.sum::{0}:,}
[$1:1,1,1,1,1,1]
{TIMECLOCK DETAILS:T.Name,T.ClockIn,T.ClockOut,T.TotalHours,T.TotalWage,T.Date.asc:T.Name == "$1":[=FD('{5}','ddd, MMM d')]|{0}|[=FD('{1}','h\:mm tt')]|[=FD('{2}','h\:mm tt')]|{3}|${4}}

image
image1280×830 100 KB

2 Likes
3

thank you very much. Always contributing and giving us your time and knowledge.

1 Like