Rate Tables - Billable and Cost Calculations

The Rate Table feature in WorklogPRO Cloud enables organizations to automatically convert time-based worklogs into monetary values. This powerful tool helps you:

• Calculate billable amounts for client invoicing

• Track internal costs for resource management

• Analyze project profitability

• Generate accurate financial reports from time tracking data

• Create multiple rate tables for different scenarios (billable rates, cost rates)

• Define flexible rules that apply different rates based on conditions

• Apply rate tables to reports to see financial metrics

• Share rate tables across your organization

• Export and import rate tables between instances or privacy

WorklogPRO Cloud supports two types of rate tables:

• Calculate the revenue or billable amount for each hour worked

• Used to determine what clients should be charged

• Helps with invoicing and revenue recognition

• Calculate the internal cost for each hour worked

• Used to determine payroll and resource costs

• Helps with budget tracking and cost analysis

When you use both a Billable and Cost rate table with the same currency, WorklogPRO automatically calculates:

• Profit = Billable Amount - Cost Amount

• Profit Margin = (Profit ÷ Billable Amount) × 100%

This gives you instant visibility into project profitability.

Each rate table contains:

1. Default Rate - Applied to all worklogs that don't match any rule

2. Rules - Conditional overrides that apply different rates based on criteria

When calculating rates for a worklog, the system:

1. Evaluates rules from highest to lowest priority

2. Uses the first rule where ALL conditions match

3. Falls back to the default rate if no rules match