Handling Amount Errors

Purpose of the Amount Error Step

The Handling Amount Errors step is triggered when the system detects an inconsistency between the financial totals calculated from the statement file and the amounts entered in the Royalty Statement Income metadata.

This step ensures financial consistency before royalty calculations are finalized.

The system assumes that all imported amounts are expressed in the currency declared at the Income level. Reprtoir does not perform currency detection or conversion at the statement line level.

If no amount inconsistencies are detected, this step is skipped automatically.


What Triggers an Amount Error

An Amount Error occurs when at least one of the following conditions is met:

  • The sum of imported Net amounts does not match the Net Amount entered in the Income metadata
  • The sum of imported Gross amounts does not match the Gross Amount entered in the Income metadata

Amount Errors relate exclusively to totals and balances. They do not concern missing assets, identifiers, or descriptive data.


How the System Detects Amount Errors

After mapping is confirmed, Reprtoir calculates:

  • The total Net amount derived from the mapped statement lines
  • The total Gross amount derived from the mapped statement lines, when applicable

These calculated totals are then compared against the amounts entered in the Royalty Statement Income Details.

Any discrepancy triggers the Amount Error step.

Reviewing Amount Errors

When an Amount Error is detected, the system displays:

  • The declared Net and Gross amounts from the Income metadata
  • The calculated totals from the imported statement lines
  • The difference between declared and calculated amounts

This allows you to quickly determine whether the issue originates from the metadata entry or from the statement file itself.


Resolving an Amount Error

Case 1: Metadata Entry Error

If the discrepancy is caused by an incorrect amount entered during Income creation:

  1. Click the “Edit Income Amount” button at the top right of the page
  2. Update the Net Amount and or Gross Amount as required
  3. Save the changes

Once corrected, the system recalculates totals and proceeds automatically if consistency is restored.

Case 2: Statement File Issue

If the discrepancy originates from the statement file:

  • Verify that the correct amount columns were mapped during the Mapping Data step
  • Confirm that no filtering or aggregation issues exist in the source file
  • Ensure the file has not been modified, truncated, or partially exported

If the file itself is incorrect, you must contact the Statement Provider and request a corrected statement.

Reprtoir does not allow manual alteration of imported statement line amounts at this stage.


What Cannot Be Done at This Step

During the Handling Amount Errors step, you cannot:

  • Edit individual statement line amounts
  • Adjust totals to force a match
  • Ignore an amount discrepancy

Financial consistency is mandatory to proceed.


Proceeding to the Next Step

Once all Amount Errors are resolved:

  • The system validates the corrected totals
  • The workflow proceeds automatically to the Handling Data Errors step

If inconsistencies persist, progression is blocked until they are resolved.


Relationship with Other Steps

Handling Amount Errors occurs after Mapping Data and before Handling Data Errors.

It ensures that the financial integrity of the statement is correct before addressing data quality, matching, and standardization issues.