Skip to main content

FS² Credit: Percentage Values in Accounts Receivable Exceeding 100%

In certain scenarios, percentage values for Accounts Receivable (AR) categories exceed 100% due to differing calculation bases within the system. This is expected system behavior.

S
Written by Strutzke, Marcel

Product Area

FS² CCC


Problem

You may notice that the combined percentage values of the following categories exceed 100%:

  • Due receivables

  • Overdue receivables

  • Not due receivables

Additionally, the sum of these categories may be higher than the displayed total Accounts Receivable (AR).

Calculation Background

This behavior is caused by different data bases used in the calculations:

  • Category values (due / overdue / not due):

    • Calculated using debit items only

  • Total Accounts Receivable (AR):

    • Calculated using debit and credit items

    • Credit items (e.g., credit memos) are deducted from the total

As a result:

  • The total AR represents a net value

  • The category values represent a gross value

  • Percentage values are calculated against a reduced total base

This can cause the overall percentage to exceed 100%.


Solution

This behavior does not require correction. However, you can interpret and use the data as follows:

  1. Understand the different calculation bases

    • Category values reflect open debit items only

    • Total AR reflects the net balance after credit items are deducted

  2. Interpret percentage values correctly

    • Percentages are based on the net AR total

    • A total above 100% indicates the presence of credit items reducing the total

  3. Use absolute values for detailed analysis

    • For precise financial evaluation, rely on the displayed amounts rather than percentages

    • Compare category values directly with each other

  4. Align reporting expectations if required

    • If you need consistent percentage calculations (e.g., always below 100%), this requires:

      • A unified calculation logic across all metrics

      • A product enhancement or customization


Known Limitations

  • The system does not provide a standard option to align the calculation logic

  • Mixed gross and net calculations are part of the current product design

  • Changes require a separate enhancement request

Did this answer your question?