Average Daily Revenue

Average Daily Revenue


Average Daily Revenue Calculations

For members of 20 groups, average daily revenue is used as a reporting metric. The basic calculation of this is as follows- 
Total period revenue for all vehicles in a particular type (full size/mini) divided by the number of days for that month= Average daily revenue

There are some complications with calculating this in TBN and this article will provide you with the way to accomplish it. The primary complication for this style of reporting is with how TBN creates add-on revenue. In other systems, add-on revenue is just a function of an extension of vehicle revenue for a single vehicle. In TBN Add-ons are associated with routes, and not vehicles which means that there are times where the revenue will not be a 1-to-1 match with a particular vehicle. For example, you may have a driver gratuity which is calculated across the vehicle totals on the booking that have multiple routes and vehicle types as part of that booking.  The following procedure will allow you to calculate your ADR. 

Pre-Requisites to getting started- 

  1. Understand if your company books revenue by "trip departure date" or "trip return date". This will be required to know which filters to use in the next steps. 
  2. Understand which vehicles fit into which categories for this reporting process (ie; which vehicles are full size and which are mini) 
  3. Determine if there are add-on types you do not want calculated in your ADR revenue. (example: some companies don't include credit card surcharges or prepaid driver gratuities in the calculation) 

 Steps to Generating ADR Report- 

  1. Navigate to the "General Ledger Code- Revenue Entries report” under the accounting tab in reports. 
  2. Select the date range that you are trying to calculate for based on when you book revenue (either departure date or return date) and click apply filters. 
  3. Click the Button “group by vehicle/add on types” 
  4. Choose the "Vehicle" radio button and click apply filters. This will show you only vehicle totals during your selected period. 
  5. Add up the vehicle totals that you want included in your “full size” vehicle revenue. (this calculates the "period full size vehicle revenue") 
  6. Add up the vehicle totals that you want included in the “mini bus” vehicle revenue. (this calculates the "period mini vehicle revenue") 
  7. Add the total of both together and calculate the percentage of revenue each represents from the monthly total. So for example if you had 1M in total revenue and 700K of that was full size revenue, you would divide 700K by 1M to get .7 or 70% of the vehicle revenue allocated to full size vehicles. (this calculates the "full size and mini allocation percentage")
  8. Next, do the same for small vehicles or simply use the remaining 30% in this case as it would be the other vehicle type. 
  9. Now, Click the Addon radio button and click apply filters. This will show you only add-on revenue during your selected period. 
  10. Next, total all the add on revenue you want to include in this report, excluding any add-ons that you want to not include in your final ADR. (this calculates the "total period add-on revenue")
  11. Once you have that total you would use the calculated percentages from the above equation to allocate the add-on revenue. This assumes that things are mostly even in terms of add ons being distributed by vehicle categories. If you feel they are not, for example if you rarely use add-on revenue when using mini buses, you could manipulate the percentage of add-on revenue you will allocate by changing the percentage you use. For example, Vehicle revenue may be split 70/30 but you could use 90/10 to allocate add-on revenue if you rarely use add-ons with smaller vehicles. (This calculates T"otal full size" and "total mini revenue)
  12. Once you have the add-on revenue allocated and added to the vehicle totals for that same period, you can simply divide that by the service days included to calculate your ADR

ADR Calculation Summary

  1. Total period full size vehicle revenue (+) (Total period add-on revenue (x) full size allocation percentage) (=) Total Full Size Revenue 
  2. Total period Mini vehicle revenue (+) (Total period add-on revenue (x) mini allocation percentage) (=) Total Mini Revenue
  3. Total Full Size Revenue (/) Service Days (=) Full Size ADR
  4. Total Mini Revenue (/) Service Days (=) Mini ADR

Overview

This module explains how to create an Average Daily Revenue (ADR) Report in TBN. This report is often required by operators participating in 20-groups (such as Spader groups) and provides visibility into monthly revenue performance normalized per day.

1. Context for Spader and 20-Group Members


Spader and other benchmarking groups typically request:

  • Monthly revenue reporting

  • Calculated as total revenue ÷ number of days in a given month

  • Requires distinguishing between add-on revenue and base revenue


In TBN, add-ons are linked to routes, not directly to dispatches, so using GL Code revenue reporting is more accurate for this purpose.

2. Accessing the Right Report


Steps:

  1. Go to the Reports tab in the top navigation

  2. Select the Accounting section

  3. Choose the GL Code Revenue Report


This report aggregates revenue entries by GL code, including both base trip revenue and add-ons.

3. Choosing the Correct Revenue Date Type


TBN offers two key options:

  • Booking Return Date

  • Booking Departure Date


Your selection depends on how your company reports revenue:

  • Use Departure Date if you recognize revenue when the trip begins

  • Use Return Date if you recognize revenue after service completion


For most ADR reporting, Departure Date is recommended for alignment with trip execution timing.

4. Adjusting for Add-On Revenue


Because TBN ties add-ons to routes, not dispatches:

  • Add-on revenue may not appear in vehicle-based dispatch reports

  • The GL Code Revenue Report is the preferred tool because it consolidates revenue across both dispatches and add-ons

5. Calculating Average Daily Revenue


After generating the report:

  1. Filter for the target month

  2. Note the total revenue figure

  3. Divide by the number of days in that month (usually 30 or 31)


This gives you your average daily revenue metric for group reporting.

Best Practices

  • Standardize on using Departure Date across all reports unless instructed otherwise by your financial team or 20-group facilitator

  • Align your GL mappings to accurately track charter vs. school bus vs. other revenue types

  • Export the GL Revenue Report to Excel for easy daily or monthly breakdowns



    • Related Articles

    • Revenue By Day Report

      Revenue By Day Report The Revenue by Day Report displays the total revenue earned by vehicle for each day of the selected month. This report is based on the return date of the dispatch and defaults to the current month. This includes revenue from ...

    • Revenue Earned By Vehicle

      Revenue Earned By Vehicle Report The Revenue Earned by Vehicle Report displays the revenue associated with each vehicle, broken out by dispatches, as well as revenue earned from any dispatches that did not have an assigned vehicle. This report is ...

    • Unearned Revenue Report

      Unearned Revenue Report Unearned Revenue: This report is meant to reflect payments received for Bookings that have not yet departed, or if the 'Return Date' filter is selected have not yet returned, as of the date selected in the filter page. The ...

    • GL Code Revenue Entries Report

      GL Code Revenue Entries Report General Ledger Code Revenue Entries- This report displays the total revenue earned from Vehicles, Addons, and Free Entry Transactions, as well as factors in any negative amounts such as Discounts, negative Addons/Free ...

    • Day-to- Day Pricing Calculations

      Day to Day Pricing Comparisons We're thrilled to introduce our groundbreaking feature that lets you calculate prices on a day-to-day basis, empowering you to manage your revenue like never before. With this feature, you can easily distinguish between ...