{"text_format":"3","workbook":"xlsx","n_sheets":29,"sheets":["Contact Information","EvalCriteria","Customer Administration","Assessments","Personal Property","PPTRA","Business License","Business Personal Property","Boats","Public Service","Bank Franchise","Real Estate","Consumer Utility","Consumption","Transient Occupancy","State Income and Estimated Tax","Abatements & Supplements","Bills, Notices & Corespondence","Online Services","Reporting","Systems Administration","Compliance","Interfaces","Misc Fees","Write Off & Void Transactions","Collections","Refunds","Cash Receipts","Workload Measures"],"not_rendered":{"external_links":3,"defined_names":30},"read":"whole","date_system":"1900"}

{"sheet":"Contact Information","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"merged":[[0,0,0,1]]}
["Contact Information"]
["This spreasheet was completed by:"]
[]
["Company Name:"]
["Contact:"]
["Address:"]
["City, State, Zip:"]
["Phone:"]
["Email"]

{"sheet":"EvalCriteria","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[0,0,0,1],[1,0,1,1]]}
["Evaluation Criteria"]
["Please use this criteria when completing Column B (Response) of this spreasheet."]
[]
["OB","Requirement is fully met 'Out of the Box.'  The solution meets the requirement as it is written without any changes necessary.  Describe method in comments."]
["RT","Requirement is fully met using the solution's reporting tool.  The method and effort required to meet the requirement (i.e. estimate of hours) must be provided in the comments."]
["SM","Requirement is fully met with a software modification.  The solution  will meet the requirement through a modification made to the system.  \"Modification\" indicates that the enhancement is made spefically for Dinwiddie, and is included in ongoing vendor support and upgrades, - OR - it means that the enhancement will be made for all customers and included in the base package for support purposes.   The method and effort required to meet the requirement (i.e. estimate of hours) must be included in the comments."]
["NR","The requirement will be fully met in the next scheduled release of the vendor solution. The release date and version must be included in the comments."]
["NA","Not available. The solution does not meet the requirement."]
["TP","Third Party Software required.  The solution meets the requirements with vendor-supplied 3rd party components.  Describe the components and support provided for them and describe how this meets the stated requirement.  "]

{"sheet":"Customer Administration","index":2,"n_rows":11,"n_cols":3,"rows_kept":11}
["Requirement","Response","Comments"]
["Customer Administration – ownership, addressing, relationships, etc."]
["Utilizes centralized taxpayer account information (name, address, social security number, drivers license number, telephone, email address, business website address, etc.) for all types of taxes and licenses. Describe how the maintenance of said information are maintained over time."]
["Allow for multiple ownership records on individual accounts.  If the system has capabilities of tracking alias information, mortgage,  as well creating relationships between tax types and other accounts, use the comment column to describe functionality.  An example would be pets and kennel."]
["Ability to record names in separate fields including but not limited to first, middle, last, and suffix.   In the comment column address if there are any drop down menu options or auto-fill capabilities available within the system.  "]
["Ability to search all customer data fields including but not limited to name, account, address (mailing and situs address)    In the comment column address how the system provides the ability to search records."]
["Ability to record addresses in separate fields including but not limited to (directional, city, state, zip, zip plus 4, number, street, suite, apartment, room).  If the system has additional abilities to process military APO/FPO and international addresses, please document such in the comment column.  In the comment column address if there are any drop down menu options or auto-fill capabilities available within the system.   Abilities to stop correspondence from going to bad addresses should be addressed."]
["Allow for multiple addresses on an account (i.e. - situs address, billing address, seasonal mailing address, temporary address).  Allow the option to send bill to multiple addresses or flag the account for review. Describe how the system provides the ability to include multiple names on statements and correspondence, maintaining the priority of owner names and listing all owners.  The system should validate any address changes. If the system has capabilities to include a drop down menu for source code tracking for address changes, example, customer phone call, returned mail, NCOA, DMV, IRMS) describe them in the comment column.  "]
["Ability to record and track customer interactions regarding with their accounts and/or transactions.  In the comment column, describe functionality if there are user defined messages, auto prefills or free form note capabilities."]
["Address how the system allows the ability to update account level data for address processing (not just at an individual bill level).  Users can add new taxpayer information to system to include, but not limited to, separate fields for taxpayer ID number, driver license number, federal tax ID number  and Department of Game and Inland Fisheries assigned number.  "]
["Ability to audit and track all customer account changes at the account level. The audit should capture date changed, user id and source of change. In the comment column, describe the system's ability to retain multiple legal identifications per taxpayer and how the system uses this information to ensure that records are not duplicated.   "]

{"sheet":"Assessments","index":3,"n_rows":41,"n_cols":3,"rows_kept":41}
["Requirement","Response","Comments"]
["Assessments"]
["Ability to import/export real estate assessment information with the County's assessment software."]
["Ability to re-assess properties in the land use program according to SLEAC for tax calculation and based on general reassessments."]
["Ability to import public service assessment information from the Virginia State Corporation Commission."]
["Ability to set up and apply an assessment method hierarchy for property classifications, i.e.  NADA, % of cost"]
["Provides for the mass update of information, particularly assessed value, through user or system import from multiple sources (NADA, DMV, DWR) and source file types."]
["Selects and assesses records with a minimum assessment based on multiple variables/criteria"]
["Allows users to modify system parameters and calculation methods/input for boats, trailers, and vehicles that are not in the NADA import file, including depreciation percentages based on asset age/purchase date"]
["Automatically adjusts to NADA generated assessed values when manual mileage is changed"]
["Utilizes the \"vehicle-acquired date\" or \"moved-in date\" depending on the situation to determine the tax liability period. Likewise it will use either \"sold\" or \"moved-out\" to end liability. "]
["Include tables to retain Virginia locality taxable dates to recognize and correctly process the tax liability period for  vehicles moving to and from prorating as well as non-prorating localities, with ability to change table data based on user profile."]
["Ability to automatically update the user ID and date when property is assessed."]
["Ability for authorized users to configure the criteria for instant assessment valuation for each property classification, assessment method and tax year."]
["Ability for authorized users to configure the criteria used to set the default assessment method for each new personal property created."]
["Ability for authorized users to configure the roll logic used to set the default assessment method for each personal property account in the subsequent tax year."]
["Ability for authorized users to create, update, and maintain separate depreciation schedules (used for % cost assessment method) for each class of property for each tax year."]
["Ability to automatically assess personal property in real time and batch interfaces, using corresponding NADA data, for any tax year within the statute of limitations."]
["Ability to automatically consider the vehicle mileage when NADA generates an assessed value, both when a vehicle property is created manually or during any DMV Import process."]
["Ability to automatically create all necessary tax year assessments and tax liability periods upon creation of a personal property account"]
["Ability to configure a separate assessment method hierarchy for property being valued through the annual statutory assessment process versus property records created throughout the tax year."]
["Ability to automatically enroll antique vehicles, entered manually or automatically, into the Antique exemption program when the vehicle meets the criteria for the program, year, plate type & expiration date.."]
["Ability to maintain the actual assessment method used for each personal property for each tax year."]
["Ability to maintain history of and display the assessment method used to determine the assessment for each property for each liability period for each tax year."]
["Ability to queue, for authorized users, any property not automatically assessed by the system during the manual or automatic creation of a personal property record."]
["System should automatically select the appropriate depreciation percentage (from the appropriate tax year depreciation schedule for the appropriate property class) to be applied to the property purchase cost, for a particular tax year, in order to obtain the assessed value.  (The % chosen by the system should be based on the property purchase year and current tax year)"]
["System should prompt user when cost or purchase year is missing when system attempts to apply the % of cost assessment method"]
["The system should indicate on the property screen any fields that are not valid, or need to be completed, to process the property record. The system should not accept a property record until the user has entered all of the required field information."]
["System should be configurable to allow for necessary rounding by tax type"]
["Ability to exclude from the personal property book any property that will not be assessed until January 1 of the following year. "]
["Ability to disallow proration of certain classes of property"]
["Ability for authorized users to configure the criteria used to associate each personal property with a classification."]
["Ability for authorized users to configure the criteria used to set the tax rate for each personal property in the subsequent tax year."]
["Ability to maintain information about personal property tax rates for each personal property, for each tax year for current tax year plus prior 6 tax years."]
["Ability to create and update classifications as necessary (State code or local ordinance)"]
["Ability for authorized users to configure the criteria used to establish the date range beyond which a personal property filing deadline extension requires supervisor approval."]
["Ability to assess a penalty for not filing a personal property tax declaration by a specified deadline.  Define how the information appears on the actual bill in the comments column (i.e. - late filing or non filing)"]
["Ability to produce an on demand assessments"]
["Ability for authorized users to maintain the criteria for personal property statute of limitations parameters."]
["Ability for authorized users to override the statute of limitations parameters on a specific personal property and tax year."]
["Ability to configure proration rules for each property classification."]

{"sheet":"Personal Property","index":4,"n_rows":20,"n_cols":3,"rows_kept":20,"merged":[[113,0,113,2],[116,0,116,2]]}
["Requirement","Response","Comments"]
["Personal Property"]
["Ability for authorized users to configure and maintain the criteria used to generate the personal property tax assessment book."]
["Ability to create one Personal Property Tax Book to include all classes of Personal Property and allow items to be prorated according to tax type"]
["Ability for authorized users to configure the schedule for generating the personal property tax assessment book throughout the year."]
["Ability to maintain electronic versions of the personal property tax books."]
["The system should produce a detailed personal property tax book for each billing by tax year, to include required property information for each taxpayer."]
["System should be able to maintain and apply Virginia locality proration information across tax years."]
["Ability to search all personal property data fields including but not limited to VIN#, license plate, title number, boat number, lessee information,  and tax ID.  In the comment column address how the system provides the ability to search records."]
["System must require user to choose a locality from the locality list when a property is moving in or out of Dinwiddie, whether or not it's moving to/from a prorating locality or not, or out of state; or whether or not the property itself is portable"]
["The system should be able to determine the tax liability of a personal property bought and sold within same month, or moved in and out within the same month, by establishing tax liability for the full month if the property has situs here for more than 15 days within the month."]
["The system should be able to handle the user creating a property and ending the ownership of the property in the same transaction, and record the necessary tax liability periods for all corresponding tax years."]
["The system should automatically determine during any DMV import process whether or not the vehicle should be prorated using the locality tables, property class, and any other DMV data within the DMV files and data.  This will include locating active duplicate VIN#'s when they exist."]
["The system should require the user to choose whether or not the property is a new purchase or a move/situs situation when adding a new property manually or during the DMV or DWR import processes."]
["System should not prorate mobile homes moving out of Dinwiddie, or sold during the tax year."]
["Ability to identify accounts in any special taxation district by type and alert staff when changes occur on the account within a certain district."]
["Ability to flag possible duplicate records (names, social security number, and T-Number)"]
["Ability to assess late penalities."]
["Ability to create and mail annual personal property items in a created 762 form."]
["Ability to use previously deleted accounts.  "]

{"sheet":"PPTRA","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"merged":[[115,0,115,2],[118,0,118,2]]}
["Requirement","Response","Comments"]
["PPTR (Personal Property Tax Relief)"]
["Ability to record qualifying PPTR amount as a transaction record to taxpayer's personal property account at the time of the levy creation.  In the comment column describe how the transaction is identified within the system.  Please describe the general ledger posting options for this transaction type"]
["Ability to record qualifying PPTR adjustments to individual personal property receivable accounts after levy creation due to a change in the qualifying status."]
["Ability to record non-qualifying PPTR adjustments to individual personal property receivable accounts after levy creation due to a change in the qualifying status."]
["Ability to provide detailed information regarding PPTR for all tax years within the statue of limitations.  Information should include amount of PPTR reimbursement received from the state and amount of PPTR applied to citizens accounts.  "]
["Ability for authorized users to configure and maintain personal property PPTR qualification criteria."]
["Ability for authorized users to state the reason for changing the PPTR use on a personal property item. Please describe if there is lookup capability for reasons."]
["Ability to automatically adjust the personal property tax liability distribution between the taxpayer and the State when the PPTR qualification status changes."]
["Ability to automatically set the personal property PPTR qualification status based on specified criteria."]
["Any change in PPTR eligibility should prompt the system to adjust the corresponding tax amount due and provided an updated tax bill as necessary."]
["The system should maintain a history of PPTR eligibility changes, along with the user who made the change and the date of the change."]
["Ability to automatically create a supplement when disallowing PPTR and the ability to abate when allowing PPTR. Describe if this is batch or on demand."]
["Ability to have system generated forecasting report for PPTR% based on  user specified criteria."]

{"sheet":"Business License","index":6,"n_rows":205,"n_cols":3,"rows_kept":205}
["Requirement","Response","Comments"]
["Business License General Requirements"]
["The system has the ability to provide a tax assessment module that is integrated with all other system modules including (but not limited to) general ledger, tax billing, accounts receivable, and cash receipts."]
["The system has the ability to retain data for a user-defined number of years."]
["The system has the ability to query GIS data when adding a new business to determine if it is within the City or not."]
["The system has the ability to cross reference State ID number, EIN number, SSN, and account number within the Business License module."]
["The system has the ability to calculate fees based on County-defined metrics."]
["The system has the ability to calculate actual gross receipts against either estimated or previously provided gross receipts.  The system will supplement or exonerate the difference. "]
["The system has the ability to support licensing fee structures by type."]
["The system has the ability to provide an online portal for electronic business license applications and renewals."]
["The system has the ability to associate a business account with multiple customer accounts and vice versa. "]
["The system has the ability to view and print all forms for a business license account and all related accounts from a single display screen or printed report."]
["The system has the ability to display the business license account number when querying a business account."]
["The system has the ability to display all delinquencies when querying a business account."]
["The system has the ability to track the compliance of each business with approvals necessary from external County and State departments based on the type of license."]
["The system has the ability to store unlimited comments for a customer record and for a single license in a specific year."]
["System should allow any address change to contractor license to be configurable to apply also to BTPP."]
["Systems should be configurable to allow for different deadlines among certain license types "]
["System should be configurable to allow authorized user to waive late payment penalty and/or interest."]
["The system has the ability to identify accounts by business type, including but not limited to:"]
["Sole Proprietor;"]
["Corporation;"]
["Retail;"]
["Contracting; "]
["Wholesale merchant;"]
["Personal Service;"]
["Business Service;"]
["Peddler; and"]
["Other, user-defined."]
["The system has the ability to identify the business account status including, but not limited to:"]
["In Audit;"]
["Bankruptcy;"]
["New Business;"]
["Closed Business;"]
["Statutory Assessed;"]
["Active; and"]
["Other, user-defined."]
["The system has the ability to drill down to the detailed information associated with each account."]
["The system has the ability to maintain records for non-licensed as well as licensed businesses in the Master Business records."]
["The system has the ability to automatically assign sequential and unique numbers to invoices."]
["Business License Applications"]
["The system has the ability to identify license by classification."]
["The system has the ability to classify license by type."]
["The system has the ability to allow for a check-list of application requirements based on business type, classification, or category, which must be satisfied as part of the application and licensing process. "]
["The system has the ability to allow the County's customers to apply and pay for Business License Applications via the internet, and in doing so, provides security measures to protect customers data and assure data confidentiality.    "]
["The system has the ability to alert business owners/contractors when applying online for a business license, that County required forms, data are missing."]
["The system has the ability to allow the County's customers to re-new and pay a Business License via the internet, and in doing so, provides security measures to protect customers data and assure data confidentiality.    "]
["The system has the ability to track the following data fields associated with the application and view and print the fields with a similar look as forms including but not limited to the following fields:"]
["Applicant name(s);"]
["SSN/FEIN:"]
["Email address;"]
["Trade name;"]
["Business phone number;"]
["Business address;"]
["Mailing/billing address;"]
["City, state, zip code;"]
["Contact name;"]
["Home office or other phone number;"]
["Type of business/profession;"]
["Home occupation or commercial location;"]
["Selection for Retail business type;"]
["Selection for Professional Occupations business type;"]
["Selection for Contractors/Developers business type;"]
["Indicator for VA. Class for Contractors/Developers business type;"]
["Indicator for Worker's Compensation"]
["Selection for Personal/Business Service business type;"]
["Selection for Wholesale Merchants business type;"]
["Virginia sales tax number;"]
["Virginia contractors license number;"]
["Map/Parcel number;"]
["Business equipment account number;"]
["Location of job (for out of Couinty contractors);"]
["Selection for Other Business or Additional Activity business type;"]
["Estimated total gross receipts to end of year; and"]
["Other, user-defined."]
["The system has the ability for customers to submit imaged documents in support of a Business License Application or Renewal.    "]
["The system has the ability for workflow to route new business license application information to the appropriate reviewers."]
["The system has the ability to flag a business license to be held due to permit issue."]
["The system has the ability to provide a field for reason for business license hold. "]
["Business License Assessments and Fee Collections"]
["The system has the ability to manage license fee payments including reconciliations and delinquencies."]
["The system has the ability to provide a user-defined account status for businesses including, but not limited to:"]
["Not filed;"]
["Filed;"]
["Notice letter(s);"]
["Summons letter;"]
["Summons;"]
["Criminal action;"]
["Civil action;"]
["Audit; and"]
["Other, user-defined."]
["The system has the ability to allow the County to add a user-defined charge to the Business License (i.e., additional charge)."]
["The system has the ability to generate renewal notices. "]
["The system has the ability to view and print all information and business license status for a business license account and all related accounts."]
["The system has the ability to track a history of business license fee schedule changes and keep history accordingly based on the fee schedule for those time periods (i.e. Rates are associated with a From - To Effective date)."]
["The system has the ability to calculate prior year business license fees."]
["The system has the ability to calculate fee based upon gross receipts needed for business license."]
["The system has the ability to create license records for the next year from the license records in the current year."]
["The system has the ability to accept business license renewal payments and apply as a credit until the assessment has been completed."]
["Ability to notify Commissioner of the Revenue office when a payment has been received."]
["The system has the ability when entering fee transactions, the fee status field will allow for a user-defined status, including but not limited to:"]
["Pending;"]
["Processed; and"]
["Billed."]
["The system has the ability to apply a fee based on County-defined thresholds for all County-defined business classifications."]
["The system has the ability to apply flat fees for multiple County-defined business license classifications."]
["The system has the ability to charge a minimum license fee on a County-defined gross receipt threshold for the following categories:"]
["Contractor;"]
["Retail;"]
["Professional;"]
["Business Service;"]
["Personal Service;"]
["Repair;"]
["Wholesale merchant;"]
["Peddler;"]
["Other, user-defined."]
["The system has the ability to apply a fee to the business license based on County defined gross receipt thresholds."]
["The system has the ability to manage the statutory assessment process."]
["The system has the ability to provide a view of the status of each type of business license or application associated with a business entity. For example, a summary view that shows the application/license status as; Pending, Completed & Billed, or Denied.   "]
["Miscellaneous Tax General Requirements"]
["The system has the ability to provide a miscellaneous tax module that is integrated with all other system modules including (but not limited to) the general ledger, accounts receivable, cash receipts, and tax billing. "]
["The system has the ability to store multiple addresses/contacts/trade names for cross reference."]
["The system has the ability to store business registration information. "]
["The system has the ability to provide a centralized address book used for all business taxes. "]
["The system has the ability to track the status of the process of accounts, including but not limited to: not filed, filed, notice letter, summons letter, summons, criminal action, civil action, audit, etc."]
["The system has the ability to capture the Commissioner of the Revenue employee responsible for each account."]
["The system has the ability to view/report on the current status of tax processing for all Commissioner of the Revenue employees responsible for business tax accounts."]
["The system has the ability to notify Commissioner of the Revenue staff responsible for taxes when a new business has been established for specific business types."]
["The system has the ability to track excise tax."]
["The system has the ability to manage income and estimated tax."]
["The system has the ability to track history of state sales and communications tax."]
["The system has the ability to track history of state sales and communications tax with the ability to interface with the Department of Taxation."]
["Bank Franchise Tax"]
["The system has the ability to create an account for each financial institution that needs to file bank franchise tax with the County.  System should be configurable to distinguish certain banks as being headquartered in Dinwiddie as compared to other banks to be assessed which are not headquartered here."]
["The system has the ability to track information from the signed State Form 64 and related schedules, including but not limited to tax liability to the County, real estate values, separate real estate holdings, when the signed State Form 64 and related schedules are received from each financial institution during the year, and history associated with each financial institution."]
["The system has the ability to automatically email or create letters to be mailed for all institutions who have submitted State Form 64 and related schedules."]
["The system has the ability to display information from the real estate record including but not limited to the current assessed value, square footage, and ownership history."]
["The system has the ability to display the current assessed value from the real estate record and the taxpayer's current reported value."]
["The system has the ability to track the status of the current year's return including each step in the process, including but not limited to: not received, return received, real estate verified, Commissioner/Chief Deputy approval, and payment submittal. "]
["The system has the ability to utilize a display screen and produce a report, including but not limited to comparisons of yearly tax amounts across multiple years for all financial institutions that reported in a given time period, taxpayer-reported real estate holdings and values across multiple years."]
["System should accommodate amended returns which create additional tax bills or refunds."]
["The system has the ability to generate a levy (including but not limited to) taxpayer information, tax assessment, tax amount, tax relief, and tax rate and submit to the appropriate biller and collector for bank franchise related taxes.       "]
["The system has the ability to produce comparative reports, including but not limited to percent change from year to year, trending over a period of years, and median change over a period of years for the bank franchise tax."]
["Transient Occupancy, Meals, and Admissions Tax"]
["The system has the ability for businesses to file the Transient/Lodging Occupancy, Meals, Admissions (5%) Tax on a quarterly and/or monthly basis. "]
["The system has the ability to apply a discount percentage based on gross receipts for the period and/or apply a cap to the discount. "]
["The system has the ability to calculate the Transient Occupancy Tax based on 5% local tax in addition to the state sales tax percentage; Meals Tax at 4% and Admissions Tax at 4%."]
["The system has the ability to calculate a 10% penalty or $10 minimum, whichever is greater not to exceed tax, for late filing and/or late payment. "]
["The system has the ability to calculate interest based on 10% per annum the first day of the following month. "]
["The system has the ability to create the Transient Occupancy, Meals, and Admissions Tax forms based on the County's requirements in order to print or email these forms. "]
["The system has the ability to track the status of the current year's filing including each step in the process, including but not limited to: form received and form not received."]
["The system has the ability to track and maintain a user defined delinquency process. "]
["The system has the ability to integrate with the Business License module in order to validate a Business License is on file. "]
["The system has the ability to generate mailings for monthly remittance forms and label. "]
["The system has the ability to produce daily, monthly, and quarterly reporting."]
["Utility Service Tax"]
["The system has the ability for businesses to file the Utility Service Tax on a monthly basis with no adjustment to the amount entered."]
["The system has the ability identify companies or accounts that are required to file. "]
["The system has the ability to calculate the Utility Service Tax based on Total Tax Billed Subscribers +/- Adjustments or Credits Allowed =  Net Tax Collected and Remitted."]
["The system has the ability to record the method of payment with associated account number. "]
["Public Service Corporations"]
["The system has the ability to support the County's process to assess tangible personal property owned by Public Service Corporations."]
["The system has the ability to allow for changes in the method of assessment for personal property and real estate of Public Service Corporations from year to year."]
["The system has the ability to automatically compare this year's reported tax assessments from the Public Service Corporation's versus last year's and systematically identify potential areas of discrepancy."]
["The system has the ability to track a history of public service semi-annual tax rate changes and keep history accordingly based on the interest rate for those time periods. "]
["The system has the ability to calculate prior semi-annual public service corporation assessments based on rates from previous time periods."]
["The system has the ability to assess and maintain Public Service Corporation data at anytime during the year."]
["The system has the ability to display information from the real estate record including but not limited to the current assessed value, square footage, and ownership history."]
["The system has the ability to display the current assessed value from the real estate record and the taxpayer's current reported value."]
["The system has the ability to display information from the personal property record including but not limited to current assessed value, vehicle information, and ownership history."]
["Short Term Rental Tax"]
["The system has the ability for businesses to file the Short Term Rental Tax on a quarterly basis. "]
["The system has the ability to calculate the Short Term Rental Tax based on 1% local tax."]
["The system has the ability to calculate a 10% penalty or $10, (starting the first day of the next month) whichever is greater not to exceed tax, for late filing and/or late payment."]
["The system has the ability to create the Short Term Rental Tax forms based on the County's requirements in order to print or email these forms. "]
["The system has the ability to track the status of the current year's filing including each step in the process, including but not limited to: form received and form not received."]
["The system has the ability to track and maintain a user defined delinquency process. "]
["The system has the ability to integrate with the Business License module in order to validate a Business License is on file. "]
["The system has the ability to produce a daily summary and balance report and a monthly report to reconcile to the daily report."]
["State Estimated and Income Tax Collection"]
["The system has the ability to generate a state-defined deposit of certificate (DC) form for transmitting to the state for estimated and state taxes collected locally with the ability to modify. "]
["The system has the ability to include the DC as part of the reports produced at the end of the day posting to the general ledger."]
["The system has the ability to generate an electronic ACH transmittal file to export to the bank based on state-defined criteria."]
["The system has the ability to generate an electronic file to export to the state for estimated income taxes collected locally."]
["The system has the ability to generate a transmittal form to send to the state for estimated taxes collected locally."]
["The system has the ability to generate a report for collected state income and estimated funds for a specific time frame. The report should generate a user-defined list of details as well as a summary line of totals for each revenue type.  The report should be able to accommodate the following items:"]
["Start date;"]
["End date;"]
["Sort by name;"]
["Sort by ticket number;"]
["Include all entries"]
["Include only entries with Balance Due;"]
["Generate totals only; and"]
["Include only zero balance accounts."]
["Reporting"]
["The system has the ability to provide an ad hoc reporting tool."]
["The system has the ability to easily generate as a set any applicable filing forms that should be mailed to a business (e.g., businesses that have filed a business license)."]
["The system has the ability to use optical reader (OCR) and barcode technology to read renewal forms with preprinted account number, and license type."]
["The system has the ability to print licenses and license renewal applications via mass mailings, e-mail, and individual in-house print based on user-defined criteria."]
["The system has the ability to generate a file that contains all business license renewal information and business license certificate information that will be sent to a print vendor or printed in-house."]
["The system has the ability to flag accounts for inconsistencies, reporting discrepancies, and/or the suggestion to audit such account."]
["The system has the ability when business information is changed to identify associated additional records that should also be reviewed. (For example, a company that has multiple business licenses that also need to be reviewed as well.)"]
["The system has the ability to generate updated business lists and distribute via mail or Internet to interested entities with appropriate system controls."]
["The system has the ability to query, sort, and produce ad hoc reports from all data fields."]
["The system has the ability to generate a report of all activity by day."]

{"sheet":"Business Personal Property","index":7,"n_rows":25,"n_cols":3,"rows_kept":25}
["Requirement","Response","Comments"]
["Business Personal Property"]
["Identifies accounts by a user-defined table of business classifications."]
["At user request, identifies active accounts that have not filed a current year return or extension request."]
["At user request, identifies those business accounts that have not been assessed for the current year."]
["Integrates with the contractor license module to retrieve business records. "]
["Can hold separate addresses based on property categories/type (e.g. business license, vehicles/BPP)"]
["Allows for filing due date extensions, and flags an account when an extension has been granted."]
["Routes extension requests through workflow for approval with appropriate audit trail. "]
["Records the purchase date and historical cost of business personal property for each tax period, automatically updates the next period and allows for deletions in that period without affecting prior year records. "]
["Maintains table of user-defined assessment methods (percent of cost) by tax type and year and applies to individual records."]
["Accommodates multiple depreciation schedules and methods"]
["Allows filing for returns with no assets and suppresses the generation of an associated assessment record."]
["Includes status fields in the business personal property record including status options such as extension filed, tax return received, processing, pending, levied and paid."]
["Retains a history of all changes made to depreciation schedules.  User should be able to review schedule from prior years."]
["Allows users to print filing forms, blank or pre-populated at the users direction, on an ad-hoc basis."]
["Generates a statutory assessment letter for accounts without a current year filing."]
["Prints user customized forms to be mailed to businesses for reporting of business personal property."]
["Displays current/prior year business data via a display screen which can easily be printed as a formatted report."]
["Ability to print a report of all business personal property leasing companies."]
["System shall provide assessment valuation upon entering class of property, year of purchase and cost of equipment either manually, upload from online filing, or laser fiche workflow."]
["The system would automatically roll forward the cost and apply the correct depreciation schedule according to user defined schedule. Describe the process in the comments."]
["Ability to assess late filing penalities.  "]
["Ability to create and mail annual personal property items in a created 762 form."]
["Ability to use previously deleted accounts.  "]

{"sheet":"Boats","index":8,"n_rows":5,"n_cols":3,"rows_kept":5}
["Requirement","Response","Comments"]
["Boats"]
["Ability to import boat data file from Department of Wildlife Resources (DWR), matching taxpayer records with VA & Hull ID #, motor information, and DWR customer identification number"]
["Ability to extract boat data and send to Vessel Valuation for assessment."]
["Ability to upload assessment data from Vessel Valuation including vendor specific assessment codes."]

{"sheet":"Public Service","index":9,"n_rows":12,"n_cols":3,"rows_kept":12}
["Requirement","Response","Comments"]
["Tax Book – PR, RE and Specialty Taxes"]
["Public Service"]
["Ability to automatically adjust values annually based on State Corporation Commission filings and Department of Taxation. Describe how you handle the true up process for twice a year billing."]
["Ability to assess tangible personal property owned by Public Service Corporations."]
["Ability to establish an account for each PSC and track current and historical reporting."]
["Ability to automatically compare this year's reported tax assessments from the Public Service Corporations versus last year's and systematically identify potential areas of discrepancy."]
["Ability to track a history of public service semi-annual tax rate changes and keep history accordingly based on the interest rate for those time periods. "]
["Ability to create new tax year assessments based on prior year assessments based on user defined time periods.  "]
["Ability to assess, maintain and track Public Service Corporation data at anytime during the year."]
["Ability to create a Public Service Property tax levy."]
["Ability to import values issued by the State of Virginia's State Corporation Commissioner and Virginia Department of Taxation."]

{"sheet":"Bank Franchise","index":10,"n_rows":12,"n_cols":3,"rows_kept":12}
["Requirement","Response","Comments"]
["Tax Book – PR, RE and Specialty Taxes"]
["Bank Franchise"]
["System should be able to generate a Bank Franchise Tax Book that meets all legal, local and state requirements."]
["System should accommodate records, assessment, and billing of bank franchise taxes."]
["System should be configurable to distinguish certain banks as being headquartered in Dinwiddie different set of fields available or required for those, as compared to other banks to be assessed which are not headquartered here."]
["System should be configurable to provide an annual report of original assessments and/or taxes billed"]
["System should be configurable to automatically generate, or prompt users to compose, letters, using account and customer data, for tax accounts which miss a filing deadline (\"non-file letters\")."]
["System should accommodate amended returns which create additional tax bills or refunds."]
["System should be able to produce for Bank Franchise Tax a listing of banks with branches headquartered in Dinwiddie and their deposits worksheet; name address, csz, Dinwiddie deposits from schedule H, total deposits, Dinwiddie percentage, net taxable capital, value, and Dinwiddie tax."]
["System should accommodate creation of reports by configurable time periods (e.g., monthly, quarterly, annually), including and sortable by various data fields reported on the bank franchise tax return."]
["The system has the ability to track the status of the current year's return including each step in the process, including but not limited to: not received, return received, real estate verified, Commissioner/Chief Deputy approval, and payment submittal. "]

{"sheet":"Real Estate","index":11,"n_rows":47,"n_cols":3,"rows_kept":47,"merged":[[34,0,34,2],[36,0,36,2],[41,0,41,2]]}
["Requirement","Response","Comments"]
["Tax Book – PR, RE and Specialty Taxes"]
["Real Estate - General"]
["System must create the Land Book in accordance with the statutory requirements of the Code of Virginia and the Library of Virginia. "]
["Ability to maintain a searchable history of real estate data that includes but is not limited to any discount or deferrals for the year. Data should be maintained by tax year with each tax year being a \"snapshot\" of the information as it was generated for the annual land book. Search features should include searching by tax year or across several tax years."]
["Ability to search all current real estate data fields including but not limited to parcel # (GPIN), account #, owner name, address, and grantor.  In the comment column address how the system provides the ability to search records."]
["System must be able to redact all confidential information related to discount programs. Describe in the comments how the system protects the identification of a tax relief parcel on public inquiry."]
["Ability to record all changes to a parcel by staff and allow for verification of information change by user defined codes and/or free form text."]
["Ability to define a table to identify property by class as taxable or tax exempt with additional coding as a subset to further identify the property type for land book classification. For example, 7-2 identifies all state owned property."]
["Ability to maintain parcel owner information data fields to match the parcel information recorded in the Circuit Court on a continual basis throughout the year without affecting the generation of the annual land book. Describe in comments how the system distinguishes between an active parcel and a future parcel for the next tax year."]
["Ability to link and maintain an accurate history of parcels in instances where GPIN changes during the tax year. Describe in comments how the system links the information to create an accurate history of the parcel, regardless of the GPIN."]
["Ability to add/maintain comments on any ownership fields to allow for information on additional owners, heirs, executors, etc."]
["Ability to create new real estate accounts and/or deactivate real estate accounts based on the division or merging of parcels as the result of a deed or plat being recorded in the Circuit Court. Explain in the comments how the system maintains history on the deactivated parcels and also identifies the parent/child relationship between the parcels."]
["Ability to support user defined codes to identify and track properties enrolled in various discount programs as well as for reporting purposes. i.e. - rehab real estate"]
["Ability to prorate real estate when supplemental bills are created for new construction."]
["Real Estate - Tax Relief: Sr, Disabled, & Veteran"]
["Ability to support an income and asset-based tax relief process requiring annual recertification. The process discounts the levy amount only by a sliding scale percentage table."]
["Ability to maintain and support a tax relief process based on criteria other than income and net worth that allows for varying percentages of relief."]
["Ability to maintain a record of the original tax amount separate from the relieved tax amount."]
["Ability to identify and track parcels in differing application cycles in order to deliver appropriate forms for renewal and identify new application requests for an upcoming tax year."]
["Ability for the tax management system to alert staff that the property is in a tax relief program when information changes that could impact program eligibility, such as ownership changes."]
["Ability to prorate tax relief when property ownership is transferred or owner no longer qualifies for program and generate a supplemental bill."]
["System must provide and maintain a history of the relieved amount by tax year in total and in detail. The history should be searchable by parcel and across tax years."]
["Ability to support the import of all current tax relief data and support manual calculations as needed on exceptions."]
["Ability to accurately apply discount when tax relief parcel is also identified as a land use parcel."]
["Ability to identify parcels for further staff review when tax relief is not renewed on the parcel."]
["Real Estate - Land Use"]
["Ability to maintain properties enrolled in the Land Use Deferral Program and identify them as land use on the real estate maintenance screen."]
["Ability to allow for multiple land use acreage classification types with a subset of soil types for each classification type. The types will correspond to a user maintained rate table which generates the land use value assessment based on varying per acre values."]
["Ability to generate the levy based on land use values in lieu of the market value assessment for parcels participating in the program."]
["Ability to allow for any non-qualifying acreage assessments to be a part of the land use assessment total, i.e. one acre house site or non-qualifying acreage and ability to change values during general reassessment without having to touch each record."]
["Ability for the tax management system to track, identify and create applications as needed based on specific form renewal schedules. i.e. - Parcel 123 has forestry acreage so a new forestry agreement is needed every 10 years."]
["Ability to calculate rollback taxes due when a parcel and/or portion of a parcel is disqualified from the program and generate bill(s) upon demand. In addition to the calculation, the system must apply penalty and interest as stated in the Virginia State Code."]
["Ability to \"flag\" changes that occur on parcels identified as land use properties, such as acreage changes, splits, and ownership changes, and start a workflow that alerts staff to the necessary review."]
["Real Estate - Rehab Discounts & Partial Exemptions"]
["Ability for the user to enter specific discount amounts for parcels enrolled in the Rehabilitated Real Estate Discount program or parcels that have a partial exemption on the property."]
["Real Estate - CDA (Community Development Authority)"]
["Ability to create and maintain information on parcels enrolled in a variety of special taxation districts including Sewer Districts, Recycling Districts, and Community Development Authorities. Parcels may exist in one or multiple districts. "]
["Ability to maintain multiple user defined rate tables, ad valorem entries and/or manual fee inputs. "]
["Ability to include levies and fees on the annual real estate bill for each parcel as separate line items."]
["Ability to identify properties in any district by type and alert staff when changes occur on parcels within a certain district."]
["Real Estate - Mineral Lands"]
["System must create the Land Book in accordance with the statutory requirements of the Code of Virginia and the Library of Virginia. "]
["Ability to maintain a searchable history of real estate data that includes but is not limited to any discount or deferrals for the year. Data should be maintained by tax year with each tax year being a \"snapshot\" of the information as it was generated for the annual land book. Search features should include searching by tax year or across several tax years."]
["Ability to search all current real estate data fields including but not limited to parcel # (GPIN), account #, owner name, address, and grantor.  In the comment column address how the system provides the ability to search records."]
["Ability to maintain parcel owner information data fields to match the parcel information recorded in the Circuit Court on a continual basis throughout the year without affecting the generation of the annual land book. Describe in comments how the system distinguishes between an active parcel and a future parcel for the next tax year."]
["Ability to track and input annual tonnages to be calculated with capitalized rate and royalty rate. "]

{"sheet":"Consumer Utility","index":12,"n_rows":3,"n_cols":3,"rows_kept":3}
["Requirement","Response","Comments"]
["Consumer Utility"]
["System should accommodate records, capture and maintain filing information of consumer utility taxes in accordance with state and local codes."]

{"sheet":"Consumption","index":13,"n_rows":3,"n_cols":3,"rows_kept":3}
["Requirement","Response","Comments"]
["Consumption"]
["System should accommodate records, capture and maintain filing information of consumption taxes in accordance with state and local codes."]

{"sheet":"Transient Occupancy","index":14,"n_rows":10,"n_cols":3,"rows_kept":10}
["Requirement","Response","Comments"]
["Transient Occupancy, Meals, and Admissions"]
["System should accommodate records, assessment, and billing of transient occupancy taxes in batch or on demand."]
["Ability to accommodate monthly entry of gross occupancy receipts and calculation of tax, penalties, and interest by location."]
["System should be configurable to allow returns to be filed for current or prior periods without earlier months being filed."]
["System should accommodate creation of new blank returns (or return booklets with one page per month) for new accounts that began mid-year."]
["System should be configurable to automatically generate, or prompt users to compose letters, using account and customer data, for tax accounts which miss a filing deadline (\"non-file letters\")."]
["System should be configurable to automate or prompt user to create statutory assessments for accounts overdue by a certain period (e.g., 10 days)."]
["System should accommodate amended returns which create additional tax bills or refunds."]
["System should accommodate creation of user defined reports for transient occupancy tax return."]

{"sheet":"State Income and Estimated Tax","index":15,"n_rows":15,"n_cols":3,"rows_kept":15}
["Requirement","Response","Comments"]
["State Income and Estimated Taxes"]
["Ability to manage and record the collection of state income and estimated taxes by name, address, and social security number in accordance with the Code of Virginia.  In the comment column, describe how the system provides a comprehensive process for the collection of state taxes. Provide documentation of your system review with Virginia Department of Taxation."]
["Ability to assess a late payment penalty at a configurable rate per month or partial month the outstanding tax due is not paid after the due date up to a configurable maximum penalty."]
["Ability to assess a late payment penalty and extension penalty in the same month up to a configurable maximum."]
["Ability to  prepare a request for correction of unpaid/paid assessments for income taxes for electronic submission to the Commonwealth of Virginia.  "]
["Ability to export payment records for electronic submission to the Commonwealth of Virginia."]
["Ability to create the deposit certificate with revenue sources and totals by tax year and category for state reporting."]
["Ability to create and export a listing of accounts that have been overpaid for state reporting."]
["Ability to prepare the transmittal of locality uncollectible (unpaid items) for state reporting and export the associated records for electronic submission to the Commonwealth of Virginia."]
["Ability to create the transmittal of tax payment slips and remittances (Form 559-A). "]
["Ability to create the recapitulation sheet which declares the amount of taxes paid during a period and export a listing of accounts for state reporting. "]
["Ability to create the declaration of income taxes assessed and export a listing of accounts for state reporting."]
["Ability for income taxes to be e-filed."]
["Ability to import VA Dept of Taxation documents to include Schedule C data for auditing purposes. "]

{"sheet":"Abatements & Supplements","index":16,"n_rows":32,"n_cols":3,"rows_kept":32}
["Requirement","Response","Comments"]
["Abatements and supplements"]
["System should be able to maintain exoneration and user defined refund reasons by code and/or configurable field. (i.e. - Treasurer adjustment vs. Commissioner abatement)"]
["Ability to generate a supplemental personal property tax levy on a scheduled batch process, after the initial book has been run, and as soon as all information necessary to create the levy has been entered."]
["Ability to maintain information about each personal property assessment adjustment: tax year, adjustment reason, adjustment amount, etc."]
["Ability to configure each adjustment type within the system. Explain how the system handles percentage adjustments based on assessment appeal type."]
["Ability to allow increases and decreases in assessed value based on changes made to relevant underlying data."]
["Ability for authorized users to set criteria for how the new value for each personal property assessment adjustment field is set or calculated as it is rolls forward to the subsequent tax year record."]
["Ability to use original due date on a supplemental bill to calculate penalty and interest on an amended assessment."]
["Ability to exonerate a personal property to eliminate a levy after the initial book date."]
["Ability to exonerate a personal property to reduce a levy after the initial book date."]
["Ability to supplement a personal property to increase a levy after the initial book date."]
["Ability to supplement a personal property to create a levy after the initial book date."]
["Ability to automatically create a supplemental assessment for personal property in real time and batch interfaces, using corresponding NADA data, for any tax year within the statute of limitations."]
["Ability for authorized users to maintain a list of personal property statute of limitations override reasons."]
["Ability to automatically identify each personal property exoneration as being either the result of proration or unrelated to proration."]
["Ability for authorized users to maintain the criteria for personal property statute of limitations parameters."]
["Ability for authorized users to override the statute of limitations parameters on a specific personal property and tax year."]
["Ability to produce an abatement form for a property tax liability period when a property tax liability has decreased due to an adjustment in assessed value or tax."]
["Ability to prevent changes to personal property assessment or tax levy value on a record for a tax year beyond the statute of limitations."]
["System must allow for multiple instances of ownership of the same property by the same taxpayer(s) during same tax year, as long as the ownership dates, and tax liability dates, do not overlap. ( i.e. - to accommodate taxpayers who sell their car, then buy it back later in the tax year or move to and from the county during the tax year)"]
["Ability to perform abatements on real estate, personal property, business personal property, contractor licenses, estimated taxes and all specialty taxes, and create form 905 for import into document imaging system."]
["Ability to process and abatement individually or batch. Upon entry of an abatement amount and the reason, the system should automatically recalculate the reduction to the assessment, tax, late file, late pay, interest, car tax relief in \"real time\".  Explain how the system recalculates the reduction.",null,{"$f":"C15:D23","v":0}]
["Ability to generate supplement based on configurable billing periods."]
["Ability to produce a supplemental tax book that includes both batch and on demand supplements."]
["Ability to abate miscellaneous charges, fees, placed into system with optional dual authority."]
["Ability to produce reporting of items abated based on user defined criteria."]
["Any modifications of a property (situs, assessment, ownership, etc.) that occur after a bill has been created should result in an adjustment on the corresponding tax year bill."]
["Ability to create a supplemental land use deferral levy with applicable penalty and interest according to Virginia state code"]
["Ability to create a supplemental real estate levy based on user selected value field(s)"]
["Ability to generate an abatement and/or supplement based on amended or adjusted contractor filings"]
["Ability to void abatements and supplements if not updated in Treasurer's office."]

{"sheet":"Bills, Notices & Corespondence","index":17,"n_rows":21,"n_cols":3,"rows_kept":21}
["Requirement","Response","Comments"]
["Bills, Notices and Correspondence"]
["Ability to produce reports that summarize info from tax book to compare with information from billing file"]
["Ability to produce billing file for any items assessed/created by Commissioner which includes credits and past due amounts including fees"]
["Ability to produce billing file for Pet License Notices (annual, rabies notices, on-demand)"]
["Ability to produce billing file for Kennel License (annual, on demand)"]
["Ability to produce an on demand bill from on demand assessment"]
["Ability to create a misc. charge, fee, or other non-county tax revenue amount"]
["Ability to import as a file or other interface a misc. charge, fee, or other non-county tax revenue amount"]
["Ability to create a on demand bill for misc. charge in system including collection fee, service fee, parking tickets, miscellaneous county fee, or other non-tax revenue fee"]
["Ability to note corrective action taken on return mail including new address"]
["Ability to note when bill, notice, or correspondence is returned including reason why and return address"]
["Ability to include multiple special assessments on notice including, but not limited to CDA and storm water fees."]
["Ability to include multiple names on bills and notices."]
["Ability to print a bill or notice with an alternate mailing address based on business function, either on demand or in mass. (i.e.- if printing a tax bill use one address, and when printing a Property Return, you use an alternate address) Describe in comments column any limitations with respect to number of alternate addresses that can be associated with an account &/or customer.",null,"  "]
["Ability to create paper bills for tax services corporations not participating in an electronic payment process "]
["Ability to omit bills for printing from the printing process based on user-defined flags (e.g., Mortgage Company, E-bill, Bankrupt)."]
["System should allow users to created unlimited customized correspondence templates and/or mailing labels that can be generated from within the application, pulling information directly from an account in batch or on demand.  Describe if you have a central address repository for use in generation of customer correspondence"]
["Ability to reproduce a bill for any tax, fee, charge, or non tax revenue item in a summary or detailed format."]
["Ability to interface with third-party printing vendor."]
["Ability to select other types of fees/credits to be added to real estate bills. "]

{"sheet":"Online Services","index":18,"n_rows":17,"n_cols":3,"rows_kept":17}
["Requirement","Response","Comments"]
["Online Services – online customer portal for viewing, changing data and payments"]
["Ability to inquire online the amount of taxes paid current year and prior years.  In the comment column describe the system functionality.  Address abilities to redact information in accordance with the Code of Virginia."]
["Ability to create reports based on defined criteria such as delinquent real estate tax."]
["Ability to search and pay online real estate, personal property, public service, dog licenses, kennel licenses, consumption utility taxes, transient occupancy, business licenses and any associated charges or fees.  In the comment column describe the system functionality.  Address tender payments accepted.  Address whether information is updated in real time or the batch process.  Describe how the system validates access to confidential personal property information"]
["Ability to request user to validate information during payment process."]
["Ability to signup for electronic notifications and/or paperless billing.  "]
["Ability for taxpayer to register personal property and new business online and automatically update system and send confirmation email response. Describe review process of data submitted by taxpayer. Include worksheet that calculates fees and payments due."]
["Ability for taxpayer to file for contractor license and upload supporting documentation."]
["Ability for taxpayer to access their business account information and file online their business personal property return and asset list attachment with costs from the previous year pre-populated on the return, adding together the previous year's 5th and 6th lines."]
["Ability for taxpayer to file transient occupancy, meals and admissions taxes online."]
["Ability for taxpayer to view their assessment history for personal and real property"]
["Ability for user to maintain their personal information. Describe what customers can update and if there is a notification process to County."]
["Ability for filing consumer utility and utility gross receipts online"]
["Ability for customer to submit customizable defined online forms and supporting documentation (i.e. - high mileage discount, personal property appeal, disabled veteran discount, pet and kennel)  Describe the review process for submissions. Describe the systems ability to update record after approval. "]
["Address future plans for acceptance of crypto currency."]
["Ability to connect recorded plats to respective real estate parcel."]

{"sheet":"Reporting","index":19,"n_rows":26,"n_cols":3,"rows_kept":26}
["Requirement","Response","Comments"]
["Reporting"]
["Ability to run queries and reports in the production system during business hours without affecting system performance."]
["Ability to create custom complex queries and reports on any taxpayer and/or personal property\ndata field(s) using a system reporting tool."]
["Ability to report on current day activity (i.e. intraday activity)"]
["System should include a report writer which creates custom report formats based on\nconfigurable criteria of data. Report writer should be easily understood to produce specific reports. Describe how the system provides in-depth statistical reporting by configurable data elements and time periods. This shall include, but not limited to, historical data, intra-day data, bill level data, transaction type, year to year comparisons, life to date of a bill, and special bill types such as Public Service, CDA, Special Assessments, Rehab, Enterprise Zone, Tax Relief (PPTR and Elderly/Disabled)."]
["Ability to apply standard calculation functions to provide summary data at report and group levels"]
["Ability to generate, print, e-mail and save any report"]
["Ability to produce reports to obtain all standard performance workload measures for the Compensation Board & Weldon Cooper Center.  See tab in the workbook named workload measures."]
["Ability to generate daily, monthly and yearly reports on abatements and supplements."]
["Ability to produce and print a statistic report of voids for audit purposes.  "]
["Ability to export query results to an external application"]
["Ability to produce statistical reporting for all charges, payments, collection actions, payment types, account status, number of transactions (current vs delinquent) in the system."]
["Ability to produce inventory reports for items found in system "]
["Ability to produce payment reporting by payment types, amounts, dates, payee in system."]
["Ability to produce collection reports for collection type, collection success, collected amount"]
["Ability to produce reports for items archived or removed from system"]
["Ability to produce security reporting including user access, last date accessed"]
["Ability to produce a report of assessment and collection statistics, including (but not limited to) the following:  numbers of accounts and total dollars for all tax types.  The report should be able to associate transactions/balances due to the related levy, levy year and fiscal year billed in for Generally Accepted Accounting Principles(GAAP)  financial reporting."]
["Ability to create a configurable report of accounts by balance due."]
["Ability to produce comparative reports for assessment and tax values, including but not limited to, percent change from year to year, trending over a period of years, and median change over a period of years for all tax types."]
["Ability to track volume for reporting purposes and by mailing type"]
["Ability to produce dog and kennel license reports including active license reports, unlicensed reports, renewal reports"]
["Ability to create a custom report of data changes that need to be reported to other county departments such as the Assessor."]
["Ability to generate a report on all special taxation districts, sorted and subtotaled by district and fee type."]
["Ability to produce a report of transactions applied to a customer's account based on user defined parameters including but not limited to transaction date, parcel id, social security  number, account number, tax type."]

{"sheet":"Systems Administration","index":20,"n_rows":11,"n_cols":3,"rows_kept":11}
["Requirement","Response","Comments"]
["Systems Administration"]
["Ability to provide for user administration for system maintenance.  In the comment column describe the methodology to user administer the system.  Describe system variables that are subject to user administration and those items that are not. "]
["Ability to audit and track all changes made within the system, with option to search and report on changes.  In the comment column describe audit and reporting capabilities."]
["Ability to establish dual authorization for tasks and/or transactions."]
["Ability to accommodate securely electronic mailing or transmission of returns and other encrypted documents (e.g., in PDF or other appropriate formats) to citizens."]
["Ability to secure options, fields, documents, records by user profile or group profile "]
["Ability to adhere to record retention set forth by Library of Virginia.  Different tax types have different retention requirements.  In the comment column describe the methodology used.  In the comment column describe how conversion of historical records for the current year, plus 5 years for personal property, business property, business license, and 20 years for real estate data has been accomplished on similarly sized public localities.  "]
["Ability to prevent unpaid receivables from archiving based upon specific criteria (i.e. legal status extending the statute of limitations for collection actions, or items under audit)."]
["Ability to automate imports and exports as needed."]
["Ability to have a test environment."]

{"sheet":"Compliance","index":21,"n_rows":7,"n_cols":3,"rows_kept":7}
["Requirement","Response","Comments"]
["Compliance with Federal, State and Local Legislation"]
["Ability to conform to the requirements of the county's local ordinances.  In the comment column describe your ability to comply with future county ordinances by their effective date.  "]
["Ability to calculated tiered penalty and interest. The county is one of the few localities in the commonwealth that have adopted the tiered penalty and interest option outlined in the Code of Virginia.  In the comment column, describe how your system calculates tiered penalty and interest on partial payments. "]
["Ability to conform to the requirements of the Code of Virginia (based on applicable statute of limitations).  See http://law.lis.virginia.gov/vacode.  Describe system ability to comply with future state laws by their effective date in the comment section.  In the comment column, describe and illustrate how your system provides a modular revenue administration system solution which allows for separation of duties as mandated by the Code of Virginia."]
["Ability to conform to the requirements of the current federal tax laws.  In the comment column describe your ability to comply with future federal laws by their effective date."]
["Ability  to conform to generally accepted accounting principles and generally accepted auditing standards.  The Auditor of Public Accounts for the Commonwealth of Virginia has published annual guidelines, manuals and audit specifications (http://www.apa.state.va.us/APA_Reports/localgov_cafrs.aspx)."]

{"sheet":"Interfaces","index":22,"n_rows":22,"n_cols":3,"rows_kept":22}
["Requirement","Response","Comments"]
["Interfaces"]
["General Ledger"]
["Ability to post entries to the correct general ledger accounts in the county's general ledger system with sufficient information to identify the type of transaction (I.e. original book assessment, supplemental assessment, abatements, payments, adjustments).  "]
["Ability for the system to provide summary or detailed information to the general ledger in real time or batch.  "]
["Accounts Payable"]
["Ability to interface with the County's accounts payable system to issue refund checks.  In the comment column, address the ability for the system to provide summary or detailed information in real time or by batch."]
["Ability to record refund check information from the county's accounts payable system on the associated receivable/inventory record."]
["Ability to interface with the County's accounts payable system to match delinquent balances against County accounts payable runs to create associated documentation.  Address the ability for the system to provide summary or detailed information to Munis in real time or by batch.  "]
["Payroll"]
["Ability to interface with the County's payroll system to match delinquent balances against County payroll to create treasurer's liens.  In the comment column, address the ability for the system to provide summary or detailed information to Munis in real time or by batch.  "]
["Bank"]
["Ability to export an accounts receivable data file to the Bank of Southside Virginia on a daily basis in batch.  The data file should include current balance due and account information."]
["State of Virginia"]
["Ability to import address changes from third parties such as state agencies, DMV, US Post Office (via National change of address files) without changing until approved by a user. Describe the ability to review and approve import."]
["CAMA System"]
["Ability to interface with a CAMA system to allow for assessment value uploads from the Assessor as well as allow for manual adjustments for property values as needed.  "]
["Ability to send ownership information to a CAMA System. In the comment column, address the ability for the system to send ownership information real time or by batch."]
["Describe if system provides ability to link to CAMA System from any account"]
["Import/Export"]
["Describe how the system handles exporting and importing of data to and from other county systems and state and other agencies. "]
["Describe how the system exports assessment information to an incorporated town."]

{"sheet":"Misc Fees","index":23,"n_rows":19,"n_cols":3,"rows_kept":19}
["Requirement","Response","Comments"]
["Miscellaneous Fees"]
["Pet License"]
["Ability to manage and record multi year pet licenses in accordance with the Code of Virginia.  In the comment column, describe how the system provides  a comprehensive system for pet licenses.  "]
["Ability to handle various prices based upon duration of time and/or spade and neutered animals, as well as those that have been designated as dangerous."]
["Ability to import information from rabies notices from veterinaries to create records for unlicensed pets."]
["Ability to import and update information from rabies notices received from veterinaries for licensed pets.  If the system has the ability to review and approve prior to importing records, use the comment column to describe the functionality."]
["Ability to issue replacement licenses.  Use the comment column to describe systems functionality to link new license information to that of previously issued licenses."]
["Ability to search by animal, owner name, pet name, address, license number."]
["Kennel License"]
["Ability to manage and record kennel licenses in accordance with the Code of Virginia.  In the comment column, describe how the system provides  a comprehensive system for kennel licenses.   "]
["Ability to handle various prices based upon the number of authorized animals and has the ability to associate individual animals to the kennel."]
["Ability to import and update information from rabies notices received from veterinaries for licensed pets.  If the system has the ability to review and approve prior to importing records, use the comment column to describe the functionality."]
["Ability to search by animal, owner name, pet name, address, license number."]
["Other Miscellanous Charges"]
["Sheriff Bills"]
["Parking Violations"]
["Building Permit"]
["Landuse Fees for the Landuse Program"]

{"sheet":"Write Off & Void Transactions","index":24,"n_rows":5,"n_cols":3,"rows_kept":5}
["Requirement","Response","Comments"]
["Write offs"]
["Ability to write off transactions for all tax types and fees on a mass and individual transaction basis for users with appropriate authorization.  In the comment column describe how the transactions are identified and processed.   Address how the system documents the reason for the write off (i.e.- court ordered, past the statute of limitations)."]
["Void Transaction "]
["Ability to identify and track voids by action type (i.e.. Entered wrong tender type, payee information, check processed for different amount).  In the comment column, describe how the system identifies and processes void transactions.  Indicate whether the system has the ability to set dual authorizations for transactions.  Address how the system documents the reason for the void."]

{"sheet":"Collections","index":25,"n_rows":26,"n_cols":3,"rows_kept":26}
["Requirement","Response","Comments"]
["Delinquent collections"]
["Ability to manage the collection of outstanding taxes.  In the comment column, describe how the system provides  a comprehensive system for the collection of delinquent taxes.  Address how the system provides cashier/customer service agents and collection agents  “real time” account balances while an account is in a collection process.  Provide information as to what format this information is available in."]
["Ability to produce delinquent notices on demand or in mass.  Describe the system's ability to incorporate tiered penalty and interest rates on delinquent notices and statement of account in the comment column."]
["Ability to add collection fees on demand and in mass based upon collection action."]
["Ability to create payment plans with variable items, variable terms , down payments.  Address how the system handles tiered penalty and interest rates in the comment column.  Ability to create documents associated with payment plan should also be addressed. Describe ability to create ACH autodraft documentation."]
["Ability to track payment plans for adherence and completion.  If the system has functionality  to track broken promises, use the comment column to describe the functionality."]
["Ability to create tax or non-tax liens (bank, wage, 3rd party) in mass and on demand.  In the comment column, address how the system handles lien releases and amendments.  Address how the system generates associated documents."]
["Ability to track liens for adherence, completion, or resolution.  If the system has functionality to track liens, use the comment column to describe functionality."]
["Ability to create seizure or distress warrants and accompanying documents.  If the system has functionality to track the seizure for adherence, completion or resolution, use the comment column to describe functionality."]
["Ability to participate in Virginia Department of Taxation setoff debt program.  In the comment column, address the system's ability to interface with the Virginia Department of Taxation.  Address how the system identifies, tracks post payments and resolves debt set off items, and produces associated documents."]
["Ability to create a treasurer's summons in mass and on demand.  In the comment column address how the system tracks summons for adherence, completion or resolution, use the comment column to describe functionality."]
["Ability to create warrants in debt  on demand and in mass.  In the comment column address how the system handles releases and amendments.  If the system has the ability to track warrants in debt and produces associated documents, use the comment column to describe functionality."]
["Ability to assign items to third party collection agents. Describe the systems ability to assign records for third party collection based on due date, outstanding amount, tax, fee, charge type, or at collector discretion.  If the system has functionality to interface with third party collectors, describe system functionality in the comment column. "]
["Ability to import and export information to the Virginia Employment Commission (VEC) for purpose of verifying and maintaining employment information. .  In the comment section address how the system allows for the review, update and tracking of VEC information (wage match files).  "]
["Ability to maintain table of employers with contact information wage and garnishment information. Ability to maintain local and corporate address of employer. Describe if the system has the ability to track changes in employer table."]
["Ability to track accounts in bankruptcy.  In the comment column, address how the system identifies the type of bankruptcy and how it manages the accounts, include comments regarding: associating bills included in claims, automated filing, payment processing based on amount due at time of filing, notifying trustees of unpaid post petition debts and extending the collection period beyond the respective statutory collection period."]
["Ability to create and process DMV registration withholding stops in mass and on demand.  In the comment column, address the system's ability to interface with the Virginia Department of Motor Vehicles.  Address what parameters are used to select withholding stops and how the system identifies, tracks and resolves registration withholding stops."]
["Ability to process wage garnishments in mass and on demand.  In the comment column, address how the what parameters are used to select wage garnishments and how the system identifies, tracks amends, releases and resolves wage garnishments."]
["Collection of Returned Transactions (ACH and checks)"]
["Ability to manage the collection of returned transactions.  In the comment column, describe how the system provides  a comprehensive system for the collection of returned items.  Address how the system provides cashier/customer service agents and collection agents  “real time” information and account balances and associated documentation. "]
["Ability to post the returned item detail to the associated receivable/inventory record.   In the comment column address how the system posts returned item detail associated with payments posted via a lock box process.  If the system has the functionality to import information from the County's financial institution, Southside Virginia Bank, please describe the functionality in the comment column.  Address how the system handles returned items on a transaction where multiple payment types occurred."]
["Ability to create and update a receivable for the returned item administration fee on demand and in mass."]
["Ability to generate notifications to taxpayers for returned items."]
["Ability to waive administrative fees when the taxpayer was not at fault in accordance with the Code of Virginia.  If the system has additional functionality like the ability to prefill or provide reason codes in a drop down list, use the comment column to describe the functionality."]
["Ability to flag associated receivable/inventory record to require certified funds due to habitual returned items."]

{"sheet":"Refunds","index":26,"n_rows":10,"n_cols":3,"rows_kept":10}
["Requirement","Response","Comments"]
["Refunds"]
["Ability to identify and manage refunds due by action causing the credit balance (i.e. overpayments, COTR abatements, TR adjustments).  In the comment column describe how the system processes and documents refunds as they are processed (identified, reviewed, submitted for processing, check issued, check cleared).    Address how the system identifies payee information."]
["Ability to flag and apply a refund to the next levy in lieu of issuing a refund check.  In the comment column, describe how the system provides this functionality.  Address if this can be done in mass or on demand."]
["Ability to process refunds based on user-defined criteria such as tax type, dollar ranges, and minimum amounts.  In the comment column, address the most common practice utilized to process refunds by the users of the system. Describe what information is available for refund research ( i.e. - reason for abatement)"]
["Ability to automatically post refunds below the minimum threshold to a user defined account.  Address whether your system has the functionality to process in mass or on demand in the comment column."]
["Ability for users with appropriate authorization to change the payee and/or address information for refunds and specify a reason code (i.e. taxpayer, leasing company, mortgage company)."]
["Ability to automatically identify and apply refunds where taxpayer/account has any outstanding debt to the County.  In the comments column address how the system identifies and processes these transactions."]
["Ability to automatically calculate refund amount due to the citizen which includes penalty and interest amounts paid prior to the refund.  "]
["Ability to calculate any earned interest owed to the customer for erroneous assessments as stipulated by the Code of Virginia.   In the comment column address how the system identifies and processes erroneous assessments."]

{"sheet":"Cash Receipts","index":27,"n_rows":21,"n_cols":3,"rows_kept":21}
["Requirement","Response","Comments"]
["Cash receipts"]
["Ability to have a cash register system that is based upon appropriate authorization levels (i.e. limit access to tax and/or license types).  In the comment column, address how the system provides real time account balance information to cashiers/customer service agents.  Address how the system identifies and processes  same day transactions (i.e. is there a set order in which transactions occur)."]
["Ability to apply payments in accordance with the Code of Virginia.  Use the comment column to address how users process payments honoring post marks as the effective date of the payment.  Address the order in which delinquent tax payments are applied."]
["Ability to record payment detail including but not limited to payment source, cashier,  payment location, process  date, and effective date. Describe if the system has functionality to provide drop down menus options, or auto-fill capabilities available within the system."]
["Ability to provide a balancing & close process that incorporates separation of duties. Describe the system's balance reporting (i.e. item count, tender type count, payment source type, creation of deposit slip)."]
["Ability to create a receipt  for any tax, fee, charge, or non tax revenue item paid in a summary or detailed format at any stage of the posting process. Describe or provide what information is included on a receipt and page formatting options (i.e. full page, 1/3 page, thermal paper). "]
["Ability to reproduce a receipt  for any tax, fee, charge, or non tax revenue item paid in a summary or detailed format."]
["Ability to produce licenses and permits upon payment in full on demand or in mass (i.e. pet, kennel, contractors, business)."]
["Ability to accept multiple payment tender types within a transaction.   Address the systems ability to store transaction information by tender type in the comment column.  If the system does not have the ability to accept multiple tender types in a single transaction,  describe how such a transaction is processed within the system. "]
["Ability to pay multiple tax types and/or accounts in a single transaction.   Address the order in which payments are applied in the comment column."]
["Ability to import and process a payment file from commissioner of revenue filings, escrow company, bank lockbox, state source, 3rd party collection source, ach file or batch payments.  Address how the system identifies and processes these payments in the comment column. "]
["Ability to review and approve imported payment files prior to posting, please use the comment column to describe system functionality."]
["Ability to void a payment with proper audit trail and documentation of the reason.  Describe if the system has functionality to provide for dual authorization, drop down menu options, or auto-fill capabilities available within the system. "]
["Ability for partial payment to be applied in a priority defined by the locality (i.e. interest 1st, penalty, principle)."]
["Ability to interface payment information to the County's general ledger. In the comment column, address the ability for the system to provide summary or detailed information in real time or by batch.  "]
["Ability to produce a statement showing current and/or outstanding items due by including but not limited to account number, driver license id, social security number, or map id. "]
["Ability to provide for authorized parties to override payment application rules.  Justification for the override should be documented within the system.  Discuss how the transactions are identified and processed in the comment column.  Describe if the system has functionality to provide for dual authorization, drop down menu options, or auto-fill capabilities available within the system. "]
["Ability to use peripheral equipment for the scanning of OCR codes or other barcodes for accurate and immediate account recall.  Address if the scanning can be done by item or in mass in the comment column."]
["Ability for the system to interface with the County's ECM system (Laserfiche).  In the comment column, describe if the system allows for the capture of supporting documentation as they are tendered, capturing all pertinent processing data or if the scanning of the documentation is completed in batch."]
["Ability to restrict payment tender types based on customer. Describe how the system identifies and maintains the restriction.  "]

{"sheet":"Workload Measures","index":28,"n_rows":126,"n_cols":5,"rows_kept":126,"merged":[[0,0,0,3]]}
["Compensation Board & Weldon Cooper Center Reporting Requirements."]
["Report Frequency 1","Report Frequency 2","System of Record","Category","Report Information"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Real Estate Parcels"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Taxable Parcels"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of  Land parcels maintained for Mortgage Companies"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Real Estate Tax Bills mailed"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Real Estate Abatements"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Real Estate Transfers"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Real Estate Parcels in Relief for the Elderly"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number Real Estate Parcels in Land Use Program"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number Real Estate Payments Processed"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Real Estate Assessments"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Mapping/GIS Updates Completed"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Numer of Reassessments/New Construction"]
["Monthly","Annual (Calendar)","BAI","Real Estate Tax","Number of Land Use Tax/Rollback Applications"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Items"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Taxable Personal Property Items"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Items in Relief"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Tax Bills mailed"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Abatements"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Address Changes"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Payments Processed"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Assessments"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Registration Renewals"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property New Registrations"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Registration Deletions"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Prorations"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of PPTR Compliance"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Personal Property Accounts for Compliance"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Motor Vehicle Records Reviewed for PPTR Compliance"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Mobile Home Assessments"]
["Monthly","Annual (Calendar)","BAI","Personal Property Tax","Number of Machinery/Tool/Personal Property/Farm Accounts"]
["Monthly","Annual (Calendar)","BAI","Dog Licenses","Number of Dog License Notices Sent"]
["Monthly","Annual (Calendar)","BAI","Dog Licenses","Number of Dog Licenses Sold"]
["Monthly","Annual (Calendar)","BAI","Dog Licenses","Number of Rabies Certifications Sent to Other Localities"]
["Monthly","Annual (Calendar)","BAI","Dog Licenses","Number of Kennel License Notices Sent"]
["Monthly","Annual (Calendar)","BAI","Dog Licenses","Number of Kennel License Sold"]
["Monthly","Annual (Calendar)","BAI","Vehicle Licenses Issued","Number of Vehicle Licenses Issued"]
["Monthly","Annual (Calendar)","BAI","Vehicle Licenses Issued","Number of Vehicle Licenses Abated"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of CDA Bills Collected"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Parking Tickets Collected"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Local Business Tax Collected"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Business Accounts with Local Excise Tax"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Utility Tax & Consumer Utility Tax Accounts"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Parks and Recreation Fees Processed"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Other Local Bills Collected"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Building Permits Processed"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Public Service Corporations Assessed"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Financial Institutions/Bank Franchise Tax"]
["Monthly","Annual (Calendar)","BAI","Other Fees/Taxes","Number of Coal, Gas, Oil, Mineral Tax Accounts"]
["Monthly","Annual (Calendar)","BAI","State Taxes ","Number of State Income Tax Memorandas Processed"]
["Monthly","Annual (Calendar)","BAI","State Taxes ","Number of Delinquent State Income Tax Notices Sent"]
["Monthly","Annual (Calendar)","BAI","State Taxes ","Number of Delinquent State Income Tax Collection Actions Taken"]
["Monthly","Annual (Calendar)","BAI","State Taxes ","Number of State Estimated Tax Accounts Created"]
["Monthly","Annual (Calendar)","BAI","State Taxes ","Number of State Estimated Tax Payments Processed"]
["Monthly","Annual (Calendar)","BAI","State Taxes ","Number of State Income Tax Payments Processed"]
["Monthly","Annual (Calendar)","DMV","Other State Duties","Number of Vehicle Titles for DMV as a DMV Licensing Agent"]
["Monthly","Annual (Calendar)","DMV","Other State Duties","Number of Vehicle Registrations for DMV as a DMV Licensing Agent"]
["Monthly","Annual (Calendar)","DMV","Other State Duties","Number of Transactions with fees collected for DMV as a DMV Licensing Agent not including Titles or Registrations"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Claims Filed with Debt Setoff"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Warrants in Debt Issued"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Parcels in Judicial Sale"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Bank Liens Issued"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Wage Liens Issued"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of 3rd Party Liens Issued"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Treasurer's Summons Issued"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Distress Actions to Seize Property"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Delinquent Notices Sent for all Tax, Fee, or License Types"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of DMV Stops issued"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Monthly Pay Plans for Tax/Delinquent Collections"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Meal Tax Enforcement Actions by Distress"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Admissions Tax Enforcement Actions by Distress"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Transient Occupancy Tax Enforcement Actions by Distress"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Bankruptcy Claims Filed"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Skip Tracing (address research) Actions Perform"]
["Monthly","Annual (Calendar)","Collections Database","Collection Actions","Number of Other Collections Action Performed (including Return Checks)"]
["Monthly","Annual (Calendar)","Collections Database","Other Actions","Number of Delinquent Skip Tracing (address research) Acction Performed"]
["Monthly","Annual (Calendar)","Collections Database","Other Actions","Number of Return Mail Pieces Processed"]
["Monthly","Annual (Calendar)","Collections Database","Other Actions","Number of Accounts Referred to Local Escheator"]
["Monthly","Annual (Calendar)","BAI","Other Actions","Number of Unclaimed Property Items Filed"]
["Monthly","Annual (Calendar)","BAI","Other Actions","Number of Checks Submitted to State as Unclaimed"]
["Monthly","Annual (Calendar)","BAI","Other Actions","Number of Tax Refunds Issued"]
["Monthly","Annual (Calendar)","BAI","Other Actions","Number of Workmen's Compensation Affidavits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Tax Relief Applications"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Business License Desk Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Business License Field Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Personal Property Desk Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Personal Property Field Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Merchant's Capital Desk Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Merchant's Capital Field Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Business Personal Property Desk Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Business Personal Property Field Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Machinery & Tools Desk Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Machinery & Tools Field Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Excise Tax Desk Audits"]
["Monthly","Annual (Calendar)","BAI","Audits and Appeals","Number of Excise Tax Field Audits"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Tax Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Business License Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Personal Property Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Business Personal Property Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Merchant's Capital Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Machinery & Tools Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Adjustments","Number of Excise Tax Assessments Adjusted"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Payroll Checks:  County"]
["Monthly","Annual (Calendar)","Keystone","Financial Management","Number of Payroll Checks:  Schools"]
["Monthly","Annual (Calendar)","Thomas Brothers","Financial Management","Number of Payroll Checks: DSS"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Vendor Checks:  County"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Vendor Checks:  Schools"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Vendor Checks: DSS"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Special Welfare Checks"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of \"State\" Checks / ACHs"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Total Number of Checks Issued"]
["Monthly","Annual (Calendar)",null,"Financial Management","Number of Payroll Direct Deposits:  Co, PRJ, PRL, SS"]
["Monthly","Annual (Calendar)",null,"Financial Management","Number of Payroll Direct Deposits:  Schools"]
["Monthly","Annual (Calendar)",null,"Financial Management","Number of Payroll Direct Deposits"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of ACH transactions Issued"]
["Monthly","Annual (Calendar)","Bank","Financial Management","Number of Wire transactions Issued"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of E-Check Batches Transmitted to Bank"]
["Monthly","Annual (Calendar)","Collections Database","Financial Management","Number of Returned Checks:  Taxes & Non-Taxes (Excl. Cafeteria)"]
["Monthly","Annual (Calendar)","Collections Database","Financial Management","Number of Returned Checks:  School Cafeteria"]
["Monthly","Annual (Calendar)","Bank","Financial Management","Number of Escrow Accounts Opened"]
["Monthly","Annual (Calendar)","Bank","Financial Management","Number of Escrow Accounts Additional Deposits"]
["Monthly","Annual (Calendar)","Bank","Financial Management","Number of Escrow Accounts Closed"]
["Monthly","Annual (Calendar)","Bank","Financial Management","Number of Positive Pay Exceptions"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Transactions Entered by Accounting Department in G/L"]
["Monthly","Annual (Calendar)","BAI","Financial Management","Number of Correcting Entries Requested by Other Departments"]