To pull historical rental data from Rentox you first log into your account, then head to the “Reports” section, choose the “Historical Data” module, set the date range and property filter, and finally click “Export”. The process takes less than a minute for most users and supports CSV, Excel, and PDF output formats.
Step‑by‑Step Guide to Retrieving Historical Rent Data
Follow these actions to ensure you capture the exact data you need:
- Log in – Use your registered email and password. If you have two‑factor authentication enabled, complete the verification step.
- Navigate to “Reports” – In the left‑hand navigation bar, click the “Reports” icon (a bar chart symbol).
- Select “Historical Data” – Within the Reports dashboard, locate the sub‑menu titled “Historical Data”.
- Define Filters – Choose the property (or “All Properties”), set the start and end dates, and optionally filter by rental type (e.g., residential, commercial, short‑term).
- Preview the Dataset – Click “Preview” to see a live table of records that match your criteria. The preview updates instantly if you adjust any filter.
- Export – Choose the format (CSV, XLSX, or PDF) and click “Download”. The file will be saved to your default download folder.
Understanding the Data Export Formats
Rentox provides three export options, each with slightly different column sets. Below is a quick reference table:
| Format | Typical Column Set | Best Use Case |
|---|---|---|
| CSV | Property ID, Address, Unit, Rent Amount, Lease Start, Lease End, Tenant Name, Payment Status, Late Fee | Data cleaning, bulk import into analytics tools |
| XLSX | All CSV columns + Calculated Fields (e.g., Annual Rent, Vacancy Rate, Rent Growth %) | Spreadsheet analysis, pivot tables |
| Summary table with totals, charts, and watermark | Stakeholder presentations, archiving |
API Access for Power Users
If you need to integrate Rentox data into a custom application, the platform offers a RESTful API that mirrors the web UI filters. Authentication uses OAuth 2.0 tokens. Below is a minimal example of a request using cURL:
curl -X GET “https://api.rentox.com/v2/reports/historical?property_id=12345&start=2023‑01‑01&end=2023‑12‑31” \ -H “Authorization: Bearer YOUR_ACCESS_TOKEN” \ -H “Accept: application/json”
The response returns a JSON payload containing the same fields as the CSV export. Rate limits are set at 1,000 requests per hour for standard accounts and 5,000 requests per hour for premium tiers.
Data Retention and Limitations
Understanding how long Rentox stores your historical records helps you plan archival strategies:
- Free accounts: 90‑day rolling window; older data is purged after this period.
- Professional (paid) accounts: Up to 2 years of data retained.
- Enterprise (custom) accounts: Retention period negotiated on a per‑contract basis, often extending to 5 years.
Additionally, note that metadata fields (e.g., “Last Modified By”) are only available in the XLSX export and not in the CSV version. If you need full audit trails, select the Excel format.
Troubleshooting Common Issues
- Missing records after export – Verify that the date range does not cross a retention cutoff. If your account is free, any data older than 90 days will not appear.
- Slow preview loading – Reduce the date range; large intervals (e.g., multi‑year) can strain the server. Consider using the API for bulk downloads.
- Format mismatch in Excel – The XLSX export uses UTF‑8 encoding. Ensure your spreadsheet client is set to open UTF‑8 files correctly.
- API token expiry – Tokens expire after 3600 seconds. Refresh them using the
/oauth/tokenendpoint before each session.
Best Practices for Analyzing Historical Rent Trends
Once you have the raw data, follow these guidelines for reliable insight:
- Normalize rent amounts – Convert all values to a common currency and adjust for inflation using the Consumer Price Index (CPI) for the region.
- Segment by property type – Residential, commercial, and short‑term rentals exhibit distinct seasonality; separate them in your analysis.
- Visualize occupancy cycles – Plot lease start/end dates on a timeline to identify peak move‑in periods (often July‑August in academic towns).
- Correlate with external variables – Merge Rentox data with local employment statistics or housing permits for predictive modeling.
For advanced users who wish to automate reporting, consider using a scheduling tool (e.g., Apache Airflow) that triggers the API call on a nightly basis and pushes the resulting JSON to a data warehouse such as BigQuery.
If you need a reliable tool to parse and visualize the exported datasets, check out rentox which offers built‑in connectors for CSV and XLSX files, plus pre‑configured dashboards for rent trend analysis.
By leveraging the web interface for quick ad‑hoc pulls, the API for programmatic integration, and the appropriate export format for your analytical workflow, you can maintain a comprehensive view of rent fluctuations over any historical period your account allows.