🎯 Overview
Understanding, verifying, and reconciling your payroll has never been easier. With Jombone’s Download Invoice option, users can quickly export a clean, structured Excel invoice containing only approved hours across jobs and candidates—ensuring accuracy, transparency, and real-time financial oversight.
📍 Where to Find It
The Download Invoice option is available within the Timesheets tab of the Staffing Workspace for the following user roles:
Workforce Admin (WA)
Operations Admin (Ops Admin)
Back Office (BO)
External Users
🔽 Navigation Steps:
Go to the Timesheets tab under the relevant company or global.
Click the three-dot menu (⋮) at the top right corner.
Select Download > Download Invoice.
📂 A file named like Payroll_Invoice_Data_WE_YYYY-MM-DD.xlsx will automatically download to your device.
📘 What's Inside the Excel?
Each row in the Excel file represents a candidate’s approved shift(s) and includes key payroll and billing details. Here's a breakdown of the columns:
Column | Description |
Company Legal Name | Name of the legal company where the job is assigned |
Company Location Name | Specific location under the company |
Job Title | Job title as per the timesheet |
Candidate Full Name | Full name of the candidate |
Jombone ID | Unique system identifier for each candidate |
Type | Pay type: |
Emp Time Policy | Indicates |
Max Time | Maximum allowable shift time |
Total Hours | Approved time duration in HH:MM format |
Total Hours Decimal | Same as Total Hours, converted to decimal |
Pay Rate | Hourly rate paid to the worker |
Regular Wages | Gross wages (Pay Rate × Hours Worked) |
Markup % | Percentage markup |
Markup Rate/Bill Rate | Final billable hourly rate to the client |
Amount | Total amount for that entry |
🟡 Note: Only approved hours appear in the invoice. Commute or saved hours are not included.
🏢 Consolidated Company View
This invoice sheet is consolidated for all companies and their locations within a single staffing company. This means:
You get a single downloadable file covering all activity across the selected week
It provides a centralized view of hours, billing, and pay across different job orders, locations, and client companies
No need to download invoices company-by-company—it's all in one place
📅 Stat Pay Calculation Tab (Auto-Included If Applicable)
If any statutory holiday (e.g., Labour Day) falls within the week:
A new tab named
Stat Pay Calculationwill be addedBased on the worker’s eligibility by province
Includes audit fields & logic-driven calculations
📑 Key Columns in Stat Pay Calculation Sheet
Column | Description |
🗂️ Company / Location | Company & work site |
🧍 Candidate Name | Full candidate name |
🌍 Province | Work province (drives rule logic) |
📆 Holiday Name | Stat holiday (e.g., Labour Day) |
✅ Worked 1 Day Before / After | Yes/No eligibility flags |
🧮 Working Days in 30/365 Days | History for qualification |
💼 Employed Before Start | Duration before stat |
💰 Regular / Vacation Pay | Used for stat pay math |
🎯 Eligible Stat Pay | Final amount granted |
⚠️ Error Messages | Explains if stat pay is not granted (e.g., “Not eligible for Labour Day Stat Pay”) |
🎯 Why This Page is Important
This export ensures that:
Invoicing is based solely on verified timesheets
You can analyse, audit, and reconcile hours with ease
External users (clients) can view what they’re billed for, line by line
Payroll teams get a ready-to-import document for internal accounting tools
📊 Auto-calculated Stat Pay based on legislation
⚠️ Error flags for non-eligible workers
It’s especially critical during statutory holiday weeks when payroll needs compliance assurance.
✅ Key Tips & Points to Remember
✅ Ensure hours are approved to reflect in the invoice.
❌ Unapproved hour won’t be captured.
📅 Use the date selector to filter weeks of interest.
🔁 You can regenerate/download the invoice as needed—data is always live.
👥 Excel can show multiple job IDs and shifts for the same candidate if applicable.
🏢 Covers all companies and locations—no need for separate downloads per entity.
📅 Stat pay logic varies by province; the tab appears only when applicable.