slide1 n.
Skip this Video
Download Presentation
A Practical Approach to Preparing for your Audit

Loading in 2 Seconds...

play fullscreen
1 / 61

A Practical Approach to Preparing for your Audit - PowerPoint PPT Presentation

  • Uploaded on

A Practical Approach to Preparing for your Audit. May 8, 2012 Presented by: Deborah Garringer, Crowe Horwath LLP Bill Spinelli, City of Tampa. Topics for Discussion. Planning and Communication for your Audit Practical suggestions Risk Assessment & Internal Controls Assessing risk

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'A Practical Approach to Preparing for your Audit' - vladimir-turner

Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

A Practical Approach to Preparing

for your Audit

May 8, 2012

Presented by:

Deborah Garringer, Crowe Horwath LLP

Bill Spinelli, City of Tampa

topics for discussion
Topics for Discussion
  • Planning and Communication for your Audit
    • Practical suggestions
  • Risk Assessment & Internal Controls
    • Assessing risk
    • Evaluating Internal Controls
  • Audit Preparation
    • Reconciliations
    • Proper closing procedures
    • Financial Statements
    • Audit Challenges
  • Q & A
annual audit process update
Annual Audit Process Update:
  • Plan and Communicate Early
  • Always Analyze the Risk to Your Entity
  • Update Internal Controls Documentation
  • Review New Accounting Guidelines
  • Review Job Assignments
practical suggestions planning
Practical Suggestions Planning
  • Plan to Plan
    • There is duplication in many of the year end procedures, discuss how the process can be streamlined.
    • Have a meeting with all key players.
    • If you need something from a department, include them in the meeting.
    • Do this timely, well before year end.
    • Be organized and prepared. Set up a system that works for your department.
practical suggestions planning1
Practical Suggestions Planning
  • Communicate to all participants of planning meeting :
    • Summarize what was discussed and who is responsible (responsibility chart)
    • Require acknowledgement of receipt
    • Allow for input if something is missing
practical suggestions planning2
Practical Suggestions Planning
  • Communicate with Departments
    • Payable cut-off and system lock out dates
    • Make sure to included key support personnel in the communications
      • Financial personnel
      • Operational personnel
      • Administrative assistants
practical suggestions planning3
Practical Suggestions Planning
  • Communicate with Departments
    • Schedules and assistance that will be needed from that department
      • Audit or year-end close schedules or reports
      • Identification of CIP projects completed
      • Access to files for auditors
      • Footnote information
practical suggestions planning4
Practical Suggestions Planning
  • Document your plan including all significant tasks, responsible individual and due date
    • Matrix
    • Checklist
    • Narrative
practical suggestions planning6
Practical Suggestions Planning
  • Communication should be:
    • Early
    • Complete
    • Effective
practical suggestions general ledger accounts
Practical Suggestions General Ledger Accounts:
  • Consider monthly reconciliation for all balance sheet accounts.
  • Document findings during monthly budget to actual comparisons for use in year-end fluctuation analysis work.
  • Book the reversing entry when you book accrual.
practical suggestions for cash and investments
Practical Suggestions for Cash and Investments:
  • Timing – can be done early in the year-end process.
  • Bank Reconciliation is key – get this done timely, fill in deposit footnote piece.
  • Pooled cash equity – reconcile to equity in each fund.
  • Investments – reconcile to trustee statements (best if done monthly) to ensure all transactions are properly recorded including interest.
  • Footnotes for investments can be prepared once 9/30 transactions recorded (effective duration by investment type, concentration of asset by type, etc.)
practical suggestions for receivables
Practical Suggestions for Receivables:
  • For Revenues/Receivables
    • Prepare FLAIR reconciliation for State Revenues
    • Book accruals
    • Reverse prior year accrual
    • Add amounts to Due from Other Government audit workpaper (and footnote, if applicable)
    • Agree subsidiary ledger to general ledger.
    • Print detail report of subsidiary ledger balances. (Report can be spooled for later printing or review.)
    • If clean up is needed, propose the entry then and rerun report or prepare a reconciliations to the G/L.
  • Grants – when submitting reimbursement request, add any accruals to Due from other Governments schedule (prepared for auditors and footnote, if applicable)
  • Look for 12 months of receipts for routine payments
  • Revenue recognition policy affects accruals.
  • For significant interlocalagreements, check revenue against contract to see if receivable needs accrued. Do this when recording the last receipt prior to 9/30.
  • Don’t forget to reverse prior year accruals.
  • Prepare reversing entry for 10/1 at the time your prepare the 9/30 accrual.
practical suggestions for debt
Practical Suggestions for Debt:
  • Can be done early.
  • When you make the last payment for the year, update the debt progression schedule for the audit footnotes.
  • Be diligent in keeping a file for all new debt issues and lease arrangements. When you obtain amortization schedules, add to audit file and footnote schedules.
  • For proprietary debt, ensure that ending balance per progression agrees to general ledger.
  • Premiums and deferred amounts can be amortized and then added to debt progression shortly after year-end.
  • Make sure ending balances agree to G/L
practical suggestions for payroll
Practical Suggestions for Payroll:
  • Many general ledger software packages can handle accrual automatically.
    • Find out if your software has this option.
    • Test the accrual in “train mode” if possible
  • Propose accrual (and reversing entry) as part of processing the last payroll of the year.
  • Prepare the reconciliation for the auditors at the time the 941 is filed.
  • Run leave reports (vacation and sick) after the last payroll for the year. Compensated absence schedules, footnote and accruals can be done shortly after the last payroll run.
practical suggestions for capital assets
Practical Suggestions for Capital Assets:
  • Reconcile capital outlay monthly.
  • Consider monthly review of all R&M accounts.
  • Identification of CIP completed can begin before year-end.
    • Can be time consuming
    • Make requests early
  • Don’t forget about intangible assets.
practical suggestions for expenditure accruals
Practical Suggestions for Expenditure Accruals:
  • Look at major contracts for retainage and necessary accruals and go ahead and draft commitment footnote.
  • Consider performing a Search for Unrecorded Liabilities
    • Set scope below auditor’s scope.
    • Perform for at least 3 months across all funds.
    • Document reasons for not accruing transactions.
practical suggestions for accounts payable
Practical Suggestions for Accounts Payable:
  • Prepare detail at 9/30 through your cut off date and keep this report for auditors to use for tie in for their Search for Unrecorded Liabilities.
practical suggestions for accounts payable1
Practical Suggestions for Accounts Payable:
  • Prepare detail at 9/30 through your cut off date and keep this report for auditors to use for tie in for their Search for Unrecorded Liabilities.
risk assessment
Risk Assessment
  • Have you done it?
  • Evaluation of internal and external risks
  • Identify risks and plan to address them
  • Focus on those that are relevant to the entity’s goals and objectives
entity environment and internal controls
Entity, Environment and Internal Controls:
  • Entity
    • Nature of Activities
    • Organizational Structure
    • Performance Measures – Internal and external
  • Environment
    • Political
    • Public
    • Internal
entity environment and internal controls con t
Entity, Environment and Internal Controls: (Con’t)
  • Entity Internal Controls
  • COSO
    • Control Environment
    • Risk Assessment
    • Control Activities
    • Information and Communication
    • Monitoring
internal control documentation
Internal Control Documentation
  • Think COSO
  • Who are the Key Personnel involved in a process?
  • What are the transactions?
  • What are the risks inherent in the process?
  • What are the IT systems affecting the process?
  • What is the work flow?
control environment
Control Environment
  • What is the tone at the top?
  • Control environment sets the foundation for all other components
  • Management’s integrity
  • Ethical values
  • Competence of staff
  • Management’s philosophy and operating style
control activities
Control Activities
  • Polices and procedures that ensure goals and objectives are carried out
  • Ensure actions are taken to address risks
  • Occur throughout the entity
  • Include things, such as:
    • Approvals
    • Authorizations
    • Reconciliations
    • Segregation of duties
information and communication
Information and Communication
  • Relevant information communicated in a proper form and a timely manner
  • Includes information systems used to produce reports needed to properly manage
  • Communication should be effective
  • Communication is vertical and horizontal
control monitoring
Control Monitoring
  • Performed on an ongoing basis
  • Focused on risk
  • May be incorporated into controls
  • Necessary to ensure controls are functioning as designed
  • Helps set a positive tone
account reconciliation
Account Reconciliation
  • Performed timely and prior to TB final close
  • Have it reviewed and document review
  • Agreed to the final TB account amount
  • Agreed to the sub-ledger (when applicable)
  • Keep as support TB and sub-ledger amount reports used in the reconciliation
  • Support all reconciling items
  • When complete, make the adjustment
account reconciliation con t
Account Reconciliation (Con’t)
  • Balance Sheet Accounts - How often and how many?
  • Operating Accounts - How often and how many?
trial balance close
Trial Balance Close
  • Close the TB for the auditor
  • Don’t close the TB for the new year until after the audit
  • Provide the closed TB to the auditor as soon as possible
  • Request analytics
  • Set an adjustment materiality (discuss with auditor)
trial balance close con t
Trial Balance Close (Con’t)
  • If not complete, identify items still open
  • Its your trial balance
  • Provide all adjustments to the auditor
  • Make all audit adjustments
  • Make sure equity accounts agree to PY financial statements
create a checklist
Create a Checklist:
  • Set Reasonable Deadlines
  • Identify the Items to Addressed During the Audit
  • Assign a Responsible Staff Person
  • Assign a Reviewer- Use as a Cross-Training Tool
timely closing procedures
Timely Closing Procedures
  • Coordinationbetween finance and other departments is essential:
    • When will Payables cut off?
    • When will grantreimbursements be submitted?
    • When will inventory counts be performed?
    • What construction projects are expected to be completed?
      • Search for outstandinginvoicesoncontracts, including retainage
timely closing procedures1
Timely Closing Procedures
  • Plan for appropriate year-end account analysis:
    • Balance subsidiary ledgers to the G/L
      • Accounts Receivables
      • Deposits
      • Accounts Payable
    • Reconcile activity in debt accounts:
      • Principal payments
      • New debt
timely closing procedures2
Timely Closing Procedures
  • Plan for appropriate year end account analysis:
    • Deferred Revenue
      • Grants
      • Taxes
    • Capital Asset Accounts
      • Assets purchased and disposed
      • Completed CIP
timely closing procedures3
Timely Closing Procedures
  • Identify year end entries:
    • Bank reconciliation clean up
    • Classifying capital items and CIP
    • Recording Debt Transactions
    • Revenue and expenditure accruals
    • Compensated Absence for Enterprise Funds
    • Recognize revenue for amounts previously deferred
timely closing procedures4
Timely Closing Procedures
  • Identify year end reports:
    • Accounts Receivable subsidiary and aging
    • Purchase Orders Carried Forward
    • Deposit detail
    • Accounts Payable subsidiary
    • Sick/Vacation (Accrued Leave Report)
timely closing procedures5
Timely Closing Procedures:
  • Identify valuations and estimates to be performed by specialists:
    • OPEB
    • Pension
    • Self-Insurance
    • Swap Valuation and Effectiveness Calculation (GASB 53)
    • Budget Adjustment
timely closing procedures6
Timely Closing Procedures:
  • IT Processes:
    • P.O. Roll over process
    • Input of new budget
    • Closing of fiscal year
  • Documentation of Closing Process:
    • Checklists
    • Notes, Approvals, Sign-off’s
    • Screen shots
financial statements
Financial Statements
  • Whose are they?
  • Who will prepare (client, auditor, third party)?
  • What are the internal controls over financial reporting and financial statement preparation?
  • If the auditor is part of the process, who is the client rep taking responsibility?
  • What are the qualifications of third-party preparer?
financial statements con t
Financial Statements (Con’t)
  • Update and complete the MD&A as soon as possible; don’t wait for final “numbers”
    • Roll the boiler plate information forward
    • Highlight items which will change
    • Update future data – generally comes from budget process
financial statements con t1
Financial Statements (Con’t)
  • Begin statistical section as soon as possible; update what you can, when you can
    • Revenue capacity schedules
    • Debt capacity schedules
    • Demographic data
    • Operating information
financial statements con t2
Financial Statements (Con’t)
  • Gather footnote support during reconciliation processes
    • Roll Notes forward
    • Cash and Investments – Update after reconciliations completed. At that point, you should have what you need.
    • Component Unit information
    • Fixed Assets
    • Debt
financial statements con t3
Financial Statements (Con’t)
  • Gather footnote support during reconciliation processes (Con’t)
    • Pension data
    • OPEB data
    • Interfund activities
    • Cash and Investments – update after reconciliations completed. At that point, you should have what you need.
    • Component Unit information
    • Fixed Assets
    • Debt
financial statement preparation
Financial Statement Preparation:
  • CAFR/Financial Statement Preparation
    • Prepare Fund level statements
    • Schedules for conversion amounts to be updated
      • Debt – bonds and notes
      • Other long term liabilities
      • Capital Assets
financial statement preparation1
Financial Statement Preparation:
  • Schedules for conversion amounts to be updated
    • Accrued interest
    • Pensions (NPO) and OPEB
    • Deferred revenue/Unearned
financial statement preparation2
Financial Statement Preparation:
  • Top Level Statement to be completed
  • Footnotes need to be done
    • (SSAP, Cash and Investments, Debt, Capital Assets, Interfund transactions, Pensions, Commitments, Fund Balance composition, etc.)
    • Statistical Section data to be gathered
audit challenges to prepare for
Audit Challenges to Prepare For:
  • Annual Audit Process Update
  • Timely Closing Procedures
  • Preparing for the Audit – Work papers and Schedules requested by the audit team (PBC list)
  • CAFR/Financial Statement Preparation
audit preparation
Audit Preparation:
  • Be Prepare
    • Document Internal Controls
    • Address the Prior-Year Finding and Recommendations
    • Meet/Discuss any Significant Issues or Changes with the Auditor
    • Reconcile the Accounts on a Timely Basis
    • Support the Accounting Estimates
    • Have the Analytical Explanations Ready
      • PY Vs. CY
      • Budget Vs. Actual
  • Make Sure Auditor’s Deadlines are Reasonable
  • Review Request List and Inquire if you Have any Questions
audit preparation1
Audit Preparation:
  • PBC List
    • Internal Control Narratives
      • Existing Procedures
      • New software or processes
      • Evaluation of potential risk areas
      • Consideration of fraud
audit preparation2
Audit Preparation:
  • Detail Control Reports to be run and prepared and copies provided to the auditor:
    • Accounts Receivable
    • Purchase Orders
    • Accounts payable
    • Deposits
    • Accrued Leave
audit preparation3
Audit Preparation:
  • Schedules to be prepared:
    • Cash transfers schedule
    • Investment detail with market values
    • Detail of Receivables
    • Due to/from Other Governments
    • Schedule of Due to/from other funds
    • Fund Balance analysis
audit preparation4
Audit Preparation
  • Footnote progressions to be updated
    • Debt progression (including compensated absences, OPEB)
    • Capital Asset progression
    • OPEB and Pensions
audit preparation5
Audit Preparation:
  • Gather general documentation for new transactions/processes
    • New debt (bonds and notes) and leases
    • New accounting standards and implementation
    • Documentation of new software programs, IT
going forward
Going Forward
  • Start reviewing your assigned funds
  • Clean up the chart of accounts
  • When in doubt deactivate
  • Gain an understanding on where the numbers are coming from
  • The more questions the better
  • Review the Notes to the financial statements
  • Obtain the template
  • Obtain the supporting documentation
important dates
Important Dates
  • 9/12/11- Job Description Assignments
  • 9/13/11- Risk Assessment Meeting
  • 9/13/11- Single Auditor Onsite
  • 9/16/11- GASB 54 Training
  • 9/19/11- External Auditor Onsite
  • 9/30/11- All Staff Meeting
  • 11/14/11- External Auditor Onsite
  • 12/22/11- Everything Done
for more information contact
For more information, contact:

Deborah Garringer

Direct 863.603.4834

Bill Spinelli

Direct 813.274.8644