NXT Canned Report for Disbursement

Danielle Lifshitz

Is there a report that exists in NXT that can easily identify gifts processed through BBMS with the disbursement date?

Alex Wong

no default report will give you what you want.

this will have to be custom report that "merge" RE data with BBMS data.

Beth Gallagher

I add the disbursement as the GL Posted Date when I process the gifts and then run the gift list report I created on disbursement day. Payment Method = Credit or Debit and Post Date = today

Karen Stuhlfeier

We add the disbursement date as a gift attribute and with a query use that to balance with finance. Not ideal, and some extra work, but it works well for us.

Kim Berry

Not sure what you want to do with that info or the timing of when you need it, but my thought is to get the information from BBMS - look under recent disbursements and click on the disbursement date to view as a transaction list. You can then export and copy the transaction IDs to run a query to see related information (ID, name, gift amount, gift date, gift type, batch #, gift ID - whatever you need).

Catherine Burns

As others have said, the info is in BBMS with details to match to RE. If you have automated gifts and want to match them to the BBMS report make sure you export a query from webview and include the "Payment Transaction ID" field as this field is not available from database view.

We import the Disbursement Date to update the GL Post Date and add the transaction fee as a gift attribute.

We use a separate BBMS transaction list for failed payments and add the failed payment amount as a gift attribute because there is no way to export this from RE otherwise.