Public and Not For Profit Accounting

profilenbomez08
Budget.xlsx
Home>Business & Finance homework help>Accounting homework help>Public and Not For Profit Accounting

Budget

Preclosing Trial Balance

Option 1

Village of AIU Village of AIU
General Fund General Fund
Budget Statement of Revenues, Expenditures and Changes in Fund Balance - Budget to Actual
For Fiscal Year 20X9 For the Year Ended June 30, 20X9
Estimated Revenues: Original (and Final) Budget Actual on Budgetary Basis Variance Favorable / (Unfavorable
Taxes $ 125,000 Revenues
Interest & penalities 20,000 Taxes $ 125,000 $ 120,000 $ (5,000)
License, permits & fees 35,000 Interest & penalities 20,000 21,500 1,500
Intergovernmental grants 15,000 License, permits & fees 35,000 30,750 (4,250)
Investment revenue 75,000 Intergovernmental grants 15,000 28,750 13,750
Miscellaneous revenue 5,000 Investment revenue 75,000 73,750 (1,250)
Total estimated revenues $ 275,000 Miscellaneous revenue 5,000 7,450 2,450
$ 275,000 $ 282,200 $ 7,200
Appropriations: Expenditures
General government 80,000 General government 80,000 88,750 8,750
Public safety 23,000 Public safety 23,000 22,875 (125)
Street and sanitation 50,000 Street and sanitation 50,000 48,250 (1,750)
Health and welfare 35,000 Health and welfare 35,000 41,000 6,000
Community development 12,000 Community development 12,000 (4,600) (16,600)
Parks and recreation 25,000 Parks and recreation 25,000 27,500 2,500
Total appropriations 225,000 225,000 223,775 (1,225)
Budgeted excess of revenues Excess of Revenues over
over appropriations $ 50,000 Expenditures 50,000 58,425 8,425
Fund Balance, July 1, 20X8 75,000 75,000 - 0
Fund Balance, June 30, 20X9 $ 125,000 $ 133,425 $ 8,425
Village of AIU
General Fund
Preclosing Trial Balance
Revenue and Expenditures Subsidiary Ledgers
June 30, 20X9
Debit Credit
Revenues Subsidiary Ledger:
Taxes 5,000
Interest & penalities 1,500
License, permits & fees 4,250
Intergovernmental grants 13,750
Investment revenue 1,250
Miscellaneous revenue 2,450
Totals 10,500 17,700
Expenditures Subsidiary Ledger:
General government 8,750
5250000 57100 Public safety 125
145000 358000 Street and sanitation 1,750
5395000 11100 Health and welfare 6,000
-5100 Community development 1,600
5389900 139900 exp chg Parks and recreation 2,500
-75000 Totals 17,250 3,475
5314900
budget 5296000 Debit Credit
credit 518000 Closing entries rev change 17,700
debit -55000 463000 rev chg (10,500)
5759000 323100 chg Appropriations 225,000 7,200
46000 bud fund b Unreserved fund balance 50,000
312000 369100 Estimated revenues 275,000 exp chg 17,250
-46000 (3,475)
369100 Revenues 282,200 13,775
Unreserved fund balance 43,425
Expenditures 223,775 (6,575)
635100 Encumbrances 15,000 50000
43,425
Debit Credit
Revenues Ledger (Balances)
Taxes 5,000
Interest & penalities 1,500
License, permits & fees 4,250
Intergovernmental grants 13,750
Investment revenue 1,250
Miscellaneous revenue 2,450
Totals 17,700 10,500
Expenditures Ledger (Balances)
General government 8,750
Public safety 125
Street and sanitation 1,750
Health and welfare 6,000
Community development 1,600
Parks and recreation 2,500
Totals 3,475 17,250

Option 2

Village of Rostern Village of Rostern
General Fund General Fund
Budget Statement of Revenues, Expenditures and Changes in Fund Balance - Budget to Actual
For Fiscal Year 20X9 For the Year Ended June 30, 20X9
Estimated Revenues: Original (and Final) Budget Actual on Budgetary Basis Variance Favorable / (Unfavorable
Taxes $ 225,000 Revenues
Interest & penalities 30,000 Taxes $ 225,000 $ 219,000 $ (6,000)
License, permits & fees 45,000 Interest & penalities 30,000 32,500 2,500
Intergovernmental grants 25,000 License, permits & fees 45,000 39,750 (5,250)
Investment revenue 85,000 Intergovernmental grants 25,000 48,750 23,750
Miscellaneous revenue 6,000 Investment revenue 85,000 82,750 (2,250)
Total estimated revenues $ 416,000 Miscellaneous revenue 6,000 9,450 3,450
$ 416,000 $ 432,200 $ 16,200
Appropriations: Expenditures
General government 90,000 General government 90,000 99,750 9,750
Public safety 33,000 Public safety 33,000 32,775 (225)
Street and sanitation 60,000 Street and sanitation 60,000 57,250 (2,750)
Health and welfare 45,000 Health and welfare 45,000 52,000 7,000
Community development 22,000 Community development 22,000 19,400 (2,600)
Parks and recreation 35,000 Parks and recreation 35,000 37,500 2,500
Total appropriations 285,000 285,000 298,675 13,675
Budgeted excess of revenues Excess of Revenues over
over appropriations $ 131,000 Expenditures 131,000 133,525 2,525
Fund Balance, July 1, 20X8 75,000 75,000 - 0
Fund Balance, June 30, 20X9 $ 206,000 $ 208,525 $ 2,525
Village of Rostern
General Fund
Preclosing Trial Balance
Revenue and Expenditures Subsidiary Ledgers
June 30, 20X9
Debit Credit
Revenues Subsidiary Ledger:
Taxes 6,000
Interest & penalities 2,500
License, permits & fees 5,250
Intergovernmental grants 23,750
Investment revenue 2,250
Miscellaneous revenue 3,450
Totals 13,500 29,700
Expenditures Subsidiary Ledger:
General government 9,750
5250000 57100 Public safety 225
145000 358000 Street and sanitation 2,750
5395000 11100 Health and welfare 7,000
-5100 Community development 2,600
5389900 139900 exp chg Parks and recreation 2,500
-75000 Totals 19,250 5,575
5314900
budget 5296000 Debit Credit
credit 518000 Closing entries rev change 29,700
debit -55000 463000 rev chg (13,500)
5759000 323100 chg Appropriations 285,000 16,200
46000 bud fund b Unreserved fund balance 131,000
312000 369100 Estimated revenues 416,000 exp chg 19,250
-46000 (5,575)
369100 Revenues 432,200 13,675
Unreserved fund balance 133,525
Expenditures 283,675 2,525
635100 Encumbrances 15,000 50000
52,525
Debit Credit
Revenues Ledger (Balances)
Taxes 6,000
Interest & penalities 2,500
License, permits & fees 5,250
Intergovernmental grants 23,750
Investment revenue 2,250
Miscellaneous revenue 3,450
Totals 29,700 13,500
Expenditures Ledger (Balances)
General government 9,750
Public safety 225
Street and sanitation 2,750
Health and welfare 7,000
Community development 2,600
Parks and recreation 2,500
Totals 5,575 19,250

Sheet3

Estimated Revenues:

Taxes125,000$

Interest & penalities20,000

License, permits & fees35,000

Intergovernmental grants15,000

Investment revenue75,000

Miscellaneous revenue5,000

Total estimated revenues275,000$

Appropriations:

General government80,000

Public safety23,000

Street and sanitation50,000

Health and welfare35,000

Community development12,000

Parks and recreation25,000

Total appropriations225,000

Budgeted excess of revenues

over appropriations50,000$

Village of AIU

General Fund

Budget

For Fiscal Year 20X9

Option 1

Village of AIU Village of AIU
General Fund General Fund
Budget Statement of Revenues, Expenditures and Changes in Fund Balance - Budget to Actual
For Fiscal Year 20X9 For the Year Ended June 30, 20X9
Estimated Revenues: Original (and Final) Budget Actual on Budgetary Basis Variance Favorable / (Unfavorable
Taxes $ 125,000 Revenues
Interest & penalities 20,000 Taxes $ 125,000 $ 120,000 $ (5,000)
License, permits & fees 35,000 Interest & penalities 20,000 21,500 1,500
Intergovernmental grants 15,000 License, permits & fees 35,000 30,750 (4,250)
Investment revenue 75,000 Intergovernmental grants 15,000 28,750 13,750
Miscellaneous revenue 5,000 Investment revenue 75,000 73,750 (1,250)
Total estimated revenues $ 275,000 Miscellaneous revenue 5,000 7,450 2,450
$ 275,000 $ 282,200 $ 7,200
Appropriations: Expenditures
General government 80,000 General government 80,000 88,750 8,750
Public safety 23,000 Public safety 23,000 22,875 (125)
Street and sanitation 50,000 Street and sanitation 50,000 48,250 (1,750)
Health and welfare 35,000 Health and welfare 35,000 41,000 6,000
Community development 12,000 Community development 12,000 (4,600) (16,600)
Parks and recreation 25,000 Parks and recreation 25,000 27,500 2,500
Total appropriations 225,000 225,000 223,775 (1,225)
Budgeted excess of revenues Excess of Revenues over
over appropriations $ 50,000 Expenditures 50,000 58,425 8,425
Fund Balance, July 1, 20X8 75,000 75,000 - 0
Fund Balance, June 30, 20X9 $ 125,000 $ 133,425 $ 8,425
Village of AIU
General Fund
Preclosing Trial Balance
Revenue and Expenditures Subsidiary Ledgers
June 30, 20X9
Debit Credit
Revenues Subsidiary Ledger:
Taxes 5,000
Interest & penalities 1,500
License, permits & fees 4,250
Intergovernmental grants 13,750
Investment revenue 1,250
Miscellaneous revenue 2,450
Totals 10,500 17,700
Expenditures Subsidiary Ledger:
General government 8,750
5250000 57100 Public safety 125
145000 358000 Street and sanitation 1,750
5395000 11100 Health and welfare 6,000
-5100 Community development 1,600
5389900 139900 exp chg Parks and recreation 2,500
-75000 Totals 17,250 3,475
5314900
budget 5296000 Debit Credit
credit 518000 Closing entries rev change 17,700
debit -55000 463000 rev chg (10,500)
5759000 323100 chg Appropriations 225,000 7,200
46000 bud fund b Unreserved fund balance 50,000
312000 369100 Estimated revenues 275,000 exp chg 17,250
-46000 (3,475)
369100 Revenues 282,200 13,775
Unreserved fund balance 43,425
Expenditures 223,775 (6,575)
635100 Encumbrances 15,000 50000
43,425
Debit Credit
Revenues Ledger (Balances)
Taxes 5,000
Interest & penalities 1,500
License, permits & fees 4,250
Intergovernmental grants 13,750
Investment revenue 1,250
Miscellaneous revenue 2,450
Totals 17,700 10,500
Expenditures Ledger (Balances)
General government 8,750
Public safety 125
Street and sanitation 1,750
Health and welfare 6,000
Community development 1,600
Parks and recreation 2,500
Totals 3,475 17,250

Option 2

Village of Rostern Village of Rostern
General Fund General Fund
Budget Statement of Revenues, Expenditures and Changes in Fund Balance - Budget to Actual
For Fiscal Year 20X9 For the Year Ended June 30, 20X9
Estimated Revenues: Original (and Final) Budget Actual on Budgetary Basis Variance Favorable / (Unfavorable
Taxes $ 225,000 Revenues
Interest & penalities 30,000 Taxes $ 225,000 $ 219,000 $ (6,000)
License, permits & fees 45,000 Interest & penalities 30,000 32,500 2,500
Intergovernmental grants 25,000 License, permits & fees 45,000 39,750 (5,250)
Investment revenue 85,000 Intergovernmental grants 25,000 48,750 23,750
Miscellaneous revenue 6,000 Investment revenue 85,000 82,750 (2,250)
Total estimated revenues $ 416,000 Miscellaneous revenue 6,000 9,450 3,450
$ 416,000 $ 432,200 $ 16,200
Appropriations: Expenditures
General government 90,000 General government 90,000 99,750 9,750
Public safety 33,000 Public safety 33,000 32,775 (225)
Street and sanitation 60,000 Street and sanitation 60,000 57,250 (2,750)
Health and welfare 45,000 Health and welfare 45,000 52,000 7,000
Community development 22,000 Community development 22,000 19,400 (2,600)
Parks and recreation 35,000 Parks and recreation 35,000 37,500 2,500
Total appropriations 285,000 285,000 298,675 13,675
Budgeted excess of revenues Excess of Revenues over
over appropriations $ 131,000 Expenditures 131,000 133,525 2,525
Fund Balance, July 1, 20X8 75,000 75,000 - 0
Fund Balance, June 30, 20X9 $ 206,000 $ 208,525 $ 2,525
Village of Rostern
General Fund
Preclosing Trial Balance
Revenue and Expenditures Subsidiary Ledgers
June 30, 20X9
Debit Credit
Revenues Subsidiary Ledger:
Taxes 6,000
Interest & penalities 2,500
License, permits & fees 5,250
Intergovernmental grants 23,750
Investment revenue 2,250
Miscellaneous revenue 3,450
Totals 13,500 29,700
Expenditures Subsidiary Ledger:
General government 9,750
5250000 57100 Public safety 225
145000 358000 Street and sanitation 2,750
5395000 11100 Health and welfare 7,000
-5100 Community development 2,600
5389900 139900 exp chg Parks and recreation 2,500
-75000 Totals 19,250 5,575
5314900
budget 5296000 Debit Credit
credit 518000 Closing entries rev change 29,700
debit -55000 463000 rev chg (13,500)
5759000 323100 chg Appropriations 285,000 16,200
46000 bud fund b Unreserved fund balance 131,000
312000 369100 Estimated revenues 416,000 exp chg 19,250
-46000 (5,575)
369100 Revenues 432,200 13,675
Unreserved fund balance 133,525
Expenditures 283,675 2,525
635100 Encumbrances 15,000 50000
52,525
Debit Credit
Revenues Ledger (Balances)
Taxes 6,000
Interest & penalities 2,500
License, permits & fees 5,250
Intergovernmental grants 23,750
Investment revenue 2,250
Miscellaneous revenue 3,450
Totals 29,700 13,500
Expenditures Ledger (Balances)
General government 9,750
Public safety 225
Street and sanitation 2,750
Health and welfare 7,000
Community development 2,600
Parks and recreation 2,500
Totals 5,575 19,250

Sheet3

DebitCredit

Revenues Subsidiary Ledger:

Taxes5,000

Interest & penalities1,500

License, permits & fees4,250

Intergovernmental grants13,750

Investment revenue1,250

Miscellaneous revenue2,450

Totals10,500 17,700

Expenditures Subsidiary Ledger:

General government8,750

Public safety125

Street and sanitation1,750

Health and welfare6,000

Community development1,600

Parks and recreation2,500

Totals17,250 3,475

Preclosing Trial Balance

Revenue and Expenditures Subsidiary Ledgers

June 30, 20X9

Village of AIU

General Fund