Allocation Run #140 — 2026-09
14876 contribution rows processed
(2026-10-15 20:32:33.497829+00:00)
· Re-run this month
Entity Totals
Entity NGP Total Mapped Excluded Unmapped
101
$1343186.78
$1202327.45
$140859.33
$0
201
$2471901.93
$702716.61
$1769185.32
$0
202
$1021602.00
$1021602.00
$0
$0
301
$4350.00
$350.00
$4000.00
$0
401
$2196.47
$2196.47
$0
$0
403
$96693.92
$96693.92
$0
$0
NEEDS DETAILS total: $3035784.45
(101: $1202327.45 · 201: $547716.61 · 202: $1155000.00 · 301: $350.00 · 401: $2196.47 · 403: $96693.92 · 501: $31500.00)
— Sage balances from the
scheduled GL ingest,
reclass journal excluded.
Sage / NGP Cross-Check
Entity NGP Classified Total Sage Total Status
101
$1202327.45
$1202327.45
Match
201
$702716.61
$547716.61
INFO — pair
202
$1000000.00
$1155000.00
INFO — pair
301
$350.00
$350.00
Match
401
$2196.47
$2196.47
Match
403
$96693.92
$96693.92
Match
201/202 fund delta (INFO) — funds 201 and 202 are two
halves of the same PAC, and money moves between them on the books each
month, so compare them as a pair, not one at a time. The
fundraising-accrual JE reclasses between the pair; their individual
deltas are expected: 201 -155,000.00, 202 155,000.00.
They net to zero across the pair — nothing to adjust.
Organization Revenue
— $21602.00 across 1 gift(s)
from 1 contact(s)
Organization gifts book to 40300 Grants &
Institutional Funding instead of 40000 Individual Contributions.
Source codes mapped to their own account by nature of the revenue (event,
list rental, joint fundraising) are left alone. Change any of it below,
then re-run the month.
GL account Amount Gifts
40300 $21602.00 1
Review contacts — 1
shown. Set an exception for a donor NGP
flagged wrong, or send one donor to a different account.
Contact Amount Gifts Entity
GL Source code(s) Decided by Change
HMP
$21602.00
1
202
40300
IE Org default (40300)
10000 — C4 Main Checking Amalgamated 2808 10001 — C4 Main Checking BOA 3599 (closed) 10010 — C4 Operating Checking Amalgamated 2819 10011 — C4 Grant Checking Amalgamated 4435 (closed) 10012 — C4 Operating Checking BOA 3901 (closed) 10020 — C4 High Yield Checking First Bank 1724 10021 — C4 Savings Capital One - 9776 (closed) 10022 — C4 Money Market Meow 10030 — PAC Hard Dollar Main Checking Amalgamated 1939 10031 — PAC Hard Dollar Checking BOA 2425 (closed) 10032 — PAC Conduit Checking BOA 3846 (closed) 10040 — PAC Non Contribution Checking Amalgamated 1950 10041 — PAC Non Contribution Checking BOA 7788 (closed) 10050 — PAC Checking Direct Mail Amalgamated 9125 10060 — PAC High Yield Checking Hard Dollar First Bank 1004 10061 — PAC Savings Hard Dollar Capital One 5046 (closed) 10070 — PAC High Yield Checking Non Contribution First Bank 8139 10071 — PAC Savings Non Contribution Capital One 4000 (closed) 10080 — AVF Main Checking Amalgamated 0631 10081 — AVF Checking BOA 2513 (closed) 10082 — AVF Maine Amalg 0470 10090 — Impact Slate Hard Dollar Operating Checking Amalgamated 3511 10100 — Impact Slate Non Contribution Operating Checking Amalgamated 5260 10110 — Impact Slate Project Amalgmated 0232 10120 — Impact Slate Project Amalgmated 4567 10130 — Impact Slate Project Amalgmated 0556 10131 — Impact Slate Project Amalgmated 8262 (closed) 10132 — Impact Slate Project Amalgmated 3522 (closed) 10133 — Impact Slate Project Amalgmated 7504 (closed) 10134 — Impact Slate Project Amalgmated 0739 (closed) 10140 — C3 Main Checking Amalgamated 5800 10150 — C3 High Yield Checking Grasshopper 3907 10200 — C4 Brokerage Vanguard 2231 10210 — PAC Brokerage Hard Dollar Vanguard 0411 10220 — PAC Brokerage Non Contribution Vanguard 7618 10230 — C3 Brokerage Vanguard 0949 10240 — PAC Money Market Hard Dollar Meow 11000 — Short-Term Investments 11010 — Accounts Receivable (Control) 11020 — Grants Receivable 11030 — Pledges Receivable 11040 — List Rental Receivable 11090 — Intercompany Loan Receivable 11200 — Prepaid Expenses 11210 — Deposits 11230 — Undeposited Funds 12000 — Equipment IT & Office 12010 — Furniture & Fixtures 12090 — Accumulated Depreciation 13000 — Intangible Assets 13100 — Long-Term Investments 13200 — Intercompany Receivables 13300 — Deferred Costs or Assets 20000 — Accounts Payable (Control) 20100 — Credit Card Liabilities 20110 — Ramp Credit Card (Historical) 20120 — Ramp Credit Card C4 20130 — Ramp Credit Card PAC 20140 — Ramp Credit Card AVF 20150 — Ramp Credit Card Slate 20160 — Ramp Credit Card C3 20200 — Accrued Expenses 20300 — Payroll Liabilities 20310 — Payroll Liabilities - Health (Medical) 20320 — Payroll Liabilities - Dental & Vision 20330 — Payroll Liabilities - Retirement (401k) 20350 — Accrued PTO Liability 20360 — FSA Payable 20400 — Deferred Revenue 20500 — Inter-Entity Payables 20600 — Loans Payable 20610 — Intercompany Loan Payable 20900 — Other Current Liabilities 30000 — Net Assets Unrestricted 30010 — Net Assets Board Designated Operating Reserve 30020 — Net Assets Board Designated Programming 30100 — Retained Earnings 30110 — Current Year Net Income 40000 — Individual Contributions 40100 — Membership Revenue 40200 — Program Service Revenue 40300 — Grants & Institutional Funding 40400 — Event Revenue 40500 — Joint Fundraising Revenue 40510 — Joint Fundraising Transfer (Net Proceeds) 40600 — In-Kind Contributions (Non-Cash) 40700 — List Rental Income 40990 — Contribution Refunds 41000 — Interest Income 41100 — Loan Proceeds 41200 — Offsets 41900 — Other Operating Income 48100 — Realized Gains/Losses on Investments 48200 — Unrealized Gains/Losses on Investments 49010 — Transfer In - Personnel 49020 — Transfer In - Overhead 49030 — Transfer In - Consulting 49040 — Transfer In - Affiliate Transfer (PAC) 49050 — Transfer In - Contribution 49060 — Transfer In - Contribution Refund 49099 — Other Transfers In 49999 — NEEDS DETAILS - INCOME 50000 — General Consulting 50010 — Legal Services 50020 — Accounting & Compliance Services 50030 — Fundraising Consulting 50040 — Design Services 51000 — Software Subscriptions 51010 — ERP & Core CRM Systems 51020 — Data Tools / Analytics 51030 — Data Acquisition 51040 — Web Development, Design & Hosting 51050 — IT Equipment 51055 — Depreciation Expense – IT Equipment 51060 — IT Repairs 51070 — IT Services 51080 — Cybersecurity 52000 — Staff Travel 52010 — Events & Conferences 52020 — Meals & Entertainment 53000 — Rent 53010 — Utilities 53020 — Insurance (Non Personnel) 53030 — Office Repairs & Maintenance 53040 — Office Supplies 53050 — Office Equipment 53060 — Office Upgrades (Non-Capital) 53070 — PO Box Fees 54000 — Credit Card Processing Fees 54010 — Bank Fees 54020 — Donor Refunds 54030 — Bounced Checks 54040 — Merchandise/Gifts 54050 — List Rentals 54060 — Caging Services 54070 — List Management 54080 — Fundraising Revenue Sharing 55000 — Dues and Subscriptions 55010 — Fines & Regulatory Fees 55020 — Postage & Delivery 55030 — Printing (General) 55040 — Business Taxes & Filing Fees 55050 — Miscellaneous 56000 — Digital Advertising 56010 — TV Advertising 56020 — Direct Mail - Printing & Postage 56030 — Radio Advertising 56040 — Media Production 56050 — Polling (General) 56051 — Polling (Split) 56060 — Research 56070 — SMS / Text Messaging 56080 — Other Media Advertising 57000 — Contributions & Grants 57010 — Joint Fundraising Distributions 59999 — NEEDS DETAILS - EXPENSE 60000 — Salaries and Wages 61000 — Health Insurance 61010 — Dental & Vision Insurance 61020 — Retirement Benefits 61030 — Transit Benefits & Parking 61040 — Employer FSA Contributions 61050 — Fringe/Other Benefits 61060 — Recruitment & Hiring Expenses 61070 — Professional Development & Training 61080 — Life & Disability Insurance 62000 — Payroll Taxes 62010 — Workers Comp / Disability 62020 — Payroll Processing Fees 79010 — Transfer Out - Personnel 79020 — Transfer Out - Overhead 79030 — Transfer Out - Consulting 79040 — Transfer Out - Affiliate Transfer (PAC) 79050 — Transfer Out - Contribution 79060 — Transfer Out - Contribution Refund 79099 — Other Transfers Out 99999 — Needs Details Expense
Per-source-code exceptions (all org gifts on one code to a specific
account) live on the
Source Codes tab as
Org GL .
Severity Category Source Code / Batch Amount Rows Detail
WARNING
Sage / NGP mismatch
Entity 201: Sage total (NEEDS DETAILS $547716.61 + already coded $0.00 = $547716.61) != NGP classified total ($702716.61). Difference: $-155000.00. JE uses Sage debit amount; investigate before importing.
WARNING
Sage / NGP mismatch
Entity 202: Sage total (NEEDS DETAILS $1155000.00 + already coded $0.00 = $1155000.00) != NGP classified total ($1000000.00). Difference: $155000.00. JE uses Sage debit amount; investigate before importing.
INFO
In-kind (book by hand)
21602.00
1
1 in-kind gift(s) ($21,602.00) in entity 202 left off the accrual JE — non-cash, never deposited, so not in NEEDS DETAILS. Book by hand in Sage: debit the expense/asset received, credit 40600 In-Kind. Gifts: HMP $21,602.00 (contribution 21588997).
Excluded by mapping — 5 line(s),
not contribution revenue (transfers, offsets, refunds, grants, payroll,
conduit). Already subtracted; here for the audit trail.
Source Code / Batch Amount Rows Detail
1066202 Interest
1930.91
2
2 rows ($1930.91) excluded: 1066202 (Interest) — Separate GL (41000) already coded.
1052693 314 Transfer
1771929.68
12
12 rows ($1771929.68) excluded: 1052693 (314 Transfer) — Inter-entity transfer.
1105018 Payroll Allocation
139558.08
2
2 rows ($139558.08) excluded: 1105018 (Payroll Allocation) — Not fundraising revenue.
1059026 Offset
525.98
1
1 rows ($525.98) excluded: 1059026 (Offset) — Separate GL (41200) already coded.
1052577 Earmark - Conduit
100.00
2
2 rows ($100.00) excluded: 1052577 (Earmark - Conduit) — Earmark conduit.
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)
Line Entity GL Dept Memo Debit Credit Function Project ClassID
1
101
40000
9998
SEP 26 Source Code Allocation - C4
1202327.45
FR
9999
9999998
2
101
40000
2100
Email
418.00
FR
9999
1052620
3
101
40000
2100
Texting
230.00
FR
9999
1052650
4
101
40000
2100
Recurring
6739.58
FR
9999
1052774
5
101
40000
3100
Strategic Support Contributions
1000000.00
FR
9999
1052788
6
101
40000
2300
Misc Checks
50.00
FR
9999
1052794
7
101
40000
2200
National Travel
5000.00
FR
9999
1052795
8
101
40000
2200
Calltime/Major Donor
137805.00
FR
9999
1052799
9
101
40000
2300
Direct Mail (Grassroots)
1200.00
FR
9999
1117033
10
101
40000
2300
HD Direct Mail
7560.00
FR
9999
1117034
11
101
40000
2100
Middollar Texting Digital
33942.87
FR
9999
1123306
12
101
40000
2100
Middollar Email Digital
9382.00
FR
9999
1123308
Line Entity GL Dept Memo Debit Credit Function Project ClassID
1
201
40000
9998
SEP 26 Source Code Allocation - PAC
547716.61
FR
9999
9999998
2
202
40000
9998
SEP 26 Source Code Allocation - PAC
1155000.00
FR
9999
9999998
3
201
40000
2100
Email
109847.43
FR
9999
1052620
4
201
40000
2100
Texting
35256.97
FR
9999
1052650
5
201
40000
2100
Website
18030.23
FR
9999
1052772
6
201
40000
2100
Ads
111142.16
FR-ACQ
9999
1052773
7
201
40000
2100
Recurring
72713.06
FR
9999
1052774
8
201
40000
2300
Misc Checks
10840.51
FR
9999
1052794
9
201
40000
2200
Calltime/Major Donor
282629.00
FR
9999
1052799
10
201
40000
2300
Direct Mail (Grassroots)
53488.14
FR
9999
1117033
11
201
40000
2300
HD Direct Mail
5.00
FR
9999
1117034
12
201
40000
2300
Direct Mail - Acquisition
6703.00
FR-ACQ
9999
1118169
13
201
40000
2100
Middollar Texting Digital
632.00
FR
9999
1123306
14
201
40000
2100
Middollar Email Digital
1429.11
FR
9999
1123308
15
202
40000
3100
Strategic Support Contributions
1000000.00
FR
9999
1052788
Line Entity GL Dept Memo Debit Credit Function Project ClassID
1
401
40000
9998
SEP 26 Source Code Allocation - IS-HD
2196.47
FR
9999
9999998
2
401
40000
2100
Email
186.47
FR
9999
1052620
3
401
40000
2300
Misc Checks
25.00
FR
9999
1052794
4
401
40000
2300
Direct Mail (Grassroots)
1985.00
FR
9999
1117033
Line Entity GL Dept Memo Debit Credit Function Project ClassID
1
403
40500
9998
SEP 26 Source Code Allocation - IS-JF (JF-2026-AUG-PRIORITY)
33251.92
PRO-JF
JF-2026-AUG-PRIORITY
9999998
2
403
40500
2100
Email
778.00
PRO-JF
JF-2026-AUG-PRIORITY
1052620
3
403
40500
2100
Texting
317.00
PRO-JF
JF-2026-AUG-PRIORITY
1052650
4
403
40500
2100
Recurring
316.00
PRO-JF
JF-2026-AUG-PRIORITY
1052774
5
403
40500
2300
Direct Mail (Grassroots)
31772.92
PRO-JF
JF-2026-AUG-PRIORITY
1117033
6
403
40500
2100
Middollar Texting Digital
50.00
PRO-JF
JF-2026-AUG-PRIORITY
1123306
7
403
40500
2100
Middollar Email Digital
18.00
PRO-JF
JF-2026-AUG-PRIORITY
1123308
8
403
40500
9998
SEP 26 Source Code Allocation - IS-JF (JF-2026-FINALSTRETCH)
63442.00
PRO-JF
JF-2026-FINALSTRETCH
9999998
9
403
40500
2100
Email
50861.00
PRO-JF
JF-2026-FINALSTRETCH
1052620
10
403
40500
2100
Texting
5903.00
PRO-JF
JF-2026-FINALSTRETCH
1052650
11
403
40500
2100
Website
100.00
PRO-JF
JF-2026-FINALSTRETCH
1052772
12
403
40500
2200
Calltime/Major Donor
1000.00
PRO-JF
JF-2026-FINALSTRETCH
1052799
13
403
40500
2300
Direct Mail (Grassroots)
1235.00
PRO-JF
JF-2026-FINALSTRETCH
1117033
14
403
40500
2100
Middollar Texting Digital
2443.00
PRO-JF
JF-2026-FINALSTRETCH
1123306
15
403
40500
2100
Middollar Email Digital
1900.00
PRO-JF
JF-2026-FINALSTRETCH
1123308
Downloads
Next steps: import the exported CSV(s) into Sage Intacct, then
re-check the reconciliation for 2026-09
— or head back to the
Close dashboard
for the rest of the month-end checklist.