Revenue and Expenditure Actuals | Last Updated 17 Jan 2020

This report includes Actual expenditures and revenues for the entire fiscal year . It includes adjustment period (period 13).

Tags: expenses, expenditures, revenues, taxes, fees, charges, actuals

This dataset has the following 25 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Ledger Typecost_center_typetextGeneral Ledger Description for the posting to the ledger. Ledger Types are as follows: B1 = Revised Budget BA = Adopted Budget B2 = Estimated Actual (not used in this report) AA = Actuals
Cost Center Typecost_center_type_2textThis field identifies expenses and budget between operating and capital.
Fund IDfund_idtextThis is the Fund Number.
Fund Descriptionfund_descriptiontextThis is Fund Name associated with the Fund Number.
Department Iddepartment_idnumberThis is the department number. Each department has an assigned number. Non-Departmental is used for non-department specific transfers (interfund transfers) and obligations (ex. debt service payments, pass- through payment).
Department Namedepartment_nametextDepartment Name that corresponds to Department ID.
Division Iddivision_idnumberThis the division id within a department. Division id is unique to a department. A division ID can be used across multiple funds
Division Namedivision_nametextDivision name corresponding to division id.
ObjectobjectnumberThis is the object code that defines the specific line items. They are generally unique to a line item. Objects starting with 5 are expenses. Objects starting with 4 are revenues.
Object Descriptionobject_descriptiontextThis description defines the object code. Generally a description is unique to an object. However, this is not always the case.
Revenue Category Codecategory_codenumberThis is code identifies the revenue category as presented in the budget. This does not apply to Expenditures. Expenditures are categorized by object sequence (511000 - 511999 = salaries and wages and 520000 - 5889999 -= supplies and expenses. These categories do not necessarily reflect the categories as presented in the CAFR.
Category Descriptioncategory_descriptiontextThis corresponds to category code.
Fiscal Yearfiscal_yeartextThis defines the fiscal year . For ex: 2010 is FY July2010 - 2011.
JulyjulynumberPeriod 1. Month entry was posted.
AugustaugustnumberPeriod 2. Month entry was posted.
SeptemberseptembernumberPeriod 3. Month entry was posted.
OctoberoctobernumberPeriod 4. Month entry was posted.
NovembernovembernumberPeriod 5. Month entry was posted.
DecemberdecembernumberPeriod 6. Month entry was posted.
JanuaryjanuarynumberPeriod 7. Month entry was posted.
FebruaryfebruarynumberPeriod 8. Month entry was posted.
MarchmarchnumberPeriod 9. Month entry was posted.
AprilaprilnumberPeriod 10. Month entry was posted.
MaymaynumberPeriod 11. Month entry was posted.
JunejunenumberThis is the final month of the fiscal year - Period 12. For this purposes of this report, it includes period 13. Period 13 is the adjustment period for year-end CAFR related adjustments.