convert sales into revenue, into cashflow

Hi.

Is there a way i can take my Sales Forecast and show it as invoiced revenue? using:

  • Sales amount = $300k
  • 1st Invoice date = June 1
  • Deal term = 3 months
  • Revenue = Jun $100k, Jul $100k, Aug $100k

After that calcualtion would like to show cashflow by adding payment terms

  • Payment terms = 60 days
  • CF revenue = Aug $100k, Sep $100k, Oct $100k

Reports:

  1. Sales Forecast = $300k
  2. Revenue Forecast = Jun $100k, Jul $100k, Aug $100k
  3. Cashflow Forecast = Aug $100k, Sep $100k, Oct $100k

Thanks,

Matt

Hi @MHewitt6,

Thanks for reaching out!

I’ll invite a few experts to this conversation so they can share their thoughts.

Hi @Josh, @warrendavey, @Jonno_Price, @ChrisoKlepke - What would you advise in this case?

Thank you!

Best,

Kristen

Help Pls! today i download my deals and then finance does the math in excel and uploads t Power BI.

Hi @MHewitt6 ,
If all the required data points are captured on the deal level (e.g. total revenue amount, 1st invoice date, deal term, payment term) then in theory you should be able to use calculated properties which you can then incorporate into custom reports to achieve this. However it would be fairly convoluted and it is not something I’ve built personally.
As an alternative, have you looked at Databox? Free Dashboard Setup | Databox
Hope that helps and please do keep us updated.