Expected Revenue Tracking

Hi qld1.universal 

Great question. There are some options avialable on XPLAN that can help you with your tracking and reporting. 

Of course CommPay would be your best option when it comes to Revenue and it is integrated into the XPLAN world and provides a link between Revenue and your XPLAN client. 

By using an external platform you will need to either import the data into XPLAN to store the revenue against the client so you can report on it - or you will need to combine data from Revex and data from XPLAN in an enternal solution like excel. Revex does have options to store your clients XPLAN Entity ID number which will help with importing into XPLAN or via Excel analysis. 

Let's think about XPLAN and recording your metrics:

1. Opportunities. Opportunities will allow you to record New and Exisitng client opportunities and track the opportunity throughout the process. You can store expected Revenue and this is reportable via XPORT.
2. XPLAN Diary will track your client meetings and outcomes can be set for each meeting. 
3. Case Threads - this is one I highly recommend. This can track your workflow, create automation, but also build in outcomes like SOA / ROA / and weather a client proceeds or doesn't proceed. There is great xmerge code for Threads which will allow you to enter the Revenue Expections then export this data along with key tasks. Then Excel can compare the client, the outcome, did it proceed with an SOA or ROA and the expected Revnue. Combine that with a report from Revex and you can do some analytics. This also integrates with Opportinities so you can use both Opportunities and Cases to achieve the best outcome. 

One thing to be aware of, there are only certain fields for Revenue Tracking in Opportunities and Cases. Your list above certianly had more. Some custom fields might be needed, if you are on a site that you can add Custom Fields - you may need to add some. 

In conclusion:

• Revenue Tracking Automation
  • Opportunities or Cases for the fields availalbe in these tools
  • Custom Fields for anything else. 
• Pipeline tracking
  • Opportunities or Cases or both. It really will provide you with excellent data, and create efficiencies in your business. 
• Reporting to provide:
  • Expected initial revenue vs Received initial revenue
    • XPORT (opportunities) or Xmerge in Excel (cases) 
  • Expected ongoing revenue vs received Ongoing Revenue
    • Combination of the above report and the data from Revex.