Preparing your fee and lease spreadsheet

This article explains how to build the spreadsheet you upload in the first step of the bulk import wizard, the one that creates or updates monthly fees and leases for many units at once. It is for property managers, building staff and board members who are preparing this file, and it is the article you will come back to most often, so it covers every column in full.

The fastest way to start: download the template

Before you build a spreadsheet from scratch, look for the button on the Upload step of the wizard that downloads a ready-made template. This template already knows your property: it comes with one row per real unit in your building, with the unit number already filled in and every other cell left blank for you to complete.

1. Open the bulk import wizard and stay on the first step, "Upload".
2. Find the button that downloads a template for this property, next to the file drop area.
3. Open the downloaded file in a spreadsheet program.
4. Fill in the blank cells for each unit's fee or lease.
5. Save the file as a CSV file.
6. Upload that file using the drop area on the same step.

If your property has no units set up yet, the downloaded template will only have the column headings and no rows to fill in. Add your units to the property first, then download the template again.

Every column, in full

The table below lists every column the spreadsheet can carry. The column name in the first row of your file must match one of the names shown here, or one of its listed alternatives, for it to be picked up automatically.

Four columns are always required, no matter what kind of fee you are recording: unit_label, lease_type, start_date and billing_day. The payer_name column is optional. Two more columns are required only depending on what lease_type says for that row: a row for a rented unit needs rent_amount_cents, and a row for an owned unit needs condo_fee_cents. Everything else is optional.

Writing amounts in cents

Every money column in this file, rent_amount_cents, condo_fee_cents, reserve_contribution_cents, security_deposit_cents, escalation_amount_cents, parking_amount_cents and add_on_amount_cents, is written in cents, not dollars. This is the part people get wrong most often, so read this section carefully.

To turn a dollar amount into cents, remove the dollar sign and the decimal point, and treat the result as a whole number.

1. $450.00 becomes 45000.
2. $1,250.50 becomes 125050.
3. $0.00 (no fee at all) becomes 0.

If you write 450 instead of 45000, the file will still be accepted, because 450 is a valid whole number. But it will be read as $4.50, not $450.00, because 450 cents is four dollars and fifty cents. The mistake will not be caught for you: it will quietly create a fee that is one hundred times too small. Always multiply your dollar amount by 100 before typing it into the file, and never include a decimal point, a dollar sign, or a comma in a money column.

The unit column: how it is matched

The unit_label column is compared against the real unit numbers already set up in your property. When a value matches a unit exactly, that row is accepted straight away. When a value is close to a real unit number but not identical, for example a typo or an old numbering format, the import will suggest the unit it thinks you meant, but it will not use that suggestion until a person confirms it on the next step of the wizard. A close match is never applied automatically.

The payer name column, and why email helps

The payer_name column is optional. When you fill it in, it is matched against the people already recorded on that unit. The closer the name is to an exact match, the more confident the system is; a name that only partly matches will be flagged for someone to check by hand.

If you leave payer_name blank, the row uses the unit's current payer, the one person who holds the unit's billing account today. If the unit has no payer, or has more than one, that row asks you to choose a payer on the Payer step.

The occupant_email column is optional, but it is the strongest way to point the import at the right person. If two people on the same unit have similar names, a matching email removes the guesswork. It is also the address used if the row ends up inviting a new person to the property, so an email you provide here saves a step later.

The date and billing day columns

start_date (and end_date, where it applies) must be written as YYYY-MM-DD, for example 2026-10-01 for the first of October 2026. Any other format will be rejected.

billing_day is the day of the month the charge is due, written as a whole number from 1 to 28. For example, a billing day of 1 means the charge lands on the first of every month. A billing day of 28 is the highest number accepted, because not every month has more than 28 days.

Columns the system does not recognise

If your spreadsheet has a column heading the import does not recognise, it will not stop your upload. On the Upload step, you can look at the table showing "CSV column" next to "Maps to" and point any unrecognised column at the right field by hand. Most files need no changes here at all; the matching happens automatically for common column names and their usual variations.

Anything you do not map, and that the system cannot use, is listed as "Not used" next to its column name. It is simply ignored, and nothing is lost from the columns you did map.

File size and format

The file must be a CSV file. The upload screen will accept a file up to 50 MB, but in practice the import can only process a file up to 10 MB and up to 20,000 rows. If your file is bigger than that, it will be rejected once you continue past the Upload step, with a message asking you to split it into smaller files. If you are importing a very large property, split the spreadsheet into two or more files and upload them one at a time.

A correctly filled-in sample

A small, correctly filled-in spreadsheet with one rented unit and one owned unit.

$450.00 was written as 45000, and $625.00 was written as 62500. Notice that each row leaves the money column that does not apply to it blank.

The column mapping table on the upload screen

The table on the Upload step where an unrecognised column can be pointed at the right field.

Related articles

Preparing your bank details spreadsheet