Bridging the Gap

A Root Cause Analysis of Project Budget Tracking

The Disconnect

When project budgets are approved, there's no reliable way to connect expenditures to the specific project. This creates significant manual work and a high risk of errors.

100%

Of approved project numbers are reset, destroying the primary tracking link before spending even begins.

The Current Workflow

1. Proposal
Project number assigned linearly
2. Approval
Original project number is reset
3. Budgeting
Linked to a generic budget code
4. Spending
Requisitions linked only to budget code, not the project
5. Reconciliation
Manual effort to link expenses, leading to errors

Root Cause Analysis

Methods & Processes

The workflow itself creates the problem. The process of resetting project numbers upon approval is the single largest contributor to tracking failures.

Systems & Technology

Our tools lack the necessary features. The CUNY system's inability to record a specific project number forces a reliance on generic codes.

Information & Data

The data becomes ambiguous. Multiple projects are often bundled under one budget code, making accurate one-to-one reconciliation impossible.

The Proposed Solution: A New Workflow

1. Draft Proposal
Submitted as a draft, no final number
2. Final Approval
A unique, permanent project ID is assigned
3. CUNY Upload
Budget and the new Project ID are uploaded together
4. Requisition
Spending is linked to both budget code AND the unique Project ID
5. Automated Tracking
Expenditures are automatically and accurately linked to the correct project

Projected Impact

By implementing a stable, unique project identifier, we can drastically reduce manual effort and eliminate the root cause of expenditure misassignment.