Municipal Budget Line-Item Tracking Worksheet

Worksheet for department budget owners to track adopted appropriations, encumbrances, and actual expenditures against municipal budget line items.

Worksheet Details

• Fiscal Year
  Enter the fiscal year being tracked, such as 2026.
• Reporting Period
• Department Name
  Department responsible for the budget line item.
• Prepared By
  Name or role of the budget owner preparing this worksheet.
• Prepared Date

Budget Line Item Identification

• Fund Code
  Enter the fund code used in the adopted budget.
• Cost Center / Department Code
  Enter the internal cost center or department code.
• Account Code
  Enter the line-item account or object code.
• Program or Project
  Optional program, initiative, or project associated with this line item.
• Line-Item Description
  Describe the budget line item being reviewed.

Budget Amounts and Activity

• Adopted Appropriation
  Original budget amount approved for this line item.
• Revised Appropriation
  Updated budget amount after transfers, amendments, or supplemental appropriations.
• Encumbrances
  Committed amounts not yet expended.
• Actual Expenditures
  Amounts spent to date.
• Remaining Balance
  Calculated as revised appropriation minus encumbrances and actual expenditures.

Variance Review and Explanation

• Variance Amount
  Calculated as revised appropriation minus encumbrances minus actual expenditures.
• Variance Status
• Variance Explanation
  Explain the cause of any material variance, such as timing, contract changes, or unplanned costs.
• Corrective Action
  Describe any budget transfer, spending freeze, procurement change, or other corrective action.

Review, Approval, and Audit Trail

• Reviewed By
  Name or role of the reviewer.
• Review Date
• Review Status
• Audit Trail Notes
  Add any notes needed to support the budget record, including references to amendments or approvals.