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

Data Validation Part 1: Before you Begin

To successfully validate data in Pereview, users will need a base level of system access as detailed below. Additionally, it is useful during validation to reference the original source files that have been loaded to Pereview.

If you lack the required user permissions to access any of the pages listed below, please contact your system administrator or Pereview support.

Data Validation Access Checklist

Pereview Pages Used During Validation

  • Asset and Collateral Overview pages, primarily used for dashboard-level review.
  • Data Upload page (Admin > Data Upload), used to confirm load results and locate load errors. All source files loaded to Pereview are stored here and available for reference.
  • Site Administration (Admin > Site), used to correct mappings or delete data directly. See the note on permission groups below.

        Formatted Reports

        The reports below are referenced throughout this guide. These may be accessed by going to Reports > Formatted in the global navigation bar. For additional information on Formatted Reports: Formatted Reports Overview

        Report

        Purpose

        Financial Upload Status

        A grid by asset and month showing which data types have been successfully loaded. The starting point each month.

        GL Transaction Detail

        Each individual journal entry, including which data load it came from. Use it to see what data is currently in the system. Narrow the parameters to a property; large data ranges may result in extended load times.

        Balance Sheet

        Assets, liabilities, and equity for the selected period. Structured by your Account Hierarchy for Balance Sheet. The primary Tier 1 report.

        Balance Sheet Over Period

        The same figures across consecutive months, side by side. Useful for finding the month a balance changed unexpectedly.

        GL Balances for Latest Post Date

        Ending balances by GL account as of the latest post date, with the Source Ending Balance and Difference columns where available. Primarily used during Tier 2 validation.

        Trial Balance

        Pereview’s own trial balance for a property and period, used for comparison against the partner-provided file.

        Income Statement

        Revenue, expenses, NOI, and net income for a given period. Structured by your Account Hierarchy for Income Statement.

        Income Statement Over Period

        The same as above but across a date range. Use this for any multi-month comparison, and to validate the Account Hierarchy. Primarily used during Tier 3 validation.

        GL Metric Over Period

        How a metric such as NOI or Net Income is built month by month. Turn on account detail to see each contributing account. Use this to validate the Metric Mapping. Primarily used in Tier 3 validation.

        Metric Mapping

        Which GL accounts roll into which metric. The second tab shows the groupings visually.

        PMC Chart of Account Mapping

        Every partner account code and the Pereview account it maps to.

        Occupancy History Validation

        Units, square footage, leased percentage, and occupancy percentage loaded for an asset over time.

        Rent Roll Details Report

        Unit-level rent roll detail for an asset as of a given effective date.

        Budget to Actuals Report

        Budgeted against actual figures by account, used to confirm the correct budget loaded.

        Relevant Pereview Access Levels

        Access in Pereview is granted through permission groups rather than to individuals directly. Three default permission groups are relevant to validation:

        Permission Group

        Site Administration Access

        Typical Use

        SuperAdmins

        Yes

        Reserved for Pereview employees only.

        Admin

        Yes

        Admin access is recommended for the data validation process. Typically assigned to the working team closest to the data during implementation. Required for Data Upload and Site Administration access, which includes the pages used to upload data, correct mappings, and delete data.

        Read Only

        No

        Users who consume reports and dashboards but do not configure or correct data.

         Note: While the above chart details the some of the out the box access levels in Pereview, keep in mind that your company may have further customized or configured your teams access levels. Ultimately, an individual's access levels will determine what components of the overall data validation workflow they are able to complete. Contact your system admin or Pereview support if you have questions.