Your Financial Audit: Stress or Stress Free You Decide Dr. Tony - - PowerPoint PPT Presentation

▶

Mar 16, 2023 254 likes •402 views

Your Financial Audit: Stress or Stress Free You Decide Dr. Tony Juarez, EdD, CPA, CIA Pattillo, Brown, & Hill, L.L.P. Audit Manager May 25, 2018 5/25/2018 Dr Tony Juarez, EdD, CPA 1 Resume Texas Education Agency, School Financial

SLIDE 1

Dr. Tony Juarez, EdD, CPA, CIA

Pattillo, Brown, & Hill, L.L.P. Audit Manager May 25, 2018

Your Financial Audit: Stress or Stress Free You Decide

5/25/2018 Dr Tony Juarez, EdD, CPA 1

SLIDE 2

Resume

Texas Education Agency, School Financial Audits Division 1987-1995
Elgin ISD, Business Manager
Region 19, Associate Director for Finance and HR
Region 4, Chief Financial Officer
San Antonio ISD, Deputy Superintendent For Finance and Business
Brownsville ISD
Region 4 Business Consultant
Juarez CPA PLLC
Pattillo, Brown, & Hill L.L.P.

5/25/2018 Dr Tony Juarez, EdD, CPA 2

SLIDE 3

Finance Office Activities

Budget Day to Day Tasks Financial Audit

July through November September through January On-going Year Round New Fiscal Year Budget Budget Committee July 1 through June 30 September 1 through August 31

5/25/2018 Dr Tony Juarez, EdD, CPA 3

SLIDE 4

Finance Officer’s Tasks

Budget

Task’s

Board Meetings Cabinet Meetings Budget Planning and Preparation Student Activity Principals, Department Directors, Teachers, etc. Staffing and Financial Requests Vendors, Financial Advisors, Insurance Agents, TEA, Region 1 Continuing Education

Financial Audit Financial Audit

End Results

Board Meeting Reports Capital Assets Student Activity

5/25/2018 Dr Tony Juarez, EdD, CPA 4

SLIDE 5

Financial Audit

Trial Balance

Cash Property Tax Revenue State Revenues Tier I and II Capital Assets Due to/From Federal Grant Manageme Transfer in/Out Long-Term Debt Property Tax Receivable

Schedule of Fixed Assets Monthly Tax Payment Reports Bank Reconciliations Summary of Finances Monthly Tax Payment Reports Financial Advisor Amortization Schedules, Lender Payment Notices, Fund, Grantor, Other Government Schedule of Federal Awards Transfer(s) to another fund

5/25/2018 Dr Tony Juarez, EdD, CPA 5

General & Fiscal Guidelines Grant Management Handbook

SLIDE 6

Stress Bucket

5/25/2018 Dr Tony Juarez, EdD, CPA 6

Bank Reconciliations Later Property Tax Revenue Fixed Assets Long-Term Debt

SLIDE 7

Financial Audit

Request for information

5/25/2018 Dr Tony Juarez, EdD, CPA 7

Bank Reconciliations 1 bank accounts x 3 days x 6 months = 18 days Fixed Assets Reconciliation Minimal 2 months Long-Term Debt Reconciliation Minimal 1 months Trial Balance Reconciliation ????????

SLIDE 8

Potential Consequences

5/25/2018 Dr Tony Juarez, EdD, CPA 8

SLIDE 9

5/25/2018 Dr Tony Juarez, EdD, CPA 9

SLIDE 10

Trial Balance Out of Balance

5/25/2018 Dr Tony Juarez, EdD, CPA

Texas Public ISD

SLIDE 11

5/25/2018 Dr Tony Juarez, EdD, CPA 11

SLIDE 12

5/25/2018 Dr Tony Juarez, EdD, CPA 12

SLIDE 13

5/25/2018 Dr Tony Juarez, EdD, CPA 13

SLIDE 14

Thank You

5/25/2018 Dr Tony Juarez, EdD, CPA 14