How can i do this excel that journal entries part and budgetary comparison schedule part?

\fGeneral Fund - General Ledger # date 1 2 3 4 5 6 7 8 9 10 11 12 13 Journal Entries debits Cash Marketable Securities Property Taxes Receivable Allowance for Uncollectible Property Taxes Sales Tax Receivable Due from State Government Supplies Inventory Vouchers Payable Due to Other Funds Advances from Other Funds CASH bb 50,000 35,525 bb - - bb - - bb 18,000 8,500 16,000 7,000 12,275 - 13,400 35,000 Funds Balance Reserved for Supplies Inventory Budgetary Fund Balance Reserved/Assigned for Encumbrances Unreserved Fund Balance Total credits 22,450 - 7,000 10,000 Committed 43,800 139,745 139,745 FUND BALANCE - bb - bb - bb - - - - - - - - - - ESTIMATED REVENUES APPROPRIATIONS - ENCUMBRANCES 1 - BUDGETARY FUND BALANCE RESERVE FOR ENCUMBRANCES - bb - 1 22,450 22,450 - T. Debits T. Credits 22,450 22,450 TRANSFERS OUT - ESTIMATED OTHER FINANCING USES BUDGETARY FUND BALANCE - - OTHER FINANCING USES OTHER FINANCING SOURCES BUDGETARY ACCOUNTS bb - - General Fund - General Ledger PROVINCE OF EUROPA GOVERNMENTAL FUNDS STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE FOR THE YEAR ENDED DECEMBER 31, 2091 Prairie City General Fund Statement of Revenues, Expenditures, and Changes in Fund Balance For the Year Ended December 31 Revenues Property Taxes Sales Taxes Charges for Services Federal Grants Fines and Forfeits Total Revenues (A) Expenditures Salaries Contractual Services Materials and Supplies Capital Equipment Total Expenditures (B) Excess of Revenue over Expenditures (AB) Other Financing Sources (Uses) Transfer In from Enterprise Fund Transfer Out to Debt Service Fund Net Change in Fund Balances before Inventory Total Fund Balance at the Beginning of the Year Increase in Reserve for Supplies in Hand Total Fund Balance at the End of the Year (17,800 + 15,000 + 21,000 + 3, 117500 $73,600 12400 10000 8900 222400 105200 15000 15300 69100 204600 17800 35,000 (20,000) 15,000 21,000 3,000 56,800 PROVICE OF EUROPA GOVERNMENTAL FUNDS BALANCE SHEET AS OF DECEMBER 31, 2091 Prairie City General Fund Balance Sheet Assets Cash Marketable Securities 22450 Property Taxes Receivable Less Allowance for Uncollectible Property Taxes Sales Taxes Receivable Due from State Government Supplies Inventory Total Assets 5000 35525 -18000 8500 16000 7000 121475 Vouchers Payable Due to Other Funds Advances from Other Funds 12,275 13,400 35,000 Liabilities Fund Balance Funds Balance Reserved for Supplies Inventory Budgetary Fund Balance Reserved for Encumbrances Unreserved Fund Balance Liabilities and Fund Balance 7,000 10,000 43800 121,475 PROVINCE OF EUROPA STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL GENERAL FUND FOR THE YEAR ENDED DECEMBER 31, 2091 Budgetary Comparison Schedule For the Year Ended Original Budget Final Budget Actual