Report Validation Rules

These rules are defined within the Report Templates and are applied during the generation and validation of financial reports. They ensure the accuracy, consistency, and completeness of the report data before it can be published.

Unlike transaction validation rules which check individual accounting entries, report validation rules verify the aggregated data and the structural integrity of the report.

Rule Types

Check Sum Validation

• Description: Verifies that the sum of a specific set of fields equals the value of another field. This is crucial for verifying accounting equations (e.g., Total Assets = Total Liabilities + Equity).
• Configuration: Defined in the template by specifying a target field and a list of source fields to sum.
• Impact: If the sums do not match, the report is marked as Pending and the discrepancy is highlighted.

Value Presence Validation

• Description: Ensures that critical fields are not empty or zero (unless allowed).
• Impact: If a mandatory field is missing data, the report cannot proceed to the Ready to Publish status.

Custom Logic

• Description: Templates can support custom validation logic for specific organizational requirements.

Validation Process

1. Generation: When a report is generated (system or user), initial values are populated.
2. Validation: The system runs the validation rules defined in the template against the populated data.
3. Status Update:
   • Passed: Status becomes Ready to Publish.
   • Failed: Status becomes Pending. Errors are listed for the user to resolve.

Example

1. Assets Check: Total Assets field must equal the sum of Current Assets + Fixed Assets.
2. Balance Sheet Check: Total Assets must equal Total Liabilities + Equity.