PREPARED 08/06/2018, 11:32:13 2018 BALANCE SHEET PAGE …

PREPARED 08/06/2018, 11:32:13

2018 BALANCE SHEET

PAGE

1

PROGRAM GM263L

ACCOUNTING PERIOD 10/2018

CITY OF EXCELSIOR SPRINGS

AS OF 07/31/2018

------------------------------------------------------------------------------------------------------------------------------------

101 GENERAL FUND

DEBITS

CREDITS

------------------------------------------------------------------------------------------------------------------------------------

ASSETS

101.01-00 101.02-01 101.02-03 101.02-04 101.02-11 101.02-12 101.02-14 101.02-15 101.03-01 101.03-02 101.03-03 101.03-07 101.03-20 102.09-00 103.01-01 103.01-03 103.01-06 103.01-07 105.03-01 105.03-02 105.03-03 105.03-04 107.01-01 107.01-02 107.01-03 109.01-00 109.02-00 109.03-00 109.10-00 115.01-00 115.02-00 115.03-00 115.04-00 121.01-00 121.02-00 121.03-00 122.01-00 126.01-00 126.02-00 143.01-00 143.02-00 152.07-00 152.08-00 152.10-00 152.11-00 152.14-00 152.15-00 152.16-00 152.17-00 152.99-00

CASH / PETTY CASH POOLED CASH PARTICIPATION / RECEIPT/DISBURS ACCOUNT POOLED CASH PARTICIPATION / POLICE TRAINING POOLED CASH PARTICIPATION / COMMUNITY SERVICE PROGR POOLED CASH PARTICIPATION / TRAFFIC SIGNAL ENFORCEM POOLED CASH PARTICIPATION / CREDIT CARD RECEIPTS POOLED CASH PARTICIPATION / INMATE SECURITY FUND POOLED CASH PARTICIPATION / JUDICIAL EDUCATION FUND PROTECTED/RESTRICTED CASH / AMBULANCE DEPOSITS PROTECTED/RESTRICTED CASH / POLICE REWARD FUNDS PROTECTED/RESTRICTED CASH / MUNICIPAL COURT FUNDS PROTECTED/RESTRICTED CASH / DWI RECOUPMENT PROTECTED/RESTRICTED CASH / CONSTRUCTION FUNDS CASH WITH FISCAL AGENT / ESCROW ACCOUNT CITY OWNED / FINANCIAL INVESTMENTS CITY OWNED / T-BILL USED AS COLLATERAL CITY OWNED / CERTIFICATES OF DEP (UMB) CITY OWNED / POOLED CDS FRANCHISE TAXES / CABLE FRANCHISE TAXES / ELECTRIC FRANCHISE TAXES / TELEPHONE FRANCHISE TAXES / GAS PROPERTY TAXES / REAL ESTATE TAXES PROPERTY TAXES / PERSONAL PROPERTY TAXES PROPERTY TAXES / BAD DEBTS ALLOW-PROP TAX INT & PENALTIES REC / INT & PENALTIES-TAX MODUL INT & PENALTIES REC / INT & PENALTIES-UTILITIES INT & PENALTIES REC / BAD DEBT ALLOW-INT & PEN INT & PENALTIES REC / ACCRUED INVESTMENT INT ACCOUNTS RECEIVABLE / CONTRACT AMBULANCE ACCOUNTS RECEIVABLE / BAD DEBT ALLOW-AMBULANCE ACCOUNTS RECEIVABLE / COURT FINES & FEES ACCOUNTS RECEIVABLE / BAD DEBT ALLOW-COURT FINE SPECIAL ASSESSMENTS REC / DEMOLITIONS SPECIAL ASSESSMENTS REC / MOWING ASSESSMENTS SPECIAL ASSESSMENTS REC / BAD DEBT ALLOW-SP ASSESS EMPLOYEE RECEIVABLES / RESIDENCY INCENTIVE INTERGOVERNMENT RECEIVABL / GRANT RELATED INTERGOVERNMENT RECEIVABL / TAX RELATED PREPAID ITEMS / POSTAGE PREPAID ITEMS / INSURANCE ADVANCE TO OTHER FUNDS / ADVANCE TO GOLF ADVANCE TO OTHER FUNDS / ADVANCE TO AIRPORT ADVANCE TO OTHER FUNDS / ADVANCE TO CONSTR SERVICE ADVANCE TO OTHER FUNDS / ADVANCE TO COMM DEVELOP ADVANCE TO OTHER FUNDS / ELMS TIF ADVANCE TO OTHER FUNDS / VINTAGE PLAZA II TIF ADVANCE TO OTHER FUNDS / COMMUNITY CENTER OPER ADVANCE TO OTHER FUNDS / POLLUTION CONTROL ADVANCE TO OTHER FUNDS / OTHER FUNDS

1,923.62 721,874.48

1,624.98 .00 .00 .00

27,640.42 6,045.00 .00 1,088.41

32,432.50 65,140.00 25,362.74

.00 480,000.00 250,000.00 245,000.00 388,000.00

.00

.00 5,302.04 20,128.02

263.19 3,759.90

.00 306,537.53

.00 .00 .00 1,602.42

.00 .00 190.94

371,040.52 484,360.31

52,520.23 38,305.43

.00 .00 .00 69,143.61 941,194.40 .00

2,422.03 15,079.93

27,218.38 2,740.10

144,000.00

4,091.57

1,147.02

PREPARED 08/06/2018, 11:32:13

2018 BALANCE SHEET

PAGE

2

PROGRAM GM263L

ACCOUNTING PERIOD 10/2018

CITY OF EXCELSIOR SPRINGS

AS OF 07/31/2018

------------------------------------------------------------------------------------------------------------------------------------

101 GENERAL FUND

DEBITS

CREDITS

------------------------------------------------------------------------------------------------------------------------------------

TOTAL ASSETS

4,343,781.66

LIABILITIES

202.01-00 202.01-20 202.02-00 202.03-00 202.05-00 202.06-00 202.08-00 202.09-00 202.10-00 202.70-00 202.94-00 203.01-00 203.02-00 203.03-00 203.04-00 204.01-01 204.01-02

CURRENT PAYABLES / ACCOUNTS PAYABLE ACCOUNTS PAYABLE / ACCRUED ACCOUNTS PAYABLE CURRENT PAYABLES / COURT BONDS HELD CURRENT PAYABLES / CRIME VICTIMS COMP FUND CURRENT PAYABLES / STATE POLICE TRAINING CURRENT PAYABLES / SAFE HAVEN CURRENT PAYABLES / COUNTY SHERIFF'S RET FUND CURRENT PAYABLES / TRAFFIC ENFORCEMENT FEES CURRENT PAYABLES / TRAFFIC REFUNDS DUE CURRENT PAYABLES / PERFORMANCE BOND HELD CURRENT PAYABLES / SUSPENSE A/C - TX COMPENSATED ABSENCES / ACCRUED VACATION COMPENSATED ABSENCES / ACCRUED SICK LEAVE COMPENSATED ABSENCES / ACCRUED COMP TIME COMPENSATED ABSENCES / ACCRUED P/S OVERTIME PROPERTY TAXES / REAL ESTATE TAXES PROPERTY TAXES / PERSONAL PROPERTY TAXES

TOTAL LIABILITIES

1,761.29 1,366.45

68.00

3,653.21 89,141.54

6,216.61

32,432.50 29,534.17

322.11

.00 .00 440.29 23,211.35 5,444.49

17,213.39

.00

19,538.96 =============

25,930.16

FUND EQUITY

244.01-00

ENCUMBRANCE RESERVES / RES FOR ENCUMBRANCES

244.02-00

ENCUMBRANCE RESERVES / P/Y RES FOR ENCUMBRANCES

252.00-00

EQUITY/FUND BALANCE / RESERVED - BRD DESIGNATED

FUND BALANCE

TOTAL FUND EQUITY

8,571.56 25,680.67 339,246.21 3,944,353.06 ============= 4,317,851.50

TOTAL LIABILITIES AND FUND EQUITY

4,343,781.66

PREPARED 08/06/2018, 11:32:13

2018 BALANCE SHEET

PAGE

3

PROGRAM GM263L

ACCOUNTING PERIOD 10/2018

CITY OF EXCELSIOR SPRINGS

AS OF 07/31/2018

------------------------------------------------------------------------------------------------------------------------------------

210 PARKS & RECREATION

DEBITS

CREDITS

------------------------------------------------------------------------------------------------------------------------------------

ASSETS

101.01-00 101.02-01 101.02-13 101.03-20 107.01-01 107.01-02 107.01-03 121.02-00 126.02-00 164.00-00

CASH / PETTY CASH POOLED CASH PARTICIPATION / RECEIPT/DISBURS ACCOUNT POOLED CASH PARTICIPATION / CREDIT CARD RECEIPTS PROTECTED/RESTRICTED CASH / CONSTRUCTION FUNDS PROPERTY TAXES / REAL ESTATE TAXES PROPERTY TAXES / PERSONAL PROPERTY TAXES PROPERTY TAXES / BAD DEBTS ALLOW-PROP TAX SPECIAL ASSESSMENTS REC / MOWING ASSESSMENTS INTERGOVERNMENT RECEIVABL / TAX RELATED FIXED ASSETS / OPERATING MACH & EQUIP

100.00 517,416.88

.00 7,836.59 6,466.92 12,936.54

2,900.39 .00 .00

10,661.24

TOTAL ASSETS

536,996.08

LIABILITIES

202.01-00 202.01-20 202.70-00 202.79-00 202.80-00 203.01-00 203.02-00 203.03-00 204.01-01 204.01-02

CURRENT PAYABLES / ACCOUNTS PAYABLE ACCOUNTS PAYABLE / ACCRUED ACCOUNTS PAYABLE CURRENT PAYABLES / PERFORMANCE BOND HELD CURRENT PAYABLES / UNEARNED FEES -GIFT CARDS CURRENT PAYABLES / COMM CENTER DEPOSITS COMPENSATED ABSENCES / ACCRUED VACATION COMPENSATED ABSENCES / ACCRUED SICK LEAVE COMPENSATED ABSENCES / ACCRUED COMP TIME PROPERTY TAXES / REAL ESTATE TAXES PROPERTY TAXES / PERSONAL PROPERTY TAXES

TOTAL LIABILITIES

78.05 4,780.12

44.91 94.52

2,819.53

3,650.36

478.55 2,729.02

775.99

12,504.70 =============

17,960.55

FUND EQUITY

244.01-00

ENCUMBRANCE RESERVES / RES FOR ENCUMBRANCES

244.02-00

ENCUMBRANCE RESERVES / P/Y RES FOR ENCUMBRANCES

FUND BALANCE

TOTAL FUND EQUITY

.00 1,640.80 517,394.73 ============= 519,035.53

TOTAL LIABILITIES AND FUND EQUITY

536,996.08

PREPARED 08/06/2018, 11:32:13

2018 BALANCE SHEET

PAGE

4

PROGRAM GM263L

ACCOUNTING PERIOD 10/2018

CITY OF EXCELSIOR SPRINGS

AS OF 07/31/2018

------------------------------------------------------------------------------------------------------------------------------------

211 E-911 PHONE TAX

DEBITS

CREDITS

------------------------------------------------------------------------------------------------------------------------------------

ASSETS

101.02-01 126.03-00

POOLED CASH PARTICIPATION / RECEIPT/DISBURS ACCOUNT INTERGOVERNMENT RECEIVABL / PHONE TAX RECEIVABLE

6,733.37 1,487.42

TOTAL ASSETS

8,220.79

LIABILITIES

202.01-00 202.01-20

CURRENT PAYABLES / ACCOUNTS PAYABLE ACCOUNTS PAYABLE / ACCRUED ACCOUNTS PAYABLE

TOTAL LIABILITIES

.00 .00 ============= .00

FUND EQUITY

244.01-00

ENCUMBRANCE RESERVES / RES FOR ENCUMBRANCES

FUND BALANCE

TOTAL FUND EQUITY

.00 8,220.79 ============= 8,220.79

TOTAL LIABILITIES AND FUND EQUITY

8,220.79

PREPARED 08/06/2018, 11:32:13

2018 BALANCE SHEET

PAGE

5

PROGRAM GM263L

ACCOUNTING PERIOD 10/2018

CITY OF EXCELSIOR SPRINGS

AS OF 07/31/2018

------------------------------------------------------------------------------------------------------------------------------------

212 EQUITABLE SHARING FUND

DEBITS

CREDITS

------------------------------------------------------------------------------------------------------------------------------------

ASSETS

101.02-01

POOLED CASH PARTICIPATION / RECEIPT/DISBURS ACCOUNT

121,343.64

TOTAL ASSETS

121,343.64

LIABILITIES

202.01-00

CURRENT PAYABLES / ACCOUNTS PAYABLE TOTAL LIABILITIES

.00 =============

.00

FUND EQUITY

244.01-00

ENCUMBRANCE RESERVES / RES FOR ENCUMBRANCES

244.02-00

ENCUMBRANCE RESERVES / P/Y RES FOR ENCUMBRANCES

FUND BALANCE

TOTAL FUND EQUITY

5,419.52

.00 126,763.16 ============= 121,343.64

TOTAL LIABILITIES AND FUND EQUITY

121,343.64

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download