Get documents about "Financial Statement Church - Excel
W
Description
Financial Statement Church document sample
Document Sample
JERSEY BAPTIST CHURCH
FINANCIAL STATEMENT
For the Month Ending February 28, 2009
SECTION I - ACCOUNT BALANCES
Chase Raymond
National City National City Chase Chase Total Bank Cash on Café
Investment / James Total
Checking Savings Checking Savings Accounts Hand Inventory
Current Assets CD Investment
Annual Percentage Yield 0.0007% 4.00% 0.00% 0.33% 1.75%
Balance Beginning of Month 449,471 255,328 100 100,341 150,697 955,936 5,379 5,604 1,509 968,429
Receipts 315,689.03 315,689 0 315,689
Cash on Hand 1,202.28 1,202 (1,202) 0
Transfers (497,000) 497,000 38 (100,341) 100,303 0 0
Change in Inventory 94 94 (94) 0
Interest / Dividends (231.40) 1,287 18 1,074 0 1,074
Bank Fees (518.71) (519) (519)
Reconciling Items (Payroll Liabilities) (404) (404) (404)
Accounts Payable 3,551 3,551 3,551
Guest House Deposit Returned (250) (250) (250)
Expenses (242,372) (242,372) 0 (242,372)
Balance End of Month 29,231 753,615 138 18 251,000 1,034,002 4,177 5,510 1,509 1,045,199
29,231 753,615 138 18 251,000 1,034,002 4,177 5,510 1,509 1,045,199
Receipts this Receipts year Budget Goal YTD
month to Date to Date Over/Under
Number of Weeks 4 25 25
UNDESIGNATED RECEIPTS 224,784 1,494,895 1,586,538 (91,643)
Average Weekly Rate 56,196 59,796 63,462 (3,666)
Receipts this Receipts year
DESIGNATED RECEIPTS month to Date
Acct. 4901.01 Lottie Moon 2,900 40,192
Acct. 4901.02 Annie Armstrong 813 4,595
Acct. 4901.03 Ray Roberts State Missions Offering 2 2,669
Acct. 4901.07 Homeland Missions 500 4,460
Acct. 4901.08 Volunteer Missions 241 3,195
Acct. 4901.18 Pac Rim 165 165
Acct. 4901.19 Stowe Center Building 3,275 16,368
Acct. 4902.09 Future Mission Trips 135 135
Acct. 4902.12 Cambodia Mission Trip 58
Acct. 4903.07 Youth Choice 126
Acct. 4903.13 Benevolence 237 18,863
Acct. 4903.18 Jersey Media 508 1,862
Acct. 4903.20 North Campus Gym 641
Acct. 4903.21 Primetimers Choice 1,073
Acct. 4905.00 Growing the Vision, Net 3,083 19,364
Acct. 4906.07 Home Aid 2,800
Acct. 4906.15 Ronnie Hill 11,414
Acct. 4907 - Reserve for Replacement 57,868 57,868
Acct. 4911 Memorials 85
Acct. 4920 Common Grounds Café 8,971 34,679
TOTAL DESIGNATED RECEIPTS 78,696 220,612
Acct. 125 Missions Development 325 6,644
Acct. 140 International Volunteer Missions 866
Acct. 205 Salaries 725
Acct. 240 Insurance 500
Acct. 294 Personnel 200
Acct. 310 General Music 502 1,420
Acct. 312 Gospel Celebration 823
Acct. 313 Emerge 530
Acct. 316 Sign Language 42
Acct. 380 Preaching 100
Acct. 410 Bible Fellowship Events 451
Acct. 442 Awana 808 5,166
Acct. 443 Upward Basketball 30,046
Acct. 450 Jersey Student Ministries 8,682 12,329
Acct. 460 Adults 18 to 29 8
Acct. 462 Jersey Prime Timers 400 3,406
Acct. 475 Women's Ministries 1,155 3,687
Acct. 510 Office Supplies 133
Acct. 515 Postage 79
Acct. 530 Stewardship 778
Acct. 620 Outreach 97 677
Acct. 630 Discipleship Training 240 1,742
Acct. 640 Because We Care 4,202
Acct. 720 Property Insurance 311
Acct. 730 Property Taxes 906
Acct. 741 Telephone 674
Acct. 744 Guest House 1,825
Acct. 820 Capital 750
TOTAL SPECIFIC MINISTRY RECEIPTS 12,209 79,020
TOTAL ALL RECEIPTS 315,689 1,794,527
2/7/2011 6:09 PM 3710f873-1fed-437c-a9eb-ce66bb653d78.xls
JERSEY BAPTIST CHURCH
FINANCIAL STATEMENT
For The Month Ending February 28, 2009
SECTION III - Sweep Account Analysis
Beginning Ending
Interest / Bank
Balance Receipts Disbursements Fees / Other Balance
Total 955,936 316,891 (239,650) 824 1,034,002
Designated Savings
Missions
Lottie Moon 4901.01 5901.01 0 2,900 (2,900) 0
Annie Armstrong 4901.02 5,901 0 813 (813) 0
Ray Roberts 4901.03 5901.03 0 2 (2) 0
Homeland Missions 4901.07 5901.07 6,957 500 (40) 7,417
Volunteer Missions 4901.08 5901.08 18,990 241 (100) 19,131
Reserve for Mission Development 4901.09 5901.09 86,447 1,692 88,139
PAC RIM 4901.18 5901.18 165 165
Stowe Center Building 4901.19 5901.19 0 3,275 (3,275) 0
Mission Trips
Future Mission Trip 4902.09 5902.09 2,417 135 2,552
Choice Accounts
Pastor's Choice 4903.01 5903.01 16,218 (517) 15,701
Pastor's Choice Capital 4903.02 5903.02 18,390 18,390
Music Pastor's Choice 4903.03 5903.03 958 958
Children's Choice 4903.05 5903.05 367 367
Preschool Choice 4903.06 5903.06 6,406 6,406
Youth Choice 4903.07 5903.07 303 303
Young Adult Choice 4903.10 5903.10 1,387 1,387
Benevolence Choice 4903.13 5903.13 49,224 237 (483) 48,978
Women's Ministry-Choice 4903.16 5903.16 264 264
Jersey Media 4903.18 5903.18 7,689 508 (24) 8,172
Synaxis Choice 4903.19 5903.19 3,279 (160) 3,119
North Campus Gym 4903.20 5903.20 641 641
Primetimers Choice 4903.21 5903.21 1,073 1,073
Property Acquisition
Time Share 4904.03 5904.03 (1,356) (783) (2,140)
Growing The Vision
Growing the Vision 4905.00 5905.00 86,816 3,083 89,898
Reserves
Replacement Fund 4907.00 5907.00 179,148 (760) 178,388
Roof Relplacement 4907.00 5907.00 57,868 57,868
Reserve for Medical Deductibles 4913.00 5913.00 18,500 18,500
Reserve for Background Checks 4915.00 5915.00 776 (33) 743
Projects
Signs 4908.04 5908.04 54,077 54,077
TV Ministry 4908.09 5908.09 1,000 1,000
Equipment
EMERGE Lights 4909.04 5909.04 1,000 1,000
Third Camera in WAC 4909.06 5909.06 1,478 1,478
Memorials
Thorson Memorial 4911.15 5911.14 3,818 3,818
Common Grounds Café
Common Grounds Café 4920.00 5920.00 6,950 8,971 (7,000) 8,921
Total Designated Savings 573,219 78,696 (15,196) 0 636,719
Reserved for Current Liabilities 20,842 (20,842) 23,990 23,990
Undesignated Savings 361,876 259,037 (248,443) 824 373,294
SECTION IV - Investment Accounts
Beginning Ending
Balance Deposits Withdrawls Sells/(Buys) Dividends Balance
Susan E. Legg Memorial Scholarship Fund 1,509 0 1,509
SECTION V -
MORTGAGE
LOANS
Maturity Date 9/1/2012
Obligation Number 005-22-0131-6
Rate 6%
(Fixed Rate)
Balance, Beginning of Month 1,952,058
Less: Payments (24,373)
Plus: Interest Portion 10,086
Balance, End of Month 1,937,770
2/7/2011 6:09 PM 3710f873-1fed-437c-a9eb-ce66bb653d78.xls
JERSEY BAPTIST CHURCH
FINANCIAL STATEMENT
SECTION VI
DISBURSEMENT DETAIL
Year 2008/2009
REMAINING 5%
Designated Reduced MAP % Reduced
February Income Designated Budget Spent 5% Reduced (INCLUDES MAP SPENT
Disbursed Disbursed YTD February Income YTD YTD Map DESIGNATED) YTD
5100 · Missions & Benevolence
5110 · Co-op Progr 11% 24,750 164,452 0 164,452 344,850 180,398 47.7%
5120 · MCBA 1.5% 3,375 22,425 0 22,425 47,025 24,600 47.7%
5125 · Missions Devel 1.5% 3,700 29,070 325 6,644 22,425 47,025 24,600 47.7%
5140 - Interrnational Volunteer Missions 1,944 866 1,078 2,018 940 53.4% Penny - Vision for Cambodia Trip
Total 5100 · Missions & Benevolence 31,825 217,891 325 7,510 210,381 440,918 230,537 47.7%
5200 · Personnel
5205 - Staff Salaries 92,256 563,979 725 563,254 1,150,109 586,855 49.0%
5240 · Insurance 11,881 75,723 500 75,223 159,046 83,823 47.3%
5241 · Social Security 3,954 24,045 0 24,045 50,365 26,320 47.7%
5242 · Annuity/Retirement 7,986 48,046 0 48,046 96,449 48,403 49.8%
5243 · Auto 744 6,183 0 6,183 24,250 18,067 25.5%
5246 · Conf./Cont. Education 3,805 0 3,805 15,675 11,870 24.3%
5247 · Expense Accounts 212 2,160 0 2,160 4,940 2,780 43.7%
5248 · Ministry Resources 368 2,018 0 2,018 3,610 1,592 55.9% Cell Phone Equipment
5250 · Worker's Compensation 2,955 0 2,955 4,143 1,188 71.3% Semi Ann. Payment, Rate increase, Group Fee
5290 - Personnel Committee Expenses 80 4,675 0 200 4,475 15,542 11,067 28.8%
Total 5200 · Personnel 117,480 733,588 0 1,425 732,163 1,524,129 791,966 48.0%
5300 · Music & Worship Exp
5310 - General Music 671 4,839 502 1,420 3,419 9,433 6,014 36.2%
5311 - Jersey Live 510 3,008 0 3,008 8,215 5,207 36.6%
5312 - Gospel Celebration 434 4,412 823 3,589 4,750 1,162 75.5% Concerts & Special Fluid, Speakers, Stands,
Cables, Mics, Haze groups
5313 - Emerge (1,429) 4,935 530 4,405 5,843 1,438 75.4% Christmas Eve
5314 - Synaxis 101 979 0 979 5,564 4,585 17.6%
5315 - Children's & Youth Music 1,000 0 1,000 1,633 633 61.2% Children's Christmas Music
5316 - Holy Hands Signing 40 42 (2) 42 44 -4.8%
5330 - Pageants & Musicals 796 1,019 0 1,019 13,300 12,281 7.7%
5340 - Audio Visual Technology Expense 535 4,970 0 4,970 9,485 4,515 52.4% Chapel Screen
5355 - Flowers / Decorations / Banners 108 0 108 1,140 1,032 9.4%
5380 · Worship Enhancements 1,356 2,663 100 2,563 7,639 5,076 33.6%
5385 · Ushers 38 515 0 515 1,092 577 47.2%
Total 5300 · Music & Worship Exp 3,013 28,488 502 2,915 25,573 68,136 42,563 37.5%
5400 · Education Ministries
Refund on Portable Toilet for August Reunion;
5410 · Churchwide Events (145) 451 (596) 4,750 5,346 -12.5% Returned Scanner purchased in May
5411 - Family Ministries (75) 803 0 803 1,425 622 56.4% Revolutionary parenting simulcast
5415 - Deacons 264 886 0 886 2,185 1,299 40.5%
5430 · Little Feet PreSchool Ministries (687) 5,533 0 5,533 19,950 14,417 27.7%
5440 · Kidz of The Kingdom Ministries 1,677 13,000 0 13,000 29,649 16,649 43.8%
5441 · Vacation Bible School 190 60 0 60 6,650 6,590 0.9% Previous year returns
5442 - Awana 258 6,004 808 5,166 838 7,790 6,952 10.8%
5443 - Upward Basketball 2,982 30,706 30,046 661 2,200 1,539 30.0%
5450 · Jersey Student Ministries 4,057 19,730 8,682 12,329 7,400 21,090 13,690 35.1%
5460 · Adults 18 to 29 293 1,737 8 1,729 6,650 4,921 26.0%
5461 · Adults 30 to 54 111 947 0 947 2,422 1,475 39.1%
Income for tickets to concert that were
5462 · Jersey Prime Timers 1,742 4,210 400 3,406 804 3,966 3,162 20.3% purchased last fiscal year.
5463 - Adult Bible Fellowship Curriculum (47) 6,763 0 6,763 24,049 17,286 28.1%
5464 - Adult Singles 30+ 90 0 90 380 290 23.6%
5470 - Men's Ministries 134 0 134 6,650 6,516 2.0%
5475 - Women's Ministries 582 5,985 1,155 3,687 2,298 8,645 6,347 26.6%
Total 5400 · Education Ministries 11,347 96,445 11,045 55,093 41,352 148,451 107,099 27.9%
3710f873-1fed-437c-a9eb-ce66bb653d78.xls 2/7/2011 6:09 PM
JERSEY BAPTIST CHURCH
FINANCIAL STATEMENT
SECTION VI
DISBURSEMENT DETAIL
Year 2008/2009
REMAINING 5%
Designated Reduced MAP % Reduced
February Income Designated Budget Spent 5% Reduced (INCLUDES MAP SPENT
Disbursed Disbursed YTD February Income YTD YTD Map DESIGNATED) YTD
5500 · Admin./Support
5510 · Office Supplies 403 6,500 133 6,367 16,610 10,243 38.3%
Annual Contracts Folder Maintenance Personal
5511 - Office Equipment 2,536 17,081 0 17,081 30,422 13,341 56.1% Property Taxes
5512 - Church Council, Professional & Legal Fees 17 1,261 0 1,261 8,190 6,929 15.4%
5515 · Postage 1,180 6,318 79 6,240 9,832 3,592 63.5% The Event Postage $1260
5520 · External Communications 342 4,259 0 4,259 10,954 6,695 38.9%
5530 · Stewardship 3,157 778 2,380 5,217 2,837 45.6% W2 forms, Envelopes
5545 - IT Expenses 1,362 7,152 0 7,152 13,879 6,727 51.5%
5570 · Recognitions 50 0 50 493 443 10.1%
5575 - Welcome Team 205 0 205 325 120 63.0% Luminaries for Christmas Eve
5580 - Contingencies 1,119 3,304 0 3,304 35,596 32,292 9.3%
5587 - Internal Communications 22 5,736 0 5,736 14,644 8,908 39.2%
Total 5500 · Admin./Support 6,980 55,023 0 989 54,034 146,162 92,128 37.0%
5600 - Evangelism & Discipleship
5610 - Benevolence & Counseling .5% 1,125 7,474 0 7,474 15,675 8,201 47.7%
5620 - Outreach 769 3,345 97 677 2,668 2,874 206 92.8% The Event (New Testaments)
5630 - Discipleship Training 1,226 4,670 240 1,742 2,928 4,650 1,722 63.0% Materials for Upcoming Quarter
5640 - Community Involvement / Servanthood 12,295 4,202 8,093 8,093 0 100.0% The Event
5650 - Intercessory Prayer Ministry 0 0 0 35 35 0.0%
5660 - Comfort & Encouragement Ministry 518 2,115 0 2,115 3,230 1,115 65.5% Flowers
Total 5600 · Evangelism & Discipleship 3,638 29,900 337 6,621 23,279 34,557 11,278 67.4%
5700 · Facilities/Operations
5710 · Debt Service 24,373 146,240 0 146,240 292,500 146,260 50.0%
5720 · Property Insurance 14,842 311 14,531 29,500 14,969 49.3% Semi Annual Premiums
5730 - Property Taxes 4,109 4,109 906 3,203 7,300 4,097 43.9%
5740 · Utilities 16,321 100,529 0 100,529 211,280 110,751 47.6%
5741 · Telephone 1,801 12,324 674 11,650 23,000 11,350 50.7%
5744 - Guest House 623 2,792 1,825 967 877 (90) 110.2% Winter Gas Bills
5750 · Grounds / Maintenance / Rentals 2,473 18,418 0 18,418 35,259 16,841 52.2% Heating repairs
5760 · Custodial Supplies 513 3,411 0 3,411 9,253 5,842 36.9%
5770 · Transportation 536 1,015 0 1,015 3,854 2,839 26.3%
5782 · Security 108 609 0 609 1,434 825 42.5%
5791 - Recreation / Athletics 0 0 0 475 475 0.0%
Total 5700 · Facilities/Operations 50,857 304,289 0 3,716 300,572 614,732 314,160 48.9%
5800 · Capital Expenditures
5820 · Equipment / Furnishings 3,653 750 2,903 114,240 111,337 2.5%
5825 · Computer Hardware/Software 1,794 2,264 0 2,264 16,625 14,361 13.6%
Accrue to full MAP through Jan. Will reduce for
5850 · Reserve for Replacement 240 25,600 0 25,600 27,050 1,450 94.6% the rest of the year.
Total 5800 · Capital Expenditures 2,034 31,517 0 750 30,767 157,915 127,148 19.5%
TOTAL (All undesignated accounts) 227,176 1,497,140 12,209 79,020 1,418,120 3,135,000 1,716,880 45.2%
3710f873-1fed-437c-a9eb-ce66bb653d78.xls 2/7/2011 6:09 PM
JERSEY BAPTIST CHURCH
FINANCIAL STATEMENT
SECTION VI
DISBURSEMENT DETAIL
Year 2008/2009
REMAINING 5%
Designated Reduced MAP % Reduced
February Income Designated Budget Spent 5% Reduced (INCLUDES MAP SPENT
Disbursed Disbursed YTD February Income YTD YTD Map DESIGNATED) YTD
5900 · Designated Disbursement
5901.01 - Lottie Moon 2,900 40,192 2,900 40,192
5901.02 - Annie Armstrong 813 4,595 813 4,595
5901.03 - Ray Roberts 2 2,669 2 2,669
5901.07 - Homeland Missions 40 249 500 4,460
5901.08 - Volunteer Missions 100 (953) 241 3,195
5901.09 - Missions Development Reserve (1,692) (12,526) 0
5901.18 - Pac Rim 0 165 165
5901.19 - Stowe Center Building 3,275 16,568 3,275 16,368
5902.09 - Future Mission Trips (375) 135 135
5902.12 - Cambodia Mission Trip 433 58
5903.01 - Pastor's Choice 517 917 0
5903.07 - Youth Choice 0 126
5903.10 - Young Adult Choice 157 0
5903.13 - Benevolence Choice 483 10,172 237 18,863
5903.18 - Jersey Media 24 2,160 508 1,862
5903.19 - Synaxis Choice 160 160 0
5903.20 - North Campus Gym 0 641
5903.21 - Primetimers Choice 0 1,073
5904.03 - Time Share 783 783 0
5905.00 - GTV 0 3,083 19,364
5906.07 - Home Aid 2,970 2,800
5906.15 - Ronnie Hill 11,414 11,414
5907.00 - Reserve for Replacement 760 (13,350) 57,868 57,868
5908.04 - Signs 294 0
5909.06 - Third Camera in WAC 443 0
5911.19 - Dr. Huang Memorial 2,535 85
5915.00 - Reserve for Background Checks 33 1,030 0
5920.00 - Common Grounds Café 7,000 32,925 8,971 34,679
Total 5900 · Designated Disbursement 15,196 103,463 78,696 220,612
Total All Disbursements 242,372 1,600,603 90,905 299,632
3710f873-1fed-437c-a9eb-ce66bb653d78.xls 2/7/2011 6:09 PM
JERSEY BAPTIST CHURCH
FINANCIAL STATEMENT
For The Period Ended February 28, 2009
Section VII Cash Flow
Current
Month Year to Date
Beginning Cash 968,429 862,121
Ending Cash 1,045,199 1,045,199
Total Cash Flow 76,770 183,077
Budget Accounts
Undesignated Budget Receipts 224,784 1,494,895
Designated Receipts to Budget Accounts 12,209 79,020
Budget Account Expenses (227,176) (1,497,140)
Impact on Cash Flow 9,817 76,775
Designated Accounts
Designated Receipts 78,696 220,612
Designated Expenses (15,196) (103,463)
Impact on Cash Flow 63,500 117,149
Interest & Dividends Earned 1,074 7,208
Bank Charges (519) (3,177)
Payroll Liabilities
Beginning Liabilities (5,391) (5,930)
Ending Liabilities 4,987 4,987
Impact on Cash Flow (404) (943)
Accounts Payable
Beginning Accounts Payable 15,451 32,687
Ending Accounts Payable 19,002 19,002
Impact on Cash Flow 3,551 (13,685)
Guest House Deposits
Received
Returned (250) (250)
Impact on Cash Flow (250) (250)
Total Cash Flow 76,770 183,077
Related docs
