Part 3 of 15 Construction Cost Categories for School Capital Programs: The 7-Bucket System That Makes Reporting Automatic
- Lettie Boggs

- 27 minutes ago
- 7 min read
Stop wrestling with spreadsheets every month—here's the category architecture that turns thousands of transactions into board-ready reports
If you're spending more than 10 minutes creating a budget rollup report, your object codes aren't organized properly—and you're about to waste hours of your life every single month.

If your object codes don't roll up cleanly, every report becomes hand-to-hand combat with Excel. I've watched facilities directors stay late on a Friday, rebuilding pivot tables just to show the board where construction dollars went. That shouldn't be your life.
When object codes do roll up into clear categories, dashboards snap into place, audits move faster, and leadership sees a story—not a 47-tab spreadsheet they have to decode.
This post gives you a proven category architecture that turns raw accounting codes into decision-ready summaries with almost no manual effort.
The immediate win
One-click reporting: Roll thousands of line items into 6–8 categories your board actually understands.
Cleaner audits: Auditors tie totals to meaningful categories without decoding your district's internal quirks or calling you for clarification.
Fewer coding errors: Staff code invoices to object codes confidently because the category rollup is obvious and logical.
When your category structure is right, creating reports stops feeling like a chore and starts feeling automatic.
The principle: Design from the summary, not the ledger
Here's the mistake most districts make: they inherit an object code structure from 1987, then try to force modern reports out of it. That's backwards.
Start with the headlines you must show leadership and the public. Build categories to match those headlines. Then map your object codes into them.
When you know how the story ends, the middle practically writes itself.
The core set (use these and stop improvising)
You want 7 categories that cover a school capital program end to end. Name them clearly. Use them consistently. Don't get creative.
A — Site Acquisition & Approval Land purchase, environmental approvals, entitlements, due diligence, relocation costs.
B — Planning & Design Architect, engineering consultants, surveys, geotechnical studies, DSA plan review, cost estimating.
C — Construction (Hard Costs) General contractor pay apps, trade packages, CM-at-risk contracts, allowances carried in the GMP.
D — Construction Administration Project and program management directly tied to delivering construction—your owner's rep, CM agency services, project controls staff supporting active builds.
E — Tests & Inspections Materials testing, special inspections, commissioning, third-party quality verification.
F — FF&E / Technology / Fixtures Initial equipping to occupy and operate: furniture, classroom technology, media systems, specialty equipment.
G — Contingency Separated into Construction, Project, and Program contingency—three distinct lines, not one mystery pot that everyone raids.
You don't need 30 categories. You need the right seven, with clear owners and consistent usage.
I know it's tempting to add "just one more category" for whatever your board asked about last month. Resist that temptation. Seven categories handled well beats 15 categories handled inconsistently.
Map objects to categories (once), then lock it down
Here's how to build the mapping that makes everything else easy:
One object code → one category. Period. No double lives. If an object code could mean two different things depending on context, you need to split the object code—not leave the category ambiguous.
Prefer specific object codes over relying on description fields. Free-text notes don't roll up into anything useful. Object codes do.
Don't hide the border cases. If legal services, district-wide advertising, or general administrative costs are truly operational (not project-specific), keep them out of your capital structure and document the exception clearly in your policy.
Here are example mappings to get you started (adapt these to your actual chart of accounts):
A – Site Acquisition & Approval:
Land purchase (6100)
Escrow and title services (6150)
CEQA/DTSC environmental clearance (6175)
Appraisals and feasibility studies (6110)
Relocation and right-of-way costs (6140)
B – Planning & Design:
Architect basic services (5800 subset or dedicated 6200s)
Engineering consultants—MEP, structural, civil (6210–6230)
Surveying and geotechnical (6240–6250)
DSA plan review fees (6270)
Cost estimating services (6280)
C – Construction:
GC pay applications (6300–6399)
Direct trade contracts (if multi-prime)
Allowances used/consumed
Builder's contingencies drawn (if visible)
GC general conditions (if separated in contract)
D – Construction Administration:
Owner's representative or CM agency (5800 subset or 6400s)
Program controls staff allocated to active jobs
Jobsite-specific administrative support
E – Tests & Inspections:
Soils and materials testing (6500)
Special inspection agencies (6510)
Commissioning agent (6520)
F – FF&E / Technology / Fixtures:
Classroom furniture packages (6600)
Lab and specialty equipment (6610)
Audio-visual and presentation systems (6620)
Network infrastructure for occupancy (6630)
G – Contingency:
Construction Contingency (separate line for contract-based change orders)
Project Contingency (separate line for scope additions)
Program Contingency (separate line for unforeseen program needs)
Your numbers will be different. The structure shouldn't be.
Governance: who owns which bucket?
This is critical and often overlooked. If a category doesn't have a clear owner, your reports will wobble and no one will feel accountable for the budget:
C (Construction) → Project Manager + GC/CM (spending against contract, managing the work)
B (Planning & Design) → Design Manager (scope alignment, change control, consultant coordination)
D (Construction Admin) → Program Director (staffing plan, allocation methodology, program support)
E (Tests & Inspections) → Quality/Compliance Lead (duration-based budget, inspection schedule)
F (FF&E/Tech) → End-User Department / Ed Tech Lead (standards, phased release, training)
G (Contingency) → Different owners by layer:
Construction Contingency: PM and GC (draw rules in contract)
Project Contingency: Project Sponsor (managing change order exposure)
Program Contingency: Program Director and CBO (portfolio risk management)
When I see budget confusion, it's usually because no one clearly owns a category. Fix that first.
Reporting that actually "clicks"
With a clean category structure, create four standard views that will cover 90% of leadership requests:
Portfolio Rollup A–G category totals by program and funding source. One slide, complete picture.
Project Snapshot Budget vs. committed vs. actual by category (A–G), with variance notes and contingency draw status. Everything your PM needs in one view.
Contingency Glidepath Beginning balance, releases, uses, and remaining balance by layer (Construction/Project/Program). No mystery about where contingency went.
FF&E Release Plan Planned vs. released vs. installed by site and phase. Keeps equipment procurement from becoming a last-minute panic.
With a solid category map, these views require zero manual spreadsheet gymnastics. They just... work. Every time.
Avoid the traps that wreck rollups
I've seen these mistakes destroy otherwise good accounting systems. Don't repeat them:
Trap 1: Category sprawl
Every time someone adds "just one more category" because the board asked a specific question once, your reporting loses clarity instead of gaining it.
Fix: Keep it at seven categories. If a special use case comes up quarterly, handle it with a filtered sub-report—not by adding a permanent eighth headline bucket that clutters every dashboard.
Trap 2: Blending capital and operational costs
Operational costs (your infamous 5800s) love to sneak into capital projects. "It's kind of related to the project" becomes "we'll just charge it here."
Fix: Publish a two-column "Capital vs. Ops" cheat sheet with real examples from your district. Enforce it at invoice entry, not during audit prep.
Trap 3: Single, unlabeled contingency line
One fat contingency line with no sub-categories invites misuse, hides actual risk exposure, and makes burn-rate analysis impossible.
Fix: Split contingency into three visible layers with stated owners, clear purposes, and documented release rules. When people know which pot they're dipping into, behavior changes.
Trap 4: Depending on free-text descriptions
If your budget analysis requires reading the invoice description field to figure out what category something belongs in, your object code architecture has failed.
Fix: Add or refine object codes so the meaning lives in the code itself, not in someone's invoice notes. Codes roll up. Comments don't.
Trap 5: Vendor-based categories
Vendors do multiple types of work. Your architect might do design, construction administration, and DSA responses. Roll up the work being done, not the company logo on the invoice.
Fix: Force correct object coding even when a vendor provides multiple services. The invoice description might say "ABC Architects," but the work could span categories B, D, and E.
Quick start (one-week implementation)
You don't need a consultant for this. You need one focused week:
Day 1: Draft your A–G category definitions. Assign clear owners to each category. Get CBO sign-off.
Day 2: Map each of your existing object codes to exactly one category. Document the five weirdest edge cases and how you'll handle them.
Day 3: Update your financial system with a maintained Category Map reference table that shows object-to-category assignments.
Day 4: Build the four standard reports listed above. Validate them against a recently closed project that you know well.
Day 5: Train your business office staff (45-minute session): show five good examples, five bad examples, and work through two live coding practice invoices together.
Then publish three lightweight reference documents:
Category Definitions (one page, plain language)
Object → Category Map (CSV or simple table)
Capital vs. Ops Cheat Sheet (one page with examples)
Put them somewhere people will actually find them. Not buried in a shared drive. Not slide 63 of a board presentation. Somewhere accessible.
What "good" looks like (fast spot-check)
Want to know if your category architecture actually works? Do this quick test:
Ask your business office for last month's portfolio rollup and snapshots of your top three active projects.
Then check:
Can you see A–G category totals in under 10 seconds?
Are contingency draws clearly labeled by layer (Construction/Project/Program)?
Can you drill down from category → object code → actual transaction without opening Excel or creating a pivot table?
If the answer to any of these is "no," your mapping isn't done yet. Keep refining until it is.
The takeaway
Category architecture isn't just accounting—it's strategy.
Get it right and you'll convert thousands of raw transactions into simple, trusted storylines: What we planned. What we committed. What we spent. What we have left.
Leaders fund clarity. They get nervous around complexity. Auditors reward discipline and documentation. Your team gets their evenings and weekends back instead of wrestling with reports.
And honestly? When your reports make sense, people trust you more. They stop second-guessing your numbers because the story is clear and consistent every single time.








Comments