Subject: Why are asset charges not calculated correctly when using Time-Based Rate Settings?
Customer Case:
The customer reports that asset charges are missing or appear incorrect when a Time-Based Rate Setting is applied. They want to understand how ON!Track calculates costs using monthly, weekly, and daily rates and why the calculated amount may differ from their expectations.
How does ON!Track work?
When a customer selects a Time-Based Rate Setting for an asset, ON!Track calculates charges based on the configured rate hierarchy:
- Monthly Rate and the number of days included in the monthly charge
- Weekly Rate and the number of days included in the weekly charge
- Daily Rate for any remaining chargeable days
A common point of confusion is how monthly charges are applied.
Monthly Rate Behavior
ON!Track evaluates each month separately. The calculation resets on the first day of every month.
If the number of Workdays on Site within a month reaches the configured threshold for the monthly rate (After 'X' workdays), ON!Track applies the full monthly charge.
Once the monthly rate has been applied:
- Additional workdays within that same month are not charged separately.
- The monthly lump-sum already covers all remaining days of that month.
- A new calculation begins on the first day of the following month.
Example
Rate configuration:
- Monthly Rate = $100
- Monthly Days = 20 days
- Weekly Rate = $35
- Weekly Days = 5 days
- Daily Rate = $12
Asset movement:
- Asset transferred into the jobsite: 1 January
- Asset transferred out of the jobsite: 17 March
Calculation:
January
- Workdays on Site exceed 20 days.
- Monthly Rate is applied.
Charge = $100
February
- Workdays on Site exceed 20 days.
- Monthly Rate is applied.
Charge = $100
March
After applying the monthly rate rules, the remaining chargeable days are evaluated.
- 15 workdays qualify for weekly charging.
- 15 days ÷ 5 days per week = 3 weeks
Weekly Charge = 3 × $35 = $105
- 2 chargeable days remain.
- Daily Rate applies to the remaining days.
Daily Charge = 2 × $12 = $24
Total Cost
| Period | Charge |
|---|---|
| January Monthly Rate | $100 |
| February Monthly Rate | $100 |
| March Weekly Rate | $105 |
| March Daily Rate | $24 |
Total Asset Cost = $329
This behavior is expected. When the configured monthly threshold is reached, ON!Track applies the full monthly rate and does not charge additional days within that month. The calculation then resets at the start of the next month and continues with the same logic.