Skip to main content

Understand invoice calculation matrix effects

In this article, we explain how to understand the invoice calculation matrix effects.

L
Written by Lucy Robbie
Updated over a week ago

Using the Fixed Invoicing screen as an example, the following describes the effects of the options.

In this case, the fixed invoice has a base type of Monthly. This means that the Monthly tab on the Invoice Calculation Matrix screen determines how the values of the fixed invoice are calculated.

The Invoice Calculation Matrix is set up as follows:

  • Daily Calculation: (Monthly x 12) / 365

  • Weekly Calculation: (Monthly x 12) / Weeks per Year Override

  • Annually Calculation: Monthly x 12

  • Weeks per Year: 53

The effect on the Fixed Invoice screen can be seen below:

The greyed-out Calculated text boxes are calculated as follows:

  • Daily - 1000 (from Value text box) x 12 / 365 = 1000 x 12 / 365 = 32.88

  • Weekly - 1000 x 12 / 53 (from Weeks per Year Override text box) = 226.42

  • Monthly - 1000 (This is copied from the Value text box and is unchanged).

  • Annually - 1000 x 12 = 12000

If changing the Weekly Calculation option on the Invoice Calculation Matrix screen to (Monthly x 12) / 52, the resulting Weekly Fixed Invoice calculated value are:

1000 x 12 / 52 = 230.77.

Did this answer your question?