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
On Reports, click Payments by Unit.
Pick the range with Start date and End date.
Under View payments by, choose Payment date (when the payment was made or recorded) or Deposit date (when it reached your bank).
Under Payment methods, untick any of Check, Cash, Bank, Card and Credit you don't want. All are on to start.
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.
On Reports, click Receipts Detail.
Pick the range. It opens on This FY.
Under Payment methods, untick any of Paper check, Cash, Bank account, Credit card and Account credit you don't want.
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:
Run Receipts Detail for the dates you need.
Click Export CSV.
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.
On Reports, click Prepayments by Unit. It runs as of today.
Change the As of date if you need another day.
Under Calculate prepayments by, choose Active date (the default) or Due date. This decides when an invoice counts as "in the future".
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.
On Reports, click Deposit Details.
Pick the range.
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.
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
On Reports, click Returned Payments.
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.
Under Payment methods, untick any methods you don't want.
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.
