Table of Contents

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

Results

Bill Date
Invoice (service starts on)
Due on
Auto-pay on
Delinquent on
Status change on

* Dependent on Days to check delinquency in Billing Settings

How did we do?

ACH Batching: Overview

Proration Calculator

Contact