Skip to main content

Billing Rules

See the scheme below to find out how the Billing Rules convert billing sources (Time Sheet & Billing Items) into Draft Invoice.

Billing---en.png

Each Billing Rule is a definition for one or more draft invoices to be created.

billing-rules-general.png

Billing Sources

Billing Items

The Draft Invoice is created automatically created from any Billing Items that are in For Approval or Approved status (Pending or Posponed/Canceled items are excluded).

Time Sheet Records

Any Time Sheet records that are in For Approval (Confirmed) or Approved states and are Chargeable at the same time are used for billing.

Free Quantity set-up in the same billing period & context (using Biling Items) is used as compensation and is deducted on fair rate principle from billed Time Sheet records.

Recurring Fees

Recurring Fees are created periodically based on the template set-up in Billing Options on client folder. You can set-up Daily, Weekly, Monthly, Quarterly or Yearly recurring fees to be automatically created when the period occurs.

Fees may also be automatically created, when new Activity is created. Activites may be created manually (when order for the service happens) or (using module Workflow) you can create Activity on the Project automatically (every month, quarter, etc.).

Billing Rule Priorities

Billing Rules are executed based on prioritization of the order of Billing Rules.

Custom Rules (on client's folder detail) are always considered higher priority than general Billing Rules, set-up for the whole organization.

You can set individual Billing Rule priority. Use arrows (>) or (<) to set order of the Billing Rule execution.

Billing Period

Draft Invoices are prepared automatically based on billing sources for last 2 years.

Any period

The Draft Invoice is created whenever there is something to be invoiced. Only one invoice is created for the whole period (automatically last 2 years of billing sources).

Weekly, Monthly, Quarterly, Yearly

The Draft Invoice is created in any of the above periods, one invoice for each period. The transaction (tax) date is always set to the end of the period.

Quarterly 2, Quarterly 3

The quarter is calculated starting 2nd month in the calendar quarter or 3rd month. Ie for Quarterly 2, the II. Q. starts May and ends July.

Billing Context

Billing Context rule for grouping Billing Sources into one or more invoices.

 

Column Options
Template Number Move priority of the Billing rule using buttons (up,down). 1st row is executed first.
Billing Period Yearly, Quarterly, Quarterly 2, Quarterly 3, Monthly, Weekly, Any Period

Projects

(not in Default Billing Rules)

Any project
Selection of multiple projects
Each project

Activities

(not in Default Billing Rules)

Any activity
Selection of multiple activities
Each activity
Products Any product
Selection of multiple products
Type of project Any type of project
Selection of multiple types of projects
Each type of project
Type of activity Any type of activity
Selection of multiple types of activities
Each type of activity

Time Sheet Billing Rules

Rules for grouping Time Sheet records into Billing Items, identifying also whether the work performed under selected Type of Work should be billed at all. You can also define whether any agreement on "Free Hours" compensation should apply.

  • Order - defines order of rule execution. Column order contains two buttons with arrows Up and Down, which increases or decreases the order value
  • Type Of Work - select Types of Work that are grouped together to create Billing Item
  • Billable - Yes / No - set whether the Time Sheet will be billed or not. In case the recores are set to Billable = No, but at the same time the work is set to Chargeable (on Time Sheet record), the work time is compensated with any Free Hours agreed.
  • Create Billing Item - mandatory field that sets Product (or Service) that should be entered into new invoice when charging Time Sheet.
  • Use Budget Items - select where we should look for Free Hours. Free Hours is any "Free Quantity" set in the same Billing Context. Because there might be more different Billing Items (Products or Services) that contain Free Quantity, you have an option to select just the corresponding Product or Services (in such case compensation for Free Quantity in other Billing Items defined in the same Billing Context is avoided)

Budget items are any Billing Items that contain "Free Qty" value (and Status is not 0, Postponed, Canceled).

Free Hours Compensation

If you select the option to Use Budget Items to <any> or you select some Products that should the system use when looking for Free Quantity available (in Billing Items), the process of calculating billable time takes available free quantity in consideration.

If there are more rates (Unit Prices) in Time Sheet records used, the system calculates fair value of the rate & consumes No. of hours accordingly. The fair value is calculated as weighted average of rates.

Calculating total free hours

Based on each time sheet billing rule, calculate free quantity available. That means sum all free quantity value of Billing Items for period & context defined by the Billing Rules (avoid using 0, canceled or postponed status items) and deduct any free quantity that has been used already during the process of allocating free quantity to Time Sheet records.

During allocating free hours, note the quantity that has been used already, so the max. total free quantity allocated to time sheet records does not exceed the total free quantity available.

Fair-based allocation of free hours to time sheet
In each period & context, various time sheet rates may apply. Due to this fact, we should deduct free hours proportionally, based on the total hours of charged work.
1. Group all chargeable time sheets from given period & context by calculated hourly rate
2. Sum number of chargeable hours
3. Divide total free hours by number of chargeable hours = split coefficient
4. If the ratio is below 1 (that means there is more chargeable hours than free hours), you can calculate the total free hours per rate that will be compensated (multiply number of chargeable hours per rate * split coefficient)
5. Use the free hours per rate in the extent available and mark down the Used Free Hours with each individual Time Sheet record, similarly add the same for Billing Items (to know that the Free Hours have been used already.

Time Sheet Billing Scenarios / Examples

General Scenario

General scenario, how the billing item is created from time sheet is:

  1. User enters Time Sheet, that is in confirmed state (Pending Time Sheets are not entered into Billing Items). This Time Sheet can be chargeable or non/chargeable
  2. Cost / Revenue rates are entered automatically into Time Sheet records using Work Price List
  3. All Confirmed or Approved Time Sheet records that are Chargeable will be entered into Billing Items
  4. Created Billing Items entered into Draft Invoice, which after approval converts to new invoice automatically.

There can be usually few situations, which you want to set. They are described in the following text, where you can find the situation, the setting of Time Sheet Billing Rules and the result description.

All work is billable

Put all chargeable time sheet into invoicing (no matter whether there is any remaining budget).

Rule Value
Type of work All
Billable Yes
Create Billing Item Use default billing item settings
Use Budget Items (none) 

billing-scenario-all-time-sheet-billable.png

Result

Any time sheet will be invoiced => Billing Item will be created, based on Type of Work to Billing item settings.

No work is billable

The company has budget limit, which can not be exceeded. No work that is entered into time sheet is billed (no matter what is the "chargeability" status).

Rule Value
Type of work All
Billable No
Create Billing Item Use default billing item settings
Use Budget Items Any

billing-scenario-no-time-sheet-billable.png

Result

Any time sheet will be entered into billing items, but witout charging any value (that is the resulting Billing item Unit Price = 0). Any free quantity from billing items will be used to pay for the time sheet hours, but if there is any remaining hours to be charged, they won't be charged (but the Billing Item with Qty = X will be created, where X is the remaining calculated hours after deducting Free qty).

Part of the work is covered by budget

Some types of work are not billable, some are billable, but the budget of Free Quantity is used.

Rule Value
Type of work Multiple ToW selected
Billable Yes
Create Billing Item Use particular item: "Extra work: payroll"
Use Budget Items Use budget item(s): Payroll Services, Payroll Fixed Fees

billing-scenario-free-quantity-compensation.png

Result

Any time sheet that belongs to selected ToW is entered into Billing Items, with compensation by existing Free Quantity in Billing Items: Payroll Services or Payroll Fixed Fees. New item is created as "Extra work: Payroll".

Part of the work is not billable

Some types of work can not be charged to clients.

Rule Value
Type of work Multiple ToW selected
Billable No
Create Billing Item Use default billing item settings
Use Budget Items Any

billing-scenario-some-work-non-billable.png

Result

Type of work that is set as not billable can not be invoiced, but may (or may not: based on settings) consume any Free qty that is available.

Some work that is always billable

Some types of work will be billed, not compensating any availble budget. This work is usualy out of agreement, so it could be billed as extre work.

Rule Value
Type of work Multiple ToW selected
Billable Yes
Create Billing Item Use "Extra work" billing item
Use Budget Items (none)
Result

Type of work will be billed separately from other time sheet records. Will not compensate any budget available. Selected billing item will be used.