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
Building a report
Answer a real business question with a saved table: pick a row type, add calculation columns, invent your own with formulas, group for subtotals, and sort, then save it so the answer is one click away next time.
What you'll achieve
Turn a business question into a saved, reusable table grouped and sorted exactly how you need it.
You'll end up with: A saved Project Margins report with an expenses column added, grouped by status with subtotals and sorted by Planned expenses.
The monthly report answers a general question, your report answers your question
The Monthly practice report tells you the firm's health in broad strokes. What it can't do is tell you which specific projects are actually profitable and what stage they're at, that's a narrower question, and it needs a table built to answer exactly it. The good news is that every report in Monument, no matter how specific the question, is built from the same five decisions in the same order. Learn that shape once and you can build any report there is.
Every principal at Meridian Studio eventually asks how are the commissions actually performing. This tutorial builds the answer as a Project Margins report, revenue against expenses, grouped by status and sorted by expense budget, then saves it so nobody has to rebuild it next month.
Five decisions, made in order, every single time
- Row type: what are the rows? Projects, invoices, time entries, expenses, contacts. This is the first and biggest choice, because it decides what one row of the table even means.
- Columns: what do you want to see about each row? A new report starts with sensible columns already in place, you add what your question needs and hide the rest.
- Filters: which rows actually belong? Narrow by a row's properties, status, client, dates, total revenue, total hours. A date filter can stay live instead of freezing, Last 30 Days keeps meaning the last 30 days forever, see Dynamic dates that never go stale.
- Grouping: how should rows bundle together? Grouping collapses rows into bands and gives each one a subtotal, arguably the single most useful thing a report does.
- Sort: what order matters? So the rows you actually care about sit at the top instead of buried in the middle.
Nail these five and the table answers the question by itself. Everything past this point is refinement.
Pick the row type first, because it decides everything downstream
You choose the row type on the New report page, before the report opens. You can start from an existing report and keep its row type and columns, or start from nothing and choose the row type yourself.
- 1
Open All reports and click New report. Under Start from, choose A copy of a report, then choose Project performance as the report to copy.
- 2
Type a Name, choose who it is Shared with, and click Create report. Each row is now one of Meridian Studio's commissions, with Actual profit and Actual margin already showing.

To start from a blank table instead, choose Nothing under Start from, then choose Projects under Reports on. Monument saves the report when you click Create report, and you find it again in the Reports menu: hover Reports on the rail.
A copy of Project performance doesn't open empty. Actual profit, revenue minus cost, and Actual margin, profit as a percentage of revenue, are already in the table. You're not adding them, they're simply the starting point the copied report gives you.
Profit tells you the dollar amount; margin tells you whether that amount is actually healthy. A project can post a solidly positive profit and still be a bad job if its margin sits far below what your studio targets, a big project with a thin margin can look better on the profit line than it deserves to.
The Add Column window groups columns by what they are about
Our question wants the expense budget made explicit, so add a Planned expenses column. Click + at the end of the table's header to open the Add column window. It opens ready to add Hours, with its recipe and a live preview of this report's rows, so the most common column is one click away.
To add something else, open the Preset list. Every column the report can show is there once, under one group, with a line that says what it is. The groups come in this order: Hours, Time value, Revenue & billing, Expenses, Profit, Dates, People, Details, Custom fields, Existing columns and Custom formulas. Hours is time in hours. Time value is hours × a rate, in dollars: Charge-out value, Cost value, Labour value, Hours × chosen rate and the rates themselves. So Charge-out value is under Time value, not under Hours or Revenue & billing. Revenue & billing is fees, invoices and payments. Expenses is what the work costs. Profit compares the two. New formula and New time series sit at the bottom of the list, whatever you search for.
Search looks through every group at once. On a time report, type "charge" and you see Charge-out rate and Charge-out value under Time value, and Charge-out over cost under Profit. Type "remaining hours" and choose Hours to open it on Remaining.
For an hours or currency figure, choose the variant under the Preset: Actual, Upcoming, Projected, Planned or Remaining. Every measure shows all five variants. A variant that this report type doesn't offer shows greyed with the reason; a time entry's own Hours, for example, is Actual hours, and the other variants say why they are greyed. Multiplier has all five too: each is that variant's net revenue ÷ its labour value, and the future ones leave out the sub-consultant and reimbursable fee lines. Every figure shows its recipe, so you can change its parts, filters, rate, date range or period split. For a plain field, such as a date, a person or a status, you only check its Name. Then click Add column.
The Preset list is wide enough to read each name, and you can type in it to search. Every choice in it has an info mark (?). A measure with variants, such as Profit, says what the measure is ("Revenue minus expenses."); hover over a variant button (Actual, Upcoming and so on) to see that variant's own definition. A measure with no variants shows its definition in its info mark. You can pick any measure whatever variant is selected: if the measure doesn't have that variant, it moves to one it has and a line under the variants says so, for example "Margin has no Planned variant, so it shows Actual." A measure with no variants shows its recipe under its name in the Preset list: the pieces it is made of. WIP hours, for example, reads Actual hours · Billable · Not invoiced. A variant shows its recipe once you pick it: Hours, Remaining reads Planned hours − Actual hours. Every variant of a measure has the same shape: Projected is Actual + Upcoming, Remaining is Planned − Actual, every Profit is its Revenue − its Expenses and every Margin is its Profit ÷ its Revenue. Under the list, one sentence says what the column shows, and the Recipe: line adds each setting you change, such as a part, a part filter, a rate, a date range or a period split. Both update as you change the settings.
A Preview at the bottom of the panel shows the first five rows of your report with the new column, plus the total for every row. It uses the report's own filters and your own access, so it shows exactly what the column will show you. If you don't have access to a figure, the preview says so instead of showing numbers.
Search still finds individual choices. Search for WIP to find WIP hours in Hours, and WIP value and WIP expenses in Revenue. Choosing a matching family opens its panel with that choice selected. WIP covers billable work not yet billed. It counts the work dated inside the report's period, or inside the date range you choose for the column. A range counts at most the twelve months before its end, and All time counts the six months ending today.
Currency and hours figures always use the same five words, so a column's name tells you what it counts:
- Actual: what has already happened, such as Actual hours or Actual expenses.
- Upcoming: what is still to come, such as Upcoming revenue.
- Projected: actual plus upcoming.
- Planned: the budget set on the schedule, such as Planned hours or Planned expenses.
- Remaining: planned minus actual, such as Remaining hours or Remaining profit.
For figures that support a date range, the panel lets you choose the dates to count. Turn on Split into periods to show one column per month, quarter or year: see Time-series columns and exporting. Settings only appear when they apply to your chosen figure. Planned and Remaining expenses and WIP support dates and periods; salaries and rate settings do not. Planned cost value, Planned charge-out value and Planned labour value always cover the whole plan, past and future, so they have no date range.
On a Leave requests report, Leave hours shows the duration of each leave request. It has no column date range or Split into periods setting. Use the report's date filters to choose which leave requests appear in the rows. Hours per day is a separate value.
Names describe the kind of record you are reading. Actual hours is logged time. Leave hours is leave duration. Working hours on a Work patterns report is the configured working time, not logged work. Holiday records use Holiday, and an expense's text uses Description.
Every column has a small ? beside its name. Click it to see where the values come from. A standard figure, such as Actual profit or Projected hours, shows how it is worked out, for example Projected hours = Actual hours + Upcoming hours, with a sentence on what it shows. A column built on other columns names them: Actual / Planned hours reads Actual hours ÷ Planned hours. A plain field, such as a project's name, says it comes straight from the record. Actual revenue and profit follow your practice's How we measure profit setting, so the text changes when that setting changes. A column you gave its own recipe, such as Projected hours without variation time, or a Profit that takes Invoiced instead of Actual revenue, shows Customised under its name, and its ? shows that recipe. Only that column in that report changes. Every other report and screen keeps the standard definition.
To change an existing column, open its header menu and choose Edit column. The same panel opens with its current settings, with the column's Name at the top. Other columns that refer to it keep working. Renaming a column also keeps those references working. A plain field column has no panel, so Edit column asks only for its name.
- 1
Open Add Column and choose Expenses under the Expenses group. Read its five versions: Actual is spent so far, Upcoming is still to come, Projected is the two together, Planned is the budget, and Remaining is the budget still left. Choose Planned, then click Add column.
- 2
The table now reads project, status, revenue, expenses, profit, margin, everything this question needs sitting on one row.
A column is built from lines
Every figure in the panel is a recipe: a few lines joined by +, −, × and ÷. When you pick a figure, the panel lists its recipe under Recipe, one line per piece, so you can see how the number is built. For example:
- Projected hours = Actual hours + Upcoming hours.
- Cost value = Actual hours × Each person's cost rate.
- Charge-out value = Billable hours × Each person's charge-out rate.
- Actual profit = Actual revenue − Actual expenses.
- Planned profit = Planned revenue − Planned expenses.
- Actual margin = Actual profit ÷ Actual revenue.
- Work done = Actual hours ÷ Planned hours.
A figure that adds nothing up from other figures, such as Actual hours, has one line: itself.
A line can be a figure that is itself built from lines, such as Cost value among other lines, or Actual profit in Actual margin. That line shows the figure's name. Click How it's built under it to see the figure's own recipe, for example Actual hours × Each person's cost rate. Click Edit its lines to change it:
- For hours valued at a rate, such as Cost value, the line opens as its hours line and its rate line. It is still the same figure, so the column stays standard.
- For a figure built from other figures, such as Actual profit in a margin, its lines go into brackets in its place. Each line that can take the named line's filters keeps them. The column is then Customised.
If you change nothing, the column is the standard figure. It shows exactly the same number as that figure anywhere else in Monument. Picking a figure and clicking Add column is still all it takes.
Each line has these controls:
- Operator: + adds the line, − takes it away, × multiplies and ÷ divides. You can pick any of the four on any line, at any time. If the line's column doesn't fit the new operator, the line switches to the nearest column that fits, and a note under the line says what changed. For example, × after an hours line turns the line into a rate on those hours. If no column fits, the recipe says why under the lines, and Add column stays greyed.
- Column: the figure the line counts. It can be any column, including margins, multipliers and Effective hourly rate, or a rate (see below). The list is wide enough to read each name, and you can type in it to search. Every choice has an info mark (?) with its definition.
- ?: every line has an info mark that says what the line is. That is true for a column line, a rate line, a fixed number and a bracket box.
- Filters: narrow what this line adds up.
- ↑ and ↓: move the line up or down. The operators stay where they are.
- × at the end of the line: remove it. A recipe always keeps at least one line.
Below the lines:
- Add column adds another line. Choose what it counts in its Column list, then its operator.
- Add number adds a fixed number, such as × 1.1, ÷ 38 or − 500.
Lines in brackets, ( … ), are worked out first. They show in a dashed bracket box. To put lines in brackets:
- Tick the box at the start of each line you want to group. A bracket box has its own tick box on its top row.
- Click Group lines under the lines. It stays greyed until two or more lines are ticked. Clear ticks takes all the ticks away.
The ticks clear after you group. A few rules decide what goes in the brackets:
- The brackets take in every line between your first and last tick. Tick lines 1 and 3, and lines 1 to 3 go in brackets.
- Ticks inside a bracket box make brackets inside that box, as many levels deep as you need.
- If your ticks reach into a bracket box from outside it, the new brackets hold the whole box. A note under the lines says so.
- The operator before your first ticked line stays in front of the brackets, as on paper. In A − B + C, tick B and C to get A − (B + C).
Click Ungroup on a bracket box to take the brackets away and keep their lines. While a bracket box is selected (you clicked or tabbed into it), Add column puts new lines inside it. Click Add outside the brackets to add lines after it instead.
The usual order applies: brackets first, then × and ÷, then + and −.
Some figures follow a rule their lines can't show. The rule is one plain line under the line it belongs to:
- Charge-out value at each person's charge-out rate values billable time only, and time with a saved billing amount keeps that amount.
- WIP shows as the hours, charge-out value or expenses it narrows, with the fixed filters Billable: Yes · Invoiced: No. It also leaves out time marked as billed or written off, so its filters can't change.
- A planned figure in a date range counts only its share of the range.
- Projected charge-out value and Break-even multiplier stay one line, because they are worked out together on the server.
- Effective hourly rate and Recoverability stay one line. They divide the invoiced amount by the hours, or by those hours' charge-out value, on the same invoices.
What a recipe shows in
The column's format follows its lines:
- Hours plus or minus hours is hours. An amount plus or minus an amount is an amount.
- Hours divided by hours, or an amount by an amount, is a percentage.
- An amount divided by hours is a rate per hour, shown as currency.
- Multiplying or dividing by a fixed number keeps the unit. A number you add or take away counts in the unit of the other side.
- Hours multiplied by a rate is an amount. Effective hourly rate is a rate per hour too, so hours × Effective hourly rate is an amount.
- An amount divided by a rate per hour is hours.
- A margin is a percentage. Multiplying by a percentage keeps the other side's unit, so Planned revenue × Planned margin is an amount.
- A multiplier counts as a plain number, like a fixed number.
A recipe that makes no sense, such as hours plus an amount or hours times hours, says why under the lines, and Add column stays greyed.
Totals and subtotals work the recipe out from its lines' totals. They never add up or average the row results. A division by zero shows a blank.
A rate is its own line
A currency figure made of hours, picked on its own, shows as two lines: the hours, then × a rate. The hours line keeps its own filters, such as Billable. The rate line offers Each person's cost rate, Each person's charge-out rate, and each of your studio's rate types. A rate type you can't use is greyed.
- Actual hours × Each person's cost rate is Cost value.
- Actual hours × Each person's charge-out rate is Charge-out value. It counts billable time, and time with a saved billing amount keeps that amount.
- Actual hours × one of your studio's rate types values the logged hours at that rate.
- Upcoming hours × Each person's cost rate or × Each person's charge-out rate is Upcoming cost value or Upcoming charge-out value.
- Upcoming hours × one of your studio's rate types values each allocation's upcoming hours, from today on, at that rate. An allocation for a pool, not a person, uses the pool's amount for that rate type.
To value hours, add a line after them and choose a rate in its Column list, under Rates. The rate joins the hours line before it with ×. After a bracket box of hours, such as (Actual hours + Upcoming hours), the rate values every line in the box. A rate anywhere else is refused, with a plain message on the line. The × on a rate line removes the rate: the line counts hours again. Pick another operator on a rate line and the rate goes: the hours line counts hours again, and a new line follows it with that operator.
Each time entry or allocation is valued at its own rate, after the hours line's filters. It is never total hours times one rate. A pairing that is another figure, such as Cost value, gives exactly that figure's number. So you can, for example, add a Billable filter to Actual hours and then value those hours at your Senior rate.
Currency figures always count all time. If your practice leaves some time out of Actual hours or Upcoming hours (Settings → Definitions), the line says so. Only Cost value can follow that setting, when Also leave it out of cost and profit is ticked.
Filters change one line only
Click Filters on a line, then Add filter. A line's filter narrows the records that one line adds up. The other lines still count everything. Report filters still choose which rows appear.
Each line offers the filters its records carry. Logged hours, for example, offer Billable, Approval status, Tags, Task tags, Team member, Role, Entity and Task type. Filters a line can't use are still listed, greyed, with a short reason. Upcoming hours can't take an Invoiced filter, for example, because hours that are not logged yet are never invoiced.
Tags and Task tags filters say has any of or has none of. Task tags are the tags on the task the time or expense was recorded against. Use has none of to leave work out of a figure. For example, tag your variation tasks Variation. Then add a Task tags filter, has none of Variation, to the Actual hours line of Projected hours. The column counts the contracted work and leaves the variation time out. Upcoming hours still counts in full.
A line can also have its own Date range: choose Date range in its Add filter list. Without one, the line follows the column's date range. Click the × beside the line's range to follow the column's range again. An Upcoming line's own range must include today or a later date.
Some lines have a fixed definition and take no filters. Their Filters button is greyed, and a sentence under the line says why. WIP follows the billing rules, Planned revenue and Hours target come from numbers set on the project, and invoice figures come from the invoice the report runs for.
Customised and Back to standard
As soon as the recipe differs from the standard, Customised appears beside Recipe. Back to standard puts the standard lines back. The Recipe: sentence spells out the lines and their filters, for example Actual hours (Task tags: not Variation) + Upcoming hours.
The added column shows Customised under its name, and its ? shows its own recipe. Only that column in that report changes. A customised column keeps the figure's name, such as Projected hours, until you type your own. Give it a name that says what is different, such as Projected hours without variations.
If your lines add up to another figure's standard recipe, the panel switches to that figure. Actual expenses plus Upcoming expenses is Projected expenses, so the panel saves the standard Projected expenses column.
A figure that divides, such as Work done, shows its second line with ÷. Work done divides Actual hours by Planned hours. Change the line after ÷ to Hours target to measure the work done against the hours target instead.
Add column stays greyed while a line's filter has no value. A figure your access doesn't cover is greyed in Column, and a recipe can't use it. A column needs access to every line in its recipe. A recipe that divides by a line, multiplies two lines, or has a line with no periods can't be split into periods. Recipes that only add, take away, or multiply or divide by fixed numbers can.
Add your team's time to expenses
The Expenses panel also holds Cost value, Labour value, Planned cost and Reimbursable expenses (sub-consultant and reimbursable costs billed back to the client). Searching for these figures opens Expenses with the matching choice selected. Salary, Salary period and Cost rate are plain settings under Details on the report types that offer them. Your saved columns keep their current calculation and settings.
The default is Actual expenses: one line. Actual expenses already include your team's time at each person's cost rate (Cost value), plus the expenses recorded against the work. Upcoming, Projected and Planned expenses include team time at cost the same way, so every variant of Expenses counts it once. To count more, add columns to the recipe:
- Upcoming expenses: upcoming time at the cost rate, planned expenses still to come, and what is left on open purchase orders. Actual and Upcoming expenses together are Projected expenses. Both always include costs you pass on to the client, such as sub-consultants and reimbursables.
- Actual labour value: logged hours valued at the salary-based labour rate.
- Charge-out value: logged billable hours valued at each person's charge-out rate. It needs access to revenue.
- Hours × chosen rate or Allocated hours × chosen rate: hours valued at one of your studio's rate types. Choose the rate type on its rate line. The column is then named, for example, Actual hours × Senior.
If you add Cost value to Actual expenses, the line says the recipe counts that time twice, because Actual expenses already hold it. The column keeps the name Actual expenses until you type your own.
When you swap a line for another figure, it keeps the filters the new figure can use and drops the rest.
Cost value starts with Each person's cost rate, the rate saved on each time entry. Choose one of your studio's rate types on its rate line to value the same logged hours at that rate instead. A Cost value column on its own is then named, for example, Cost value · Senior. Rate types you don't have access to are greyed out.
With the built-in rates, Actual uses recorded time values, Upcoming uses upcoming allocations, and Projected adds those two lines. Labour value uses the person's salary-based labour value, with the existing role or studio average where needed. Profit, margin and multiplier columns keep their own calculations; changing this column does not change those figures.
For a studio rate type, Hours × chosen rate values logged hours at the selected rate in force on each entry's date. Allocated hours × chosen rate values allocated hours across the working days in their date range, using each day's selected rate. Allocated time can include past days: it is not the same as Upcoming time. These choices only appear on report types that support their source records.
Reimbursable expenses remain a separate choice. They are part of recorded expenses, so selecting them does not add them a second time to all expenses. Settings under Details are plain fields and have no lines. A combined amount needs access to every line it includes. Choices you cannot use stay disabled.
On Quote reports, Quote is the title and Quote number is the document number. Saved column names stay as you set them.
Revenue includes what you bill and what you receive
Revenue holds the currency choices that were in Billing: Charge-out value, WIP value, WIP expenses, Invoiced, Paid, Planned revenue, Fee burn and Fee left to invoice. Invoice totals, Amount paid, Balance due and expense Billable amount or Billed amount also live here on the report types that support them. Their calculations do not change when you choose them from Revenue.
WIP expenses is the expense amount still available to bill, including any markup. It remains separate from Actual expenses, which adds up cost. A $100 expense with 20% markup can show $120 in WIP expenses and $100 in Actual expenses.
A rate line appears only on supported time-entry or allocation sources. Charge-out value shows as Actual hours × a rate. Keep Each person's charge-out rate to use the existing figure: billable time at each entry's saved rate. Time with a saved billing amount keeps that amount, and non-billable time counts nothing.
Choosing one of your studio's charge-out rate types values logged hours at that rate on each entry's date, one entry at a time. A chosen rate values the hours the hours line's filters allow. The hours line starts with the Billable filter when you choose a rate, so it still counts billable time only. Remove that filter to value every logged hour, billable or not: the recipe then reads All hours × [Rate]. Columns saved before this change value every logged hour, so they reopen as All hours and keep their numbers. This also works on a time-entry report's Charge-out value column. Allocated charge-out value requires a studio rate type. It reads Allocated hours × [Rate] and values allocated hours on each working day in the selected range, including past days. It is a separate choice from Upcoming charge-out value and has no recorded-amount option. These choices do not change your Actual revenue, Invoiced or Paid calculations.
Billing settings and statuses are plain fields under Details. Look there for Billable, Invoiced yes/no, Payment, Overdue, Marked billed, Revenue type, Markup, Charge-out rate, billing addresses and payment terms. Charge-out rate is a rate setting; Charge-out value is the amount that time is worth.
Details also holds Rate amount and Hours per period on Rates, Allocation % and Progress on Resource allocations, and Invoice amount and Invoice percentage on Milestones. These describe settings on the record. Effective hourly rate and Recoverability stay with the Revenue figures they describe. Projected cash stays in Profit because its forecast combines revenue and costs.
Choose which revenue and expenses make your profit
Profit and Margin are recipes like every other figure, and every variant has the same shape. Actual profit opens as Actual revenue − Actual expenses; Actual expenses already hold your team's time at cost. Projected profit is Projected revenue − Projected expenses, and Planned profit is Planned revenue − Planned expenses. Actual margin opens as two lines: Actual profit ÷ Actual revenue; Projected margin is Projected profit ÷ Projected revenue, and Planned margin is Planned profit ÷ Planned revenue. Upcoming profit is Upcoming revenue − Upcoming expenses (Projected profit − Actual profit when your practice has changed either of those on Settings → Definitions), and Remaining profit is Planned profit − Actual profit. Upcoming margin and Remaining margin divide their profit by their revenue: Remaining margin is (Planned profit − Actual profit) ÷ (Planned revenue − Actual revenue). If your practice leaves billable expenses out of profit, the expense line says so in a line under it. Leave the lines as they are and the column stays exactly as it was.
Change any line to work profit out the way your studio does. For example, change Actual revenue to Invoiced to see invoiced revenue minus actual expenses. To change the profit inside a margin, click How it's built under Actual profit, then Edit its lines: its lines go into brackets in its place. Or pick another line in its Column list. Change the revenue after ÷ too. Any column can be picked as a line in a column's recipe, including a profit, a margin or a multiplier. Profit always takes time off at a cost rate: on a line taken off, each person's charge-out rate and charge-out rate types are greyed, and salaries (labour value) are greyed in Column, each with the reason.
A custom Margin is worked out again from the totals of its lines, so the total row is never an average of row margins. A custom Margin can't be split into periods. A custom column needs access to every line. Achieved multiplier opens as Actual net revenue ÷ Actual labour value, and Reimbursable recovery as Reimbursable revenue ÷ Reimbursable expenses. Profit and Margin columns saved before this change reopen as their lines and keep their numbers. A margin saved with its profit spelled out and left unchanged reopens as Actual profit ÷ Actual revenue.
Settings → Definitions uses the same lines, but a practice definition only adds and takes off. There × and ÷ show greyed, with the reason.
To use another column on the report instead, write a custom formula, as the next section explains.
When the number you need isn't in any menu, write it
Choose New formula under Custom formulas to build a formula from lines in the same builder Add Column uses, with this report's own columns as lines too, or switch to Free-form and type it with column names in curly braces, something like {Fee} - {Planned expenses}. The result becomes a real column: sortable and recalculating live like the other calculated columns on the table. New time series opens the advanced period setup from the same section.
The editor is built to keep you from guessing wrong. Live validation flags a mistyped column reference the moment you type it, not after you've saved and moved on. Format inference figures out that dividing a currency by a currency should probably be a percentage, without you telling it so. A Progress output type turns a numerator-and-denominator formula into an actual progress bar per row, ideal for something like how much of the budget is spent. And because a custom column isn't trapped in the report that created it, once built it shows up in Custom formulas for every report on that row type, so the studio defines its version of margin exactly once instead of arguing about six almost-matching spreadsheets.
Template columns answer the questions everyone asks. Custom columns answer the question that's specific to how your firm actually measures a job, fee net of subconsultants, spend against approved budget shown as a bar, whatever it is. Build it once as a column and it's available to drop into any report from then on.
Grouping is where the story actually shows up
A flat list of projects is useful. A grouped one tells you something. Group by Status and the report bundles projects into bands, on hold, in progress, complete, and gives each band its own subtotal, so you can see immediately whether the thin margins are concentrated somewhere you can still fix them (in progress) or already locked in (complete).
- 1
Click Group in the report heading, then Add group, and choose Status.
- 2
Read the subtotal on each status band: revenue, expenses, and profit now add up per group, not just per project.

The subtotal per band is the actual payoff of grouping. A spreadsheet makes you write those sums and hope you update them correctly as data changes; a grouped report just keeps them correct. Group by status today, regroup by client tomorrow, same underlying data, a completely different question answered, and nothing to rewrite.
Sort, then save it so the answer sticks around
- 1
Click Sort in the report heading, then Add sort column, and choose Planned expenses. The smallest expense budgets now lead each status group.
- 2
Open Actions and choose Save as new report. Name it Project Margins, choose who it is Shared with, and click Save.
- 3
Open Actions and hover Export CSV. Choose Status for one row per status with its subtotals, or Projects for every project.
Saving surfaces one decision worth pausing on: Shared with. Everyone lets the whole studio open the report; choose people or groups to share it with fewer. The saved report is listed in the Reports menu (hover Reports on the rail) and recalculates against live data every time it opens. To keep later changes on the same report, use Save in the toolbar instead.
A report can grow into more than one block
Everything so far builds one table. A report doesn't have to stop there: add a chart or a stat tile next to it and the report becomes a small ordered stack of blocks instead of a single table, each block still built from the same five decisions, just with its own row type, columns, and filters.
- 1
From the report's Actions menu, click Add chart for a quick chart alongside the current table, or open Add block and choose Table, Chart, or Stat to add one explicitly.
- 2
The report converts from one table into a small stack of blocks: the original table becomes the first block, and the new one appears below it.
- 3
Click Add block again to keep stacking blocks: a stat tile summarising this month's totals, a chart trending them, a second table drilling into the detail behind either one.
Every block picks its own row type independently, so a report isn't locked to Projects just because its first block is. A stat tile pulling hours from time entries can sit right above a table listing invoices, one saved report answering a question that used to need two or three separate ones.
A brand-new report always starts as the classic single-table shape this whole article teaches. Blocks are something you add on top once one table alone stops answering the question, not something every report has to build up front.
When a block says "Unavailable"
Blocks respect the same permissions as everything else in Monument. If you save a report with a financial stat tile and share it with someone who can't see financial data, they still see the report, they just see that block replaced with Unavailable in the exact spot it would otherwise sit. The rest of the report renders normally around it, nothing shifts to fill the gap, and there's no way to peek at what an Unavailable block would have shown.
Troubleshooting
- The row type decides everything downstream, so get it right first. You can't add a column the row type doesn't have. If a figure you want isn't offered anywhere in the menu, you likely picked the wrong rows, time entries instead of projects, say.
- Don't go hunting the Add Column menu for Profit and Margin. On a projects report they're already template columns sitting in the table the moment it opens. The menu is only for what isn't there yet.
- A formula column can't be filtered on. Filters work against a project's actual properties, status, client, dates, total revenue, total hours, never against a calculated column like Margin. To surface the loss-makers instead, sort by Margin, worst-first reads the same and needs no filter at all.
- A free-form formula references columns by exact name.
{Fee}has to match the column it's pointing at exactly; use Insert column, or build the formula in the builder, rather than typing names by hand. - A saved report is the question, not a snapshot of an answer. Reopen it next month and it re-runs against whatever the current numbers are, so last month's profitability report will show this month's figures. That's the point, not a bug to work around.
- When a report is grouped, read the subtotals, not the individual rows. The band subtotal is the headline number; scanning row by row misses the story the grouping was built to tell.
- Export one row per group. In Actions, hover Export CSV or Download PDF. Each grouping level, such as Status, gives one row per group with its subtotals. The last entry, such as Projects, gives every row.
Where this fits next
This is step 2 of Answer questions with reports. To narrow a report's rows, see Filter a report; to change a saved report's columns, see Edit a report. Next, add your own figures and trends.
Search Monument help
Search help articles and open a result.