If your business tracks revenue alongside staff costs for scheduling and reporting purposes, you can import revenue figures directly into Droppah.
Who Can Import Revenue?
The Import Revenue option is available to:
Admins, or
Team Managers who have “Pay Rates Visible” enabled (configured under Manage > Teams > Team Managers > Click into Manager)
The Import Revenue option can be found in the ⋮ menu on the Calendar > Timesheets Page. Your company will need to be on a plan with rostering and have the cost setting toggled on.
Preparing Your CSV File
To import revenue, your CSV file must include the following columns:
Column Title | Description |
Team Name | Must exactly match a team name in your Droppah account. |
Revenue Date | Accepted formats: DD/MM/YYYY, DD-MM-YYYY, YYYY/MM/DD, YYYY-MM-DD |
Revenue Time (optional) | Optional. Time formats accepted: H:mm, HH:mm, H:mm a, HH:mm a, H:mma, HH:mma |
Gross Amount | Numeric value. May be tax inclusive or exclusive. This is the value shown in Droppah and reports. |
Tax Amount (optional) | Optional. Numeric value. Not displayed in-app but may be used in future reporting. |
Column headers must exactly match the names above. Any differences will result in errors.
See the attached file at the bottom of this article for a revenue import template.
Uploading Your File
Navigate to Calendar > Timesheets.
Open the ⋮ menu in the top right.
Ensure the Costs setting is toggled on.
Select Import Revenue…
Upload your prepared CSV file.
Droppah will automatically check for:
Missing or incorrect column names.
Invalid values.
Confirm & Import
If no issues are found:
A confirmation modal will show how many records will be imported.
Click Import to proceed with bulk inserting the revenue records
Once imported, revenue figures appear alongside staff costs on the Timesheets view and are included in Insights Reports.
For more details on how to use your revenue data in Droppah see: Revenue & Labour Costs.
All Accepted Date Formats
All Accepted Date Formats
Date Format | Example |
DD/MM/YYYY | 08/07/2025 |
D/M/YYYY | 8/7/2025 |
DD/MM/YY | 08/07/25 |
D/M/YY | 8/7/25 |
DD-MM-YYYY | 08-07-2025 |
D-M-YYYY | 8-7-2025 |
DD-MM-YY | 08-07-25 |
D-M-YY | 8-7-25 |
YYYY/MM/YY | 2025/07/08 |
YYYY/M/D | 2025/7/8 |
YYYY-MM-DD | 2025-07-08 |
YYYY-M-D | 2025-7-8 |