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:
- Click the “Edit Income Amount” button at the top right of the page
- Update the Net Amount and or Gross Amount as required
- 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.
Updated about 8 hours ago
