Plus / Minus or Variance Analysis

I am looking to figure out the best way to create a report that shows the variance in donor giving as related to our projections. We currently do the projections in Excel and have a separate +/- sheet where we keep track manually. Is there a way to input projections into RE NXT? Maybe through opportunities?

Thanks!

Tagged:

Answers

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    if you simply trying to put projection into RE, then Opportunity likely is best record to use. As it indicates how much you are planning to solicit the specific donor for in a given year. Ask Amount, Expected Amount, Funded amount will help.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    you will have to manually enter the funded amount though, then from funded to ask amount, you can do the variance analysis.

    another way is to just do ask amount as the projection, and then use constituent query's summary of gift column to output amount actually given to plot against the ask/projection.