Revenue Application Overview

The Revenue Application allows users to look at all City incoming monies in a given budget fiscal year. The domain has been set up to view this information in a 3 tiered format, so that the user can opt to consume the information broadly, more distinctly, or drill down on specific records.

Glossary of Terms

Adopted (Budget)- A plan of financial operations, legally adopted by the City, after a vote by the City Council, providing an estimate of expenditures and revenues for a given fiscal year, and providing details of expected debt financings. Under law, the Adopted budget has to be balanced. The Adopted budget includes the Expense budget, which is used to fund the City’s day to day operations and the Revenue budget, which is a forecast of how much money the City expects to collect during the fiscal year from taxes and other resources. The Adopted budget also includes the Contract budget.

Modified (Budget) – The budget reflecting changes made to the Adopted budget subsequent to the start of the fiscal year. These changes are due to new estimates of expenditures and revenues.

Revenue – An inflow of City funds (such as from tax payments)

Recognized (Revenue) - The Total Revenue (so far) collected for the fiscal year selected.

Remaining –The Modified budget minus the Recognized revenue.

Revenue Source – A code that is required on all revenue accounting transactions. Different types of revenues have different revenue source codes.

Revenue Category - a subset of ‘Revenue Source’

Revenue Class –a subset of ‘Revenue Sources’

Fiscal Year - is a period used for calculating annual ("yearly")financial statements, which covers the period 7/1/XX through 6/30/XX of the following year.

Budget Fiscal Year – is the fiscal year, irrespective of when funds were actually collected, that revenue is budgeted to.

Fund Class – Classification of Revenue types

Closing Classification Name – Category of incoming funds

CALCULATION RULES

Recognized – sum of Collected Revenue, Billed Revenue, Collected Unearned Revenue Roll-over, Accounts Left in Old Years, and Unbilled Revenue.

HOW TO NAVIGATE THE DOMAIN

Top Navigation Bar – Allows you to move from one domain to another.

Graph Visualization – provides visualization for the following:
-Revenue
-Fiscal Year Comparisons
-Top Ten Agencies by Revenue
-Top Ten Revenue Categories by Revenue

If you allow your cursor to hover over the bars in the charts, you will be able to see what each bar represents. The graphs automatically change every 40 seconds, or you can click on the circle beneath the graph to forward through to the next visualization.
The bars on each graph are hyperlinked to the specific spending transactions that the graph illustrates.
The Grid view hyperlink above the visualization displays the information on the graphical visualization as numeric data in a table format within a new browser window which can be exported to an excel spreadsheet. (A new browser window displays the information).

Show Details Hyperlink – By clicking on this hyperlink, you can expand the page to show another layer of detailed Revenue information.

Column Arrows – The arrow in front of the ‘Recognized” column allows you to sort the information by greatest or least amounts

‘+’ Button – By clicking on the ‘+’ the widget will expand from a ‘Top 5’ listing to display a maximum of 150 rows of record. When expanded, the ‘+’ symbol will transform to the ‘-‘ symbol. Clicking on the ‘-‘ symbol will collapse your records back down to ‘Top 5”.

'Details' link – Clicking on the ‘Details’ link will bring you to an exportable detail transaction page.

Blue Hyperlinks – Clicking on the blue hyperlinks will refresh the page for the information selected. Within the table, the ‘Agency’ and ‘Recognized’ columns will be hyperlinked. When a user clicks on any particular ‘Agency’, the system will direct the user to ‘Agency’ specific landing page. When a user clicks on any particular value for ‘Recognized’, the system will redirect the user to the ‘Revenue Details’ page.

WAYS TO SEARCH FOR INFORMATION

Basic Search – Basic Search allows you to search through all domains. The results will default to spending transactions and is equipped with smart search capability.

Advanced Search - Advanced search gives the user the ability to narrow their searches by a series of different filters; i.e., Budget FY, Fiscal Year, Agency, Funding Class, Revenue Category etc.

Faceted Search – Allows users to explore a collection of information by applying multiple filters employing a hierarchy structure.

Citywide Agencies – Allows users to select information on a particular agency by choosing from a pre-populated agency drop down list.