Before validating data in Pereview for a given period, you must first confirm that the data was successfully loaded. Data can be loaded to Pereview through a variety of automated and manual means; however, it is imperative to confirm that the data files you expect to receive each month were received and successfully loaded.
Verifying Data Receipt and Locating Load Errors
To quickly assess what financial data has been received and successfully loaded to Pereview, navigate to Formatted Reports and run the Financial Upload Status report. This report shows a month-by-month breakdown of data successfully loaded to Pereview. Upload status is displayed for GL (Actuals or Budget), Rent Roll, and Financial Model data.
The report is broken down by asset and month, with each green box representing data that has been successfully loaded for that period.
Note: If you notice a gap in the data, it is possible that the data was received in Pereview but there was an error during the load process. Using the top navigation bar, navigate to Admin > Data Upload. On this screen, you can search for the file or data in question and confirm whether there was an error, as seen below.
Work from a list of the properties and files each partner owes you and check them off. A property that quietly drops out of a monthly submission is easy to miss when you are looking at statements rather than at the file inventory. If a partner feed goes quiet, confirm the feed schedule has not expired before assuming a system problem.
A Successful Load Does Not Always Mean a Complete Load
A load can complete without an error and still be missing data. Any account code in the source file that is not mapped in your PMC Chart of Accounts has no destination in Pereview, so those rows do not load. The amounts are absent rather than misplaced, and the shortfall usually surfaces later as a Balance Sheet that does not balance or a subtotal that does not tie.
This is most common the first time a partner starts using a new account. Before loading a new period, compare the account codes in the source file against your current mapping and map anything new. The PMC Chart of Account report gives you the current list. For more information around loading to data: Data Upload
If you find that a file loaded twice, loaded for the incorrect period, or loaded from the incorrect statement, the incorrect data stays in Pereview until it is deleted. See Deleting Data Loads.
Recommended Best Practices: Confirming Data Receipt
☐ Every expected file for the period has been received.
☐ The Financial Upload Status report shows the expected data types and months as loaded.
☐ Any gap has been investigated in Admin > Data Upload for a load error.
☐ Automated feeds have been confirmed as still active and not expired.
☐ Account codes in the source files have been checked against the PMC Chart of Accounts.