Customer Forum

Recurring Revenues

Admin Posted: 2016-10-27 10:55

Does anyone have any recommendations on the best way to work with recurring revenues within Workbooks?

We sell services that are paid for an an ongoing monthly basis, with open ended contracts. Clients choose from a range of bolt on solutions, so all overall packages are custom. Some bolt-ons are single charges that are only be paid initially. The majority are monthly recurring charges. Sales team are targeted/commissioned on gross margin for the first 12 months of revenues received from any sale.

Is creating monthly opportunities with the estimated close date being the monthly payment due date, adding all the products as line items to every opportunity on an ongoing basis, the best/only way?

Alix (Workbooks Online) Posted: Tue, 08.11.2016 - 12:25

I would suggest that you do not need to create a new Opportunity each month. It may be simpler to add custom fields to your Line Items to help you classify each of the Products. For example, you could have a new column which determines the Payment Type, either 'Single Charge' or 'Ongoing Monthly Payments'. You may also want a column which store the 'Monthly Charge' for those Line Items that are recurring.

The when you are reporting on the Opportunities to determine the commission for your Sales Team, you can drill through from the Opportunity to the Line Items to fetch the data from these custom fields. You can create calculated columns that determine the amount should be included for each Line Item, e.g. if the 'Payment Type' is 'Single Charge' then output the full amount from the line, if the 'Payment Type' is 'Ongoing Monthly Payment' then output 12 times the 'Monthly Charge', and from there calculate the commission. If you then create a summary view which groups by Opportunity Reference, it will add up the calculated values from each line into the Total Commission for that Opportunity, and you can group by the Assigned To of the Opportunity to get the Total Commission for each Sales Team Member.

If you need to discuss your requirements further, please do not hesitate to contact Support by email,