Kennards Self Storage

Report converter v1.9-rc.9

Readable vacant-unit, delinquent-customer, task checklist, incomplete tasks, walk through lock audit, lead follow-up and move-in/move-out reports from Hummingbird Excel exports.

Drag your Hummingbird Excel exports hereone or several at once (.xlsx)or

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.

Choose the .xlsx download from Hummingbird to begin: Available Spaces by Attribute, Delinquencies, All Tasks, Incomplete Tasks, Walk Through Audit, Leads Report or Move-in/Move-out Activity Report.

Delinquencies: export at least 12 months

When you export Delinquencies from Hummingbird, set Report Time Period to Custom Range, starting at least 12 months ago and ending today.

Hummingbird only lists customers whose arrears started within the period you choose. The default, This Month, leaves out anyone who fell behind before the 1st, even if they still owe money. These are often overlocked customers, or customers who pay every 6 or 12 months and still have a small balance.

In a test at one centre, a Last 30 Days export missed 15 overlocked customers owing $15,258, 41% of the centre's arrears.

The converter checks this for you: if an export covers less than 12 months, or the file name does not show the period, its card turns red and tells you to export again.

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:

  1. Download “Available Spaces by Attribute” as Excel, retaining the Summary tab.
  2. Choose that file above. Check the centre, report date, unit count and preview.
  3. Leave every space type selected for the complete report, or select just the types you need for a walkthrough.
  4. 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.