Get Full Government Meeting Transcripts, Videos, & Alerts Forever!
Get email alerts on the Governance topic
No spam. Unsubscribe anytime.
Commission debate highlights demand for more frequent, detailed spending reports; staff to propose formats
Summary
Commissioners pressed city finance staff for monthly, downloadable spending reports in Excel; staff said some canned reports are available but the requested crosswalk to account detail requires additional work and will be proposed by email.
Commissioner Kelly (unnamed in transcript) and other commissioners questioned city finance staff about the availability of monthly financial reports and detailed spending data exported to Excel. Carol (city finance) explained the city's accounting system produces several canned reports — a detailed trial balance, an accounts-payable export and budget worksheets — but the export formats do not produce a single, easily sortable Excel file with account numbers, vendor names and descriptions without additional manual work.
Carol said the trial-balance export can be run as a PDF or dumped to Excel but that file contains about 16,000 lines for the year and lacks an intuitive combination of account description and vendor detail; producing the requested format would require staff time to marry accounts-payable detail to account numbers. She said some ad-hoc reports (capital-account dumps or quarterly budget-status reports) are produced and that budget amendments and audit processes provide additional oversight. Commissioners said they had previously asked for the data 35 days earlier; the exchange grew heated and commissioners pressed for monthly reporting per an ordinance requiring monthly financial reports.
Carol agreed to send commissioners an email by the end of the day describing which canned PDF/Excel reports are available and what additional work would be required to produce the exact Excel extract requested. The commission did not adopt a final new format at the meeting.
Why it matters: Commission access to timely, machine-readable financial data affects transparency and oversight; the discussion highlighted operational constraints in producing custom reports and the need to agree on a practical, repeatable monthly format.
Next steps: Finance staff to email proposed options and timelines for producing monthly reports and to describe which canned exports can satisfy commissioners' needs without extensive manual reconciliation.
