I tried to post this ealrier, so this MIGHT be a repeat...
I need to produce a monthly report of new gifts and pledges (but not payments) received during a particular month. I can get these, and I only want hard credit. But, is there a way to exclude Foundation gifts that are in reality pledge payments towards a pledge made in a prior time period? For example, Rocky T.F. Squirrel pledged $444,444 last year. This month, we received a payment towards that pledge from the Bullwinkle Foundation. This payment gets entered as an "on behalf of" transaction (i.e., has an honor marker = B), entered from Rocky's side of the pledge. But, it is a "gift transaction" on the foundation side. But I don't want this particular "Gift Transaction" included because it's a payment on a pledge that we already reported in a different time period. However, I do want some on behalf of transactions, if they are actually for the selected time period (i.e., this month).
I've seen this discussed before but not in while. Anyone have a nice little solution to this?
Sue, St. George's School, Newport, RI