TRCS - Enhanced Intercompany Report

From release 25.05, in TRCS, Intercompany Report is now enhanced to include two new options of suppressing blank columns and suppressing matched transactions. With this new capability, user can:

• Suppress columns that are entirely blank (that is, have no data across all rows)

This report demonstrates the functionality when the Suppress Blank Columns option is selected. This feature hides any columns that contain no data across all rows, simplifying the report and making it easier to focus on relevant data.

• Suppress rows with matched transactions within a specified tolerance

this option can be used to suppress matches with:

• Tolerance Value: This report illustrates the use of the Suppress Matches option with a specified Tolerance Value. Transactions where the variance between intercompany transactions is less than or equal to the specified tolerance value are suppressed.
• Tolerance Percent: This report shows the effect of applying the Suppress Matches option along with a specified Tolerance Percent. Here, transactions where the variance between intercompany transactions falls within the tolerance percentage value are suppressed, reducing the visibility of minor variances.

NOTE:

• Either or both tolerance criteria can be applied when generating reports. 
• While applying both the Tolerance Value and Tolerance Percent, the system effectively chooses the stricter criterion (that is, the lower of the two thresholds) to determine whether to suppress a row. This ensures that only variances that fall within the most restrictive tolerance setting are hidden from the report, providing a more precise control over what data is displayed.
• The variance amount can be a positive or negative value. The system uses the absolute value of the variance amount to determine whether it meets the suppression criteria.

Example:

Without any suppressed options selected -

1. Suppress columns that are entirely blank (that is, have no data across all rows)

• Suppress Blank Columns: Enabled
• Example Output:
• Columns without any data are omitted from the report
• Note columns that were having no data are removed A2 asset Entity, A2 asset Partner

    

2. Suppress rows with matched transactions within a specified tolerance

Suppress Tolerance Value:

This report illustrates the use of the Suppress Matches option with a specified Tolerance Value. Cells where the variance between intercompany transactions is less than or equal to the specified tolerance value are suppressed.

Example:

• Suppress Matches: Enabled
• Tolerance Value: 500.0
• Tolerance Percent: 0.0
• Example Output: Transactions with variances of 500 or less are suppressed

3. Suppress Tolerance Percent:

• This report shows the effect of applying the Suppress Matches option along with a specified Tolerance Percent. Here, cells where the variance between intercompany transactions falls within the tolerance percentage value are suppressed, reducing the visibility of minor variances.

  Example:

• Suppress Matches: Enabled
• Tolerance Value: 0.0
• Tolerance Percent: 5.0
• Example Output:
• Calculates the Tolerance Percent Value by applying the specified percentage to the transaction amounts
• Tolerance threshold = 5% of the lower of the two amounts (entity or partner transaction), if absolute variance is less than or equals to tolerance threshold, that transaction will be suppressed
• Example: first transaction is suppressed transaction between LA => ICP_NY, where 5% of Min (80000,79500) >= 500 (variance value)
• If the absolute variance is less than or equal to the threshold value calculated, the transaction is suppressed.

Applies to

• Tax Reporting

Business Benefit: 

The Intercompany Report currently includes all transactions, regardless of whether they are matched or unmatched, and displays all columns, even if they contain no data. The new options allow to suppress empty columns and only view significant differences, reducing time spent.

Created by Mohit Jain and Megha Gupta