Loading...
HomeMy WebLinkAbout2022-07 Century Center Bank Account SummaryPeriod Ending: Issued By: City of South Bend Century Center Bank Account Cash Summary Page Numbers Contents 2 - 4 Cash Summary Detail 5 Cash Trends Chart 6 Cash Summary - Five Year Comparison Distribution South Bend Civic Center Board of Managers Century Center Management Mayor Chief of Staff Deputy Chief of Staff City Controller Deputy City Controller Director of Treasury July 31, 2022 Controller's Office Key Bank Key Bank Key Bank Key Bank Key Bank Cerfificate Capital & InvestmentOperating (1)A/P - PayrollEventEnergy Bond (4)of Deposit Old National Month Account Account Account Account Account Capital Loan Net NotesEnding Balance - June 30, 2017 866,416.01 1,379,882.78 66,379.77 121,121.52 50,106.82 - - 2,483,906.90 Receipts 73.58 826,232.30 430,000.00 11,247.60 4.26 - - 1,267,557.74 Hotel/Motel Tax depositDisbursements - (432,979.30) (454,883.07) (8,997.96) - - - (896,860.33) Operating Acct transfer to Payroll/AP AccountEnding Balance - July 31, 2017 866,489.59 1,773,135.78 41,496.70 123,371.16 50,111.08 - - 2,854,604.31 Receipts 73.60 332,585.88 550,425.00 66,177.95 4.25 - - 949,266.68 Disbursements - (554,038.32) (468,294.18) (61,805.66) - - - (1,084,138.16) Operating Acct transfer to Payroll/AP AccountEnding Balance - August 31, 2017 866,563.19 1,551,683.34 123,627.52 127,743.45 50,115.33 - - 2,719,732.83 Receipts 71.23 323,875.56 326,641.00 18,087.30 4.12 - - 668,679.21 Disbursements - (328,212.82) (323,933.13) (36,608.60) - - - (688,754.55) Operating Acct transfer to Payroll/AP AccountEnding Balance - September 30, 2017 866,634.42 1,547,346.08 126,335.39 109,222.15 50,119.45 - - 2,699,657.49 Receipts 73.60 357,492.33 328,759.66 52,107.99 4.26 - - 738,437.84 Disbursements - (328,534.64) (395,820.99) (71,321.72) - - - (795,677.35) Operating Acct transfer to Payroll/AP AccountEnding Balance - October 31, 2017 866,708.02 1,576,303.77 59,274.06 90,008.42 50,123.71 - - 2,642,417.98 Receipts 71.12 102,200.15 445,500.00 37,512.92 4.12 - - 585,288.31 Disbursements (1,500.00) (447,547.90) (429,224.94) (29,084.34) - - - (907,357.18) Operating Acct transfer to Payroll/AP AccountEnding Balance - November 30, 2017 865,279.14 1,230,956.02 75,549.12 98,437.00 50,127.83 - - 2,320,349.11 Receipts 73.49 325,196.99 274,960.00 36,474.54 4.26 - - 636,709.28 Disbursements - (275,174.76) (357,405.82) (16,574.54) - - - (649,155.12) Operating Acct transfer to Payroll/AP AccountEnding Balance - December 31, 2017 865,352.63 1,280,978.25 (6,896.70) 118,337.00 50,132.09 - - 2,307,903.27 Receipts 73.50 965,841.23 368,946.93 45,604.42 4.25 - - 1,380,470.33 Hotel/Motel Tax depositDisbursements - (367,651.21) (332,257.20) (31,663.83) - - - (731,572.24) Operating Acct transfer to Payroll/AP AccountEnding Balance - January 31, 2018 865,426.13 1,879,168.27 29,793.03 132,277.59 50,136.34 - - 2,956,801.36 Receipts 66.39 211,771.13 378,234.17 47,320.13 3.85 - - 637,395.67 Disbursements - (381,723.39) (338,920.56) - - - - (720,643.95) Operating Acct transfer to Payroll/AP AccountEnding Balance - February 28, 2018 865,492.52 1,709,216.01 69,106.64 179,597.72 50,140.19 - - 2,873,553.08 Receipts 73.28 280,820.04 351,139.85 22,887.05 4.26 - - 654,924.48 Disbursements (5,215.89) (346,580.67) (334,252.94) (98,821.87) - - - (784,871.37) Operating Acct transfer to Payroll/AP AccountEnding Balance - March 31, 2018 860,349.91 1,643,455.38 85,993.55 103,662.90 50,144.45 - - 2,743,606.19 Receipts 70.72 126,947.00 309,050.80 42,830.70 4.12 - - 478,903.34 Disbursements - (308,719.06) (284,153.42) (16,892.80) - - - (609,765.28) Operating Acct transfer to Payroll/AP AccountEnding Balance - April 30, 2018 860,420.63 1,461,683.32 110,890.93 129,600.80 50,148.57 - - 2,612,744.25 Receipts 72.97 430,071.57 360,800.00 50,072.07 4.26 - - 841,020.87 Disbursements (4,800.00) (357,799.47) (367,605.89) (40,903.37) - - - (771,108.73) Operating Acct transfer to Payroll/AP AccountEnding Balance - May 31, 2018 855,693.60 1,533,955.42 104,085.04 138,769.50 50,152.83 - - 2,682,656.39 Receipts 70.34 425,381.48 250,064.78 115,917.53 4.12 - - 791,438.25 Disbursements - (254,729.61) (253,694.85) (169,757.03) - - - (678,181.49) Operating Acct transfer to Payroll/AP AccountEnding Balance - June 30, 2018 855,763.94 1,704,607.29 100,454.97 84,930.00 50,156.95 - - 2,795,913.15 Receipts 72.68 777,238.80 292,000.00 13,865.36 4.26 - - 1,083,181.10 Hotel/Motel Tax depositDisbursements - (296,682.12) (317,553.03) - - - - (614,235.15) Operating Acct transfer to Payroll/AP AccountEnding Balance - July 31, 2018 855,836.62 2,185,163.97 74,901.94 98,795.36 50,161.21 - - 3,264,859.10 Receipts 72.69 225,962.84 385,000.00 14,852.33 4.26 - - 625,892.12 Disbursements - (388,568.43) (369,086.23) (32,714.19) - - - (790,368.85) Operating Acct transfer to Payroll/AP AccountEnding Balance - August 31, 2018 855,909.31 2,022,558.38 90,815.71 80,933.50 50,165.47 - - 3,100,382.37 Receipts 70.35 306,077.58 314,248.00 62,499.85 4.13 - - 682,899.91 Disbursements - (315,568.80) (237,122.56) (39,500.00) - - - (592,191.36) Operating Acct transfer to Payroll/AP AccountEnding Balance - September 30, 2018 855,979.66 2,013,067.16 167,941.15 103,933.35 50,169.60 - - 3,191,090.92 Receipts 181.77 343,441.71 298,493.82 80,072.88 10.65 - - 722,200.83 Disbursements - (299,914.87) (390,825.99) (81,925.23) - - - (772,666.09) Operating Acct transfer to Payroll/AP AccountEnding Balance - October 31, 2018 856,161.43 2,056,594.00 75,608.98 102,081.00 50,180.25 - - 3,140,625.66 Receipts 715.71 673,023.91 400,866.41 37,754.58 10.31 - - 1,112,370.92 Disbursements - (404,530.38) (476,475.39) (139,835.58) - - - (1,020,841.35) Ending Balance - November 30, 2018 856,877.14 2,325,087.53 - - 50,190.56 - - 3,232,155.23 Receipts 486.08 227,182.58 1,027,907.51 43,281.37 10.66 - - 1,298,868.20 Disbursements - (1,029,733.14) (1,027,907.51) (43,281.37) - - - (2,100,922.02) Ending Balance - December 31, 2018 857,363.22 1,522,536.97 - - 50,201.22 - - 2,430,101.41 Receipts 1,092.93 271,296.59 256,670.26 46,252.29 10.66 - - 575,322.73 Disbursements - (258,011.87) (256,670.26) (46,252.29) - - - (560,934.42) Ending Balance - January 31, 2019 858,456.15 1,535,821.69 - - 50,211.88 - - 2,444,489.72 Receipts 988.36 879,151.80 230,589.87 13,204.41 9.63 - - 1,123,944.07 Hotel/Motel Tax DepositDisbursements - (233,396.45) (230,589.87) (13,204.41) - - - (477,190.73) Ending Balance - February 28, 2019 859,444.51 2,181,577.04 - - 50,221.51 - - 3,091,243.06 Receipts 1,095.58 310,869.16 229,697.45 57,356.76 10.67 - - 599,029.62 Disbursements - (231,662.55) (229,697.45) (57,356.76) - - - (518,716.76) Ending Balance - March 31, 2019 860,540.09 2,260,783.65 - - 50,232.18 - - 3,171,555.92 Five Years - July 31, 2017 through July 31, 2022Century Center Bank Statement Cash SummaryCentury Center Bank Account Cash Summary2 Key Bank Key Bank Key Bank Key Bank Key Bank Cerfificate Capital & InvestmentOperating (1)A/P - PayrollEventEnergy Bond (4)of Deposit Old National Month Account Account Account Account Account Capital Loan Net NotesFive Years - July 31, 2017 through July 31, 2022Century Center Bank Statement Cash SummaryReceipts 1,061.58 197,422.08 527,230.71 99,468.51 10.32 - - 825,193.20 Disbursements - (528,744.53) (527,230.71) (99,468.51) - - - (1,155,443.75) Transfer of Maint./Op Expenses to 1st Source for Reimb (1Q19)Ending Balance - April 30, 2019 861,601.67 1,929,461.20 - - 50,242.50 - - 2,841,305.37 Receipts 1,098.33 276,006.98 326,302.86 48,216.22 10.67 - - 651,635.06 Disbursements - (294,005.09) (326,302.86) (48,216.22) - - - (668,524.17) Ending Balance - May 31, 2019 862,700.00 1,911,463.09 - - 50,253.17 - - 2,824,416.26 Receipts 1,064.24 317,301.32 309,187.75 18,822.21 10.32 - - 646,385.84 Disbursements - (311,582.16) (309,187.75) (18,822.21) - - - (639,592.12) Ending Balance - June 30, 2019 863,764.24 1,917,182.25 - - 50,263.49 - - 2,831,209.98 Receipts 178,736.61 957,681.01 313,826.26 41,105.65 10.68 - 1,491,360.21 Hotel/Motel Tax DepositDisbursements - (495,585.86) (313,826.26) (41,105.65) - - - (850,517.77) Transfer from Operating to Capital - $177,475.00Ending Balance - July 31, 2019 1,042,500.85 2,379,277.40 - - 50,274.17 - - 3,472,052.42 Receipts 1,328.94 185,827.30 590,165.39 83,044.87 10.67 - - 860,377.17 Disbursements - (590,337.45) (590,165.39) (83,044.87) - - - (1,263,547.71) Transfer of Maint./Op Expenses to 1st Source for Reimb (2Q19)Ending Balance - August 31, 2019 1,043,829.79 1,974,767.25 - - 50,284.84 - - 3,068,881.88 Receipts 1,201.79 169,811.92 203,412.05 50,451.44 10.34 - - 424,887.54 Disbursements - (204,908.37) (203,412.05) (50,451.44) - - - (458,771.86) Ending Balance - September 30, 2019 1,045,031.58 1,939,670.80 - - 50,295.18 - - 3,034,997.56 Receipts 1,110.02 266,115.05 701,720.02 61,634.19 10.68 - - 1,030,589.96 Disbursements - (703,375.38) (701,720.02) (61,634.19) - - - (1,466,729.59) Transfer of Maint./Op Expenses to 1st Source for Reimb (3Q19)Ending Balance - October 31, 2019 1,046,141.60 1,502,410.47 - - 50,305.86 - - 2,598,857.93 Receipts 829.38 436,304.93 250,528.59 47,432.77 10.33 - - 735,106.00 Disbursements (66,123.07) (184,694.69) (250,528.59) (47,432.77) - - - (548,779.12) Transfer from Capital to Operating - $66,123.07Ending Balance - November 30, 2019 980,847.91 1,754,020.71 - - 50,316.19 - - 2,785,184.81 Receipts 833.39 327,993.35 582,490.26 53,578.75 10.69 - - 964,906.44 Disbursements - (583,970.60) (582,490.26) (53,578.75) - - - (1,220,039.61) Transfer of Maint./Op Expenses to 1st Source for Reimb (4Q19)Ending Balance - December 31, 2019 981,681.30 1,498,043.46 - - 50,326.88 - - 2,530,051.64 Receipts 831.82 944,322.64 222,036.53 40,771.23 10.66 - - 1,207,972.88 Hotel/Motel Tax DepositDisbursements - (220,862.86) (222,036.53) (40,771.23) - - - (483,670.62) Ending Balance - January 31, 2020 982,513.12 2,221,503.24 - - 50,337.54 - - 3,254,353.90 Receipts 778.79 290,124.57 255,625.49 27,012.50 9.97 - - 573,551.32 Disbursements - (258,519.92) (255,625.49) (27,012.50) - - - (541,157.91) Ending Balance - February 29, 2020 983,291.91 2,253,107.89 - - 50,347.51 - - 3,286,747.31 Receipts 246.12 181,245.70 185,765.04 24,521.09 6.26 - - 391,784.21 Disbursements - (189,853.52) (185,765.04) (24,521.09) - - - (400,139.65) Ending Balance - March 31, 2020 983,538.03 2,244,500.07 - - 50,353.77 - - 3,278,391.87 Receipts 8.06 12,602.60 452,194.48 - 2.06 - - 464,807.20 Disbursements - (452,712.13) (452,194.48) - - - - (904,906.61) Transfer of Maint./Op Expenses to 1st Source for Reimb (1Q20)Ending Balance - April 30, 2020 983,546.09 1,804,390.54 - - 50,355.83 - - 2,838,292.46 Receipts 8.33 1,514.00 133,574.96 1,135.00 2.14 - - 136,234.43 Disbursements - (136,992.56) (133,574.96) (1,135.00) - - - (271,702.52) Ending Balance - May 31, 2020 983,554.42 1,668,911.98 - - 50,357.97 - - 2,702,824.37 Receipts 8.07 575.01 69,288.13 - 2.06 - - 69,873.27 Disbursements - (70,188.60) (69,288.13) - - - - (139,476.73) Ending Balance - June 30, 2020 983,562.49 1,599,298.39 - - 50,360.03 - - 2,633,220.91 Receipts 8.33 24,621.90 307,097.48 18,926.00 2.13 - - 350,655.84 Disbursements - (308,194.71) (307,097.48) (18,926.00) - - - (634,218.19) Transfer of Maint./Op Expenses to 1st Source for Reimb (2Q20)Ending Balance - July 31, 2020 983,570.82 1,315,725.58 - - 50,362.16 - - 2,349,658.56 Receipts 8.33 35,235.03 78,866.58 8,075.94 2.13 - - 122,188.01 Disbursements - (79,906.68) (78,866.58) (8,075.94) - - - (166,849.20) Ending Balance - August 31, 2020 983,579.15 1,271,053.93 - - 50,364.29 - - 2,304,997.37 Receipts 8.06 369,517.22 59,214.91 13,208.51 2.07 - - 441,950.77 Hotel/Motel Tax DepositDisbursements - (59,744.18) (59,214.91) (13,208.51) - - - (132,167.60) Ending Balance - September 30, 2020 983,587.21 1,580,826.97 - - 50,366.36 - - 2,614,780.54 Receipts 8.33 54,541.54 373,758.98 18,221.00 2.13 - - 446,531.98 Disbursements - (375,529.94) (373,758.98) (18,221.00) - - - (767,509.92) Transfer of Maint./Op Expenses to 1st Source for Reimb (3Q20)Ending Balance - October 31, 2020 983,595.54 1,259,838.57 - - 50,368.49 - - 2,293,802.60 Receipts 8.06 129,237.81 145,013.43 600.00 2.07 - - 274,861.37 Disbursements - (146,351.69) (145,013.43) (600.00) - - - (291,965.12) Ending Balance - November 30, 2020 983,603.60 1,242,724.69 - - 50,370.56 - - 2,276,698.85 Receipts 8.33 161,982.18 406,625.18 3,788.00 2.13 - - 572,405.82 Disbursements - (409,177.68) (406,625.18) (3,788.00) - - - (819,590.86) Transfer of Maint./Op Expenses to 1st Source for Reimb (4Q20)Ending Balance - December 31, 2020 983,611.93 995,529.19 - - 50,372.69 - - 2,029,513.81 Century Center Bank Account Cash Summary3 Key Bank Key Bank Key Bank Key Bank Key Bank Cerfificate Capital & InvestmentOperating (1)A/P - PayrollEventEnergy Bond (4)of Deposit Old National Month Account Account Account Account Account Capital Loan Net NotesFive Years - July 31, 2017 through July 31, 2022Century Center Bank Statement Cash SummaryReceipts 8.36 362,427.64 114,384.66 - 2.14 - - 476,822.80 Hotel/Motel Tax DepositDisbursements - (118,958.07) (114,384.66) - - - - (233,342.73) Ending Balance - January 31, 2021 983,620.29 1,238,998.76 - - 50,374.83 - - 2,272,993.88 Receipts 7.54 19,677.84 119,207.04 2,461.00 1.93 - - 141,355.35 Disbursements - (121,134.13) (119,207.04) (2,461.00) - - - (242,802.17) Ending Balance - February 28, 2021 983,627.83 1,137,542.47 - - 50,376.76 - - 2,171,547.06 Receipts 8.36 119,453.84 115,649.36 6,413.34 2.14 - - 241,527.04 Disbursements - (116,861.18) (115,649.36) (6,413.34) - - - (238,923.88) Ending Balance - March 31, 2021 983,636.19 1,140,135.13 - - 50,378.90 - - 2,174,150.22 Receipts 8.08 58,392.98 142,810.43 26,586.73 2.07 - - 227,800.29 Disbursements - (138,989.29) (142,810.43) (26,586.73) - - - (308,386.45) Ending Balance - April 30, 2021 983,644.27 1,059,538.82 - - 50,380.97 - - 2,093,564.06 Receipts 8.36 102,612.47 303,062.04 19,053.62 2.14 - - 424,738.63 Disbursements - (304,275.59) (303,062.04) (19,053.62) - - - (626,391.25) Transfer of Maint./Op Expenses to 1st Source for Reimb (1Q21)Ending Balance - May 31, 2021 983,652.63 857,875.70 - - 50,383.11 - - 1,891,911.44 Receipts 8.08 92,209.21 144,698.25 - 2.07 - - 236,917.61 Disbursements - (147,163.99) (144,698.25) - - - - (291,862.24) Ending Balance - June 30, 2021 983,660.71 802,920.92 - - 50,385.18 - - 1,836,966.81 Receipts 8.35 392,592.94 135,004.74 10,385.75 2.14 - - 537,993.92 Hotel/Motel Tax DepositDisbursements - (137,019.28) (135,004.74) (10,385.75) - - - (282,409.77) Ending Balance - July 31, 2021 983,669.06 1,058,494.58 - - 50,387.32 - - 2,092,550.96 Receipts 8.36 159,879.73 148,181.25 30,201.30 2.14 - - 338,272.78 Disbursements - (149,015.42) (148,181.25) (30,201.30) - - - (327,397.97) Ending Balance - August 31, 2021 983,677.42 1,069,358.89 - - 50,389.46 - - 2,103,425.77 Receipts 8.08 130,706.34 532,856.44 34,615.50 2.07 - - 698,188.43 Disbursements - (534,455.33) (532,856.44) (34,615.50) - - - (1,101,927.27) Transfer of Maint./Op Expenses to 1st Source for Reimb (2Q21)Ending Balance - September 30, 2021 983,685.50 665,609.90 - - 50,391.53 - - 1,699,686.93 Receipts 8.36 197,906.29 208,876.06 20,083.37 2.14 - - 426,876.22 Disbursements - (210,304.65) (208,876.06) (20,083.37) - - - (439,264.08) Ending Balance - October 31, 2021 983,693.86 653,211.54 - - 50,393.67 - - 1,687,299.07 Receipts 8.08 243,459.63 437,071.24 59,337.46 2.07 - - 739,878.48 Disbursements - (438,409.32) (437,071.24) (59,337.46) - - - (934,818.02) Transfer of Maint./Op Expenses to 1st Source for Reimb (3Q21)Ending Balance - November 30, 2021 983,701.94 458,261.85 - - 50,395.74 - - 1,492,359.53 Receipts 8.36 269,822.34 194,530.09 40,401.00 2.14 - - 504,763.93 Disbursements - (195,916.46) (194,530.09) (40,401.00) - - - (430,847.55) Ending Balance - December 31, 2021 983,710.30 532,167.73 - - 50,397.88 - - 1,566,275.91 Receipts 8.35 1,162,105.58 158,477.25 6,900.00 2.14 - - 1,327,493.32 Hotel/Motel Tax DepositDisbursements - (161,210.00) (158,477.25) (6,900.00) - - - (326,587.25) Ending Balance - January 31, 2022 983,718.65 1,533,063.31 - - 50,400.02 - - 2,567,181.98 Receipts 7.55 137,989.75 162,289.91 28,241.00 1.94 - - 328,530.15 Disbursements - (164,520.93) (162,289.91) (28,241.00) - - - (355,051.84) Ending Balance - February 28, 2022 983,726.20 1,506,532.13 - - 50,401.96 - - 2,540,660.29 Receipts 8.35 207,913.48 297,513.10 21,427.25 2.14 - - 526,864.32 Disbursements - (295,608.33) (297,513.10) (21,427.25) - - - (614,548.68) Ending Balance - March 31, 2022 983,734.55 1,418,837.28 - - 50,404.10 - - 2,452,975.93 Receipts 8.09 211,746.79 241,288.57 5,070.00 2.07 - - 458,115.52 Disbursements - (244,267.76) (241,288.57) (5,070.00) - - - (490,626.33) Ending Balance - April 30, 2022 983,742.64 1,386,316.31 - - 50,406.17 - - 2,420,465.12 Receipts 8.35 195,543.14 206,012.64 60,981.22 2.14 - - 462,547.49 Disbursements - (207,446.89) (206,012.64) (60,981.22) - - - (474,440.75) Ending Balance - May 31, 2022 983,750.99 1,374,412.56 - - 50,408.31 - - 2,408,571.86 Receipts 8.09 180,864.50 247,432.65 40,289.07 2.07 - - 468,596.38 Disbursements - (249,347.84) (247,432.65) (40,289.07) - - - (537,069.56) Ending Balance - June 30, 2022 983,759.08 1,305,929.22 - - 50,410.38 - - 2,340,098.68 Receipts 8.36 157,682.84 214,008.99 21,432.93 2.14 - - 393,135.26 Disbursements - (216,270.08) (214,008.99) (21,432.93) - - - (451,712.00) Ending Balance - July 31, 2022 983,767.44 1,247,341.98 - - 50,412.52 - - 2,281,521.94 Century Center Bank Account Cash Summary4 2-9101112Century Center Bank Account Cash BalancesFive Years - July 31, 2017 through July 31, 2022$0.0 M$0.5 M$1.0 M$1.5 M$2.0 M$2.5 M$3.0 M$3.5 M$4.0 MCentury Center Bank Account Cash Summary5 Amount7/31/18 $3,264,859.10- - 7/31/19 $3,472,052.42 6.35% 6.35%7/31/20 $2,349,658.56 -32.33% -28.03%7/31/21 $2,092,550.96 -10.94% -35.91%7/31/22 $2,281,521.94 9.03% -30.12%Note: - Hotel/motel tax revenue is typically received in January/February and June/July.Century Center Ending Bank Account Statement BalancesJuly 31, 2018 - July 31, 2022Annual PercentChange ChangePercentCumulativeFive Year Comparison$0$500,000$1,000,000$1,500,000$2,000,000$2,500,000$3,000,000$3,500,000$4,000,000Century Center Bank Account Cash Summary6