How to Reconcile Your Fundraiser with Gifts in Raiser’s Edge NXT

1. Sync any outstanding transactions

Check to see if any transactions failed to sync. You can do this by filtering transactions in the All Transactions Table by RE NXT Sync status.

1. Not Yet Synced: these transactions haven't been synced yet. This might be because auto-sync is disabled, or you have your settings set to sync at payout date, and the payout hasn't been triggered yet.

    

2. Failed: this transaction tried to sync but failed. 

3. Partial: Some of this transaction was able to sync, but parts of it failed. 

If any transactions failed or partially synced, view and fix the error, then resync the transaction.

2. Gather Your Reports

If you have confirmed all transactions have fully synced, it's time to gather your reports to reconcile the data that has synced.

1. All Transactions Report: This report contains all the details and data about your fundraiser. Refer to this article for instructions on how to find it.
2. Audit Log: This report shows all integration activity, including all gifts synced by Trellis into Raiser's Edge. Refer to this article for instructions on how to find it. 

3. Cross-Reference Checkout IDs

The Checkout ID is the unique code Trellis assigns to all checkouts. Cross reference the checkout IDs in the Sales Breakdown Sheet in the All Transactions Export with the Gift Sync sheet in the audit log. 

Step 1: Copy the Gift Sync data into the All Transactions Export

Copy all the data from the Gift Sync sheet in the Audit Log, and paste it into a new sheet in the All Transactions export. Name the new sheet Gift Sync.

Step 2: Find the Checkout ID columns

Look at the top of each sheet and note which column letter the Checkout ID is in:

• On the Sales Breakdown sheet
• On the new Gift Sync sheet

Step 3: Add the formula

1. Go to the Sales Breakdown sheet.
2. Add a new empty column. Label the column Gift Created?
3. Click the cell right below it (row 2) and paste this formula:

=IF(COUNTIF('Gift Sync'!A:A, A2)>0, "Match", "Missing")

1. Before pressing Enter, update the letters:
   • Change both As in 'Gift Sync'!A:A to the Checkout ID column letter on the Gift Sync sheet.
   • Change the A in A2 to the Checkout ID column letter on the Sales Breakdown sheet (keep the 2).
2. Press Enter.

Step 4: Apply it to every row

Click the cell with the formula. Double-click the small square in its bottom-right corner. The formula will copy down to every row.

Step 5: See what's missing

1. Click the Gift Created? column heading.
2. Create a Filter.
3. Click the arrow next to Gift Created?, uncheck everything except Missing, and click OK.

Any rows showing are transactions that don't have a matching gift.

Frequently Asked Questions

The transaction says it's fully synced, but no gifts were created - why?

There could be a few reasons why the gift was not created:

1. You have that fundraising driver set to "Do not sync as gift" in your RE NXT gift sync settings
2. The transaction was entered via the SES, and the user unchecked "Sync gift to RE NXT" during the purchase. 
   1. This can be checked via the Checkout Overview sheet in the All Transactions export, in the Offline Gift Sync column.

Is there a way to see all gifts synced by Trellis in RE NXT?

When we sync gifts, we add a custom field called "Trellis Source" that indicates which part of Trellis the transaction was made.