Lockport’s Open Financial Data Portal
Fund Balance Accumulation
Last Updated: 12/22/2023
This data contains macro-level historic budgetary surpluses / (deficits) as well as the annual resulting fund balance accumulation for each major fund.
Update Frequency: Quarterly
Balance Sheet
Last Updated:12/22/2023
The balance sheet is a pivotal piece of information for any organization. This data contains monthly balances for City assets and liabilities.
Update Frequency: Quarterly
Contingency Utilization
Last Updated: 12/22/2023
Each year, the Common Council can elect to utilize contingency accounts to fund unplanned projects and initiatives. This shows what resolutions formally use contingency each fiscal year.
Update Frequency: Monthly
Utility Billing Trends
Last Updated: 12/22/2023
Throughout the year, the City bills its citizens for water and sewer services. This data set shows long term trends occurring with each type of service based on billing information.
Update Frequency: Monthly
Metric Benchmarking
Last Updated:12/22/2023
Certain metrics may be indicative of overall or trending performance of a fund. This file contains some of the most useful metrics to monitor.
Update Frequency: Monthly
Cash Balances
Last Updated: 12/22/2023
Cash balances are required per fund balance policy to ensure that the City can maintain day-to-day operations without delay. This data set contains monthly cash balance levels per fund.
Update Frequency: Monthly
Budget Reporting
Last Updated: 12/22/2023
Each year, the annual operating budget establishes a projected modified accrual-based budget. This data contains the year’s recorded revenues and expenditures.
Update Frequency: Monthly
Combined Sales Tax
Last Updated: 12/22/2023
Sales tax is one of the most volatile revenue sources in the City. This data set contains our monthly revenue recognition compared to budgeted allocation for the month.
Update Frequency: Monthly
Accounts Payable
Last Updated:12/22/2023
This data set contains City-made payments to vendors. Data is organized by budgetary accounts.
Update Frequency: Monthly
Payments by Vendor
Last Updated:12/22/2023
This data set contains accounts payable data on the vendor level (i.e., how much has been paid to which vendor by the City as a whole).
Update Frequency: Monthly
Monthly Reporting
Last Updated: 12/29/2023
As part of an initiative to show transparent decision making, this expanded section of the finance portal now includes managerial documents, such as regular monthly reporting memorandums.
View Documents
Monthly Reports
- December 2023 Update
- November 2023 Update
- October 2023 Update
- September 2023 Update
- September 2023 Ambulance Update
- August 2023 Update
- July 2023 Update
- June 2023 Update
- June 2023 Property Tax Update
- May 2023 Update
- April 2023 Capital Proposal
- April 2023 Update
- March 2023 Update
- February 2023 Update
- January 2023 Update
- December 2022 Update
- November 2022 Update
- October 2022 Update
- September 2022 Update
- August 2022 Update
- July 2022 Update
- June 2022 Update
- May 2022 Update
- March 2022 Update
- February 2022 Update
- January 2022 Update
Ambulance Reporting
Last Updated: 12/22/2023
This section contains ambulance billing reports directly from the City’s third-party biller. Please note that there are contractual adjustments subtracted from the gross which creates the net billable charges.
View Documents
Finance Committee Presentations
Last Updated: 9/27/2023
Finance Committee Presentations made to the Common Council are located here for reference.
View Documents
Presentations
- Accounting and Budgeting Basics, 2021
- Audit Process, 2023
- Balance Sheet, 2022
- Board of Estimate Presentation, 2023
- Bonds and Debt, 2023
- Budgeting Basics, 2022
- Budgeting Basics, 2023
- Budgeting Resolutions, 2023
- Capital Proposal, 2023
- Council Member Finance Introduction, 2023
- Financial Policies, 2023
- Fund and Budgeting Basics, 2021
- Fund Balance, 2022
- Internal Service Administration Review, 2023
- Introduction to Finance for Council, 2021
- Lead Pipe Replacement Program, 2023
- Property Tax Rate and Levy, 2022
- Year End Catch Up, 2022
Cash Flow Statement
Last Updated: 12/22/2023
The attached excel contains a detailed monthly cash flow statement for the City of Lockport. Figures are included for the General Fund, Refuse Fund, Water Fund, and Sewer Fund.
Collections Benchmarking
Last Updated: 12/22/2023
This set of data has metrics related to monthly cash collection for property taxes, tax certificates, and utility bills. It identifies long-term trends and benchmarks with prior year data.
If you have any questions about these reports and figures, please contact the City of Lockport Finance Director at trusso@lockportny.gov.