Details about this thread
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 314 subscribers
  • Views 731 views
  • Users 0 members are here
Related content from around SugarClub

Best Way to Capture Invoice Installments (Forecast)

Andy Wilson

Hello,

I'm looking for some advice around the best method or module to capture invoice installments (value and dates).

This will be used for forecasting purposes in the form of a dashboard chart.

Currently, our users provide a single figure within an opportunity, but this can lead to inaccurate reporting when particular revenues will be split over a varying number of months and invoices.

Not all revenues will have installment invoicing and the ones that are issued in installments may not be split equally across each month.

For example:

Customer A has an opportunity raised against them for 100.00.

At present, the opportunity value is 100.00 and my report says this opportunity will be invoiced in December 2024.

In reality, it has been agreed that this customer will be invoiced 10.00 in October 2024, 60.00 in November 2024, and 30.00 in December 2024.

I have thought about creating a series of individual opportunities which will relate to the parent opportunity. However, I don't believe our users would welcome this method.

Does anyone have any ideas to help achieve this, please?


Thank you.

Parents
  • 0

    Using "Revenue Line Items" and Separte "Installments" module - Both of them  may work for that need.

    However if you use "Revenue Line Items" module for these installment details, it gives the right monthly forecast for your forecasting needs.

    Ideally, if you get the order for 100$ and only invoicing is to be done in 4 installments with $25 each at each quarter, keeping in 4 Revenue Line Items make sense.

    Your opportunties are always to give you indication of your future cashflows. 

    If you take the Installment route, your forecast may not be projecting accurate dates for your income. 

    I suggest you should explore more towards using "Revenue Line Items"

    Ram Kumar LK

    Sr Solution Architect

    https://www.bhea.com

Reply
  • 0

    Using "Revenue Line Items" and Separte "Installments" module - Both of them  may work for that need.

    However if you use "Revenue Line Items" module for these installment details, it gives the right monthly forecast for your forecasting needs.

    Ideally, if you get the order for 100$ and only invoicing is to be done in 4 installments with $25 each at each quarter, keeping in 4 Revenue Line Items make sense.

    Your opportunties are always to give you indication of your future cashflows. 

    If you take the Installment route, your forecast may not be projecting accurate dates for your income. 

    I suggest you should explore more towards using "Revenue Line Items"

    Ram Kumar LK

    Sr Solution Architect

    https://www.bhea.com

Children
No Data