Gaap Cash Clearing Accounts
W
Description
Gaap Cash Clearing Accounts document sample
Document Sample


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
Get documents about "