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:
- Sales Forecast = $300k
- Revenue Forecast = Jun $100k, Jul $100k, Aug $100k
- 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.