These reports show what your association spends and what it still owes. The three expense reports total spending by vendor or by category. The vendor reports show your vendors, what you owe each one and how overdue those bills are. Check Register lists the checks you've printed or mailed, and Subscription History lists what PayHOA has charged your association.
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 of them are in the Expense Reports section of Reports.
Report | Opens on | Use it when |
Expenses by Vendor | This FY | You want to know how much you paid each vendor. |
Expenses by Category | This FY | You want every expense, grouped by expense category. |
Expenses Detail | This FY | You want one list of every expense, with vendor and memo. |
Check Register | This FY | You need a log of checks you printed or mailed through PayHOA. |
Check Register Legacy | This FY | You need checks printed with PayHOA's older check printing. |
Vendor Overview | This year | You want a vendor list with the fields you pick, plus totals paid. |
Vendor Balance Summary | Today | You want what you owe each vendor on a date. |
Vendor Balance Detail | Today | You want the unpaid bills behind each vendor's balance. |
Vendor Aging of Accounts | Today | You want your unpaid bills by how overdue they are. |
Vendor Aging of Accounts Detail | Today | You want the same, bill by bill. |
Subscription History | This FY | You want PayHOA's own charges to your association. |
Note: These reports list expenses; they don't include the attachments (invoice copies). To download a year's vendor invoices and attachments in bulk for your records, export them from Payables. See Can I download all our vendor invoices and attachments for the year at once?
What counts as an expense
Expenses by Category and Expenses Detail use the same rules as the profit and loss reports. See Profit and loss reports.
Counts | Doesn't count |
Approved bank transactions with an expense category | Transactions still on For review, uncategorized and excluded transactions |
Journal entries to an expense category | Transfers between your own accounts |
Payables (bills), once — the bill and its payment aren't counted twice | On cash basis, payables whose payment was cancelled |
Payables are dated by their payment on cash basis and by their invoice date on accrual basis. See How payables show up in your books.
Expenses by Vendor
What you paid each vendor in the range. Each vendor is a heading, with a Total for line, and Total Vendor Expenses at the bottom.
Column | What it is |
Send Date | When the payment was sent or made |
Check # | The check number, if there is one |
Memo | The payment memo |
Description | What the payment was |
Amount | The amount |
The CSV adds Vendor, Nickname and Expected Delivery.
Counts: payables sent for payment, checks and bill payments made in PayHOA, and approved bank transactions that have the vendor set on them. A vendor you've since deleted still shows if it was paid in the range.
Leaves out: bank transactions with no vendor set, transactions that are excluded or still on For review, and, on cash basis, payments that were cancelled or declined. On accrual basis a voided payment still shows, because voiding undoes the payment and not the bill: the bill is still an expense, and still in Accounts Payable, until you delete the payable (Payables → Unpaid → ⋯ → Delete). See Voids and deletes.
There's no filter for one vendor, and no vendor ledger report. To see everything paid to one vendor for a specific period, find the vendor's heading on this report for your dates (or filter the CSV's Vendor column), or filter Payables → Paid by Vendor and Payment date. See Can I run a vendor ledger? For all of a vendor's payments with no date range, open the vendor's page. Vendor Overview can give a total too, but its Total Amount follows the report's payment dates (it opens on This year), so set a range wide enough to cover every year you want. See The vendor page: documents, notes and history.
Tip: A bank transaction only counts here if its Vendor is set. When you categorize a vendor payment, pick the vendor too. See Review and categorize transactions.
Expenses by Category
Every expense in the range, grouped by expense category, with a Total for line for each category and a grand total. The first column is Category / Date; the others are Description, Account and Amount.
Click a category to open its Account Register for the same dates.
Expenses Detail
Every expense in the range on one list, with Total Expenses at the bottom.
Column | What it is |
Date | The transaction, journal entry or payable date |
Description | The description |
Account | The bank account |
Category | The expense category |
Memo | The memo, or the payable's memo |
Vendor | The vendor, if set |
Amount | The amount |
Check Register
Shown when your association uses check printing. Lists every check you printed yourself or had mailed through PayHOA, with its status. Drafts never appear.
The date range is matched to each check's own date: the check date for a printed check, the send date for a mailed check, or the scheduled date (or the bill's due date) for a mailed check that hasn't gone out yet.
Column | What it is |
Check Number | The check number |
Type | Printed (you printed it) or Mailed (PayHOA mailed it) |
Bank Account | The account it's drawn on |
Check Date | The date described above |
Payee | Who it's to |
Memo | The memo |
Amount | The amount |
Status | Where it is now, such as Scheduled, Printed, Mailed, Processed, Paid, Cleared, Voided or Cancelled. Reconciled means the check number appears in a finished bank reconciliation. |
Check Register Legacy appears only if your association printed checks with PayHOA's older check printing, before Payables. It has the same columns. Type is Legacy and Bank Account is blank.
Vendor Overview
A vendor list with the fields you choose.
On Reports, click Vendor Overview.
Under Step 1: Choose payment dates, set the range. Every active vendor is listed whatever the dates; the range only changes Total Amount and Total Checks. A deleted vendor appears only if it had activity in the range or has a payable.
Under Step 2: Pick your columns, tick the fields you want in Vendor fields (and Vendor custom fields, if you have any). The fields are listed alphabetically, and some are ticked to start. Search across all fields... finds a field by name.
Click Show results.
The fields are Vendor ID, Vendor Name, Nickname, Account Number, EIN, Full Address (or Address Line 1, Address Line 2, City, State, Zip), Full Contact Info (or Contact Name, Contact Email, Phone #, Fax #), Website, Total Checks and Total Amount. If none is ticked you'll see Please select at least one field to view a report.
Note: This message can also pop up as the report opens, even though columns are ticked and results are showing. You can ignore it.
This report's CSV is also the starting file for changing many vendors at once. See Update existing vendors with the importer.
Vendor Balance Summary and Detail
What you owed each vendor at the end of a day.
On Reports, click Vendor Balance Summary or Vendor Balance Detail. It runs as of today.
Change the As of date if you need another day.
Keep Hide $0.00 balances on to list only vendors you owe.
Click Show results.
Vendor Balance Summary has Vendor and Balance Due, with Total Outstanding at the bottom. Click a vendor to open it.
Vendor Balance Detail lists the bills: Vendor, Invoice #, Invoice Date, Due Date, Memo and Amount.
Counts: confirmed payables with an invoice date on or before the as-of date that were still unpaid at the end of that day. A bill whose payment is still waiting for approval, or was declined or cancelled, still counts as owed.
Leaves out: drafts, payables paid by that date (a payment that has been sent, printed, processed or marked as paid counts as paid), and vendors you've deleted.
Vendor Aging of Accounts and Detail
The same unpaid bills, split by how overdue they are on the as-of date.
Column | What it is |
Vendor | The vendor |
Total Due | Everything unpaid |
Currently Due | Not yet due, due on the as-of date, or with no due date |
1-30 Days Past | Due 1 to 30 days before the as-of date |
31-60 Days Past | 31 to 60 days |
61-90 Days Past | 61 to 90 days |
90+ Days Past | More than 90 days |
Total is the last row. Vendor Aging of Accounts Detail adds Invoice # and lists each bill under its vendor, ending with Total Outstanding. Both use the same rules as the vendor balance reports.
A bill shows as long as it's unpaid. If a bill you've paid is still here, its payment was recorded after the as-of date, or it was paid outside PayHOA and never marked paid. See Record a payment made outside PayHOA.
Subscription History
What PayHOA has charged your association and how you paid. The columns are Charge Title, Description, Date Due, Method and Amount, grouped by payment date with Total Payments at the bottom. The CSV adds Payment Date.
1099s
None of these reports gives you 1099 totals. Use the 1099 tools in Payables. See File 1099s for your vendors.
Troubleshooting
Problem | What to do |
A vendor I paid isn't on Expenses by Vendor | The bank transaction has no vendor set. Open it on Transactions and pick the Vendor. |
A bill is counted twice | The payable and its bank transaction were both given an expense category. See How payables show up in your books. |
A check I printed isn't on Check Register | Its check date is outside the range, or it was printed with the older check printing. Try Check Register Legacy. |
Check Register isn't on my Reports page | Your association doesn't use check printing. For a check register for a date range without it, for example for an audit, run Account Register for the bank account and those dates. See Where is a check register for a date range? |
I need a vendor ledger: one vendor's payments for a date range | There's no vendor ledger report. See Expenses by Vendor above and Can I run a vendor ledger? |
A paid bill shows on vendor aging | See "Vendor Aging of Accounts and Detail" above. |
For other messages, see the troubleshooting table in Run, filter, export and favorite a report.
