Billing Calculator

Matt Glosson Updated by Matt Glosson

This Billing Calculator helps put actual test dates to the settings found in the Sonar V2 billing parameters. It will calculate based on the initial date entered (Bill Date). Use it like this:

  • Left column: The Sonar V2 field name
  • Middle column: The value to input
  • Right column: Further explanation

For a “tutorial” on how Billing Defaults work, use the Billing Defaults page along with this worksheet. In addition to helping understand Billing Defaults, these values can also be seen and set in individual Accounts as “Billing Parameters.”

This tool is designed to be used to calculate Fixed Day Billing or Account Billing Settings. It's not designed to be used for calculating billing prior to an account's activation when Fixed Day Billing is not in use.
Bill Date * Date indicating when the Bill is generated
Bill Day Day of the month when the Bill is generated
(auto-filled by Bill Date above)
Invoice Day Day of the month to start the service period
The Invoice Day logic works like this:
  • If the number is blank/empty, the service period starts the same day as the Bill Day
  • If the number is the same as the Bill Day, (e.g., Bill Day=1, Invoice Day=1) the service period will begin on that day the following month
  • If the number is bigger than the Bill Day, the service period starts later the same month
  • If the number is less than the Bill Day, the service period starts the following month
Auto Pay Day
 Event to use as the basis for Autopay Days below
Autopay Days * Number of days after the Bill day or Invoice day to charge the account
(based on the selection of Autopay Day above)
Due Day
 Event to use as the basis for Due Days below
Due Days *
PAST DUE AFTER		 Number of days after the Bill day or Invoice day that payment is expected by
(based on the selection of Due Day above)
Grace Days *
DELINQUENT AFTER		 Number of days after the Due Date before the invoice
(and by extention, the account) is flagged as delinquent
Status Switch Days
CHANGE STATUS AFTER		 Number of days after Grace Days expire before the account status is changed.
Be sure to see the notes that appear after you hit "Calculate" below.

Results

Bill Date
Invoice Day
Service Period
Due on
Auto-pay on
Delinquent on
Status change on

* Notes on Delinquency and Status change:

The "Delinquent on" and "Status change on" dates calculated above may not be true every month, because in Billing Settings in an instance, you can set the Days to Check Delinquency. If the day that an invoice would go delinquent falls on a day that is unchecked, it will not go delinquent until the first "checked" day after. This also moves the Status change day, as that is calculated X number of days after the invoice has gone delinquent.

For example, if an invoice would have gone delinquent on August 14, 2021 (a Saturday), but the "Days to check delinquency" setting excluded Saturdays and Sundays, the invoice would actually go delinquent on Monday, August 16. If the Status Switch Days were set to 32, the status would change on September 17, which is 32 days after August 16.

Also note that the status change happens at midnight UTC.

For more information, see our Delinquency Best Practices document.

How did we do?

ACH Batching: Overview

General Transactions: Best Practices

Contact