Timesheets are used to record the hours worked by individuals or teams on a daily or weekly basis. They provide an accurate account of time spent on tasks or projects, supporting payroll, project costing, and workforce management.
By integrating Dashpivot timesheets with Excel via Flowsite, you can:
Eliminate manual data entry – Automatically sync timesheet data to Excel, reducing errors and saving admin time
Speed up payroll processing – Format raw data to match your payroll system
Improve accuracy – Ensure consistency between timesheet entries and payroll records
Create custom reports – Build summaries (e.g. total hours, overtime, cost codes) in Excel
Stay audit-ready – Filter records by employee, date, project, or cost code
Scale easily – Handle growing data volumes without increasing workload
Maintain flexibility – Export or integrate with systems like Xero or QuickBooks
Daily Timesheet Structure
A daily timesheet records hours worked by an individual or crew, including start and finish times, breaks, and total hours. Data is typically captured using table fields in Dashpivot.
Key features of this setup
1. Central timesheet data
One master table to log hours by employee, project, cost code, and date
Includes start/finish times, total hours, and activity details
2. Custom filters
Easily filter timesheet records by:
Employee
Project
Date
Task or location
This enables quick summaries and review of daily work logs.
How to set up the integration
1. Connect Dashpivot to Flowsite
Log in to Flowsite.
Go to Connections.
Find Dashpivot and click Connect.
Enter your Dashpivot credentials and authenticate.
Confirm the connection appears in your Connections table.
Tip: Configure your Dashpivot data correctly to avoid errors in your Excel file.
2. Create a flow
Select your Daily Timesheet template in Dashpivot.
Choose Excel as the destination.
Set the recurring time in the Flow Editor (e.g. hourly or daily).
Enter the Template ID:
Open your template in Dashpivot
Copy the 24-digit string in the URL
Paste it into the Template ID field
Enter required fields: URL, username, and password.
Note: The hosted source password is only visible when generated. Save it securely. If lost, you can regenerate it.
Set the update frequency.
See also:
1. Mac - https://help.sitemate.com/en/articles/9359337-how-to-connect-microsoft-excel-to-flowsite-on-mac
2. Windows - https://help.sitemate.com/en/articles/11032854-how-to-connect-microsoft-excel-to-flowsite-on-windows
3. Configure your Excel file
Select or create the Excel file.
Structure and format columns (e.g. employee, date, hours, cost code).
4. Test the workflow
Submit a sample timesheet in Dashpivot.
Trigger the flow manually.
Confirm the data appears correctly in Excel.