I am a RE user and have been trying to reconcile our income from RE to our General Ledger.  Pulling income based off of Fund Distribution Credit Account number seems like the most logical criteria to use for the Query.  The problem is this: gifts in our database that are split between two different funds with different distribution credit account numbers end up getting the total gift amount added into each of the seperate distribution accounts.  This is throwing our reconciliation WAY OFF!  Is there an output that I am unaware of that will result in showing the split amount of the fund that is tied to the queried distribution account number?

Under the fund section in a query you will find the field split amount.  Use this field when querying on split gifts to avoid the gift double counting.

Good luck!

Mike, 

Under Campaigns, Funds, & Appeals there is a Split Amount field. But this field is not available in any of the canned reports; so it's problematic for us. For that reason, we do not use split gift amounts when entering gifts. If we receive a $100 check for 2 different funds, we create two separte gifts; one to each fund for $50.

If you run Reports under financial reports and your format is based on fund, the distributions to the fun is correct. The gift detail & Summary report works well