Skip to main content

Custom reports

A custom report is a table of units and owners with the columns you choose: addresses, balances, owner names, emails, phone numbers…

M
Written by Michael Bollinger

A custom report is a table of units and owners with the columns you choose: addresses, balances, owner names, emails, phone numbers, tags, autopay, custom fields and more. Use it for a mailing list, a phone tree, a list of owners on autopay, or any list the standard reports don't give you. Save the columns as a template and you can rerun it in one click, schedule it, or add it to a report packet.

Before you start: You need the Reports permission. It has one level, Read, which is enough to build, run and export a custom report. To save, change, pin, schedule or delete a template you need Admin Status: there is no Reports write permission to give. See Permissions with only one level.

Custom reports only hold unit and owner information. They can't show transactions, invoices, payments or vendors. For vendor details, use Vendor Overview (see Expense and vendor reports). For money in and out, use the financial reports in Reports overview.

Build a custom report

  1. Click Reports in the left menu.

  2. On the Individual reports tab, go to Custom reports at the bottom and click Build report. The Create a custom report page opens.

  3. Step 1: Choose units or owners. Leave this alone to include everyone (Everyone is included until you pick some). To limit the report, tick units on the Select units tab, people on the Select owners tab, or both. You can search, and filter by Unit tags, Owner tags and Balance. The step's subtitle shows what you picked, for example 12 units and 3 owners selected.

  4. Step 2: Pick your columns. Tick the fields you want. They're grouped in sections, Unit fields, Unit custom fields, Owner fields and Owner custom fields, and listed alphabetically in each. Click a section name to open or close it.

    • Select all ticks every field in a section; Deselect all clears them.

    • Type in Search across all fields... to find a field by name. The link then reads Select visible and only ticks the fields that match.

  5. Click Show results.

The table appears below with one column per field and Generated {date and time} under its title. Click a column header to sort. Cancel clears every field, unit and owner you picked and starts over.

The fields you can pick

Section

Fields

Unit fields

Unit ID, Unit Title, Address, City, State, Zip, Past Due Balance, Balance, Tags, Other Contacts, Notes, Open Violations, Violation Status, plus one field for each of your association's request forms (see below).

Unit custom fields

One field for each custom field your association added to units. Only shows if you have some.

Owner fields

Full Name, First Name, Last Name, Email, Auxiliary Emails, Phone, Secondary Phone, Mailing Address, Address Line 1, Address Line 2, City, State, Zip, Country, Last Login, Tags, Autopay Enabled, Autopay Max, Account Number, Notes. If your association uses the paper-mail opt-out, there's also Electronic-only Communication.

Owner custom fields

One field for each custom field your association added to people. Only shows if you have some.

Request form fields. Each request form your association has (for example ARC Request or Pool Scheduling Form) appears as a field under Unit fields. It lists that unit's open requests on that form, newest first, each as the date and time it was submitted and who submitted it, for example 10/14/2026 09:12:45 am by Jane Smith. Completed requests aren't listed, and a unit with no open requests shows a blank cell. To work with requests themselves, see Requests overview.

The Account Number field. Account Number under Owner fields in a custom report is a reference PayHOA builds itself for each owner. You can't set or change it, and it isn't printed on invoices or statements. For your association's own account or member numbers, use a custom field. See Tags, notes and custom fields.

To add or change unit and owner custom fields, see Tags, notes and custom fields.

How rows are built

  • Any unit field picked: one row per unit. Each owner gets their own columns, headed First Owner First Name, Second Owner First Name and so on. Only owner custom fields are combined in one cell.

  • Only owner fields picked: one row per person instead of one per unit. Use this for a clean contact list where each person appears once.

Important: With only owner fields and nothing picked in Step 1, the report lists every person in your association, including admins and board members who don't own a unit. For owners only, tick the units in Step 1 (use the checkbox at the top of the list to select them all).

What you pick in Step 1 applies either way:

  • With a unit field: you get the units you ticked, plus the units owned by the people you ticked.

  • With only owner fields: you get the people you ticked, plus the people who own the units you ticked.

Export the report

After you click Show results, click Export above the table and pick one:

  • Export CSV — opens in Excel, Google Sheets or Numbers. There's no direct Excel export; CSV is the spreadsheet format.

  • Export PDF (portrait)

  • Export PDF (landscape) — better when you have many columns.

Note: The PDF doesn't follow the sort you set by clicking column headers, and exporting a PDF after you've sorted a column can fail with Unable to download PDF. If that happens, reload the page, run the report again and export it before you sort anything. If the order matters, export to CSV and sort it in your spreadsheet.

Make a mailing list or address labels

PayHOA doesn't print address labels. To make them, export the owners' names and mailing addresses with a custom report and use the file for a mail merge:

  1. Build a custom report. In Step 1, tick the units you're mailing to (use the checkbox at the top of the list for all of them), so that only owners are listed.

  2. In Step 2, under Owner fields, tick Full Name and Mailing Address. If your label template needs the address in separate columns, tick Address Line 1, Address Line 2, City, State and Zip instead.

  3. Click Show results, then Export → Export CSV.

  4. Open your word processor's mail merge for labels and use the CSV as the list of recipients.

Mailing Address uses the unit's address when an owner has no mailing address on file. The separate address fields don't; they're blank for those owners.

If you'd rather not print anything, send the letter through Mail Room and PayHOA prints, addresses and mails it. See Mail Room overview.

Save it as a template

A template remembers the fields and units you picked, so you don't have to tick them again.

  1. Build the report and click Show results.

  2. Click Save as template.

  3. Enter a Template name. The dialog shows how many fields and units it will save.

  4. Click Save template. You see Template saved successfully.

A template keeps the units and owners you picked in Step 1 as well as the fields. Templates belong to the association, not to you. Everyone with access to Reports sees them under Custom reports on the Reports page. Click one to open it; the page title becomes Custom report: {name}.

Changes to an open template save automatically

When a template is open, its name is in the page title. If you tick or untick a field, or change the units or owners in Step 1, the template saves itself a moment later and the header shows Saving... and then Saved at 2:41 PM. There's no separate save button. If you don't want to change the template, click Cancel first: it clears the page and detaches the template, so what you build next isn't saved over it.

Note: Without Admin Status, a change you make on an open template can't be saved, and you see Unable to save template changes. You can still run and export the report.

Rename or delete a template

  1. Open the template and click Actions at the top right.

  2. To rename it, click Edit report name, change the Template name in Edit template and click Save. You see Template saved.

  3. To delete it, click Delete report. The Delete custom report dialog asks Delete "{name}"? Its schedules stop too. This can't be undone. Click Delete report. You see Custom report deleted.

Deleting a template stops its schedules. It doesn't delete any packet it was added to (see below).

Favorite a template

Click the pin next to a template under Custom reports (Add to favorites). It then shows in the Favorites card at the top of the Reports page. Favorites are personal: each person picks their own. Click the pin again to remove it. Pinning a template needs Admin Status; with the Reports permission alone the pin doesn't stick. See Run, filter, export and favorite a report.

Schedule a template or add it to a packet

  • Schedule it: open the template and click Actions → Schedule. It's emailed on a timetable as a PDF, CSV or both. See Scheduled reports. A custom report you haven't saved can't be scheduled; save a template first.

  • Add it to a packet: templates appear in the Custom Reports section when you create a report packet, and show in the packet as (Custom) followed by the template name. See Report packets.

Important: A packet keeps the fields and units the template had when you added it. If you change the template later, the packet doesn't pick up the change. Remove the template from the packet and add it again.

Once a template has a schedule, the template page shows This report has 1 active schedule. Next delivery: … with a Manage schedules link.

Troubleshooting

What you see

What it means and what to do

Please select at least one field to view a report.

Tick at least one field before Show results or Export.

Please select at least one field to save as a template.

Same: a template needs at least one field.

Unable to save template changes.

The automatic save failed, usually because you have the Reports permission but not Admin Status. Saving a template needs Admin Status; ask an admin of your association to make the change.

Unable to load report data.

The report didn't run. Try again; if it keeps failing, contact support with the template name or the fields you picked.

Unable to download PDF.

If you sorted the table, reload the page, run the report again and export before you sort. Otherwise try Export CSV. If it keeps failing, contact support with the template name.

A custom report shows no results at all on a phone (for example in an Android phone's browser)

First make sure at least one field is ticked in Step 2 and click Show results; the table appears below the two steps, so scroll down. Custom reports can have many columns and are easier to use on a larger screen, so if the table still doesn't show, reload the page and try once more, then run the report on a computer or tablet. A report that works on a computer and stays blank on a phone isn't expected: contact PayHOA support with the template name or the fields you picked, the phone and browser, and a screenshot. See Troubleshooting.

A unit or owner is missing

Check Step 1: Choose units or owners: if any units or owners are picked, only those are included.

People who aren't owners are on the list

You picked only owner fields and nothing in Step 1. Tick the units in Step 1 to list owners only.

Show results is greyed out

No field is ticked yet, or the field list is still loading.

What's next

Did this answer your question?