Orange County NC Website
Browse       Search
Orange County <br />Needs Assessment Project <br />Page 37 <br />Budgeting Overview: <br />The current budget process is heavily manual and is primarily performed using Microsoft Excel <br />spreadsheets and macros. The process is very limited in functionality and requires a tremendous <br />time commitment from all departments, especially the Budgeting department. Tt is critical that <br />any new system be fully integrated with other financial applications, specifically general ledger, <br />purchasing and accounts payable. <br /> Inte rnal Prior ities <br />1 Capability to enerate a bud et re aration worksheet. <br />9 9 p p <br />2 Including Prior Five (5) Years Actual Revenue and <br /> <br />Expenditures. X <br />3 Including Current Year Budget and Actual Year-to-Date <br /> <br />mounts. X <br />4 Including Current Year Estimated Budget Savings and <br /> <br />Overrun. X <br />5 Including Space for Entering Next Year's Budget Amount, On- <br /> <br />line. X <br />6 Including Space for Entering Current Yew's Estimated <br /> <br />mounts for Months Remaining in the Fiscal Year, On-line. X <br />7 Including Space for Entering Each Month's Percentage of the <br /> <br />nnual Budget or Monthly Budget Amount. X <br />8 Ilows department level users on-line access for budget ~ <br /> <br />creation, adjustment and query purposes. X <br />9 Capability to perform on-line file maintenance and inquiry <br /> <br />unctions of the budget information. X <br />10 Capability to pertorm on-line approval of budget entries and <br /> <br />hanges. X <br />11 Capability to allocate portions or percentages of budgets <br /> <br />between general ledger accounts. X <br />12 Capability to enter a description of each major item included in <br /> <br />he account budget and revise on an individual item basis. X <br />13 Capability to use the budget preparation worksheet as a <br /> <br />urnaround document to produce the final budget. X <br />14 apability to specify an annual percent or dollar amount budget <br /> <br />increase for specified or all accounts. X <br />15 Capability to generate initial budget estimates from multiple <br /> <br />ear history with different factors by department/account. X <br />16 Capability .to allocate budgets to months by portion, percentage <br /> <br />nd/or major budget item. X <br />17 Capability to allow individual departments to enter initial budget <br /> <br />information. X <br />18 Capability to mass enter data for both revenue and expenditure <br /> <br />'expense" accounts by account. X <br />19 Capability to establish new revenue and expenditure "expense" <br /> ccounts on-line, which will transfer to the general ledger <br /> ystem when the budget is transferred to the general ledger. X <br />