Kevin W. Harper CPA & Associates
  • Home
  • About Us +
    • Services
    • Our People
    • Projects
    • Contact Us
  • Resources
  • Blog

Resources for Your Agency

Below is a list of our downloadable templates, checklists, Word, and Excel tools.
Everything is 100% free for your agency to download and use. Everything is customizable for your needs.
Simply click on the file name to download an attachment (no contact info needed).

For any questions, problems, or feedback, please email Kevin.
(To see each resource in context, click on "Related Blog Post”.
VISIT BLOG
Long-Term Financial Planning Policy [Word]
Related Blog Post: Long-Term Financial Planning – Benefits, Purpose, and Policy Sample
From the California Society of Municipal Finance Officers & the California Municipal Treasurers Association, Summer 2022
Presentation:
"Bamboozled" [PPT]
Generic Risk Framework [Word]
Related Blog Post: How to Assess Internal Controls: A Risk Framework
Sample Tenant Ledger [Excel]
Related Blog Post: How to Manage Your Government’s Tenant Rental Receivables Safely
Sample Payroll Error Log [Excel]
Related Blog Post: How Cities Can Monitor and Improve the Payroll Process
Example Finding of a Financial Government Audit [Word]
Related Blog Post: How Should a Government Respond to Audit Findings?
Checklist: Minimum Qualifications for an Independent Audit Firm [Word]
Related Blog Post: How to Select the Right Independent Auditor?
Risk Assessment Documentation Example [Word]
Related Blog Post: How to respond to auditors asking for Risk Assessment documentation?
From the Annual Conference of the California Society of Municipal Finance Officers, 02/18/2021
​

Presentation Materials:
Common Finance Dept Deficiencies – PRESENTATION [PDF]
Handout 1 - Budget Templates [Excel]
Handout 2 - Developing Budget Contracts [PPT]
Handout 3 - Error Logs [Excel]
Handout 4 - Financial Forecast [PPT]
Handout 5 - Grants Status Report [Excel]
Handout 6 - Grants Procedures [Word]
Handout 7 - Training on Contract Processing [PPT]
Handout 8 - Training on Invoice Processing [PPT]
Handout 9 - Training on Journal Vouchers [PPT]
Handout 10 - Long Term Financial Projection [Excel]

Related Presentation: (Virtual) Annual Conference of the California Society of Municipal Finance Officers, presentation by Kevin W. Harper with Rebecca Gebhart of Alameda County, 02/18/2021
Conference Website link:
https://conference.csmfo.org/
Related Blog Posts: various
Finance Staff Training Opportunities [Word]
Related Blog Post: How to Set Up a Finance Staff Training Program
Sample Closing Plan [Excel]
Related Blog Post: Annual Accounting Closing Plan
Finance-Related Performance Metrics List [Word]
Related Blog Post: Performance Metrics for Finance Departments
Sample Error Log (for Accounts Payable and for Cash Receipts) [Excel]
Related Blog Post: Error Logs: How to Monitor Effectiveness of Internal Controls
Budget vs Actual Report Sample [Excel]
Related Blog Post: Effective Budgeting: Budget vs Actual Quarterly Report
Multi-Year Financial Projections Sample [Excel]
Related Blog Post: Multi-Year Financial Projections
From the Annual Conference of the California Society of Municipal Finance Officers, 01/29/2020​
​

​Inventorying Capital Assets:
Fixed Asset Addition Form [Excel]
Fixed Asset Disposal Form [Excel]
Fixed Asset Transfer Form [Excel]
Generic Count Sheet [Excel]
Generic Rotation Plan [Excel]
Sample Procedures [Word]

Related Presentation: Annual Conference of the California Society of Municipal Finance Officers, 01/29/2020
Conference Brochure link:
https://issuu.com/smalaunch/docs/csmfo2020_digitalonsiteguide?fr=sMWJmODcyMjU5MQ (please see page 7 for this presentation's description.)
Related Blog Posts: Inventorying Capital Assets – 6 Steps of Preparation​, Inventorying Capital Assets – Inventorying Capital Assets – Key Points for Taking Physical Inventory, Common Challenges in Inventorying Capital Assets –“Sticky Wickets”, How to Manage Fixed Asset Disposals Better?
Government Capital Assets – Internal Controls to Have in Place [List – Word]
Related Blog Post: Government Capital Assets – Internal Controls to Have in Place​
Sample Meal Per Diem Policy [Word]
Related Blog Post: Employee Expense Reimbursements – Meal Per Diems vs. Exact Expense Reimbursements​
Sample Travel Expense Form [Excel]
Related Blog Post: Employee Expense Reimbursements – Common Problems & Internal Controls to Implement
Sample employee reimbursement policies [PDF or website links]:  
County of Napa – Travel Policy
County of Santa Clara – Travel Policy
County of Sonoma – Travel and Meal Reimbursements

City of Los Angeles – Policy for Travel Expenses, Non-Travel Expenses and Elected Officials’ Contingency Account Expenditures
Related Blog Post: Employee Expense Reimbursements – Common Problems & Internal Controls to Implement
Development of a Travel Policy (provided by the GFOA) [Word]
Related Blog Post: Employee Expense Reimbursements – Common Problems & Internal Controls to Implement
Budget vs. Actual Variance Analysis Report [Excel]
Related Blog Post: Explaining Budget vs. Actual Variances in Financial Reports
Internal audit mission statements [PDFs via direct links]: 
City of Milwaukee, Wisconsin 
City and County of Denver, Colorado​ 
City of Boise, Idaho​ 
City Of San Diego, California
​Related Blog Post: The Importance of Having an Internal Audit Function
Written Interview Tests Questions:
Narrative [Word]
True/False, Multiple Choice, Fill-in-the-Blank; Analytical [Word]
Excel Skills Assessment [Excel]
Related Blog Post: Written Tests for New Financial Hires: What Questions Should Governments Include​
Sample Interview Questions [Word]:
Finance Director 

Finance Manager 
Accountant 
Accounting Clerk 

​​Related Blog Post: Sample Interview Questions of New Hires in Governments’ Financial Departments
Sample FAQ [Word]
​Sample "Who to Call"-List [Word]
​
Related Blog Post: Navigating Administrative Services of Local Governments
Sample Mission Statements for Government Customer Service Departments [Word]
Sample Assessments Feedback Survey [PDF]
Related Blog Post: Proactive Customer Service for Local Government Administrative Service Departments
Audit Plan for P-Card Program [Word]
Related Blog Post: Auditing a Purchasing Card Program – Why It Matters & How to Do it Right
Account Reconciliation Assignment Template [Excel]
Account Reconciliation Sample [Excel]

Related Blog Post: Five Steps to Good Account Reconciliation Procedure
Pollution Remediation Liability Worksheet [Word]
Related Blog Post: Does GASB 49 Affect Your Government? – GASB 49’s Requirements, Part 2
Grants Management & Subrecipient Monitoring-specific Attachments:

Management Decision Template (Word)
Related Blog Post: Subrecipient Monitoring – Linking Risk Assessment Results to Levels of Monitoring
Related Blog Post: Subrecipient Monitoring – Reviewing Financial and Programmatic Reports


Risk Assessment Summary (Excel)
Related Blog Post: Subrecipient Monitoring – Linking Risk Assessment Results to Levels of Monitoring
Related Blog Post: Subrecipient Monitoring – Reviewing Financial and Programmatic Reports
Related Blog Post: Subrecipient Monitoring – How to Conduct a Risk Assessment of Subrecipients


Subrecipient Financial Report Review Checklist [PDF]
Related Blog Post: Subrecipient Monitoring – Reviewing Financial and Programmatic Reports

Subgrantee Risk Assessment Questionnaire – Financial Risk [Word]
Subgrantee Risk Assessment Questionnaire – Programmatic Risk [Word]

Related Blog Post: Subrecipient Monitoring – How to Conduct a Risk Assessment of Subrecipients

Subrecipient vs. Contractor Determination Checklist (Excel)
Related Blog Post: Subrecipient Monitoring – How to Distinguish Subrecipients from Contractors

Grants Management Procedures Template [Word]
Related Blog Post: Grants Management: Grants Procedures (Free Template)

Grant Status Report Template [Excel]
Related Blog Post: Benefits of Preparing a Grant Status Report [Downloadable Template Included]​​​

For any questions, or to book a consultation,
please reach out to us here:

CONTACT US

    Sign up for our newsletter highlighting top blog posts & free resources:

Get Free Tools!

Search Across Entire Site:


HELPFUL LINKS:

Home
Services
People
Projects
Testimonials
​
​Articles
Blog
​Resources (for download) 

Contact Us​
​
​Book Consultation
FAQ
​Employment
​

Client Portal
​Privacy Policy
​​Admin Login
20885 Redwood Road, #202
Castro Valley, CA 94546
(510) 593-5037
KHarper@kevinharpercpa.com
  • Home
  • About Us +
    • Services
    • Our People
    • Projects
    • Contact Us
  • Resources
  • Blog