Fee Report Instructions Instructions - Fiscal Year 2019-20 G.S. 143C-9-4 mandates that state agencies, universities, boards, and commissions submit a complete report of all funds received during the fiscal year for the use of a property, the provision of a service, or the exercise of a regulated privilege. This information is collected and compiled by OSBM into an annual Fee Report. The web-based NC Fee Report collection system will be open for data entry on or before Monday, February 15, 2021 and is to be completed by Friday, March 19, 2021. Getting Started Each Fee Report contact at the agency / board / commission / university will be sent a link to the online spreadsheet collection form in the Smartsheet application. You are welcome to share this link with others in your organization if multiple people need to edit the data. The spreadsheet contains one row for each Fee with columns that collect data about that fee. When possible, information from the prior year’s Fee Report has been defaulted into the spreadsheet. All defaulted information should be checked and updated as needed. All rows require that the following new information be provided for the fiscal year: the number of times the fee was collected in FY2019-20 the total dollar amount collected for that fee in FY2019-20 You may Add new rows to provide a listing for a fee not shown by default. A fee that is no longer needed can indicated on the column labeled “Check box if Fee should be deleted.” All data provided will be incorporated into a report that is sent to the Legislature and posted publicly. Please be aware of spelling and grammar. Data Definitions Data definitions for each column of the Smartsheet Fee Report collection spreadsheet can be found in this Fee Report Data Definitions document. Important fields to note: Number Collected - This Fee Only The value represents the number of times the fee described on the row was collected during FY 2019-20. If your collection period was different than the fiscal year, please note that in the Comments column. Amount Collected - This Fee Only The value represents the dollar amount collected in FY 2019-20 for the fee described on that row. If your collection period was different than the fiscal year, please note that in the Comments column. NCAS Amount - Total for All Fees in Account This value represents the amount reported for the entire Budget Code / Fund Code / Account Code combination in NCAS. This value is NOT editable. If there are several fees under the same Budget Code / Fund Code / Account Code structure, this number may be repeated on each row. This is by design. For Organizations with a Large Number of Fees Because Smartsheet has standard spreadsheet features, you can copy and paste between rows, or drag down to copy across rows. You can use the filter on the toolbar to filter by Budget Code, Fund Code or Account Code. Or you can create your own filters. You can work with the spreadsheet directly in Smartsheet, or you can export to Excel if it is easier to review the data outside of Smartsheet. But you must return to Smartsheet to make the updates in the application. Please do not email spreadsheets to OSBM. Smartsheet History Tracking Smartsheet automatically tracks all changes to the spreadsheet. Each time a cell is adjusted, the system will record the value that changed along with the user that made the change. Assistance For questions about completing the forms, contact Susie Esealuka, Office of State Budget and Management at 984-236-0629.
Fee Report Instructions Instructions - Fiscal Year 2019-20 G.S. 143C-9-4 mandates that state agencies, universities, boards, and commissions submit a complete report of all funds received during the fiscal year for the use of a property, the provision of a service, or the exercise of a regulated privilege. This information is collected and compiled by OSBM into an annual Fee Report. The web-based NC Fee Report collection system will be open for data entry on or before Monday, February 15, 2021 and is to be completed by Friday, March 19, 2021. Getting Started Each Fee Report contact at the agency / board / commission / university will be sent a link to the online spreadsheet collection form in the Smartsheet application. You are welcome to share this link with others in your organization if multiple people need to edit the data. The spreadsheet contains one row for each Fee with columns that collect data about that fee. When possible, information from the prior year’s Fee Report has been defaulted into the spreadsheet. All defaulted information should be checked and updated as needed. All rows require that the following new information be provided for the fiscal year: the number of times the fee was collected in FY2019-20 the total dollar amount collected for that fee in FY2019-20 You may Add new rows to provide a listing for a fee not shown by default. A fee that is no longer needed can indicated on the column labeled “Check box if Fee should be deleted.” All data provided will be incorporated into a report that is sent to the Legislature and posted publicly. Please be aware of spelling and grammar. Data Definitions Data definitions for each column of the Smartsheet Fee Report collection spreadsheet can be found in this Fee Report Data Definitions document. Important fields to note: Number Collected - This Fee Only The value represents the number of times the fee described on the row was collected during FY 2019-20. If your collection period was different than the fiscal year, please note that in the Comments column. Amount Collected - This Fee Only The value represents the dollar amount collected in FY 2019-20 for the fee described on that row. If your collection period was different than the fiscal year, please note that in the Comments column. NCAS Amount - Total for All Fees in Account This value represents the amount reported for the entire Budget Code / Fund Code / Account Code combination in NCAS. This value is NOT editable. If there are several fees under the same Budget Code / Fund Code / Account Code structure, this number may be repeated on each row. This is by design. For Organizations with a Large Number of Fees Because Smartsheet has standard spreadsheet features, you can copy and paste between rows, or drag down to copy across rows. You can use the filter on the toolbar to filter by Budget Code, Fund Code or Account Code. Or you can create your own filters. You can work with the spreadsheet directly in Smartsheet, or you can export to Excel if it is easier to review the data outside of Smartsheet. But you must return to Smartsheet to make the updates in the application. Please do not email spreadsheets to OSBM. Smartsheet History Tracking Smartsheet automatically tracks all changes to the spreadsheet. Each time a cell is adjusted, the system will record the value that changed along with the user that made the change. Assistance For questions about completing the forms, contact Susie Esealuka, Office of State Budget and Management at 984-236-0629.
