Accounting › Planning & Control
Fund Accounting
Funds, grants, programs and functions on every line, and the rules that put them there — so a clerk keys the cost center and the ledger knows which fund paid and which award it is charged to.
In Accounting → Planning & Control · 12 screens
WorkspaceDerivation StudioWrite the rules that derive fund, grant, program and function — conditions in AND/OR groups or an expression, actions that set a value, copy a field, look one up or compute it — and test them against a line before they touch a posting.OpenRecordsFundsEach fund is a self-balancing set of accounts with its own restrictions. The type decides the category: governmental, proprietary or fiduciary.OpenRecordsGrantsEvery award: who gave it, its Assistance Listing number, its period of performance and the fund it belongs to. A cost outside the period, or in another fund, is refused at posting.OpenRecordsPrograms & FunctionsWhat the money was for (a program) and the statement of activities column it reports under (a function).OpenRecordsDerivation Rule SetsOne set per thing derived, run in sequence so a later set can read what an earlier one decided. First match stops at the first rule that fires; all applicable lets each refine the last.OpenRecordsDerivation RulesEvery rule as a record. The Derivation Studio draws the condition as a builder; here it is the JSON it is saved as.OpenRecordsDerivation Lookup TablesOne, two or three key fields to a value: a hundred cost centers to their funds is one table, not a hundred rules.OpenRecordsDerivation Lookup RowsA key, or two or three, and the value it gives. * matches anything; the most specific row wins.OpenRecordsFund Accounting SettingsWhether every line this company posts must carry a fund, and whether the derivation rules run at all.OpenViewDerived PostingsEvery posted line with its fund, grant, program and function, and which rule put each there.OpenRecordsBudget TransfersMoney moved between budget lines or funds during the year, or the adopted amount amended — each one numbered, approved by a second person, and audited. On approval the lines’ planned and available amounts change.OpenRecordsGrant ClaimsA reimbursement claim to the grantor for what the grant has spent to the end of the period, less what was claimed before. Approved by a second person, it raises the grantor’s invoice in the grant’s fund, ready to post.Open
Columns, fields and actions
| Screen | Kind | What it is | Columns | Fields | Actions |
|---|---|---|---|---|---|
| Derivation Studio | Workspace | Write the rules that derive fund, grant, program and function — conditions in AND/OR groups or an expression, actions that set a value, copy a field, look one up or compute it — and test them against a line before they touch a posting. | 0 | 0 | 0 |
| Funds | List | Each fund is a self-balancing set of accounts with its own restrictions. The type decides the category: governmental, proprietary or fiduciary. | 8 | 10 | 0 |
| Grants | List | Every award: who gave it, its Assistance Listing number, its period of performance and the fund it belongs to. A cost outside the period, or in another fund, is refused at posting. | 12 | 17 | 0 |
| Programs & Functions | List | What the money was for (a program) and the statement of activities column it reports under (a function). | 4 | 5 | 0 |
| Derivation Rule Sets | List | One set per thing derived, run in sequence so a later set can read what an earlier one decided. First match stops at the first rule that fires; all applicable lets each refine the last. | 9 | 12 | 0 |
| Derivation Rules | List | Every rule as a record. The Derivation Studio draws the condition as a builder; here it is the JSON it is saved as. | 11 | 17 | 0 |
| Derivation Lookup Tables | List | One, two or three key fields to a value: a hundred cost centers to their funds is one table, not a hundred rules. | 6 | 6 | 0 |
| Derivation Lookup Rows | List | A key, or two or three, and the value it gives. * matches anything; the most specific row wins. | 7 | 9 | 0 |
| Fund Accounting Settings | List | Whether every line this company posts must carry a fund, and whether the derivation rules run at all. | 3 | 3 | 0 |
| Derived Postings | Read-only list | Every posted line with its fund, grant, program and function, and which rule put each there. | 11 | 0 | 0 |
| Budget Transfers | List | Money moved between budget lines or funds during the year, or the adopted amount amended — each one numbered, approved by a second person, and audited. On approval the lines’ planned and available amounts change. | 18 | 7 | 4 |
| Grant Claims | List | A reimbursement claim to the grantor for what the grant has spent to the end of the period, less what was claimed before. Approved by a second person, it raises the grantor’s invoice in the grant’s fund, ready to post. | 15 | 8 | 4 |