Laserfiche WebLink
IV. Technological Advances <br />2013 Annual Report · Publc Works Department · St. Anthony Village, Minnesota <br />9 <br />IV. Technological Advances <br />LIQUOR DATA TRANSFER <br />The accounting system conversion from ACS to Caselle Civic allowed for the ability to import data into the <br />system that would have previously had to be input by manual data entry. The finance department collaborated <br />with the Liquor Operation, their point-of-sale software vendor and a third party custom programmer to design <br />and implement an export function of the data needed to then import it into Caselle Civic, and remit payment. <br />Approximately 55% of invoices processed originate from the Liquor Operation. Subsequently, manual input of <br />those invoices took nearly a full work day to complete for each check run. By implementing this enhancement, <br />the time need for input went from roughly 6-7 hours to about 10 minutes. <br />DASHBOARD <br />As discussed earlier, the Finance Department rolled out the “Dashboard” <br />feature for the Department heads in 2013. Through this module, Staff <br />can search paid invoices for payment details and coding information, and <br />view their budget versus actual status on a line item level or department <br />wide level at any point in time. Thereby allowing Department heads to <br />have the accurate and timely information they need and to manage their <br />resources efficiently. <br />UTILITY BILLING <br />The Utility Billing module was interfaced with the General Ledger in early 2013. This allowed for the automatic <br />posting of utility transactions to the general ledger. Prior procedures required summarizing data monthly and <br />recording activity to general ledger by Journal entry. Late in 2013 the inclusion of return envelopes for ACH <br />customers was eliminated by adjusting bill printing parameters and procedure. Additional methods of accepting <br />payments will be reviewed in the upcoming year. <br />ANNUAL BUDGET DOCUMENT <br />The Budget document processing was further <br />reorganized in 2013. Prior to the 2013 Budget <br />document each page of was the budget document <br />was separate excel file or word document. The <br />2014 budget document is the second generation <br />of the reorganization efforts. The current document <br />consolidates all funds into a single excel files. This <br />allows a single point of data access and processing for <br />the 2013 Budget document. The second generation <br />of the process included the linking between tabs for <br />summaries, cross-referencing and powerpoint slide <br />production, resulting in the 2014 budget document. <br />The time invested to create comprehensive tool will <br />streamline the 2015 Budget production. <br />City of St. Anthony Village <br />3301 Silver Lake Road <br /> St. Anthony, Minnesota 55418 <br />www.ci.saint-anthony.mn.us City of <br />St. Anthony <br />ANNUAL BUDGET <br />2014 <br />The 2014 Annual Budget is <br />a document that provides <br />the financial framework for <br />the City’s operations in the <br />upcoming year. It helps to <br />ensure that the City’s resources <br />are used in a cost effective <br />manner to maintain City <br />services and to provide for <br />long term-capital needs. The <br />information herein includes <br />detail budgets for the City’s <br />general operating fund, special <br />revenue funds, capital funds, <br />debts service funds and overall <br />budget information.