Reporting

Transaction Report

The Transaction Report lists the individual transactions that make up a number on another report. It's the drill-down you land on when you click an income, expense or balance-sheet line on the Profit & Loss or Balance Sheet — so you can see exactly which payments, invoices and journal entries produced a figure.

Note

The Transaction Report isn't listed as a tile on the main Reports hub. You reach it from the sidebar or by drilling down from the Profit & Loss or Balance Sheet.

What it lists

What appears depends on the line you drilled in from (the type and category):

  • Income or expense transactions for a chosen account.
  • All income and expenses together, for a Net Income view (expenses reduce the running balance).
  • Asset, liability or equity account transactions for a balance-sheet account.
  • An A/R aging view of unpaid invoices when opened from the A/R Aging Summary.

A running balance is maintained down the list, so the final balance equals the report total.

Columns

Column What it shows
Date Transaction date.
Type The kind of transaction (Payment, Invoice, etc.).
Num The reference number (payment/invoice number).
Name Tenant, program or vendor.
Memo/Description Line description.
Category The income/expense account.
Property The related property.
Amount Transaction amount.
Balance Running balance.

You can show/hide columns and drag to reorder them from the columns panel.

Filters

  • Date range — choose a preset (Today, This Month, This Year, All Dates, etc.) or custom from/to dates. The default range is year-to-date.
  • Accounting methodaccrual (default) or cash.
  • Search & conditions — filter rows by Name, Transaction type, Category, Property, Memo/Description or Amount, using operators like contains, equals, greater than and less than.
  • Sort — order the rows by any sortable column.

Use Print to open a clean, formatted print/PDF view of the visible columns, or email the report to a recipient.

Was this article helpful?