Statement Net Assets-Worksheet - Excel

Document Sample
Statement Net Assets-Worksheet - Excel Powered By Docstoc
					                                                           ___________________ COUNTY
                                                      STATEMENT OF NET ASSETS WORKSHEET

                                                                                                                 Total
                                                        Totals                                                Government          How Reported on Government
                                                        Fund             Adjustments                             Wide                Wide Financial Statements
                                                      Statement      Debit      ref.   Credit          ref.    Statement                     (suggested)

ASSETS:
Current Assets:
     Cash and Cash Equivalents                                                                                         0.00   Cash and Cash Equivalents

151 Investments                                                                                                        0.00   Investments

110 Taxes Receivable--Delinquent                                                                                       0.00   Accounts Receivable

114 Judgments Receivable                                                                                               0.00   Accounts Receivable

117 Accounts Receivable, Net                                                                                           0.00   Accounts Receivable

121 Special Assessments Receivable--Current                                                                            0.00   Accounts Receivable

122 Special Assessments Receivable--Delinquent                                                                         0.00   Accounts Receivable

123 Special Assessments Receivable--Deferred                                                                           0.00   Accounts Receivable

125 Interest Receivable--Special Assessments                                                                           0.00   Accounts Receivable

126 Governmental Unit's Share of Assessment
     Improvement Costs                                                                                                 0.00   Accounts Receivable

128 Notes Receivable                                                                                                   0.00   Accounts Receivable

129 Due from Component Units                                                                                           0.00   Due From Component Units

131 Due from _____________________ Fund                                                                                0.00   Internal Balances

132 Due from _____________________ Government                                                                          0.00   Accounts Receivable

135 Interest Receivable                                                                                                0.00   Accounts Receivable

137 Dividends Receivable                                                                                               0.00   Accounts Receivable

141 Inventory of Supplies                                                                                              0.00   Inventories

142 Inventory of Stores Purchased for Resale                                                                           0.00   Inventories

154 Deposits                                                                                                           0.00   Other Assets

155 Prepaid Expenses                                                                                                   0.00   Other Assets

157 Unamortized Discount on Bonds sold                                                                                 0.00   Other Assets

186 Advance to ____________ Fund                                                                                       0.00   Internal Balances

107.1 Restricted Cash and Cash Equivalents                                                                             0.00   Restricted Cash

107.2 Restricted Investments                                                                                           0.00   Restricted Investments



     Capital Assets:
       Land, Improvements and Const. in Progress                                                                       0.00   Land, Improvements, CIP

       Other Captial Assets, Net of Depreciation                                                                       0.00


                                                                                                                              Other Capital Assets, Net of Depreciation

TOTAL ASSETS                                                  0.00         0.00                 0.00                   0.00   Total Assets



LIABILITIES AND FUND BALANCES/NET ASSETS:
Liabilities:
201 Claims Payable                                                                                                     0.00   Accounts Payable

202 Accounts Payable                                                                                                   0.00   Accounts Payable

203 Judgments Payable                                                                                                  0.00   Other Current Liabilities

204 Annuities Payable                                                                                                  0.00   Other Current Liabilities

205 Notes Payable                                                                                                      0.00   Other Current Liabilities

206 Contracts Payable                                                                                                  0.00   Other Current Liabilities

207 Contracts Payable--Retained Percentage                                                                             0.00   Other Current Liabilities

208 Due to ______________________ Fund                                                                                 0.00   Internal Balances

209 Due to _________________ Government                                                                                0.00   Other Current Liabilities

210 Amounts Held for Others                                                                                            0.00   Other Current Liabilities

211 Matured Bonds Payable                                                                                              0.00   Other Current Liabilities

212 Matured Interest Payable                                                                                           0.00   Other Current Liabilities

215 Accrued Interest Payable                                                                                           0.00   Due Within One Year

216 Accrued Wages Payable                                                                                              0.00   Other Current Liabilities

217 Payroll Withholding Payable                                                                                        0.00   Other Current Liabilities

218 Amount Held for Special Assessment Debt Service                                                                    0.00   Other Current Liabilities

220 Customer Deposits                                                                                                  0.00   Other Current Liabilities

221 Due to Fiscal Agents                                                                                               0.00   Other Current Liabilities

222 Special Assessments Collected in Advance                                                                           0.00   Other Current Liabilities

223 Revenues Collected in Advance                                                                                      0.00   Other Current Liabilities

224 Deferred Revenue                                                                                                   0.00   Deferred Revenue

225 Registered Warrants                                                                                                0.00   Other Current Liabilities

226 Bonds Payable--Current                                                                                             0.00   Other Current Liabilities

227 Due to Component Unit                                                                                              0.00   Other Current Liabilities

228 Compensated Absences Payable -- Current                                                                            0.00   Due Within One Year

242 Advance from ___________________ Fund                                                                              0.00   Internal Balances
                                                                      1
                                                                   ___________________ COUNTY
                                                              STATEMENT OF NET ASSETS WORKSHEET

                                                                                                                         Total
                                                                Totals                                                Government          How Reported on Government
                                                                Fund             Adjustments                             Wide               Wide Financial Statements
                                                              Statement      Debit      ref.   Credit          ref.    Statement                    (suggested)

      Noncurrent Liabilities:
        Due Within One Year                                                                                                    0.00   Due Within One Year




        Due in More than One Year                                                                                              0.00   Due in More than One Year




Total Liabilities                                                     0.00         0.00                 0.00                   0.00


Fund Balances:
 271 Reserved For:
  271.01 Encumbrance                                                                                                           0.00   Net Assets-Unrestricted

  271.02 Inventory                                                                                                             0.00   Net Assets-Unrestricted

  271.03 Advance to _________ Fund                                                                                             0.00   Net Assets-Unrestricted

  271.04 Debt Service                                                                                                          0.00   Net Assets-Restricted for Debt Service

  271.17 Snow Removal                                                                                                          0.00   Net Assets-Restricted for Road

  271.18 Highway and Bridge Reserve                                                                                            0.00   Net Assets-Restricted for Road

  271.19 Secondary Road                                                                                                        0.00   Net Assets-Restricted for Road

  271.20 Permanently Reserved Purposes                                                                                         0.00   Net Assets for Permanently Restricted Purposes

  271.99 Other Purposes                                                                                                        0.00   Net Assets-Restricted for Other Purposes



 272 Unreserved Fund Balances:
  272.01 Designated for Next Year's Appropriation                                                                              0.00   Net Assets

              Reported in Non-Major:
               Special Revenue Funds                                                                                           0.00   Net Assets

               Debt Service Funds                                                                                              0.00   Net Assets

               Capital Project Funds                                                                                           0.00   Net Assets

               Permanent Funds                                                                                                 0.00   Net Assets

  272.03 Designated for Capital Outlay Accumulations                                                                           0.00   Net Assets

              Reported in Non-Major:
               Special Revenue Funds                                                                                           0.00   Net Assets

               Debt Service Funds                                                                                              0.00   Net Assets

               Capital Project Funds                                                                                           0.00   Net Assets

               Permanent Funds                                                                                                 0.00   Net Assets

  272.02 Designated for Other Purposes                                                                                         0.00   Net Assets

              Reported in Non-Major:
               Special Revenue Funds                                                                                           0.00   Net Assets

               Debt Service Funds                                                                                              0.00   Net Assets

               Capital Project Funds                                                                                           0.00   Net Assets

               Permanent Funds                                                                                                 0.00   Net Assets

  272.09 Undesignated                                                                                                          0.00   Net Assets

              Reported in Non-Major:
               Special Revenue Funds                                                                                           0.00   Net Assets

               Debt Service Funds                                                                                              0.00   Net Assets

               Capital Project Funds                                                                                           0.00   Net Assets

               Permanent Funds                                                                                                 0.00   Net Assets



         Net Assets:
            Invested in Capital Assets, Net of Related Debt                                                                    0.00   Net Assets-Invested in Capital Assets




            Restricted for:
              Road and Bridge Purposes                                                                                         0.00   Net Assets-Restricted for Road

              Capital Projects                                                                                                 0.00   Net Assets-Restricted for Capital Projects

              Debt Service                                                                                                     0.00   Net Assets-Restricted for Debt Service

              Permanently Restricted Purposes                                                                                  0.00   Net Assets for Permanently Restricted Purposes

              Other Purposes                                                                                                   0.00   Net Assets-Restricted for Other Purposes

           Unrestricted (Deficit)                                                                                              0.00


                                                                                                                                      Net Assets-Unrestricted

Total Fund Balances/Net Assets                                        0.00         0.00                 0.00                   0.00


TOTAL LIABILITIES AND FUND BALANCES/NET ASSETS                        0.00         0.00                 0.00                   0.00   Total Net Assets



                                                                              2