Industry Use Cases

How to Find Donor Gifts Assigned to the Wrong Fund

A gift was designated for the food pantry. The batch was posted to the general fund. A review at gift level catches the mismatch that a deposit total hides.

What to pull

Use Excel gifts, fund mapping and posting tabs or export gift designations from fundraising and journal detail from accounting. Keep gift ID, allocation, amount and fund code.

How to check it

Join by gift and allocation reference. Compare the donor’s recorded designation with the approved accounting mapping. Account for split gifts and posted reclassifications.

Select the relevant sheets in Jolene.pro and run this check.

Which allocations have a different fund code or no clear mapping? Show the amount and source rows.

What to do with the result

Give finance the gift and journal references for each exception. Ask donor services to confirm ambiguous designations.

Confirm original designations and approved fund mappings before making corrections.

Try Jolene.pro · Follow Jolene.pro on LinkedIn

Leave a comment