Browse articles
- Getting started
- Project finances
- Billing by the hour
- Practice finances
- Grouping fees
- Budgeting project costs
- Claim an expense
- Recording revenue entries
- Recording project expenses
- Purchase orders
- Approving expenses
- Going further
- Construction cost fees
- Recurring fees
- Billing expenses
- Contingencies and discounts
- Billing progress claims
- Project templates
- Overheads
- Getting started
- Billing milestones
- Sending an invoice
- Billing logged time
- Month-end invoicing
- Fee proposal templates
- Writing a fee proposal
- Getting a proposal signed
- Link invoices that are already in Xero
- Going further
- Payments and overdue invoices
- Connect your accounting system
- Fee groups on invoices
- Tax codes and accounts
Filter a report
Narrow a report live with option-list, numeric, and date-range filters, stack several at once, and keep every one of them editable and removable.
What you'll achieve
Narrow a report to the rows that actually matter, live, using status, numeric, and date filters together.
You'll end up with: A Projects report narrowed live by status, revenue, and a current date window, with every filter chip still editable and removable.
Before you start
A filter narrows which rows show up; nothing else about the report changes
Building a report is where filters were flagged as the third of the five decisions: which rows actually belong. Everything about columns, grouping, and sort still works exactly the same on a filtered report, filtering only changes which rows those other decisions apply to. Add Fee greater than zero, and the report is still grouped and sorted the same way on whatever's left, just on a narrower set of projects.
Every field type gets a filter shaped for what it actually is: a checkbox list for a status or another fixed set of options, a number and a condition for anything numeric, and the same date-range control used everywhere else in Monument for a date. You don't learn a new interaction for each field, you learn the shape once per data type.
Column filters narrow a figure
Report filters choose rows. Column filters choose the records that a figure adds up. For example, keep every project row and add up only its billable time entries.
Open a column's menu and choose Column filters, or use Add filter inside a family panel. The available choices depend on the source. Time entries offer entity, team member, role, billable and invoiced filters. Actual expense sources also offer expense type; planned revenue items and invoice lines offer revenue type. Tags use the source record's tags. A formula offers only filters supported by all its inputs. Each column keeps its own filters, so two columns can compare different parts of the same projects. Clear a column's filters to add up its complete source again.
Choose Invoiced next to Billable. Yes counts invoiced or marked-billed work; No counts work still unbilled. This filter is available on Actual hours, time-based values and Actual expenses. Upcoming work has no invoiced state. For Projected choices, Yes counts billed Actual work. No counts unbilled Actual work plus Upcoming work. The filter also follows a supported column into its periods, so you can compare unbilled work for a selected date range.
The filter follows the same rules as unbilled work. Time on draft invoices stays unbilled. Once any part of a time entry is billed or covered by a fixed fee, the whole entry counts as invoiced. Marking an entry billed also clears it from unbilled work. Time marked Never bill stays out of a Billable: Yes column. For partly billed expenses, the cost is split in the same proportion as the billable amount. A draft invoice reserving an expense's full billable amount removes it from unbilled work; a partial draft reservation leaves it unbilled.
Actual expenses adds up cost. WIP expenses adds up the amount still available to bill, including any markup, so these two figures can differ for the same expenses. The named WIP hours choice stays in Hours. WIP value and WIP expenses sit in Revenue. All three cover all time. They do not gain a date range from this filter.
Start a Projects report
- 1
Open All reports and click New report. Under Start from, choose Nothing. Under Reports on, choose Projects. Type a Name and click Create report.
An option list narrows by matching any of your picks
- 1
Click Add filter and choose Status. It opens as a checkbox list, not a single dropdown, because you often want more than one stage at once.
- 2
Tick In Progress, and the table narrows live to just those projects.

- 3
Tick Not Started as well. Both stay selected and the rows update again, an option-list filter matches any ticked value, not only the last one you picked.
Status behaves like an "or", not an "and": ticking both In Progress and Not Started shows projects at either stage, not only ones that are somehow both. Each additional tick widens what qualifies, it's the filter itself, Status equals one of these, that narrows the whole report.
A number filter pairs a condition with a value
- 1
Click Add filter again and choose Fee. Its panel keeps a condition and a number together in one place.
- 2
The condition starts at greater than. Enter zero, and the report narrows to projects that have posted any revenue at all.

Fee greater than zero is a small, deliberate example, but the same panel works for a real threshold too: greater than a target figure to find the projects actually worth reviewing, or less than one to catch the ones falling short.
A date filter uses the one date-range control, everywhere
- 1
Click Add filter once more and choose Start date. Every date filter throughout Monument, report filters included, opens the same date-range control.
- 2
Open the range to see fixed dates, relative bounds, and live presets together, then choose This Month.

- 3
Click Apply. The filter chip now reads This Month instead of two fixed dates.
This Month isn't frozen the day you pick it. Monument resolves a preset like this fresh every time the report runs, so reopening this same report next month shows next month's window automatically, not the calendar page you happened to be on when you filtered it.
Presets and relative bounds keep a filter current on purpose. When a report genuinely needs a window that shouldn't move, an end-of-quarter snapshot compared against a fixed prior period, say, the same control lets you pick or type exact calendar dates instead.
Filter the amounts inside one column
Open a financial column's header menu and choose Edit column. The family panel offers filters for that column's source records. A column filter changes what the column adds up. The report filters above still choose which rows appear.
Actual expenses can filter by Expense type, such as Supplier invoice, Staff claim, or Direct cost. Team member means the person who claimed the expense. Upcoming and Projected expenses offer only filters shared by their sources; planned items and purchase orders do not have an Actual Expense type.
Revenue type filters use the linked revenue source. On an invoice with several tags, only the matching source amounts count. A payment follows that same share of the invoice. Manual amounts with no linked source stay untagged.
For revenue by Team member or Role, linked time identifies the person and the role recorded on that entry. A fixed fee linked to time is shared by the entries' charge-out values, using the same rule as milestone invoicing. If every charge-out value is zero, the shares use logged hours. The shares add back up to the full fee. A fee without linked time stays unassigned.
Effective hourly rate and Recoverability use the hours linked to issued invoices. A partly invoiced entry contributes only its invoiced hours. When imported billing has missing links, Recoverability also shows how much of the full billing the matching linked share covers. A column filter does not hide the unknown historical amounts from that coverage comparison.
Purchase-order commitments use tags from the linked planned expense. Monument subtracts all linked Actual expenses before filtering the amount still committed. An unlinked purchase-order line stays untagged.
Margin, multiplier, and recovery filters apply to all the parts needed for that figure. Their totals are recalculated from the filtered amounts, rather than averaging each row's percentage. The panel only offers filters that those parts support. WIP follows the report's period or the column's own date range, and does not offer these optional column filters.
Remove one filter without disturbing the rest
- 1
Remove Fee with the cross on its chip. The filter disappears while Status and Start date stay exactly as they were.
Filters don't depend on each other. Removing one only removes that one condition, whatever row set the remaining filters already narrowed to stays narrowed the same way.
Every filter you can see, you can change
- 1
Click the Status chip. It opens again with your ticks, ready to change. Every filter shown on a report is a live, editable condition, never a locked scope hiding in the background.
If a report seems to be missing rows you expected, the filter explaining that is always visible as a chip you can open, adjust, or remove, there's no hidden structural filter working against you that the interface doesn't show. And whatever filters are still on the report when you save it save along with it, so the same narrowed view reopens exactly as you left it.
- 1
Click Save in the toolbar. The overwrite summary lists the filters you added and removed. Click Overwrite, and the report opens with these filters next time.
Troubleshooting
- Status won't narrow past one option. An option-list filter matches any ticked value. To narrow further, remove ticks rather than add them, or switch to a different field entirely.
- A numeric filter shows no rows. Check the condition first, greater than versus less than is an easy swap to make by accident, before assuming the underlying data is wrong.
- A date filter looks like it changed on its own. It didn't freeze; that's the point. Presets like This Month and relative bounds like Last 30 Days resolve fresh every time the report runs. Switch that side to a fixed date if you need a window that genuinely shouldn't move.
- A filter you expected to see isn't there to remove. If it's not visible as a chip, it isn't a filter you can edit or clear from this screen; check the report's row type or the route it is scoped to instead.
Where this fits next
This is reference for a step of Answer questions with reports: Building a report. You can now narrow a report to the rows that matter. To change a saved report's columns instead of its rows, see Edit a report. To build a figure none of the ready-made columns already offer, see Adding your own figures.
Related articles
Search Monument help
Search help articles and open a result.