Data Validation Overview
This overview provides a generalized step-by-step process for validating financial data that has been loaded to Pereview. The goal is to ensure that the data loaded to Pereview aligns with your internal expectations and partner-provided financials.
This process validates property-level financial and operational data, specifically:
- What was loaded
- Does it tie to your partner-provided statements
- Does the data map correctly to your reports and dashboards
Note: Your investment structure, including ownership records, ownership percentages, fund membership, and portfolio configuration, are established during implementation and is not re-validated during this process.
Data Receipt & Validation Timelines
While timelines may vary from company to company, we recommend establishing fixed dates for your monthly data receipt and validation processes to drive clean, consistent data in Pereview. The below represents a suggested monthly timeline.
|
Timing |
Action |
|
By the 10th |
Resolve all issues or missing data from the prior month in preparation for receipt of new data. |
|
15th to 20th |
Partner submission window. All required files arrive, are retrieved from Pereview, and are loaded. |
|
By the 25th |
Complete Tier 1, Tier 2, and (where applicable) Tier 3 validation, resolve or escalate exceptions, and internally approve the reporting month. |
Data Validation Process
Review the below articles which walkthrough each phase of the overall data validation process.
Baseline user and data requirements needed to successfully validate data in Pereview.
Confirm receipt of expected data files to resolve any missing data or gaps prior to beginning validation.
Validate data loaded to Pereview using three tiers of validation to ensure the data aligns with partner-provided source data.
Troubleshoot common data issues uncovered during the data validation process.
Part 5: Troubleshooting & Support Options
Support options for data validation and additional troubleshooting resources.
Note: For clients using Pereview’s Data Management Services, your data is automatically loaded and validated each month on your behalf. It is still useful, however, to understand the processes and best practices for validating data in Pereview, and to interpret what is reported back to you.