Your Wild Apricot reconciliation report shows a mismatch
Your reconciliation report flagged one or more rows, wouldn’t let you drill in, or gave you an error when you tried to create it.
What’s happening
Section titled “What’s happening”A few different situations can show up here:
- A row is flagged. The count or amount MapleGather imported doesn’t match what you reported from Wild Apricot for that row — this is exactly what the report is designed to catch.
- A flagged row has no “Drill in” option. Some Wild Apricot data only comes as a total, with no way to see the individual records behind it. The report tells you this plainly and points you to a manual check — it isn’t an error, just a limit of what the source data can tell you.
- “Pick exactly one source.” When creating the report, you need to choose either a Wild Apricot connection or CSV imports — not both, and not neither.
- “Enter every source total.” If you’re reconciling against a CSV import, every source total (contacts, levels, payments, donations, registrations) needs a value before the report can be created.
How to fix it
Section titled “How to fix it”- For a flagged row you can drill into, select Drill in to see the specific records — each comes with a reason, like a missing email address or a duplicate that was skipped. Fix the source data in Wild Apricot and re-import, or accept the row as expected.
- For an aggregate-only row (no “Drill in” available), treat the note as a heads-up to check that data manually in Wild Apricot rather than something MapleGather can isolate for you.
- If report creation was rejected for having both or neither scope selected, choose exactly one: a Wild Apricot connection, or CSV imports with manual totals.
- If report creation asked for missing totals, go back and fill in every required field — active and archived contacts, members by level, and the count and amount for payments, donations, and event registrations.
If that didn’t work
Section titled “If that didn’t work”If a row stays flagged after you’ve re-imported corrected data, run a fresh reconciliation report — the original report reflects the data at the time it was created and doesn’t update automatically. If the numbers still don’t add up, the gap is in the data the report compared: for a CSV-scope report, check the source totals you entered — a mistyped total flags its row — and create the report again; otherwise select Drill in on the row to see the records behind the gap, or, for an aggregate-only row, compare that figure in Wild Apricot by hand.