Run #6 — 2025-05

Allocation Run #6 — 2025-05

19170 contribution rows processed (2026-04-07 17:58:02.797021+00:00) · Re-run this month

⚠ Journal entry does not balance — Sage will reject it on import.

Debits must equal credits. A gap here almost always means a miscoding in Sage — a line booked to the wrong source code or dimension (e.g. source 9999999 "not applicable" instead of 9999998 "needs details"), so the balance the debit reverses doesn't match NGP. Fix it in Sage, re-pull the GL, and re-run.

JE REV-ACCR-2025-05-IS-JF does not balance. Debits: $24904.00, Credits: $39576.83, Difference: $-14672.83. Sage debit differs from NGP credits; investigate before importing.

Open the reconcile screen for this month and use Diagnose on the off row →

Entity Totals

Entity	NGP Total	Mapped	Excluded	Unmapped
401	$900.0000	$900.0000	$0	$0
403	$39576.8300	$39576.8300	$0	$0

Sage / NGP Cross-Check

Entity	NGP Classified Total	Sage Total	Status
401	$900.00	$900.00	Match
403	$39576.83	$24904.00	MISMATCH

Error Log

Severity	Category	Amount	Rows	Detail
WARNING	Sage / NGP mismatch			Entity 403: Sage NEEDS DETAILS ($24904.00) != NGP classified total ($39576.83). Difference: $-14672.83. JE uses Sage debit amount; investigate before importing.
WARNING	JE does not balance			JE REV-ACCR-2025-05-IS-JF does not balance. Debits: $24904.00, Credits: $39576.83, Difference: $-14672.83. Sage debit differs from NGP credits; investigate before importing.
INFO	Entity not in this run	464307.9900	17791	Entity 314 Action Fund - Hard Dollar not selected for this run — 17791 rows, $464307.9900 skipped.
INFO	Entity not in this run	300841.5500	495	Entity 314 Action not selected for this run — 495 rows, $300841.5500 skipped.
INFO	Entity not in this run	24500.0000	2	Entity 314 Action Victory Fund not selected for this run — 2 rows, $24500.0000 skipped.

Journal Entries

Badge meanings — exported CSV downloaded, not yet seen posted in Sage · posted found posted in Sage · superseded replaced by a newer export · error needs attention · ⚠ Sage totals mismatch (see JE Registry)

REV-ACCR-2025-05-IS-HD (3 lines, Debits: $900.00, Credits: $900.00)

superseded Export REV-ACCR-2025-05-IS-HD

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
1	401	40000	9998	MAY 26 Source Code Allocation - IS-HD	900.00		FR	9999	9999998
2	401	40000	2300	Direct Mail (Grassroots) - Appeals		500.00	FR	9999	1117033
3	401	40000	2100	Website		400.00	FR	9999	1052772

REV-ACCR-2025-05-IS-JF (9 lines, Debits: $24904.00, Credits: $39576.83)

exported Export REV-ACCR-2025-05-IS-JF

Line	Entity	GL	Dept	Memo	Debit	Credit	Function	Project	ClassID
1	403	40500	9998	MAY 26 Source Code Allocation - IS-JF (JF-2025-Q2-PRIORITY)	24804.00		PRO-JF	JF-2025-Q2-PRIORITY	9999998
2	403	40500	2200	Calltime/Major Donor		657.00	PRO-JF	JF-2025-Q2-PRIORITY	1052799
3	403	40500	2300	Direct Mail (Grassroots) - Appeals		18140.83	PRO-JF	JF-2025-Q2-PRIORITY	1117033
4	403	40500	2100	Email		12609.00	PRO-JF	JF-2025-Q2-PRIORITY	1052620
5	403	40500	2100	Recurring		448.00	PRO-JF	JF-2025-Q2-PRIORITY	1052774
6	403	40500	2100	Texting		2737.00	PRO-JF	JF-2025-Q2-PRIORITY	1052650
7	403	40500	2100	Website		4885.00	PRO-JF	JF-2025-Q2-PRIORITY	1052772
8	403	40500	9998	MAY 26 Source Code Allocation - IS-JF (JF-2026-MISC-GOPH-V2)	100.00		PRO-JF	JF-2026-MISC-GOPH-V2	9999998
9	403	40500	2100	Website		100.00	PRO-JF	JF-2026-MISC-GOPH-V2	1052772

Downloads

Download full JE CSV Download Error Log

Next steps: import the exported CSV(s) into Sage Intacct, then re-check the reconciliation for 2025-05 — or head back to the Close dashboard for the rest of the month-end checklist.