Understanding the One-Day End Date Difference between Advanced Billing and Maxio Core

Some Maxio users may notice that a Transaction’s End Date in Maxio Core appears one day earlier than the End Date shown on the related Advanced Billing Subscription.

How Maxio handles end dates for Advanced Billing term subscriptions

To prevent revenue periods from overlapping, Maxio automatically adjusts (or “short-dates”) the end date for Advanced Billing term subscription transactions by one day before creating the Transaction record.

Why this happens

Without this adjustment, two consecutive billing periods would both include the same boundary day. This causes the system to double-count revenue for that day. By reducing the end date by one day, each transaction covers:

• The full Start Date, and
• The shortened End Date,
• Without overlapping the next billing period, which begins on the same nominal day.

Impact of short-dated transactions on the Advanced Subscription Momentum Report

The Advanced Subscription Momentum Report uses strict rules to determine whether a Transaction is included in a given reporting period. Under these rules, any Transaction that starts and ends within the same reporting period is excluded unless its End Date falls on the last day of the period.

Typically, this only presents an issue when you've made manual configurations to the Term Subscriptions in Advanced Billing. You will need to ensure the dating is consistent between manually and automatically created Invoices.

Example:

• The Advanced Billing Ad-hoc Invoice period is 10/1 - 10/31
• The Maxio Core Transaction created using Advanced Billing dates is 10/1 - 10/30

In this scenario, the Transaction’s MRR will not be counted in the Momentum Report unless the Transaction End Date is adjusted to 10/31.