...
Depending on how rounding is configured, rounding discrepancies can arise. For example, the sum of invoice item totals may not add up exactly to the invoice total as shown on an invoiceconsider a scenario where two invoice line items on an invoice have a value of $10.0045 each, which totals to $20.009. However, if the invoice document format is configured to show invoice items to two decimal places, then the invoice will display $10.00 for each invoice item but the invoice total will be $20.01 (i.e. $20.009 rounded to two decimal places) resulting in a $0.01 discrepancy.
Additionally, when it comes to invoices, FastTrack360 will add grouped items together, and then apply the rounding to the sum of those items.
The following is a guide that explains how rounding is applied in FastTrack360, the various places in the system where rounding can be applied and what that rounding affects. Recommendations are also given as to how rounding should be configured at each point in the system to achieve the best results and to reduce rounding discrepancies.
...
Wherever rounding can be configured in FastTrack360, the following settings must be defined:
Rounding Type
This identifies if values are to be rounded or truncated to a certain number of decimal places.
For example, 7.3467 rounded to two decimal places is 7.35 while the same value truncated to two decimal values is 7.34.
Rounding Value
This identifies the number of decimal places to which values are to be rounded or truncated. This can be a value from 0 to 6 decimal places.
...
When creating an invoice or payslip formats in Maintenance > Document Designer > Document Formats there are several fields that allow for rounding. This rounding is for display purposes only.
Invoices
You are able to set rounding on your invoices to make them easier to read. The main fields where you will need to think about rounding are the following at the invoice item level:
...
It is important to remember that these fields are for display purposes only and the stored values in the system will be driven by the rounding on the billing company.
Invoice Rounding Lines
Invoice formats can be configured to display a rounding line, which can be used to show the rounding difference between the sum of tax (VAT/GST) item totals at the invoice item level and the corresponding invoice item totals. That can be used to help debtors reconcile invoice item totals to the overall invoice totals. An example of this is shown in Figure 5 below.
...
The rounding line can be enabled within an invoice document format by selecting the Invoice Items layout component by selecting the Display Rounding Line option under Rounding Settings in the component properties, as shown in Figure 6 below.
...
| Info |
|---|
A rounding line can only be displayed on an invoice if the Tax (GTS/VAT) and Total fields are included in the Invoice Items component. |
Pay Slips
You are able to set rounding on your pay slip to make them easier to read. The main fields where you will need to think about rounding are;
...
System Configuration Area | Rounding |
Pay / Bill Agreements: Pay Rate Rules Bill Rate Rules |
6 decimal places 6 decimal places
|
Billing Company: Invoice Item Sub Total (Excluding Tax) Invoice Item Tax Total Invoice Item Total (Including Tax) Invoice Sub Total (Excluding Tax) Invoice Sub Total (Including Tax) Invoice Tax Total |
6 decimal places 6 decimal places 6 decimal places 2 decimal places 2 decimal places 2 decimal places
|
Document Formats: Rates and Sub-totals | 4 decimal places |
Middle/Back Office Country Settings: Rounding |
6 decimal places (rounding here should always match what you have set on Pay and Bill Rate Rules) |