Gaap Cash Clearing Accounts

Document Sample
Gaap Cash Clearing Accounts Powered By Docstoc
					                                                                                        Exhi bit 22




                     California State University, _____________
              Financial Statement Audit - Prepared by Client (PBC) List
                                    June 30, 2005

Note: This is a preliminary PBC list. Additional items may be requested as the audit progresses.
Items on the PBC list must be centrally accumulated in a separate set of binders to be provided to
the audit team on the first day of fieldwork. All schedules in the binders should be labeled and
cross-references to the PBC list (for example: “General #1”).

GENERAL
1. Completed and approved Reporting Package (all sections)

2. Completed troubleshooting checklist.
3. GAAP conversion template (statement of net assets and statement of revenues, expenses, and
   changes in net assets) for each net asset category with all adjustments recorded, including a
   prior year and change column.. *
4. Copy of each GAAP journal entry recorded with attached supporting documentation.
5. If restatement adjustments have been made to beginning net assets, supporting source
   documentation for all adjustments. Additionally, all restatement adjustments must be listed
   in Note 15 of the Reporting Package.
6.

7. Cash flow worksheet which contains supporting calculations and related supporting source
    documentation for each line item on the statement of cash flows.
8. Completed Management’s Discussion and Analysis (MD&A) checklist.
9. Supporting documentation for all footnote information contained in the Reporting Package.
10. Supporting calculations and source documentation for all amounts/percentages disclosed in
    the MD&A.

11. Completed draft financial statements, including MD&A and all footnotes. MD&A must be
    reviewed and approved by management prior to providing to KPMG (refer to Chapter 7 of
    the GAAP Manual).
12. PeopleSoft 8.4 trial balance reports (refer to GAAP Workshop Chapter 4 presentation for list
    of standard reports currently available in PeopleSoft 8.4).
13. SAM 7 Report for each net asset category.
14. SAM 6C Report
15. SAM 99 Report
16. Organizational charts
17. Most recent FISMA report


CASH
1. List of cash accounts maintained by the campus with 6/30/05 balances (Cash Leadsheet). *
2. June 2005 bank reconcilations including a listing of outstanding checks, listing of deposits in
   transit, and supporting documentation for other significant reconciling items.
3. June and July 2005 bank statements (Sam 11 reports).
   INVESTMENTS
   1. Investments leadsheet that includes the type of investment, market value, cost, and
      calculation of unrealized gain or loss as of June 30, 2005. *
   2. Copies of June 2005 investment statements for all Met West accounts.
   3. June 2005 investment statements or other supporting documentation for any other
      investments not managed by MetWest (CDs, etc.).
   4. Schedule of investment purchases (additions) and sales (withdrawals) with supporting
      documentation (the information is utilized for the statement of cash flows).
   5. Copy of the fund balance clearing account schedule at 6/30/05 sent from the Chancellor’s
      Office.
   6. Detail of investment income and accrued interest at 6/30/05.

   ACCOUNTS RECEIVABLE
   1. List of all accounts receivables (current and noncurrent) by net asset category with 6/30/05
       and 6/30/04 gross and net balances, including related allowance balance for each type of
       receivable (Accounts Receivable Analysis Schedule). Balances must agree to receivables in
       each net asset category on the conversion template. *
   2. Rollforward schedule of state appropriations receivable. This schedule should include the
       following: total appropriation granted by the State in the current year, the amount of the
       previous year’s appropriation that was unspent, the amount expended and waiting for
       reimbursement and the amounts still remaining that can be carried forward and spent in the
       next year (receivable).
   3. Copy of FY 2004-2005 state appropriations schedule by campus (GAAP appropriations
       support summary) sent from the Chancellor’s Office.
   4. Listing of all students and vendors with outstanding account balances and their respective
       balances at 6/30/05 (Aging reports). The ending balance on this report must tie to amount
       presented on the Accounts Receivable Analysis Schedule discussed above. If amounts do not
       tie, a reconciliation must be prepared with explanations of differences. (Note: This detail
       report should only include debits made to student accounts if your conversion procedures
       map the debits to a receivable and the credits to deferred revenue).
   5. Detail of accounts receivable from auxiliary organizations. *
   6. Detail of accounts receivable from the Chancellor’s Office.
   7. Detail of other accounts receivables. *
   8. Policy for establishing allowance for doubtful accounts (reserves) and writing off
       uncollectible receivables. *
   9. Allowance for doubtful accounts leadsheet (should include allowance balance for each type
       of receivable (students, vendors, other, etc.). *
   10. Calculation and analysis of the 6/03/05 allowances established for each type of receivable
       (students, vendors, other, etc.).

   STUDENT LOANS RECEIVABLE
   1. List of student loans receivables with 6/30/05 and 6/30/ gross and net balances, including
      related allowance balance for each type of loan receivable.
   2. Calculation and analysis of the 6/30/05 allowance for uncollectible student loans receivable
      (Perkins/Nursing loans).




Last revised May 19, 2005                    Page 2
   3. June 2005 AMS Report with outstanding Perkins/Nursing loans receivable balances. The
      balances on this report must tie to the 6/30/05 student loans receivable balances in the
      schedule above.

   PLEDGES RECEIVABLE
   1.   Detail of pledges receivable at 6/30/05.
   2.   Supporting documentation for any new pledges received during the fiscal year.
   3.   Calculation of net present value of pledges receivable.
   4.   Calculation and analysis of the 6/30/05 allowance for uncollectible pledges receivable.

   PREPAID EXPENSES AND OTHER ASSETS (CURRENT)
   1. Detail of prepaid expenses at 6/30/05. *
   2. Detail of other assets at 6/30/05.

   CAPITAL ASSETS
   1. Rollforward schedule of capital assets, including accumulated depreciation, that includes
      beginning balances, additions, deletions, transfers, and the current year balances. Beginning
      balances must agree directly to the prior year Reporting Package submitted to the
      Chancellor’s Office, unless there are restatement adjustments as listed in Note 15 of the
      current year Reporting Package. *
   2. A detailed listing of all additions and disposals of equipment during the year. *
   3. Calculation performed to determine library book valuations.
   4. Detail listing of vendor payments for library books.
   5. Detail of all expenditures for capital assets.
   6. Copies of all GAAP journal entries with supporting documentation made to record equipment
      purchased and buildings and construction in progress allocated from the Chancellor’s Office.
   7. Copy of the rollforward schedule of CWIP allocated to your campus from the Chancellor’s
      Office.
   8. Schedule of capital expenditures spent by net asset category.
   9. Detail of all capital assets gifted during the year.

   OTHER ASSETS (NONCURRENT)
   1. Detail of other assets at 6/30/05.
   2. Support for significant additions to other assets.
   3. Documentation of realizability of other assets.

   ACCOUNTS PAYABLE, ACCRUED SALARIES AND BENEFITS, AND ACCRUED
   COMPENSATED ABSENCES

   1. Listing of the detail of the nature and balances of accounts payable at 6/30/04. *
   2. Access to your July, August, September and October 2004 warrant registers and all open
      invoices to date.
   3. Calculation of accrued salaries and benefits as of 6/30/04 with supporting documentation
      (accrued salaries and benefits schedule). *
   4. Copy of GAAP journal entry to record compensated absences with supporting documentation
      (compensated absences schedule). *


Last revised May 19, 2005                       Page 3
   DEFERRED REVENUE
      Detail of items recorded in deferred revenue and their respective balances at 6/30/05. *

   LEASES AND LONG -TERM DEBT
   1. Rollforward schedule of outstanding debt, including capital leases, that was allocated from
      the Chancellor’s Office or incurred independently by the campus *
   2. Copies of all new operating or capital lease agreements entered into during the current year.
   3. For capital leases, a schedule of future minimum lease payments including amounts that
      represent interest (this schedule must agree to the Reporting Package Note 6iv). *
   4. For operating leases, a schedule of future minimum lease payments for amount payable under
      non-cancelable lease agreements (this schedule must agree to the Reporting Package Note
      6iv). Also include the amount paid in total operating lease expenditures for the current year.
      *
   5. Copies of journal entries received from the Chancellor’s Office to record the Public Works
      Board Energy Efficiency Revenue Bonds and Systemwide, Housing, Student Union, and
      Parking Revenue Bonds.
   6. Copies of any new debt agreements for debt incurred independently by the campus
   7. Detail of interest expense and calculation of accrued interest balance at 6/30/05.

   SELF - INSURANCE CLAIMS LIABILITY
   1. Copies of journal entries and supporting documentation provided by the Chancellor’s Office.

   GRANTS REFUNDABLE
   1. Supporting detail for the grants refundable balance at 6/30/05.

   DEPOSITORY ACCOUNTS
   1. Supporting detail for the depository accounts balance at 6/30/05.

   OTHER LIABILITIES
   1. Listing of the detail of the nature and balances of other liabilities (current and noncurrent) at
      6/30/05. *
   2. Support for significant additions
   3. Rationale for classification as noncurrent

   NET ASSETS (GAAP EQUITY)
   1. Rollforward schedule of net assets by each net asset category (Beginning balances on
      rollforward schedule must agree to ending balances on the prior year Reporting Package.
      Any restatement adjustments should be reflected in Note 15 of the current year Reporting
      Package.) *
   2. Copies of all GAAP journal entries made that affect net assets




Last revised May 19, 2005                       Page 4
   FUND BALANCE CLEARING
   1. Copies of all journal entries made to eliminate fund balance clearing with supporting
      documentation attached.

   OTHER ITEMS
   1. Tuition and fees reasonableness test (include total number of students attending each term,
      fees and tuition charged each term and any other applicable information). *
   2. Tuition discounting calculation for scholarships given (tuition discounts should be reported
      net of revenue in the current year, not as an expense). *
   3. Resident Assistants (RA) housing schedule containing: 1) number of RAs for the year ended
      June 30, 2005 and related costs of housing provided to RAs (i.e. cost of housing if they would
      have been required to pay for it); and 2) detail of how these costs are accounted for in the
      statement of revenues, expenses, and changes in net assets
   4. Copies of all auxiliary organizations financial statements for the year ended June 30, 2005.
   5. Supporting tie-out schedules for the auxiliary organizations (GASB and FASB) columns on
      the statement of net assets and statement of revenues, expenses, and changes in net assets.
   6. Supporting tie-out schedules for Note 16 (Other Information: Auxiliary Organizations) of the
      Reporting Package.
   7. Copies of independence letters from the auditors of the campus’ auxiliary organizations
   8. Detail of all legal expenses incurred during the current year
   9. Phone listing of key personnel withjob title and extension


   *   indicates an example of this schedule was provi ded i n the 2005 GAAP Reporting Manual,
       Chapter 9.




Last revised May 19, 2005                     Page 5

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:50
posted:5/5/2011
language:English
pages:5
Description: Gaap Cash Clearing Accounts document sample