Filters and options in the AP Aging Summary report
A complete list of filters, what each one does, and how to use them.
Jul 11, 2026
| Filter | What it does | Example use | Notes |
|---|---|---|---|
| Vendor | Show only outstanding balances for one vendor, or leave blank for all. | Select "Farmaline" to see only what you owe Farmaline. | Optional; if blank, includes all vendors. |
| As of date | Measure aging from this date forward. Bills older than this date are included; bills in the future are excluded. | Set to 2026-07-03 to see aging as of today. | Defaults to today. Changing this changes which age bucket each bill falls into. |
| Currency | Show balances in a single currency. | Select "USD" to see only USD payables. | Required; multi-currency reports show totals separately per currency. No auto-conversion. |
| Account | Filter to bills posted to a specific payables account (if your chart has multiple AP accounts). | Select "Accounts Payable – Imports" to see only import bills. | Optional; leave blank to include all AP accounts. |
Filter behavior
- Multiple filters at once: all filters work together (AND logic). E.g., "Vendor = Farmaline AND Currency = USD AND As of date = 2026-07-03" shows only Farmaline's USD payables as of today.
- Blank fields: most filters are optional. Leaving them blank means "include everything in that dimension."
- Date changes: moving the "As of date" backward or forward shifts bills between age buckets, so the same bill might appear in "31–60 days" on one date and "61–90 days" on another.
Was this helpful?