What imports
- Properties and units from your master sheet
- Residents with contact info
- Active leases with rent, deposit, and term
- Ledger balances as of a cutover date
Spreadsheet migration is the most common — and usually the messiest. Ayillo's import flow accepts a CSV of properties, units, leases, and residents in a documented shape.
Export the source data, choose the exact Ayillo workspace and property scope, map and preview every row, reconcile the cutover balances, and only then commit. Ayillo's Migration Center is designed to surface problems before they become live records; it does not need to modify Spreadsheets.
Keep an untouched export from Spreadsheets. In Ayillo, select the destination workspace and property scope explicitly, load the files, review the mapped rows and resolve any missing or ambiguous fields. Reconcile residents, leases and balances against one cutover date before committing. After the import, compare record counts and spot-check the highest-risk records before your team treats Ayillo as the system of record.
Check property and unit counts, resident identity and contact details, lease status and dates, outstanding balances, open maintenance work, and staff access. Imported data should match the source export and the chosen cutover date. If a tracked import has later operational activity, Ayillo's rollback path fails closed rather than deleting records that may now be connected to real work.
You can run the Migration Center yourself and keep full control of the mapping and preview. If you want help, Ayillo can provide concierge guidance for the Spreadsheets export, field mapping and cutover review. The assistance is optional; the self-service path remains available.
Sheet formulas don't migrate. Rebuild reports in Ayillo's reporting layer.
There is no fixed migration time because row volume and source-data quality vary. The important gate is reconciliation: preview the import, resolve exceptions, and do not commit until the destination records and cutover balances are correct.
Yes. Exporting and previewing data in Ayillo does not require shutting down the old system. Pick a clear cutover point so the same charges, payments, leases, or maintenance activity are not entered independently in both systems after that point.
Tracked imports have a guarded rollback path. Ayillo refuses destructive rollback when imported records have later activity or when the import predates the required rollback audit metadata, so connected operational history is not silently deleted.
Step-by-step guide to migrating property, lease, and resident data from AppFolio to Ayillo with clean cutover.
Step-by-step guide to migrating property, lease, and resident data from Buildium to Ayillo with clean cutover.
Step-by-step guide to migrating property, lease, and resident data from DoorLoop to Ayillo with clean cutover.
Step-by-step guide to migrating property, lease, and resident data from TurboTenant to Ayillo with clean cutover.
Step-by-step guide to migrating property, lease, and resident data from Any source to Ayillo with clean cutover.
Give every resident a portal for rent, maintenance, documents, and lease renewals — no separate app needed.
$49/month includes 5 units, then per-unit pricing that drops as you grow. Optional modules are billed separately and must be added deliberately.
Start the importDrop an export and we'll show exactly what Ayillo would import — properties, units, residents, leases, balances, and work orders. No account, no upload: your file is parsed on this device and never sent to our servers.
How to export: Any CSV. Save your sheet as comma-separated values.