Units, leases and owners,ready for Buildium's rentals import.
Collect one row per unit, with its lease, tenant and rental owner, in the column order of Buildium's Rentals workbook, with sub types, rent frequencies, dates and contact details checked before you paste them in.
Buildium Rentals
Try the template with up to 3 rows
What You'll Collect
Property & unit
StringProperty name, unit number and the property and unit addresses, with a postal code that keeps its leading zero.
Sub type
EnumSingle-Family, Multi-Family, Condo/Townhome, Industrial, Office, Retail, Shopping center, Storage or Parking space.
Lease dates & rent
DateLease start and end, next due date and the rent amount, as real dates and plain numbers.
Up to three rent charges
NumberRent, Rent 2 and Rent 3, each with an amount, an income account, a due date and a memo.
Tenant contact
EmailName, login and alternate email, phone numbers and an emergency contact, checked as they are typed.
Rental owner
StringThe owner's name, address, contact details and agreement dates, one owner spelled the same way every time.
Need more than three rows?
Collect every property's details.
The free template is limited to three rows so you can try the workflow. Create your own form to send to each owner or site manager, and get units, leases and owners back in one file instead of a different spreadsheet from every source.
Create your own formBuildium's column order
All 72 columns of the Rentals workbook in its order, so the downloaded CSV pastes straight in.
Checked as they type
Sub types, rent frequencies, dates, amounts, emails and phone numbers are checked, and missing required values are highlighted.
Your own fields
Add a parking space, a pet deposit or a lock code to your own form.
Up to 1,000 rows
A whole building's units in one file.
How it works
From the rent roll to Buildium in three steps.
01
Collect
Import your current rent roll, or send the form to each owner or site manager.
02
Complete
One unit per row. Missing required values, sub types that aren't on the list and bad dates are highlighted.
03
Download and paste
Download the CSV and paste its rows under the headings of Buildium's Rentals workbook, replacing the sample row. Then upload it in Settings, Import data.
Why use a form?
Buildium's workbook is built on fixed lists.
Sub type, rent frequency, bedrooms and bathrooms each come from a set list, with exact wording such as 1.5 Bath and Every two weeks. Rows typed freely by owners and site staff rarely match, and one off the list costs a re-check of the whole file.
A form offers the lists as it is filled in, keeps dates as dates and postal codes as text, and highlights rows that are missing a required value.
Sub types and frequencies off the list
Single family, SFH and Monthly rent are three spellings of what Buildium wants as Single-Family and Monthly.
Dates and zeros lost in Excel
A lease date pasted as text, or a postal code like 01234 that becomes 1234, doesn't match what you meant.
Owners spelled two ways
Buildium links properties to a rental owner by name, so Mike Kelley and Mike Kelly become two owners.
Buildium rentals import template
How Buildium's Rentals workbook is laid out
Buildium, property management software for residential and association managers, can load properties, units, tenants and rental owners from a spreadsheet. It publishes a Rentals workbook for the purpose, and you upload the completed file in Settings under Import data.
The workbook is one wide sheet with a row for each unit. Property and unit details come first, then the tenant and the lease, with up to three rent charges that each have an amount, an account, a next due date and a memo. After those come the tenant's address and contact details, then the rental owner. Columns marked with an asterisk are required, and the rest are marked optional.
Some columns come from set lists: the property sub type (Single-Family, Multi-Family, Condo/Townhome, Industrial, Office, Retail, Shopping center, Storage, Parking space), the rent frequency, bedrooms, bathrooms and Yes or No for 1099 eligibility. The bank account and income accounts have to match accounts in your Buildium account. The sample row shows dates as real dates, a postal code with a leading zero and phone numbers in the (617) 098-9827 layout.
This template follows the workbook's column order, so the CSV you download pastes straight in. The tenant and owner columns that share a name in the workbook, such as City/Locality, are prefixed so every column stays unique; the order is unchanged. It covers the Rentals workbook, not Buildium's association templates or its separate tenant and rental owner uploads.
How-To Guides
Related Templates
Read Buildium import errors for every rule and its fix, or see Import Builder for property managers. Importing vendors too? Use the Buildium vendors template. Moving between systems? Read the property management data migration guide.
Need a CSV form of your own?
Create a custom Import Builder form with your own fields, validation and row limits.
Get started