Skip to content

Instantly share code, notes, and snippets.

@sethetter

sethetter/170304-open-budget-odd.md

Created March 4, 2017 23:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sethetter/b005155e97f3e085b6c122ff38747919 to your computer and use it in GitHub Desktop.
Save sethetter/b005155e97f3e085b6c122ff38747919 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
170304-open-budget-odd.md

Elizabeth Conversation Notes!

  • Chart of Accounts -- the structure
    • Organization - where
    • Object - what
  • In our data
    • object == oca
    • org == obj_lvl_3
    • expenditures = 1-5
    • revenue = 6-9
  • Current financials until mid 2018
    • Probably can use this data for 2018-2019 budget too
    • New structure coming after that
    • Tyler, Munis -- new financial system
  • Current objects not explaining business line functionality well
    • obj_lvl_3 can be "other" too often
  • CAFR - combine annual financial report
  • In budget book they report out by OL2
    • Utilities is an OL2, as opposed to electric/water
    • Communiciations
    • Technology
    • Building
    • Fleet
    • Contractual services
    • Capital outlay?
  • OL2 determined by first 2 chars of ol3 key
  • Reconciling data is major challenge
    • Net out transfers, because they make things look bigger than they are
  • Operate with a lot of "funds"
    • Legal limitations
    • Water/utilities - own fund
    • Sewer, etc
    • Special revenue fund type
    • TIF own fund
  • Part of property tax from old town cinema
  • FUND TRANSFERS need to be netted out
    • 5100, 5101 -- transfers
    • 9800, 9801 -- revenue
  • General fund charges other depts for using certain city services
  • Negative expenditures / revenues
    • Neg exp usually in 1300, or 1499
      • Shrinkage!
      • Budget as if all positions are filled
    • Neg rev
      • Rebate program in housing
  • SE - "what would be your concern of the project if published right now?"
    • Most important thing is the reconciliation
    • It's all "fund" so finance dept looks huge
      • Not really where the action is
      • Pension funds, substantial reserves
    • Can't have a fund balnace that is more than 5% of expenditures
      • Don't want gov stockpiling money
      • But 5% is not much
    • Water is major community issue, but the capital side of it
    • Transit is another issue, grants and local funding diff schedules makes it hard
    • Maybe limit to general fund at first
  • OCA belongs to one Dept and one Fund
    • Can have OCA's in a department that belong to a different
  • General fund > Department > ..? ol3?
  • Dept > OL1 -> OCA -> OL1 -> OL2
  • Fire Trucks are so expensive that they become capital
  • Tax exemptions table pulled?
    • Table pulled to make sure not to show exemptions for "public safety"
    • Not sure what "public safety" means yet
    • Mission Hills is pushing the issue, coming up with own interp.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment