Skip to main content

Enable and configure an invoice calculation matrix

In this article, we explain how to enable and configure an invoice calculation matrix.

L
Written by Lucy Robbie
Updated over a week ago

Enable

The invoice calculation matrix functionality is enabled automatically when the respective Modules & Functions for Fixed Invoicing and Service Packages are enabled.

There is also an additional setting called Invoice Calculation Matrix Profiles that restricts access to assigning a specific matrix profile to a customer record.

Once enabled, the Invoice Calculation Matrix Profiles Module & Function can be enabled or disabled at the user and profile levels; again, this is through the support team.

Profile

  1. Click Settings, then click Other.

  2. Click Profile & Users, then click Modules & Functions.

  3. Select the relevant record, then from the QuickLinks click Modules.

  4. Click Bill Payer, then select the Invoice Calculation Matrix Profile checkbox.

Users

  1. Click Settings, then click Other.

  2. Click Profile & Users, then click Users.

  3. Select the relevant record.

  4. From the QuickLinks click Modules & Functions.

  5. Click Bill Payer, then select the Invoice Calculation Matrix Profile checkbox.


Configure

Once the Module & Functions have been enabled, the invoice calculation matrix feature can be configured.

To configure the invoice calculation matrix, follow these steps.

  1. Click Settings, then click Finance,

  2. Click Invoice, then click Calculation Matrix.

On the Calculation Matrix screen, there are several options to choose from that apply to Daily, Weekly, Monthly, and Annual calculations.

The available options within each calculation drop-down are as follows:

Daily

Tab

Field

Option

Daily

Weekly Calculation

(Daily x 365) / 52

Daily

Weekly Calculation

Daily x 7

Daily

Monthly Calculation

(Daily x 365) / 12

Daily

Annually Calculation

Daily x 365

Weekly

Tab

Field

Option

Weekly

Daily Calculation

(Weekly x 52) / 365

Weekly

Daily Calculation

Weekly / 7

Weekly

Monthly Calculation

(Weekly x 52) / 12

Weekly

Annually Calculation

Weekly x 52

Weekly

Annually Calculation

(Weekly / 7) x 365

Monthly

Tab

Field

Option

Monthly

Daily Calculation

(Monthly x 12) / 365

Monthly

Weekly Calculation

(Monthly x 12) / 52

Monthly

Weekly Calculation

(Monthly x 12) / Weeks per Year Override

Monthly

Annually Calculation

Monthly x 12

Annually

Tab

Field

Option

Annually

Daily Calculation

Annually / 365

Annually

Daily Calculation

Annually / 365.25

Annually

Weekly Calculation

Annually / 52

Annually

Weekly Calculation

Annually / Weeks per Year Override

Annually

Monthly Calculation

Annually / 12

The Weeks per Year field allows the number of weeks per year to be overridden based on the required calculation. This field is shared across all tabs and is referenced in the / Weeks per Year Override options for the Weekly Calculation on the Monthly and Annually tabs.

If no value is entered in the Weeks per year field, the default value of 52.143 weeks are used.

The Weeks per Year field has validation, which means the value entered cannot be less than 52 or greater than 53.

Did this answer your question?