Since the application automatically includes order details via our custom API solution with various ordering systems, Blue Onion automatically builds a deferred revenue waterfall over time in order to reconcile fulfillment data and ending deferred revenue balances.
To view this detail, navigate to the "Deferred Revenue" page on the sidebar:
The waterfall begins with the orders placed in the first month selected for the date filter, and then provides the month those orders were fulfilled, cancelled, or remaining to be fulfilled.
Additionally, each amount can be clicked on to provide the order line item details that are included in that amount:
Total Ordered:
The gross order amount, less discounts, that occurred in the given month on that row. This amount does not include sales tax, shipping, or fee amounts.
Order month: The month in which orders were originally placed.
Fulfillment Month:
The order line items that were fulfilled for the given month in that column. Note that this may differ from the revenue recognition if orders from prior months were fulfilled in a later month.
Total fulfilled: Represents the total dollar amount that was fulfilled in that month.
Total Canceled:
The orders that were marked as cancelled in that month. Please note that this is on an order line item basis, whereas the journal entry pages only include orders that were canceled in full.
Total Remaining:
The order line items that were ordered, but not fulfilled by month-end for the given period. The total of this column should represent your period end deferred revenue balance.
Total fulfilled: Represents the total dollar amount that was fulfilled in that month.
Blue Onion allows you to view your deferred revenue (gross sales less discounts) and related fulfillment by month.
In this example, there were $30k of orders (gross sales less discounts) placed in September. Of the $30k orders:
$26.8k was fulfilled in September.
$800 was fulfilled in October.
$251 was canceled in September.
Each number on the page provides a click-through to order and line item detail so you can see the transaction-level detail comprising each summary number. We hear from customers that this page helps identify outstanding deferred revenue balances from prior periods that may need review.