Gift Detail & Summary Report Doesn't Give Original Gift Amount

Bernard Nemis

Hello, Everyone.

When I ran the Gift Detail & Summary Report, it gives me the adjusted amount instead of the original amount regardless of the date. So if I have a gift entry of $50 on June 30, and then I made an adjustment on July 30 (new fiscal year) to $200, the report would show $200 even if I use the gift date/post date to June 30 on the report.

This doesn't make sense because if we depend on this report to give us end of the year figures, and then we have to make changes (ie. refunds) after the year ends, then the amount should still be $50 if I ran the report on June 30.

Thank you. say I have a gift entry of $50 on 6/30. I run a Gift Summary report for that date and it gives me the amount of $30...Let's say I have a gift entry of $50 on 6/30. I run a Gift Summary report for that date and it gives me the amount of $30...

JoAnn Strommen

@Bernard Nemis Believe it's a known issue. It's ‘run this report at EOY’ or cannot be run with accurate info later. To run it later will also reflect any new gifts/payments/adjustments made before run date.

Bernard Nemis

@JoAnn Strommen
Thank you, JoAnn. I have researched any other means of pulling the preadjusted gift amount and I found out in the Query this: Gift Query > Adjustments > Gift Adjustment Previous Funds > Split Amount (which is good in the gift involves two or more funds). The issue I have with this is that the Export doesn't have this option. The only work around I can think so far is to pull a query file and clean that spreadsheet.

Dariel Dixon 2

@Bernard Nemis Gift Detail & Summary Reports are dynamic, and not static. I don't know if this isn't worked as expected. The report is giving you the figures at the time the report was run, not necessarily when the report was created. Because adjustments actually change the amount of the gift, and actually kinda moves the original values to another field that may not exist on gifts without adjustments. Like @JoAnn Strommen mentioned, it's tough because you have to basically remember to run it when you need it and store it somewhere.

Bernard Nemis

@Dariel Dixon
Thanks, Dariel. Would you know of a way to pull that pre adjustment amount other than the query I mentioned? If I pull any report at fiscal year end so that our BO can reconcile their data with ours, then every time I make a change to any gifts within that fiscal year, I have to give a new report and supplement it with the Adjusted Gift report. My issue there is that not all gift changes happen through gift adjustments.

JoAnn Strommen

@Bernard Nemis What function does Export not have?

Bernard Nemis

@JoAnn Strommen
You can't pull the same information found in the Gift Query > Adjustments > Gift Adjustment Previous Funds > Split Amount. It's not in Export (as far as I know).

Elizabeth Johnson

@Bernard Nemis I don't think I've run into this problem. I keep all my adjustments for a particular year within that fiscal year - so I would back date my adjustment to 6/30/yy. We do not post to the general ledger so that might be an issue for someone that does. Because we don't post we use the GL Post date as the date a transaction was entered into the system. This is true for us for gifts, pledges, and adjustments.

Dariel Dixon 2

@Bernard Nemis I would look into Export and output the adjustments and amendment options that you want. I think that really is the best option that will get you the info you want, but I don't know if the format is what you're looking for.

Bernard Nemis

@Dariel Dixon
Thanks, Dariel. Unfortunately the Export doesn't have the “Previous” output. But the Query does. So I have been thinking if the format could work if I export the Query results. It's format is closer to the canned report since it lists split gifts by rows, as opposed to the Export - it lists the split gifts in the same row but different columns. As Elizabeth mentioned, I would have to rely more on the adjustment reports. Thank you!