Committed quantity usage billing

This topic is only applicable to termed contracts. A termed contract has both start and end dates.

With committed quantity usage billing, you determine the value metric and price point for a given allotment of your product or services. Then bill your customer as they consume the committed quantity based on the usage for the billing period. You can defer the associated revenue and recognize it any way you want.

If there's overage after the committed quantity is completely consumed or if there are unused quantities when the contract line ends, you get to decide the rules for how to automate those workflows.

Example

Say that your company provides data storage for businesses. You offer a "save when you commit" model where you charge 0.10 per GB for customers who commit to a volume of 5,000 GB in a given year. You want to bill monthly based on the total usage for the previous billing period, so the customer pays for what they used when they used it. You want to recognize revenue using the Daily rate method.

You start a contract for your customer, Pacific Board World, and add a Quantity-based billing contract line for the data storage item. You set the Quantity type to Committed and choose options for overage and unused quantities at contract completion. When you save the contract line, Intacct automatically generates the revenue schedules based on the flat/fixed amount of 500.00 (5,000 (the committed quantity) x 0.10 (the committed rate) = 500.00).

When you add a usage record, Intacct multiplies the usage quantity by the committed rate and schedules the usage to be billed on the usage date, as in the following example:

When you generate invoices for a billing period, Intacct combines the applicable usage records into the invoice line item.

In the above example as of May 5, the total used quantity is 1,058.00. The total unused quantity is 3,942.00 (5,000 - 1,058). The total billed amount is 72.20 (47.20 + 25.00).

Overage options

Say that your customer has completely consumed the committed quantity but continues to consume additional quantities. How should Intacct account for these quantities?

There are three possible options for overage:

  • Bill overage: Intacct allows you to add overage quantities and include the usage records when you generate invoices. When you add a usage record with a quantity that constitutes overage, Intacct treats the quantity as a variable quantity type and invoices it at the applicable billing price list tier rate. This usage does not appear on the billing or revenue schedules.
  • Do not allow overage: Intacct prevents you from adding usage records for overage quantities. If you try to add a usage record with a quantity that constitutes overage, Intacct displays an error and will not create the usage record.
  • Do nothing: Intacct allows you to add overage usage quantities but doesn't include them when you generate invoices. You can report on this usage.

If you want to bill overage, the contract must reference a billing price list and there must be a billing price list entry for the applicable item.

Unused quantity options

Say that the contract line reaches its end date, but there are remaining unused quantities. How should Intacct account for these quantities?

On the contract line end date + 1 (plus any offset value), the Intacct scheduler initiates an end date action for the contract line. There are three possible end date actions:

  • Bill unused quantity: Intacct creates a usage record for the remaining unused quantities and schedules it to bill on the contract line end date. When you invoice this amount, the billing schedule is Completed.

    For example, say the committed quantity is 100, the contract line end date is May 31, and the total used quantity is 80. On June 1, Intacct creates a usage record dated May 31 for the remaining quantity of 20.

    The contract line Audit Trail shows the following after the action is executed: Action = Workflow, Source = System, and After = Bill unused quantity.

  • Cancel unused quantity: Intacct multiplies the unused quantity by the rate and credits Unbilled AR and debits Unbilled Deferred Revenue for the resulting amount. It terminates the remainder of the revenue schedule using the contract line end date as the cancellation date. This contract line will not be renewed as the contract line's state is Canceled.

    The contract line Audit Trail shows the following after the action is executed: Action = Workflow, Source = System, and After = Cancel unused quantity.

  • Do nothing: Intacct takes no action. You can continue to add usage to the contract line past the contract line end date and bill against the committed quantity.

The scheduler only executes the end date action one time. If you subsequently delete the system-created unused quantity usage record, uncancel the contract line, or change the usage quantities in any way after the end action runs, you need to manually account for any unused quantity as applicable.

Before adding a committed quantity contract line

Before adding a committed quantity contract line, you may need to update your billing price list for the desired item.

Note the following expected behavior for billing price lists and committed quantity contract lines:

  • You can use a billing price list entry to default the committed rate for a selected item.
  • If you want to bill for overage, a billing price list with a valid price list entry for the applicable item must be specified on the contract. You won't be able to save the contract line without specifying a billing price list on the contract and saving the contract.
  • Included units must be 0.00 on the billing price list entry.

Add a committed quantity contract line

  1. Do one of the following:

    • Add a contract line from the Contracts page:

      1. Go to Contracts > AllContracts.

      2. Find the contract to which you want to add a contract line.
      3. Select More actionsEdit at the end of the row.

      4. Select Add located above the top-left corner of the Contract lines grid.
    • Add a contract line from the Contract lines page:

      1. Go to Contracts > All and select Add (circle) next to Contract lines.

      2. Use the Contract dropdown to select the desired contract.

        Intacct populates the page with default information from the selected contract.

  2. Use the Item dropdown list to select the desired product or service.
  3. If applicable, use the calendar tool to select the desired Start and End dates or GL posting date.
  4. Use the Billing method dropdown list to select Quantity based.
  5. Select Committed as the Quantity type.
  6. Use the On contract line end date dropdown list to select the desired workflow for handling unused quantities.
  7. Use the If usage exceeds the committed quantity dropdown list to select the desired workflow for overage.
  8. In the Calculator, enter the Committed qty and Rate values.

    The Flat/fixed amount field reflects the contract line value.

  9. Use the Revenue template dropdown lists to select the revenue templates and use the calendar tool to select the desired Start and End dates for each template.

    If you select a Quantity-based revenue template, the Total revenue quantity will be the Committed quantity.

  10. Use the dropdown lists to select any Dimension values.
  11. Select Post.

  1. Do one of the following:
    • Open an existing contract in Edit mode. Select Add located above the top-left corner of the Contract lines grid.

      The Contract Line popup window appears.

    • Go to Contracts > All > Contracts and select Add (circle) next to Lines.

      In the Contract Line page, use the Contract dropdown list to select the desired contract.

    • Intacct populates the page with default information from the selected contract.
  2. Use the Item dropdown list to select the desired product or service.
  3. If applicable, use the calendar tool to select the desired Start and End dates or GL posting date.
  4. Use the Billing method dropdown list to select Quantity based.
  5. Select Committed as the Quantity type.
  6. Use the On contract line end date dropdown list to select the desired workflow for handling unused quantities.
  7. Use the If usage exceeds the committed quantity dropdown list to select the desired workflow for overage.
  8. In the Calculator, enter the Committed qty and Rate values.

    The Flat/fixed amount field reflects the contract line value.

  9. Use the Revenue template dropdown lists to select the revenue templates and use the calendar tool to select the desired Start and End dates for each template.

    If you select a Quantity-based revenue template, the Total revenue quantity will be the Committed quantity.

  10. Use the dropdown lists to select any Dimension values.
  11. Select Post.

Learn more about contract line fields.

Next steps

Add usage records

Generate invoices

Post revenue recognition