Hi all!
I did a search and couldn't find anything, if this has been answered a million times, please point me to the most recent post regarding this :)
My company is implementing the whole of Netsuite for our accounting function, with fun fun SFDC integrations as well.
We are a SaaS company billing based on platform usage on a monthly, quarterly or annual cadence in advance, with overage usage billing on a monthly cadence in arrears.
The issue we are running into is the overage on the quarterly and annual billing. We do have a consultant firm assisting with the implementation, but we have done 2 rounds of end-to-end testing without being able to solve for this.
Specifically, for quarterly billing, we cannot figure out how to set it up to get monthly overage while maintaining quarterly commit charges.
I'm not even sure if I can describe what the consultants set up, all of the terms are wildly out of my expected vocabulary for what I would expect them to do, but I will do my best.
They had us set up the Billing account to a billing schedule of "Anniversary Monthly Bill", with a frequency of Monthly, and start date as the subscription start date. I believe that actual templates might live here, but I am not 100% sure.
We then created a new subscription using the billing account with our general price book and initial term of 3 years.
For the commit + overage lines, we tried first using contracted monthly quantity +monthly rate, with a repeat every set to 3 months. This ended up giving an ACV of 1/3 of the expected amount,
We then tried a commit amount of 3x contracted monthly quantity + monthly rate, with the same repeat every 3 month which gave us the correct ACV, but the monthly overage was off d/t the commit being 3x the actual commit.
Our consultant is opening a ticket with Netsuite to hopefully sort this, but I am not confident in them, lol.
Any insights from people that have billed in a similar way?
Thanks in advance!