Capital Lease Obligations - Auditor-Controller

Document Sample
Capital Lease Obligations - Auditor-Controller Powered By Docstoc
					 Long-Term Debt
  Capital Leases

       James D. Moore
      Senior Accountant
Specialized Accounting Division
  Auditor-Controller’s Office
      February 21, 2008
Departments with County Debt Obligations & Capital Leases


Objectives


   v Review departmental year-end
     responsibilities for capital leases.
   v Provide a checklist for convenient reference.
   v Provide a useful tool for analyzing current
     year lease activity.
Capital Lease Obligations

Departmental Year-end
Responsibilities

   v    Maintain pertinent supporting
        documentation.
   v    Update amortization (Excel worksheets) to
        reflect adjustments, deletions or additions.
   v    Submit to the Auditor-Controller’s Office by
        May 16, 2008.
   v    Submit appropriate documentation by fiscal
        year-end, June 30, 2008. No schedule Q. is
        needed any longer for your Capital Leases.
Capital Lease Obligations


Checklist for your reference . . .


   q     Use the query to obtain principal and interest
         payments. You can create your query from the
         sample attached.
   q     Reconcile the query to your Excel departmental
         amortization worksheet.
   q     Compare and adjust as needed. If your Excel
         report (worksheet) does not equal the query,
         correct the amortization as needed.
   q     Email query results and Excel lease amortization
         schedule to me by May 16, 2008.
County Capital Lease Obligations

   Let’s review how it was done in
   FY06-07.
County Capital Lease Obligations

  The Tool (PeopleSoft Query) Con’t…


                                   Select your dept. here
                                   (see next slide) Use in-
                                   tree option.




                                    For principal, use
                                    range #532500-532680.
                                    For interest paid, use
                                    expense range #533700
                                    -533780.
County Capital Lease Obligations

  The Tool (PeopleSoft Query) Con’t…
County Capital Lease Obligations

The Tool (PeopleSoft Query) Con’t…
Departments with County Debt Obligations & Capital Leases

People-Soft Query Screens
(version 8.8 FRP8 Environment)


  v   Let’s review examples of what the new
      screen shots look like now (FY07-08)

  v   Attached pages reflect version 8.8, People-
      Soft screenshots – to aid in running new
      queries for County Capital Leases (principal
      and interest payments for FY07-08)
Departments with County Debt Obligations & Capital Leases
Departments with County Debt Obligations & Capital Leases
County Capital Lease Obligations
Departments with County Debt Obligations & Capital Leases
County Capital Lease Obligations
County Capital Lease Obligations
County Capital Lease Obligations
County Capital Lease Obligations
County Capital Lease Obligations



   Contact Information
   If you require additional
   assistance


   v   James D. Moore (951) 955-9462
       jdmoore@co.riverside.ca.us

   v   Jerry Wood (951) 955-3574
       Jwood@co.riverside.ca.us

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:7/13/2013
language:English
pages:18