FY 18 Annual Report

2018

ANNUAL FINANCIAL SUMMARY CITY OF SPENCER, IOWA

SUMMARY OF BANK ACCOUNTS Total Cash Transactions of all funds for the period July 1, 2017 through June 30, 2018, excluding Spencer Municipal Utilities and Spencer Hosptial Accounts.

$ 29,897,492.56 41,240,304.49 $

CITY CLERK'S BOOK BALANCE JULY 1, 2017 PLUS: Receipts for Year Ending June 30, 2018 TOTAL TO ACCOUNT FOR: LESS: Disbursements for Year Ending June 30, 2018

71,137,797.05

38,554,378.57

32,583,418.48

CITY CLERK'S BOOK BALANCE JUNE 30, 2018

141,370.12 (5,300.00) (34,081.48) (13,016,948.97) (5,417.35) -

PLUS: Warrants Outstanding

LESS: Petty Cash LESS: Police Forfeiture Acct- Farmers Bank LESS: Investments LESS: Outstanding Deposit/Wire

LESS: Adjustment

$ 19,663,040.80

RECONCILED CASH BALANCE OF ALL FUNDS IN FARMERS BANK CHECKING ACCOUNT: June 30, 2018

STATEMENT OF BANK BALANCES AND SECURITIES As of June 30, 2018 (Excluding Spencer Municipal Utilities and Spencer Hospital)

$ 19,663,040.80 505,642.87 12,511,306.10

Checking

IMMIA

ICS

INVESTMENTS - CERTIFICATE OF DEPOSITS: Farmers Bank CSI - Escrow/Wells Fargo

- -

-

TOTAL INVESTMENTS

TOTAL BANK BALANCES AND SECURITIES

$ 32,679,989.77

20