FAQ - Billing Connectors

How does pro-rating work?

Pro-rating depends on your Billing system.

IDSync will post additions to your PSA system using the date it finds a change in your Marketplace system, so if your Billing System is configured to use pro-ration, your billing system will automatically calculate the pro-rated values (for cost and price).


The following is an example of how Pro-ration works on the Connectwise Platform along with the IDSync "Roll-up" feature for consolidating line-items:

Below you will see a single addition dated March 1, 2019 on an Agreement in Connectwise: 

Assuming that the MSP bills in advance and bills on the 1st of the month for the Month of March, the initial bill might look like the following:



MARCH INVOICE

  • The invoice shows that 2 units were purchased.  Because this is the first month those units are being billed, the invoice indicates that the units are being prorated starting on 3/1/2019.  Since 3/1/2019 coincides with the start of billing date, no actual proration occurs and the units are billed at their full monthly price for the month of March. 

Now, assume that the customer purchases two additional units of Office 365 Business Premium on March 15th.  Two additions will display on the agreement as shown below:


When the next invoice is generated in April, the invoice might look like the following:


APRIL INVOICE


  • Looking at the invoice to the left, you will see that the original 2 units that were purchased on March 1, 2019 are billed for the full month of February at $22.00/month per license.  The 2 additional units that were purchased on March 15th, 2019 are billed for roughly the equivalent of a month and a half (the half month of March plus the full month of April) at a price of $34.06/month per license.  This proration calculation is indicated by the note that indicates that: "This item has been prorated with a start date of: 3/15/2019".



Now, let's look at what the IDSync Connectwise "roll-up" does to the addition records after the invoice has been issued for April. 

You will notice that addition #2 (with an effective date of 3/15/2019) is now marked as cancelled with a cancellation date equal to April 1st (the date on which that addition was first invoiced to the customer).
You will also notice that quantity on addition #1 changed from a quantity of 2 units to a quantity of 4 units.  This has been done to consolidate the two line items into one single line item for future invoicing. 

Finally, see the following Invoice for May that demonstrates how the "roll-up" eliminates the "extra" line item now that the line item from sequence #2 has been pro-rated and invoiced.


MAY INVOICE

  • You will note that only a single line item for four licenses displays now for a full month at $22/month per unit.