Logo final 60Useful Tools Database

Crawford & Associates, PC have long been recognized as a leader in developing useful and practical guidance and tools for governmental accountants and auditors. In the process of developing materials for continuing education courses or conference sessions, we have designed a number of example forms, guidance charts and other useful information to make the job of the governmental accountant or auditor easier. Listed below are some useful tools available from our web site.

You will find TWO sections: the first has smaller files and the section below it has larger files. To view our files, you must be able to view word documents, pdf files, and excel files.

Section I: Use the data below to search our database of Useful Tools

Category

Title

Description

Type

File

Accounting

Invoice Approval Form

Example form for documenting approval of invoices for payment.

application/msword

Download now

Accounting

GASB 61 Reporting Entity Questionnaire

Questionnaire to assist in evaluating potential component units within a financial reporting entity.

application/pdf

Download now

Accounting

GASB 68 Pension Case Study Assumptions

GASB 68 pension case study background information and assumptions.

application/pdf

Download now

Accounting

GASB 61 Reporting Entity Flowchart

Flowchart to assist in evaluating the composition of the financial reporting entity, including potential component units.

application/pdf

Download now

Accounting

GASB 54 Fund Type Classification Worksheet

Worksheet to assist in classifying funds by type pursuant to GASB 54 definitions.

application/vnd.ms-excel

Download now

Accounting

GASB 54 Fund Balance Analysis Worksheet

Example worksheet to track changes in fund balance by level of constraint pursuant to GASB 54.

application/vnd.ms-excel

Download now

Accounting

Financial Statements Consistency Checklist

Checklist for reviewing the basic consistencies that should be present within a set of governmental financial statements.

application/msword

Download now

Accounting

Agent Multi Employer Pension Case Study Worksheet

Blank worksheet used in GASB 68 agent multi employer case study.

application/vnd.ms-excel

Download now

Accounting

Agent Multi Employer Pension Case Study Solution

Worksheet solution to GASB 68 agent multi employer accounting case study.

application/vnd.ms-excel

Download now

Accounting

GASB 68 Pension Case Study Actuarial Report

Example actuarial report used in GASB 68 case study.

application/pdf

Download now

Accounting

GASB 68 Case Study Worksheet Answers

Compeleted worksheet with suggested answers for GASB 68 accounting case study.

application/vnd.ms-excel.sheet.macroEnabled.12

Download now

Accounting

GASB 68 Cost Sharing Assumptions

GASB 68 cost sharing plan case study assumptions.

application/pdf

Download now

Accounting

GASB 68 Cost Sharing Supporting Schedule 2

GASB 68 cost sharing plan case study supporting information part 2.

application/pdf

Download now

Accounting

Court Daily Accounting Form

Example daily balancing form for municipal court clerks.

application/vnd.ms-excel

Download now

Accounting

Capital Asset Project Form

Example form for documenting capital asset construction projects.

application/vnd.ms-excel

Download now

Accounting

Purchase Requisition Form

Example form for documenting requests for spending or purchases.

application/msword

Download now

Accounting

Purchase Order Form

Example form for documenting spending or purchasing commitments.

application/msword

Download now

Accounting

GASB 68 Case Study Blank Worksheet

Blank worksheet for use in conducting GASB 68 accounting case study.

application/vnd.ms-excel.sheet.macroEnabled.12

Download now

Accounting

GASB 68 Cost Sharing Supporting Schedule 1

GASB 68 cost sharing plan case study supporting information part 1.

application/pdf

Download now

Accounting

GASB 68 Cost Sharing Worksheet

GASB 68 cost sharing plan case study worksheet and answers.

application/vnd.ms-excel.sheet.macroEnabled.12

Download now

Audit

Audit RFP – GAAP Basis

Example request for proposal for audit services for GAAP-basis financial statements.

application/msword

Download now

Audit

Audit RFP - OCBOA Financial Statements

Example request for proposal for the audit of financial statements prepared on a cash or modified cash basis.

application/msword

Download now

Budget

Resolution - Lapsing All Appropriations

Example resolution to adopt a policy of lapsing all unexpended appropriations at year end.

application/msword

Download now

Budget

Budget Status Report

Example budget status report for a fund.

application/vnd.ms-excel

Download now

Budget

Resolution Adopting Municipal Budget Act

Example resolution for electing to adopt the provisions of the Municipal Budget Act.

application/msword

Download now

Budget

Resolution - Lapsing Only Unencumbered Appropriati

Example resolution for policy of lapsing only unencumbered appropriations at year end.

application/msword

Download now

Budget

Budget Adoption Resolution – Purpose-Based

Example resolution for budget adoption on a purpose-based budget.

application/msword

Download now

Budget

Budget Adoption Resolution – Fund-Based

Example resolution for budget adoption on a fund-based budget.

application/msword

Download now

Budget

Budget Amendment Form

Example form for use in making budget amendments.

application/vnd.ms-excel

Download now

Budget

Budget Policy

Example budget and fiscal management policies.

application/msword

Download now

Ethics

Elected Official's Orientation Guide to Ethics

An introductory guide to ethical behavior for elected officials presented in a question and answer format.

application/msword

Download now

Ethics

Government Code of Conduct

Example code of conduct policies for a government entity.

application/msword

Download now

Fraud

How to Prevent, Deter and Detect Fraud

Defines certain types of fraud and introduces basic concepts to help prevent, deter and detect fraud.

application/pdf

Download now

Fraud

Importance of Internal Controls

An artcile written by Mike Crawford on the importance of effectively designed and implemented internal controls over misappropriation of assets and other potential fraud.

application/pdf

Download now

Fraud

The Need for Audit Committees in Government

Role of audit committees in government and explaining why they are essential for a strong control environment

application/msword

Download now

Fraud

Management Antifraud Programs and Controls

Helps management design and implement fraud prevention, deterrence and detection policies and procedures.

application/pdf

Download now

Legal

Changing Fiscal Years – AG Opinion

State Attorney General’s opinion on Oklahoma municipalities interested in changing fiscal years.

application/pdf

Download now

Legal

Changing Municipal Fiscal Years

Summary of information for Oklahoma municipalities interested in changing fiscal years.

application/pdf

Download now

Legal

Ordinance for Changing Fiscal Years

Example ordinance for Oklahoma municipalities interested in changing fiscal year.

application/msword

Download now

Legal

Ordinance on Claims Payment

Example ordinance for adopting a claims payment policy that differs from state law.

application/msword

Download now

Legal

Municipal Utility Issues

An OML document that discusses various issues related to establishing utility rates under Oklahoma law.

application/msword

Download now

Legal

Okla Municipalities and Their Public Trusts

A whipe paper that discusses the relationship between an Oklahoma municipality and its public trusts created pursuant to Title 60, Section 176.

application/pdf

Download now

Legal

Debt Limitation Issues

An OML document that discusses the constitutional debt limitation for Oklahoma governments and related court cases.

application/msword

Download now

Legal

AG Opinion on Employee Benefits & Awards

1987 OK Attorney General opinion on the legality of payments to employees for awards and other benefits.

application/msword

Download now

Performeter

Example Performeter Report

An example Performeter financial evaluation report for a local government entity in Powerpoint format.

application/pdf

Download now

Policies

Purchasing and Disbursement Policies

Example ordinance to establish formal policies for purchasing, competitive bidding, and disbursing.

application/msword

Download now

Policies

Segregation of Duties

Example form to establish segregation of duties over financial management and accounting.

application/msword

Download now

Policies

Capital Assets Policies

Example capital assets management policies.

application/msword

Download now

Policies

Investment Policies

Example policies for managing deposit and investment risks

application/msword

Download now

Policies

Budget Policy

Example budget and fiscal management policies.

application/msword

Download now

Reports

Monthly Executive Summary Budget Report

Example monthly report for governing body on budget and financial status.

application/msword

Download now

Reports

Long-Term Debt Report

Example monthly report of long-term debt and changes therein by debt issue.

application/vnd.ms-excel

Download now

Reports

Monthly Budget Status Report

Example high-level budget status report for a fund with narrative text boxes.

application/vnd.ms-excel

Download now

Reports

Monthly Treasury Report

Example monthly report of cash and investment balances and changes therein, including an analysis of unisured deposits and related collateral.

application/vnd.ms-excel

Download now

Reports

Monthly Sales and Use Tax Report

Example monthly report of sales and use tax collections compared to prior year.

application/vnd.ms-excel

Download now

 

Section II: Below, find our larger files for download.

Category

Title

Description

Type

File

Budget

Budget Document – By Fund

Example format for fund-based budget document

Application/pdf

Download

 

Budget Document – By Purpose

Example format for purpose-based budget document.

Application/pdf

Download

Legal

Public Trust Issues

An OML document that discusses various issues related to public trusts created under Oklahoma law.

Application/pdf

Download

 

Municipalities and Their Public Trusts

An OML document that discusses various relationship issues between municipalities and their public trusts created under Oklahoma law.

Application/pdf

Download