Short answer
Functional Expense Allocation Studio lets finance teams define allocation bases for shared costs like rent, payroll, utilities, and software. GrantPipe applies those percentages when it builds the Statement of Functional Expenses, so the report ties out without changing the posted general ledger.
The problem
Your rent bill hits one account. Your payroll hits one account. Your software bill hits one account. At audit time, those shared costs still need to land across program, management, and fundraising.
That is where the spreadsheet starts. Someone copies the trial balance, applies percentages, fixes rounding by hand, and hopes the Statement of Functional Expenses still ties out.
How GrantPipe solves it
GrantPipe lets you set allocation bases for shared costs. A base can use headcount, square footage, time study, or a manual percentage split.
You bind each shared expense account to one active base. When GrantPipe builds the Statement of Functional Expenses, it splits that account’s balance across program, management, and fundraising. The general ledger stays unchanged.
What you set up
You start with a base. A base is the rule for how one shared cost should split.
For rent, you might use square footage. For shared staff time, you might use a time study. For software or insurance, you might use a manual split your finance team has approved.
Each base has targets. A target can be program, management, or fundraising. A program target can also point to a specific program. That gives your team a clean program detail view below the functional class total.
GrantPipe checks the weights before it saves the base. The weights must add to 100 percent. If they do not, the app stops the save and shows what needs work.
What happens at report time
After the base exists, you connect it to one shared expense account. Only one active rule can apply to that account at a time. This keeps the report clear and avoids two rules fighting over the same balance.
When you run the Statement of Functional Expenses, GrantPipe reads the posted expense balance. Then it applies the active base for that date range. The report shows the split by natural account and functional class.
The posted ledger does not change. The report is the place where the split happens. That makes it easier to explain the work to your board, your accountant, and your auditor.
Why the ledger stays clean
Functional expense allocation is a reporting rule in GrantPipe. It is not a journal entry.
That matters. Your rent entry stays posted as rent. Your payroll entry stays posted as payroll. The report shows how each balance should be split for ASC 958-720.
This keeps the audit trail easier to read. It also means you can change an allocation base later without rewriting old journal entries.
How the math works
Each target stores a weight in basis points. Ten thousand basis points equals 100 percent.
GrantPipe checks that each base totals 100 percent before saving it. When a report runs, GrantPipe splits each balance with largest-remainder math. That means every row adds back to the original account total, down to the cent.
What it replaces
- The spreadsheet used to split shared costs
- Manual rounding fixes on the Statement of Functional Expenses
- Side journal entries that only exist for reporting
- The audit question about how shared costs were split
A simple example
Say your nonprofit spends $12,000 on rent for the quarter. The office is 70 percent program space, 20 percent management space, and 10 percent fundraising space.
You create a square-footage base with those weights. Then you bind the rent account to that base.
When the report runs, GrantPipe shows $8,400 as program, $2,400 as management, and $1,200 as fundraising. The original rent account still ties to $12,000. Nothing is lost to rounding.
If the office layout changes, you can create a new base for the next period. The old report can still show the old method. The new report can use the new method.
Who it is for
Finance leads use it to close the year without a spreadsheet.
Executive directors use it to trust the board packet and audit draft.
Auditors use the method labels and saved percentages to review the split.
Start a free trial
Related feature pages
See grant budget sentinel. See restricted fund tracking. See accounting anomaly detector. See pricing and plan fit.
Try it free
See this in GrantPipe.
Start a 1-month free trial. No credit card. Test it against your real grants and funds.
Source: FASB ASC 958-720
Q&A
How does GrantPipe keep the report tied out?
GrantPipe splits each account balance by basis points. It uses largest-remainder math, so rounding never creates or loses a cent. The program, management, and fundraising columns add back to the original account total.
Q&A
Why not post allocation journal entries?
Allocation entries can make the ledger harder to audit. GrantPipe treats allocation as a reporting rule. The original expense entry stays intact. The report shows the split only when you need the Statement of Functional Expenses.
Q&A
Can program costs be split by program too?
Yes. A program target can point to a specific program. The report also returns a program breakdown so program costs can be reviewed below the functional class total.
Frequently asked