General Instructions to Complete the Annual Financial Statement Workbook
-
a)
This workbook is composed of several individual worksheets to complete the Annual Financial Statement.
-
b)
It is designed to automatically calculate linked schedules from each of the data entry points.
-
c)
The individual spreadsheets containing formulas are locked to protect the formulas.
-
d)
Fill in only the gray sections of the worksheet.
-
e)
Begin by navigating to the "Key Inputs" tab.
-
f)
Select the Municipality or County by clicking on the arrow on the right side of cell D8. This will populate the municipality/county and dates throughout the workbook. Continue to complete each of the fields in order to populate throughout the workbook. Enter the exact number of utilities and the utility types. Do not skip sets of utility pages.
-
g)
In all applicable signature lines insert the email address of the applicable official.
-
h)
The completed AFS must be submitted to the Division via the FAST portal with a file name of: xxxx_afs_20xx.xlsm (provide 4 digits municode and year). It must be saved as a Macro-Enabled Workbook.
-
i)
Only the Chief Financial Officer has access to the "Submit for Review" tab within the FAST portal.
-
j)
If copying data from a prior workbook, copy and use Paste Values to preserve formatting.
-
k)
On the Key Inputs tab, users can select "Standard" or "Expanded" for a variety of sections to reduce the number of unused pages throughout the document. The following sheets can be adjusted: 6, 6b, 9a, 10, 11, 12, 17a, 20, 35, and 37. All sections are preset to "Standard" and should only be switched to "Expanded" if more pages are needed.