Loading...
HomeMy WebLinkAbout[04b] Financial Reports EDA Agenda Item 4 (b) MEETING DATE: November 19, 2019 AGENDA ITEM: October Finance Reports SUBMITTED BY: Finance BOARD/COMMISSION/COMMITTEE/COUNCIL RECOMMENDATION: N/A PREVIOUS EDA ACTION: None BACKGROUND INFORMATION: Enclosed you will find the reconciled financial reports through October 31, 2019. The ending undesignated balance shows a deficit of $14,200. The designated project balance is $55,933. The capital designated balance includes 2019 capital budget balance of $44,100. The budget is covered by property taxes. The second half taxes will be received in December. The undesignated fund balance is a surplus of $29,900 without showing the 2019 capital budget. In addition, the CDBG DEED grant reimbursement for the draw #4 was paid, but not received by the State as of 10/31/19. The State reimbursed draw #4 in Nov for $23,814; resulting in an increase in the fund balance. The other funds reported include the TIF funds, Lodging Tax, DEED CDAP Grant reimbursement and the Revolving Loan fund. There is one new revolving loan for Krewe and Flour to Flower Bakery. Payments st begin Dec. 1 on the new RLF Loan. The current, revolving loan fund balance is $166,981 at October st 31, including $136,714 reserved balance from the EDA fund to be used for future economic development. $30,267 is available from the State’s RLF fund for future loan requests. st The Lodging Tax fund has a balance of $33,937 on October 31. rd Finally, the 3 quarter expense reports are due for ad hoc board members. BUDGET/FISCAL IMPACT: For Information Only ATTACHMENTS: Request for EDA Action – Finance Reports EDA Financial Summary EDA Balance Sheet EDA Check Register EDA Revenue Report EDA Expenditure Report EDA Summary CIP Expense Report Form REQUESTED BOARD ACTION: Consider acceptance of the October financial reports. YTDYTDCurrent FUND DescrAccount DescrBegin YrDebitCreditBalance FUND 150 Economic Development Economic DevelopmentG 150-10100 Cash$58,897.49$278,359.52$306,324.06$30,932.95 Economic DevelopmentG 150-10450 Interest Receivable$55.81$0.00$55.81$0.00 Economic DevelopmentG 150-10500 Accounts Receivable$0.00$0.00$0.00$0.00 Economic DevelopmentG 150-10700 Taxes Receivable - Delinquen$921.82$0.00$921.82$0.00 Economic DevelopmentG 150-13113 Due From other Gov t Units$704.77$0.00$704.77$0.00 Economic DevelopmentG 150-15500 Due From Other Fund$10,800.00$0.00$0.00$10,800.00 Economic DevelopmentG 150-20200 Accounts Payable-$8,109.70$8,109.70$0.00$0.00 Economic DevelopmentG 150-20201 Salaries Payable-$1,457.32$1,457.32$0.00$0.00 Economic DevelopmentG 150-22204 Deferred Inflow of Resources-$921.82$921.82$0.00$0.00 Economic DevelopmentG 150-24415 Design. Fd Bal - Operations-$22,009.92$0.00$0.00-$22,009.92 Economic DevelopmentG 150-25310 Unassigned Fund Balance-$38,881.13$307,084.64$287,926.54-$19,723.03 FUND 150 Economic Development$0.00$595,933.00$595,933.00$0.00 FUND 152 TIF 3-1 CMCU TIF 3-1 CMCUG 152-10100 Cash$183.67$37,639.41$36,383.04$1,440.04 TIF 3-1 CMCUG 152-10450 Interest Receivable$14.98$0.00$14.98$0.00 TIF 3-1 CMCUG 152-10500 Accounts Receivable$0.00$0.00$0.00$0.00 TIF 3-1 CMCUG 152-20200 Accounts Payable$0.00$0.00$0.00$0.00 TIF 3-1 CMCUG 152-20500 Due To Other Fund-$500.00$0.00$0.00-$500.00 TIF 3-1 CMCUG 152-25310 Unassigned Fund Balance$301.35$36,398.02$37,639.41-$940.04 FUND 152 TIF 3-1 CMCU$0.00$74,037.43$74,037.43$0.00 FUND 153 TIF 4-1 Fortitude Senior Apts TIF 4-1 Fortitude SeniorG 153-10100 Cash$4,527.85$40,887.90$41,469.34$3,946.41 TIF 4-1 Fortitude SeniorG 153-10450 Interest Receivable$11.58$0.00$11.58$0.00 TIF 4-1 Fortitude SeniorG 153-10500 Accounts Receivable$0.00$0.00$0.00$0.00 TIF 4-1 Fortitude SeniorG 153-20200 Accounts Payable$0.00$0.00$0.00$0.00 TIF 4-1 Fortitude SeniorG 153-20500 Due To Other Fund$0.00$0.00$0.00$0.00 TIF 4-1 Fortitude SeniorG 153-25310 Unassigned Fund Balance-$4,539.43$41,480.92$40,887.90-$3,946.41 FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$82,368.82$82,368.82$0.00 FUND 157 TIF 2-1 Millstream TIF 2-1 MillstreamG 157-10100 Cash$25,642.09$38,881.95$36,622.18$27,901.86 TIF 2-1 MillstreamG 157-10450 Interest Receivable$90.55$0.00$90.55$0.00 TIF 2-1 MillstreamG 157-10500 Accounts Receivable$0.00$0.00$0.00$0.00 TIF 2-1 MillstreamG 157-13113 Due From other Gov t Units$340.80$0.00$340.80$0.00 TIF 2-1 MillstreamG 157-20200 Accounts Payable-$306.72$306.72$0.00$0.00 TIF 2-1 MillstreamG 157-25310 Unassigned Fund Balance-$25,766.72$37,053.53$39,188.67-$27,901.86 FUND 157 TIF 2-1 Millstream$0.00$76,242.20$76,242.20$0.00 FUND 158 TIF 2-2 Meat Market TIF 2-2 Meat MarketG 158-10100 Cash$495.50$8,255.07$8,043.95$706.62 TIF 2-2 Meat MarketG 158-10450 Interest Receivable$1.79$0.00$1.79$0.00 TIF 2-2 Meat MarketG 158-20201 Salaries Payable$0.00$0.00$0.00$0.00 TIF 2-2 Meat MarketG 158-20500 Due To Other Fund-$500.00$0.00$0.00-$500.00 TIF 2-2 Meat MarketG 158-25310 Unassigned Fund Balance$2.71$8,045.74$8,255.07-$206.62 FUND 158 TIF 2-2 Meat Market$0.00$16,300.81$16,300.81$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat TIF 2-3 Bayou Blues/AllG 159-10100 Cash$1,278.12$20,104.96$21,122.60$260.48 TIF 2-3 Bayou Blues/AllG 159-10450 Interest Receivable$0.25$0.00$0.25$0.00 YTDYTDCurrent FUND DescrAccount DescrBegin YrDebitCreditBalance TIF 2-3 Bayou Blues/AllG 159-20200 Accounts Payable$0.00$0.00$0.00$0.00 TIF 2-3 Bayou Blues/AllG 159-20500 Due To Other Fund-$9,800.00$0.00$0.00-$9,800.00 TIF 2-3 Bayou Blues/AllG 159-25310 Unassigned Fund Balance$8,521.63$21,122.85$20,104.96$9,539.52 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$41,227.81$41,227.81$0.00 FUND 220 Lodging Tax Lodging TaxG 220-10100 Cash$30,334.72$15,558.46$11,956.50$33,936.68 Lodging TaxG 220-10450 Interest Receivable$91.25$0.00$91.25$0.00 Lodging TaxG 220-10500 Accounts Receivable$625.55$0.00$625.55$0.00 Lodging TaxG 220-25310 Unassigned Fund Balance-$31,051.52$12,673.30$15,558.46-$33,936.68 FUND 220 Lodging Tax$0.00$28,231.76$28,231.76$0.00 FUND 225 DEED CDAP Grant DEED CDAP GrantG 225-10100 Cash$34,945.69$16,657.79$12,500.00$39,103.48 DEED CDAP GrantG 225-10450 Interest Receivable$63.04$0.00$63.04$0.00 DEED CDAP GrantG 225-25310 Unassigned Fund Balance-$35,008.73$12,563.04$16,657.79-$39,103.48 FUND 225 DEED CDAP Grant$0.00$29,220.83$29,220.83$0.00 FUND 250 Revolving Loan Fund Revolving Loan FundG 250-10100 Cash$211,358.83$8,331.73$52,710.00$166,980.56 Revolving Loan FundG 250-10450 Interest Receivable$775.57$0.00$775.57$0.00 Revolving Loan FundG 250-11900 Notes Receivable$0.00$0.00$0.00$0.00 Revolving Loan FundG 250-22204 Deferred Inflow of Resources$0.00$0.00$0.00$0.00 Revolving Loan FundG 250-24415 Design. Fd Bal - Operations-$74,310.39$0.00$0.00-$74,310.39 Revolving Loan FundG 250-25310 Unassigned Fund Balance-$137,824.01$53,485.57$8,331.73-$92,670.17 FUND 250 Revolving Loan Fund$0.00$61,817.30$61,817.30$0.00 $0.001,005,379.961,005,379.96$0.00 CHECK #Search NameCommentsFUNDDEPARTAmount 054977RUBINSKI WORKSCVB commercial video22046500$1,500.00 054984CENTRAL MN HOUSING PARTNERSHIPhousing grant draw #315046500$3,038.00 054985CENTURYLINKT1 line/20 sets 229 #'s15046500$0.38 054995MIDCONTINENT COMMUNICATIONSfiber lines15046500$104.67 055000R BECK & SONS CONSTRUCTIONhousing grant draw #322546500$3,125.00 055000R BECK & SONS CONSTRUCTIONhousing grant draw #315046500$20,952.00 055001RENGEL PRINTING, INCLetterhead15046500$16.54 055053CENTURYLINKfinal payoff - close contract T1/15046500$160.02 055057LEAGUE OF MN CITIES INS TRUSTCDD15046500$124.45 055057LEAGUE OF MN CITIES INS TRUSTEDA15046500$4.10 055093RUBINSKI WORKSVideo Session22046500$2,000.00 055106BRUNO PRESSMarketing - Social Media Aug/S22046500$1,500.00 055158MIDCONTINENT COMMUNICATIONSFiber Lines15046500$105.27 055176Think Tourism USAFeatured Listings22046500$425.00 055185BRUNO PRESSOct CVB Social Media Marketin22046500$750.00 055201ST. CLOUD TIMESPH Property Tax Amendments15046500$166.35 055201ST. CLOUD TIMESPH Cities Grant Fund ( CDBG)15046500$109.09 055209KREWE RESTAURANTLoan Settlement25046500$51,975.00 055236RENGEL PRINTING, INCEnv #10 Window15046500$40.42 055254MIDCONTINENT COMMUNICATIONStelephone/fiber Sept15046500$103.85 055272MIKE DIRKES CONSTRUCTION, LLCCDAP Draw #4 project SJ-18-015046500$21,194.00 055291BRUNO PRESSNov CVB social media marketin22046500$750.00 05531487 LUMENSphotos LA Jam/Rolling Ridge B22046500$150.00 055318CENTRAL MN HOUSING PARTNERSHIPCDAP housing grant Draw #415046500$2,620.00 055322JOVANOVICH, KADLEC & ATHMANNRLF loans25046500$735.00 $111,649.14 2019October2019 Account DescrSOURCYTD Budget2019 AmtYTD Amt FUND 150 Economic Development R 150-46500-31010 Current Ad Valorem Taxes31010$111,240.00$0.00$52,795.34 R 150-46500-33160 Federal Grants - Other33160$178,625.00$0.00$62,056.00 R 150-46500-34150 TIF/MIF Deposit34150$0.00$0.00$500.00 R 150-46500-34160 Tax Abatement Reimbursement34160$0.00$0.00$7,208.00 R 150-46500-36210 Interest Earnings36210$850.00$28.28$1,283.48 R 150-49302-39201 Transfers from Other Funds39201$0.00$0.00$13,627.66 FUND 150 Economic Development$290,715.00$28.28$137,470.48 FUND 152 TIF 3-1 CMCU R 152-46500-31050 Tax Increment31050$0.00$0.00$22,058.86 R 152-46500-36210 Interest Earnings36210$0.00$0.69$93.33 R 152-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$0.00$0.69$22,152.19 FUND 153 TIF 4-1 Fortitude Senior Apts R 153-46500-31050 Tax Increment31050$0.00$0.00$23,899.28 R 153-46500-34150 TIF/MIF Deposit34150$0.00$0.00$0.00 R 153-46500-36210 Interest Earnings36210$0.00$1.92$213.88 R 153-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$1.92$24,113.16 FUND 157 TIF 2-1 Millstream R 157-46500-31050 Tax Increment31050$0.00$0.00$22,036.05 R 157-46500-36210 Interest Earnings36210$0.00$13.60$989.36 FUND 157 TIF 2-1 Millstream$0.00$13.60$23,025.41 FUND 158 TIF 2-2 Meat Market R 158-46500-31050 Tax Increment31050$0.00$0.00$4,829.91 R 158-46500-36210 Interest Earnings36210$0.00$0.34$35.65 R 158-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 158 TIF 2-2 Meat Market$0.00$0.34$4,865.56 FUND 159 TIF 2-3 Bayou Blues/Alley Flat R 159-46500-31050 Tax Increment31050$0.00$0.00$145.10 R 159-46500-36210 Interest Earnings36210$0.00$0.13$25.43 R 159-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$0.00$0.13$170.53 FUND 220 Lodging Tax R 220-46500-31600 Lodging Tax31600$14,000.00$1,207.07$13,669.87 R 220-46500-36210 Interest Earnings36210$100.00$16.88$1,171.79 FUND 220 Lodging Tax$14,100.00$1,223.95$14,841.66 FUND 225 DEED CDAP Grant R 225-46500-34200 DEED Housing Reimbursement34200$0.00$0.00$15,466.00 R 225-46500-36210 Interest Earnings36210$25.00$17.08$1,128.75 R 225-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 FUND 225 DEED CDAP Grant$25.00$17.08$16,594.75 FUND 250 Revolving Loan Fund R 250-46500-36210 Interest Earnings36210$100.00$107.18$7,556.16 R 250-49302-39201 Transfers from Other Funds39201$0.00$0.00$0.00 2019October2019 Account DescrSOURCYTD Budget2019 AmtYTD Amt R 250-46500-39320 Loan Principal39320$995.00$0.00$0.00 R 250-46500-39321 Loan Interest39321$5.00$0.00$0.00 R 250-46500-39322 Loan Origination Fee39322$0.00$0.00$0.00 FUND 250 Revolving Loan Fund$1,100.00$107.18$7,556.16 $305,940.00$1,393.17$250,789.90 2019October2019 Account DescrYTD Budget2019 AmtYTD Amt FUND 150 Economic Development E 150-46500-101 Salaries$28,325.00$616.52$20,891.26 E 150-46500-103 Legislative Bodies$1,260.00$0.00$280.00 E 150-46500-121 PERA Contributions$2,125.00$46.24$1,566.88 E 150-46500-122 FICA Contributions$1,710.00$36.83$1,252.37 E 150-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 150-46500-125 Medicare Contributions$400.00$8.61$292.92 E 150-46500-130 H S A- Employer Contribution$790.00$0.00$900.00 E 150-46500-131 Health Insurance$5,040.00$117.65$3,882.31 E 150-46500-132 Dental Insurance$415.00$9.64$317.98 E 150-46500-133 Life Insurance$25.00$1.27$21.52 E 150-46500-134 Disabilty Insurance$240.00$12.74$204.19 E 150-46500-151 Workers Comp. Insur. Prem.$155.00-$1.54$127.01 E 150-46500-171 Clothing Allowance$0.00$0.00$0.00 E 150-46500-200 Office Supplies$500.00$40.42$167.68 E 150-46500-215 Software Support$935.00$0.00$1,242.52 E 150-46500-300 Professional Services$0.00$0.00$0.00 E 150-46500-303 Engineering Fee$2,000.00$0.00$14,687.38 E 150-46500-304 Legal Fees$1,000.00$0.00$0.00 E 150-46500-308 Community Programs$178,625.00$23,814.00$85,870.00 E 150-46500-321 Telephone$475.00$103.85$766.66 E 150-46500-322 Postage$100.00$0.00$0.00 E 150-46500-328 Marketing$1,000.00$0.00$0.00 E 150-46500-331 Travel & Conference Expense$500.00$0.00$0.00 E 150-46500-340 Advertising$200.00$0.00$343.26 E 150-46500-433 Dues & Memberships$5,295.00$0.00$5,000.00 E 150-46500-582 Computer Software$500.00$0.00$0.00 E 150-46500-588 EDA Programs$44,100.00$0.00$4,579.72 E 150-46500-622 TIF/Abatement Payments$15,000.00$0.00$14,234.92 E 150-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 150 Economic Development$290,715.00$24,806.23$156,628.58 FUND 152 TIF 3-1 CMCU E 152-46500-101 Salaries$0.00$0.00$0.00 E 152-46500-121 PERA Contributions$0.00$0.00$0.00 E 152-46500-122 FICA Contributions$0.00$0.00$0.00 E 152-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 152-46500-125 Medicare Contributions$0.00$0.00$0.00 E 152-46500-132 Dental Insurance$0.00$0.00$0.00 E 152-46500-133 Life Insurance$0.00$0.00$0.00 E 152-46500-134 Disabilty Insurance$0.00$0.00$0.00 E 152-46500-300 Professional Services$0.00$0.00$990.00 E 152-46500-301 Audit & Accounting Services$750.00$0.00$0.00 E 152-46500-340 Advertising$45.00$0.00$67.83 E 152-46500-622 TIF/Abatement Payments$0.00$0.00$19,852.97 E 152-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 152 TIF 3-1 CMCU$795.00$0.00$20,910.80 FUND 153 TIF 4-1 Fortitude Senior Apts E 153-46500-101 Salaries$0.00$0.00$0.00 E 153-46500-121 PERA Contributions$0.00$0.00$0.00 2019October2019 Account DescrYTD Budget2019 AmtYTD Amt E 153-46500-122 FICA Contributions$0.00$0.00$0.00 E 153-46500-125 Medicare Contributions$0.00$0.00$0.00 E 153-46500-300 Professional Services$0.00$0.00$990.00 E 153-46500-340 Advertising$0.00$0.00$67.83 E 153-46500-588 EDA Programs$0.00$0.00$0.00 E 153-46500-622 TIF/Abatement Payments$0.00$0.00$21,509.35 E 153-49300-720 Transfers to Other Funds$0.00$0.00$2,139.00 FUND 153 TIF 4-1 Fortitude Senior Apts$0.00$0.00$24,706.18 FUND 157 TIF 2-1 Millstream E 157-46500-101 Salaries$0.00$0.00$0.00 E 157-46500-121 PERA Contributions$0.00$0.00$0.00 E 157-46500-122 FICA Contributions$0.00$0.00$0.00 E 157-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 157-46500-125 Medicare Contributions$0.00$0.00$0.00 E 157-46500-132 Dental Insurance$0.00$0.00$0.00 E 157-46500-133 Life Insurance$0.00$0.00$0.00 E 157-46500-134 Disabilty Insurance$0.00$0.00$0.00 E 157-46500-300 Professional Services$0.00$0.00$990.00 E 157-46500-301 Audit & Accounting Services$500.00$0.00$0.00 E 157-46500-340 Advertising$45.00$0.00$67.82 E 157-46500-622 TIF/Abatement Payments$34,000.00$0.00$19,832.45 E 157-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 157 TIF 2-1 Millstream$34,545.00$0.00$20,890.27 FUND 158 TIF 2-2 Meat Market E 158-46500-101 Salaries$0.00$0.00$0.00 E 158-46500-121 PERA Contributions$0.00$0.00$0.00 E 158-46500-122 FICA Contributions$0.00$0.00$0.00 E 158-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 158-46500-125 Medicare Contributions$0.00$0.00$0.00 E 158-46500-131 Health Insurance$0.00$0.00$0.00 E 158-46500-132 Dental Insurance$0.00$0.00$0.00 E 158-46500-133 Life Insurance$0.00$0.00$0.00 E 158-46500-134 Disabilty Insurance$0.00$0.00$0.00 E 158-46500-300 Professional Services$0.00$0.00$0.00 E 158-46500-301 Audit & Accounting Services$500.00$0.00$0.00 E 158-46500-340 Advertising$45.00$0.00$67.82 E 158-46500-622 TIF/Abatement Payments$4,000.00$0.00$4,588.41 FUND 158 TIF 2-2 Meat Market$4,545.00$0.00$4,656.23 FUND 159 TIF 2-3 Bayou Blues/Alley Flat E 159-46500-101 Salaries$0.00$0.00$0.00 E 159-46500-121 PERA Contributions$0.00$0.00$0.00 E 159-46500-122 FICA Contributions$0.00$0.00$0.00 E 159-46500-123 Deferred Comp-Employer$0.00$0.00$0.00 E 159-46500-125 Medicare Contributions$0.00$0.00$0.00 E 159-46500-132 Dental Insurance$0.00$0.00$0.00 E 159-46500-133 Life Insurance$0.00$0.00$0.00 E 159-46500-134 Disabilty Insurance$0.00$0.00$0.00 E 159-46500-300 Professional Services$0.00$0.00$990.00 E 159-46500-301 Audit & Accounting Services$750.00$0.00$0.00 2019October2019 Account DescrYTD Budget2019 AmtYTD Amt E 159-46500-340 Advertising$45.00$0.00$67.83 E 159-46500-622 TIF/Abatement Payments$0.00$0.00$130.59 E 159-49300-720 Transfers to Other Funds$0.00$0.00$0.00 FUND 159 TIF 2-3 Bayou Blues/Alley Flat$795.00$0.00$1,188.42 FUND 220 Lodging Tax E 220-46500-300 Professional Services$0.00$750.00$6,439.00 E 220-46500-309 Visitors Bureau$14,100.00$150.00$4,075.00 E 220-46500-328 Marketing$0.00$0.00$1,442.50 E 220-46500-340 Advertising$0.00$0.00$0.00 FUND 220 Lodging Tax$14,100.00$900.00$11,956.50 FUND 225 DEED CDAP Grant E 225-46500-300 Professional Services$12,500.00$0.00$12,500.00 E 225-46500-340 Advertising$0.00$0.00$0.00 FUND 225 DEED CDAP Grant$12,500.00$0.00$12,500.00 FUND 250 Revolving Loan Fund E 250-46500-300 Professional Services$0.00$0.00$0.00 E 250-46500-304 Legal Fees$0.00$735.00$735.00 E 250-46500-317 Other fees$0.00$0.00$0.00 E 250-46500-434 Certification Fee$0.00$0.00$0.00 E 250-46500-455 Revolving Loan Proceeds$0.00$51,975.00$51,975.00 FUND 250 Revolving Loan Fund$0.00$52,710.00$52,710.00 $357,995.00$78,416.23$306,146.98 4 2,898.58 55,932.90 92,755.00 195,545.1 136,713.66192,646.56 10/31 19,267.10 19,267.1019,267.10 10/31through Reimbursed85,870.00 500.00 44,600.00 EDA 44,100.0044,100.00 Plan 2018 4 8 2018 17, 17, Award178,625.00 July 2,398.58 31,100.00 170,212.2 136,713.66167,813.66 Expenditures Availablethrough Improvement 12/31/201 December Capital Capital Recommended: Adopted 2019 Fund EDA General Housing Grant Draw Down CodeNumberEquipmentBalance201920192019Balance ProjectProjectReserveBudgetGrants/AidsSpent2019 DepartmentAccount