Open this tool in Edge or Chrome. Files are processed on this computer; nothing is uploaded. Drag exports from File Explorer or the browser's downloads onto the box above (or anywhere on this page), or click Choose files and pick one or several (hold Ctrl and click each file): each report gets its own card below. Choosing or dropping more files adds them to the list. The supplied export is .xlsx. For an older .xls file, use Excel → Save As → Excel Workbook (.xlsx) first.
Keep “Sell rate” unless you have confirmed the billing period. Changing the heading does not calculate or change any prices.
Core columns: unit, customer, paid through, days late, total past due and phone. Optional details appear beneath each entry at your selected font size. All source entries are included, including any inactive or resolved records in a historical export.
Paid through and Days Late are copied from the export. Delinquency Days Late is a separate field. Amounts are Total Past Due, with no inferred rent or late-fee split. Report date is initially taken from the end date in the filename; check it before printing.
Tasks are grouped by type (Delinquency, Operations, Lead, Maintenance) and sub type, with a tick box, initials column and a “Checked by” line for each type. Redundant columns (rental ID, property, association, created/updated by, created at and the “autogenerated from a trigger” note) are left out. The task title is shown only when it differs from the sub type. Due dates, overdue days and statuses are copied from the export, and the task count and overdue total are checked against the export footer.
Columns: tick box, Space, Status (Space Status Live), Tenant and Tenant status. Rows that need action (To Overlock, an overlock to remove, or Overlocked with the tenant now Current) are shaded and marked ». Bold is set by the ticks above: overlocked and action rows by default, and any other status you choose (for example Available or Reserved). Your choices here are remembered on this computer. Walk order is used for sorting only and is not printed. Statuses are copied from the export, and the unit count and walk order total are checked against the export footer.
Every outstanding task in the export is listed, grouped by category (task type) and then by due date, oldest first. All categories are ticked each time you load a file; untick any you don't need. Columns: Done, Initials, Unit, Customer, Task, Notes and, in landscape, Assigned to. The task count and overdue days are checked against the export footer.
Move-ins and move-outs are listed in two sections, by date, with Date, Space #, Tenant, Size and Category (the other export columns are left out). “Today” is the report date above, so check it. Care calls lists only the move-ins from 20 days before the report date, with a Called tick box and a Notes column; the export's date range must reach back that far. Date range lists the move-ins and move-outs between the From and To dates (both included; changing a date ticks Date range). Ticked lists print one after another in this order: Today, Care calls, Date range, All dates. For Date range and All dates you can list move-ins, move-outs or both; Today and Care calls are not affected. The counts are checked against the export's Total rows.
Leads are grouped as Reservations (Cart Abandonment, New Reservation, New Web Reservation) and Sales Enquiries (Inquiry, Waitlist, and any lead with no lead type). Columns: Name, Move in date, Phone, Space size, Lead type, O/D, AM, PM and Notes. O/D (overdue) is marked when the expected move-in is before the report date: check the report date above. AM and PM are tick boxes. Landscape is recommended. In portrait, phone, size and lead type print under the name. The lead count and Sell Rate total are checked against the export footer.
Your choices (text size, orientation and the options for each report type) are remembered on this computer and used next time. “Reset saved choices” goes back to the standard settings.
Download the PDF, or open it to print on A4 at actual size (100%). The PDF already includes page breaks and page numbers. If the preview is blank, download the PDF and open it in your normal PDF reader.
How these reports work
Move-ins and move-outs (Move-in/Move-out Activity Report): in Hummingbird, export the Move-in/Move-out Activity Report for your centre as Excel and choose the file here. Move-ins and move-outs print in two sections with the date, unit, tenant, size and category. Choose Today only for the report date, or Care calls for customers who moved in 20 days before the report date, with a Called tick box and notes. For care calls, export a date range that starts at least 20 days ago.
Incomplete tasks (Incomplete Tasks): in Hummingbird, export Incomplete Tasks for your centre as Excel and choose the file here. Every task still outstanding, from any day, is listed by category (Delinquency, Operations, Lead, Maintenance) and then by due date, oldest first, with a tick box and initials column. All categories are ticked each time; untick any you don't need, or tick “Start each category on a new page” to hand each category to a different person.
Lead follow-ups (Leads Report): in Hummingbird, export the Leads Report for your centre as Excel and choose the file here. The sheet lists every active lead under Reservations (Cart Abandonment, New Reservation, New Web Reservation) and Sales Enquiries (Inquiry, Waitlist, and any lead with no lead type). Check the report date: leads whose expected move-in is before it are marked O/D (overdue). Tick AM or PM as you follow each lead up. Tick “Start Sales Enquiries on a new page” to hand the two lists to different people.
Walk through lock audit (Walk Through Audit): in Hummingbird, export the Walk Through Audit for your centre as Excel and choose the file here. Walk the centre with the printout and check every lock against the expected lock: Rented units have a customer lock; Overlocked units have a customer lock plus an overlock; every other status (Available, Reserved, Pending, Maintenance, Company, Future Rented) has a company lock. Shaded rows marked » need action: add an overlock (To Overlock) or remove one (a remove-overlock status, or Overlocked where the tenant is now Current, marked “remove overlock?”). Sort by walk order (units with no walk order set come first, as in Hummingbird) or by unit number, and choose tick boxes for every unit or every unit except Rented. Two columns per page uses the least paper.
Task checklist (All Tasks): in Hummingbird, open All Tasks for your centre, set the date range to the last 7 days so every task type and overdue task is included, and export as Excel. Choose the file here: one checklist replaces the Care Calls and Overlock/Remove Lock prints in the Hummingbird Morning Procedure (leads and reservations are on the Leads Report). Care calls are the only Lead tasks listed; Clean & Prepare Space tasks with no unit are left out; overlocks and cut locks under Delinquency (outstanding only, matching the procedure’s Pending filter). Operations and Maintenance tasks are included too. Tasks are grouped by type and sub type, with a tick box and initials column for each outstanding task and a “Checked by” line per type. Untick types you don’t need, or keep “Start each task type on a new page” on to hand each type to a different person. Choose “All tasks” to also list completed and dismissed tasks (shaded, with who completed them).
Delinquent customers: in Hummingbird, open Delinquencies, set Report Time Period to Custom Range starting at least 12 months ago and ending today, export as Excel and select the file. A shorter period (such as the default This Month) only lists customers whose arrears began in that period, so longer-term arrears would be missing; the converter warns about this. The report type is detected automatically. All customer entries are kept separately, sorted by Days Late by default. Default columns are Unit, Customer, Paid through, Days late, Past due and Phone. Choose extra details if needed. Reports use A4 portrait by default (or landscape) with repeated column headings and an overall total; no customer values are truncated or shrunk to fit.
Export totals and the Hummingbird count footer are checked when present. Missing phone numbers are shown as a dash. Separate rent owing and late-fee balances are not provided by this export. A historical date range may contain inactive entries; these are retained. Select the status detail to see them.
Vacant units:
- Download “Available Spaces by Attribute” as Excel, retaining the Summary tab.
- Choose that file above. Check the centre, report date, unit count and preview.
- Leave every space type selected for the complete report, or select just the types you need for a walkthrough.
- Download the PDF to save a separate report, or open the PDF to print. The PDF can be reopened later without the original spreadsheet.
One block per source group, with square-metre area first in bold and dimensions secondary. Ordered by space type, then area and rate. Unit numbers keep their original spelling and are sorted naturally. Every selected unit is printed; long lists continue into additional blocks. Different prices, sizes or attributes are never merged.
Access, hours, alarm status, floor and specialist descriptions are retained. “GF” = Ground Floor, “Lift” = Lift Access, “Ext hrs” = Extended Hours, “24h” = 24 Hours. Floor is copied exactly as exported. Area is copied from Excel, avoiding the PDF’s rounded areas.
Promotion references describe the Summary tab only. The source Detail tab may show different promotion wording or individual offers. No discount is calculated. Confirm the applicable offer in the storage system before quoting it.
The report uses only the exported availability. Occupancy percentages, total capacity, set rates and days vacant are omitted from the printed list. The converter checks available counts and duplicate unit IDs, and cross-checks units, prices, dimensions and attributes against Detail when that tab is present. Incompatible exports produce an error rather than a partial report.
Version 1.9-rc.9 · Offline .xlsx converter · No installation, macros or internet connection required.