| Crane Lake Water &
Sanitary District PROFIT & LOSS YTD COMPARISON June 2020 | |
| Administrative | E. S. Area | G.C. Operating | Debt Service | TOTAL | | Jun 20 | Jan – Jun 20 | Jun 20 | Jan – Jun 20 | Jun 20 | Jan – Jun 20 | Jun 20 | Jan – Jun 20 | Jun 20 | Jan – Jun 20 | | Ordinary Income/Expense | | Income | | 301-Base/Volume Charges | | GC Base Charges | 0.00 | 0.00 | 0.00 | 0.00 | 12,415.10 | 78,760.60 | 0.00 | 0.00 | 12,415.10 | 78,760.60 | | GC Volume Charge | 0.00 | 0.00 | 0.00 | 0.00 | 2,376.77 | 12,689.25 | 0.00 | 0.00 | 2,376.77 | 12,689.25 | | Late Fees | 0.00 | 0.00 | 0.00 | 0.00 | -57.60 | 317.61 | 0.00 | 0.00 | -57.60 | 317.61 | | Total 301-Base/Volume
Charges | 0.00 | 0.00 | 0.00 | 0.00 | 14,734.27 | 91,767.46 | 0.00 | 0.00 | 14,734.27 | 91,767.46 | | 304-Service Connections | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 350.00 | 0.00 | 350.00 | | Total Income | 0.00 | 0.00 | 0.00 | 0.00 | 14,734.27 | 91,767.46 | 0.00 | 350.00 | 14,734.27 | 92,117.46 | | Expense | | 514-Chemicals | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3,000.00 | 0.00 | 0.00 | 0.00 | 3,000.00 | | 518-Dues and
Subscriptions | 275.40 | 756.36 | 0.00 | 0.00 | 0.00 | 50.00 | 0.00 | 0.00 | 275.40 | 806.36 | | 528-Licenses and Permits | 0.00 | 0.00 | 520.00 | 520.00 | 0.00 | 505.00 | 0.00 | 0.00 | 520.00 | 1,025.00 | | 534-Office Supplies | 94.84 | 1,354.52 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 94.84 | 1,354.52 | | 535-Postage and Delivery | 0.00 | 440.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 440.00 | | 537-Professional Fees | | Accounting | 0.00 | 15,510.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 15,510.00 | | Consulting | 1,250.00 | 8,350.00 | 750.00 | 750.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2,000.00 | 9,100.00 | | Engineering | 0.00 | 0.00 | 0.00 | 981.06 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 981.06 | | Legal | 1,797.12 | 6,337.47 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,797.12 | 6,337.47 | | Total 537-Professional
Fees | 3,047.12 | 30,197.47 | 750.00 | 1,731.06 | 0.00 | 0.00 | 0.00 | 0.00 | 3,797.12 | 31,928.53 | | 539- Payroll Taxes | | FICA | 109.85 | 682.09 | 0.00 | 0.00 | 428.23 | 1,329.34 | 0.00 | 0.00 | 538.08 | 2,011.43 | | Medicare | 25.69 | 159.52 | 0.00 | 0.00 | 100.15 | 310.90 | 0.00 | 0.00 | 125.84 | 470.42 | | MN Unemployment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 22.19 | 0.00 | 0.00 | 0.00 | 22.19 | | Total 539- Payroll Taxes | 135.54 | 841.61 | 0.00 | 0.00 | 528.38 | 1,662.43 | 0.00 | 0.00 | 663.92 | 2,504.04 | | 539A-PERA | 127.20 | 791.04 | 0.00 | 0.00 | 297.90 | 1,321.20 | 0.00 | 0.00 | 425.10 | 2,112.24 | | 545-Repairs | | GC Repairs | 0.00 | 0.00 | 3,623.29 | 3,623.29 | 1,292.40 | 11,013.37 | 0.00 | 0.00 | 4,915.69 | 14,636.66 | | Total 545-Repairs | 0.00 | 0.00 | 3,623.29 | 3,623.29 | 1,292.40 | 11,013.37 | 0.00 | 0.00 | 4,915.69 | 14,636.66 | | 550-Snowplowing/Lawn Care | 0.00 | 0.00 | 0.00 | 0.00 | 350.00 | 350.00 | 0.00 | 0.00 | 350.00 | 350.00 | | 559-Supplies-GC Plant | 0.00 | 0.00 | 0.00 | 0.00 | 24.96 | 533.19 | 0.00 | 0.00 | 24.96 | 533.19 | | 561-Technical Services | | Daily on Site | 0.00 | 0.00 | 880.00 | 880.00 | 2,172.50 | 2,172.50 | 0.00 | 0.00 | 3,052.50 | 3,052.50 | | Non Routine/Emergency | 0.00 | 0.00 | 0.00 | 0.00 | 384.00 | 2,356.00 | 0.00 | 0.00 | 384.00 | 2,356.00 | | Technical-Routine | 0.00 | 0.00 | 0.00 | 0.00 | 940.00 | 6,110.00 | 0.00 | 0.00 | 940.00 | 6,110.00 | | Total 561-Technical
Services | 0.00 | 0.00 | 880.00 | 880.00 | 3,496.50 | 10,638.50 | 0.00 | 0.00 | 4,376.50 | 11,518.50 | | 562-Telephone | 86.57 | 520.62 | 0.00 | 0.00 | 181.58 | 1,093.45 | 0.00 | 0.00 | 268.15 | 1,614.07 | | 563-Travel & Ent | 0.00 | 0.00 | 0.00 | 0.00 | 305.90 | 2,378.36 | 0.00 | 0.00 | 305.90 | 2,378.36 | | 565-Utilities | | Culvert | 0.00 | 0.00 | 0.00 | 0.00 | 46.00 | 1,219.00 | 0.00 | 0.00 | 46.00 | 1,219.00 | | Electric Lift | 0.00 | 0.00 | 0.00 | 0.00 | 175.75 | 1,248.77 | 0.00 | 0.00 | 175.75 | 1,248.77 | | Electric Plant | 0.00 | 0.00 | 0.00 | 0.00 | 786.53 | 7,908.83 | 0.00 | 0.00 | 786.53 | 7,908.83 | | H Road | 0.00 | 0.00 | 0.00 | 0.00 | 51.00 | 359.47 | 0.00 | 0.00 | 51.00 | 359.47 | | Waters Edge Manhole | 0.00 | 0.00 | 0.00 | 0.00 | 50.47 | 1,324.49 | 0.00 | 0.00 | 50.47 | 1,324.49 | | White Pines Manhole | 0.00 | 0.00 | 0.00 | 0.00 | 45.10 | 403.07 | 0.00 | 0.00 | 45.10 | 403.07 | | Total 565-Utilities | 0.00 | 0.00 | 0.00 | 0.00 | 1,154.85 | 12,463.63 | 0.00 | 0.00 | 1,154.85 | 12,463.63 | | 751-Interest Expense | 0.00 | 0.00 | 0.00 | 133.34 | 0.00 | 639.36 | 0.00 | 30,737.89 | 0.00 | 31,510.59 | | Payroll Expenses | 1,771.75 | 11,001.50 | 0.00 | 0.00 | 6,907.00 | 21,441.00 | 0.00 | 0.00 | 8,678.75 | 32,442.50 | | Total Expense | 5,538.42 | 45,903.12 | 5,773.29 | 6,887.69 | 14,539.47 | 67,089.49 | 0.00 | 30,737.89 | 25,851.18 | 150,618.19 | | Net Ordinary Income | -5,538.42 | -45,903.12 | -5,773.29 | -6,887.69 | 194.80 | 24,677.97 | 0.00 | -30,387.89 | -11,116.91 | -58,500.73 | | Other Income/Expense | | Other Income | | 702-St Louis
Cnty-Property Tax | 0.00 | 722.46 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 722.46 | | 703-Special Assessments
Revenue | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,118.69 | 0.00 | 1,118.69 | | 709-Fiscal Disparity
Payments | 0.00 | 3.29 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.29 | | 710-Refunds | 0.00 | 107.40 | 0.00 | 0.00 | 0.00 | 250.60 | 0.00 | 0.00 | 0.00 | 358.00 | | 729-MN PCA-Legacy | 0.00 | 0.00 | 0.00 | 836.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 836.00 | | Interest Income | 0.00 | 0.00 | 0.00 | 0.00 | 99.79 | 799.86 | 0.00 | 230.05 | 99.79 | 1,029.91 | | Total Other Income | 0.00 | 833.15 | 0.00 | 836.00 | 99.79 | 1,050.46 | 0.00 | 1,348.74 | 99.79 | 4,068.35 | | Net Other Income | 0.00 | 833.15 | 0.00 | 836.00 | 99.79 | 1,050.46 | 0.00 | 1,348.74 | 99.79 | 4,068.35 | | Net
Income | -5,538.42 | -45,069.97 | -5,773.29 | -6,051.69 | 294.59 | 25,728.43 | 0.00 | -29,039.15 | -11,017.12 | -54,432.38 |
|
