Learn about all the different reports SmartBarrel offers, and which scenarios they work best in.
SmartBarrel Reports
Custom Company Payroll Detailed
Filters:
- *Select Date Range: 0-4 weeks
- *Column Selector
- Projects
- Contractors
- Divisions
Calculates Payment Profile: Yes
Shows $ Amounts: Yes
Per Diem: Yes
Format(s): Data Grid
Use Case: View detailed payroll information in a customizable data grid format.
Description: Shift data will be loaded vertically with each row representing hours assigned to a date, a project, and shift productivity. The data grid format allows you to customize the columns, export to xls or csv, and visualize your payroll data with charts and grouping features.
Master Report
Filters:
- *Select Date Range: Open-ended
- Projects
- Contractors
- Column Selector
- Shift Type
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: Yes
Format(s): Data Grid
Use Case: View non-payroll data in a customizable data grid format.
Description: Shift data will be loaded vertically with each row representing hours assigned to a date, a project, and shift productivity. The data grid format allows you to customize the columns, export to xls or csv, and visualize your payroll data with charts and grouping features. This report does not calculate payment profiles or dollar amounts.
Payroll
Company Payroll Detailed
Filters:
- *Select Week
- Shift Type
-
*Contractor
Calculates Payment Profile: Yes
Shows $ Amounts: Yes
Per Diem: No
Format(s): xls
Use Case: Weekly Payroll, IIF Converter for Quickbooks
Description: Shift data will be loaded vertically with each row representing hours assigned to a date, a project, and shift productivity.
Company Weekly Timesheet
Filters:
- *Select Date Range: 0-4 weeks
- Column Selector
- Projects
- Contractors
- Shift Type
- Divisions
Calculates Payment Profile: Yes
Shows $ Amounts: Yes
Per Diem: Yes
Format(s): xls
Use Case: View detailed payroll information in left-to-right timesheet format.
Description: Shift data will be loaded on the left-hand side, and then the hours will be displayed chronologically from left to right. Each date will have an RT and OT column, if applicable a DT column will also be generated. Some workers may have multiple rows if their shifts contain multiple projects or productivity assignments. Each worker will have a bolded row at the end of their section that represents all of their totals in the data range. Per Diem calculations will be based on per diem eligibility from the timesheet multiplied by the worker's daily per diem rate.
Daily Project Timesheet
Filters:
- *Select Date
- Column Selector
- *Project
- Contractors
- Shift Type
Calculates Payment Profile: No
Shows $ Amounts: Yes
Per Diem: No
Format(s): XLS, PDF
Use Case: Review and document a project's timesheet for a specific day
Description: Limited to 1 project, this report will show you all contractors and their workers that punched in on the selected date. It will show you total hours and total pay (without calculating overtime).
Employee Hours
Filters:
- *Start Date
- *End Date
- Contractors
- Projects
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls
Use Case: View shift information with cost code and total hours over long date ranges
Description: Shows shift and cost code information row by row. The last row for each worker will be bolded and contain their total hours worked within the date range. This report does not calculate payment profiles or dollar amounts but can be run for long date ranges.
Employee Timecard
Filters:
- *Select Week
- Contractors
- Shift Type
Calculates Payment Profile: Yes
Shows $ Amounts: No
Per Diem: No
Format(s): xls, pdf
Use Case: Review payroll in timecard format for each worker
Description: Generates a timecard for each worker that fits the selected filters. Each row in the timecard represents hours worked on a cost code and project, the hours will be represented with 1 column per day of the week. There will be a summary section with total hours by type.
Payroll Detailed Enhanced
Filters:
- *Select Week
-
*Contractor
- Column Selector
- Shift Type
Calculates Payment Profile: Yes
Shows $ Amounts: Yes
Per Diem: Yes
Format(s): xls, pdf
Use Case: Weekly payroll with automatic per diem
Description: Shift data will be loaded vertically with each row representing hours assigned to a date, a project, and shift productivity. Data will be grouped and totaled by project and sorted by worker. Worker's per diem amounts will be calculated based on days worked multiplied by their daily rate. If the worker has a weekly per diem rate, they will get that rate if they have any activity during the week.
Project Payroll Detailed
Filters:
- *Select Week
- Shift Type
- *Project
-
*Contractors
Calculates Payment Profile: Yes
Shows $ Amounts: Yes
Per Diem: No
Format(s): xls, pdf
Use Case: Weekly Payroll for projects with subcontractors
Description: Shows shift and cost code information row by row for a specific project. The last row for each worker will be bolded and contain their total hours worked within the date range. Sorted alphabetically by first name
Project Weekly Timesheet
Filters:
- *Select Date Range: 0-4 weeks
- Column Selector
- *Project
- Contractors
- Shift Type
- Show Reporting
Calculates Payment Profile: Yes
Shows $ Amounts: Yes
Per Diem: Yes
Format(s): xls, pdf
Use Case: View detailed payroll information in left-to-right timesheet format for a specific project.
Description: Shift data will be loaded on the left-hand side, and then the hours will be displayed chronologically from left to right. Some workers may have multiple rows if their shifts contain multiple projects or productivity assignments. e.
Worker Timesheet
Filters:
- *Select Week
- Column Selector
- *Contractor
- Workers
- Shift Type
Calculates Payment Profile: Yes
Shows $ Amounts: yes
Per Diem: No
Format(s): xls, pdf
Use Case: Review weekly payroll for specific workers
Description: detailed payroll report for a worker or group of workers. The PDF version will generate a single page for each worker, the Excel version will generate a new sheet in the Excel file for each selected worker.
Operations
Company Time Card Detailed
Filters:
- *Select Week
- Shift Type
- *Projects
Calculates Payment Profile:
Shows $ Amounts:
Per Diem: Yes
Format(s): xls
Use Case: Review hours in a weekly timesheet format with custom per diem logic
Description: This report is required to run on dates that are Monday through Sunday. The shift data will be loaded on the left-hand side, and then the hours will be displayed chronologically left to right with the weekday names as the headers. Each worker will have a per diem row, and the timesheet per diem eligibility will be tracked. For this report, they are considered codes, so the end of the report sums the days where per diem applies and does not sum the total eligibility values. For example, if every weekday has "2" in per diem, the total will still be 5 at the end of the week.
Daily Report
Filters:
- *Select Date
- Column Selector
- *Projects
- *Contractors
- Shift Type
- Show Reporting
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls, pdf (recommended)
Use Case: Daily documentation of project attendance, work summary, toolbox talks, and incidents.
Description: Can be run for a single project on a single day, it will show every worker that was present on that day with their start and stop time. The PDF version will also show each worker's punch pictures. The first section will contain a data summary, and the field logs will populate at the end of the report and also include any attachments in the PDF version.
Employee Change Log
Filters:
- *Start Date
- *End Date
- Column Selector
- Projects
- Contractor
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls, pdf
Use Case: Review manual timesheet adjustments before running payroll reports.
Description: Will display individual timecards for each worker. Anything that has been manually adjusted will be highlighted in blue. Open shifts and unclassified shifts will be highlighted in red.
Employee Executive Summary:
Filters:
- *Select Start Date
- Projects
- Contractors
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls, pdf
Use Case: Total hours per worker over a 2 week period
Description: Data is organized in a timesheet format with each column being a date. It can display any 2 week time period. It will create a row for each worker with activity and display their total hours in the last column.
Headcount Attendance:
Filters:
- *Start Date
- *End Date
- Shift Type
- *Project
- Contractors
Calculates Payment Profile: no
Shows $ Amounts: no
Per Diem: no
Format(s): xls, pdf
Use Case: Review the number of unique workers per contractor over a period of time for an individual project.
Description: Each column will represent the unique workers per day. Each row will represent the contractor. This report can be run for a single project for an unlimited date range.
Job Hours
Filters:
- *Select Date Range
- Select Columns
- *Project
- contractors
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls
Use Case: Show a worker's hours alongside badge ID
Description: This report can be run for an unlimited date range and will show a workers total hours alongside their Badge ID and Position.
Productivity Breakdown
Filters:
- *Select Project
- *Data
- *Show
- *Group By
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls
Use Case: Assess a project's performance against it's labor budget
Description: Provides a breakdown of hours for cost codes and compares the budgeted hours to actual hours used. Also calculates the remaining hours along with the percentage of hours used. Additionally, a weekly timeline can be shown in the detailed view.
Project Hours Timesheet
Filters:
- *Select Date Range
- Column Selector
- *Project
- Contractors
- Shift Type
- Show Reporting
Calculates Payment Profile: No
Shows $ Amounts: Yes
Per Diem: Yes
Format(s): xls, pdf
Use Case: View detailed hours information in left-to-right timesheet format for a specific project.
Description: Shift-data will be loaded on the left-hand side, and then the hours will be displayed chronologically left to right. Some workers may have multiple rows if their shifts contain multiple projects or productivity assignments.
Project Weekly Compliance
Filters:
- *Select Week
- *Select Project
- Contractors
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls
Use Case: See total hours by classification with custom project approval
Description: Shows the hours by classification in a timesheet format for a week. At the top will be the written disclaimer that the workers agree to when they submit their hours at the punch-out.
Punch Analysis
Filters:
- *Select Date Range
- Select Columns
- Contractors
- *Project
- Shift Type
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls
Use Case: Audit irregular punches
Description: Shows detailed punch information including edits, distance, verification and more. Best for finding and investigating irregular cases.
Punch Change Log
Filters:
- *Select Date Range
- Contractors
- Divisions
- Projects
- Crews
- Shift Type
- Column Selector
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls
Use Case: Review manual timesheet adjustments and the total time being added/subtracted manually.
Description: Will display a table of all shifts, manually modified punches and shifts will be highlighted in blue. The +/- column will show the total hours being added or subtracted by manual modifications.
Attendance
Compliance Daily Attendance
Filters:
- *Select Date
- *Select Project
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls, pdf
Use Case: Report who showed up each day for each contractor
Description: This report will give you the total number of workers per contractor with a list of attendees for a single project on a single day. This report is useful for certified payroll documentation for general contractors.
Project Weekly Attendance
Filters:
- *Select Week
- *Select Project
- Contractors
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): xls, pdf
Use Case: Record and document attendance for a project
Description: This report will mark attendance for each day over a week for every contractor and worker on a project. Each day attended will be marked with an X on Excel and a checkmark on the pdf.
Subcontractor Management
Company Weekly Payment
Filters:
- *Select Week
- Select Columns
- Contractors
- Shift Type
- Projects
Calculates Payment Profile: No
Shows $ Amounts: Yes
Per Diem: Yes
Format(s): xls
Use Case: Calculate the total amount billable for subcontractors
Description: Shows the hours per day for each worker in a timesheet format. It will calculate the total pay with a simple rate*hours formula and does not calculate the payment profile. Per diem will be calculated by active days times daily per diem rate. The total amount will be the total pay plus the per diem.
Integrations
Points North Import
Filters:
- *Select Week
- *Contractor
- Projects
- Shift Type
Calculates Payment Profile: No
Shows $ Amounts: No
Per Diem: No
Format(s): csv
Use Case: Upload Classification data to Points North
Description: Shows each worker's classifications worked per day over a pay period for a specific contractor. Useful to upload certified payroll data into Points North and maintain compliance.
Smart Labor Import
Filters:
- *Select Week
- Contractors
- *Project
- Shift Type
Calculates Payment Profile: Yes
Shows $ Amounts: No
Per Diem: No
Format(s): No
Use Case: Upload temp labor and staffing hours to Smart Labor Management.
Description: Each row represents a worker's hours, cost code, job site, and the date the hours were worked on. The report can be run for a single project with multiple contractors. This data can be uploaded to Smart Labor. ST = straight Time and OT = Overtime.