Expenditures (2018 - Current Year)

data.naperville.il.us | Last Updated 31 Jul 2019

Spending by City departments on goods and services. Dataset is used in Open Checkbook to create highly-interactive charts, graphs and tables how the City allocates public funds. Open Checkbook is part of the City's commitment to open data. Open Budget will be released later in 2018.

Tags: expenditures, checks, payments; finance

This dataset has the following 29 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Fiscal Yearfiscal_yearnumberThe year in which the payment occurred
Fiscal Periodfiscal_periodnumberThe month in which the payment occurred
Invoice Statusinvoice_statustextWhether the invoice has been paid or not
Vendor IDvendor_idnumberA unique ID number assigned to the vendor
Vendor Namevendor_nametextThe name of the vendor
Check Numbercheck_numbernumberA unique ID number assigned to the check
Payment Amountpayment_amountnumberThe amount remitted for goods or services
Check Datecheck_datecalendar_dateThe date the check was issued
Invoice Numberinvoice_numbertextA unique ID number assigned to the invoice
Invoice Dateinvoice_datecalendar_dateThe date given on the invoice
Line Item Descriptionline_item_descriptiontextA description of the goods or services purchased
Purchase Order Numberpurch_order_notextA unique ID number assigned to the purchase order
Organization Codeorg_codenumberA unique ID number assigned to the organization section of the account number
Organization Code Descriptionorg_descriptiontextThe organization section of the account number
Object Codeobject_codenumberA unique ID number assigned to the object section of the account number
Object Descriptionobject_descriptiontextThe object section of the account number
Payment Typepayment_typetextThe manner of payment (ACI, check, wire)
Payment Statuspayment_statustextWhether the payment has cleared or not
Fund Codefund_codenumberA unique ID number assigned to the fund
FundfundtextThe mechanism which paid for the good or service
Function Codefunction_codenumberA unique ID number assigned to the function
FunctionfunctiontextDescribes the use of the good or service
Department Codedepartment_codenumberA unique ID number assigned to the department
DepartmentdepartmenttextThe department that received the good or service
Division Codedivision_codenumberA unique ID number assigned to the division
DivisiondivisiontextThe division that received the good or service
Payment IDpayment_idnumberA unique ID number assigned to the payment
Department Numberdepartment_nonumberA unique ID number assigned to the department
Department Descriptiondepartment_descriptiontextThe department that received the good or service