1. Navigate to the Time menu, then Roster Management.
2. Click the Actions dropdown in the top-right corner.
3. Select Import Sales Data from the dropdown menu.
   
4. On the Import Sales Data section, click Download to retrieve the CSV template.
5. If you have existing sales data in the system, the downloaded file will include your current data (up to 1000 rows). If not, you'll receive a blank template with the required column headers.

The CSV template includes columns for:

• Date Timestamp.*
• Time.
• Email.
• Work Site.*
• My Forecast.
• Actual.*
• Transaction Count.

1. Open the downloaded CSV template in your spreadsheet application.
2. Fill in your sales data according to the template format, ensuring:
   • Work site names match exactly with those configured in Employment Hero
   • Numerical values are entered without currency symbols
   • All required fields are completed
     
3. Save the file as a CSV format.
4. Verify the file size is under 15MB.

Tip: Include historical sales data alongside forecasts to enable variance tracking and performance analysis.

1. Return to the Import Sales Data page (Time menu → Roster Management → Actions → Import Sales Data).
2. In the "Step 2. Upload your completed file in CSV format" section, click the upload area or drag your CSV file into the designated zone.
3. The system will validate your file. If successful, you'll see a confirmation message.
4. If validation errors occur, review the error messages, correct the issues in your CSV file, and upload again.
5. Once validation is successful, click Import to complete the upload.

Your sales data is now available in the Sales Data dashboard and will be integrated with your labour metrics.

To enable and configure Auto Forecast:

1. Navigate to Roster Management.
2. Click the Settings cog icon in the top toolbar.
3. Select Sales Data Settings from the left menu.
4. Under "Sales Forecasting", ensure the toggle is turned on.
5. Under "How should we predict future sales?", select your preferred forecasting method.
   
6. Click Save to apply your changes.

Once configured, the Auto Forecast column in your Sales Data dashboard will display predicted sales based on your selected method.

Choose from four forecasting methods based on your business needs:

1. AI Forecast

Uses advanced AI models to predict sales based on multiple factors including historical data, trends, and seasonal patterns. This method leverages machine learning to provide the most sophisticated forecasting available.

Best for: Businesses with complex seasonal patterns or multiple influencing factors.

2. Last 3 Weeks Average

Calculates the average sales for the same weekday over the most recent 3 weeks to forecast future sales.

Example: Forecasting Monday, Nov 24, 2025:

• Recent Mondays: Nov 17 ($115), Nov 10 ($120), Nov 3 ($110)
• Forecast = ($115 + $120 + $110) / 3 = $115

Best for: Stable businesses with consistent week-to-week patterns.

3. Compare to Last Year

Averages actual sales for the same weekday over the most recent 3 weeks, compares it to the same 3-week period from last year, calculates the percentage change, and applies it to last year's corresponding day.

Example: Forecasting Monday, Nov 24, 2025:

1. Recent 3 Mondays: Nov 17 ($115), Nov 10 ($120), Nov 3 ($110) → Average = $115
2. Last year's 3 Mondays: Nov 19, 2024 ($95), Nov 12, 2024 ($105), Nov 5, 2024 ($100) → Average = $100
3. Percentage change = ($115 – $100) / $100 = 15%
4. Apply growth to last year's corresponding day: Nov 26, 2024 = $107 → Nov 24, 2025 = $107 × 1.15 ≈ $123.05

Best for: Growing or declining businesses that need to account for year-over-year trends.

4. Same Day Last Year

Uses the average of the same date over the past 3 years (or available years) to account for highly seasonal patterns.

Example: Forecasting Nov 24, 2025:

• Nov 24, 2024: $110
• Nov 24, 2023: $105
• Nov 24, 2022: $120
• Forecast = ($110 + $105 + $120) / 3 ≈ $111.67

Best for: Businesses with strong calendar-based seasonality (e.g., retail with specific holiday patterns).

My Forecast represents your manually entered sales projections. You can input these values directly when importing sales data or editing the Sales Data dashboard.

Auto Forecast is the system-generated prediction based on your selected calculation method. Auto Forecast values are automatically calculated and updated based on your historical sales data.

Both columns appear in the Sales Data dashboard, allowing you to compare your manual forecasts against the system's predictions and actual sales performance.

1. Navigate to the Time menu, then Roster Management.
2. Click the Sales button located to the right of the settings icon in the top toolbar.
   
3. The Sales Data dashboard will open, displaying a summary view of all work sites.

The dashboard provides a consolidated overview of sales performance, labour hours, and costs across selected periods and work sites.

The Sales Data dashboard consists of two main sections:

Summary View (All Sites)

The top section displays aggregated data across all filtered work sites:

• Period: The time period for the data (Weekly, Daily, etc.)
• Work Site: The name of the work site
• Last Year: Sales figures from the same period last year
• Auto Forecast: System-generated sales predictions based on your selected forecasting method
• My Forecast: Your manually entered forecasted sales for the period
• Actual Sales: Confirmed sales figures
• Variance: The difference between forecast and actual sales (colour-coded green for positive, red for negative)
• Grand Total: Shows totals for Last Year, Auto Forecast, My Forecast, Actual Sales, and Variance across all work sites

Daily Breakdown (Individual Site)

Below the summary, you'll find a detailed breakdown for the selected work site:

• Day: Individual days or weekly aggregation
• Last Year / Auto Forecast / My Forecast / Actual / Variance: Sales data per day
• Budgeted Hour: Planned labour hours (editable)
• Scheduled Hour: Hours from published roster shifts
• Timesheet Hour: Actual hours worked from timesheets
• Hour Variance: Difference between scheduled and timesheet hours
• Budgeted Cost: Planned labour cost (editable)
• Scheduled Cost: Cost based on scheduled shifts
• Timesheet Cost: Actual labour cost from timesheets
• Cost Variance: Difference between scheduled and actual costs (colour-coded)

Variances are automatically calculated and colour-coded to help you quickly identify areas requiring attention.

Use the filters at the top of the Sales Data dashboard to customise your view:

Work Site Filter

• Select a specific work site from the dropdown to view its detailed breakdown
• The summary table will update to show only the selected site
• Click the X next to the work site name to remove the filter and view all sites

Period Filter

• Choose from Weekly, Daily, 2-Week, 4-Week, or Monthly views
• The breakdown section will adjust to show appropriate time granularity

Date Range Navigation

• Use the arrow buttons next to the date range to navigate to previous or next periods
• Click the date range itself to select a custom start and end date

You can edit certain fields directly in the Sales Data dashboard:

Editing Actual Sales

1. In the Daily Breakdown section, locate the day you want to update.
2. Click in the Actual field and enter the confirmed sales figure.
3. The variance will automatically recalculate.
4. Click Save to apply your changes.

Editing Budget Hours and Costs

1. Click in the Budgeted Hour or Budgeted Cost field for the relevant day.
2. Enter your budget value.
3. Click Save to update the budget.

Changes to budget hours and costs in the Sales Data dashboard will also be reflected in your Roster Management budget view.

Apply Percentage of Forecast to Budget Cost

You can automatically calculate budgeted costs based on a percentage of your forecast:

1. Tick the checkbox Apply % of My Forecast to Budgeted Cost above the Daily Breakdown table.
2. The system will calculate budgeted costs as a percentage of your forecast values across all days.
3. Review the calculated values and adjust individual days as needed.
4. Click Save to apply the changes.

This feature is particularly useful for maintaining consistent labour cost ratios relative to expected sales.

The Sales Data dashboard pulls labour information from multiple sources within Employment Hero:

• Scheduled Hours and Costs: Automatically imported from all shifts in Roster Management
• Timesheet Hours and Costs: Automatically imported from pending or approved timesheets in Timesheet Management
• Budget Hours and Costs: Can be set directly in the Sales Data dashboard or in the Roster Management budget view

This integration provides a complete picture of planned versus actual labour deployment, helping you identify staffing inefficiencies and opportunities for cost optimisation.

The Sales Data dashboard updates in real-time as changes occur in connected systems:

• When you publish or modify roster shifts, scheduled hours and costs update automatically
• When timesheets are submitted and approved, timesheet hours and costs are immediately reflected
• Budget changes made in the Sales Data dashboard sync to Roster Management budget views
• Auto Forecast values recalculate automatically when new actual sales data is added
• Variances recalculate instantly as underlying data changes

There is no need to manually refresh the dashboard—all data stays current across the platform.

Scheduled and timesheet data will only appear if:

• Shifts have been created in Roster Management for the selected date range
• Timesheets have been submitted (pending or approved) for the selected period
• The shifts and timesheets are assigned to the work site you're viewing

If you're viewing future dates, scheduled hours will appear once shifts are created, but timesheet data will not appear until employees work those shifts and submit timesheets.

Yes, your CSV file can include sales data for multiple work sites. Each row in the CSV should specify the work site name, and the system will automatically distribute the data to the appropriate sites when you upload the file.

After import, you can view consolidated data for all sites or filter to individual sites using the work site dropdown in the Sales Data dashboard.

You can update sales data in two ways:

• Re-import via CSV: Download your existing data, make changes, and upload the modified file. This will overwrite previous values for the affected periods and work sites.
• Manual editing: Edit Actual Sales figures directly in the Sales Data dashboard for quick adjustments without needing to re-upload a file.

For bulk updates across multiple sites or extended periods, CSV re-import is more efficient. For individual corrections, manual editing is faster.

Budget hours and costs are synchronised between the Sales Data dashboard and Roster Management:

• When you edit budgeted hours or costs in Sales Data, those changes will appear in the Budget view in Roster Management
• Similarly, budget changes made in Roster Management will be reflected in the Sales Data dashboard
• This ensures consistency across all views and prevents conflicting budget information

You can manage budgets from either location based on your workflow preference—the data remains synchronised across both interfaces.