Skip to content
Sign in
  • There are no suggestions because the search field is empty.

Data Validation

This checklist 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.  

Phase 1: High-Level Dashboard Validation  

Before diving into the ledger, start with a "top-down" look at the dashboards to catch obvious discrepancies.  

  • Review Dashboard Widgets: Examine the reported NOI, Revenue, and Expenses for each period on the asset or collateral overview pages.  
  • Verify the "As-Of" Date: Ensure the data reflects the correct time period (e.g., year-to-date actuals through the latest loaded month, such as October 2025).  
  • Audit Occupancy Metrics: Historical data may appear "one-dimensional" (Occupied = Leased Percentage) because that is the level of detail provided in legacy records.  
  • Going forward, data from Rent Rolls will allow the software to track separate Leased vs. Occupied percentages.  
  • Compare Subtotals: Match high-level line items (like Net Income) against the partner-provided operating statements.  

  

Phase 2: Metric Mapping Verification  

If the dashboard numbers seem off, use this step to see which specific Pereview General Ledger accounts are rolling up into those totals.  

  • Run the Metric Mapping Report: Navigate to Formatted Reports and select Metric Mapping under the Data Validation section.  
  • Filter and Export: Select the specific metrics you want to audit (e.g., Debt Service, Expenses, Revenue) and export the list to Excel.  
  • Verify Account Groupings: Ensure every account from your Chart of Accounts is mapped to the correct metric.  
  • Example: Check that all appropriate operating accounts are included in the NOI roll-up.  

  

Phase 3: Financial Statement Deep-Dive  

Once high-level numbers are confirmed, run detailed reports to verify the data structure.  

  • Generate Income Statements & Balance Sheets: Located under the Financials section of Formatted Reports.  
  • Apply Correct Filters:  
  • Asset/Accounting Code: Select the property currently ready for validation.  
  • Hierarchy Selection: Ensure you select the correct Property Type hierarchy (e.g., Multifamily Hierarchy or Hotel Hierarchy).  
  • Account Codes: Set this to "Show" so you can see the specific line items and their associated codes.  
  • Perform Tier 2 Validation: Confirm that the ending balances in the software align exactly with the ending balances on the provided Trial Balance (TB).  

 

Phase 4: Granular PMC Account Mapping  

If you find a specific line item that looks incorrect (e.g., commercial vacancy mapped to a multifamily section), use this report to trace the source.  

  • Run the PMC Chart of Account Mapping Report: Select the report that lists the Property Management Company (PMC) account details.  
  • Reverse Engineer the Mappings: This report shows every original PMC account and the specific destination account within the software's Chart of Accounts.  
  • Audit Descriptions: Review the PMC Account Description against the Pereview Account Code to ensure the conversion logic is sound.  

 

Phase 5: Feedback and Approval  

  • Compile Observations: Note any accounts that need to be re-classified, or any mapping logic that requires adjustment.  
  • Submit Feedback: Contact Pereview with any questions or to request assistance.  

Tip: The Pereview team can create a custom "Favorite Reports" section at the top of your report list to pin these validation tools for quicker access.