Issue with Engage reconciliation report
Closed, ResolvedPublic1 Estimated Story Points
Actions

Description

@Eileenmcnaughton There seems to be an issue with the Engage reconciliation report instance/74

Many of the batches I've been trying to reconcile seem to match up, but for a few, there are huge discrepancies between the total that shows in the report and what shows for the batches under Find Contributions.

Batch numbers with big discrepancies:
50755
50756

The batches above appear to be hand entered into Civi.

Batch numbers not showing at all in the report, but can be found under Find Contribs:
18722
18723

These batches were imported into Civi. I've placed the files on the server under the Engage folder.

Event Timeline

• LeanneS created this task.Jan 16 2019, 12:00 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 16 2019, 12:00 AM

Just digging in now & the first batch seems to be mostly different in the report vs advanced search because of one contribution which has batch 50755 but has Endowment Gift rather than Engage as the Financial Type. This batch isn't in the ssheet

civicrm/contact/view/contribution?reset=1&id=34924536&cid=2064433&action=view&context=contribution&selectedChild=contribute

The second batch has one Endowment - civicrm/contact/view?reset=1&cid=12817020

@LeanneS - I'm not seeing a discrepancy on civicrm/report/instance/75 for batches 18722 & 18723 - the only thing I did was change the report date range (which I didn't save) to 'Previous Month' as it's saved as 'Current Month' & these are December batches

Eileenmcnaughton added a project: Fundraising Sprint Bert and Ernie's Excellent Adventure.Jan 30 2019, 10:05 PM

Eileenmcnaughton claimed this task.Feb 1 2019, 4:14 AM

Eileenmcnaughton moved this task from Backlog to Doing on the Fundraising Sprint Bert and Ernie's Excellent Adventure board.

• DStrine moved this task from Triage to Current Sprint on the Fundraising-Backlog board.Feb 4 2019, 6:01 PM

• DStrine added a project: Fundraising Sprint Casino Royale With Cheese.Feb 5 2019, 9:28 PM

Thanks for clarifying! I'll make a note going forward of which batches we reclassify the financial type from Engage to Endowment gift. Okay to close.

Eileenmcnaughton closed this task as Resolved.Feb 6 2019, 10:58 PM

Eileenmcnaughton moved this task from Backlog to Done on the Fundraising Sprint Casino Royale With Cheese board.

Eileenmcnaughton set the point value for this task to 1.Jun 27 2019, 5:08 AM