Based on McKinney Select Data

Trial-balance actuals, check-register detail, FY26 adopted budget, and a 10-year forecast — in one interactive view.

What this dashboard does

It takes ~30 years of general-ledger trial balance, the full check-register history, and the FY26 adopted budgets from the enterprise financial system, embeds them into a single self-contained page, and lets you explore them without any back-end software. Every chart, sparkline, and forecast is computed in your browser from the data baked into the file — no server calls.

Tabs

• 📖 Introduction — this page.
• 📊 Financial Data — the main analysis: filterable hierarchy, sparklines, CAGR, forecasts to 2036, and check-register drilldown.
• 📋 Chart of Accounts — searchable, editable view of every COA element with usage history.

Reading the main table

Hierarchy vs Flat mode

• Hierarchy (default) — expand Fund → Dept → Division → Element → Object → Account.
• Flat — every account on one row, sortable by any column.

Click any year-column header to sort by that year's value. Click a fund/dept name to expand or collapse.

Number coloring (anomaly-only red)

• Gold — value is in the expected direction for that account type. Revenue showing negative is normal (credit balance); expense showing positive is normal.
• Red — sign is opposite of expected. Revenue showing positive (refund/anomaly), or expense showing negative (correction). These rows deserve a second look.

Total / aggregate rows stay gold to keep them visually quiet.

Sparklines

Mini line charts in the center of each row show the trend across whichever year range you've selected. For revenue and liability accounts, the line is automatically flipped so that growing magnitude (more revenue, more debt) trends visually upward. The history sparkline sits to the left of the center block; the forecast sparkline sits to the right.

CAGR columns (H-CAGR, F-CAGR)

Compound annual growth rate across the visible history (H) and forecast (F) windows. Gold when the trend is favorable for that account type, red when unfavorable.

Forecasts (2026 – 2036)

• 2026 base = adopted budget (if available for that account), otherwise the 3-year historical average.
• 2027 – 2036 = previous year × (1 + population_growth + CPI + E-Factor), compounded annually. Population growth comes from interpolated McKinney estimates baked into the page.
• Change Rev CPI, Exp CPI, or E-Factor in the top bar and the entire forecast (and the sparklines and CAGRs) recalculates immediately.

Filtering

The control bar at the top of the Financial Data tab has six dropdowns and four type checkboxes:

• Fund / Dept / Division / Element / Object — cascading. Pick a fund and the other dropdowns narrow to what's inside it. The dashboard opens with GENERAL FUND pre-selected.
• Type checkboxes — seven categories, all on by default:
  • A Asset · L Liability · E Expenditure · R Revenue (standard four)
  • F Fund Balance / Equity — closing-entry / accumulated-surplus accounts. With F on, each fund's row totals zero out as they should in a balanced trial balance.
  • T Transfers — interfund / interagency transfers (detected by object name).
  • D Due To / Due From — interfund receivables and payables.
  Unchecking all of them strands the dashboard (no rows visible); click Reset to recover.
• History years — show 5 or 10 years of history.
• View — History only, Both (default), or Forecast only.

Drilling into A/P transactions

Rows that have underlying check-register detail are marked with a clipboard icon (📋):

• Bright 📋 on an account row — click to open the transaction modal.
• Dim 📋 on a parent row — there's check-register detail somewhere underneath; expand to find it.
• No icon — purely aggregate rollup, no transactions stored against this rollup level itself.

Inside the modal: sortable by FY, Date, Payment #, Vendor, Description, or Amount. Sorting by anything other than Date or Amount switches to a grouped view (e.g., all checks per vendor) with auto-expanded subtotals — click the ▶ triangle on any subtotal row to collapse just that group.

Themes

Three palettes via the top-bar toggle: Blue (default, dark), Green (dark with green accents), and Print (black-and-white, optimized for printed reports and screenshots).

Known data quirks

• About 2.3% of trial-balance rows have an empty AccountType in the source data. They won't appear under any A/E/L/R filter — they need to be classified in the underlying system.
• ~16k rows fall under an OBJ MISSING placeholder object code. Those are accounts whose object-segment couldn't be resolved against the COA master.
• The dashboard is read-only against the operational database. Edits in the Chart of Accounts tab are stored locally in browser storage as a working copy — they don't write back to the source system. Use the CSV export there to push changes through your normal COA-maintenance process.