Skip to content

Bookings by revenue type report

The Bookings by revenue type report answers one question: what did we sell each period, and how much of it is recurring? It adds up the deals won in each week, month or quarter, keeping MRR, ACV, One-time fees and Total value apart, and splits every row into new business and expansion, by owner, by source and by deal type.

Go to Reports and click Bookings by revenue type under Revenue.

The report covers the opportunities your role can view. It opens on This quarter, by month, over every deal.

Use the row of filters above the numbers:

  • The period: a preset such as This quarter or Last month, All time, or Custom range with a from and a to date. A deal counts as sold in the period its Close date falls in.
  • The deal owner: Everyone (or My team), or one person. This filter appears when your role reaches your team’s or everyone’s opportunities. People who have left are listed last, marked (inactive).
  • The pipeline: All pipelines or one pipeline. This filter appears when you have more than one.
  • The source: All sources or one source, matched to the deal’s Source.

Below the row:

  • Grain sets what each row of the first table is: a Week, a Month or a Quarter. Weeks start on the day set under Settings > Company, the same day the dashboards and quotas use.
  • Deal type: All, Recurring or Fixed, matched to the deal’s Deal type, so recurring contracts and fixed projects can be read apart.
  • Business: All, New business or Expansion. With one picked, every figure on the page is that kind of deal only.

The dates the period covers are shown at the right of the filters. Your filters, the grain, the deal type and the business kind are kept in the page address, so a bookmark opens the same view.

Click any count or amount to open the deals it counts, with Company, Owner, Stage, MRR, One-time fees, Total value and Close date. The list’s total matches the figure you clicked. A figure with no deals behind it is plain text. Click a deal to open it, or Bookings by revenue type in the trail at the top to go back to the report.

The report reads these fields from each won opportunity:

  • MRR: monthly recurring revenue on a recurring deal.
  • ACV: annual contract value. If you don’t enter one, Gabriel sets it to MRR times 12.
  • One-time fees: setup, project or hardware revenue billed once.
  • Total value (TCV): the deal’s Value. On a recurring deal left blank, it’s MRR times the contract term plus one-time fees. A recurring deal with no contract term and no typed value has a total of 0: it still counts its MRR and ACV, so the Value column can read lower than the MRR column suggests.
Figure What it is
Bookings The Total value of the deals won in the period. Under the amount, how many deals, and how many were new business and expansion
MRR sold The MRR on the deals won in the period, per month
ACV sold The ACV on the deals won in the period
One-time fees The One-time fees on the deals won in the period

A won deal is new business when it is the company’s first win in Gabriel: the won deal at that company with the earliest close date, whoever owned it and whichever pipeline or deal type it was in. Every later win at that company is expansion. Two wins at one company on the same day are told apart in a fixed order, so they always split the same way.

The first win may be outside the period. A company first won last year and won again this quarter is an expansion this quarter, even with the period on This quarter. This is the rule the Owner dashboard’s New vs expansion card uses, so the two agree.

The table shows each kind with its deal count and every amount. Click a figure to open that kind’s deals.

One row per bucket of the grain you chose, with buckets that sold nothing kept so a quiet week is visible. Each row shows the deals closed in the bucket, the amount chosen with the Amount control, and how many of the deals were New business and how many Expansion. Click the count or amount to open the row’s deals, or the New or Expansion count to open only those.

  • Under a period, the rows are the buckets the period touches. A bucket the period starts or ends part way through is still one row, labelled by the days it covers, such as Oct 1–4, 2026 for a quarter that starts on a Thursday. A period touching more buckets than the table lists shows the latest ones, with one row Before the first of them holding the earlier part of the period, so the columns still add up to the totals. The line above the table says how many are listed. Choose a shorter period, or a larger grain, to see them apart.
  • Under All time, the rows are the current bucket and the ones before it, with a row Before them for earlier deals and a row After them for deals dated later than the current bucket. A close date can be edited, and an import can bring one in the future, so After is where to look when the rows add up to less than the totals.

The Amount control above the tables swaps the money column between Value, MRR, ACV and One-time. The counts stay the same.

One row per owner with a won deal in the period, most deals first. Deals with no owner are last, as Unassigned. A rep whose deals are all expansion is farming the base; one whose deals are all new business is hunting.

One row per source that one of those deals names, most deals first. Deals with no source are last, as No source. Compare which sources bring new logos and which bring expansion.

Two rows, Recurring and Fixed, both kept even when one sold nothing. With the Deal type filter on one of them, the other row reads as zeros.

A won deal with no close date falls in no period and no bucket. Under every period a line below the tables says how many won deals have none, with their total value; click the count to open them and set their dates. Under All time they are in the headline numbers and in the owner, source and deal type tables, as expansion (there is no date to be a first win by), but still in no row of the first table. For the same reason the line follows the Business filter: with New business picked there are none to report, and with Expansion picked they are all listed.

  • A deal is won by its stage’s Outcome (Won), set under Settings > Pipeline & Sales Stages. The stage name doesn’t matter. It is dated by its Close date, which Gabriel sets to the day the deal is marked won. The MSP revenue and Win/loss reports and the dashboards date won deals the same way, so they agree.
  • The first win of a company is looked up across every won deal in your company’s Gabriel, not only the deals your role can see or the ones the filters keep. A deal can be an expansion because of a first win you cannot open.
  • A period and a bucket are whole days in your own time zone, or your company’s if you haven’t set one. This month, This quarter and This year run to the end of the period.
  • Amounts are shown rounded, such as $12.5K.
  • Read MRR sold by month, not by quarter. The recurring base grows a little every month; a quarter hides which month the push landed in.
  • Watch the new business share. Expansion is cheaper to win but needs a base to sell into. A quarter of expansion only means the base is not growing.
  • Enter MRR on every recurring deal. A recurring deal without MRR adds nothing to MRR sold or ACV sold, and with no typed value adds nothing to Bookings either.
  • Put setup and hardware in One-time fees, not MRR. Mixing a one-time charge into MRR overstates the recurring base for every month after.
  • Keep close dates on won deals. A won deal with no date is in no bucket and no period but All time. Check the line below the tables and clear it.
  • Keep one company per customer. A customer entered as two companies is “new” twice. Merge duplicates so expansion reads as expansion.

The report says no deals were won in this period. Nothing was won in the period with these filters. Set the period to All time and clear the other filters, including the deal type and business kind below the row.

A deal I expected as new business is an expansion. Its company has an earlier won deal, perhaps outside the period, in another pipeline, of another deal type, or owned by someone else. Open the company’s opportunities to find it. If the company is a duplicate, merge it.

Bookings is lower than MRR sold suggests. A recurring deal with no contract term and no typed value has a total of 0. Set the contract term or the value on the deal.

The rows add up to less than the totals. Under All time, look at the Before and After rows: deals dated earlier or later than the listed buckets are there. Under a long period, the Before row holds the earlier part of the period. Won deals with no close date are in no row; see the line below the tables.

The dashboard’s New vs expansion card shows different numbers. The card covers the quarter or year and the deals the Owner board counts; the report covers the period and filters you chose. With the same period and no filters, the split is the same.