Skip to main content

Expense and vendor reports

These reports show what your association spends and what it still owes.

M
Written by Michael Bollinger

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.

  1. On Reports, click Vendor Overview.

  2. 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.

  3. 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.

  4. 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.

  1. On Reports, click Vendor Balance Summary or Vendor Balance Detail. It runs as of today.

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

  3. Keep Hide $0.00 balances on to list only vendors you owe.

  4. 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.

What's next

Did this answer your question?