Docs
The Data Validation step is the first and most critical part of the monthly or quarterly close in RevRec Premium. It ensures that all billing and accounting inputs such as invoices, credit notes, and payments are processed, mapped, and balanced before journal entries are generated.
RevRec Premium provides a dedicated Data Validation user interface(UI) where you can review errors, warnings, and discrepancies flagged by the system. Any unresolved issues here may prevent journal generation or cause imbalances in journal entries.
Follow the steps below to access the Data Validation report in your RevRec Premium site:
RevRec Premium performs several automated validation checks. Below are the key error codes and their resolutions:
Error Code: Input_Control_Difference
Description: This control evaluates events (invoices, credit notes, and payments) along with their associated balances in the source system against the processed data in the RevRec Premium for those events. Any discrepancies found between the two are flagged in the report with the error code.
Resolution: This error cannot be resolved by you. Contact Chargebee Support for assistance.
Error Code: Missing_Exch_Rate
Description: This control evaluates events such as invoices, credit notes, and payments along with their associated balances in the source system, against the corresponding processed data in RevRec Premium. This ensures required exchange rates are available for invoices, credit notes, and payments. Missing values are flagged.
Resolution: Errors are cleared automatically once the exchange rate is updated and journals are regenerated. No user action is needed. If the issue persists for more than two days, contact Chargebee Support.
Error Code: Unmapped_Transaction
Description: This control evaluates transactions that are synced into the system but are not recognized for journal entry creation because there’s no valid mapping for their event type. The system never generates the transaction-level journal entries for these events.
Resolution: This error cannot be resolved by you and requires investigation by the product team. Contact Chargebee Support.
Error Code: Unbalanced_Transactions
Description: This control evaluates whether the sum of the amounts with type “Debit” is equal to the sum of the amounts with type “Credit” for the journal entries.
Resolution: This error cannot be resolved by you and requires investigation by the product team. Contact Chargebee Support.
Error Code: Overlapping_JournalAccountMappings
Description: This control evaluates the journal account mappings and identifies overlapping journal account mappings across periods.
Resolution: To resolve this,
Error Code: Missing_Journal_Account_Mappings
Description: This control evaluates that each transaction-level journal entry has one journal account mapping available for it. If the journal account mapping is not available, then it is considered missing and will be flagged in the report with this error code.
Resolution: To resolve this,
Error Code: Mismatched_Journal_Postings
Description: This control evaluates event-level journal entries along with their associated balance, reconciles with the aggregated journal entries created by the system for posting to the accounting system. If discrepancies are found between the two, they are reported in the report with this error code.
Resolution: This error cannot be resolved by you and requires investigation by the product team. Contact Chargebee Support.
Errors and warnings displayed on the grid have the potential to impact the journal entries generated by the system.
Each error row displays the number of impacted records.
Click the row to view the individual transactions and details of the error. The error details page allows you to identify the individual record in error and the reason for the error.
Apply the recommended resolution to fix the error.
Errors can arise from configuration issues, missing fields in source data, or system limitations or bugs. Errors related to the configuration and input data can be resolved in a reasonable time, but resolving the errors caused by the system limitation can take considerable time. In such cases, it is recommended to book a manual adjustment in your accounting system for the difference and clear the errors or warnings from RevRec Premium to close the accounting period.
You can clear errors and warnings in two ways:
After clicking the Delete icon, you will be asked to provide the reason for clearing the error. You cannot clear an error without specifying the reason.
Note:
RevRec Premium provides full auditability and change traceability through the Audit Log. The log captures:
All changes are compiled into the Audit Trail Report, which supports internal reviews and external audits.
To access the report, navigate to Reports > Security & Audit > Audit Trail.
Was this article helpful?