Exporting Split Gifts

Emily Rubino 2

Happy Friday everyone! I'm hoping someone can direct me on the best way to handle exporting gift information from batch, as I am a bit new to this process. Our accounting team needs to export the following information for each gift batch we commit: 

• GL Post Date
• Gift Date
• Gift Type
• Pay Method
• Gift Amount
• Fund ID
• Campaign ID
• Constituent Name
• GL Debit Number and GL Credit Number

I've been able to export this information without issue, but run into a problem when trying to export split gifts. I can't seem to figure out how to export the Fund ID and GL Debit and GL Credit numbers for the split gift. I've tried following the knowledgebase solutions, but am still struggling to understand. Is there a particular way I should pull in the fields so that I am able to export the split gift with both of the Fund IDs and their own individual GL Debit and GL Credit numbers?


Thanks so much for any insight you can provide.

Deb Dressely

Emily Rubino:

Happy Friday everyone! I'm hoping someone can direct me on the best way to handle exporting gift information from batch, as I am a bit new to this process. Our accounting team needs to export the following information for each gift batch we commit: 

• GL Post Date
• Gift Date
• Gift Type
• Pay Method
• Gift Amount
• Fund ID
• Campaign ID
• Constituent Name
• GL Debit Number and GL Credit Number

I've been able to export this information without issue, but run into a problem when trying to export split gifts. I can't seem to figure out how to export the Fund ID and GL Debit and GL Credit numbers for the split gift. I've tried following the knowledgebase solutions, but am still struggling to understand. Is there a particular way I should pull in the fields so that I am able to export the split gift with both of the Fund IDs and their own individual GL Debit and GL Credit numbers?


Thanks so much for any insight you can provide.

 

We pull reports with split gifts all the time.  Add to your list above Split Amount.  It is under +Funds near the bottom of the list.  You already have fund ID on the list so when you add split amount to your output you will see the fund id and fund split amount for each gift.


Deb