Raw data can be exported from your Property Meld account, formatted as CSV (comma-separated value) files. These basic CSV files are suitable for any spreadsheet program.
NOTE: Only Admin and Agent users can access Reports.
The following types of Reports are available.
- All Melds
- Work logs
- Detailed Expenditures
- All Owners
- All Tenants
- All Units
To access and save these Reports:
From Account Settings (gear icon, upper-right), click Reports.
Select the type of report you want to save. If presented, enter or select additional criteria and click GENERATE REPORT.
The following banner will be displayed at the top of the screen.
All Melds, Work Logs, Invoices, Expenditures, and Detailed Expenditures allow you to select a custom date range for your data export.
You can also filter each report by Property Group(s). Leave this field blank to generate a report including all Property Groups.
All Owners, All Tenants, and All Units will reflect the current totals available at the time of export.
Once generated, check the email inbox associated with your user account for the report.
Open the email and click Download File.
The body of the email will be similar to the following image.
Optionally, change the name of the file, and click Save.
Take the time to double-check your browser's download-saving location, and change it if needed. This can greatly assist in finding the file post-download.
Once the download is finished, open the CSV file with a spreadsheet application.
You can then filter, edit, and sort your data. Below are examples of the All Units Report and All Melds Report.
Example: All Units Report
Example: All Melds Report
HINT: Because each "Meld creation date" and "Meld completion date" is a timestamp, you may elect to format these cells to easily filter and sort the data. See the section below for instructions.
Using "Text to Columns" to Format Date Column
In Microsoft Excel, you can do this by using the "Text to Columns" Delimited function, specifying "T" in the "Other" delimiter option. The effect of this operation is splitting any timestamp column by the "T" and creating two new columns where the date is not formatted as a Date field. Refer to this link Text to Column in Excel for a tutorial on how to use this functionality.
You will need to insert 1 column to the right of any date column to avoid overwriting data in neighboring columns.
Then follow the basic steps depicted in the following screenshots.