Reporting and Finance
ROI and Finance Snapshot
Forge gives you several financial views of an event. Some show money in (revenue, collected cash, refunds, what is still owed); one adds money out (budget and expenses) to give you return on investment. This page explains each view, what it counts and which one to trust for which question.
Use Finance > Transactions and Invoices for exact money. Use the event Reports > Finance tab for a quick money-in summary, Finance > Budget & Expense to record costs, and the event ROI tab to see net result against your costs. Dashboard totals are cached summaries and can lag Salesforce until you press Refresh.
The money views below use different sources on purpose. The table shows which to use.
| Question | Open | What it is |
|---|---|---|
| How much did we bill, collect, refund and still have outstanding for this event? | Event > Reports > Finance | Four cards and a monthly table from cached order and transaction data. |
| Registrations by ticket type and revenue split, and a registrations timeline? | Event > Reports > Overview (Snapshot panel) | A snapshot built from cached Salesforce data. |
| Did the event pay for itself? | Event > ROI | Revenue minus actual spend, ROI percent, budget variance and a target. |
| What did we plan to spend and what did we actually spend? | Event > Finance > Budget & Expense | The records the ROI view reads. |
| Which pipeline did the event influence? | Event > Reports > ROI | Salesforce Opportunities; see Funnel and Pipeline. |
| Money across all events | Reports > Finance | Cross-event table and watchlist; see Dashboards. |
Event Reports > Finance
Open an event, choose Reports, then the Finance sub-tab. It has four cards and a Monthly Performance section. Press the refresh icon next to Finance Summary to re-read from Salesforce. Free events with no donations show "Finance reports require paid tickets or donations on this event."
| Card | What it counts | Recommendation |
|---|---|---|
| Revenue (with number of orders) | The larger of the total billed on the event's orders and the cash actually captured. Taking the larger value keeps revenue from reading low when payments were recorded before the orders updated. | Compare with Captured. A big gap means unpaid invoices. |
| Captured | The sum of the event's payments that are captured, paid or settled. | This is cash received. Use it for reconciliation with your gateway payouts. |
| Refunds | The sum of the event's payments marked refunded. | Review refunds in Transactions. |
| Accounts Receivable | Revenue minus Captured minus Refunds (never below zero), plus any authorized but not yet captured amount, which is shown underneath as "Authorized: amount". | Chase unpaid invoices or capture authorizations. Authorized funds that are not captured within about a week expire. |
Salesforce's own definitions behind the cards: Captured counts payments whose Payment Status is Captured, Refunds counts Refunded, and the tooltip on Accounts Receivable describes orders authorized but not yet captured. The extra revenue-minus-collected part is calculated by Forge.
| Monthly Performance | What it shows | Good to know |
|---|---|---|
| Chart | Revenue per month (colored bar) and Budget (grey bar) when a budget figure exists. | Months come from the order created date. |
| Table: Month, Revenue, Fees, Net | Revenue by month, a Fees figure and Net (Revenue minus Fees). | In the per-event view the Fees figure is not taken from your fee records and reads zero, so Net equals Revenue and no budget bars appear. Use Transactions for real processing fees, and Budget & Expense for budget. |
Snapshot panel (Registrations and Ticket Mix)
On the event Reports > Overview tab for paid events, a Snapshot panel shows when the snapshot was last synced, with Revalidate and Refresh snapshot buttons. If no snapshot exists yet it says "No snapshot yet. Refresh to generate the first summary."
| Card | What it shows | How it is calculated |
|---|---|---|
| Registrations timeline | Daily bars with a cumulative line. Events longer than 120 days show weekly totals instead and say so. | Counts registrations whose status is real (Registered, Attended, Checked In, Paid, Confirmed, Complete, Approved and similar). Canceled, Waitlisted and Pending are left out. Zero days are filled in across the event's dates. |
| Weekly registrations | A smoothed weekly trend. | Registrations grouped by calendar week. |
| Revenue by ticket type | Revenue per ticket type for paid tickets, with percent. | Price times registrations for each ticket, then scaled to the cash actually captured so discounts and partial payments do not inflate the total. |
| Registrations by ticket type | Count and percent per ticket type. | Same status rule as the timeline. |
| Sessions | Registered versus attended by session. | See Session Popularity. |
Year over year and Salesforce reports
| Row | What it shows | How it is calculated |
|---|---|---|
| Registrations to date | Registered attendees this year and last year at the same point before the event. | Counts registered attendees by the day they were created. Last year's count stops at the same number of days before its own start date as today is before this event, so the two are comparable. |
| Check-ins, Net revenue, Remaining spots | Current totals for this event and the prior-year event. | Read from the two events in Salesforce. A row is hidden when either event has no value. |
Event ROI
The ROI tab compares what the event earned with what you spent. It appears in the event's tabs when the ROI Dashboard feature is switched on for the event, and every figure refreshes when you open it.
| Tile or table | What it shows | How it is calculated |
|---|---|---|
| Revenue | Money received for the event. | The sum of the amounts on all payment transactions linked to the event's invoices. It reflects payments recorded, not unpaid invoices. |
| Actual Spend | What you spent. | The sum of Actual Amount on the event's Budget & Expense entries. |
| Net | Revenue minus Actual Spend. | Positive means a surplus. |
| ROI | Return on spend as a percent. | Net divided by Actual Spend, times 100. Shows a dash when Actual Spend is zero or empty, because the percent would be meaningless. Green or violet when zero or above, red when negative. |
| Year over year | This edition against the previous edition of the same event, with Change = this edition minus prior. | The prior edition is the most recent earlier-starting event in the same Event Group. Rows are Revenue, Donations, Actual Spend, Registered and Attended; a row is hidden if either side is not available. Shows "No comparison data" when the event is not in a group or has no earlier edition. |
| Budget vs. Actual by Category | Category, Estimated, Actual and Variance, with Export CSV. | Totals of each category's Estimated and Actual amounts from Budget & Expense. Variance is Estimated minus Actual, so positive means under budget and negative means over budget. |
| ROI Target | Optional goals with a progress percent. | Enter a Target net amount and, optionally, a Target ROI %; progress shows Net as a percent of the target amount. Leave both empty for no target; Clear removes it. |
- Record planned costs on Finance > Budget & Expense (Estimated Amount) and real costs as you pay them (Actual Amount).
- Open the event's ROI tab and check Revenue, Actual Spend, Net and ROI.
- Set an ROI Target if you have a goal, and compare to the previous edition under Year over year.
- Use Export CSV to share the category table. The file includes a summary row (revenue, spend, net, ROI and targets) followed by one row per category with variance and variance percent.
Revenue on the ROI tab is cash-based and can differ from Revenue on Reports > Finance, which is the larger of billed and captured. If the two disagree, check the Transactions tab for payments recorded without an invoice, and invoices still unpaid.
Budget & Expense
Event > Finance > Budget & Expense is where costs are recorded. It has a summary and two lists. Saving, editing or deleting an entry refreshes the summary automatically.
| Part | What it shows | Recommendation |
|---|---|---|
| Budget & Expense Summary | Total Budget, Total Expenses and Variance for the event. | These are Salesforce figures calculated from the entries (Variance is Total Budget minus Total Expenses). Editing a total directly is overwritten when an entry changes, so enter entries instead. |
| Budget entries | Name, Category, Subcategory, Budget and Actual for each line, with New budget entry. | Use one line per planned cost, with the Category that matches how you report (for example Audiovisual (AV), Catering (F&B), Decor, Entertainment, Marketing, Site Rental, Contingency or Other). |
| Expense entries | Name, Category, Amount, Transaction Date and Vendor, with New expense entry. | Record each invoice or receipt you pay, with the vendor and date, and link it to the Budget entry it belongs to. |
The ROI tab's Actual Spend reads the Actual Amount on Budget entries, not the Amount on Expense entries directly. Salesforce is designed to roll each Expense entry up into the Budget entry it is linked to (its Budget & Expense lookup), so link every Expense entry to a Budget entry. An Expense entry with no Budget entry is not included in Actual Spend.
Reports page snapshot
On Reports (/reports) with one event selected, the Overview tab's Snapshot card shows Registrations to date, Revenue to date, Cash collected and Average order value. Their definitions are on the Dashboards page. Refresh there re-reads the event's cached numbers.
Things to know about accuracy
- Revenue in cached views uses the larger of billed and captured amounts so it does not under-report; use Transactions when you need only cash.
- Cached dashboards show a Synced or Cached time and a Refresh recommended flag. Use Refresh before you export or present.
- Card numbers are never stored in Forge or Salesforce by Forge; only amounts, statuses and gateway references appear in these views.
- The Year over year card at the top of an event's Reports > Overview compares the event with a prior-year event. It uses the event's Prior Year Event in Salesforce when one is set, and otherwise the latest earlier event in the same event group. Use the selector on the card to pick a different prior-year event, or choose Automatic to clear it. With nothing to compare, the card says No comparison data.
- Reports > Salesforce reports lists the reports in the Blackthorn Events ROI folder in Salesforce and opens each one in a new tab with this event already filtered. Reports that filter by a date are not listed. Reports that compare a series of events, such as This vs last, appear only when the event's Series Key is shared by at least two events or a prior-year event is set. If the folder is not in your Salesforce org, the tab says No Salesforce reports.