Rental reports and the books
What it's for
Downloading your rental figures to Excel, and (with Accounting) posting rent, deposits and receipts to your books automatically.
Before you start
Reports need View rentals. Posting needs the Accounting module and Leasing settings permission to switch it on.
Download a report
- Go to Rentals & leasing → Rental reports.
- On the report's card choose the Property (or All properties) and, for dated reports, From and To (default: this month so far).
- Press Download CSV. It opens in Excel or Google Sheets.
| Report | What it lists |
| Rent roll | Every live lease: units, tenant, rent and charges, deposit held, unpaid and advance. |
| Occupancy | Units per property by status, with the occupancy rate. |
| Units | Every unit with its status, tenant and rent. |
| Rent invoices (dated) | Invoices in the period with tax, paid and unpaid. |
| Rent receipts (dated) | Payments received in the period by mode, with tax withheld. |
| Arrears ageing | Unpaid amounts per lease by days overdue. |
| Deposits | Deposit agreed, received, deducted, refunded and held per lease. |
| Leases ending | Leases ending in the next 180 days, and ended ones not closed. |
| Maintenance requests (dated) | Requests in the period with status, cost and time to close. |
Post to the books
- Leasing settings → Books: switch on Post rent to the books and press Save settings. The section shows only with Accounting.
- From then on every invoice, receipt and deposit entry posts a journal as it is made. Press Post earlier records to post what was recorded before.
| Document | Journal |
| Rent or charge invoice | Dr Customer receivable (tenant); Cr Rent income (4300); Cr Tax output. |
| Late fee | Dr Customer receivable; Cr Late fees on rent (4320). |
| Deposit invoice | Dr Customer receivable; Cr Deposits held. |
| Rent receipt | Dr the account it went into (the account chosen in Into, otherwise Bank; Gateway clearing for online; Deposits held when from the deposit) and Tax withheld receivable; Cr Customer receivable. |
| Deposit deducted | Dr Deposits held; Cr Deposit deductions (4310). |
| Deposit refunded | Dr Deposits held; Cr the account paid from. |
| Credit refunded | Dr Customer receivable; Cr Bank. |
The income accounts are created the first time they are needed. Cancelling an invoice, receipt or deposit entry reverses its journal.
Tips and common questions
- Only documents in your books currency post ("Only … leases post."); leases in another currency stay out of the books.
- A posting that fails (for example in a locked period) never blocks the rental work. It is noted in the activity log; Post earlier records tries again and reports how many could not be posted.
Related: Leasing settings · Payments and rent receipts