Alpine School District Template for GASB 34

The Alpine School District in American Fork, Utah, and Squire & Co., CPAs, have prepared a Microsoft Excel template to help school districts prepare financial statements for the first time under the Government Accounting Standards Board’s Statement No. 34 (GASB 34).
To find a download of a copy of the template for 2005 statements, click here for the CAFR page on the Alpine School District Web site:
www.alpine.k12.ut.us/depts/accounting/cafr/cafrindex.htmlThis template allows users to enter their own fund statements and post the conversion entries; then the government-wide statements are created by formula along with the reconciliation statements.
The adjusting journal entries are organized as follows:
1. Identify beginning balances of governmental full-accrual accounts
2. Convert data in the governmental funds from the modified-accrual basis of accounting to the full-accrual basis of accounting
3. Incorporate data from internal service funds into governmental activities
4. Eliminate certain interfund balances and activities
The template has been created with conditional formatting built into proofs on the Excel "input tab" to alert the user in red for out-of-balance conditions throughout the document. Formulas that show the source of data, which allows the user to trace all amounts used to create the government-wide statements, are listed in blue.
The template also allows the user to enter the name of their district, year-end date, and ECT on the input, which will place the name of their own district throughout the document. The creators of this template believe that it could save users two weeks of development time.
Click here for additional sample CAFRS and information on ASBO's Certificate of Excellence in Financial Reporting program.