Property Tenant Arrears Tracker
Help a commercial-property accountant run the weekly tenant arrears review. Load each dated receivables export into one register, check it every week for aging, reminders due, and promises past their date, and draft the reminders and owner-report summaries you send.
Integrations
General Input Database
Send Email
Industries
Capabilities
- A register of unpaid tenant charges from each dated receivables export: property, tenant, charge, open balance and currency, due date, last reminder, promised date, and status.
- A weekly digest, emailed to you, with aging per tenant in exact totals per currency, the tenants due a reminder, and promises past their date.
- Courtesy and firm payment reminders drafted for you to send, and arrears summaries for your owner report.
Included resources
What to bring
- A dated receivables export or aged receivables report, pasted or summarized, with each open charge's tenant, amount, currency, and due date.
- How many days past due a charge waits before a reminder, how long to wait between reminders, and the reminders and payment promises you record.
- Who receives the digest and when the weekly check runs.
Setup
- Add the specialist. Its register app and weekly check share one new database.
- Tell it who gets the digest, when the check runs, when a charge needs a reminder, and how long to wait between reminders.
- It adds one fictional trial charge, previews the digest without emailing it, marks the trial paid, and reports ready. You turn the app and the check on.
Scope
- Drafts and tracks only. It never contacts a tenant, sends a legal or default notice, adds late fees or interest, or changes your ledger.
- It keeps each currency separate and never converts or rounds. A charge is marked paid only when you confirm it.
Example
Fictional input and an illustrative result.
Input
Fictional weekly check on Sep 24, 2026 with the default settings, from a receivables export dated Sep 21. Example Plaza: Example Bakery owes USD 1,200 for INV-1041 Base rent Aug 2026, due Aug 1, and USD 1,200 for INV-1052 Base rent Sep 2026, due Sep 1, with no reminder sent. Example Florist owes USD 900 for INV-1055 Base rent Sep 2026, due Sep 1, and promised to pay by Sep 20. Example Tower: Example Law LLP owes EUR 450.10 for INV-2210 Service charge Q3 2026, due Sep 15 and reminded Sep 21, and EUR 3,000 for INV-2230 Base rent Oct 2026, due Oct 1. Example Studio owes USD 800 for INV-2240 Base rent Oct 2026, due Oct 1.
Output
Tenant arrears
Checked Sep 24, 2026 on UTC calendar days. 3 tenants have past-due balances. Balances come from the receivables export dated Sep 21, 2026.
Reminder due (1)
- Example Plaza: Example Bakery: USD 2,400.00 past due, oldest 54 days. Last reminder: none recorded.
Promises past their date (1)
- Example Plaza: Example Florist: USD 900.00 promised by Sep 20, 2026 for INV-1055 Base rent Sep 2026.
Aging by tenant
| Tenant | Currency | Current | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | Total |
|---|---|---|---|---|---|---|---|
| Example Plaza: Example Bakery | USD | 0.00 | 1,200.00 | 1,200.00 | 0.00 | 0.00 | 2,400.00 |
| Example Plaza: Example Florist | USD | 0.00 | 900.00 | 0.00 | 0.00 | 0.00 | 900.00 |
| Example Tower: Example Law LLP | EUR | 3,000.00 | 450.10 | 0.00 | 0.00 | 0.00 | 3,450.10 |
Totals by currency
| Currency | Current | 1 to 30 | 31 to 60 | 61 to 90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| EUR | 3,000.00 | 450.10 | 0.00 | 0.00 | 0.00 | 3,450.10 |
| USD | 800.00 | 2,100.00 | 1,200.00 | 0.00 | 0.00 | 4,100.00 |
Nothing was sent to tenants. No notice, late fee, or ledger change was made.