Reports & Charts (Beta)

​

Overview

Reports & Charts provides users with visualization and aggregation tools to track various aspects of their revenue and finance data. From revenue and bookings to customer counts and payment status, these reports offer valuable insights into key metrics and trends. Each chart or report focuses on a different aspect of performance: Charts

• Revenue: Tracks total revenue generated each month, broken down by revenue type.
• Bookings: Displays monthly sales based on the value of a commercial agreement between a buyer and seller, segmented by customer transaction type.
• Customers: Provides insights into new customer acquisition and customer churn.
• Renewals: Analyzes subscription renewal amounts and timing, renewal lapses, and churn over time.
• Invoicing and Payments: Monitors unpaid invoices and revenue suspended by past due payments.
• Collections: Tracks uncollected payments and collected payments over time.

Reports

• Bookings: Displays monthly sales based on the value of a commercial agreement between a buyer and seller, segmented by customer transaction type.
• Customer count: Breaks down the monthly customer count into various categories.
• Invoice receivable: Lists all invoices sent to customers within a selected date range.
• Raw data: Offers detailed revenue data segmented by Bricks and Customers.
• Revenue: Tracks total revenue generated each month, broken down by revenue type.
• Revenue waterfall: Analyzes recurring revenue data segmented by Customers.
• Tax remittance: Displays total taxes billed and amounts to remit by state.

​

Key Terms

​

Subscription Status

​

Renewed

Closed won renewal orders.

​

Terminated

Subscriptions that are scheduled to end before the end date specified on the contract.

​

Churned

Subscriptions that have been terminated, and the termination date has passed.

​

Lapsed

Subscriptions that have ended but have not been terminated, nor has a renewal been closed.

​

Revenue

​

MRR

Monthly recurring revenue. Any Brick on an active subscription that the customer is billed for on a recurring basis.

​

Recurring

Consistent and periodic income from subscription Bricks.

​

Non-recurring

One-off payments from one-time, usage, and milestone Bricks.

​

Usage

Income from Usage Bricks based on actual usage or pre-committed quantities.

​

Milestone

Income from Milestone Bricks based on achieving predetermined checkpoints.

​

Charts

The charts listed below offer a single-year view (unless otherwise noted) of your company’s revenue data and customer count.

​

Revenue

The Revenue chart offers a breakdown of the total revenue your company generated on Salesbricks. It includes monthly recurring revenue (MRR) from recurring, non-recurring, usage, and milestone Bricks on active closed won orders for each month. It also provides a forecast of future months’ revenue based on the expected MRR of active subscriptions. Types of Revenue:

• Recurring
• Non-recurring
• Usage
• Milestone

Clicking on this chart will take you to the Revenue report. Please note that Salesbricks charges usage in arrears; any usage revenue displayed on the chart is based on usage data from the previous month.

​

Bookings

The Bookings chart displays the total revenue your company has booked each month. Types of Transactions:

• New logo: Closed won initial orders indicating new customers
• Renewal: Closed won renewal orders
• Recast: Closed won recast orders
• Upgrade: Closed won upgrade orders
• Churn

Clicking on this chart will take you to the Bookings report.

​

Customers

The Customers chart tracks the monthly amount of:

• New customers from closed won initial orders
• Churned customers from terminated orders
• Existing customers from active subscriptions

Clicking on this chart will take you to the Customer count report. Please note that you are not currently able to drill down in the Customers chart to understand which customers make up the numerical values.

​

Renewals

The Renewals chart visualizes the total monthly revenue from renewed, lapsed as potential loss, churned, and upcoming subscriptions. Types of Subscriptions:

• Renewed: These appear on the chart during the month in which the renewal agreement starts.
• Lapsed
• Churned
• Upcoming: The expected renewal value will appear on the chart under the month in which the next agreement is expected to start.

Please note that you are not currently able to drill down in the Renewals chart to understand which customers make up the numerical values.

​

Invoicing and Payments

The Invoicing and Payments chart monitors your total money due, categorized by how late payments are. Past-due invoices are segregated into five buckets:

• 1-30 days past due
• 31-60 days past due
• 61-90 days past due
• 91-120 days past due
• 120+ days past due

Clicking on this chart will take you to the Invoice receivable report.

​

Collections

The Collections chart aggregates the total amount of money collected for the selected fiscal year, as well as uncollected payments of all transactions across all fiscal years. Uncollected money is calculated by the total amount of all unsettled invoices. Collected money is displayed under three categories:

• Money collected during the current month
• Money collected during the current fiscal quarter (the consecutive three-month period used for financial reporting and analysis)
• Money collected during the current fiscal year-to-date (the start of the fiscal year to today)

Please note that collections are shown based on fiscal quarters, and currently, this cannot be adjusted manually.

​

Reports

​

Bookings

The Bookings report shows a list of logos and revenue that closed during a selected time range. Bookings are sorted based on the date the order was closed; if an order was closed in February but set to start in April, it will appear in the report as a February booking. Churned logos appear under the month that the order was terminated.

​

Customer count

The Customer count report tracks customer acquisition and churn rates to determine net customer count changes. Customers are sorted based on the date the order was closed; if an order was closed in February but set to start in April, it will appear in the report as a February customer. Churned customers appear under the month that the order was terminated. This report breaks down your monthly customer count into four quantities:

• Start of month total: How many unique logos you had coming in to the start of the month
• Added this month: How many new logos you’ve added
• Churned this month: How many logos terminated their subscription
• End of month total: How many customers you ended the month with after accounting for new and churned logos

​

Invoice receivable

The Invoice receivable report lists all invoices within a selected date range. An invoice will appear in the report if its “invoice date” (typically, the start of the billing period) falls within the selected date range. Invoices can also be filtered by customer names and payment status (paid and/or unpaid).

​

Raw data

The Raw data report offers a detailed look at all revenue data, segmented by Bricks and Customers, within a selected date range. This data includes subscriptions, one-time payments, usage, and milestones. Data for this report is filtered by the period that coincides with the report’s date range. For example, if a subscription runs from February to December, and the report shows raw data from June to December, the report will only show raw data for this subscription from June to December. The revenue data shown on each row is the MRR for that Brick, which is calculated by dividing the grand total by the total contract length in days, then multiplying it by the number of days in each month.

​

Revenue

The Revenue report displays the total revenue from sales transactions for each month, also segmented into recurring, non-recurring, milestone, and usage revenue. Data for this report is filtered by the period that coincides with the report’s date range. For example, if a subscription runs from February to December, and the report shows revenue from June to December, the report will only show revenue for this subscription from June to December.

​

Revenue waterfall

The Revenue waterfall report shows all recurring revenue data, segmented by customers. This data takes only the recurring revenue from subscriptions into consideration. Monthly revenue allocations are prorated by day. Data for this report is filtered by the period that coincides with the report’s date range. For example, if a subscription runs from February to December, and the report shows revenue from June to December, the report will only show revenue for this subscription from June to December.

​

Tax remittance

The Tax remittance report displays the total tax amount billed, and the amounts to remit for each state where you have sold your software and services. Salesbricks uses Stripe’s APIs (Taxjar) to determine nexus - whether or not sales tax should be applied to an order based on your company’s address and the buyer’s address. As the seller, it is your responsibility to register and remit taxes with each applicable individual state. If you would like assistance with this process, we recommend using our partner, Zamp. An overview of Zamp’s services can be found here.