Guides / Setup
Exporting a resident list from your HOA software
Your management software already holds the list of who lives where. Pool Check-in needs a copy of it, and the copy is a spreadsheet. The work is a report, an export and a preview, and most of it is the same whichever software you use.
What the pool needs from the list
The pool does not need your whole homeowner file. It needs enough to answer one question at the gate: does this person live here. That takes two things on every row, an address and a name. Everything else is optional, and a smaller file is easier to check.
Export only what you need. A homeowner export often carries mailing addresses, phone numbers, email addresses and account notes. None of that is needed at a pool gate, and a file with less personal information is a safer file to move around. Take it out of the spreadsheet before you upload, or choose fewer columns when you build the report.
Which columns matter
The importer looks for these and finds them on its own in most files, whatever the exact heading:
- Address, which can also be headed Unit, Street, Property or Home. It can be any text: a street address, a unit number, a room number or a member number. Everyone with the same address becomes one household.
- First and last name, either as two columns or as a single Name, Resident, Tenant or Owner column. A single column can read Last, First or First Last. Every row needs a name.
- City, state and zip are optional and are shown with the address when you have them.
- Type, such as Owner or Renter, is optional and is saved with each person.
- A dues or balance column is optional. If the file has one, the preview shows which households it would mark as behind on dues before anything is saved.
The file itself
Pool Check-in reads Excel (.xlsx or .xls) and CSV files up to 4 MB and 20,000 rows, and a Google Sheet shared by link. It looks through the first 15 rows of each sheet for the header and imports the sheet that fits best, so a title or a blank row above your columns is fine. You rarely need to rename a heading.
One row per person works best. If your software puts two owners of one home in a single row, the preview shows how many residents and households it found, so you can see at once whether the count looks right.
Exporting from Vantaca
In Vantaca, run the homeowner or owner list report and add the columns you want, such as the owner name and the property address. Export it as Excel or CSV if the report offers either. Upload the file as it comes out, without editing the layout first.
Ask us about a direct Vantaca connection. Today, the file upload works. We have not yet tried a real Vantaca export. If yours does not read cleanly, send it to us and we will check it. Our Vantaca page keeps the current state and the steps.
Exporting from AppFolio
In AppFolio, run the report that lists tenants or owners with their property addresses, and export it as Excel or CSV. Make sure each row is one person with a name and a property address, because some report layouts group several people under one heading.
Ask us about a direct AppFolio connection. Today, the file upload works. We have not yet tried a real AppFolio export. If it does not read cleanly, send it to us and we will check it. The AppFolio page on this site has the current steps.
Exporting from Buildium
In Buildium, export your association owner data as Excel or CSV from the owner list or an owner report. Check that the file has a name column or first and last name columns and an address column.
Ask us about a direct Buildium connection. Today, the file upload works. We have not yet tried a real Buildium export. If yours does not read cleanly, send it to us and we will check it. The Buildium page has the current steps.
Exporting from other software
Most property and association software can export an owner or resident list as Excel or CSV. Look for a report named owner list, homeowner directory, tenant directory or resident roster and for an export option on the report. If the software cannot export at all, copy the list into a spreadsheet by hand or type people into Pool Check-in directly.
A list kept in a Google Sheet works too. Share the sheet so that anyone with the link can view it, paste the link into Pool Check-in and press Sync now. A sync runs only when you press that button. It is not a live connection, and changes made in Pool Check-in do not go back to the sheet.
The Import your resident list page and the help article on getting your list ready cover the same ground for any source. The list of integrations shows which systems we have named pages for.
Clean the list before you upload
A few minutes in a spreadsheet saves surprises at the gate:
- Remove columns you do not need, especially phone numbers, email addresses and notes.
- Check that every row has both an address and a name. Rows without them are skipped, and the preview lists each skipped row with its reason.
- Make addresses consistent. Unit 4 and Apt 4 become two households if they are spelled differently.
- Delete people who no longer live there, so a former resident cannot be checked in.
- Keep a copy of the original file so you can compare it with what you uploaded.
The preview comes first
Every import is previewed before anything is saved. The preview shows the columns it found, how many residents and households it found, a few sample rows and every row it would skip, with the reason. Read it the way you would read a proof. If the household count looks too low or too high, close the preview, fix the file and try again, because nothing has been saved yet.
When the file has a dues column, the preview also shows which households it would mark as behind on dues. Nothing is marked until you apply it.
Add or replace, and the 24-hour undo
You can add the file to your list or replace the list with it. Replace all asks you to confirm the community and the number of residents first. It clears the list and loads the file, and it keeps the bans, suspensions and dues marks you set. If an address is spelled differently in the new file, a mark tied to the old spelling stops applying and the app tells you.
After you confirm, you can undo the last import for 24 hours. An undo of a replace works only while nobody has added or removed residents since, because it puts the old list back as it was. That makes the first import low risk, because a wrong file can be taken back. After a day, or once a newer import exists, the undo is gone, so check the result on the day you load it.
Keeping the list current
A roster goes stale when owners sell and tenants move. Upload a new file when that happens, or let a shared Google Sheet sync when you press the button. A household you banned by hand stays banned when you import dues, because imports change only the marks they created.
This guide is general information about running a pool. It is not legal advice. Rules about pools, records and guests vary by state and county, so ask your association’s attorney about yours.