Skip to main content

Unit balance and invoice reports

These reports show what each unit was charged and what it owes.

M
Written by Michael Bollinger

These reports show what each unit was charged and what it owes. Use the unit balance reports for balances and statements over a period, the invoice reports to list invoices by unit, category or title, and New Recurring Charges to see who was added to or removed from a recurring invoice.

Before you start: you need Reports access. Picking dates, exporting, scheduling and adding a report to a packet work the same as on every report. See Run, filter, export and favorite a report.

All seven are in the Who Owes You section of Reports. For who's past due, see Aging and delinquency reports.

Report

Opens on

Filters

Use it when

Unit Balance List

Today, runs on open

Select units

You want every unit's balance right now.

Unit Balance Summary

This year

Date range, Select units

You want each unit's starting balance, charges, payments and ending balance for a period.

Unit Balance Detail

This year

Date range, Select units

You need a statement for one or more units over a period, for example for a lender.

Invoices by Unit

This FY

Date range, Select units

You want every invoice issued to each unit in a period.

Invoices by Revenue Category

This FY

Date range

You want invoices grouped by income category, for example all special assessments.

Invoices by Title

This FY

Date range

You want invoices grouped by their title, for example "2026 Annual Dues".

New Recurring Charges

This FY

Date range

You want to know which units were added to or removed from a recurring invoice.

Pick units

Unit Balance List, Unit Balance Summary, Unit Balance Detail and Invoices by Unit have a Select units section with a unit picker: a search box, Unit tags, Owner tags and Balance filters, and a list of units.

  1. Tick the units you want. The section's subtitle changes from All units included until you pick some to how many you picked, for example 3 units selected.

  2. Click Show results.

With no units ticked, the report includes every unit. Deleted units aren't offered and aren't included.

The Balance filter narrows the list of units you can tick. Its choices are Has balance, Has past due balance and Zero balance (a unit that owes nothing). It only filters the list: to limit the report, tick the units it leaves, for example with the checkbox at the top of the list, and then click Show results.

Zero-balance units, and archived or past owners. To run a unit balance report for all owners, leave every unit unticked. Unit Balance List, Unit Balance Summary and Unit Balance Detail then cover every unit, including units with a zero balance and units with no activity in the period. These reports are by unit, not by person, so a unit's invoices and payments from before a change of ownership, or from an owner who has since been archived or moved out, are still in its figures and still listed on Unit Balance Detail for the dates you pick. Only the heading changes: it names the unit's current owners. No balance report lists an archived or previous owner's balance by name. To see who owned a unit before, run the Ownership Change report, whose Previous Owners column names them; see Ownership Change. For one unit's whole history under every owner, use Account history PDF → For all owners on the unit's page. See Produce a statement as an admin.

Unit Balance List

Every unit's balance now. The card says As of {date} at {time}: the moment you ran it.

Column

What it is

Unit Title

The unit

Unit Address

The unit's address

Owner(s)

The current owners

Outstanding Balance

The unit's current balance, the same number the Units page shows.

A scheduled send of this report for a past date uses the balance at the end of that day instead.

Unit Balance Summary

One row per unit for the period.

Column

What it is

Unit

The unit

Owners

The current owners

Starting Balance

What the unit owed at the start of the range

Total Charges

Invoices that became active in the range

Total Payments

Payments recorded in the range that succeeded or are still pending

Ending Balance

Starting Balance + Total Charges − Total Payments

The last row, Total Transactions, totals each column. The CSV has Unit Title and Unit Address in place of Unit.

Unit Balance Detail

A statement for each unit over the period: a heading with the unit and its owners, then:

  1. Starting Balance — what the unit owed at the start of the range.

  2. One line per invoice (Invoice Created) and per payment (Payment Received), in date order, with a running Balance.

  3. Ending Balance.

Column

What it is

Date

Invoice date, or the date the payment was recorded

Action

Invoice Created or Payment Received

Description

The invoice title, or the payment method

Category

The invoice's income category

Amount

Positive for an invoice, negative for a payment

Balance

The running balance

The CSV adds a Unit column to every row.

For a lender or a refinance: pick the unit, set the range (for example the last 24 months), click Show results, then Save as PDF.

  • Counts: active invoices dated in the range, and payments recorded in the range. Invoices with a future date only appear once something has been paid on them.

  • Leaves out: deleted invoices, invoices with no income category, and payments that were deleted or returned.

Tip: For one unit, the Account history PDF on the unit's page is often quicker. It covers the unit's whole history rather than a date range, and shows forgiven invoices and returned payments too. See What owners can see: account history and statements.

Invoices by Unit, by Revenue Category and by Title

The three invoice reports list the same invoices, grouped three ways. Each group has a heading and a Total for line; Total Invoices is the grand total.

Report

Grouped by

Visible columns

Invoices by Unit

Unit, with its owners in the heading

Title, Status, Active Date, Due Date, Category, Deposit Acct, Amount, Remaining

Invoices by Revenue Category

Income category

Unit, Title, Status, Active Date, Due Date, Deposit Acct, Amount, Remaining

Invoices by Title

Invoice title

Category, Unit, Status, Active Date, Due Date, Deposit Acct, Amount, Remaining

  • Status is the invoice's status today: paid, partial, current, future or overdue.

  • Deposit Acct is the bank account the invoice's payments go to.

  • Remaining is what's still unpaid today, not on the range's end date.

  • The CSV adds columns the screen hides: Unit Title and Unit Address on all three, plus 1st Owner First Name and 1st Owner Last Name on Invoices by Unit.

What they count:

  • Counts: invoices whose invoice date (active date) falls in the range, including ones in a category you've since deleted.

  • Leaves out: deleted invoices, invoices with no income category, and invoices on units that have been deleted.

To find or export invoices with more filters, use the Invoices page. See Find, filter and export invoices.

New Recurring Charges

Shows changes to who's on each recurring invoice template during the range. Each template is a heading with the date it was created; under it, one line per unit added or removed.

Column

What it is

Unit

The unit added or removed

Action

added or deleted, with the date and time

Charge Amount

That unit's amount on the template

The CSV adds a Template column. Templates with no unit changes in the range aren't listed. See Manage recurring templates.

Troubleshooting

Problem

What to do

A unit's balance here doesn't match the Units page

Unit Balance List uses the same number, as of the moment you ran it. Unit Balance Summary and Detail stop at the end date. Run them to today to compare.

A previous owner's invoices are on the statement

These reports cover the unit, not the owner. For the current owner only, use Account history PDF → For current owner(s) on the unit page.

An invoice is missing

Check its invoice date is in the range. Deleted invoices, and invoices on deleted units, are left out.

Remaining doesn't match the past date I picked

Remaining is always as of today. For a balance on a past date, use Unit Balance Summary or Aging of Accounts.

No results found

Nothing matched. Widen the range or untick the units under Select units.

For other messages, see the troubleshooting table in Run, filter, export and favorite a report.

What's next

Did this answer your question?