Methodology
How the figures on this portal are produced, what they include, and — just as important — what they leave out and why.
How a figure gets here
- Accounting records are extracted from the Commission’s financial system of record. Nothing is hand-entered into this portal.
- The extract is transformed into a published snapshot. A snapshot is all-or-nothing: every screen, chart, drilldown and download uses one snapshot at a time. Separate page loads can use a newer completed publication as updates arrive; compare publication details when reconciling figures.
- Sums are computed by the database over every record that matches the filters on the screen. A page of results never determines a total.
- Restricted records are removed before publication by policy. They are excluded from rows, totals, searches and downloads alike, and their size is disclosed below.
Definitions
- Original budget
- The budget as adopted for the fiscal year, before in-year transfers, carryforwards or other amendments.Basis: Budget ledger lines for the year, 'original' lines only.
- Approved amendments
- In-year budget changes published in the reporting store: transfers in and out, and carryforwards.Basis: Budget ledger lines for the year, amendment line kinds.
- Revised budget
- Original budget plus approved amendments. Where a revised figure is published directly, that figure is used.Basis: Revised budget line, or original plus amendments when no revised line exists.
- Actuals (expenditure)
- Posted, committed ledger amounts for expenditure-class accounts in the fiscal year, including amounts in a period that is still provisional.Basis: Ledger entries in the fiscal year, expenditure-class accounts, debits positive.
- Revenue collections
- Posted revenue-class ledger amounts, shown as positive collections. The source signed value is retained internally and shown where relevant.Basis: Ledger entries in the fiscal year, revenue-class accounts, sign normalised to positive collections.
- Open encumbrances
- Committed but not yet expended balances from purchase orders and similar commitments, as at the published snapshot.Basis: Encumbrance budget lines for the year.
- Requisition reservations
- Requisition-stage reservations that have not become encumbrances or expenditures, as at the published snapshot.Basis: Requisition budget lines for the year.
- Available expenditure budget
- Revised budget minus actual expenditures, open encumbrances and requisition reservations. Shown only where the revised budget is greater than zero; otherwise the account shows a stated condition instead of a figure.Basis: Revised budget, actuals, encumbrance and requisition lines for the same year and account.
- Utilisation
- Actual expenditures as a percentage of the revised budget. Not shown when the revised budget is zero or negative.Basis: Actual expenditure ÷ revised budget.
- Committed
- Actual expenditures plus open encumbrances plus requisition reservations, as a percentage of the revised budget. Reported separately from utilisation.Basis: (Actual + encumbrance + requisition) ÷ revised budget.
- Payments (checkbook)
- Posted payment instruments in the fiscal year, one row per instrument. A void instrument is shown and counted separately from valid disbursements.Basis: Payment register rows for the year, excluding withheld categories.
- Payment allocation
- How a payment's net amount is distributed across invoices and general-ledger accounts. Allocation amounts sum to the payment's net amount; where they do not, the difference is shown as an allocation gap.Basis: Payment-to-invoice and invoice-to-ledger allocations in the same publication.
- Publication
- A complete, versioned snapshot of the published data. Every screen, drilldown, chart and export on this site uses one publication, so figures never mix versions.Basis: Publication identifier carried on every published fact row.
- Source cutoff
- The point in time through which the source system's records were included in this publication. It is not the time the data was extracted.Basis: Source cutoff recorded when the publication was staged.
- Provisional period
- A fiscal period that remains open in the accounting system and can still change. Later corrections and backdated entries can alter earlier periods.Basis: Ledger posting period status in the source system.
- Prior-year comparable
- Posted actuals for the same account in the preceding fiscal year. An absent prior year means no published history exists for that account, and is labelled rather than shown as zero.Basis: Ledger entries for the same account, prior fiscal year.
Formulas, exactly as computed
- available = revised budget − actual expenditures − open encumbrances − requisition reservations (shown only when revised budget > 0)
- utilisation % = actual expenditures ÷ revised budget × 100 (not shown when revised budget ≤ 0)
- revenue collections = −1 × revenue-class ledger amount (credit-balance ledger)
What years and volumes are covered
Measured from the published data itself, not from a calendar assumption. A year appears here only if it has published activity.
| Data set | Fiscal years | First date | Last date | Records | Note |
|---|---|---|---|---|---|
| General ledger entries | 2023–2026 | Jan 1, 2023 | Dec 31, 2026 | 1,046,918 | Ledger coverage is measured from posted entries, not from the fiscal calendar. |
| Budget lines | 2023–2026 | Not published | Not published | 34,134 | |
| Payments | 2023–2026 | Jun 1, 2022 | Nov 13, 2026 | 34,482 | |
| Payment allocations | Not determined | Not published | Not published | 141,240 |
Completeness by fiscal year and data set
Measured from the published records themselves, grouped by each data set’s own fiscal-year field — never from a fiscal calendar assumption. “No published activity” means no records exist for that year in that data set; it is not zero, and it is not plotted as zero. A year is labelled complete only when records are published and the year is closed in the source system: records existing is never, by itself, completeness.
| Data set | FY 2023 | FY 2024 | FY 2025 | FY 2026 |
|---|---|---|---|---|
| Payments | 7,751 closed year | 8,018 closed year | 10,020 closed year | 8,693 open year |
| Budget lines | 10,987 closed year | 10,168 closed year | 4,581 closed year | 8,398 open year |
| General ledger entries | 266,804 closed year | 262,572 closed year | 279,411 closed year | 238,131 open year |
Which fiscal years does this data set actually cover?
See every figure in “Published records by fiscal year — Payments” as a table
| Fiscal year | Published records |
|---|---|
| FY 2023 | 7,751 |
| FY 2024 | 8,018 |
| FY 2025 | 10,020 |
| FY 2026 | 8,693 |
Years With Data: 4 · Years Shown: 4 · Records: 34,482
Publication #2614 · measured from the published records themselvesHow this figure is computed
Which fiscal years does this data set actually cover?
See every figure in “Published records by fiscal year — Budget lines” as a table
| Fiscal year | Published records |
|---|---|
| FY 2023 | 10,987 |
| FY 2024 | 10,168 |
| FY 2025 | 4,581 |
| FY 2026 | 8,398 |
Years With Data: 4 · Years Shown: 4 · Records: 34,134
Publication #2614 · measured from the published records themselvesHow this figure is computed
Which fiscal years does this data set actually cover?
See every figure in “Published records by fiscal year — General ledger entries” as a table
| Fiscal year | Published records |
|---|---|
| FY 2023 | 266,804 |
| FY 2024 | 262,572 |
| FY 2025 | 279,411 |
| FY 2026 | 238,131 |
Years With Data: 4 · Years Shown: 4 · Records: 1,046,918
Publication #2614 · measured from the published records themselvesHow this figure is computed
Counts in the current publication
- Segment Values
- 283
- Vendors
- 4,402
- Accounts
- 29,749
- Payments
- 34,482
- Allocations
- 141,240
- Budget Lines
- 34,134
- Fiscal Years
- 4
- Gl Entries
- 1,046,918
What is excluded, and how much of it
| Exclusion | Records | Amount | Reason |
|---|---|---|---|
| Payments to withheld payee categories | 0 records | $0.00 | Withheld under the publication policy for payee categories that require entity-level review. These rows are excluded from every figure, chart and export on this site — not shown as blank rows. |
| Payments not marked for publication | 0 records | $0.00 | Flagged in the reporting store as outside the approved public scope for this release. |
| Withheld payees (count only) | 0 records | Not applicable | The number of withheld payees is published; their names and payment detail are not. |
Excluded records are removed before publication. They cannot be recovered from this portal by any filter, search, download or API parameter — including by guessing an identifier — and they are not counted in any total. This page states how many there are so that the totals can be understood.
Expenditure basis: net of interfund transfers
Published expenditure is net of transfers to other BREC funds. BREC moves money between its own funds — to Debt Service to pay bonds, to the Public School Fund for the one-eighth-mill transfer, to the Ecosystem and Environmental Operations Fund — and Munis books those movements as OBJECT-type expenditures, so a plain reading of the ledger counts them as spending. They are the same dollar arriving in a different BREC fund, where it is counted again as that fund’s spending.
Eight ledger objects are excluded, and they are the ledger’s own definition rather than a category invented here: 527801, 527806, 527807, 527809, 527810, 527811, 527812, 527813. In FY2026 that removed $1,614,671.75 of actual spending. The same rule is applied to the budget side, which matters: transfer appropriations in FY2026 were larger than the transfers that actually happened, so netting one column and not the other would have published a phantom, permanently underspent programme line.
Not excluded: bond and loan principal paid directly by this fund (real cash to bondholders), and payments to other governments for services. Setting APP_EXPENDITURE_BASIS=gross restores every expense row; that switch exists for reconciliation against Munis, not as a reader-facing option.
Bulk downloads
- Budget & actuals, filtered (CSV) — Applies the filters in the current URL, matches the on-screen totals.
- Payments, filtered (CSV) — Applies the filters in the current URL; withheld categories are absent from the file and disclosed on the screen.
Known limits of this data
- Amounts are US dollars. Figures shown to the cent are rounded to the cent for display; totals are summed from unrounded published values and then rounded, so a column may differ from its displayed rows by a cent.
- Revenue, expenditure, commitments and payments are different measures of different events. They are reported separately and are never added together.
- A payment date, an expenditure posting date and a budget adoption date are three different dates; comparisons across them are not like-for-like.
- Bank-cleared status is not published, so no payment on this site is labelled cleared.
- Fields with no approved public source are shown as 'not published' rather than inferred or filled with a default.
Machine access
Every screen is backed by a documented JSON API under /api with the same filters and the same totals; add format=csv to the accounts and payments endpoints for the filtered population as a file. Service status reports the live publication without any data. Publication version: 1.13.0.