The URL can be used to link to this page

Home My Public Portal AboutJE 803-00092.11.2022GENERAL LEDGER DATE 11/01/22 JOURNAL # 803-00092.11.2022 DESCRIPTION Reverse Unearned Revenue for American Rescue Plan SOURCE: sconvery CHECK #: Amount Account # Description Debit Credit Account # 5,981,982.05 10-000-243010 Unearned Revenue 5,981,982.05 10-100-430012 Federal Grants - ARPA Reverse Unearned Revenue for American Rescue Plan 5,981,982.05 5,981,982.05 TOTAL JE Requested by Finance Department JE Entered by Shelby Convery General Ledger Chart of Accounts Maintenance User: SConvery Printed: 3/15/2023 10:13:14 AM JE N JE Da Per Ye DR Am CR Am , Sys Batch Description Vendo Last Ba Proof List JOHN G. CHRISTY MUNICIPAL BUILDING 320 E McCarty St Jefferson City, MO 65101-3193 1022 6/9/20: 8 20: $0.00 $3j19'3,T GL j22 10/31/: 13 20: -$3,793,2- $0.00 GL /123 10/31/: 13 20: $0.00 $2,499,3 GL 126 10/314 13 : 20: $+29S9 $0.00 GL 127 10/31/: 13 20: $0.00 $1,293;9 GL 128 10/31/: 13 ' 20: $1,293,9 $0.00 GL 131 10/31/: 13 20: $3,793;2 $0.00 GL 132 10/31/: 13 20: $0.00 $3;193,2 GL 133 10/31/: 13 20: $2;49,3 $0.00 GL 134 10/31/: 13 20: $0.00 • $_ " 3 GL 135 10/31/: 13 20: $0.00 :. ,-' __ GL 139 10/31/: 13 20: -$3,773,2 $0.00 GL ,140 10/31/: 13 20: $1,293,9 $0.00 GL 142 10/31/: 13 20: $0.00 $3,7443;2--GL 143 10/314 13 20: $1,515,4 $0.00 GL 175 10/31/: 13 20: $600.00 ' $0.00 GL 181 10/31/: 13 20: $4,600.0 $0.00 ' GL 00030.0E Setup Unearned Revenue for American Rescue Plan 00086.1( Reverse JE# 191 Setup Unearned Revenue for American Rescue 00086.1( Setup UneamedRevenue for American Rescue Plan 00088.1( . Record grant revenue for American Rescue Plan FY22 00089.1( VOID JE# 126 Record grant revenue for American Rescue Plan 00089.1( Record grant revenue for American Rescue Plan FY22 00090.1( Reverse JE# 1022 Setup Unearned Revenue for American Resew 00090.1( Setup unearned.revenue for American Rescue Plan (2nd payment 00090.1( Reverse JE# 123 Setup Unearned Revenue for American Rescue 00090.1( Setup Unearned Revenue for American Rescue Plan 00091.1( Move first ARPA grant payment (5/20/2021) to Federal Grants -A 00092.1( Reverse JE# 135 Move first ARPA grant payment (5/20/2021) to 00092.1( Record ARPA Grant used (earned) for FY2022 00093.1( Reverse JE# 139 Reverse JE# 135 Move first ARPA grant payme 00094.1( to correct unearned revenue 00121.1( Correct ARPA Grant Revenue 00125.1( Reverse JE# 144 Setup Unearned Receivable for Animal Shelter SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery SConvery http://ssi.net?actionzeport&object=netpaiams&idki295.1 http://ssi.net?action=report&object=netparams&id=86bo1 http://ssi.net?action=report&object=netparams&id=86bcE http://ssi.net?actionzeport&obj ect=netparams&ids 1 d6e http://ssi.net?actionzeport&object=netparams&id=eodOc http://ssi.net?action=report&object=netparams&id=e0d0c http://ssi.net?actionzeport&object netparams&id=9d0et http://ssi.net?actionzeport&object=netparams&id=9d0et http://ssi.net?actionzeport&object=netparams&id=9d0et http://ssi.net?actionzeport&object netparams&id=9d0et http://ssi.net?action=report&object=netparams&id=ae99a http://ssi.net?action=report&object=netparams&id=a9b0d http://ssi.net?action=report&object=netparams&id=a9b0d http://ssi.net7actionzeport&object=netparams&id=3 c 19 E http://ssi.net?action=report&object=netparams&id=c799 http://ssi.net?actionzepor[&object=netparams&id=15171 http://ssi.net?actionzeport&object=netparams&id=e53c5 General Ledger - Chart of Accounts Maintenance (3/15/2023) Page 1 of 1 General Ledger. Journal Entry Proof List. User: SConvery Printed: 3/15/2023 - 10:33 AM Batch: 00090.11.2022 Account Number Account Description ITYOF-JEFFERSON JOHN G. CHRISTY MUNICIPAL BUILDING 320E McCarty St'. Jefferson City, MO 65101:-3193 Debit Amount Credit Amount Line Description System Reference Project Management Journal Entry: 793-01=2023 ' Journal Entry Date: 11/01/2022 10-100-430010 : Federal Grants . ' ' 0.00 79,012.61. Reverse JE# 166 Record unavailable revenue for FEMA portion of Maximum Management Costs Allowed 10-000-243050 "Unavailable Revenues 79,012.6.1 ' . 0.00 Reverse JE# 166 Record unavailable revenue for FEMA portion of Maximum Management Costs Allowed Journal Entry Totals 79,012.61 79,012.61 Journal Entry Balance 0.00 Journal Entry: 794-01-2023 . Journal Entry Date: 11/01/2022 10-100-430010 10-000-243050 Journal Entry Totals Federal Grants 0.00 26,337.53 Reverse JE# 167 Record unavailable revenue for SEMA portion of Maximum Management Costs Allowed Unavailable Revenues 26,337.53 0.00. Reverse JE# 167 Record unavailable revenue for SEMA portion of Maximum Management Costs Allowed 26,337.53 26,337.53 Journal Entry Balance 0.00 Journal Entry: 795-01-2023 'Journal Entry Date: 11/01/2022 GL -Journal Entry Proof List (3/15/2023 - 10:33 AM) Page 1 Account Number Account Description Debit Amount Credit Amount Line Description System Reference Project Management 21-210-430010 Federal Grants 0.00 64,515.59 Reverse JE# 169 Record unavailable revenue for SEMA portion of Debris removal (Parks) 21-000-243050 Unavailable Revenues 64,515.59 0.00 Reverse JE# 169 Record unavailable revenue for SEMA portion of Debris removal (Parks) Journal Entry Totals, Journal Entry Balance Journal Entry: 796-01-2023 64,515.59. 64,515.59 Journal Entry Date: 11/01/2022 10-100-430010 Federal Grants 0.00 166,278.25 Reverse JE# 165 Record unavailable revenue for SEMA portion of Debris Removal (General) 10-000-243050 Unavailable Revenues 166,278.25 0.00 Reverse JE# 165. Record unavailable revenue for SEMA portion of Debris Removal (General) 0.00 Journal Entry Totals 166,278.25 166,278.25 Journal Entry Balance 0.00 Journal Entry: 797-01-2023 Journal Entry Date: 11/01/2022 10-990-430010 Federal Grants 0.00 240,691.83 Reverse JE# 211 Record unavailable revenue for FEMA-4451-DR-MO Norris Dr 10-000-243050 Unavailable Revenues 240,691.83 0.00 Reverse JE# 211 Record unavailable revenue for FEMA-4451-DR-MO Norris Dr Journal Entry Totals 240,691.83 240,691.83 Journal Entry Balance 0.00 Journal Entry: 798-01-2023 Journal Entry Date: 11/01/2022 10-146-430010 Federal Grants 0.00 64.24 Reverse JE# 210 Record unavailable revenue for P21AP11790 GL -Journal Entry Proof List (3/15/2023 - 10:33 AM) Page 2 Account Number Account Description Debit Amount Credit Amount Line Description System Reference Project Management 10-000-243050 Journal Entry Totals Journal Entry Balance Journal Entry: 799-01-2023 10-990-430020 10-000=243050 Unavailable Revenues 64.24 0.00 Reverse JE# 210 Record unavailable revenue for P21AP11790 64.24 64.24 0.00 Journal Entry, Date: 11/01/2022 State Grants 0.00 48,751.84 Reverse JE# 209 Record unavailable revenue for JEFF -0007-20G Grant Unavailable Revenues 48,751.84. 0.00 Reverse JE# 209 Record unavailable revenue for JEFF -0007-20G Grant Journal Entry Totals 48,751.84 48,751.84 Journal Entry Balance 0.00 Report Totals: 625,651.89 625,651.89 0.00 GL -Journal Entry Proof List (3/15/2023 - 10:33 AM) Page 3