Laserfiche WebLink
� <br />GL System <br />CITY OF PEQUOT LAKES <br />12/31/2011 AUDIT PREPARATION LIST <br />Water Usage report for 2011 <br />Trial Balance report for 2011 <br />Detail Ledger for January - February 2012 <br />Journals by Fund <br />Detail Ledger for 2011 <br />Miscellaneous �Any updated policies (personnel, investment, acctg & reportin�, bus cont, CR card, travel, etc...) <br />� Updated organization chart for financial statements as of 12/31/11 <br />� Fund listing for 2011 <br />� Copy of any new joint powers agreements entered into during 2011 <br />�Copy of 2011 board approved budget <br />I Capital outlay carryover spreadsheet <br />�Trailside Estates WAC/SAC spreadsheet <br />I OPEB Actuary <br />�Actual vs Budget Explanations spreadsheet <br />Provide the 2011 annual required contribution amount for the Fire Dept Relief Assoc <br />Person <br />Responsible <br />Mike <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Sandy <br />Nancy <br />Sandy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Sandy <br />Date <br />Completed <br />2/3/2012 <br />3/8/2012 <br />3/14/2012 <br />3/7/2012 <br />3/8/2012 <br />2/3/2012 <br />1 /13/2012 <br />2/3/2012 <br />1 /13/2012 <br />2/3/2012 <br />3/8/2012 <br />2/3/2012 <br />1 /12/2012 <br />3/16/2012 <br />1 /27/2012 <br />Cash Listinq of Petty Cash and Change funds for 2011 Nanc�r 2/3/2012 <br />Schedule of cash balances by fund for 12/31/2011 Nancy 2/17/2012 <br />�Prepare bank confirmations and send to LA Nancy 12/16/2011 <br />IDecember 2011 and January 2012 bank reconcilations and statements for all accounts Nancy 2/17/2012 <br />December 2011 outstanding check list for main checking account Nancy 2/6/2012 <br />Interest income spreadsheet Nancy 2/17/2012 <br />AR Detail of accounts receivable for all funds <br />Revenues Schedule of 2011 property taxes and special assessment revenues <br />�Summary of utility billings by month by area for 2011 <br />� Copy of Flanning and Zoning fees for 2011 <br />� � Copy of Planning and Zoning licenses for 2011 <br />�Receipts Register for 2012 <br />Receipts Journal for 2011 <br />AP <br />Expenditures <br />Transfers <br />Due to/from <br />Detailed listing of accounts payable for all funds <br />Check Registers for 2011 & 2012 <br />Disbursements Journal for 2011 <br />Summary of transfers in and transfers out by fund and identify the purpose of each transfer <br />Summary of due to and due from other funds and identify the purpose of each due to/from <br />Debt Summary of long-term debt for 2011 <br />� Fill out accrued interest payable spreadsheet <br />� Copies of debt payment schedules for any new debt issued <br />� Copies of new leases entered into or renewed during 2011 <br />�Lease note disclosure spreadsheet <br />Update deferred bond issuance cost amortization spreadsheet <br />LC � Listing of open construction contracts that were open at any time during 2011 <br />Capital Assets �Update capital asset listing/depreciation schedules <br />A schedule of 2011 additions to capital assets for Water, Sewer, City <br />A schedule of 2011 disposals of capital assets for Water, Sewer, City <br />Payroll Update Accrued Vacation, SL, Comp spreadsheet <br />Salaries Payable support <br />� Payroll tieout spreadsheet <br />� Summary of 2011 PERA contributions by applicable pension plan <br />Audit Adj � Process audit adjustments <br />� <br />Nancy <br />Nancy <br />Jeanyne <br />Dawn <br />Dawn <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Sandy <br />Nancy <br />Nancy <br />Sandy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />Nancy <br />3/7/2012 <br />2/3/2012 <br />1/11/2012 <br />2/8/2012 <br />2/8/2012 <br />3/14/2012 <br />3/8/2012 <br />3/8/2012 <br />3/14/2012 <br />3/8/2012 <br />2/6/2012 <br />3/1 /2012 <br />2/13/2012 <br />2/13/2012 <br />2/6/2012 <br />1 /27/2012 <br />2/28/2012 <br />2/13/2012 <br />1 /27/2012 <br />2/28/2012 <br />2/28/2012 <br />2/28/2012 <br />2/16/2012 <br />2/14/2012 <br />2/16/2012 <br />2/14/2012 <br />3/7/2012 <br />