Fin5 Acct Fin Instructor Guide
Fin5 Acct Fin Instructor Guide
Fin5 Acct Fin Instructor Guide
Instructor Guide
Financial/Managerial Series
This course includes content developed by the Pennsylvania
Department of Environmental Protection in cooperation with the
following grantees:
RCAP Solutions, Inc.
Penn State Harrisburg Environmental Training Center
Training Module 5
Instructor Guide
Basics of Accounting and Finance for Small Water Systems
Objectives:
After completing this course, the learner will be able to:
Identify Assets, Liabilities, Retained Earnings, Revenue, and Expenses on a
financial statement.
Identify the components of a Balance Sheet, Income Statement and Statement of
Cash Flows.
Identify the difference between the Cash Basis and Accrual Basis of Accounting.
Determine the importance of auditing and internal controls.
Key Points:
An effective accounting system is crucial to the financial tracking of system
revenues and expenses and to the prevention of fraud and misuse of system
funds.
An understanding of financial reports is necessary for the board when planning
for the system’s future finances.
Many governmental entities and utilities (water systems) track revenue on a cash
basis; however, most will be required to move to an accrual basis.
The three main financial reports are the Income Statement, Statement of Cash
Flows, and the Balance Sheet.
Auditing and internal controls help to prevent the misuse of system funds.
PowerPoint presentation
Laptop
Projector
Training Module 5 Workbooks
Flipchart and markers (optional)
Organize workbooks so that they can be passed out to participants prior to the
start of the training. To save time and keep your audience focused, try to plan for
and minimize any possible disruptions and transitions between activities.
1
After opening the PowerPoint file, the slide show can be viewed by selecting the
“View Show” command under the “Slide Show” menu button. The slide show can
be ended with “Esc”. Slides can be advanced with “Enter”, “PgDn”, the down
arrow or the right arrow. You can go back to the previous slides with
“Backspace”, the up arrow or the left arrow.
2
Training Module 5
Basics of Accounting and Finance for Small Water
Systems
Objectives:
Introduction
#1
Instructor Note: Display Slide # 1.
3
Components of a Balance Sheet, Income Statement and
Statement of Cash Flows;
Difference between the Cash Basis and Accrual Basis of
Accounting; and
Importance of auditing and internal controls.
Q: Why should you care about the accounting and finances of the
system?
Definitions
#2
Instructor Note: Display Slide #2.
To do this, let’s start with a few basic terms that you need to know.
4
#3
Instructor Note: Display Slide #3.
Assets are resources that are expected to increase future cash flows
into the system or reduce the cash flows out.
#4
Instructor Note: Display Slide #4.
#5
Instructor Note: Display Slide #5.
5
An example is electrical use in pumping water.
#6
Instructor Note: Display Slide #6.
#7
Instructor Note: Display Slide #7. Provide a maximum of 5
minutes for the learners to complete the exercise. Review the
answers to the exercise afterward.
Answers
1. Electricity (Expense)
2. Pump station (Asset)
3. Meters (Asset)
4. Salaries (Expense)
6
Now that we’ve reviewed or discussed some of the basics, let’s
discuss some aspects of accounting systems.
• Income Measurement
• Chart of Accounts
• Data Management
• Financial Reporting
• Internal Controls
• Auditing
#9
Instructor Note: Display Slide #9.
While there are several ways to measure, there are two main ways to
measure Income that will be covered here.
7
Many small water systems use the cash method for reporting to the
board. However, the accrual basis is used during the preparation of
an annual audit.
#10
Instructor Note: Display Slide #10.
#11
Instructor Note: Display Slide #11.
8
customer (when the revenue is earned), not when the customer
eventually pays (when the revenue is realized).
From a practical standpoint, you record Revenue when bills are sent
and record Expenses when bills are received.
#12
Instructor Note: Display Slide #12.
9
#13
Instructor Note: Display Slide #13.
#14
Instructor Note: Display Slide #14.
This data will likely be best managed through the use of an electronic
ledger. Most existing programs provide preset templates and charts
of accounts and there are many good software programs out there
that are used extensively such as QuickBooks and Peach Tree as
well as many proprietary systems. Some things to consider when
choosing an electronic ledger:
10
#15
Instructor Note: Display Slide #15.
The other way to manage the data from your accounting system is to
use a paper ledger. Consider the following:
• Low cost
• Requires math and accounting skills
Only very small systems should use this type of ledger system where
the purchase of computer equipment and software would be
prohibitively expensive.
#16
Instructor Note: Display Slide #16. Provide a maximum of 15
minutes for learners to complete the exercise. Review the answers to
the exercise afterward. Additionally, it may be a good time to allow
the learners a 10 minute break following the review of the exercise.
11
3. You send out water samples for testing on 9-30. The lab
sends you results and a bill on 10-15. The water system
sends the lab a check on 11-01.
a. Cash Basis – (Answer: 11-01)
b. Accrual Basis – (Answer: 10-15)
4. Your engineer agrees to do an environmental report on 5-02
and completes work on 6-15. He submits his results and a
bill on 6-22. The engineer is paid on 7-01.
a. Cash Basis – (Answer: 7-01)
b. Accrual Basis – (Answer: 6-22)
5. Water bills are generated and sent to customers on 1-15.
Payments are received on 1-30.
a. Cash Basis – (Answer: 1-30)
b. Accrual Basis – (Answer: 1-15)
How did everyone do? These were just some basic examples.
Financial Statements
#17
Instructor Note: Display Slide #17.
Now that you know some of the basics and are familiar with some
accounting terms, we’re going to discuss financial statements. The
four main types of financial statements are:
• Balance Sheet
• Income Statement
• Statement of Cash Flows
• Statement of Retained Earnings (dealing with stockholders)
12
The first three will be discussed further in this section. Since you are
not generally dealing with stockholders, you don’t need to worry too
much about the Statement of Retained Earnings.
#18
Instructor Note: Display Slide #18.
• Assets
• Liabilities
• Retained Earnings (RE)
The Liabilities section includes the debt of the system such as Loans
and Accounts Payable.
The RE section includes the net worth of the system after Liabilities
are subtracted from Assets.
#19
Instructor Note: Display Slide #19. Briefly run through the
components of the Balance Sheet in Appendix 1 with the learners.
13
#20
Instructor Note: Display Slide #20.
#21
Instructor Note: Display Slide #21. Briefly run through the
components of the Income Statement in Appendix 2 with the learners.
#22
Instructor Note: Display Slide #22.
14
The CF from Investing Activities includes Cash from changes in long
term assets and securities.
#23
Instructor Note: Display Slide #23. Briefly run through the
components of the Statement of Cash Flows in Appendix 3 with the
learners.
#24
Instructor Note: Display Slide #24.
Net Income from the Income Statement gets added to the Retained
Earnings on the Balance Sheet.
Ending cash balance on the Statement of Cash Flows goes onto the
current Balance Sheet.
15
#25
Instructor Note: Display Slide #25.
#26
Instructor Note: Display Slide #26. Provide a maximum of 15
minutes for learners to complete the exercise. Review the answers
afterward. Some questions have multiple answers. The amounts are
found on other sheets but with slightly different names. BS is the
Balance Sheet, IS is the Income Statement, and SCF is the
Statement of Cash Flows.
Statement: Amount:
1. Investment income: SCF (or BS) 2,178
2. Total operating revenue: IS 144,407
3. Loan interest expense: SCF (or BS) (17,983)
4. Accounts payable: BS 6,572
5. Salaries: IS 13,503
6. Ending cash balance: SCF (or BS) 92,540
7. Land: BS 13,535
16
8. Net income: IS 58,667
9. Total current assets: BS 101,485
10. Payroll taxes: IS 1,276
Controls
#27
Instructor Note: Display Slide #27.
#28
Instructor Note: Display Slide #28.
You can also maintain internal control through review and approval
such as the following:
17
The board is ultimately responsible for ensuring that internal controls
are in place and effective, not the employees.
#29
Instructor Note: Display Slide #29.
Summary
#31
Instructor Note: Display Slide #31. Provide a maximum of 10
minutes for the learners to complete the exercise. Review the
answers afterward.
18
Fill In-the Blank
9. Three main parts of the Balance Sheet are Assets, Liabilities, and
Retained Earnings.
19
#32
Instructor Note: Display Slide #32.
#33
Instructor Note: Display Slide #33.
The following are references and resources you can use when you
need additional information on the topics presented today.
20
The complete list of training modules includes:
Module 1, Water Supply System Basic Operations
Module 2, Responsibilities of Governing Boards
Module 3, The Safe Drinking Water Act
Module 4, Dealing with Consultants, Technical Assistance
Providers, Regulators, and Funding Agencies
Module 5, The Basics of Accounting and Finance for Small
Water Systems
Module 6, Business Planning for Small Water Systems
Module 7, Budgeting and Capital Improvements Planning
Overview for Small Water Systems
Module 8, Rate Design Overview for Small Water Systems
Module 9, Bidding, Purchasing, and Leasing
Module 10, Project Management Overview for Small Water
Systems
21
Appendix 1
Assets
CURRENT ASSETS
Cash and cash equivalents $ 92,540
Accounts receivable 8,945
RETAINED EARNINGS
22
Appendix 2
INCOME STATEMENT
Year ended 12-31-02
OPERATING REVENUE
Water billing $ 136,572
Tap-in and inspection fees 7,835
OPERATING EXPENSES
Salaries $ 13,503
Advertising 78
Professional Services 6,014
Depreciation 22,671
Office Expense 1,041
Plant operation 14,789
Insurance 703
Payroll Taxes 1,276
Repair and maintenance 875
Supplies 1,463
Travel 159
Utilities 6,794
Miscellaneous 569
23
Appendix 3
24