Diagnostics Log
Every "Diagnose" run from the reconcile screen — deterministic checks and AI analyses — in one place. Review after a few closes to spot recurring causes; recurring AI-caught patterns are candidates for new automatic checks.
| When | Entity | Range | Gap | Source | Findings |
|---|---|---|---|---|---|
| 2026-07-15 14:59:46.714947+00:00 | unmapped-ngp | 2026-05-01 – 2026-05-31 | -$222,272.22 | AI |
No known pattern matched this gapAI analysis**Most likely cause: missing/unmapped designation (cause #5), not a timing or coding gap.** **Evidence:** - The row itself is "unmapped-ngp" — by definition this bucket is NGP contributions whose designation doesn't map to any Sage fund/entity. It isn't a real Sage fund, so there's little or nothing on the Sage side to net against it. - The deterministic checks ruled out all the usual explanations (late entry, wrong GL account, offsetting entity, stale feed, suspicious debit) — those checks look for line-level or gift-level matches elsewhere, and found none. That's expected here, because the "match" isn't missing on the Sage side at all — it's that NGP has ~$222k of gifts carrying designations with no entity mapping, so there's nothing for Sage to line up against. - A gap of this size in a single month, isolated to the unmapped bucket, is the classic signature of one or a few high-volume designations (e.g., a new appeal code, a renamed fund, or a bulk-imported list) that were never added to the designation→entity mapping table. **Next step:** 1. In 314 Sage Tools, drill into the unmapped-ngp row to list the underlying NGP designations/source codes for May 2026, sorted by dollar amount — this will surface the one or two designations driving the $222,272.22. 2. Check Sage for those same gifts: are they sitting in source code 9999998 (NEEDS DETAILS) awaiting the accrual reclass JE, or did they get force-coded to 9999999 by mistake? 3. Add the missing designation-to-entity mapping rule(s), then re-run reconciliation to confirm the gap clears and reallocates to the correct entity row. |
| 2026-07-15 14:59:20.229302+00:00 | unmapped-ngp | 2026-05-01 – 2026-05-31 | -$222,272.22 | checks |
No known pattern matched this gap |
| 2026-07-15 14:43:22.231220+00:00 | 201+202 | 2026-06-01 – 2026-06-30 | -$500.00 | AI |
17 gift(s) were entered in NGP after the Sage GL window ($265,670.11) One Sage GL line exactly matches the gap: $500.00 ($500.00) One Sage GL line exactly matches the gap: $500.00 ($500.00) 8 NGP gifts each equal the gap amount ($500.00) ($500.00) AI analysis**Most likely cause: Miscoded/uncoded Sage line sitting in "NEEDS DETAILS" (source 9999998), not yet reclassed to entity 201/202.** Evidence: The $500 gap is explained exactly by a Sage GL credit still parked under source code 9999998 — either the 6/7 entry (acct 40000, "ActBlue AF") or the 6/4 entry (acct 40520, "Annie Andrews Conduit Check"). Both are textbook "uncoded revenue" waiting on the monthly accrual reclass JE. Since that reclass hasn't run yet (or ran to the wrong entity), Sage is short exactly $500 relative to NGP — which matches the sign of your gap (Sage < NGP). **Why not the backdated-NGP warning:** Those 17 gifts total ~$265,670, far more than the $500 gap. If they were the driver here, the net difference would be much larger. They're a real, separate issue but not what's producing this specific $500 mismatch (they're likely already offsetting elsewhere in the combined 201+202 row). **Weak/ignore:** The 8 NGP gifts at $500 each are just a common amount — not meaningful on their own given a stronger, exact GL match exists. **Next step:** 1. In Sage, open the two GJB lines (6/4 and 6/7) and confirm which one's designation actually belongs to entity 201 or 202. 2. If it does, manually recode it from 9999998 to the correct fund/dept now rather than waiting for the monthly reclass JE, then re-run reconciliation. 3. Separately, book or acknowledge the 17 backdated batches so they don't mask future gaps. |
| 2026-07-15 14:42:46.370728+00:00 | 201+202 | 2026-06-01 – 2026-06-30 | -$500.00 | checks |
17 gift(s) were entered in NGP after the Sage GL window ($265,670.11) One Sage GL line exactly matches the gap: $500.00 ($500.00) One Sage GL line exactly matches the gap: $500.00 ($500.00) 8 NGP gifts each equal the gap amount ($500.00) ($500.00) |
| 2026-07-15 14:42:13.132516+00:00 | 201+202 | 2026-06-01 – 2026-06-30 | -$500.00 | checks |
17 gift(s) were entered in NGP after the Sage GL window ($265,670.11) One Sage GL line exactly matches the gap: $500.00 ($500.00) One Sage GL line exactly matches the gap: $500.00 ($500.00) 8 NGP gifts each equal the gap amount ($500.00) ($500.00) |
| 2026-07-15 14:28:20.258910+00:00 | unmapped-ngp | 2026-02-01 – 2026-07-15 | -$222,272.22 | checks |
The Sage GL feed doesn't cover the whole range yet |