AG 2014 12 15 - Laserfiche WebLink

Home Browse Search

General Instructions Operating and Financial Statistics Report Getting Started General Overview This Excel workbook collects essential financial and non - financial operating information on each rural or small urban transit provider. The workbook is organized into a series of worksheets. Report all data that is available for all transportation providers used under the auspices of your public transit system and that only your system accounts for (e.g., volunteers, other providers, and other CT systems). Beginnning in FY11, reporting of operating statisitics will be on a quarterly basis Even though reporting is quarterly, as can be seen from the forms data entry for operating statistics should be done on a monthly basis. Note: The quarterly reporting requirements are focused on operating statistics. Financial and certain other data will continue to be reported on an annual basis only. Saving the OPSTATS Report File Your first step should be to save the file to a location where it can be retrieved and updated. Once saved, open the file and review and complete the form following the instructions in this document. It is recommended that the file be saved frequently while updating information so as not to lose data if technical difficulties with hardware or software are experienced. Worksheet Tabs and Line Numbers Tabs for each worksheet are located at the bottom of the Excel program screen and are labeled. Lines in the form that require a number or other information to be entered are numbered. The line numbers are on the left and right sides of the page. Instructions are provided in this document for all numbered lines. (A hyperlink is provided which will take you to a page with specific instructions and /or definitions for that line. To return to the worksheet you were working on, simply click on the appropriate worksheet tab at the bottom.) In some lines and columns, the answer is automatically calculated or information is copied from another section in the report. These autofill lines and columns are protected and the answers cannot be changed. Reporting Period The Fiscal Year period of performance is July 1 to June 30. How to Report Accrual Accounting All financial data in the OPSTATS Report must follow accrual accounting principles. Under accrual accounting: - Revenues are recorded when earned, regardless of whether or not receipt of the revenue takes place in the same reporting period. - Expenditures are recorded as soon as they result in liabilities for benefits received, regardless of whether or not payment of the expenditure is made in the same reporting period. If a cash basis or encumbrance basis accounting system is used, worksheet adjustments should be made to record the data on an accrual basis. Example of Accrual Accounting Attachment number 1 1 -4 Page 443