Docstoc

DogwoodGAConvWkst2009

Document Sample
DogwoodGAConvWkst2009 Powered By Docstoc
					                                                                                                                         Instructions


                                             General Instructions for Use
This workbook has been provided as a tool to facilitate your unit's conversion to the full accrual statements required by GASB
34. In preparation of this workbook, the staff of the LGC has assumed that the user has a good working knowledge of Excel.
The LGC's staff will provide accounting support for use of this workbook; however, we cannot give detailed instruction in the use
of Excel.

The user should download a blank workbook appropriate for his/her unit of government and save it permanently on a local
computer. It would be best to then make another copy for the current year's data. If for whatever reason the current file
becomes corrupted, the user should reload the blank copy from their local computer (or download another from the web) and
begin again. For maximum protection, users should save their work frequently as they enter data.

Most of the workbook is protected to prevent accidental changes in formulas and the mapping of cells. The password to
unlock the workbook is gasb34 (must be entered in lower case, no spaces). Only users with advanced Excel skills should
attempt to change the workbook by releasing the protection.

The workbook is color-coded. Blue cells are calculated numbers and are protected and locked. Yellow cells are those that
need data entered by the user. However, every yellow cell may not be applicable to your unit and can be left blank. The tan
sections on the summary worksheet are those accounts that have multiple rows included for one account to be summed at the
end of the conversion process. The purple rows are proof totals.

This workbook is mapped using cell references. Any addition of columns and/or rows could alter the formulas and corrupt the
data. There are columns and rows placed in the program in areas where we felt that you may need to add additional text and
data. Using these columns and rows will help prevent the altering of formulas and cell references. In most cases they are
named "other" funds or "other" accounts, etc. They should be obvious.

The staff has tried to anticipate the most likely scenarios for governments in North Carolina . However, it is impossible for us to
anticipate every unique situation that exists in our local governments. If you need assistance with your particular data, please
call and we will make every attempt to help you enter the data into the workbook. However, some instances will exist for which
the workbook will not make the necessary calculation. The "manual entry" columns on the summary worksheet are there for this
purpose. The user can determine the necessary entry and post it in this columns to the appropriate accounts. Be especially
aware of extraordinary and special items that have not been handled elsewhere in the workbook.

This workbook is designed to calculate the government-wide numbers for all governmental -type activities, including any internal
service funds deemed to be primarily governmental in nature. A separate workbook is available to calculate the government-
wide numbers for all business-type activities.

Sample workbooks are available for Carolina County, City of Dogwood, and Carolina Board of Education. Refer to the proper
workbook for your particular unit type. Please note that in some cases immaterial amounts have been used to demonstrate a
transaction in the three examples above. For your statements, determine materiality by the proper criteria and please do not be
mislead by the small amounts in our examples.


Specific Instructions:
This workbook is set up in a series of worksheets that address the various entries required to convert from modified to full
accrual. Some entries must be initially recorded, some are simple reclassifications, and others are allocations to programs or
functions. The workbook is based on the premise of answering a series of questions for those areas where modified and full
accrual differ in their treatment of a transaction. The answers to these questions will generate accounting entries which are
automatically mapped or linked to the conversion worksheet. Many entries are recorded only in this conversion worksheet and
are not to be recorded in the general ledger but some effect permanent accounts like capital assets, depreciation, and liabilities.
These entries must be posted to the unit's ledger accounts in order to properly reflect the beginning balances for the next year.
In each case, the specific instructions to the individual worksheets indicate whether an entry to the permanent accounts is
required.

The first worksheet is the "summary" sheet titled "Conversion Worksheet." This is the sheet to which all the other sheets post.
It is also the sheet where you will begin your data entry. The far most left columns are the trial balance columns. Please enter
your adjusted pre-closing trial balance numbers here. We have assumed that you have prepared your fund statements at this
point and that the trial balance is adjusted to reflect any changes that are needed to be made at the fund level. The prior year's
ending balances for capital assets and long-term liabilities must also be manually posted to the "Capital Assets and Long-term
Debt" column.




  f4efb566-3051-445a-9d85-3ac660dacd41.xls                                                                                            1
                                                                                                                                                   Instructions
Specific Instructions - continued

When you have worked through all the other worksheets (A-M), this sheet will have your government-wide numbers for the
governmental activities column of the Statement of Net Assets and the Statement of Activities. You may change fund titles as
you see fit but if you unprotect the sheet and add lines or columns, formulas will be effected. Please do not do so unless you
have strong Excel skills. Some "other" asset and "other" liability accounts have been added to handle the case where you need
another account. These titles can be changed but should then be used consistently throughout the workbook.

Workbook Contents:
Complete explanations and instructions are presented on each of the worksheets following the Conversion Worksheet. A brief
synopsis is presented below.
    General Instructions: synopsis and general guidelines for use of the workbook.
    Conversion worksheet: includes trial balances for all governmental funds, columns for prior year capital assets and long-
    term debt balances, and columns for posting the various reclassification, conversion, elimination and consolidation entries
    resulting in the final numbers for governmental activities for the statements.
 A. Revenue by function : allocates revenue to the proper government-wide financial statement categories (Charges for
    Services, Operating Grants and contributions, and Capital grants and contributions) and their respective programs/functions
    for presentation on the Statement of Activities. Note that these reclassification entries only change the presentation of
    revenue and will not be a factor in the reconciliation from modified to full accrual.
 B. Property taxes: addresses the prior year and current year revenue recognition for ad valorem taxes.
 C. Other revenues: addresses the prior year and current year revenue recognition for all other revenue.
 D. Depreciation: records depreciation expense for all asset classes by program/function and records unallocated amounts.
 E. Capital Outlay: converts capital outlay expenditures for items above the capitalization threshold to the proper asset class
    and reduces respective program/function expenditures.
 F. Other Capital Asset Entries: addresses all other capital asset entries, sales, trades, retirements, donations, impariment
    losses/gains, etc. and generates the correct entry to asset classes, programs/functions, and revenue or expenditure
    accounts. Please be aware that any reductions that result from a change in capitalization threshold should be recorded with
    the beginning capital asset numbers in columns AF and AG of the conversion worksheet.
G. Debt Service: converts debt service expenditures to the proper reductions in liability accounts.
 H. Debt Issues: addresses all other debt transactions including new debt issues, refunding, and amortization.
 I. Other Asset Entries: addresses the asset accounts, equity interest in joint venture, prepaid expenses, inventory, and
    advance funding of pensions.
 J. Other Liability & Expenses: addresses compensated absences, claims & judgments, net pension obligation, net OPEB
    liability and other long-term liabilities.
 K. K.1 - K.3 Internal Service Fund Allocation: There are worksheets for three internal service funds, each of which must
    serve governmental funds as the primary beneficiary. If enterprise funds are the primary beneficiary then they should be
    entered in the Business type conversion worksheet elsewhere on the website.
 L. Eliminations - Consolidations: addresses all elimination and consolidation entries related to interfund payables,
    receivables, transfers, creates the entries for recording the current portion of long-term liabilities, and records internal
    service funds for which business-type activities are the predominant user.
M. Net Asset Calculation: facilitates the determination of the net assets equity section. The resulting numbers are not
    mapped but are provided for manual entry into worksheet L to avoid circular logic.

    There may be instances in the individual worksheets where negative debits or credits are generated in an entry and we did not create formulas to reclassify
    as a positive number. If this occurs do not be alarmed, it will be corrected in the final columns of the Conversion Worksheet.


Printing:

Worksheets have been created such that they can be printed for offline review. On the Conversion worksheet, once all the detail
fund data has been entered and the grand totals are as you expected, those detail fund columns can be hidden so that one sees
the account titles on the left and then the column "Total Governmental Funds." By hiding detail columns you will be able to fit the
conversion worksheet to legal size paper. Please note that to hide columns, you must "unlock" the worksheet. We suggest that
once fund detail is verified that you unlock the worksheet, hide the detail fund columns, and then re-protect the worksheet in
order not to overwrite formulas and mapping. All other worksheets fit on standard 8.5x11 paper. Some worksheets result in such
complicated entries that a work section is presented below the final entry to accumulate all activity. These work sections are not
defined in the normal print range. If you wish to print the work sections, you will need to select the work section for printing or
redefine your print ranges. Please note that the work sections are often larger than regular 8.5x11 paper.



Note:
Cross-referencing has been used throughout the workbook to tie together relevant numbers and or comments to better clarify an
entry. In each case we have used the following denotation j k l (circled numbers) which uses the font type "Wingdings2." If
your computer does not support this font you may see Greek alphabetic characters or some other notation. We apologize for any
  f4efb566-3051-445a-9d85-3ac660dacd41.xls
confusion but notes and numbers will still cross-reference consistently by whatever character your computer displays.         2
Cross-referencing has been used throughout the workbook to tie together relevant numbers and or comments to better clarify an
entry. In each case we have used the following denotation j k l (circled numbers) which uses the font type "Wingdings2." If
                                                                                                                      Instructions
your computer does not support this font you may see Greek alphabetic characters or some other notation. We apologize for any
confusion but notes and numbers will still cross-reference consistently by whatever character your computer displays.




  f4efb566-3051-445a-9d85-3ac660dacd41.xls                                                                                      3
                     4/12/2011 ... 9:50 AM                                                                                                                                                                                                                      City of Dogwood                                                                                                                                                                                                                                                                                                     4
                                                                                                                                                                                                                                                          GASB 34 Conversion Worksheet
                                                                                                                                                                                                                            to prepare the Government-wide Statements - (including adjustments and consolidations)




                                                     Notes 1 & 2 --- Data is entered                                                          Notes 1 & 2 --- Data is entered                                                                  One column on the govt funds
                                                                                                                                                                                                                                                                         Grand total of major + non-major   Note 3 - Data must be Entered   Note 4 -- Entry A.1 from   Note 5: Conversion and annual accruals                 Note 6: Reclassifications, eliminations, and     Manually Posted         -- Computed --                                  --- Computed ---
    Accounts in tan have multiple                                                                                                                                                                                                              statement -- computed funds -- computed                      below to the proper accounts             Worksheet A                  Entries from Worksheets B - J                consolidation entries - Worksheets K & L           Entries

    lines to which entries are posted.                                                   Major Governmental Funds                                            Non-major Governmental Funds                                                                                          Total                       Capital Assets and             Reclassification of                                                                    Reclassifications and                   Other Misc Entries                                      Statement of                         Statement of
                                                          General Fund                 Emergency Telephone   Parking & Recreation Major Fund #4   Grant Project   Cemetery CareOther Non-Major #3
                                                                                                                                                                                          Other Non-Major #4    Other Non-Major #6 Other Non-Major #8
                                                                                                                                                                                                     Other Non-Major #5    Other Non-Major #7  Subtotal Non-Major            Governmental Funds             Long-term Debt Accounts          Revenues by Function                    Conversion Entries                                  Eliminations                           As Needed           Working Column                     Activities                          Net Assets
                          Description                     Dr         Cr                  Dr          Cr         Dr         Cr       Dr    Cr      Dr        Cr      Dr       Cr     Dr   Cr     Dr  Cr     Dr  Cr     Dr  Cr     Dr  Cr Dr Cr      Dr       Cr                Dr           Cr                   Dr            Cr               Dr            Cr         Ref          Dr        Ref                Cr        Ref        Dr         Ref      Cr                   Dr       Cr        Dr            Cr                 Dr            Cr                 Dr                  Cr
Balance Sheet Accounts
 Assets
    Cash and cash equivalents                           459,332                           8,000                  23,400                             -                    24,681                                                                  24,681            -         515,413                 -                                                                                                                      K.1-3       25,730                                                     541,143                   -                                       541,143
    Restricted cash                                                                                                                                                                                                                                 -              -             -                   -                                                                                                                                                                                                 -                     -                                                                -
    Investments                                                                                                                                                                                                                                     -              -             -                   -                                                                                                                      K.1-3            -                                                         -                     -                                                                -
    Taxes receivable                                     63,235                                                                                                                                                                                     -              -          63,235                 -                                                                                                                                                                                              63,235                   -                                        63,235
    Allowance for uncollectible tax accounts                                                                                                                                                                                                        -              -             -                   -                                                                                                                                                                                                 -                     -                                                                -
    Accrued interest receivable on taxes                                                                                                                                                                                                            -              -             -                   -                                                                  B.1           11,844                                                                                                        11,844                   -                                        12,949
                                                                                                                                                                                                                                                    -              -             -                   -                                                                  B.2            1,105      B.2                  -                                                                             1,105                   -
                                                                                                                                                                                                                                                    -              -             -                   -                                                                  C.1              -                                                                                                             -                     -
    Allowance for uncollectible interest                                                                                                                                                                                                            -              -             -                   -                                                                                                                                                                                                 -                     -                                                                -
    Accounts receivable                                      874                          4,415                                                                                 375                                                                 375            -           5,664                 -                                                                                                                                                                                               5,664                   -                                            5,664
    Allowance for uncollectible accounts                                                                                                                                                                                                            -              -             -                   -                                                                                                                                                                                                 -                     -                                                                -
    Special assessments receivable                                                                                                                                                                                                                  -              -             -                   -                                                                                                                                                                                                 -                     -                                                                -
    Due from other funds                                                                                                                                                                                                                            -              -             -                   -                                                                                                                      K.1-3         2,600       L.2              -                             2,600                   -                                                                -
                                                                                                                                                                                                                                                    -              -             -                   -                                                                                                                                                L.3            2,600                             -                   2,600
                                                                                                                                                                                                                                                    -              -             -                   -                                                                                                                                                L.4              -                               -                     -
    Due from fiduciary funds                                                                                                                                                                                                                        -              -             -                   -                                                                                                                       L.4             -                                                         -                     -                                                                -
    Due from other governments                           82,300                          10,000                                                   5,000                                                                                           5,000            -          97,300                 -                                                                                                                                                                                              97,300                   -                                        97,300
    Due from component unit                               3,700                                                                                                                                                                                     -              -           3,700                 -                                                                                                                                                                                               3,700                   -                                         3,700
    Internal balances                                                                                                                                                                                                                               -              -             -                   -                                                                                                                       L.3            400      K.1-3             300                             400                   300                                         100
                                                                                                                                                                                                                                                    -              -             -                   -                                                                                                                       L.8            -         L.8              -                               -                     -
    Inventories                                           1,245                                                                                                                                                                                     -              -           1,245                 -                                                                                                                      K.1-3         2,700                                                      3,945                   -                                            3,945
    Prepaid items                                                                                                                                                                                                                                   -              -             -                   -                                                                                                                      K.1-3           -                                                          -                     -                                                                -
    Advances to other funds                                                                                                                                                                                                                         -              -             -                   -                                                                                                                      K.1-3           -         L.2               -                              -                     -                                                                -
                                                                                                                                                                                                                                                    -              -             -                   -                                                                                                                                                L.3               -                              -                     -
    Intangible asset - advance funding of pension
    obligation                                                                                                                                                                                                                                        -            -              -                  -                                                                  I.1             -                                                                                                               -                     -                                                               -
    Deferred Charges - Issuance cost                                                                                                                                                                                                                  -            -              -                  -                                                                  H.1             -         H.1                  -                                                                                -                     -                                                               -
    Deferred Charges - refunding                                                                                                                                                                                                                      -            -              -                  -                                                                  H.1             -         H.1                  -                                                                                -                     -                                                               -
    Land                                                                                                                                                                                                                                              -            -              -                  -           164,770                                                E.1             -         F.1                  -    K.1-3            -                                                      164,770                   -                                      176,770
                                                                                                                                                                                                                                                      -            -              -                  -                                                                  F.1             -         F.4                  -                                                                                -                     -
                                                                                                                                                                                                                                                      -            -              -                  -                                                                  F.2          12,000                                                                                                          12,000                   -
                                                                                                                                                                                                                                                                                                                                                                        F.4             -                                                                                                               -                     -
    Construction in progress                                                                                                                                                                                                                          -           -               -                 -            103,000                                                E.1         590,000                                                                                                         693,000                   -                                      693,000
    Other non-depreciable assets                                                                                                                                                                                                                      -           -               -                 -                                                                                                                                                                                                   -                     -                                                               -
    Buildings                                                                                                                                                                                                                                         -           -               -                 -         2,451,086                                                 E.1         395,240        F.1                -     K.1-3       26,000                                                    2,872,326                   -                                    2,603,581
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -          F.4            268,745                                                                               -                 268,745
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum. Depreciation - Buildings                                                                                                                                                                                                                   -           -               -                 -                          1,056,594                                F.1             -         D.1              22,148                            K.1-3         26,000                               -               1,104,742                                                   1,104,742
    Improvements other than buildings                                                                                                                                                                                                                 -           -               -                 -            599,494                                                E.1             -         F.1                 -                                                                             599,494                   -                                      599,494
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -         F.4                 -                                                                                 -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum. Depreciation - Improvements                                                                                                                                                                                                                -           -               -                 -                            414,058                                F.1             -         D.1              22,403                                                                               -                 436,461                                                        436,461
    Equipment                                                                                                                                                                                                                                         -           -               -                 -            739,517                                                E.1          89,499       F.1              21,350   K.1-3       35,000                                                      864,016                21,350                                    842,666
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -         F.4                 -                                                                                 -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum. Depreciation - Equipment                                                                                                                                                                                                                   -           -               -                 -                            488,538                                F.1          21,350       D.1              65,785                            K.1-3         12,830                            21,350               567,153                                                        545,803
    Vehicles & motorized equip.                                                                                                                                                                                                                       -           -               -                 -            472,015                                                E.1          40,200       F.1              42,695   K.1-3       10,000                                                      522,215                42,695                                    479,520
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -         F.4                 -                                                                                 -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum. Depreciation - Vehicles + Mot. Equip                                                                                                                                                                                                       -           -               -                 -                            292,199                                F.1          42,695       D.1              76,122                            K.1-3           7,500                           42,695               375,821                                                        333,126
    Infrastructure                                                                                                                                                                                                                                    -           -               -                 -         2,457,863                                                 E.1             -         F.1                 -                                                                           2,457,863                   -                                    2,457,863
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -         F.4                 -                                                                                 -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum. Depreciation - Infrastructure                                                                                                                                                                                                              -           -               -                 -                          1,001,052                                F.1             -         D.1              54,852                                                                               -               1,055,904                                                   1,055,904
    Other asset class 1                                                                                                                                                                                                                               -           -               -                 -                                                                   E.1             -         F.1                 -                                                                                 -                     -                                                           -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -         F.4                 -                                                                                 -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum. Depreciation - asset class 1                                                                                                                                                                                                               -           -               -                 -                                                                   F.1             -         D.1                  -                                                                                -                     -                                                               -
    Other asset class 2                                                                                                                                                                                                                               -           -               -                 -                                                                   E.1             -         F.1                  -                                                                                -                     -                                                               -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.1             -         F.4                  -                                                                                -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   F.2             -                                                                                                               -                     -
    Accum Depreciation - asset class 2                                                                                                                                                                                                                -           -               -                 -                                                                   F.1             -         D.1                  -                                                                                -                     -                                                              -
    Net investment in joint venture                                                                                                                                                                                                                   -           -               -                 -                                                                   I.1             -                                                                                                               -                     -                                                              -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
  Liabilities                                                                                                                                                                                                                                         -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
     Accounts payable & accrued liabilities                            103,874                        17,000                                                  5,000                                                                                   -         5,000             -             125,874                                                                                                                                              K.1-3           2,900                              -                 128,774                                                        128,774
     Miscellaneous liabilities                                                                                                                                                                                                                        -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
     Contract retainage                                                                                                                                                                                                                               -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
     Due to other funds                                                   2,200                                                                                                                                                                       -           -               -               2,200                                                                                                                      L.2            -        K.1-3              -                               -                   2,200                                                            -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                                                                        L.3          2,200                                                       2,200                   -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                                                                        L.4            -                                                           -                     -
    Due to other governments                                              6,055                                                                                                                                                                       -           -               -               6,055                                                                                                                                                                                                 -                   6,055                                                          6,055
    Deferred revenue                                                     57,180                                                                                                                                                                       -           -               -              57,180                                                                 B.2           57,180      C.1                  -                                                                             57,180                57,180                                                            -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                   C.1              -                                                                                                              -                     -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                                                                                                                                                   -                     -
    Unearned revenue                                                     15,502                                                                                                                                                                       -           -               -              15,502                                                                                                                                                                                                 -                  15,502                                                         15,502
    Customer deposits                                                                                                                                                                                                                                 -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
    Due to primary government                                                                                                                                                                                                                         -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
    Due to fiduciary funds                                                                                                                                                                                                                            -           -               -                 -                                                                                                                                                 L.4               -                               -                     -                                                              -
    Intergovernmental payable                                                                                                                                                                                                                         -           -               -                 -                                                                                                                                                                                                   -                     -                                                              -
    Advances from other funds                                                                                                                                                                                                                         -           -               -                 -                                                                                                                        L.2             -       K.1-3              -                               -                     -                                                              -
                                                                                                                                                                                                                                                      -           -               -                 -                                                                                                                        L.3             -                                                          -                     -

    Accrued interest payable                                                                                                                                                                                                                          -            -              -                  -                                                                  G.3               -       G.2               1,355                                                                              -                   1,355                                            -              2,133
                                                                                                                                                                                                                                                                                                                                                                                                  G.3                 778                                                                              -                     778
    Claims payable - current                                                                                                                                                                                                                          -            -              -                  -                                                                                                                                                L.6             -                                -                     -                                                               -
    COPs payable - current                                                                                                                                                                                                                            -            -              -                  -                                                                                                                                                L.6          10,000                              -                  10,000                                                          10,000
    Bonds payable - current                                                                                                                                                                                                                           -            -              -                  -                                                                                                                                                L.6          10,000                              -                  10,000                                                          10,000
    Notes payable - current                                                                                                                                                                                                                           -            -              -                  -                                                                                                                                                L.6             -                                -                     -                                                               -
    Capital leases - current                                                                                                                                                                                                                          -            -              -                  -                                                                                                                                                L.6           8,434                              -                   8,434                                                           8,434
    Compensated absences - current                                                                                                                                                                                                                    -            -              -                  -                                                                                                                                                L.6          37,750                              -                  37,750                                                          37,750
    Other long-term liability #1 - current                                                                                                                                                                                                            -            -              -                  -                                                                                                                                                L.6             -                                -                     -                                                               -
    Other long-term liability #2 - current                                                                                                                                                                                                            -            -              -                  -                                                                                                                                                L.6             -                                -                     -                                                               -
    Liabilities payable from restricted assets                                                                                                                                                                                                        -            -              -                  -                                                                                                                                                                                                 -                     -                                                               -
    General obligation bonds                                                                                                                                                                                                                          -            -              -                  -                             70,000                               G.1           10,000                                 L.6        10,000                                                      20,000                70,000                                                          50,000
                                                                                                                                                                                                                                                      -            -              -                  -                                                                  H.1              -        H.1                 -                                                                                -                     -
    Premium - GO Bonds                                                                                                                                                                                                                                -            -              -                  -                                                                  H.1              -        H.1                 -                                                                                -                     -                                                               -
    Discount - GO Bonds - contra-liability                                                                                                                                                                                                            -            -              -                  -                                                                  H.1              -        H.1                 -                                                                                -                     -                                                               -
    Bond anticipation notes                                                                                                                                                                                                                           -            -              -                  -                                                                  G.1              -        H.1                 -                                                                                -                     -                                                               -
    Installment purchases/COPS                                                                                                                                                                                                                        -            -              -                  -                                                                  G.1              -        H.1             200,000    L.6        10,000                                                      10,000               200,000                                                         190,000
    Capital leases payable                                                                                                                                                                                                                            -            -              -                  -                              7,352                               G.1            1,975      H.1              19,000    L.6         8,434                                                      10,409                26,352                                                          15,943
    Notes and loans payable                                                                                                                                                                                                                           -            -              -                  -                                                                                                                       L.6           -         K.1-3              -                              -                     -                                                               -

                     f4efb566-3051-445a-9d85-3ac660dacd41.xls
                                                4/12/2011 ... 9:50 AM                                                                                                                                                                                                                          City of Dogwood                                                                                                                                                                                                                                                                                                                   5
                                                                                                                                                                                                                                                                                         GASB 34 Conversion Worksheet
                                                                                                                                                                                                                                                           to prepare the Government-wide Statements - (including adjustments and consolidations)




                                                                                    Notes 1 & 2 --- Data is entered                                                          Notes 1 & 2 --- Data is entered                                                                  One column on the govt funds
                                                                                                                                                                                                                                                                                                        Grand total of major + non-major   Note 3 - Data must be Entered   Note 4 -- Entry A.1 from           Note 5: Conversion and annual accruals                 Note 6: Reclassifications, eliminations, and      Manually Posted         -- Computed --                                       --- Computed ---
                              Accounts in tan have multiple                                                                                                                                                                                                                   statement -- computed funds -- computed                      below to the proper accounts             Worksheet A                          Entries from Worksheets B - J                consolidation entries - Worksheets K & L            Entries

                              lines to which entries are posted.                                                        Major Governmental Funds                                            Non-major Governmental Funds                                                                                          Total                       Capital Assets and             Reclassification of                                                                            Reclassifications and                    Other Misc Entries                                        Statement of                            Statement of
                                                                                         General Fund                 Emergency Telephone   Parking & Recreation Major Fund #4   Grant Project   Cemetery CareOther Non-Major #3
                                                                                                                                                                                                                         Other Non-Major #4    Other Non-Major #6 Other Non-Major #8
                                                                                                                                                                                                                                    Other Non-Major #5    Other Non-Major #7  Subtotal Non-Major            Governmental Funds             Long-term Debt Accounts          Revenues by Function                            Conversion Entries                                  Eliminations                            As Needed           Working Column                       Activities                             Net Assets
                                                   Description                           Dr         Cr                  Dr          Cr         Dr         Cr       Dr    Cr      Dr        Cr      Dr       Cr     Dr   Cr     Dr  Cr     Dr  Cr     Dr  Cr     Dr  Cr Dr Cr      Dr       Cr                Dr           Cr                   Dr            Cr               Dr            Cr                 Ref          Dr        Ref                Cr        Ref        Dr         Ref      Cr                    Dr       Cr        Dr            Cr                   Dr            Cr                    Dr                  Cr
                              Compensated absences payable                                                                                                                                                                                                                           -          -                -                 -                            120,460                                        J.1               -       J.1              46,763   L.6         37,750       K.1-3           2,400                            37,750               169,623                                                          131,873
                              Claims and judgments                                                                                                                                                                                                                                   -          -                -                 -                                                                                                     J.1                 -     L.6            -         K.1-3             -                                 -                     -                                                                -
                              Other long-term liability #1                                                                                                                                                                                                                           -          -                -                 -                                                                           J.1               -       J.1                 -     L.6            -                                                             -                     -                                                                -
                              Other long-term liability #2                                                                                                                                                                                                                           -          -                -                 -                                                                           J.1               -       J.1                 -     L.6            -                                                             -                     -                                                                -
                              Net pension obligation                                                                                                                                                                                                                                 -          -                -                 -                             38,083                                                                  J.1               6,636                                                                                -                  44,719                                                           44,719
                              Net OPEB obligation                                                                                                                                                                                                                                    -          -                -                 -                                -                                                                    J.1              37,044                            K.1-3            -                                  -                  37,044                                                           37,044
                              Fund Equity - Beginning                                                 410,276                         5,453                                                                    19,808                                                                -       19,808              -             435,537          235,895       3,735,304                                        G.2            1,355      B.1              71,447                            K.1-3         47,770                            237,250             4,290,058                                               -        4,052,808
                                                                                                                                                                                                                                                                                     -          -                -                 -                                                                                                     C.1                 -     L.8              -        L.8             -                                  -                     -
                                                                                                                                                                                                                                                                                     -          -                -                 -                                                                                                     I.1                 -                                                                                  -                     -
                                                                                                                                                                                                                                                                                                                                                                                                                                                                   L.9     4,416,667                                                      4,416,667                   -
                                 Change in net assets                                                                                                                                                                                                                                -            -              -                  -                                                                                                                                                                                                           -                     -                                               -               363,859
                                 Reclassification to net assets                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                           -                     -                                         4,416,667
                                                                                                                                                                                                                                                                                     -            -              -                  -
   Net Assets                                                                                                                                                                                                                                                                        -            -              -                  -                                                                                                                                                                                                           -                     -
     Invested in capital assets net of related debt                                                                                                                                                                                                                                  -            -              -                  -                                                                                                                                                        L.9      4,092,481                                 -               4,092,481                                                        4,092,481
     Restricted for Capital Projects                                                                                                                                                                                                                                                 -            -              -                  -                                                                                                                                                        L.9         10,000                                 -                  10,000                                                           10,000
  Government-wide Statement




     Restricted for Debt Service                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                        L.9            -                                   -                     -                                                                -
     Restricted for Transportation                                                                                                                                                                                                                                                   -            -              -                  -                                                                                                                                                        L.9          4,084                                 -                   4,084                                                            4,084
     Restricted for Public Safety                                                                                                                                                                                                                                                    -            -              -                  -                                                                                                                                                        L.9          5,415                                 -                   5,415                                                            5,415
     Restricted for Economic Development                                                                                                                                                                                                                                             -            -              -                  -                                                                                                                                                        L.9            -                                   -                     -                                                                -
     Restricted for Cultural and Recreation                                                                                                                                                                                                                                          -            -              -                  -                                                                                                                                                        L.9         25,056                                 -                  25,056                                                           25,056
     Restricted for Other restrictions #1                                                                                                                                                                                                                                            -            -              -                  -                                                                                                                                                        L.9            -                                   -                     -                                                                -
     Restricted for Other restrictions #2                                                                                                                                                                                                                                            -            -              -                  -                                                                                                                                                        L.9            -                                   -                     -                                                                -
     Restricted for Other restrictions #3                                                                                                                                                                                                                                            -            -              -                  -                                                                                                                                                        L.9            -                                   -                     -                                                                -
     Unrestricted                                                                                                                                                                                                                                                                    -            -              -                  -                                                                                                                                                        L.9        279,631                                 -                 279,631                                                          279,631
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                     -                                                                -
Operating Accounts - Revenues                                                                                                                                                                                                                                                        -            -              -                  -                                                                                                                                                                                                           -                     -        Proof totals for Net Assets    12,997,597        12,997,597
                              Taxes - Ad valorem …………………...(General)                                  829,577                                                                                                                                                                        -          -                -            829,577                                                                          B.1           59,603      B.2              58,285                                                                             59,603               887,862                     828,259
                              Other taxes & licenses…………………..(General)                                 53,314                           -                                                                                                                                            -          -                -             53,314                                             -                            C.1              -        C.1                 -                                                                                  -                  53,314                      53,314
                              Unrestricted intergovernmental..(Typically general)                     702,269                                                                                                                                                                        -          -                -            702,269                                             -                            C.1              -        C.1                 -                                                                                  -                 702,269                     702,269
                              Restricted intergovernmental…………...(Program)                            166,334                       785,000              200,000                          115,000                                                                                    -      115,000              -          1,266,334                                       1,266,334                          C.1              -        C.1                 -                                                                            1,266,334             1,266,334                         -
                              Permits and fees…………….(Charges for services)                             13,160                                                                                                                                                                        -          -                -             13,160                                          13,160                          C.1              -        C.1                 -                                                                               13,160                13,160                         -
                              Sales & services…………….(Charges for services)                             22,007                                                                                                   4,836                                                                -        4,836              -             26,843                                          26,843                          C.1              -        C.1                 -                                                                               26,843                26,843                         -
                              Investment earnings……………..(Typically general)                            23,804                                              5,000                                                  412                                                                -          412              -             29,216                                           5,412                          C.1              -        C.1                 -     L.7              -       K.1-3             700                             5,412                29,916                      24,504
                              Miscellaneous……………………(Typically general)                                    183                                                                                                                                                                        -          -                -                183                                             -                            C.1              -        C.1                 -                               L.10             -                                 -                     183                      73,438
                                                                                                                                                                                                                                                                                     -          -                -                -                                                                            F.1              -        F.1               5,000                                                                                -                   5,000
                                                                                                                                                                                                                                                                                     -          -                -                -                                                                            F.1              -        F.2              12,000                                                                                -                  12,000
                                                                                                                                                                                                                                                                                     -          -                -                -                                                                            I.1              -        F.4              56,255                                                                                -                  56,255
                                                                                                                                                                                                                                                                                     -          -                -                -                                                                            I.1              -        I.1                 -                                                                                  -                     -
                              Other revenue 1                                                                                                                                                                                                                                        -          -                -                -                                                  -                                                                                                                                                          -                     -                             -
                              Other revenue 2                                                                                                                                                                                                                                        -          -                -                -                                                  -                                                                                                                                                          -                     -                             -
                                                                                                                                                                                                                                                                                     -          -                -                -                                                                                                                                                                                                             -                     -                             -
   General Government                                                                                                                                                                                                                                                                -          -                -                -                                                                                                                                                                                                             -                     -                             -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -          -                -                -                                                                     -      C.1               -       C.1                  -    L.5              -       K.1-3             330                               -                     330                           330
     Operating Grants & Contributions                                                                                                                                                                                                                                                -          -                -                -                                                                     -      C.1               -       C.1                  -                              L.7              -                                 -                     -                             -
                              Capital Grants & Contributions                                                                                                                                                                                                                         -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                    -                            -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
   Public Safety                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                             13,160       C.1               -       C.1                  -                                                                                 -                 13,160                       13,160
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                            815,877       C.1               -       C.1                  -                              L.7               -                                -                815,877                      815,877
     Capital Grants & Contributions                                                                                                                                                                                                                                                  -            -              -                  -                                                                -         C.1               -       C.1                  -                              L.7               -                                -                    -                            -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
   Transportation                                                                                                                                                                                                                                                                    -            -              -                  -                                                                                                                                                                                                           -                    -                            -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                                -         C.1               -       C.1                  -    L.5              -                                                           -                    -                            -
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                            132,457       C.1               -       C.1                  -                              L.7               -                                -                132,457                      132,457
     Capital Grants & Contributions                                                                                                                                                                                                                                                  -            -              -                  -                                                                -         C.1               -       C.1                  -                              L.7               -                                -                    -                            -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
   Economic and Physical Development                                                                                                                                                                                                                                                 -            -              -                  -                                                                                                                                                                                                           -                    -                            -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                                -         C.1               -       C.1                  -                                                                                 -                    -                            -
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                             88,402       C.1               -       C.1                  -                              L.7               -                                -                 88,402                       88,402
                              Capital Grants & Contributions                                                                                                                                                                                                                         -            -              -                  -                                                             26,598       C.1               -       C.1                  -                              L.7               -                                -                 26,598                        26,598
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                             -
   Environmental Protection                                                                                                                                                                                                                                                          -            -              -                  -                                                                                                                                                                                                           -                    -                             -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                                   -      C.1               -       C.1                  -                                                                                 -                    -                             -
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                                 3,000    C.1               -       C.1                  -                              L.7               -                                -                  3,000                         3,000
                              Capital Grants & Contributions                                                                                                                                                                                                                         -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                     -                              -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                     -                              -
   Human Services                                                                                                                                                                                                                                                                    -            -              -                  -                                                                                                                                                                                                           -                     -                              -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                                   -      C.1               -       C.1                  -                                                                                 -                     -                              -
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                     -                              -
                              Capital Grants & Contributions                                                                                                                                                                                                                         -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                    -                            -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
   Cultural & Recreation                                                                                                                                                                                                                                                             -            -              -                  -                                                                                                                                                                                                           -                    -                            -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                             26,843       C.1               -       C.1                  -                                                                                 -                 26,843                       26,843
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                                412       C.1               -       C.1                  -                              L.7               -                                -                    412                          412
     Capital Grants & Contributions                                                                                                                                                                                                                                                  -            -              -                  -                                                            205,000       C.1               -       C.1                  -                              L.7               -                                -                205,000                      205,000
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
   Other program 1                                                                                                                                                                                                                                                                   -            -              -                  -                                                                                                                                                                                                           -                    -                            -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                                   -      C.1               -       C.1                  -                                                                                 -                    -                            -
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                    -                            -
     Capital Grants & Contributions                                                                                                                                                                                                                                                  -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                    -                            -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
   Other program 2                                                                                                                                                                                                                                                                   -            -              -                  -                                                                                                                                                                                                           -                    -                            -
 Govt-wide




     Charges for Services                                                                                                                                                                                                                                                            -            -              -                  -                                                                   -      C.1               -       C.1                  -                                                                                 -                    -                            -
     Operating Grants & Contributions                                                                                                                                                                                                                                                -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                    -                            -
     Capital Grants & Contributions                                                                                                                                                                                                                                                  -            -              -                  -                                                                   -      C.1               -       C.1                  -                              L.7               -                                -                    -                            -
                                                                                                                                                                                                                                                                                     -            -              -                  -                                                                                                                                                                                                           -                    -                            -
Operating Accounts - Expenditures                                                                                                                                                                                                                                                    -            -             -                   -                                                                                                                                                                                                           -                    -                               -
                                                                                                                                                                                                                                                                                     -            -             -                   -                                                                                                                                                                                                           -                    -                               -
   General Government                                                                 565,050                                                                                                                                                                                        -            -         565,050                 -                                                                          D.1           28,779      E.1             420,884   K.1-3           300      K.1-3               36                          594,129              420,920     187,099
                                                                                                                                                                                                                                                                                     -            -             -                   -                                                                          F.1              -        I.1                   4    L.7            -         L.5               -                                -                      4
                                                                                                                                                                                                                                                                                     -            -             -                   -                                                                          H.1              -        J.1                 -      L.8            -         L.8               -                                -                    -
                                                                                                                                                                                                                                                                                     -            -             -                   -                                                                          J.1           13,894                                L.10            -                                                         13,894                  -
                                                                                                                                                                                                                                                                                                                                                                                                               F.4              -                                                                                                               -                    -
                                                                                                                                                                                                                                                                                     -            -            -                    -                                                                                                                                                                                                           -                    -
   Public Safety                                                                      524,736                          785,038                                                                                                                                                       -            -      1,309,774                  -                                                                          D.1           17,115      E.1              25,989   L.7              -       K.1-3           1,022                         1,326,889               27,011    1,352,817
                                                                                                                                                                                                                                                                                     -            -            -                    -                                                                          J.1           52,968      I.1                  29                                                                             52,968                   29
                                                                                                                                                                                                                                                                                     -            -            -                    -                                                                          F.3              -        J.1                 -     L.8              -        L.8               -                                -                    -


                                                f4efb566-3051-445a-9d85-3ac660dacd41.xls
                       4/12/2011 ... 9:50 AM                                                                                                                                                                                                                                    City of Dogwood                                                                                                                                                                                                                                                                                                          6
                                                                                                                                                                                                                                                                          GASB 34 Conversion Worksheet
                                                                                                                                                                                                                                          to prepare the Government-wide Statements - (including adjustments and consolidations)




                                                            Notes 1 & 2 --- Data is entered                                                                Notes 1 & 2 --- Data is entered                                                                     One column on the govt funds
                                                                                                                                                                                                                                                                                         Grand total of major + non-major   Note 3 - Data must be Entered   Note 4 -- Entry A.1 from       Note 5: Conversion and annual accruals                 Note 6: Reclassifications, eliminations, and     Manually Posted          -- Computed --                                  --- Computed ---
    Accounts in tan have multiple                                                                                                                                                                                                                              statement -- computed funds -- computed                      below to the proper accounts             Worksheet A                      Entries from Worksheets B - J                consolidation entries - Worksheets K & L           Entries

    lines to which entries are posted.                                                          Major Governmental Funds                                                 Non-major Governmental Funds                                                                                              Total                       Capital Assets and             Reclassification of                                                                        Reclassifications and                   Other Misc Entries                                       Statement of                         Statement of
                                                                 General Fund                 Emergency Telephone   Parking & Recreation Major Fund #4        Grant Project   Cemetery CareOther Non-Major #3
                                                                                                                                                                                                      Other Non-Major #4    Other Non-Major #6 Other Non-Major #8
                                                                                                                                                                                                                 Other Non-Major #5    Other Non-Major #7  Subtotal Non-Major                Governmental Funds             Long-term Debt Accounts          Revenues by Function                        Conversion Entries                                  Eliminations                           As Needed            Working Column                     Activities                          Net Assets
                           Description                           Dr         Cr                  Dr          Cr         Dr         Cr       Dr    Cr           Dr        Cr      Dr       Cr     Dr   Cr     Dr  Cr     Dr  Cr     Dr  Cr     Dr  Cr Dr Cr      Dr       Cr                    Dr           Cr                   Dr            Cr               Dr            Cr             Ref          Dr        Ref                Cr        Ref        Dr         Ref      Cr                   Dr       Cr         Dr            Cr                 Dr            Cr                 Dr                  Cr
                                                                                                                                                                                                                                                                                                                                                                                            F.4               -                                                                                                             -                    -
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                                                                                                                                                      -                    -
  Transportation                                              392,840                                                                                                                                                                                                 -            -         392,840                 -                                                                      D.1         121,399       E.1               8,697   L.7              -       K.1-3             181                          514,239                8,878    520,016
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                      J.1          14,696       I.1                  41                             L.5              -                             14,696                   41
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                      F.3             -         J.1                 -     L.8              -        L.8              -                                -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4             -                                                                                                               -                    -
                                                                                                                                                                                                                                                                    -              -             -                   -                                                                                                                                                                                                      -                    -
  Economic and Physical Development                                 -                                                                                      115,000                                                                                              115,000            -         115,000                 -                                                                      D.1              -        E.1                  -    L.7              -       K.1-3              -                           115,000                  -      117,218
                                                                                                                                                                                                                                                                    -              -             -                   -                                                                      J.1            2,218      I.1                  -                                                                              2,218                  -
                                                                                                                                                                                                                                                                    -              -             -                   -                                                                      F.3              -        J.1                  -    L.8              -        L.8               -                               -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4              -                                                                                                              -                    -
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                                                                                                                                                      -                    -
  Environmental Protection                                    257,918                                                                                                                                                                                                 -            -         257,918                 -                                                                      D.1           58,937      E.1              40,200   L.7              -       K.1-3             241                          316,855               40,441    280,694
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                      J.1            4,280      I.1                 -                                                                               4,280                  -
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                      F.3              -        J.1                 -     L.8              -        L.8               -                               -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4              -                                                                                                              -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                      -                    -
  Human Services                                                                                                                                                                                                                                                      -            -              -                  -                                                                      D.1               -       E.1                  -    L.7              -       K.1-3              -                               -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      J.1               -       I.1                  -                                                                                -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      F.3               -       J.1                  -    L.8              -        L.8               -                               -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4               -                                                                                                             -                    -
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                                                                                                                                                      -                    -
  Cultural & Recreation                                         91,260                                                                                                                                                                                                -            -          91,260                 -                                                                      D.1           15,080      E.1              29,169   L.7              -       K.1-3             120                          106,340               29,289     79,430
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                      J.1            2,387      I.1                   8                                                                             2,387                    8
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                      F.3              -        J.1                 -     L.8              -        L.8               -                               -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4              -                                                                                                              -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                      -                    -
  Other program 1                                                                                                                                                                                                                                                     -            -              -                  -                                                                      D.1               -       E.1                  -    L.7              -       K.1-3              -                               -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      J.1               -       I.1                  -                                                                                -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      F.3               -       J.1                  -    L.8              -        L.8               -                               -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4               -                                                                                                             -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                      -                    -
  Other program 2                                                                                                                                                                                                                                                     -            -              -                  -                                                                      D.1               -       E.1                  -    L.7              -       K.1-3              -                               -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      J.1               -       I.1                  -                                                                                -                    -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      F.3               -       J.1                  -    L.8              -        L.8               -                               -                    -
                                                                                                                                                                                                                                                                                                                                                                                            F.4               -                                                                                                             -                    -
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                                                                                                                                                      -                    -
  Capital Outlay                                                                                                       590,000                                                                                                                                        -            -         590,000                 -                                                                                                E.1             590,000                                                                           590,000              590,000                        -
                                                                                                                                                                                                                                                                                                                                                                                                                      F.3                 -                                                                                 -                    -
                                                                                                                                                                                                                                                                      -            -             -                   -                                                                                                                                                                                                      -                    -
  Debt Service                                                                                                                                                                                                                                                        -            -             -                   -                                                                                                                                                                                                      -                    -
    Principal retirement                                        11,975                                                                                                                                                                                                -            -          11,975                 -                                                                                                G.1              11,975                                                                            11,975               11,975                        -
    Interest and fees                                            5,365                                                                                                                                                                                                -            -           5,365                 -                                                                      H.1               -       G.3                 -     K.1-3            -        L.7               -                             5,365                  -        6,143             -
                                                                                                                                                                                                                                                                                                                                                                                            G.3               778                                                                                                           778                  -
    Bond issuance costs                                                                                                                                                                                                                                               -            -              -                  -                                                                                                H.1                  -                                                                                -                    -                          -
    Advance refunding escrow                                                                                                                                                                                                                                          -            -              -                  -                                                                                                H.1                  -                                                                                -                    -                          -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                      -                    -
  Unallocated depreciation                                                                                                                                                                                                                                            -            -              -                  -                                                                      D.1               -                                                                                                             -                    -                          -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                      -                    -
Other financing sources (uses)                                                                                                                                                                                                                                        -            -             -                  -                                                                                                                                                                                                       -                    -
                                                                                                                                                                                                                                                                      -            -             -                  -                                                                                                                                                                                                       -                    -
    OFS - Transfers in                                                          10,813                                             208,400                                                                                                                            -            -             -              219,213                                                                                                F.2                 -    L.1        212,704       K.1-3            -                             212,704              219,213                   6,509
    OFU - Transfers out                                       305,800                              -                                                                                                                                                                  -            -         305,800                -                                                                       F.1             -                                   K.1-3          -          L.1         212,704                           305,800              212,704     93,096
    OFS - Capital leases (proceeds)                                             19,000                                                                                                                                                                                -            -             -               19,000                                                                     H.1          19,000                                                                                                          19,000               19,000                        -
    OFS - Installment purchase/COPS (proceeds)                                                                                     200,000                                                                                                                            -            -             -              200,000                                                                     H.1         200,000                                                                                                         200,000              200,000                        -
    OFS - Bonds issued (proceeds)                                                                                                                                                                                                                                     -            -             -                  -                                                                       H.1             -                                                                                                               -                    -                          -
    OFS - Premiums on debt issued                                                                                                                                                                                                                                     -            -             -                  -                                                                       H.1             -                                                                                                               -                    -                          -
    OFU - Discounts on debt issued                                                                                                                                                                                                                                    -            -             -                  -                                                                                                 H.1                  -                                                                                -                    -                          -
    OFU - Payments to escrow agent                                                                                                                                                                                                                                    -            -             -                  -                                                                                                 H.1                  -                                                                                -                    -                          -
    OFS - Sale of capital assets                                                5,000                                                                                                                                                                                 -            -             -                5,000                                                                     F.1           5,000                                                                                                           5,000                5,000                        -
    OFS - Insurance recovery                                                  325,000                                                                                                                                                                                                            -              325,000                                                                     F.4         325,000                                                                                                         325,000              325,000                        -
                                                                                                                                                                                                                                                                      -            -             -                  -                                                                                                                                                                                                       -                    -                          -
    Change in reserve for prepaid expenses                                                                                                                                                                                                                            -            -             -                  -                                                                       I.1               -                                                                                                             -                    -                          -
    Change in reserve for inventories                                                82                                                                                                                                                                               -            -             -                   82                                                                     I.1                82                                                                                                            82                   82                        -
                                                                                                                                                                                                                                                                      -            -             -                  -                                                                                                                                                                                                       -                    -                          -
Special and extraordinary items                                                                                                                                                                                                                                       -            -              -                  -                                                                                                                                                                                                       -                   -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                                                                                                                                                       -                   -
    Special item - expenditure                                                                                                                                                                                                                                        -            -              -                  -                                                                      J.1               -        J.1                 -    L.10             -                                                           -                   -                          -
    Extraordinary item - expenditure                                                                                                                                                                                                                                  -            -              -                  -                                                                      J.1               -        J.1                 -                                                                                 -                   -                          -
                                                                                                                                                                                                                                                                      -            -              -                  -                                                                      F.4               -                                                                                                              -                   -
    Special item - revenue                                                                                                                                                                                                                                          -            -              -                  -                                                  -                -    F.1               -        F.1                 -                                                                                 -                 -                            -
                                                                                                                                                                                                                                                                    -            -              -                  -                                                                                                   F.2                 -                                                                                 -                 -
    Extraordinary item - revenue                                                                                                                                                                                                                                    -            -              -                  -                                                  -                -                               F.4                 -                                                                                 -                 -                            -
                                                                                                                                                                                                                                                                    -            -              -                  -                                                                                                                                                                                                         -                 -
        Proof Total - (debits and credits should balance)   2,765,630       2,765,630          807,453      807,453    613,400     613,400    -      -     120,000      120,000       25,056   25,056   -   -   -   -   -   -   -     -      -     -            145,056      145,056      4,331,539          4,331,539        7,223,640        7,223,640     1,311,749         1,311,749              2,215,659                  2,215,659              4,800,485                  4,800,485          -        -      19,883,072        19,883,072     2,636,513   3,000,372          25,995,194        25,995,194
                                                                                                                                                                                                                                                                                 -                                 -
Change in Net Assets                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    363,859             -
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       3,000,372   3,000,372
                                                                                                                                                                                                                                                                                   -                                 -
                                                                                                                                                                                                                                                                                   -                                 -
                                                                                                                                                                                                                                                                                   -                                 -                                                                                                                                                                                                                                                                                             -




Notes:
 Pre-closing trial balance entered at the function level for each governmental fund (for the fund balance number - use ending fund balance from prior year).
 Preliminary judgment made on which funds are major and which are non-major before conversion worksheet is done. Reconfirm if any adjusting entries for modified accrual are made.
 Capital Assets & Long-term Debt accounts are those previously carried in the General Fixed Asset Account Group (GFAAG) and the General Long Term Debt Account Group (GLTDAG) plus the respective accumulated depreciation and the category of infrastructure (according to the phased implementation rules of GASB 34).
 The amounts recorded are the ending balances from the prior year (this year's beginning balances) plus any reductions resulting from changes in capitalization threshold. Current year activity will be recorded in a later step.
 Revenues are reclassified from the summary levels in the fund statements to the classification required for the Statement of Activities in Worksheet A. A separate worksheet on the website is available to assist with this classification process.
 Please note that the numbers in this column will not be included in the reconciliation from modified to full accrual.
  Conversion entries to convert from modified accrual to full accrual are generated from the worksheets B through J.
  Reclassification, elimination and consolidation entries are in worksheets K and L including the required Internal Service Fund entries in worksheet K.1, K.2, and K.3.




                       f4efb566-3051-445a-9d85-3ac660dacd41.xls
                                                                                                                                                                             Entry A


                                                                 Revenue Reclassification by Function
                    Program revenues must be reclassified for presentation on the Statement of Activities to report revenues by function (program). Ad valorem
                    taxes and other revenues that will be classified as general revenue will not be affected in this entry. These program revenues will be categorized
                    into charges for services, operating grants and contributions, and capital grants and contributions. In order for grants or contributions to be
                    classified as capital in nature, the unit must own the asset. Grants that can be considered either operating or capital are classified as operating
                    grants at the recipient's discretion.
                    1.   See Memo # 964 for the proper classification of revenue sources to operating, capital or charges for service.
                    2.   Examine the trial balance and summary reports of revenues by function and by source code to determine which revenue items need to be
                         reclassified. If units do not have a chart of accounts that breaks out revenues by functional source codes, a manual classification of
                         revenues must be prepared. A worksheet to assist you is available at this website.
                    3.   Complete section A below indicating the amount of revenue in all governmental funds which should be noted as program specific on the
                         Statement of Activities. Note that items that are classified as special or extraordinary at the fund level typically will be classified as such
                         when viewed at the government-wide level although there could be rare occurrences when special and/or extraordinary items at the fund
                         level will not be treated as such on the government-wide statements.
                    4.   Complete section B of the worksheet indicating the functional and categorical reclassifications of the amounts in Section A., then the entry
                         required for the Conversion worksheet will be created in Section C. Any items that qualify for the definitions of special items or
                         extraordinary items should be reported separately in order to be properly reported on the Statement of Activities. See definitions in the
                         comment fields - place cursor over the field with a red triangle in the corner.
                    5.   The journal entry will reverse the original entry in the trial balance and credit an entry by function and revenue category. It is posted only to
                         the conversion worksheet not to the general ledger or accounting system.
                    6.   As previously stated, revenues that result in the ownership of a capital asset are classified as capital. If no capital asset results, the
                         revenue should be classified as operating.


                    From the financial records, determine the amount in the following categories that must be reclassified to functional revenues,
                    special or extraordinary items. Also, include any items that were special or extraordinary items at the fund level that will be general
              A.    revenues in the government-wide statements.

                         Modified Accrual Revenue Class                     Amount
                         Other taxes and licenses                                 -
                         Unrestricted intergovernmental                           -
                         Restricted intergovernmental                       1,266,334
                         Permits and Fees                                      13,160
                         Sales and services                                    26,843
                         Investment Earnings                                    5,412
                         Miscellaneous                                            -
                         Other revenue 1                                          -
                         Other revenue 2                                          -
                         Special item - fund statements                           -
                         Extraordinary item - fund statements                     -

                              Total revenue to be reclassified           $ 1,311,749


                    From the financial records, indicate the appropriate program classification to which the revenue should be reclassified.
              B.    The total of Section B must agree to the total of Section A above.

                                                                            Amount
                         General government
                            Charges for services
                            Operating grants and contributions
                            Capital grants and contributions
                         Public safety
                             Charges for services                              13,160
                             Operating grants and contributions               815,877
                             Capital grants and contributions                     -
                         Transportation
                             Charges for services                                 -
                             Operating grants and contributions               132,457
                             Capital grants and contributions                     -
                         Economic and Physical Development
                             Charges for services                                 -
                             Operating grants and contributions                88,402
                             Capital grants and contributions                  26,598
                         Environmental Protection
                             Charges for services
                             Operating grants and contributions                  3,000
                             Capital grants and contributions
                         Human Services
                            Charges for services
                            Operating grants and contributions
                            Capital grants and contributions




4/12/2011 - City model                                                                                                                                                            7
                                                                                                                                                                               Entry A


                                                                 Revenue Reclassification by Function
                         Cultural and recreation
                              Charges for services                              26,843
                              Operating grants and contributions                   412
                              Capital grants and contributions                 205,000
                         Other program 1
                             Charges for services
                             Operating grants and contributions
                             Capital grants and contributions
                         Other program 2
                             Charges for services
                             Operating grants and contributions
                             Capital grants and contributions
                         Special items - government-wide
                         Extraordinary items - government-wide


                             Total program revenues                       $ 1,311,749




              C.    Journal entry for conversion worksheet to reclassify revenue to functional categories: [Entry A.1]

                                                                                                                        Debit                 Credit
                    Other taxes and licenses                                                                                   -
                    Unrestricted intergovernmental                                                                             -
                    Restricted intergovernmental                                                                         1,266,334
                    Permits and Fees                                                                                        13,160
                    Sales & Services                                                                                        26,843
                    Investment earnings*                                                                                     5,412
                    Miscellaneous                                                                                              -
                    Other revenue 1                                                                                            -
                    Other revenue 2                                                                                            -
                    Special item                                                                                               -
                    Extraordinary item                                                                                         -
                        General government - Charges for services                                                                                     -
                        General government - Operating grants and contributions                                                                       -
                        General government - Capital grants and contributions                                                                         -
                        Public safety - Charges for services                                                                                       13,160
                        Public safety - Operating grants and contributions                                                                        815,877
                        Public safety - Capital grants and contributions                                                                              -
                        Transportation - Charges for services                                                                                         -
                        Transportation - Operating grants and contributions                                                                       132,457
                        Transportation - Capital grants and contributions                                                                             -
                        Economic and physical development - Charges for services                                                                      -
                        Economic and physical development - Operating grants and contributions                                                     88,402
                        Economic and physical development - Capital grants and contributions                                                       26,598
                        Environmental protection - Charges for services                                                                               -
                        Environmental protection - Operating grants and contributions                                                               3,000
                        Environmental protection - Capital grants and contributions                                                                   -
                        Human services - Charges for services                                                                                         -
                        Human services - Operating grants and contributions                                                                           -
                        Human services - Capital grants and contributions                                                                             -
                        Cultural and recreation - Charges for services                                                                             26,843
                        Cultural and recreation - Operating grants and contributions                                                                  412
                        Cultural and recreation - Capital grants and contributions                                                                205,000
                        Other program 1 - Charges for services                                                                                        -
                        Other program 1 - Operating grants and contributions                                                                          -
                        Other program 1 - Capital grants and contributions                                                                            -
                        Other program 2 - Charges for services                                                                                        -
                        Other program 2 - Operating grants and contributions                                                                          -
                        Other program 2 - Capital grants and contributions                                                                            -
                        Special item (revenue)                                                                                                        -
                        Extraordinary item (revenue)                                                                                                  -

                                                                                                                         1,311,749              1,311,749



                         * Interest is typically a general revenue but if earned on investments legally restricted for a specific program it will follow the initial revenue
                         source as in this capital grant.

                         Note that any revenue items or other financing sources qualifying as "special" or "extraordinary" as defined by GASB 34 will have to
                         be presented as such in the General Revenue section of the Statement of Activities.




4/12/2011 - City model                                                                                                                                                              8
                                                                                                                                                  Entry B



                          Adjust Property Tax Revenue From Modified Accrual to Full Accrual

      Revenues must be adjusted to the full accrual basis of accounting on the Statement of Activities. Under modified accrual, taxes must be both
      measurable and available (for full accrual they are measurable and earned.) This means that some revenue received in the current year may
      have actually been earned in the prior year and some revenue deferred for the current year due to unavailability may actually be earned for full
      accrual. Taxes collected in advance of the period the taxes are intended to finance will be "unearned revenue" under both full and modified
      accrual. Estimates for uncollectibles is the same for both methods, if material.

      See Memos # 949 and #964 for discussion of the proper recognition of revenue under modified accrual and full accrual for GASB 33 and 34.
      1.   Determine beginning of year balances for deferred revenue and accrued interest receivable of ad valorem taxes. Enter those amounts in
           section A below.
      2.   Determine end of year balances for deferred revenue and accrued interest receivable on ad valorem taxes. Enter those amounts in section
           B below.
      3.   The following entries will be done in two stages. The first journal entry will reverse the beginning of year entry and restate fund balance.
           The second entry will reverse the ending balance and recognize revenue on the full accrual basis. It is posted only to the conversion
           worksheet, not to the general ledger or accounting system. Unearned revenue for prepaid taxes at year end will not be adjusted.
      4.   Under the full accrual basis of accounting, accrued interest on uncollected taxes should be recognized as revenue after adjusting for
           uncollectible amounts. It may be necessary to estimate the amount of that receivable. Penalties that are known at year-end should already
           be recorded in taxes receivable. Penalties related to discoveries should be recorded when the discovery occurs.

      What was the amount in deferred tax receipts at the beginning of the year? - (Exclude prepaid taxes.)
A.    What was the amount of accrued interest receivable on tax receipts at the beginning of the year?

      Both amounts should be net of estimated uncollectible amounts.
                                                                    Amount
      Ad Valorem taxes:
          Deferred revenue (ad valorem tax) - "beginning of year" $   59,603              Does not include penalties (accounted for in Agency Fund).
           Accrued interest rec. on ad valorem - "beginning of year"          11,844

                                                                        $     71,447




      What was amount in deferred tax receipts at the end of the year? - (Exclude prepaid taxes.)
B.    What was the amount of accrued interest receivable on tax receipts at the end of the year?

      Both amounts should be net of estimated uncollectible amounts.
                                                                            Amount
      Ad Valorem taxes:
          Deferred revenue (ad valorem tax) - "end of year"             $     57,180      Does not include penalties (accounted for in Agency Fund).
           Accrued interest rec. on ad valorem - "end of year"                12,949

                                                                        $     70,129




C.    Final Entry for Conversion Worksheet [Entry B.1 and B.2]


                                                                                                Debit                Credit
B.1   Taxes - ad valorem*                                                                           59,603
      Accrued interest receivable on taxes                                                          11,844
          Fund Balance - beginning                                                                                       71,447
B.2   Deferred Revenues*                                                                            57,180
      Accrued interest receivable on taxes                                                           1,105                  -
          Taxes - Ad valorem*                                                                          -                 58,285

                                                                                                   129,732              129,732

      *    Includes penalties




4/12/2011 - City model                                                                                                                                    9
                                                                                                                                                                            Entry C


                                               Adjust Other Revenues From Modified Accrual to Full Accrual

                  In addition to ad valorem taxes, other revenues must be adjusted to reflect the full accrual basis of accounting on the Statement of Activities. The
                  availability criteria is not considered for revenue recognition under full accrual accounting. This means that some deferred revenue at year end under
                  modified accrual will be recognized as revenue under full accrual on the Statement of Activities. Also, revenues recorded under modified accrual in
                  the current year which were deferred from the prior year were already recognized as revenue under full accrual in the prior year. Receipts that have
                  not been earned at year end will not be recognized as revenue under the full accrual basis of accounting.
                  It is presumed that deferred revenues not recorded on the fund's modified accrual statements because of materiality, will not be material on the
                  government-wide statements. A work section, presented in this spreadsheet following the final entry, shows the individual entries for each section in
                  Worksheet C. It is not included in the normal print range. If you wish to print the work section, you will need to adjust the print range.

                  See Memos # 949 and # 964 for a discussion of the proper recognition of revenue under modified accrual and full accrual for GASB 33 and 34.
                  1.     Determine ending balance from prior fiscal year (or beginning of year balances) in deferred revenue for each revenue source below. Enter the
                         amount in question 1 of each section below.
                  2.     Determine end of current year balances for deferred revenue for all revenue sources listed below. Enter those amounts for question 2 in each
                         section below.
                  3.     Determine the function / program to which the revenue applies for those revenues which are program specific. Note that special assessments in
                         section F. and G. have additional questions regarding new levies for the current year and current year collections.
                  4.     The conversion journal entry in section J. will reverse the beginning and ending of year deferral in the trial balance. It is posted only to the
                         conversion worksheet, not to the general ledger or accounting system.


           A.     Beer and Wine Excise Tax (Unrestricted intergovernmental for Modified Accrual -- Unrestricted - General for Full Accrual)

                                                                                                                                      Amount

                  1.     Indicate the amount of beer and wine excise tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.
                  2.     Indicate the amount of beer and wine excise tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.



           B.     Piped Natural Gas Tax (Unrestricted intergovernmental for Modified Accrual -- Unrestricted - General for Full Accrual)

                                                                                                                                      Amount

                  1.     Indicate the amount of piped natural gas tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.
                  2.     Indicate the amount of piped natural gas tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.



           C.     Controlled Substance Abuse Tax (Restricted governmental for Modified Accrual -- Public Safety - operating for Full Accrual)

                                                                                                                                      Amount

                  1.     Indicate the amount of controlled substance tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.
                  2.     Indicate the amount of controlled substance tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.



           D.     Utility Franchise Tax (Unrestricted governmental for Modified Accrual -- Unrestricted - General for Full Accrual)

                                                                                                                                      Amount

                  1.     Indicate the amount of utility franchise tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.
                  2.     Indicate the amount of utility franchise tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.



           E.     Telecommunications Tax (Unrestricted governmental for Modified Accrual -- Unrestricted - General for Full Accrual)

                                                                                                                                      Amount

                  1.     Indicate the amount of Telecommunications tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.

                  2.     Indicate the amount of Telecommunications tax included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.




4/12/2011 - City model                                                                                                                                                           10
                                                                                                                                                            Entry C


                                               Adjust Other Revenues From Modified Accrual to Full Accrual


                  Special Assessments - Assessment results in ownership of an asset - (Miscellaneous Revenue for Modified Accrual)
           F.                                                                         (Program Revenue - Capital grants & contributions for Full Accrual)

                                                                                                                                          Amount
                  1.     Indicate the amount of special assessments included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.
                  2.     Add any additional assessments made in the current year in the cell to the right.                                         -   j
                  3.     Enter the amount of the new levy in the function below where the proceeds will be/have been
                         expended. The sum below must equal the amount in step 2.
                                                                                                              Amount
                                                General government
                                                Transportation
                                                Economic & physical development
                                                Environmental protection
                                                Other program 1
                                                Other program 2

                                                                                                         j                 -

                  4.     Indicate the amount of special assessments included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.
                                                                                        Current year collections                                   -   k

                  5.     Enter the amount of the current year collections in the function where the proceeds will be/have
                         been expended. The sum of the amounts entered must equal the calculated amount for current
                         collections.
                                                                                                                Amount
                                                General government
                                                Transportation
                                                Economic & physical development
                                                Environmental protection
                                                Other program 1
                                                Other program 2
                                                                                                       k                 -

                         Entry prepared assuming that Special Assessments were charged appropriately to program revenue in worksheet A.


                  Special Assessments - No new asset on unit's books - (Miscellaneous revenue for Modified Accrual)
           G.                                                                   (Program revenue - charge for service for Full Accrual)
                                                                                                                                          Amount
                  1.     Indicate the amount of special assessments included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the prior year.

                  2.     Add any additional assessments made in the current year in the cell to the right.

                  3.     Enter the amount of the new levy in the function below where the proceeds will be/have been
                         expended. The sum below, must equal the amount listed in step 2 above.
                                                                                                              Amount
                                                General government
                                                Transportation
                                                Economic & physical development
                                                Environmental protection
                                                Other program 1
                                                Other program 2
                                                                                                         l                 -

                  4.     Indicate the amount of special assessments included in deferred revenue utilizing the modified
                         accrual basis of accounting at the end of the current year.
                                                                                        Current year collections                                   -   m

                  5.     Enter the amount of current year collections in the function where the proceeds will be/have been
                         expended. The sum of the amounts entered must equal the calculated amount for current
                         collections.
                                                                                                                Amount
                                               General government
                                               Transportation
                                               Economic & physical development
                                               Environmental protection
                                               Other program 1
                                               Other program 2

                                                                                                         m                 -
                         Entry prepared assuming that Special Assessments were charged appropriately to program revenue in worksheet A.




4/12/2011 - City model                                                                                                                                           11
                                                                                                                                                                        Entry C


                                                 Adjust Other Revenues From Modified Accrual to Full Accrual


           H.     Other revenues not previously covered that require adjustment from modified to full accrual - including misc. charges, services & fees

                  Review the different revenue accounts - any amounts earned but not available under modified accrual should be adjusted if not previously covered in
                  this worksheet or in the Property Taxes Revenue worksheet ( Worksheet B.) Any amount not earned at year end would not be adjusted.
                                                                                                                              Amount

                  1.     Indicate the amount of other revenues included in deferred revenue utilizing the modified accrual                       n
                         basis of accounting at the end of the prior year that were not recognized as revenue because they
                         were not considered available. Also, indicate by amount the appropriate full accrual revenue
                         classification.
                                                                            Misc. Rev.
                                                                            not program   Charges for     Operating Grants    Capital grants &
                                                                              specific     Services *     & Contributions      contributions
                                                                                            Amount            Amount              Amount
                         General government
                         Public Safety
                         Transportation
                         Economic & physical development
                         Environmental protection
                         Human services
                         Cultural and recreation
                         Other program 1
                         Other program 2
                         Miscellaneous revenue - not program specific                         N/A                N/A                N/A
                                                                                  -                 -                  -                   -     n                -

                  * would include sales and services and permits and fees


                  2.     Indicate the amount of other revenues included in deferred revenue utilizing the modified accrual
                         basis of accounting at the end of the current year that were not recognized as revenue because
                         they were not considered available. Be careful not to duplicate deferred revenues that have been
                         handled in previous entries.                                                                                            o

                  3.     Indicate by amount the appropriate full accrual revenue classification. The sum of amounts in step
                         3 must equal the amount in step 2.
                                                                            Misc. Rev.
                                                                            not program   Charges for     Operating Grants    Capital grants &
                                                                              specific     Services *     & Contributions      contributions
                                                                                            Amount            Amount              Amount
                         General government
                         Public Safety
                         Transportation
                         Economic & physical development
                         Environmental protection
                         Human services
                         Cultural and recreation
                         Other program 1
                         Other program 2
                         Miscellaneous revenue - not program specific                         N/A                N/A                N/A
                                                                                  -                 -                  -                   -     o                -


                  * would include sales and services and permits and fees



           I.     Investment Earnings


                  1.     What was the accrued investment earnings at the end of the prior year?

                  2.     What are the accrued investment earnings at the end of the current year?
                         Any investment earnings that should be reclassified as program revenue will be adjusted in worksheet L.




4/12/2011 - City model                                                                                                                                                       12
                                                                                                                                                Entry C


                                              Adjust Other Revenues From Modified Accrual to Full Accrual


           J.     Final Entry for Conversion Worksheet [Entry C.1]
                                                                                                                 Debit             Credit
           C.1 Accrued interest receivable                                                                               -
               Deferred revenue                                                                                          -                  -
                  Other taxes and licenses                                                                               -                  -
                  Intergovernmental - unrestricted                                                                       -                  -
                  Intergovernmental - restricted                                                                         -                  -
                  Permits and fess                                                                                       -                  -
                  Sales and services                                                                                     -                  -
                  Miscellaneous                                                                                          -                  -
                  Investment earnings                                                                                    -                  -
                  General government - charge for service                                                                -                  -
                  Public Safety - charge for service                                                                     -                  -
                  Transportation - charge for service                                                                    -                  -
                  Economic & physical development - charge for service                                                   -                  -
                  Environmental protection - charge for service                                                          -                  -
                  Human services - charge for service                                                                    -                  -
                  Cultural and recreation - charge for service                                                           -                  -
                  Other program 1 - charge for service                                                                   -                  -
                  Other program 2 - charge for service                                                                   -                  -
                  General government - operating grants & contributions                                                  -                  -
                  Public Safety - operating grants & contributions                                                       -                  -
                  Transportation - operating grants & contributions                                                      -                  -
                  Economic & physical development - operating grants & contributions                                     -                  -
                  Environmental protection - operating grants & contributions                                            -                  -
                  Human services - operating grants & contributions                                                      -                  -
                  Cultural and recreation - operating grants & contributions                                             -                  -
                  Other program 1 - operating grants & contributions                                                     -                  -
                  Other program 2 - operating grants & contributions                                                     -                  -
                  General government - capital grants & contributions                                                    -                  -
                  Public Safety - capital grants & contributions                                                         -                  -
                  Transportation - capital grants and contributions                                                      -                  -
                  Economic & physical development - capital grants & contributions                                       -                  -
                  Environmental protection - capital grants & contributions                                              -                  -
                  Human services - capital grants & contributions                                                        -                  -
                  Cultural and recreation - capital grants & contributions                                               -                  -
                  Other program 1 - capital grants & contributions                                                       -                  -
                  Other program 2 - capital grants & contributions                                                       -                  -
                         Fund balance - beginning                                                                        -                  -
                                                                                                                         -                  -

                  Entry prepared assuming that Special Assessments were charged appropriately to program revenue in worksheet A.




4/12/2011 - City model                                                                                                                               13
                                                                                                                                                                          Entry D



                                                           Recording Depreciation Expense
    Depreciation expense must be calculated and reported in relation to all of the unit's depreciable capital assets. Some units may have a capital asset software
    system that can easily calculate annual depreciation expense. Others may need to calculate the expense manually. This function has previously been done
    for all the proprietary or business-type activities funds. It will now be expanded to general capital assets. The challenge may be the requirement to record the
    expense by function, e.g. the depreciation for police cars must be charged to public safety. If function or department codes are not currently in the capital
    asset system, perhaps location can identify the function. Capital assets that can be specifically identified with a function or program will have their
    depreciation charged respectively. For those units that prepare CAFRs the capital asset schedules required for that publication should give you helpful
    information about classifying your capital assets by function.
    Depreciation for shared capital assets should be allocated over the functions/programs based on usage, square footage, etc. Depreciation for capital assets
    that essentially serve all functions can be reported as a separate line entitled "unallocated depreciation" or charged to General Government. Unallocated
    depreciation should be a rare exception. The depreciation on infrastructure must follow the same principles and be charged to the function where repairs and
    maintenance are charged, e.g., the depreciation on streets would be charged to Transportation. Please remember that depreciation must be posted to the
    unit's permanent accounts in order to correctly reflect next year's beginning balances, but will not be shown in the fund statements.
    See Memo #934 for further discussion of depreciation particularly as related to long lived assets like infrastructure. Note that infrastructure previously held
    does not have to be recorded in year 1 of implementation, for governments implementing in 2002 (phase 1) or 2003 (phase II). These phase I and II
    governments have 4 years to get all their existing infrastructure properly recorded. Governments implementing in 2004 (phase III) are not required to record
    their old infrastructure. All governments must begin to record new additions to infrastructure in year 1 of implementation.
    1. Identify assets by function and calculate the annual depreciation in section A below. For those items that are shared and no clear allocation method is
       available, place those figures into General Government or the unallocated depreciation line (use of "unallocated depreciation" will typically be the exception).

    2. Identify the proper asset class to which the depreciation should be recorded in section B. below.
    3. The data provided in sections A. and B. will provide the information to create the proper entry for the conversion worksheet.


A. Indicate the annual depreciation expense by function:
                                                                       Annual
                                                                     Depreciation
                                                                      Expense
         General Government                                                28,779
         Public Safety                                                     17,115
         Transportation                                                   121,399
         Economic & physical development                                      -
         Human Services                                                       -
         Environmental protection                                          58,937
         Cultural & recreation                                             15,080
         Other program 1                                                      -
         Other program 2                                                      -
         Unallocated depreciation                                             -

                                                                          241,310


B. Indicate the appropriate asset class for the depreciation amount computed in section A above.

                                                                       Annual
                                                                     Depreciation
         Buildings                                                         22,148
         Improvements                                                      22,403
         Equipment                                                         65,785
         Vehicles + Mot. Equip                                             76,122
         Infrastructure                                                    54,852
         Other asset class 1                                                  -
         Other asset class 2                                                  -
                                                                          241,310


C. Entry for Conversion worksheet to record depreciation expense.                 [Entry D.1]

                                                                                                            Debit               Credit
D.1 General Government                                                                                         28,779
    Public Safety                                                                                              17,115
    Transportation                                                                                            121,399
    Economic & physical development                                                                               -
    Human Services                                                                                                -
    Environmental protection                                                                                   58,937
    Cultural & recreation                                                                                      15,080
    Other program 1                                                                                               -
    Other program 2                                                                                               -
    Unallocated depreciation                                                                                      -
        Accum. Depreciation - Buildings                                                                                            22,148
        Accum. Depreciation - Improvements                                                                                         22,403
        Accum. Depreciation - Equipment                                                                                            65,785
        Accum. Depreciation - Vehicles + Mot. Equip                                                                                76,122
        Accum. Depreciation - Infrastructure                                                                                       54,852
        Accum. Depreciation - other asset class 1                                                                                     -
        Accum. Depreciation - other asset class 2                                                                                     -
                                                                                                              241,310             241,310

4/12/2011 - City model                                                                                                                                                         14
                                                                                                                                                                         Entry E


                                  Adjust Capital Outlay Expenditures Under Modified Accrual to Full Accrual
                Expenditures recorded under the modified accrual basis of accounting for the purchase or construction of capital assets must be reported as
                additions to capital assets under the full accrual basis of accounting on the government-wide statements. The capital assets acquired in
                these transactions will be added to the amounts previously recorded when the Capital Assets were entered on the conversion worksheet.
                Note that all expenditures for capital assets may not have been coded as capital outlay so a careful review of expenditures is needed to find
                all transactions related to capital assets such as expenditures for land or infrastructure coded as street improvements.
                Also be aware that some expenditures may fall below the capitalization threshold that the Governing Board has set for your unit. If certain
                purchases fall below the capitalization threshold, a legitimate balance may remain in Capital Outlay after this adjustment. For example, if the
                unit has chosen $1,000 as the minimum for capitalization, then any items purchased costing less than that amount would remain as an
                expenditure with no addition made to the various capital asset accounts. Only those items above the unit's capitalization threshold would be
                adjusted and reported as capital assets in the government-wide statement of net assets.
                Please be aware that in addition to posting to the conversion worksheets, capital assets and depreciation must be added to the unit's
                permanent accounts for recording capital assets in order to have proper beginning balances for next year's statements.

                1.       Review the governmental funds, including capital projects, and identify capital outlay expenditures that should be capitalized and
                         recorded as capital assets in the city's permanent records . Accumulate by function for entry to Section A below. The amount for
                         capital outlay for property where title is not held by the city will be excluded from this entry and reclassified as a functional expenditure
                         in worksheet F. This entry will include any capital outlay for the restoration of assets subject to impairment loss. The associated
                         impariment entries are handled in Worksheet F.
                2.       Determine the asset categories for which the expenditures noted in Section A were made and enter amounts by asset class. The total
                         amount for section A and B should be equal.
                3.       The journal entry for the conversion worksheet, to reclassify these expenditures as capital assets, will be automatically created.
                What was the amount of capital outlay to be capitalized by function in all governmental funds? This includes expenditures related
          A.    to impairment losses.
                                                                       Amount
                         General Government                             420,884
                         Public Safety                                   25,989
                         Transportation                                   8,697
                         Economic & physical development                    -
                         Environmental protection                        40,200                  It is assumed that the balance at the beginning of the year for
                         Human Services                                     -                    construction in progress for projects that were completed during
                         Culture and Recreation                          29,169                  the year has been reclassified to the appropriate category.
                         Capital Outlay (capital projects)              590,000
                         Other program 1                                    -                    `
                         Other program 2                                    -
                                                                      1,114,939



          B.    What was the amount to be capitalized by asset class?
                                                            Amount
                         Land                                               -
                         Construction in progress                       590,000
                         Buildings                                      395,240                  Any expenditures during the year on completed projects at year
                         Other Improvement                                  -                    end should be recorded in the appropriate category rather than in
                         Equipment                                       89,499                  construction in progress.
                         Vehicles and motorized equipment                40,200
                         Infrastructure (e.g. street improvements)          -
                         Other asset class 1                                -
                         Other asset class 2                                -
                                                                      1,114,939



          C.    Journal entry for conversion worksheet to capitalize capital outlay expenditures. [Entry E.1]
                                                                                                                              Debit            Credit
                                      E.1          Land                                                                            -
                                                   Construction in Progress                                                    590,000
                                                   Buildings                                                                   395,240
                                                   Other Improvement                                                               -
                                                   Equipment                                                                    89,499
                                                   Vehicles and motorized equipment                                             40,200
                                                   Infrastructure                                                                  -
                                                   Other asset class 1                                                             -
                                                   Other asset class 2                                                             -
                                                         General Government                                                                     420,884
                                                         Public Safety                                                                           25,989
                                                         Transportation                                                                           8,697
                                                         Economic and Physical Development                                                          -
                                                         Environmental Protection                                                                40,200
                                                         Human Resources                                                                            -
                                                         Cultural & Recreation                                                                   29,169
                                                         Capital Outlay                                                                         590,000
                                                         Other program 1                                                                            -
                                                         Other program 2                                                                            -
                                                                                                                             1,114,939        1,114,939



4/12/2011 - City model                                                                                                                                                        15
                                                                                                                                                                                                                                                Entry F


                                                                                        Adjust Other Capital Asset Entries to Full Accrual
           Other transactions affecting capital assets must also be adjusted from their treatment under modified accrual to full accrual for the government-wide financial statements. This covers the disposal of assets such as the sales,
           trade-ins or the scrapping of fully depreciated assets, and the donations of capital assets. Please be aware that in addition to posting to the conversion worksheets, capital assets eventually must be added to the unit's
           permanent accounts for recording capital assets in order to have proper beginning balances for next year's statements. (Capital assets acquired through leases should have been recorded in the capital outlay worksheet; the
           debt side of the entry will be made later. Depreciation expense was calculated in a previous worksheet.)
           1. Review all governmental funds for sales of assets. For those items that meet the definition of a special item* enter the amounts by asset class for each question in section A.1. Typically there would not be more than one
              sale that qualified under the definition of special item. Enter the amounts under the proper asset class.
           2. For those items sold that qualify as a regular sale of assets, enter the amounts by asset class for each question in section A.2
           3. Trade-in's of equipment or vehicles should also be recorded and they are treated similarly to sales of assets. Any expenditure made as part of the trade-in transaction was recorded with the capital outlay entry. Now we
              must remove the old asset from the capital asset accounts and adjust the true cost of the newly acquired asset. Enter the amounts by asset class in section B of the worksheet below. For question d, please enter the net
              book value of the old asset in the cell for the asset class of the new asset, e.g., if a vehicle is traded for another vehicle then the number would be placed in the field for the same asset class "vehicles", however if a vehicle
              is traded for equipment place the number in the asset class of the new asset "equipment". Trading across asset classes will be rare but the worksheet should accommodate the entry.
           4. Retiring/scrapping or donating assets is a matter of removing those amounts from the capital asset accounts including removing the related accumulated depreciation. Enter amounts by asset class in section C.
           5. Donations of assets and transfers in from an enterprise or internal service fund reported as business-type activity, are not recorded in the fund statements; however, this data would have been picked up previously in the
              capital asset note under additions. For reporting on the government-wide statements, the donations must be reflected as revenue and as an increase to the specific asset account. The revenue amount will be reflected in
              "miscellaneous general revenues" or as a special item if appropriate. The transfers in of capital assets from business type activities must be reported as transfers. Enter amounts in section D.
           6. Expenditures for capital outlay where title is held by other parties must be reclassified as a functional expenditure. A prime example of this situation is the county expenditure for school construction where the Board of
              Education holds title to the property but municipalities could have a similar situation perhaps in an Economic Development project. In Section E, indicate the amount of capital outlay that must be reclassified and indicate
              the function to which it should be charged. Section F addresses asset impairment losses. See Section F below for further discussion.
           7. The work section of this worksheet following section G compiles the data for the final entries in section G. Entry F.1 is for disposals; entry F.2 is to record the revenue when assets are donated to the unit; entry F.3 is to
              reclassify capital outlay expenditures to the proper function when title to the asset is not held by the unit; F.4 is for asset impairment loss due to physical damage. The work section is not defined in the initial print range but
              provides the components of the final entry. Print ranges can be modified if needed. Please note that reductions due from changes in capitalization thresholds should be handled with the beginning balances loaded in the
              conversion worksheet.

      A. Sale of assets:
                                                                                                                                                  Other                                         Other asset        Other asset
                                                                                                             Land          Building            Improvement                                       Class #1           Class #2
           1. Sales that qualify as a "special item" for statement presentation:*
               a. What is the original cost at the beginning of the year for an asset
                  sold during current year?
               b. What is the accumulated depreciation at the beginning of the year                           N/A
                  for the asset sold in a. above?
               c. What is the depreciation expense for the current year up to the                             N/A                          0
                  date of sale for the asset above?
                              Net book value of capital assets sold                                                 -                  0                   0
               d. Indicate amount of revenue recorded for sale.
                              Gain / loss qualifying as special item                                                -                  0                   0

              * Special item - Subject to management control and unusual in nature (possessing a high degree of abnormality and clearly unrelated to ordinary or typical activity) or infrequent in occurrence; should be a material amount
              to justify such treatment.
                                                                                                                                         Other                         Vehicles +          Other asset      Other asset
           2. Other sales of assets that do not qualify as special items:                              Land         Building         Improvement Equipment             Mot. Equip           Class #1          Class #2
              a. What is the original cost at the beginning of the year for assets
                  sold during current year?                                                                                                               10,000
               b. What is the accumulated depreciation at the beginning of the year                           N/A
                  for the assets sold in a. above?                                                                                                                10,000
               c. What is the depreciation expense for the current year up to the                             N/A
                  date of sale for the assets above?                                                                                                                 -
                              Net book value of capital assets sold                                                 -              -                   -             -                  -
               d. Indicate revenue account to which items were recorded?
                              Miscellaneous Revenue
                              Other financing source - sale of capital assets                                                                                      5,000
                              Gain / loss on sale of assets                                                         -              -                   -           5,000                -
                   Note: If the composite method is used for computing depreciation and useful life, no gain or loss should be recognized. The proceeds received upon the asset's removal reduces the amount that would have been
                   charged to accumulated depreciation. For the case where the composite method is used, adjust accumulated depreciation such that gain/loss computes as zero ($0).

4/12/2011 - City model                                                                                                                                                                                                                                 16
                                                                                                                                                                                                                                               Entry F


                                                                                         Adjust Other Capital Asset Entries to Full Accrual

      B. Trade-in of capital assets.
                                                                                                                                    Other                         Vehicles +            Other asset             Other asset
               Trade-in of Capital assets:                                                               Land         Building   Improvement Equipment            Mot. Equip             Class #1                Class #2              Total
               a. What is the original cost at the beginning of the year for assets
                  traded-in during current year?                                                                                                                                                                                               -
               b. What is the accumulated depreciation at the beginning of the year                       N/A
                  for the assets traded-in a. above?                                                                                                                                                                                           -
                                                                                                                                                                                                                                               -
               c. What is the depreciation expense for the current year up to the                         N/A
                  date of trade-in for the asset above?                                                                                                                                                                                        -
                              Net book value of capital assets traded                                           -            -           -              -                      -                      -                       -                -
               d. Enter net book value of traded asset calculated above into the cell
                  for the asset class for the newly acquired asset? (typically it will
                  be the same asset class as the old asset but it may be a different
                  class.)                                                                                                                                                                                                                      -


      C. Retiring, scrapping and donating capital assets (with no proceeds):             j

                                                                                                                                    Other                         Vehicles +            Other asset             Other asset
               Retiring, scrapping or donating Capital assets:                                           Land         Building   Improvement Equipment            Mot. Equip             Class #1                Class #2          Infrastructure
               a. What is the original cost at the beginning of the year for assets                                                             11,350                  42,695
               b. What is the accumulated depreciation at the beginning of the year                       N/A                                      11,350                 41,000

               c. What is the depreciation expense for the current year up to the                         N/A
                  date of trade-in for the asset above?                                                                                                                     1,695
                              Loss on disposal of assets                                                        -            -           -              -                      -
               d. Of any assets donated above, what is the net book value (cost less total accum.
                  deprec. for all asset classes ) of any assets donated to the Enterprise Funds or an                                         This amount will be classified as a "transfer out" for the governmental activities
                  Internal Service Fund reported in business-type activities?                                                                column. It should also be included as a reconciling item to the fund statements.

                              j If proceeds received then treat transaction as a sale and enter in section A. above

      D. Capital assets received by the unit as donations:
                                                                                                                                    Other                         Vehicles +            Other asset             Other asset
               Donations of capital assets received by the unit:                                         Land         Building   Improvement Equipment            Mot. Equip             Class #1                Class #2          Infrastructure
               a. What is the fair value of all the assets donated to the unit? Enter
                  the amounts in the appropriate asset class.                                             12,000
               b. Indicate any amounts from above that would qualify as a special item.
               c. What is the net book values of any assets donated from or transferred in from
                  the Enterprise Funds or an Internal Service Fund accounted for in Business-type                                             This amount will be classified as a "transfer in" for the governmental activities
                  activities included in the amount above?                                                                                   column. It should also be included as a reconciling item to the fund statements.



      E. Reclassify capital outlay expenditures where the city does not hold title to the assets:
           1. What expenditures classified as "capital outlay" were spent for assets where the city
              does not hold title to the asset, (e.g. economic development project)?
           2. Indicate the function to which the expenditures in 1 above apply.
                                                            Public Safety
                                                            Transportation
                                                            Economic & physical development                                  -
                                                            Environmental protection                                         -
                                                            Human services                                                   -
                                                            Cultural and recreational                                        -
                                                            Other program 1
                                                            Other program 2                                                  -
                                                                                                                             -

4/12/2011 - City model                                                                                                                                                                                                                              17
                                                                                                                                                                                                                                           Entry F


                                                                                      Adjust Other Capital Asset Entries to Full Accrual

      F. Compute and record asset impairment loss or gain per GASB Statement 42 for physical damage: (Asset must have been restored or be planned for restoration otherwise asset is written off.)
           The carrying value of an asset must be adjusted if its service utility has been significantly impaired. This example addresses the most common, physical damage. To meet the requirements of GASB 42 both of the following
           must be true: 1) magnitude of decline in service utility is significant; and 2) it is unexpected. This entry will calculate the capital asset impairment loss (or gain if an insurance recovery was received) when pysical damage
           occurs using the restoration cost approach. Within that approach, the damage ratio can be calculated by the replacment cost method or the deflator method depending on what information is known. If replacement cost in
           current dollars is not known, then the restoration cost can be deflated to the year of acquisition. Deflation factors can be computed if the inflation factor per year is known or obtained from the internet by using engineering
           construction indexes or the consumer price index and selecting factors for the date of acquisition of the impaired asset.
           Restoration expenditures or insurance recovery may occur in another fiscal year. In that case, the impairment loss is recorded in the year of the loss and the recovery would be recorded as as a gain (miscellaneous revenue
           or extrarodinary gain) depending on the magnitude of the amount.

           1. Assets physically damaged during the year from accidents or natural                                                           Other                           Vehicles +      Other asset       Other asset
              causes which have been or are planned to be restored:                                        Land         Building         Improvement Equipment              Mot. Equip       Class #1          Class #2         Infrastructure
              a. What is the original cost at the beginning of the year for assets physically
                 damaged during current year?                                                                               850,000
               b. What is the accumulated depreciation at the beginning of the year for the                 N/A
                  assets damaged in a. above?                                                                                85,000
               c. What is the depreciation expense for the current year up to the                           N/A
                  date of the damage for the assets above?                                                                       -                                -
                             Net book value of capital assets damaged                                             -         765,000                 -             -                 -
           2. What is (or was) the restoration cost ? (Amount would have been included in
              the capital outlay entry - Tab E - if spent in the same fiscal year.)                        395,240
           3. Answer either a. or b. below, but not both - (either the replacement cost
              method or the deflation factor method is used to calculate loss.)
              a. What is the replacement cost for a new asset of the type                                                                    Restoration cost ratio
                 damaged in 1a. Above?                                                                   1,125,000            0.3513        based on replacement cost
                                                                                     either or
              b. What is the appropriate deflation factor to use if replacement cost                                                                                                         Restoration cost ratio
                 is not known?                                                                                                   -          Deflated restoration cost                        based on deflation factor

           4. Impairment Loss Calculation                                                         3a. Replacement           268,745             3.b Deflator method     0
               a. Indicate to which asset class the loss in 3a or 3b should be
                  credited. Should be same class as that indicated in 1 above.
                  Land
                  Buildings                                     268,745
                  Other Improvements
                  Equipment
                  Vehicles & Motorized Equipment
                  Infrastructure
                  Other asset class #1
                  Other asset class #2

                                                               268,745

           5. Indicate insurance recovery amount if received in this fiscal year?
               a. Other financing source - insurance recovery                                                               325,000

               b.            Net Gain / loss on insurance recovery                                                           56,255




4/12/2011 - City model                                                                                                                                                                                                                           18
                                                                                                                                                              Entry F


                                                                                       Adjust Other Capital Asset Entries to Full Accrual

      F. Asset Impariment Loss - continued
         6. Based on the computation in 5.b above. Enter the gain or loss against the
            proper accounts below:
            a. If there is a net gain, is it an extraordinary gain or miscellaneous
               revenue? Can only be one, not both.
               Extraordinary gain
               Miscellaneous revenue                                          56,255

               b. If there is a net loss, is it an extraordinary loss or a program expense?
                  (GASB definition for extraordinary loss can be found in the authoritative
                  literature.) Enter amount as negative number.
                               Extraordinary loss
                               General Government
                               Public Safety
                               Transportation
                               Economic & physical development
                               Environmental protection
                               Human Services
                               Culture and Recreation
                               Other program 1
                               Other program 2

                                              Total for 6a and 6b above       56,255


      G. Final Entry to Conversion Worksheet for sales, disposals, donations to the unit of capital assets and asset impairment loss: [Entry F.1, 2, 3 & 4]
                                                                                                               Debit             Credit
                   F.1        Accumulated depreciation - Buildings                                                   -                 -
                              Accumulated depreciation - Other improvements                                          -                 -
                              Accumulated depreciation - Equipment                                                21,350               -
                              Accumulated depreciation - Vehicles & motorized equipment                           42,695               -
                              Accumulated depreciation - Other asset class #1                                        -                 -
                              Accumulated depreciation - Other asset class #2                                        -                 -
                              Accumulated depreciation - Infrastructure                                              -                 -
                              OFS - Sale of capital assets - other financing source                                5,000               -
                              Miscellaneous revenue                                                                  -                 -
                              General Government…….loss on disposal                                                  -                 -
                              OFU - Transfer Out                                                                     -                 -
                                 Land                                                                                -                 -
                                 Buildings                                                                           -                 -
                                 Other Improvements                                                                  -                 -
                                 Equipment                                                                           -              21,350
                                 Vehicles & Motorized Equipment                                                      -              42,695
                                 Infrastructure                                                                      -                 -
                                 Other asset class #1                                                                -                 -
                                 Other asset class #2                                                                -                 -
                                 Miscellaneous general revenue [gain (loss) on sale] k                               -               5,000
                                 Special Item - gain (loss) on sale of asset        l                                -                 -




4/12/2011 - City model                                                                                                                                             19
                                                                                                                                                                                                                               Entry F


                                                                                Adjust Other Capital Asset Entries to Full Accrual
                   F.2   Land                                                                                          12,000                 -
                         Buildings                                                                                        -                   -
                         Other Improvements                                                                               -                   -
                         Equipment                                                                                        -                   -
                         Vehicles & Motorized Equipment                                                                   -                   -
                         Infrastructure                                                                                   -                   -
                         Other asset class #1                                                                             -                   -
                         Other asset class #2                                                                             -                   -
                              Miscellaneous revenue                                                                       -                12,000
                              Special item - revenue                                                                      -                   -
                              OFS - Transfer In                                                                           -                   -
                   F.3   Public Safety                                                                                     -                   -
                         Transportation                                                                                    -                   -
                         Economic & physical development                                                                   -                   -
                         Environmental protection                                                                          -                   -
                         Human services                                                                                    -                   -
                         Cultural and recreational                                                                         -                   -
                         Other program 1                                                                                   -                   -
                         Other program 2                                                                                   -                   -
                             Capital outlay                                                                                -                   -
                   F.4   OFS - Insurance recovery                                                                     325,000
                             Land                                                                                         -                   -
                             Buildings                                                                                    -               268,745
                             Other Improvements                                                                           -                   -
                             Equipment                                                                                    -                   -
                             Vehicles & Motorized Equipment                                                               -                   -
                             Infrastructure                                                                               -                   -
                             Other asset class #1                                                                         -                   -
                             Other asset class #2                                                                         -                   -
                             Miscellaneous revenue                                                                        -                56,255
                             Extraordinary gain/ioss                                                                      -                   -
                         General Government                                                                               -                   -
                         Public Safety                                                                                    -                   -
                         Transportation                                                                                   -                   -
                         Economic & physical development                                                                  -                   -
                         Environmental protection                                                                         -                   -
                         Human Services                                                                                   -                   -
                         Culture and Recreation                                                                           -                   -
                         Other program 1                                                                                  -                   -
                         Other program 2                                                                                  -                   -
                            Total of F.1, F.2, F.3 and F.4                                                            406,045             406,045

                         k Sales of assets are assumed to generate gains which post to miscellaneous revenue. If losses result the number will appear as a debit. Material losses should be reported as a General Government
                            expense unless they qualify as a "special" item expense. Reclassification of these material losses will be made during the final stages in worksheet L - entry L.10.
                         l Special items are assumed to be gains and posted as such. If a loss results then the amount posted will be a debit.




4/12/2011 - City model                                                                                                                                                                                                              20
                                                                                                                                        Entry G


                   Adjust Debt Service Expenditures Under Modified Accrual to Full Accrual
                   Debt activity under the modified accrual basis of accounting is treated as an expenditure or as an other financing
                   source - debt proceeds. For the full accrual basis of accounting used on the government-wide statements, these
                   debt service expenditures must be adjusted to report the reduction in the principal balance for the permanent
                   liability account. New debt issued during the year will be addressed in Schedule H. Interest expense will be
                   determined by the period the debt is outstanding rather than by the cash payment. Refunding bonds will also be
                   addressed in Schedule H. Please note that these adjustments to debt accounts must be posted to the unit's
                   1.    Review the various governmental funds and identify debt service expenditures that should be recorded as a
                         reduction to a liability as principal is paid down. Enter information in Section A below.
                   2.    Review the governmental funds to determine the amount of interest paid under modified accrual. Also
                         estimate the amount of accrued interest payable at the beginning of the year and for the end of the year
                   3.    The journal entry for the conversion worksheet, to reclassify these expenditures and other financing
                         sources to increases and decreases in the proper liability accounts will be automatically created.



             A.    What was the amount of debt service paid by category of debt for all governmental funds?

                                                                                             Amount
                   1.    Enter the amount of principal paid as debt service in all
                         governmental funds for the categories below?
                                    General obligation bonds                                    10,000
                                    Bond anticipation notes                                        -
                                    Installment purchases/COPs                                     -
                                    Capital leases                                               1,975


                                    Total of principal payments                                 11,975




             B.    What was the interest activity for debt over the year?

                                                                                             Amount

                   1.                                                                            1,355
                         What was accrued interest at the beginning of the year under full accrual?

                   2.    What was the accrued interest at the end of the year under full accrual? 2,133




             C.    Entry for conversion worksheet to record reductions in outstanding debt and interest expense and liability.          [Entry G.1, G.2 & G.3]


                                                                                              Debit          Credit
                                    G.1         General obligation bonds payable                10,000            -
                                                Bond anticipation notes payable                    -              -
                                                Installment purchases/COPs payable                 -              -
                                                Capital leases payable                           1,975            -
                                                      Debt Service -principal retirement           -           11,975
                                    G.2         Beginning fund balance                           1,355
                                                     Accrued interest payable                                   1,355
                                    G.3         Accrued interest payable                           -              778
                                                     Interest expense                              778            -
                                                                                                14,108         14,108




4/12/2011 - City model                                                                                                                          21
                                                                                                                                                                Entry H


                                                  Debt Issues and Other Debt Related Transactions

       The issuance of debt needs to be reflected in the proper liability accounts rather than as other financing sources in order to prepare the government-
       wide Statement of Net Assets. Also, corresponding transactions for premiums, discounts and issuance costs must be adjusted from other financing
       uses to liabilities, contra-liabilities, and deferred charges. Refunding bonds must also be adjusted to the proper permanent accounts. Refunding
       bonds and their corresponding defeased debt will be handled together in the same section below. Bond issuance cost and deferred charges must be
       amortized over the life of any debt issued from the year of implementation forward to correctly state expenses on the Statement of Activities. The
       unit's permanent accounts will need to be adjusted to properly reflect next year's beginning balances for debt related accounts.

       1.    Review the governmental funds for additions to the various debt categories which would have been recorded as an other financing source - debt
             proceeds. Enter information in Section B below. New issuance of refunding bonds will be handled in section B.
       2.    Review the governmental funds and record the information regarding bond refunding including the new debt, the old debt, the payment to the
             escrow agent, and any issuance costs. (If there were multiple refundings in the year, combine the numbers.)
       3.    Review the accounts for deferred charges from refunding and issuance cost and any discounts or premiums that must be amortized over the
             life of the debt. Indicate the amount for the annual expense.



A.     What was the amount of new debt issued by category for all governmental funds? (Exclude refunding bonds.)

                                                                                        Face                                        Issuance
                                                                                       Amount        Discount      Premium            Cost
       1.    Enter the face amount of newly issued debt and any
             discount, premium or issuance cost for all governmental
             funds by the categories below?
                         General obligation bonds                                            -                                             -
                         Bond anticipation notes                                             -                                             -
                         Installment purchases/COPs                                      200,000                                           -
                         Capital leases                                                   19,000                                           -


                              Total of new debt                                          219,000




B.     Complete the questions below regarding bond refunding.


       Old Debt:
       1. What was the amount outstanding for the old debt at
             the time it was refunded?
       2.    What was the amount of any unamortized discount,          Unamortized                  Unamortized                     Unamortized
             premium or issuance cost on the old debt?                  Discount =                   Premium =            -      Issuance Cost =

       Proceeds of New Debt:
       3. What is the face amount of the new debt issued?
       4.    What was discount on the new debt?
       5.    What was the premium on the new debt?
       6.    What was issuance cost for new debt?
                       Net Proceeds of New Debt Issue:                                                      -

       Payments to Escrow Agent:
       7. What was the payment to the escrow agent to defease
           old debt?
       8.    Were there any additional payments to the escrow
             agent charged to debt service?
                        Reacquisition cost:                                                                 -



C.     Amortize bond issuance cost and deferred charges for the current year.

       Units may elect to amortize the discount or premium on bonds and the deferred charge (loss) on refunding using the straight-line method or the
       effective interest rate amortization method.
       1.    What is the current year annual amortization for issuance costs?

       2.    What is the current year annual amortization for discounts?
       3.    What is the current year annual amortization for
             deferred charge (loss) from refunding?
       4.    What is the current year annual amortization for premiums?




     4/12/2011 - City model                                                                                                                                          22
                                                                                                                                   Entry H


                                            Debt Issues and Other Debt Related Transactions



D.     Entry for conversion worksheet to record additions to outstanding debt and all refunding activity. [Entry H.1]


                                                                                                             Debit      Credit
                              H.1   OFS - Capital leases (proceeds)                                           19,000         -
                                    OFS - Installment purchases/COPS (proceeds)                              200,000         -
                                    OFS - Bonds issued (proceeds)                                                 -          -
                                    OFS - Premiums on debt issued - other financing source                        -          -
                                    Discounts on debt issued - contra-liability                                   -          -
                                    Deferred Charges - issuance cost                                              -          -
                                    Deferred Charges - refunding                                                  -          -
                                    General Government - expense                                                  -          -
                                         Debt service - bond issuance cost                                        -          -
                                         Debt service - advance refunding escrow                                  -          -
                                         Debt service - interest and fees                                         -          -
                                         OFU - Discount on debt issued - other financing use                      -          -
                                         OFU - Payment to escrow agent                                            -          -
                                         Premium on debt issued - liability                                       -          -
                                         General obligation bonds                                                 -          -
                                         Bond anticipation notes                                                  -          -
                                         Installment purchases/COPs                                               -      200,000
                                         Capital leases - liability                                               -       19,000
                                                                                                             219,000     219,000




     4/12/2011 - City model                                                                                                             23
                                                                                                                                                     Entry I


                                                      Adjustments to Other Asset Accounts
       There are asset accounts that may not be recorded on the fund statements which will be required to be reported in the government-wide financial
       statements. These assets include such items as equity interests in joint ventures, advance funding of pension costs, and prepaid expenses and
       inventory when the purchases method is used. If the consumption method was used, no entry is required, but if the purchases method was used an
       adjustment must be made if the amount is material. If inventories or prepaid expenses are not recorded in the fund financial statements because
       they are not material, they are assumed not to be material to the government-wide statements. The results will be need to be posted to the unit's
       permanent accounts to properly reflect next year's beginning balances.
       1.    Equity in joint ventures is defined by GASB 14 and should be recorded as an asset if there is an underlying contract which creates an explicit,
             measurable equity interest. The increase (or decrease) will be recognized as revenue (or loss) on the Statement of Activities.
       2.
             Governmental funds have the option to record inventories and prepaid expenses using the purchases method; i.e. recognizing an expenditure
             at the time of purchase rather than based on consumption. GASB 34 requires that inventories and prepaid expenses be accounted for as
             assets regardless of their treatment in the fund financial statements if material. Therefore balances remaining in inventories or prepaid
             expenses must be recorded as assets for the government-wide statements and the corresponding expenditures must be reduced.
       3.    Advance funding of pension occurs when the benefit plan has a negative net pension obligation. A net pension obligation (liability - which is
             the normal case) should be addressed in worksheet J.



A.     Equity interest in joint ventures -    ( Underlying contract creates explicit, measurable equity interest - otherwise note disclosure only)

                                                                                                               Amount
       1.    What is the amount of the unit's equity interest in all joint ventures at the end
             of the prior year (beginning balance.)

       2.    Indicate the amount of any distributions during the current year that were
             recognized as revenue under modified accrual.

       3.    What is the amount of the unit's equity interest in all joint ventures at the end
             of the current year (ending balance.)

                                                        Net change in value over the year                              -


B.     Prepaid expenses - if recorded at the fund level using the purchases method
                                                                                                               Amount
       1.    What was the amount of the Reserve for Prepaid Expenses at the end of the
             prior year?
       2.    What was the amount of Reserve for Prepaid Expenses at the end of the
             current year?
                                                   Net change for the year                                             -       j
       3.    Indicate to which function the net change in prepaid expenses applies. The
             sum of the amounts below must equal the amount in the net change field
             above .

                                                                                                            Net Change
                                                                                                             Amount
                                                        General government
                                                        Public Safety
                                                        Transportation
                                                        Economic & physical development
                                                        Environmental protection
                                                        Human services
                                                        Cultural and recreation
                                                        Other program 1
                                                        Other program 2
                                                                                                        j              -




     4/12/2011 - City model                                                                                                                                  24
                                                                                                                                               Entry I


                                                    Adjustments to Other Asset Accounts

C.     Inventory - if recorded at the fund level using the purchases method
       Purchases method

       1.    What was the amount of Reserve for Inventory at the end of the prior year?                  1,163
       2.    What was the amount of Reserve for inventory at the end of the current year?                1,245
                                                      Net change for the year                                  82   k
       3.
             Indicate to which function the net change in inventory reserve apply. The sum
             of the amounts below must equal the amount in the net change field above.

                                                                                                   Net Change
                                                                                                     amount
                                                      General government                                     4
                                                      Public Safety                                         29
                                                      Transportation                                        41
                                                      Economic & physical development                     -
                                                      Environmental protection                            -
                                                      Human services                                      -
                                                      Cultural and recreation                                8
                                                      Other program 1                                     -
                                                      Other program 2                                     -
                                                                                               k               82




D.     Intangible Asset - Advance Funding of Pension - (net negative pension obligation. - Net pension liability found on Worksheet J.)

                                                                                                                                  Amount
       1.    What was the amount of the net negative pension obligation at the beginning of the year. If multiple benefit plans
             are involved enter the sum of all plans.                                                                                  -

       2.    What was the amount of the pension obligation at the end of the year. If multiple benefit plans are involved enter
             the sum of all plans.                                                                                                     -
                                                    Change in pension obligation during the year                                       -   l

       3.    Enter the function which paid the amount above. For the amount for the Law Enforcement Officer's Separation
             Allowance, the Public Safety function would have made the overpayment. If multiple functions contribute to
             other plans, the overpayment may be prorated based on total payments. The sum of these amounts must equal
             the amount in the change in pension obligation field above.
                                         General government
                                         Public Safety
                                         Transportation
                                         Economic & physical development
                                         Environmental protection
                                         Human services
                                         Cultural and recreation
                                         Other program 1
                                         Other program 2

                                                      Total of pension over funding            l           -




     4/12/2011 - City model                                                                                                                        25
                                                                                                                               Entry I


                                                  Adjustments to Other Asset Accounts


       Entry for Conversion worksheet to record changes in assets. (Entry I.1)
E.
                                                                                            Debit            Credit
       I.1                      Investment in joint venture                                         -                 -
                                Miscellaneous revenue                                               -                 -
                                Change in Reserve for prepaid expense                               -                 -
                                Change in reserve for Inventory                                         82            -
                                Intangible asset - advance funding of pension                       -                 -
                                     General government                                             -                      4
                                     Public Safety                                                  -                     29
                                     Transportation                                                 -                     41
                                     Economic & physical development                                -                 -
                                     Environmental protection                                       -                 -
                                     Human services                                                 -                 -
                                     Cultural and recreation                                        -                     8
                                     Other program 1                                                -                 -
                                     Other program 2                                                -                 -
                                     Misc. Revenue - [Net Income (loss) in joint venture]           -                 -
                                     Fund balance                                                   -                 -
                                                                                                        82                82




     4/12/2011 - City model                                                                                                        26
                                                                                                                                  Entry J


                                Adjustments to Other Liability and Expense Accounts
      Expenses need to be accrued for those liabilities incurred during the period which are not normally paid with current available
      resources. This includes items such as compensated absences, claims and judgments, landfill closure and post-closure costs, the net
      pension cost of unit managed benefit plans, any other postemployment benefits or other long-term liabilities. The results will need to be
      posted to permanent accounts for next year's beginning balances.
      1.    Compensated absences earned during the current period must be reported as an expense under full accrual accounting. This
            may be a number that is not easily determined. Typically, you will know the beginning and ending balances and either the
            leave earned during the current year (Method 1) or the leave used during the current year (Method 2). Choose ONE of the
            tables below in Section A. Enter the data in the yellow fields. The cells in blue with the red caption will be calculated. The
            information must be entered by function in order to calculate functional expense for the current year and prior years. This data
            will provide the information to create the entry to record current year expense and the entry to eliminate expenditures related
            to prior years. (Choose only one method, if data is entered into both tables the resulting entry will be overstated.)

      2.    Review the governmental funds for expenditures made during the year for claims & judgments. Enter the payment amounts in
            section B.1 below. Also, determine additions to claims & judgments from management. Enter the amounts of the new liability
            by function in section B.2.
      3.    The net pension obligation has always been calculated for the note disclosure if the unit had an actuarial study performed. If
            material, most units also recorded the amount in the General Long Term Debt account. The beginning balance was recorded
            earlier when the capital assets and long term debt accounts were recorded. The information to be recorded in Section C is
            the incremental change in the current year. If the pension obligation has been advance funded, please complete the
            questions on the Worksheet I and leave this section blank.
      4.    The other post-employment benefits (OPEB) may be calculated through an actuarial study or by calculations using the
            alternative method. All units must record the amount in their General Long Term Debt account, if the benefits are offered.
            The information to be recorded here is the incremental change in the current year, based on beginning and ending computed
            liabilities. If the OPEB obligation has been advance funded, please complete the questions on the Worksheet I and leave
            this section blank.
      5.    For other long term liabilities, the incremental changes will need to be recorded charging the expense to the corresponding
            function. For counties with landfills in the general fund who have a liability for post-closure cost, use the other liability
            accounts in Section E. The function to be effected for the changes is the function in which the unit accounts for the landfill.


A.    Compensated Absences - What are current and prior year expenses under full accrual? (Choose Method 1 or 2)
      Method 1 - know current year amounts earned                   Beginning            Current year              Ending
                                                                     Balance         Earned        Used*           Balance
            General government                                          24,572        16,565          7,817          33,320
            Public Safety                                               43,001        28,988          9,203          62,786
            Transportation                                              30,715        23,106         12,572          41,249
            Economic & physical development                              6,143         4,141          1,923            8,361
            Environmental protection                                    12,286         8,282          4,651          15,917
            Human services                                                  -             -             -                -
            Cultural and recreation                                      6,143         4,142          2,295            7,990
            Other program 1                                                 -             -             -                -
            Other program 2                                                 -             -             -                -
                                                                       122,860        85,224         38,461         169,623

      Method 2 - know current year amounts taken                    Beginning            Current year              Ending
                                                                     Balance        Earned*         Used           Balance
            General government                                                           -
            Public Safety                                                                -
            Transportation                                                               -
            Economic & physical development                                              -
            Environmental protection                                                     -
            Human services                                                               -
            Cultural and recreation                                                      -
            Other program 1                                                              -
            Other program 2                                                 -            -
                                                                            -            -              -                 -
           * Calculated -      Do not enter data into both tables !

     4/12/2011 - City model                                                                                                              27
                                                                                                                                           Entry J


                                    Adjustments to Other Liability and Expense Accounts

B.    What are the adjustments to expenses and liabilities for claims and judgments ?

      1.    What was the balance at the end of the prior year for claims and judgments?

      2.    What was the amount of new claims incurred during this current year?                                                           j
      3.    Indicate the amount of payments made on claims & judgments during current year.                                                k
      4.    Were there any adjustments in the current year for prior year claims?
            Please enter reductions as negative amounts and increases as positive amounts.
                                                                                                                                           l
      5.    Ending balance for claims & judgments for the current year. - calculated                                               -
      6.    Indicate to which function the new claims and judgments listed in step 2 apply. The sum of the
            amounts below must equal the amount in the corresponding step above. Indicate to which
            function the payment was charged in step 3. Indicate to which function any adjustments noted
            in step 4 should be recorded. Indicate any amounts that should be reported as special or
            extraordinary items.
                                                            New claims                       Payments                       Adjustments
            General government
            Public Safety
            Transportation
            Economic & physical development
            Environmental protection
            Human services
            Cultural and recreation
            Other program 1
            Other program 2
            Special item
            Extraordinary item
                                                      j              -                 k          -                l                   -


C.    What is the addition to the net pension obligation for the year?

                                                                                                                              Amount
      1.    What was the amount of the net pension obligation at the beginning of the year. If multiple
            benefit plans are involved enter the sum of all plans. (Beginning balances were recorded in Columns AF &
            AG in the main Conversion Worksheet.)                                                                               38,083
      2.    What was the amount of the net pension obligation at the end of the year. If multiple benefit
            plans are involved enter the sum of all plans.                                                                      44,719
                                        Change in pension obligation during the year                                             6,636     m
      3.    Enter the cost by function for the increment above, e.g. for the Law Enforcement Officer's
            Separation Allowance the amount is entered as a cost to Public Safety. If other plans exist
            covering other employees or all employees then their respective function should be charged.
            The total for the detail in step 3 must equal the amount in step 2. (If the change in Step 2 is negative, the
            sum of step 3 should also be negative.)
                          General government                                                                                       -
                          Public Safety                                                                                          6,636
                          Transportation                                                                                           -
                          Economic & physical development                                                                          -
                          Environmental protection                                                                                 -
                          Human services                                                                                           -
                          Cultural and recreation                                                                                  -
                          Other program 1                                                                                          -
                          Other program 2                                                                                          -
                                     Total of incremental net pension costs                                        m             6,636




     4/12/2011 - City model                                                                                                                     28
                                                                                                                                       Entry J


                                   Adjustments to Other Liability and Expense Accounts

      What is the addition to the net OPEB obligation for the year for the Total Governmental Funds portion?                  Please refer to
D.    Memorandum #2010-1 for a journal entry overview.

                                                                                                                         Amount
      1.    What was the amount of the net OPEB obligation at the beginning of the year? If multiple
            benefit plans are involved enter the sum of all plans. (Beginning balances for Governmntal Funds only were
            recorded in Columns AF & AG in the main Conversion Worksheet.)                                                   -
      2.    What was the amount of the net OPEB obligation at the end of the year? If multiple benefit
            plans are involved enter the sum of all plans. Only include the portion related to Governmental Funds.        37,044
                                   Change in OPEB obligation during the year                                              37,044      n
      3.    Enter the cost by function for the increment above, e.g. for Retirees Healthcare. If plans exist
            covering employees then their respective function should be charged. The total for the detail in
            step 3 must equal the amount in step 2. (If the change above is negative, the sum of step 3 should also be
            negative.)
                          General government                                                                               5,146
                          Public Safety                                                                                   26,547
                          Transportation                                                                                   4,162
                          Economic & physical development                                                                    -
                          Environmental protection                                                                           649
                          Human services                                                                                     -
                          Cultural and recreation                                                                            540
                          Other program 1                                                                                    -
                          Other program 2                                                                                    -
                                     Total of incremental net OPEB costs                                             n    37,044




     4/12/2011 - City model                                                                                                                     29
                                                                                                                                      Entry J


                                    Adjustments to Other Liability and Expense Accounts

E.    Other long-term debt liabilities - What are adjustments to expenses and liabilities?
                                                                                                                      Other long-   Other long-term
                                                                                                                     term debt #1       debt #2
      1.    What was the balance at the end of the prior year for other long-term liabilities?
      2.    What was the amount of new claims incurred during this current year?                               o                                      r
      3.    Indicate the amount of payments made on other long-term liabilities.                               p                                      s
      4.    Were there any adjustments to these account balances during the year?              Please
            enter reductions as negative amounts and increases as positive amounts.                            q                                      t
      5.    Ending balance for other long-term liabilities for the current year. - calculated                                -                -
      6.    Indicate to which function the new "other liabilities" listed in step 2 apply. The sum of the
            amounts below must equal the amount in the corresponding step above. Indicate to which
            function the payment was charged in step 3. Indicate to which function any adjustments noted
            in step 4 should be recorded. Indicate any amounts that should be reported as special or
            extraordinary items.

                                                                     Other long-term debt #1                   Other long-term debt #2
                                                            New claims         Payments   Adjustments   New claims     Payments  Adjustments
            General government
            Public Safety
            Transportation
            Economic & physical development
            Environmental protection
            Human services
            Cultural and recreation
            Other program 1
            Other program 2
            Special item
            Extraordinary item
                                                                     -                -            -           -             -                -
                                                                    o             p            q           r             s               t




F.    Journal entry for conversion worksheet to record additions and reductions in outstanding debt. [Entry J.1]
                                                                                          Debit        Credit
                     J.1        General government                                         13,894           -
                                Public Safety                                              52,968           -
                                Transportation                                             14,696           -
                                Economic & physical development                              2,218          -
                                Environmental protection                                     4,280          -
                                Human services                                                 -            -
                                Cultural & recreation                                        2,387          -
                                Other program 1                                                -            -
                                Other program 2                                                -            -
                                Special item                                                   -            -
                                Extraordinary item                                             -            -
                                Compensated absences                                           -        46,763
                                    Claims & Judgments                                         -            -
                                    Other L.T. Liability 1                                     -            -
                                    Other L.T. Liability 2                                     -            -
                                    Net Pension Obligation                                     -          6,636
                                    Net OPEB Obligation                                        -        37,044
                                                                                           90,443       90,443


     4/12/2011 - City model                                                                                                                  30
                                                                                                                                                                  Entry K.1




                                                      GASB 34 - Allocation of Internal Service Funds (Fund #1)
        This worksheet prepares the allocation of internal service funds using the Look -back approach. Internal service funds should gen erally operate on a
        breakeven basis. Therefore when a profit or loss results from internal transactions, it should be allocated back to the funds involved based on their
        percentage of participation. If the Internal Service fund had a net loss, the allocation would result in a corresponding incr ease in expenses. Any
        adjustments arising from these calculations are not intended to be posted to the general ledger. They should be treated as re porting entries for purposes
        of reporting on the government-wide statements and will be posted only to the conversion worksheet. A separate worksheet should be prepared for each
        individual internal service fund. Three worksheets for internal service fund allocation have been provided and mapped to the conversion worksheet. If
        more copies are needed then their resulting entries will require an entry (and mapping) to the conversion worksheet or you ma y choose to enter the
        entries directly into the yellow "Misc. Entries" column (be careful not to overwrite the data mapped from the other internal service funds.)



        1. Determine the proportionate participation of each function by matching the charge for service with the functional category and determine which activity
           primarily benefits from the internal service fund - governmental or business type in Step A. If business type activity is determined as the primary
           beneficiary, please delete data from this form and enter it in the business type worksheet provided on the website.
        2. Enter the amounts in Step B for the permanent balance sheet accounts for the given internal service fund. These amounts will be posted to the
           governmental activity column as determined in Step A to be the primary beneficiary of the internal service fund's activities. This worksheet will handle
           only those funds determined to benefit governmental activities. In step 2 of Section B enter the amounts that must be excluded from the allocation.
           These amounts come directly from the fund statements. Also, in step 3 enter the change in net assets from the income statement for the fund being
           allocated.
        3. Adjust for the prior year's internal balance in Step C. This adjusts beginning net assets to match the government-wide presentation. k
        4. Section D is the actual allocation of the residual profit or loss computation. These are the amounts that will be included in your reconciliation from the
           fund balance on the fund statements to the government-wide net assets amount.
        5. The entry is automatically generated from all the data provided and mapped to the Reclassifications and Eliminations column of the Conversion
           Worksheet as entry K.1-3. Additional worksheets are provided for other internal service funds and their entries are mapped together such that K.1 +
           K.2 + K.3 results in the final K.1-3 entry. Please note that if rounding causes a slight inaccuracy, adjustments can be made.


            k   The method used throughout this worksheet differs from the GAAFR by using beginning fund balance rather than ending balance. This
            method generates a calculation for beginning equity on the full accrual basis of accounting.



   A. Enter the dollar amount of revenues paid by each function to the internal service fund. The percentage of total internal charges will be
      automatically calculated. This will provide the information to determine the primary activity type. The activity which is the primary beneficiary
      will be the activity to which balance sheet accounts are recorded later in the entry.


                                           Determination of Proportionate Participation
                                                                                 $                        %
            Internal Charges
               Governmental Activities:
                  General government                                     $             600                     1.9%
                  Public safety                                                     17,000                    53.8%
                  Transportation                                                     3,000                     9.5%
                  Economic & physical development                                      -                       0.0%
                  Environmental protection                                           4,000                    12.7%
                  Human Services                                                       -                       0.0%
                  Culture and recreation                                             2,000                     6.3%
                  Other program 1                                                      -                       0.0%
                  Other program 2                                                      -                       0.0%

                     Total Governmental Activities                       $          26,600                    84.2% j

               Business-type Activities:
                 Water and sewer                                         $           2,000                     6.3%
                 Electric                                                            3,000                     9.5%
                 Other Enterprise 1                                                    -                       0.0%
                 Other Enterprise 2                                                    -                       0.0%

                     Total Business-type Activities                      $           5,000                    15.8%

                         Total Internal Charges                          $          31,600                     100%

            External Charges                                                           330

                         Total Charges for Services                      $          31,930


                                                                                                  If the predominant activity is business type, please copy your numbers
            The Predominant Activity Type is                                                     into the business type activities worksheet contained in the conversion
            (business or governmental): -- automatic calculation           Governmental      j   worksheet for business type activities and delete them here.




4/12/2011 - City model                                                                                                                                                     31
                                                                                                                                                                                       Entry K.1

   B. Record the trial balance for permanent balance sheet accounts of the internal service fund. Amounts should be ending balances except for net
      assets (fund balance.) It should be recorded at the beginning amount for the fiscal year. In step 2 enter the amounts for those items which
      should be eliminated when allocating the Internal Service fund's net profit or loss. In step 3 enter the amount for "Change in Net Assets" from
      the income statement.
        1. Record permanent balance sheet accounts.                                              Debit              Credit
             Cash & cash equivalents                                                                  25,730
             Investments                                                                                 -
             Due from other funds                                                                      2,600
             Advances to other funds                                                                     -
             Inventories                                                                               2,700
             Prepaid items                                                                               -
             Land                                                                                        -
             Buildings                                                                                26,000
             Equipment                                                                                35,000
             Vehicles                                                                                 10,000                           From fund Statement of Net Assets at end of year
               Buildings - Accum. Depreciation                                                                          26,000
               Equipment - Accum. Depreciation                                                                          12,830
               Vehicles - Accum. Depreciation                                                                            7,500
               Accounts Payable                                                                                          2,900
                Due to other funds                                                                                         -
                Advances from other funds                                                                                  -
               Accrued vacation/Compensated absences                                                                     2,400
               Claims and judgments                                                                                        -
               Net OPEB liability                                                                                          -
               Bonds, notes and loans payable                                                                              -
               Net assets - Beginning balance                                                                           47,770         Beginning fund balance from fund statement

        2. Enter unallocated amounts
             Investment earnings                                                                                             700
             Interest expense                                                                              -                           From fund Statement of Revenues, Expenses, and
             Transfers out                                                                                 -                           Changes in Net Assets
             Transfers in                                                                                                    -
             Charges to external customers                                                                                   330       Compute if not separately disclosed
                                                                                                                                       Calculated based on mark-up, e.g. if mark up is 10%
                Expenses for services provided externally                                                 300                          then cost for revenue of $330 is $300.
                                                                                                                                       From fund Statement of Revenues, Expenses, and
        3. Enter the fund's "change in net assets"                                                                                     Changes in Net Assets
             Enter a positive amount for income; enter a negative
             amount for a loss.                                                2,630
             Sum of amounts in step 2. - calculated                              730
                                                                                                                                        If positive, an excess charge will be allocated; if
                                                                                                                                       negative, a loss or undercharge will be allocated to the
                   Amount to be allocated         - calculated                 1,900                                      1,900        functions that used the service.

                                                                                                     102,330           102,330         Entry must balance !


   C. Adjust beginning net assets (fund balance) for prior year consolidation(s) of internal service funds. (This amount will be the Internal balance
      amount created from last year's final entry for this fund and will become cumulative over time.)
      This will not be an issue in year 1 of implementation. It will only be required in later years.

        1.
             What was the prior year internal balance entry for internal service funds
             allocation for business type activity? Indicate sign - this amount will be negative if
             business type activities owe (have a balance payable to) government type activities and positive
             if business type activities have a balance receivable from government type activities.                          -
                                                                                                                                          Entries must net to zero.
        2.
             What was the prior year internal balance entry for the internal service fund
             allocation for governmental type activity? Indicate sign - this amount will be negative if
             government activities owe (have a balance payable to) business type activities, and positive if
             government type activities have a balance receivable from business type activities.                             -

   D. Compute the adjustment to the expenses in the functional categories by multiplying the proportionate participation percentage determined in
      Step A by the amount of profit or loss to be allocated as calculated in Step D.
                                                                                           Adjustment to         Adjustment to
                                                                                           Governmental          Business-type
                    …. Automatically computed ….                                             Activities            Activities

             General government                                                                             36
             Public safety                                                                               1,022
             Transportation                                                                                181
             Economic & physical development                                                               -
             Environmental protection                                                                      241
             Human Services                                                                                -
             Culture and recreation                                                                        120
             Other program 1                                                                               -
             Other program 2                                                                               -

             Water and sewer                                                                                                 120        * In this scenario the governmental activities, as
                                                                                                                                       primary beneficiary, will have a balance payable to the
             Electric                                                                                                        180       business type activity of $373 which will be posted to
             Other enterprise 1                                                                                              -         the internal balance account to avoid an elimination
             Other enterprise 2                                                                                              -         entry later.
                Total Allocations                                                                        1,600               300   *                                                  1,900
4/12/2011 - City model                                                                                                                                                                            32
                                                                                                                                                                  Entry K.1



   E. Final entry for Conversion worksheet - [Entry K.1] - Posted to the Reclassification & Elimination Column

                                                                              Debit                  Credit

   K.1      Cash & cash equivalents                                               25,730
            Investments                                                              -
            Due from other funds                                                   2,600
            Advances to other funds                                                  -
            Inventories                                                            2,700
            Prepaid items                                                            -
            Land                                                                     -
            Buildings                                                             26,000
            Equipment                                                             35,000
            Vehicles                                                              10,000                             Permanent balance sheet accounts
              Buildings - Accum. Depreciation                                                            26,000
              Equipment - Accum. Depreciation                                                            12,830
              Vehicles - Accum. Depreciation                                                              7,500
              Accounts Payable                                                                            2,900
               Due to other funds                                                                           -
               Advances from other funds                                                                    -
              Accrued vacation/compensated absences                                                       2,400
              Claims and judgments                                                                          -
              Net OPEB liability                                                                            -
              Notes and loans payable                                                                       -
              Fund balance - Beginning balance                                                           47,770
              Investment Earnings - General revenue                                                           700
              Charges for service - General government                                                        330
              Direct expenses - General government                                    300                            Unallocated amounts for operating accounts
              Interest and fees                                                       -
              Transfers in                                                                                    -
              Transfers out                                                           -
               General government expenditures                                                                36
               Public safety expenditures                                                                  1,022
               Transportation expenditures                                                                   181
               Economic & physical development                                                               -
               Environmental protection expenditures                                                         241     Allocation of profit or loss
               Human Services expenditures                                                                   -
               Culture and recreation expenditures                                                           120
               Other program 1 expenditures                                                                  -
               Other program 2 expenditures                                                                  -
               Internal balances *                                                                           300
                                                                                102,330                 102,330


            Business-type Activities Adjustments:

            Internal balances *                                                       300
               Water and sewer expenses                                                                       120
               Electric expenses                                                                              180    Must be manually posted to business type
               Other enterprise #1                                                                            -      worksheet elsewhere on the website.
               Other enterprise #2                                                                            -
               Fund balance                                                                                   -
                                                                                      300                     300

            * This amount will become the reconciling amount to be entered in Section C, steps 1 & 2 for the next year. In subsequent years the amount for
            Section C becomes cumulative, with year 1's balance added to year 2 etc. over time.




4/12/2011 - City model                                                                                                                                                  33
                                                                                                                                                                 Entry K.2




                                                      GASB 34 - Allocation of Internal Service Funds (Fund #2)
      This worksheet prepares the allocation of internal service funds using the Look-back approach. Internal service funds should generally operate on a
      breakeven basis. Therefore when a profit or loss results from internal transactions, it should be allocated back to the funds involved based on their
      percentage of participation. If the Internal Service fund had a net loss, the allocation would result in a corresponding increase in expenses. Any
      adjustments arising from these calculations are not intended to be posted to the general ledger. They should be treated as reporting entries for purposes
      of reporting on the government-wide statements and will be posted only to the conversion worksheet. A separate worksheet should be prepared for each
      individual internal service fund. Three worksheets for internal service fund allocation have been provided and mapped to the conversion worksheet. If
      more copies are needed then their resulting entries will required an entry (and mapping) to the conversion worksheet or you may choose to enter the
      entries directly into the yellow "Misc. Entries" column (be careful not to overwrite the data mapped from the other internal service funds.)

       1. Determine the proportionate participation of each function by matching the charge for service with the functional category and determine which activity
          primarily benefits from the internal service fund - governmental or business type in Step A. If business type activity is determined as the primary
          beneficiary, please delete data from this form and enter it in the business type worksheet provided on the website.
       2.
            Enter the amounts in Step B for the permanent balance sheet accounts for the given internal service fund. These amounts will be posted to the
            governmental activity column as determined in Step A to be the primary beneficiary of the internal service fund's activities. This worksheet will handle
            only those determined to benefit governmental activities. In step 2 of Section B enter the amounts that must be excluded from the allocation. These
            amounts come directly from the fund statements. Also, in step 3 enter the change in net assets from the income statement for the fund being allocated.
       3. Adjust for the prior year's internal balance in Step C. This adjusts beginning net assets to match the government-wide presentation. k
       4. Section D is the actual allocation of the residual profit or loss computation. These are the amounts that will be included in your reconciliation from the
          fund balance to the government-wide net assets amount.
       5. The entry is automatically generated from all the data provided and mapped to the Reclassifications and Eliminations column of the Conversion
          Worksheet as entry K.1-3. Additional worksheets are provided for other internal service funds and their entries are mapped together such that K.1 + K.2
          + K.3 results in the final K.1-3 entry. Please note that if rounding causes a slight inaccuracy, minor adjustments can be made.


            k   The method used throughout this worksheet differs from the GAAFR by using beginning fund balance rather than ending balance. This
            method generates a calculation for beginning equity on the full accrual basis of accounting.


  A. Enter the dollar amount of revenues paid by each function to the internal service fund. The percentage of total internal charges will be
     automatically calculated. This will provide the information to determine the primary activity type. The activity which is the primary beneficiary will
     be the activity to which balance sheet accounts are recorded later in the entry.


                                          Determination of Proportionate Participation
                                                                                $                          %
            Internal Charges
               Governmental Activities:
                  General government                                      $             -                       0.0%
                  Public safety                                                         -                       0.0%
                  Transportation                                                        -                       0.0%
                  Economic & physical development                                       -                       0.0%
                  Environmental protection                                              -                       0.0%
                  Human Services                                                        -                       0.0%
                  Culture and recreation                                                -                       0.0%
                  Other program 1                                                       -                       0.0%
                  Other program 2                                                       -                       0.0%

                    Total Governmental Activities                         $             -                       0.0%   j

              Business-type Activities:
                Water and sewer                                           $             -                       0.0%
                Electric                                                                -                       0.0%
                Other Enterprise 1                                                      -                       0.0%
                Other Enterprise 2                                                      -                       0.0%

                    Total Business-type Activities                        $             -                       0.0%

                         Total Internal Charges                           $             -                       0.0%

            External Charges                                                            -

                         Total Charges for Services                       $             -


                                                                                                   If the predominant activity is business type, please copy your numbers
            The Predominant Activity Type is                                                      into the business type activities worksheet contained in the conversion
            (business or governmental): -- automatic calculation          Business Type       j   worksheet for business type activities and delete them here.




4/12/2011 - City model                                                                                                                                                  34
                                                                                                                                                                                 Entry K.2

  B. Record the trial balance for permanent balance sheet accounts of the internal service fund. Amounts should be ending balances except for net
     assets (fund balance.) It should be recorded at the beginning amount for the fiscal year. In step 2 enter the amounts for those items which should
     be eliminated when allocating the Internal Service fund's net profit or loss. In step 3 enter the amount for "Change in Net Assets" from the
     income statement.
       1. Record permanent balance sheet accounts.                                              Debit                Credit
          Cash & cash equivalents                                                                         -
          Investments                                                                                     -
          Due from other funds                                                                            -
          Advances to other funds                                                                         -
          Inventories                                                                                     -
          Prepaid items                                                                                   -
          Land                                                                                            -
          Buildings                                                                                       -
          Equipment                                                                                       -
          Vehicles                                                                                        -                       From fund Statement of Net Assets at end of year
            Buildings - Accum. Depreciation                                                                                   -
            Equipment - Accum. Depreciation                                                                                   -
            Vehicles - Accum. Depreciation                                                                                    -
            Accounts Payable                                                                                                  -
             Due to other funds                                                                                               -
             Advances from other funds                                                                                        -
            Accrued vacation/Compensated absences                                                                             -
            Claims and judgments                                                                                              -
            Net OPEB liability                                                                                                -
            Bonds, notes and loans payable                                                                                    -
            Net assets - Beginning balance                                                                                    -   Beginning fund balance from fund statement

       2. Enter unallocated amounts
            Investment earnings                                                                                               -
            Interest expense                                                                              -                       From fund Statement of Revenues, Expenses, and
            Transfers out                                                                                 -                       Changes in Net Assets
            Transfers in                                                                                                      -
            Charges to external customers                                                                                     -   Compute if not separately disclosed
                                                                                                                                  Calculated based on mark-up, e.g. if mark up is 10%
               Expenses for services provided externally                                                  -                       then cost for revenue of $330 is $300.
                                                                                                                                  From fund Statement of Revenues, Expenses, and
       3. Enter the fund's "change in net assets"                                                                                 Changes in Net Assets
            Enter a positive amount for income; enter a negative
            amount for a loss.                                                   -
            Sum of amounts in step 2. - calculated                               -
                                                                                                                                   If positive, an excess charge will be allocated; if
                                                                                                                                  negative, a loss or undercharge will be allocated to the
                  Amount to be allocated - calculated                            -                                            -   functions that used the service.

                                                                                                              -               -   Entry must balance !



  C. Adjust beginning net assets (fund balance) for prior year consolidation of internal service funds. (This amount will be the Internal balance
     amount created from last year's final entry for this fund.)
     This will not be an issue in year 1 of implementation. It will only be required in later years.

       1.
            What was the prior year internal balance entry for internal service funds
            allocation for business type activity? Indicate sign - this amount will be negative if
            business type activities owe (have a balance payable to) government type activities and positive if
            business type activities have a balance receivable from government type activities.
                                                                                                                                     Entries must net to zero.
       2.
            What was the prior year internal balance entry for the internal service fund
            allocation for governmental type activity? Indicate sign - this amount will be negative if
            government activities owe (have a balance payable to) business type activities, and positive if
            government type activities have a balance receivable from business type activities.


  D. Compute the adjustment to the expenses in the functional categories by multiplying the proportionate participation percentage determined in
     Step A by the amount of profit or loss to be allocated as calculated in Step D.
                                                                                          Adjustment to           Adjustment to
                                                                                          Governmental            Business-type
                   …. Automatically computed ….                                             Activities              Activities

            General government                                                                            -
            Public safety                                                                                 -
            Transportation                                                                                -
            Economic & physical development                                                               -
            Environmental protection                                                                      -
            Human Services                                                                                -
            Culture and recreation                                                                        -
            Other program 1                                                                               -
            Other program 2                                                                               -
                                                                                                                                   * In this scenario the governmental activities, as
            Water and sewer                                                                                                   -
                                                                                                                                  primary beneficiary, will have a balance payable to the
            Electric                                                                                                          -   business type activity of $304 which will be posted to
            Other enterprise 1                                                                                                -   the internal balance account to avoid an elimination
            Other enterprise 2                                                                                                -   entry later.
4/12/2011 - City model                                                                                                                                                                       35
                                             Entry K.2
             Total Allocations   -   -   *     -




4/12/2011 - City model                             36
                                                                                                                                                                  Entry K.2



  E. Final entry for Conversion worksheet - [Entry K.1] - Posted to the Reclassification & Elimination Column

                                                                            Debit                   Credit

  K.1     Cash & cash equivalents                                                   -
          Investments                                                               -
          Due from other funds                                                      -
          Advances to other funds                                                   -
          Inventories                                                               -
          Prepaid items                                                             -
          Land                                                                      -
          Buildings                                                                 -
          Equipment                                                                 -
          Vehicles                                                                  -                                Permanent balance sheet accounts
            Buildings - Accum. Depreciation                                                                  -
            Equipment - Accum. Depreciation                                                                  -
            Vehicles - Accum. Depreciation                                                                   -
            Accounts Payable                                                                                 -
             Due to other funds                                                                              -
             Advances from other funds                                                                       -
            Accrued vacation/compensated absences                                                            -
            Claims and judgments                                                                             -
            Net OPEB Liability                                                                               -
            Notes and loans payable                                                                          -
            Fund balance - Beginning balance                                                                 -
            Investment Earnings - General revenue                                                            -
            Charges for service - General government                                                         -
            Direct expenses - General government                                    -                                Unallocated amounts for operating accounts
            Interest and fees                                                       -
            Transfers in                                                                                     -
            Transfers out                                                           -
             General government expenditures                                                                 -
             Public safety expenditures                                                                      -
             Transportation expenditures                                                                     -
             Economic & physical development                                                                 -
             Environmental protection expenditures                                                           -       Allocation of profit or loss
             Human Services                                                                                  -
             Culture and recreation expenditures                                                             -
             Other program 1                                                                                 -
             Other program 2                                                                                 -
             Internal balances *                                                                             -
                                                                                                             -


          Business-type Activities Adjustments:

          Internal balances *                                                       -
             Water and sewer expenses                                                                        -
             Electric expenses                                                                               -       Must be manually posted to business type
             Other enterprise #1                                                                             -       worksheet elsewhere on the website.
             Other enterprise #2                                                                             -
             Fund balance                                                                                    -
                                                                                    -                        -

          * This amount will become the reconciling amount to be entered in Section C, steps 1 & 2 for the next year. In subsequent years the amount for Section
          C becomes cumulative, with year 1's balance added to year 2 etc. over time.




4/12/2011 - City model                                                                                                                                                  37
                                                                                                                                                                  Entry K.1




                                                      GASB 34 - Allocation of Internal Service Funds (Fund #3)
       This worksheet prepares the allocation of internal service funds using the Look-back approach. Internal service funds should generally operate on a
       breakeven basis. Therefore when a profit or loss results from internal transactions, it should be allocated back to the funds involved bases on their
       percentage of participation. If the Internal Service fund had a net loss, the allocation would result in a corresponding increase in expenses. Any
       adjustments arising from these calculations are not intended to be posted to the general ledger. They should be treated as reporting entries for purposes
       of reporting on the government-wide statements and will be posted only to the conversion worksheet. A separate worksheet should be prepared for each
       individual internal service fund. Three worksheets for internal service fund allocation have been provided and mapped to the conversion worksheet. If
       more copies are needed then their resulting entries will require an entry (and mapping) to the conversion worksheet or you may choose to enter the
       entries directly into the yellow "Misc. Entries" column (be careful not to overwrite the data mapped from the other internal service funds.)

       1. Determine the proportionate participation of each function by matching the charge for service with the functional category and determine which activity
          primarily benefits from the internal service fund - governmental or business type in Step A. If business type activity is determined as the primary
          beneficiary, please delete data from this form and enter it in the business type worksheet provided on the website.
       2. Enter the amounts in Step B for the permanent balance sheet accounts for the given internal service fund. These amounts will be posted to the
          governmental activity column as determined in Step A to be the primary beneficiary of the internal service fund's activities. This worksheet will handle
          only those funds determined to benefit governmental activities. In step 2 of Section B enter the amounts that must be excluded from the allocation.
          These amounts come directly from the fund statements. Also, in step 3 enter the change in net assets from the income statement for the fund being
          allocated.
       3. Adjust for the prior year's internal balance in Step C. This adjusts beginning net assets to match the government-wide presentation. k
       4. Section D is the actual allocation of the residual profit or loss computation. These are the amounts that will be included in your reconciliation from the
          fund balance on the fund statements to the government-wide net assets amount.
       5. The entry is automatically generated from all the data provided and mapped to the Reclassifications and Eliminations column of the Conversion
          Worksheet as entry K.1-3. Additional worksheets are provided for other internal service funds and their entries are mapped together such that K.1 + K.2
          + K.3 results in the final K.1-3 entry. Please note that if rounding causes a slight inaccuracy, adjustments can be made.


           k The method used throughout this worksheet differs from the GAAFR by using beginning fund balance rather than ending balance. This method
           generates a calculation for beginning equity on the full accrual basis of accounting.



  A. Enter the dollar amount of revenues paid by each function to the internal service fund. The percentage of total internal charges will be
     automatically calculated. This will provide the information to determine the primary activity type. The activity which is the primary beneficiary will
     be the activity to which balance sheet accounts are recorded later in the entry.


                                          Determination of Proportionate Participation
                                                                                $                          %
          Internal Charges
             Governmental Activities:
                General government                                       $              -                        0.0%
                Public safety                                                           -                        0.0%
                Transportation                                                          -                        0.0%
                Economic & physical development                                         -                        0.0%
                Environmental protection                                                -                        0.0%
                Human Services                                                          -                        0.0%
                Culture and recreation                                                  -                        0.0%
                Other program 1                                                         -                        0.0%
                Other program 2                                                         -                        0.0%

                    Total Governmental Activities                        $              -                        0.0%   j

             Business-type Activities:
               Water and sewer                                           $              -                        0.0%
               Electric                                                                 -                        0.0%
               Other Enterprise 1                                                       -                        0.0%
               Other Enterprise 2                                                       -                        0.0%

                    Total Business-type Activities                       $              -                        0.0%

                         Total Internal Charges                          $              -                        0.0%

          External Charges                                                              -

                         Total Charges for Services                      $              -


                                                                                                    If the predominant activity is business type, please copy your numbers
          The Predominant Activity Type is                                                         into the business type activities worksheet contained in the conversion
          (business or governmental): -- automatic calculation            Business Type       j    worksheet for business type activities and delete them here.




4/12/2011 - City model                                                                                                                                                   38
                                                                                                                                                                                    Entry K.1

 B. Record the trial balance for permanent balance sheet accounts of the internal service fund. Amounts should be ending balances except for net
    assets (fund balance.) It should be recorded at the beginning amount for the fiscal year. In step 2 enter the amounts for those items which should
    be eliminated when allocating the Internal Service fund's net profit or loss. In step 3 enter the amount for "Change in Net Assets" from the
    income statement.
      1. Record permanent balance sheet accounts.                                              Debit                Credit
         Cash & cash equivalents                                                                         -
         Investments                                                                                     -
         Due from other funds                                                                            -
         Advances to other funds                                                                         -
         Inventories                                                                                     -
         Prepaid items                                                                                   -
         Land                                                                                            -
         Buildings                                                                                       -
         Equipment                                                                                       -
         Vehicles                                                                                        -                           From fund Statement of Net Assets at end of year
           Buildings - Accum. Depreciation                                                                                   -
           Equipment - Accum. Depreciation                                                                                   -
           Vehicles - Accum. Depreciation                                                                                    -
           Accounts Payable                                                                                                  -
            Due to other funds                                                                                               -
            Advances from other funds                                                                                        -
           Accrued vacation/Compensated absences                                                                             -
           Claims and judgments                                                                                              -
           Net OPEB Liability                                                                                                -
           Bonds, notes and loans payable                                                                                    -
           Net assets - Beginning balance                                                                                    -       Beginning fund balance from fund statement

      2. Enter unallocated amounts
           Investment earnings                                                                                               -
           Interest expense                                                                              -                           From fund Statement of Revenues, Expenses, and
           Transfers out                                                                                 -                           Changes in Net Assets
           Transfers in                                                                                                      -
           Charges to external customers                                                                                     -       Compute if not separately disclosed
                                                                                                                                     Calculated based on mark-up, e.g. if mark up is 10%
              Expenses for services provided externally                                                  -                           then cost for revenue of $330 is $300.
                                                                                                                                     From fund Statement of Revenues, Expenses, and
      3. Enter the fund's "change in net assets"                                                                                     Changes in Net Assets
           Enter a positive amount for income; enter a negative
           amount for a loss.                                                   -
           Sum of amounts in step 2. - calculated                               -
                                                                                                                                      If positive, an excess charge will be allocated; if
                                                                                                                                     negative, a loss or undercharge will be allocated to the
                 Amount to be allocated - calculated                            -                                            -       functions that used the service.

                                                                                                             -               -       Entry must balance !


 C. Adjust beginning net assets (fund balance) for prior year consolidation of internal service funds. (This amount will be the Internal balance
    amount created from last year's final entry for this fund.)
    This will not be an issue in year 1 of implementation. It will only be required in later years.

      1.
           What was the prior year internal balance entry for internal service funds
           allocation for business type activity? Indicate sign - this amount will be negative if
           business type activities owe (have a balance payable to) government type activities and positive if
           business type activities have a balance receivable from government type activities.
                                                                                                                                        Entries must net to zero.
      2.
           What was the prior year internal balance entry for the internal service fund
           allocation for governmental type activity? Indicate sign - this amount will be negative if
           government activities owe (have a balance payable to) business type activities, and positive if
           government type activities have a balance receivable from business type activities.


 D. Compute the adjustment to the expenses in the functional categories by multiplying the proportionate participation percentage determined in
    Step A by the amount of profit or loss to be allocated as calculated in Step D.
                                                                                         Adjustment to           Adjustment to
                                                                                         Governmental            Business-type
                  …. Automatically computed ….                                             Activities              Activities

           General government                                                                            -
           Public safety                                                                                 -
           Transportation                                                                                -
           Economic & physical development                                                               -
           Environmental protection                                                                      -
           Human Services                                                                                -
           Culture and recreation                                                                        -
           Other program 1                                                                               -
           Other program 2                                                                               -
                                                                                                                                      * In this scenario the governmental activities, as
           Water and sewer                                                                                                   -
                                                                                                                                     primary beneficiary, will have a balance payable to the
           Electric                                                                                                          -       business type activity of $304 which will be posted to
           Other enterprise 1                                                                                                -       the internal balance account to avoid an elimination
           Other enterprise 2                                                                                                -       entry later.
              Total Allocations
4/12/2011 - City model                                                                                   -                   -   *                                                      -       39
                                                                                                                                                                  Entry K.1



  E. Final entry for Conversion worksheet - [Entry K.1] - Posted to the Reclassification & Elimination Column

                                                                            Debit                   Credit

  K.1     Cash & cash equivalents                                                   -
          Investments                                                               -
          Due from other funds                                                      -
          Advances to other funds                                                   -
          Inventories                                                               -
          Prepaid items                                                             -
          Land                                                                      -
          Buildings                                                                 -
          Equipment                                                                 -
          Vehicles                                                                  -                                Permanent balance sheet accounts
            Buildings - Accum. Depreciation                                                                  -
            Equipment - Accum. Depreciation                                                                  -
            Vehicles - Accum. Depreciation                                                                   -
            Accounts Payable                                                                                 -
             Due to other funds                                                                              -
             Advances from other funds                                                                       -
            Accrued vacation/compensated absences                                                            -
            Claims and judgments                                                                             -
            Net OPEB Liability                                                                               -
            Notes and loans payable                                                                          -
            Fund balance - Beginning balance                                                                 -
            Investment Earnings - General revenue                                                            -
            Charges for service - General government                                                         -
            Direct expenses - General government                                    -                                Unallocated amounts for operating accounts
            Interest and fees                                                       -
            Transfers in                                                                                     -
            Transfers out                                                           -
             General government expenditures                                                                 -
             Public safety expenditures                                                                      -
             Transportation expenditures                                                                     -
             Economic & physical development                                                                 -
             Environmental protection expenditures                                                           -       Allocation of profit or loss
             Human Services                                                                                  -
             Culture and recreation expenditures                                                             -
             Other program 1                                                                                 -
             Other program 2                                                                                 -
             Internal balances *                                                                             -
                                                                                                             -


          Business-type Activities Adjustments:

          Internal balances *                                                       -
             Water and sewer expenses                                                                        -
                                                                                                                     Must be manually posted to business type
             Electric expenses                                                                               -       worksheet elsewhere on the website.
             Other enterprise #1                                                                             -
             Other enterprise #2                                                                             -
             Fund balance                                                                                    -
                                                                                    -                        -

          * This amount will become the reconciling amount to be entered in Section C, steps 1 & 2 for the next year. In subsequent years the amount for Section
          C becomes cumulative, with hear 1's balance added to year 2 etc. over time.




4/12/2011 - City model                                                                                                                                                  40
                                                                                                                                                                                    Entry L



                                                        Consolidation, Elimination and Reclassification Entries
                         Interfund balances between governmental funds must be eliminated for purposes of presenting the government-wide Statements. Only those net
                         balances between governmental and business type activities will remain and they will be classified as internal balances. Interfund transfers must be
                         consolidated to arrive at net transfers between governmental and business type activities. Reclassifications to programs or to current versus long-
                         term assets and liabilities may also be necessary. These are the final steps to produce the trial balance that will become the government-wide
                         statements. Entries are posted only to the conversion worksheet.
                         1.   Transfers that occur during the year between governmental funds and between enterprise funds must be eliminated. Only transfers between
                              governmental and enterprise funds remain. Transfers to/from discretely presented component units should now be reported as revenue and
                              expenditures in the appropriate governmental fund and will not need reclassification. The transfers between governmental funds and the
                              internal service funds must be eliminated for any internal service fund that has been consolidated with the governmental activities. After these
                              entries, the remaining transfers should be those between business type activities or fiduciary funds.
                         2.   Interfund receivables and payables between the governmental funds must be eliminated so as not to overstate the assets and liabilities for
                              governmental activities. There are four accounts which are affected, "due to/from" and "advances to/from." Interfund receivables and payables
                              to fiduciary funds are treated as external parties at the government-wide level. They are best reported in a separate account entitled due
                              to/from fiduciary funds on the funds' Balance Sheet. If receivables/payables from fiduciary funds have not already been recorded on a separate
                              line, complete the questions in Section D.
                         3.   The balances remaining after eliminating the activity between governmental funds should be the activity between governmental activities and
                              business-type activities. These reciprocal balances between activity types must be eliminated and reclassified as internal balances. The
                              numbers for the entry will be pulled from the Conversion worksheet by going to the appropriate account and looking for the balance reported in
                              the Statement of Net Assets' column. Once the entries in Section C and D have posted to the worksheet, all of these accounts should have a
                              zero balance and an "internal balance" account should remain with the net difference.
                         4.   In order to present the net cost per function in the Statement of Activities, any "doubling up" of expenditures or revenues must be eliminated.
                              This occurs when administrative activities such as printing, data processing, accounting staff, etc. are accounted for in function/fund #1 and
                              charged out or allocated to other functions or funds where the payment for the service is treated as revenue in function #1. In this scenario, the
                              expenditures are presented twice and the revenues are overstated for governmental activities. In this case, the costs should be presented in
                              the functions that were charged and the revenue and expense in function/fund #1 must be eliminated. IF THE PAYMENTS FROM THE
                              USERS ARE TREATED AS A REIMBURSEMENT (the expenditure in function/fund #1 is reduced by payment from the user function),
                              NO ADJUSTMENT IS NECESSARY. The entry created will reduce revenues and expenses in function/fund #1 for the expenditure amount
                              allocated to other functions. Profits or losses are presumed to be immaterial in this entry. If material, any profit or loss must be allocated back
                              to the functions using the service by a manual entry to the worksheet.
                         5.   The Statement of Net Assets should be presented in order of liquidity and the current portion of long-term liabilities such as bonds and notes
                              payable, compensated liabilities, and other long-term liabilities must be identified separately. For compensated absences, this will depend on
                              the assumption of FIFO or LIFO as the method for computing leave to be taken. For the FIFO method, typically the estimate will be based on
                              expected leave or average leave taken over the last several years. Indicate the amount to be paid from current resources in Section F below. If
                              the LIFO method is used, the assumption is made that typically employees take leave as it is earned and that there is no current portion. If the
                              portion payable and due within one year for other liability accounts has been handled elsewhere, the question can be left blank.
                         6.   Worksheets K.1-3 only handled internal service funds if the governmental activities were the primary users. For those internal service funds
                              where the business type activity was the primary user and the allocation entries were created in the business type conversion worksheet,
                              those entries applying to governmental activities must be entered in Section H below.
                         7.   Assumptions were made in journal entry F.1 (from Tab F.Other Capital Asset Entries ) that all sales/disposals of capital assets resulted in
                              gains to miscellaneous revenue. If however a material loss occurred, it should be reclassified as a General Government expense. (Question
                              #131 from Implementation Guide 1.) For material losses, complete the question in section I. below. Indicate the amount of the loss that
                              qualifies as a General Government expense and any material portion that meets the criteria for a special expense.
                         8.   In addition to the elimination, consolidation and reclassification entries made in this worksheet, it may be necessary to record manual entries in
                              the "Other Miscellaneous Entries As Needed" column on the Conversion worksheet. Any such entries would be conversion or reclassification
                              entries that are unique for your unit which have not been previously handled throughout the workbook. This is especially true of any unusual
                              special or extraordinary revenue or expense items. The special and extraordinary item accounts are at the end of the trial balance in the
                              Conversion Worksheet. Remember that any manual entries which are entered to the "Other Miscellaneous Entries As Needed" columns must
                              have balanced debits and credits.
                         9.   Fund balance must be reclassified to the net asset categories required for the presentation on the government-wide statements. Data for this
                              entry is entered manually to avoid circular logic. It should be one of the last steps performed. Worksheet M has been presented to help you
                              calculate the correct amounts to enter into Section J. below.




                   A.    Consolidate transfers to arrive at net transfers to business type activities.


                         1.   What was the amount of transfers between governmental funds? The amount transferred in and out will be the same.
                              (Includes General fund, special revenue funds, capital projects, debt service, and permanent funds) .                                      212,704

                         2.   What was the net amount of transfers between the governmental funds and the internal service funds whose
                              predominant user is governmental?                                                                                                              -




                   B.    Eliminate interfund balances for receivables and payables between governmental funds.


                         1.   What is the amount of interfund receivables and payables between governmental funds in the "due to/from account"?
                              This is the amount only between governmental funds. Do not include any due to/due froms between governmental and
                              enterprise funds.                                                                                                                              -

                         2.   What is the amount of interfund receivables and payables between governmental funds in the "advances to/from"
                              account? This is the amount only between governmental funds. Do not include any advances to/from between
                              governmental and enterprise funds.                                                                                                             -




4/12/2011 - City model                                                                                                                                                                   41
                                                                                                                                                                                                        Entry L

                         Reclassify inter-activity receivables and payables to internal balances (transactions between government type activities and business type
                         activities.) Note: Due to/from Fiduciary funds are not included here. It is best to separately classify them at the fund level but if that was not done, then complete
                   C.    Section D below.


                         1.   What is the amount of receivables -"due from other funds" due to the governmental activities from business type
                              activities? Go to the conversion worksheet and look at the balance in the Statement of Net Assets column for this account. Enter that amount
                              (less any portion related to fiduciary funds) in the box to the right.                                                                                            2,600
                         2.   What is the amount of payables -"due to other funds" due to the business type activities from the governmental
                              activities? Follow the directions in step 1 above - entering the number from the Conversion worksheet - exclude fiduciary funds portion.                          2,200
                         3.   What is the amount of receivables-"Advances to other funds" due to the governmental activities from business type
                              activities? Follow the directions in step 1 above - entering the number from the Conversion worksheet - exclude fiduciary funds portion.                             -
                         4.   What is the amount of payables -"Advances from other funds" due to the business type activities from the
                              governmental activities? Follow the directions in step 1 above - entering the number from the Conversion worksheet - exclude fiduciary funds                         -




                   D.    Reclassify receivables and payables to the fiduciary funds from governmental activities.


                         1.   What is the amount in "Due from other funds" that is due from fiduciary funds ?                                                                                      -

                         2.   What is the amount in "Due to other funds" that is due to fiduciary funds?                                                                                           -

                              Leave this section blank if a separate account(s) entitled "Due to/from fiduciary funds" has been used at the fund level.




                   E.    Eliminate the "doubling up effect" that may occur with inter-function activities when expenditures have been recorded twice.

                         1.   What is the amount of expenditures incurred and revenues collected that is truly a cost of the
                              user function, e.g. services such as data processing, printing, accounting, garage, etc. For this
                              entry to be required, revenue has been recorded in the function providing the service. Indicate
                              the amount by function below. Include charges to and revenues collected from business type
                              activities. Assumption is that expenditures and revenue are equal and there is no material profit or loss to be
                              allocated. If reimbursement method was used, leave this section blank .

                                                                                                                  General government                                                               -
                                                                                                                  Transportation                                                                   -

                                                                                                                                                                                                   -




                   F.    Classify current portion of long-term liabilities. (Leave the cell blank if account does not apply or classification has been handled previously.)

                         1.   What is the amount of claims payable that will be due and payable within one year?                                                                                   -
                         2.   What is the amount of installment purchases/COPs payable that will be due and payable within one year?                                                           10,000
                         3.   What is the amount of Bonds payable that will be due and payable within one year?                                                                                10,000
                         4.   What is the amount of notes payable that will be due and payable within one year?                                                                                    -
                         5.   What is the amount of capital leases payable that will be due and payable within one year?                                                                        8,434
                         6.   What is the amount of compensated absences that will be due and payable within one year?                              (Use of the FIFO assumption                37,750
                              will be based on average leave taken over the years. Typically, use of the LIFO method will not have a current portion.)

                         7.   What is the amount of other long-term debt #1 that will be due and payable within one year?                                                                          -
                         8.   What is the amount of other long-term debt #2 that will be due and payable within one year?                                                                          -




                   G.    Reclassify any interest expense or investment income that should be related to a specific program.

                         1.
                              Indicate the amount by program/function for interest expense or investment earnings that should
                              be included with program cost or revenue due to being integral to the operation or required by a
                              third party restriction. If the investment earnings were classified as anything other than general
                              revenues in worksheet A no additional entry to adjust revenue is necessary on this worksheet.
                                                                                                                                                                         Investment Earnings
                                                                                                                        Interest Expense                      Operating              Capital related
                                                                                        General government                           -                                      -                      -
                                                                                        Public Safety                                -                                      -                      -
                                                                                        Transportation                               -                                      -                      -
                                                                                        Economic & physical development              -                                      -                      -
                                                                                        Environmental protection                     -                                      -                      -
                                                                                        Human services                               -                                      -                      -
                                                                                        Cultural and recreation                      -                                      -                      -
                                                                                        Other program 1                              -                                      -                      -
                                                                                        Other program 2                              -                                      -                      -
                                                                                                                                     -                                      -                      -




4/12/2011 - City model                                                                                                                                                                                       42
                                                                                                                                                                                                Entry L



                   H.    Record any entries from Internal Service Fund Allocation where the Business type activity was dominant.

                         1.   Enter the amounts as positive numbers in the debit or credit columns for the internal balance and
                              the functions noted below. This entry was generated in the internal service fund allocation
                              worksheet for business type activities elsewhere on the website. The entry must balance. If
                              multiple internal service funds exist with dominant user of business type, please add the entries
                              together to arrive at the net debit or credit.                                                                   Debit                       Credit
                                                                                      Internal balance                                                    -                             -
                                                                                      General government                                                  -                             -
                                                                                      Public Safety                                                       -                             -
                                                                                      Transportation                                                      -                             -
                                                                                      Economic & physical development                                     -                             -
                                                                                      Environmental protection                                            -                             -
                                                                                      Human services                                                      -                             -
                                                                                      Cultural and recreation                                             -                             -
                                                                                      Other program 1                                                     -                             -
                                                                                      Other program 2                                                     -                             -
                                                                                      Net assets - unrestricted                                           -                             -
                                                                                                                                                          -                             -


                   I.    Reclassify material losses in the sale of capital assets. (Entry initially generated as F.1 from Tab F.Other Cap Asset Entries)

                         1.   What is the "material" amount of loss on disposal that should be reclassified as an expense to
                              General Government.(Enter as a positive number. Miscellaneous revenue will be adjusted in this entry.)

                         2.   What is the "material" amount of loss on disposal that meets the criteria to be reported as a
                              special expense item. (Enter as a positive number - Miscellaneous revenue will be adjusted in this entry.)



                   J.    Reclassify fund balance to net assets.            (See worksheet M for assistance with computation of this entry.)


                         Invested in capital assets net of related debt:
                         1. What are net capital assets (capital assets less accumulated depreciation.)                                          4,376,858

                         2.   What is debt related to capital assets excluding unexpended debt proceeds?                                          284,377

                              Invested in capital assets net of related debt:                                                                                                  4,092,481

                         Restricted for:
                            Capital projects                                                                                                       10,000
                            Debt Service                                                                                                              -
                            Transportation                                                                                                          4,084
                            Public Safety                                                                                                           5,415
                            Economic Development                                                                                                      -
                            Cultural and Recreation                                                                                                25,056
                            Other restrictions #1                                                                                                     -
                            Other restrictions #2                                                                                                     -
                            Other restrictions #3                                                                                                     -                            44,555

                         Unrestricted:                                                                                                            279,631


                              Proof Totals:        Total net assets ………….. (from entries above)                                                  4,416,667
                                                   Full accrual Beginning net equity + change in net equity - (from conversion worksheet)        4,416,667



                   K.    Final Entry for Conversion Worksheet [Entry L.1 to L.9]

                              From Section
                                 Above                                                                                           Debit         Credit
                   L.1              A        OFS - Transfers in                                                                    212,704
                                                  OFU - Transfers out                                                                             212,704
                   L.2              B        Due to other funds                                                                            -                    Eliminates intra-governmental
                                             Advances from other funds                                                                     -                     activity
                                                  Due from other funds                                                                                    -
                                                  Advances to other funds                                                                                 -
                   L.3             C         Advances from other funds                                                                   -
                                             Due to other funds                                                                        2,200                    Closes out inter-activity
                                             Internal balances                                                                           400              -     accounts to internal
                                                   Advances to other funds                                                                                -     balance account
                                                   Due from other funds                                                                                 2,600
                   L.4             D         Due from fiduciary funds                                                                      -
                                                  Due from other funds                                                                                    -     Reclasses external
                                             Due to other funds                                                                            -                    receivables & payables
                                                  Due to fiduciary funds                                                                                  -
                   L.5              E        General government - charge for service                                                       -
                                             Transportation - charge for service                                                           -                    Eliminates doubling up effect
                                                  General government                                                                                      -     of interfunction activity
                                                  Transportation                                                                                          -




4/12/2011 - City model                                                                                                                                                                               43
                                                                                                                                                                    Entry L
                   L.6          F   Claims payable                                                                -
                                    COPs payable                                                               10,000
                                    Bonds payable                                                              10,000
                                    Notes payable                                                                 -
                                    Capital leases                                                              8,434
                                    Compensated absences                                                       37,750
                                    Other long-term liability #1                                                  -
                                    Other long-term liability #2                                                  -                  Classify for liquidity
                                         Claims payable - current                                                             -      presentation
                                         COPs payable - current                                                            10,000
                                         Bonds payable - current                                                           10,000
                                         Notes payable - current                                                              -
                                         Capital leases - current                                                           8,434
                                         Compensated absences - current                                                    37,750
                                         Other long-term liability #1 - current                                               -
                                         Other long-term liability #2 - current                                               -
                   L.7          G   General government                                                             -
                                    Public Safety                                                                  -
                                    Transportation                                                                 -
                                    Economic & physical development                                                -
                                    Environmental protection                                                       -
                                    Human services                                                                 -
                                    Cultural and recreation                                                        -
                                    Other program 1                                                                -
                                    Other program 2                                                                -
                                          Interest expense                                                                     -
                                    Investment earnings                                                            -
                                          General government -operating grants & contributions                                 -
                                          Public Safety-operating grants & contributions                                       -
                                          Transportation-operating grants & contributions                                      -
                                          Economic & physical development-operating grts & contrib.                            -     Reclass program revenue
                                          Environmental protection-operating grants & contributions                            -     not adjusted previously
                                          Human services-operating grants & contributions                                      -
                                          Cultural and recreation-operating grants & contributions                             -
                                          Other program 1-operating grants & contributions                                     -
                                          Other program 2-operating grants & contributions                                     -
                                          General government-capital grants & contributions                                    -
                                          Public Safety-capital grants & contributions                                         -
                                          Transportation-capital grants & contributions                                        -
                                          Economic & physical development-capital grts & cont.                                 -
                                          Environmental protection-capital grants & contributions                              -
                                          Human services-capital grants & contributions                                        -
                                          Cultural and recreation-capital grants & contributions                               -
                                          Other program 1-capital grants & contributions                                       -
                                          Other program 2-capital grants & contributions                                       -
                         L.8    H   Internal balance                                                               -           -
                                    General government                                                             -           -
                                    Public Safety                                                                  -           -
                                    Transportation                                                                 -           -
                                    Economic & physical development                                                -           -     Record internal service
                                    Environmental protection                                                       -           -     fund allocation where
                                    Human services                                                                 -           -     business type is dominant
                                    Cultural and recreation                                                        -           -
                                    Other program 1                                                                -           -
                                    Other program 2                                                                -           -
                                    Fund balance                                                                   -           -
                                                                                                                                     Reclassifies material losses
                         L.10   I   General Government (expense)                                                   -                 on sale of cap. assets as
                                    Special item - expense (loss on sale or disposal of assets)                    -                 expense of Gen. Govt. or
                                         Miscellaneous revenue (Adjusts journal entry F.1 created earlier)                     -     records as special exp item

                         L.9    J   Fund balance                                                             4,416,667
                                         Invested in capital assets net of related debt                                  4,092,481
                                         Restricted for capital projects                                                    10,000
                                         Restricted for Debt Service                                                           -
                                         Restricted for Transportation                                                       4,084
                                         Restricted for Public Safety                                                        5,415   Classifies net assets and
                                         Restricted for Economic Development                                                   -     maps to the Statement of
                                         Restricted for Cultural and Recreation                                             25,056   Net Assets Column
                                         Restricted for Other restrictions #1                                                  -
                                         Restricted for Other restrictions #2                                                  -
                                         Restricted for Other restrictions #3                                                  -
                                         Unrestricted                                                                      279,631
                                                                                                             4,698,155   4,698,155




4/12/2011 - City model                                                                                                                                                   44
                                                                                                                                                                      M - Supporting Schedule




                                          Calculation of Net Assets-Governmental Activities
           Fund balance must be reclassified to a Net Assets presentation for the government-wide statements. This worksheet will assist you in the
           calculation of the numbers that must be entered manually into worksheet L. Worksheet L creates the entry that posts to the conversion worksheet to
           reclassify net asset. It was not automatically generated in order to avoid circular logic. This step will be one of the last performed in finalizing data in
           the conversion worksheet.
           The information collected in this worksheet and presented in the gold colored cells will provide the specific information that must be input into
           Worksheet L. Section J. Entering these final numbers into worksheet L should complete the conversion process.

      A.                                                 Restricted Assets - Data From Fund Statements
           Restricted assets are calculated in total for the government-wide activities. However, the fund statements are needed to begin this calculation. In the
           yellow cells below, enter the indicated totals by function (which may require some aggregation of funds). For example, the functional expenditure for
           the Wireless E911 Special Revenue Fund is public safety, so the restricted assets for that fund are calculated entirely on that line. The transportation
           function is Powell Bill funds that are a part of the General Fund. Restricted assets are those restricted by an external source such as a grantor agency
           or a creditor, or restricted by board action in conjunction with separate legislation, such as the levying of an occupancy tax. Board action by itself is not
           enough to restrict an asset. Once the determination is made that a restricted asset exists, then the total amount to be restricted must be calculated to
           include any receivables of that asset less any payables or unearned income that relate to that asset. All numbers are entered as positive numbers.


                                                                        +              +                    -                    -             Net
                                                                   Unexpended                                              Unearned         Restricted
           Governmental Activities By Function                        Cash    Receivables             Payables              Income           Assets
           General government                                                                                                                       -
           Public safety                                                  8,000        14,415                17,000                               5,415     j
           Transportation                                                 4,084                                                                   4,084     k
           Economic and physical development                                            5,000                   5,000                               -       l
           Environmental Protection                                                                                                                 -
           Human services                                                                                                                           -
           Cultural and recreation                                       24,681            375                                                   25,056     n
           Other program 1                                                                                                                          -
           Other program 2                                                                                                                          -
           Debt service                                                                                                                             -
           Capital outlay                                                10,000                                                                  10,000     m

               Total                                                     46,765        19,790                22,000                   -          44,555

                                                               j E 911 Fund
                                                               k Powell Bill moneys reserved in General Fund
                                                               l Grant Projects Fund
                                                               m Recreation Project in Capital Project Funds; unexpended grant revenue
                                                                 (assumes $13,400 of $23,400 in cash is unexpended debt proceeds)
                                                               n Cash and receivables in Cemetery Care Permanent Fund


      B.                                                            Capital Assets Net of Related Debt

           Governmental Activities
                                                                   Gross Capital   Accum.            Net Capital
           Capital assets, all governmental activities                Assets     Depreciation          Assets
            Land                                                       176,770
            Other non-depreciable assets
            Buildings                                                 2,603,581     1,104,742
            Improvements other than buildings                           599,494       436,461
            Equipment                                                   842,666       545,803                              Capital asset data pulled from the St. of Net Assets Column
            Vehicles and other motorized equipment                      479,520       333,126                              in Conversion Worksheet
            Infrastructure                                            2,457,863     1,055,904
            Asset class 1                                                                 -
            Asset class 2                                                                 -
            Construction in progress                                    693,000
                      Net Capital Assets                              7,852,894     3,476,036            4,376,858

           Capital debt calculation
            Total debt, gross                                          284,377
           Less:
             Debt for assets to which the city does
             not hold title                                                 -         Enter the amount of debt related to capital assets.
             Other debt not issued for capital                              -         Enter as a positive number.
             Unexpended proceeds                                            -
             Unamortized assets related to capital debt                     -
           Add:
             Unamortized liabilities related to capital debt               -
           Total capital debt                                          284,377

               Capital assets net of related debt                     4,092,481




4/12/2011 - City model                                                                                                                                                                   45
                                                                                                  M - Supporting Schedule




                                        Calculation of Net Assets-Governmental Activities

      C.                                                Calculation of Net Assets

           Total Net Assets                           4,416,667   from the Conversion worksheet

           Less Restricted Net Assets                   44,555    from Section A above

           Less Capital Assets Net of Related Debt    4,092,481   from Section B above

           Unrestricted Net Assets                     279,631




4/12/2011 - City model                                                                                               46

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:12
posted:4/12/2011
language:English
pages:46