Skip to main content

Payment reports

Five reports cover the money owners pay you.

M
Written by Michael Bollinger

Five reports cover the money owners pay you. Payments by Unit lists each payment, unit by unit. Receipts Detail shows which invoice each payment paid. Prepayments by Unit shows money paid ahead. Deposit Details shows what's inside each bank deposit. Returned Payments lists payments that came back.

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 five are in the Payment Reports section of Reports.

Report

Opens on

Filters

Use it when

Payments by Unit

This year

Date range, View payments by, Payment methods

You want every payment received in a period, by unit, with fees.

Receipts Detail

This FY

Date range, Payment methods

You want to know which invoices each payment paid, and in which category.

Prepayments by Unit

Today

As of date, Calculate prepayments by

You need to know who has paid ahead or has credit, for example to explain a Prepayments line.

Deposit Details

This year

Date range, Filter deposit account, Revenue category, Deposit types, Anonymous mode

You're matching a bank deposit to the owner payments in it.

Returned Payments

This FY

Date range, Payment methods

You want a list of returned or bounced payments.

Payments by Unit

  1. On Reports, click Payments by Unit.

  2. Pick the range with Start date and End date.

  3. Under View payments by, choose Payment date (when the payment was made or recorded) or Deposit date (when it reached your bank).

  4. Under Payment methods, untick any of Check, Cash, Bank, Card and Credit you don't want. All are on to start.

  5. Click Show results.

Payments are grouped by unit, with a Total for line for each unit and Total Payments at the bottom.

Column

What it is

Date

When the payment was made or recorded

Type

The method, such as Credit Card, Bank Account, Check (offline), Cash (offline) or Account Credit. Lockbox checks show as Check (Lockbox).

Recorded By

The person who recorded or made the payment

Deposit Date

When it reached your bank. Recorded checks and cash use the date they were recorded.

Notes

The note added to the payment

Amount

The amount applied to the owner's account

Fees

Processing fees your association paid on it

Net

Amount minus Fees: what the association kept

Fees and Net only appear when at least one payment in the report had fees your association paid. Fees the owner paid on top (the convenience fee) aren't in Amount or Fees. See Processing fees and the convenience fee.

  • Counts: payments that succeeded or are still pending.

  • Leaves out: failed, returned and deleted payments. With Deposit date, online payments that haven't reached your bank yet are left out too.

Receipts Detail

One row for each invoice or credit a payment paid, newest first, with Total Payments at the bottom.

  1. On Reports, click Receipts Detail.

  2. Pick the range. It opens on This FY.

  3. Under Payment methods, untick any of Paper check, Cash, Bank account, Credit card and Account credit you don't want.

  4. Click Show results.

Column

What it is

Payment Date

When the payment was made or recorded

Charge Title

The invoice it paid

Charge Active

That invoice's date

Category

The invoice's income category

Payment Method

How it was paid

Unit

The unit

Payor

Who paid

Payment Amount

The part of the payment applied to that invoice

How credit shows up:

  • When a payment, or part of one, became account credit and hasn't been used yet, it shows as Account Credit for $X, in your prepaid liability category (for example Prepaid Revenue).

  • When that credit is later used on an invoice, the row is listed under the original payment, with the invoice it paid.

So a payment is listed once, by the invoices it ended up paying. Returned payments, payments that failed and payments on invoices that were later deleted are left out.

See how one owner's payments were applied to invoices

Receipts Detail is the report that shows payment application: which invoice each payment paid, and how much of the payment went to it. It covers every unit and has no unit or owner filter, so to see one homeowner:

  1. Run Receipts Detail for the dates you need.

  2. Click Export CSV.

  3. In your spreadsheet, filter the Unit column to that unit. Each row is one payment applied to one invoice: Payment Date, Charge Title, Payment Method and Payment Amount.

There's no statement for one unit that shows how each payment was applied. Unit Balance Detail, Payments by Unit and the unit's Account history PDF list invoices and payments in date order with a running balance, but not which invoice a payment paid.

Prepayments by Unit

Money on each unit that's been paid but not yet earned.

  1. On Reports, click Prepayments by Unit. It runs as of today.

  2. Change the As of date if you need another day.

  3. Under Calculate prepayments by, choose Active date (the default) or Due date. This decides when an invoice counts as "in the future".

  4. Click Show results.

Each unit with a prepayment is a heading, with:

  • Invoices paid ahead — invoices whose active date (or due date) is after the as-of date but that had been paid by then.

  • Account Credit — unused credit on the unit, on one line.

Column

What it is

Charge

The invoice title, or Account Credit

Category

The invoice's income category

Active Date / Due Date

The invoice's dates

Charge Amount

The invoice amount

Prepayment Total

How much was paid ahead

Total Prepaids at the bottom is the total. The CSV adds Unit and Address.

This is the report that explains a Prepayments or Uncategorized Account Credits line on a cash-basis profit and loss or budget report: it lists the units whose money hasn't been applied to a current invoice yet. See Account credit and Reports: common questions.

Deposit Details

Each money-in transaction on your bank accounts in the range, with what's inside it.

  1. On Reports, click Deposit Details.

  2. Pick the range.

  3. To narrow it down:

    • Filter deposit account — pick one or more bank accounts (All accounts to start).

    • Revenue category — only deposits that contain that category (All categories to start). A matching deposit is shown whole, with all its payments, not just the lines in that category.

    • Deposit types — untick any of PayHOA (online payments paid out to you), Lockbox (only shown if your association uses the lockbox), Offline (recorded checks and cash you deposited) and Other (every other money-in transaction, such as interest or a bank-feed deposit).

    • Anonymous mode — shows a unit ID in place of each payer's name.

  4. Click Show results.

Column

What it is

Date

The deposit date; for the payments inside it, the payment date

Description

The deposit, then each payment in it

Account

The bank account

Category

The income category, or {n} Categories when it covers several

Amount

The amount

Expand a deposit to see the payments in it, and a payment to see the invoices it paid. Total Deposits at the bottom adds up the deposits.

To print one deposit. The report has no checkboxes for picking individual deposits: Export CSV and Save as PDF always include every deposit that matches the filters. To print a single deposit, set Start date and End date to that deposit's date, pick its bank account under Filter deposit account if other deposits landed that day, click Show results and then Save as PDF. Use this with the bank statement to explain a deposit. See Link owner payments to deposits and Get paid: deposit accounts and when money arrives.

Returned Payments

  1. On Reports, click Returned Payments.

  2. Pick the range. It opens on This FY. The range is matched to the date of the original payment, not the date it was returned.

  3. Under Payment methods, untick any methods you don't want.

  4. Click Show results.

Column

What it is

Payor

Who paid

Unit

The unit. (Deleted) after it means the unit has since been deleted.

Payment Date

The date of the original payment

Type

The payment method

Date Deleted

When the payment was deleted, or --

Return Reason

The reason recorded. If the payment was also deleted, it starts with *** DEL -.

Amount

The amount that came back

Total at the bottom adds them up. For online bank payments, the bank's own return code isn't kept, so Return Reason may only say the payment was returned. See When an online payment fails, is returned or is disputed.

Refunds

There's no refund report. A refund shows on the unit's Account history and on the ledger. Deposit Details only lists money coming in, so a refund doesn't get its own row there; when it was taken out of a payout, it appears as a line inside that payout. See Refund an owner's payment.

Troubleshooting

Problem

What to do

A payment is missing

Check Payment methods and View payments by. A payment by deposit date that hasn't reached your bank yet isn't listed. Failed and returned payments are left out.

There are no Fees and Net columns

No payment in the range had fees your association paid. Owners may be paying the convenience fee.

A deposit's total doesn't match the bank

The bank amount is after processing fees and refunds. Open the deposit on Deposit Details to see each payment. See Get paid: deposit accounts and when money arrives.

I need to know which units make up a Prepayments line

Run Prepayments by Unit as of the end of the period.

I need to see how one owner's payments were applied to their invoices

Export Receipts Detail to CSV and filter the Unit column. See See how one owner's payments were applied to invoices above.

I can't select individual deposits to print on Deposit Details

There's no selection. Narrow the dates (and the deposit account) to the one deposit, then Save as PDF.

The same payment shows on two rows of Receipts Detail

It paid two invoices, or part of it became credit. Each row is the part applied to one invoice.

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

What's next

Did this answer your question?