Loading...
HomeMy WebLinkAboutBudget Transfer - AccountingGRANT COUNTY COMMISSIONERS AGENDA MEETING REQUEST FORM (Must be submitted to the Clerk of the Board by 12:00pm on Thursday) REQUESTING DEPARTMENT:Auditor REQUEST SUBMITTED BY:Emili Wash CONTACT PERSON ATTENDING ROUNDTABLE: CONFIDENTIAL INFORMATION: E]YES ®NO DATE: PHONE: 13"Ire-S IRU If necessary, was this document reviewed by legal? 0 YES 0 NO ❑ N/A DATE OF ACTION: 4.30 1- q APPROVE: DENIED ABSTAIN D1: D2: D3: 4/23/24 DEFERRED OR CONTINUED TO: U ---------- DAgreement / Contract DAP Vouchers DAppointment / Reappointment FIARPA Related D Bids / RFPs / Quotes Award 013id Opening Scheduled 0 Boards / Committees 0 Budget DComputer Related DCounty Code D Emergency Purchase El Employee Rel. FlFacilities Related FlFinancial OFunds ElHearing D Invoices / Purchase Orders FIGrants — Fed/State/County 01 -eases EIMOA / MOU DMinutes 00rdinances D Out of State Travel El Petty Cash OPolicies DProclamations 0 Request for Purchase DResolution DRecommendation ElProfessional Serv/Consultant DSupport Letter DSurplus Req. DTax Levies ElThank You's DTax Title Property E1WSLCB MC Need review and approval for cash transfer for the amount of $96,944 from Prop 1 Sales tc New Jail Capital Replacement 13"Ire-S IRU If necessary, was this document reviewed by legal? 0 YES 0 NO ❑ N/A DATE OF ACTION: 4.30 1- q APPROVE: DENIED ABSTAIN D1: D2: D3: 4/23/24 DEFERRED OR CONTINUED TO: U GRANT COUNTY CASH TRANSFER REQUEST DEPARTMENT: AUDITOR EFFECTIVE DATE: 04.23.2024 DESCRIPTION: 311 TRAN SO4.2024 REQUESTED BY: EMILI WASH ACCOUNTING JE NO. 955,584 TRANSFER DETAILS: 5% ALLOCATION OF PROP 1 SALES TAX (117) REVENUE TRANSFER TO NEW JAIL CAPITAL REPLACEMENT (311) TREASURER GL NO. TRANSFER TO TRANSFER FROM fo .ice Xal- SRI .1 A, CRIME JUST. CONST. SALES/USE TAX 117.000.00 0000 101000000 96,944.00 NEW JAIL CAPITAL REPLACEMENT 311.000.00 0000 101000000 961944.00 Completed By: Approved By: $ 96,944.00 $ 96,944.00 TOTAL TO TOTAL FROM k6eie tswi�h System: 4/23/2024 8:38:58 AM County of Grant Page: 1 User Date: 4/23/2024 GENERAL TRANSACTION EDIT LIST User ID: eswash General Ledger # Intercompany Journal Entry Batch ID: 311TRANS04.2024 Batch Comment: Approved: No Batch Total Actual: Approved By: Trx Total Actual: Approval Date: $387,776.00 Batch Total Control: I Trx Total Control: $387,776.00 0 Journal Transaction Transaction Reversing Source Transaction Entry Type Date Date Document Reference ------------------------------------------------------------------------------------------------------------------------------------------ User-Defined 1 User -Defined 2 ------------------------------------------------------------------------------------------------------------------------------------------------------- 955,584 Standard 4/23/2024 GJ 311TRANS04.2024 Account Description Debit Credit ------------------------- 117.000.00.0000.597000011 ----------------------------------------------- ---------------------- PROP I JAIL TRANSEF OUT MAINT. FUND ---------------------- $96,944.00 117.000.00.0000.101000000 CASH $96,944.00 311.000.00.0000.101000000 CRIM. JUST. CONST, . . .CASH $96,944.00 311.001.00.0000.397000011 CRIM. JUST. CONST. . . ,TRANSFER IN $96,944,00 Total Distributions: 4 -------------------------------------------- Totals: $193,888.00 $193,888.00 Total Journal Entries: 1 4-.0 WED .REVIE yr 40a'ii 20241 By -es wash.at8': A P R 0" VE D By Katie, Smith' a','t,10, 2�t1'_'___2__ _77 Accounting has been instructed by the Board of County Commissioners to allocate 5% of the annual tax revenues generated from Prop 1 sales tax, after deducting annual bond expenses, to fund 311 for New Jail Capital Replacement. Transfer will be completed in 2024. 2023 Calculation Annual Prop 1 Tax Revenue 62741,146 Less: Annual Bond Expense 428022262 11938o884_ 5% allocation for fund 311 963944 Transfer 96,944 from fund 117 to 311 County of Grant 117-000 Prop 1 Sales For the Twelve Months Ending Sunday, December 31, 2023 MONTHLY REVENUE REPORT TOTAL RECEIVED YEAR TO DATE UNCOLLECTED Previous Year Previous Year ACCOUNT # ACCOUNT NAME APPROPRIATION THIS PERIOD RECEIVED BALANCE %RECD This Period I o Uate 313150000 PROP 1 TAX ($6,000,000.00) $845,888.46 $6,741,145.63 $741,145.63 112.35% 361110000 INVESTMENT INTEREST 25,834.34 60,034.81 607034.81 0.00% 388100000 PRIOR YEARS(S) CORRECTIONS (9,821,056.00) (9,821,056.00) 0.00% 397000000 OPER TRANSFERS IN 9,821,055.02 9,821,055.02 0.00% TOTAL REVENUES (15,821,056.00) 871,722.80 16,622,235.46 801,179.46 105.06% 1/25/2024 GCDEPTREV 4:02 PM System: 3/22/2024 9:28:41 AM County of Grant Page: 1 User Date: 3/22/2024 SUMMARY INQUIRY FOR 2023 User ID: krsmith General Ledger Account: 211.000.00.0000.101000000 CRIM JUST. DEBT SRV CASH Currency: Period ------------------------------------------------------------------------------------------------------------------------------------ Debit Credit Net Change Period Balance Beginning Balance $0.00 $0.00 Period 1 $0.00 $0.00 Period 2 $0.00 $0.00 Period 3 $0.00 $0.00 Period 4 $0.00 $0.00 Period 5 $0.00 $0.00 Period 6 $1,958,331.25 $1,958,331.25 $0.00 $0.00 Period 7 $0.00 $0.00 Period 8 $599.04 $599.04 $0.00 $0.00 Period 9 $0.00 $0.00 Period 10 $0.00 $0.00 Period 11 $0.00 $0.00 Period 12 $2,843,331.25 ------------------------- $2,843,331.25 -------------------------------------------------- $0.00 $0.00 ------------------------- Totals: $4,802,261.54 $4,8021261.54 $0.00 $0.00 1/2612024 GCDEPTEXP 8:18 AM County of Grant 117-000 Prop 1 Sales For the Twelve Months Ending Sunday, December 31, 2023 Monthly Expense Report TOTAL EXPENDITURES YEAR TO DATE UNENCUMBERED PREVIOUS YR PREVIOUS ACCOUNT # ACCOUNT NAME APPROPRIATIOI\ THIS PERIOD EXPENDITURES BALANCE USED THIS PERIOD YTD 523601100 REG SALARIES & WAGES $1,000,000.00 $11000,000.00 0.00% 597000000 OPER. TRANSFERS OUT 4,801,663.00 2,843,331.25 5,802,261.54 (1,000,598.54) 120.84% TOTAL: OTHER NOT 5????00?? CLASSIFIED 4,801,663.00 21843,331.25 5,802,261.54 (1,000,598.54) 120.84% 5???? 1 ??? - TOTAL: REG 5????12?? SALARIES/WAGES 110007000.00 1,000,000.00 0.00% 5???????? GRAND TOTAL: 5,801,663.00 2,843,331.25 5,802,261.54 (598.54) 100.01% 1/2612024 GCDEPTEXP 8:18 AM