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
- Download Invoices and Expenditures
- All Owners
- All Technicians
- 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, Detailed Expenditures and Download Invoices and Expenditures allow you to select a custom date range for your data export.
You can also filter each (other than Download Invoices and Expenditures) report by Property Group(s). Leave this field blank to generate a report including all Property Groups.
The new Download Invoices and Expenditures feature allows you to download a ZIP file of all approved invoices and expenditures along with line items created within the date range you choose.
Once you have clicked the DOWNLOAD button, the download will appear at the bottom of the screen and will need to be opened. Once you select Open, you will have the option to double click on the ZIP file or "Extract all" to see each individual document.
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.