Skip to main content

For property managers

Import rental properties by CSV: your rent roll and certificate dates, without retyping

The agency import wizard turns a CSV saved from your spreadsheet or property software into a Portfolio, with no retyping. It matches the columns, shows a preview and saves nothing until you press Import.

Read more

Upload a newer file later and it updates what is there instead of adding copies.

Pilot offer: the first 20 businesses to sign up get 3 months at no charge (no card needed), then 25% off for as long as you stay a member. 17 of 20 places left. How it works

The demo is your own private copy with made-up example data. No sign-up, and it's deleted automatically.

Prices include GST.

Property import feature, import properties and certificate dates screen for a property manager on a phone, with example data: a note that only what is needed is kept, a Template button, a Choose File box for a CSV and a box to paste cells from a spreadsheet with an example address and certificate expiry date
Property import on a phone, with example data.
Property import feature, import screen for a property manager: a Download template button and a Choose File box to upload a CSV export, with a note that owner and tenant details are not kept and nothing is saved until you press Import
Computer view, swipe sideways to see more. Open full size
Property import feature, import screen for a property manager: a Download template button and a Choose File box to upload a CSV export, with a note that owner and tenant details are not kept and nothing is saved until you press Import
The Import screen, with example data: a Download template button, a box to choose a CSV export, and a note that owner and tenant details are not kept and nothing is saved until you press Import.

What you get with Property import

  • Import your rent roll from a CSV file in three screens

    Press Import on the Portfolio page to load your rent roll from a CSV file. Nothing is saved until the last button.

    Read more

    Step 1, Choose or paste your list: pick a CSV file, or paste cells and press Use this list, or press Download template to see the headings PoolPreCert already recognises. In Excel use File, Save As, CSV. A file can hold up to 1,000 properties and be up to 1.5 MB, so split a bigger one.

    Step 2, Check the columns: PoolPreCert matches your headings to what it needs and says how many it matched. Press Change columns to pick a different column for any item. The optional question Which system is this from? helps us learn layouts and does not change what is imported. Matched layouts are remembered for the next file with the same headings.

    Step 3, Preview: chips count the rows to add, to update, with no change, skipped, and needing a fix. Press a chip to see only those rows.

  • Fix problems and add pool and certificate dates on the spot

    A row that needs a fix opens a small form under it, with Street address, Suburb, State, Postcode, Certificate expiry and Manager email. Correct it there; your original file is not touched. Dates are read the Australian way, so 5/3/2027 is 5 March.

    Read more

    If the state is missing it is worked out from the postcode, and a full address in one column is split for you.

    If your file has no pool or certificate column, tick Every row in this list is a property with a pool; if it has one, rows with no date are added as No date recorded unless you untick that box. Rows marked as having no pool, rows repeated further down the file and the template's example row are skipped, and the preview says why. A row with only an issue date gets an expiry worked out using QBCC's terms: 2 years for a non-shared pool and 1 year for a shared pool.

  • Uploading again never doubles anything

    Properties are matched by your own property code first, then by address, ignoring capitals, Street against St, and Unit 3 against 3/. A match is updated, never copied. An import never moves a certificate date backwards: if the file holds an older date, the later one is kept.

    Read more

    Nothing is ever deleted by an import.

    When it finishes, Import finished shows how many were added, updated and already up to date, with a table of what changed. Rows that were not imported can be saved with Download the rows not imported. See your portfolio takes you to the list. If your plan's property limit is reached, the page tells you which rows were left out. Undo this import (10 minutes) removes what it added and restores what it changed.

  • What it keeps and what it leaves out

    It keeps the address, whether there is a pool, whether it is shared, the certificate dates, number and inspector name, and your own property manager's name and work email. It does not keep owner or tenant names, phone numbers, emails, rent or lease details.

    Read more

    Columns that look like them are listed as Not imported and are never read.

    If your export is awkward to match, Get help tidying your list opens a page with a prompt to copy into an AI assistant you already use. It tells you to remove owner and tenant details first, and nothing reaches PoolPreCert until you upload or paste the result.

  • Send properties from Zapier or Make

    An owner or admin opens Calendar and connections, finds Send us properties from another tool and presses Make an API token. The token is shown once, so copy it then. You can hold up to 3, and Stop this token ends one straight away.

    Read more

    A connector or your software supplier then sends a POST to /api/v1/agency/import with the token as a Bearer token and a list of properties as JSON, up to 200 properties and 500 KB per call, 60 calls an hour for each token. Add ?dry_run=1 to see what would happen and save nothing. The reply counts added, updated, unchanged and skipped, and the same matching and no-delete rules apply.

How to start

  1. Get your export

    Save a spreadsheet of your properties as a CSV, or press Download template and paste your data into it.

  2. Choose the file

    On Import properties and certificate dates, choose your CSV and check the columns, pressing Change columns if one is wrong.

  3. Read the preview

    Press a chip such as need a fix, correct those rows in place, and tick the pool box if your file has no pool column.

  4. Press Import

    The button shows how many properties will be saved. Nothing is saved before this.

  5. Check the result

    Read What changed, then press See your portfolio.

What Property import does and does not do

What it does

  • Reads a CSV export and matches the columns
  • Shows a preview before anything is saved
  • Lets you fix problems in place and add pool and certificate dates
  • Can take properties from Zapier or Make

What it does not do

  • It does not connect to your property software. You upload a file, or a connector sends one.
  • It does not delete properties, and it does not move a certificate date backwards.
  • It does not load owner or tenant details, rent or lease dates, or smoke alarm dates.
  • It does not check certificates with QBCC. The dates are the ones in your file.

Common questions

Do I have to give you owner or tenant details?

No. Only the property, its pool and certificate dates, and optionally your own property manager's name and work email. Owner and tenant columns are ignored even if they are in the file.

What happens if I upload an updated file next month?

Properties are matched by your property code, then by address, and updated. You get no duplicates, later certificate dates replace earlier ones, and nothing is deleted.

Which file do I upload to import my rent roll, and can it be an Excel file?

A CSV. In Excel use File, Save As, CSV first, or press Download template to see the headings it already recognises. The wizard reads up to 1,000 properties and 1.5 MB at a time.

Can I check the list before it is saved?

Yes. Step 3, Preview, counts the rows to add, update, leave unchanged, skip and fix. Nothing is saved until you press Import.

Which property software does it work with?

Any that can save a spreadsheet or CSV of your properties. Software suppliers do not publish the headings of their exports, so the wizard matches by plain-English heading and lets you correct the match.

Does it cost extra?

Import is part of the business plans. Starter is $49 a month and Business is $99 a month (incl. GST). The first 20 businesses to sign up get 3 months at no charge (no card needed), then 25% off for as long as you stay a member. After the places are gone, plans start with a 14-day trial, no card required. Your plan sets how many properties you can hold.

What it needs and what it costs

Import is part of an agency account on a business plan or trial, and your plan sets how many properties you can hold. See the plans and prices. See the plans and prices. The first 20 businesses to sign up get 3 months at no charge, no card required. Prices include GST. Start 3 months at no charge

Try it before you pay

The first 20 businesses to sign up get 3 months at no charge, no card required. Prices include GST. The demo at the top of the page needs no sign-up.