Weekly timesheets are used to record total hours worked by employees across a full week. They provide a structured summary of time spent on projects, supporting payroll processing, cost tracking, and workforce management.
By integrating Dashpivot weekly timesheets with Excel via Flowsite, you can:
Automate payroll calculations – Sync weekly hours and apply pay rules automatically
Centralise timesheet data – Store all employee hours in one structured Excel file
Track hours by project – Allocate time across single or multiple projects
Improve accuracy – Reduce manual entry and ensure consistent records
Enable reporting – Filter and summarise data by week, employee, or project
Stay audit-ready – Maintain clear, traceable payroll and timesheet records
Weekly timesheet structure
A weekly timesheet captures total hours worked per employee for a given week. Data is typically entered in structured table fields, allowing breakdowns by hour types, cost codes, and projects.
Single project weekly timesheet
Used to track hours for employees working on one project or workplace. Hours are entered in a structured table field, allowing clear allocation to each project and cost code.
Key features:
1. Weekly summary with breakdown
Summarises total hours per employee for the week
Includes regular hours, overtime, and double time (or custom hour types)
2. Integrated payroll system
Calculates pay based on hourly rates and hour types
Supports deductions, allowances, and total pay per employee
3. Filter by week
Adjust summaries based on the selected week for easy review and reporting
Multiple project weekly timesheet
Used to track hours across multiple projects in one timesheet. Hours are entered in a structured table field, allowing clear allocation to each project and cost code. The employee list changes based on the selected project and week.
Key features:
1. Weekly summary with breakdown
Tracks total hours per employee each week
Includes regular, overtime, and custom hour types
2. Payroll system
Calculates pay based on hourly rates and hour types
Supports deductions, allowances, and totals
3. Dynamic employee list
Employee names update based on the selected project and week
4. Filter by week
View and adjust summaries based on the selected week
5. Multi-project support
Track and manage hours across multiple projects in one file
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.
See: How to Configure Dashpivot Data in Power Query (Excel/Power BI via Flowsite).
2. Create a flow
Select your Weekly Timesheet template in Dashpivot.
Choose Excel as the destination.
Set the recurring time in the Flow Editor (e.g. daily or weekly).
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.
3. Configure your Excel file
Select or create the Excel file.
Structure columns (e.g. employee, week, project, hours, cost code, pay types).
4. Test the workflow
Submit a sample weekly timesheet in Dashpivot.
Trigger the flow.
Confirm the data appears correctly in Excel.