Financial Statement of a Church - Download as Excel

Document Sample
Financial Statement of a Church - Download as Excel Powered By Docstoc
					                                                                                      JERSEY BAPTIST CHURCH
                                                                                       FINANCIAL STATEMENT
                                                                                For the Month Ending August 31, 2007

                                                                                                              SECTION I - ACCOUNT BALANCES

                                                                                              Operating       Cash on         Café       Investment
                                                                                                                                                        Total
                                                                                              Checking         Hand        Inventory      Accounts
                                     Current Assets

                                   Balance Beginning of Month                                     605,959         1,287         4,475         6,672       618,392
                                    Receipts                                                      235,283                                         0       235,283
                                    Cash                                                             (715)          715                                         0
                                    Change in Inventory                                               321                        (321)                          0
                                    Interest / Dividends                                            2,566                                       30          2,595
                                    Bank Fees                                                        (601)                                                   (601)
                                    Reconciling Items (Payroll Liabilities)                         3,246                                                   3,246
                                    Accounts Payable Included in Expenses                           7,333                                                   7,333
                                    Expenses                                                     (297,725)                                        0      (297,725)
                                   Balance End of Month                                           555,667         2,002         4,154         6,701       568,524

                                                                                                                    SECTION II - RECEIPTS

                                                                                             Receipts this    Receipts    Budget Goal                    YTD
                                                                                                month        year to Date   to Date                   Over/Under
                                     Number of Weeks                                                     4            52           52

                                     UNDESIGNATED RECEIPTS                                        195,861      2,747,120    3,080,000                    (332,880)

                                     Average Weekly Rate                                           48,965        52,829       59,231                       (6,402)

                                     DESIGNATED RECEIPTS
                                     Acct. 4901.01 Lottie Moon                                      2,593        94,460
                                     Acct. 4901.02 Annie Armstrong                                    731        20,880
                                     Acct. 4901.03 Ray Roberts State Missions Offering                183         4,323
                                     Acct. 4901.04 Cooperative Program Special                                      293
                                     Acct. 4901.05 World Hunger                                                      30
                                     Acct. 4901.07Men's Mission Trailer                               302         7,369
                                     Acct. 4901.08 Volunteer Missions                                  60         2,051
                                     Acct. 4901.10 Kenya                                            1,050         2,305
                                     Acct. 4901.12 Katrina Relief                                                   130
                                     Acct. 4901.13 Israel Relief                                                     50
                                     Acct. 4901.14 Chile                                                            600
                                     Acct. 4901.16 Christian Associates International                 100           200
                                     Acct. 4901.17 Pac Rim Registrations                              350           530
                                     Acct. 4901.18 Pac Rim                                          1,687         2,038
                                     Acct. 4902.04 Chile Mission Trip                                (127)        5,408
                                     Acct. 4902.06 Belgium Mission Trip                                             913
                                     Acct. 4902.08 Bali Mission Trip                                             (1,276)
                                     Acct. 4902.09 Future Mission Trips                               677           892
                                     Acct. 4902.10 Mississippi Mission Trip                                       3,374
                                     Acct. 4902.12 Cambodia Mission Trip                             (537)       24,952
                                     Acct. 4902.13 Cleveland Hope Mission Trip                        553           943
                                     Acct. 4903.01 Pastor's Choice                                     20           550
                                     Acct. 4903.03 Music Pastor's Choice                                            525
                                     Acct. 4903.07 Youth Choice                                                     420
                                     Acct. 4903.12A/V Choice                                                      7,675
                                     Acct. 4903.13 Benevolence                                        185        22,574
                                     Acct. 4903.18 Jersey Media                                       188         3,529
                                     Acct. 4905.00 Growing the Vision, Net                          2,553        40,116
                                     Acct. 4906.07 Home Aid                                                       7,559
                                     Acct. 4906.08 Anniversary Celebration                                        6,496
                                     Acct. 4906.10 Creation Conference                                              712
                                     Acct. 4907.00 Reserve For Replacement                                        9,000
                                     Acct. 4908.04 Signs                                                         56,200
                                     Acct. 4908.08 Chapel Renovation / Heritage Service                          12,500
                                     Acct. 4908.09 TV Ministry                                                    1,000
                                     Acct. 4909.03 Choir Room Piano                                               2,500
                                     Acct. 4909.04 EMERGE Lights                                                  1,000
                                     Acct. 4909.05 AVION System                                                   2,000
                                     Acct. 4909.06 Third Camera in WAC                              3,000        13,100
                                     Acct, 4911.05 Keith Carver Memorial                                             50
                                     Acct. 4911.13 Leo Monroe Memorial                                               50
                                     Acct. 4911.14 Earl Cappel Memorial                                             160
                                     Acct. 4911.16 Bobby Jewell                                                      20
                                     Acct. 4914.00 Scholarship                                                    1,000
                                     Acct. 4920 Common Grounds Café                                 2,612        63,238
                                     Acct. 125 Missions Development                                   183         3,501
                                     Acct. 205 Salaries                                               100         4,060
                                     Acct. 240 Insurance                                              639         5,070
                                     Acct. 242 Annuities                                                         11,042
                                     Acct. 247 Expenses                                                               8
                                     Acct. 294 PC Committee                                                          30
                                     Acct. 310 General Music                                        4,159         4,199
                                     Acct. 312 Gospel Celebration                                   1,098         2,006
                                     Acct. 313 EMERGE                                                               182
                                     Acct. 330 Pageants                                                           6,789
                                     Acct. 340 Audio / Visual                                                     1,854
                                     Acct. 380 Preaching                                            4,644         8,419
                                     Acct. 415 Deacon Ministry                                                    1,455
                                     Acct. 430 Little Feet Preschool Ministries                                       8
                                     Acct. 440 Kids of The Kingdom                                  1,915         7,177
                                     Acct. 441 VBS                                                    385           430
                                     Acct. 442 Awana                                                              7,321
                                     Acct. 443 Upward Basketball                                                 29,464
                                     Acct. 450 Jersey Student Ministries                            2,445        51,236
                                     Acct. 460 Adults 18 to 29                                         42           156
                                     Acct. 462 OASIS Adults 55+                                     2,213         7,604
                                     Acct. 463 Adult Curriculum                                        57            57
                                     Acct. 470 Men's Ministries                                     4,046         4,364
                                     Acct. 475 Women's Ministries                                                10,214
                                     Acct. 511 Office Equipment                                                       8
                                     Acct. 515 Postage                                                               52
                                     Acct. 525 Member Involvement                                                   470
                                     Acct. 620 Outreach                                               100         1,701
                                     Acct. 630 Discipleship Training                                              4,394
                                     Acct. 660 Encouragement Ministry                                                17
                                     Acct. 720 Property Insurance                                   1,216         6,872
                                     Acct. 744 Guest House                                                        3,988
                                     Acct. 750 Grounds/Maintenance/Rentals                                          344
                                     Acct. 825 Computer Hardware / Software                                          60
                                     TOTAL DESIGNATED RECEIPTS                                     39,422       606,992

                                     TOTAL ALL RECEIPTS                                           235,283      3,354,111




2/7/2011 5:53 PM 6050262c-be9e-4124-bc4c-6593eb3f92d7.xls
                                                                 JERSEY BAPTIST CHURCH
                                                                   FINANCIAL STATEMENT
                                                            For The Month Ending August 31, 2007

                                                                                                   SECTION III - Sweep Account Analysis
                                                                                Beginning                                      Interest /        Ending
                                                                                 Balance         Receipts   Disbursements      Bank Fees         Balance
Total                                                                              605,959          234,568        (286,825)          1,965         555,667

Designated Savings
Missions
     Lottie Moon                             4901.01   5901.01                            0            2,593           (2,593)                            0
     Annie Armstrong                         4901.02   5901.02                            0              731             (731)                            0
     Ray Roberts                             4901.03   5901.03                            0              183             (183)                            0
     Cooperative Program Special             4901.04   5901.04                            0                                                               0
     Men's Mission Trailer                   4901.07   5901.07                        2,004             302             (471)                         1,835
     Volunteer Missions                      4901.08   5901.08                        7,671              60                                           7,731
     Reserve for Mission Development         4901.09   5901.09                       35,597                             1,443                        37,040
     Kenya                                   4901.10   5901.10                          100            1,050           (1,150)                            0
     Katrina Relief                          4901.12   5901.12                          130                              (130)                            0
     Christian Associates International      4901.16   5901.16                                           100             (100)                            0
     Pac Rim Registrations                   4901.17   5901.17                         180               350                                            530
     Pac Rim                                 4901.18   5901.18                         351             1,687            (142)                         1,896
Mission Trips
     Thailand Mission Trip                   4902.03   5902.03                                                           500                            500
     Chile Mission Trip                      4902.04   5902.04                          127             (127)                                             0
     Future Mission Trip                     4902.09   5902.09                          375              677                                          1,052
     Mississippi Mission Trip                4902.10   5902.10                           14                              (14)                             0
     Cambodia Mission Trip                   4902.12   5902.12                        1,367             (537)           (830)                             0
     Cleveland Hope                          4902.13   5902.13                          390              553            (943)                             0
Choice Accounts
     Pastor's Choice                         4903.01   5903.01                       16,881              20             (417)                        16,484
     Pastor's Choice Capital                 4903.02   5903.02                       11,000                                                          11,000
     Music Pastor's Choice                   4903.03   5903.03                          951                                                             951
     Children's Choice                       4903.05   5903.05                          667                                                             667
     Youth Choice                            4903.07   5903.07                          199                                                             199
     Upward Basketball Choice                4903.08   5903.08                          921                             (212)                           709
     College and Career Choice               4903.10   5903.10                        1,558                              (13)                         1,545
     Audio Visual Choice                     4903.12   5903.12                        2,200                                                           2,200
     Benevolence Choice                      4903.13   5903.13                       43,523             185            (2,223)                       41,485
     Transportation Choice                   4903.15   5903.15                           14                               (14)                            0
     Women's Ministry-Choice                 4903.16   5903.16                          264                                                             264
     Jersey Media                            4903.18   5903.18                        6,708             188                                           6,896
Property Acquisition
     Time Share                              4904.03   5904.03                         (709)                            (647)                        (1,356)
Growing The Vision
     Growing the Vision                      4905.00   5905.00                       10,422            2,553           (7,099)                        5,876
Events
     Home Aid                                4906.07   5906.07                        7,559                                                           7,559
Reserve for Replacement
     Replacement Fund                        4907.00   5907.00                     133,225                              (413)                       132,812
Projects
     Signs                                   4908.04   5908.04                       23,971                                                          23,971
     Chapel Renovations - Heritage Service   4908.08   5908.08                       10,500                             (613)                         9,887
     TV Ministry                             4908.09   5908.09                        1,000                                                           1,000
     83 Building Renovations                 4908.10   5908.10                          247                                                             247
     Lobby Displays                          4908.11   5908.11                        3,078                                                           3,078
Equipment
     EMERGE Lights                           4909.04   5909.04                        1,000                                                           1,000
     Third Camera in WAC                     4909.06   5909.06                       10,100            3,000                                         13,100
Memorials
     Thorson Memorial                        4911.15   5911.14                        3,818                                                           3,818
Reserve for Medical Deductibles
     Reserve for Medical Deductibles         4913.00   5913.00                       18,500                                                          18,500
Common Grounds Café
     Common Grounds Café                     4920.00   5920.00                       1,095             2,612          (3,164)                           543
Total Designated Savings                                                           356,997            16,180         (20,159)               0       353,018

Reserved for Current Liabilities                                                     20,971          (20,971)         31,550                         31,550

Undesignated Savings                                                               227,990           239,359        (298,216)           1,965       171,099


                                                                                               SECTION IV - Investment Accounts
                                                                  Beginning                                                                      Ending
                                                                   Balance       Deposits       Withdrawls      Sells/(Buys)      Dividends      Balance
Susan E. Legg Memorial Scholarship Fund                                6,672                                                               30         6,701



                                                                                             SECTION V - MORTGAGE LOANS
Maturity Date                                                      9/1/2012      1/24/2008     11/1/2012      1/24/2008       5/1/2011
Obligation Number                                                005-22-0131-6 005-08-5175-7 005-17-3292-3 005-15-7676-7 005-12-3061-3
Rate                                                                 6.00%         5.55%         6.45%          7.07%       LIBOR + 1.75
                                                                 (Fixed Rate) (Fixed Rate)   (Fixed Rate)  (Variable Rate) (Variable Rate)        Total

Balance, Beginning of Month                                                 0     1,011,493          304,117          210,798         659,916      2,186,324

Less: Payments                                                                       (1,248)          (1,635)           (331)          (3,886)       (7,099)
Plus: Interest Portion                                                                1,248            1,635             331            3,886         7,099
Plus: New Loans                                                     2,186,324    (1,011,493)        (304,117)       (210,798)        (659,916)            0
Balance, End of Month                                               2,186,324             0                0               0                0     2,186,324
Source of Funds used for Payments:
 Operating Funds                                                            0             0                0               0                0             0
 GTV Funds                                                                  0         1,248            1,635             331            3,886         7,099
Total                                                                       0         1,248            1,635             331            3,886         7,099



2/7/2011 5:53 PM 6050262c-be9e-4124-bc4c-6593eb3f92d7.xls
                                                                         JERSEY BAPTIST CHURCH
                                                                          FINANCIAL STATEMENT
                                                                               SECTION VI
                                                                          DISBURSEMENT DETAIL
                                                                              Year 2006/2007




                                                                                                                                                   REMAINING
                                                                                           Designated                                                BUDGET
                                                             August                         Income       Designated   Budget Spent   ANNUAL        (INCLUDES       % BUDGET
                                                            Disbursed     Disbursed YTD      August     Income YTD        YTD        BUDGET       DESIGNATED)      SPENT YTD

                    5200 · Personnel
                      5205 - Staff Salaries                    115,996         1,046,065          100         4,060      1,042,005    1,092,038          50,033         95.4%
                      5240 · Insurance                           7,376           123,755          639         5,070        118,685      138,763          20,078         85.5%
                      5241 · Social Security                     6,219            57,255                          0         57,255       63,792           6,537         89.8%
                      5242 · Annuity/Retirement                  6,453           105,411                     11,042         94,369       93,371            (998)       101.1%
                      5243 · Auto                                3,533            22,373                          0         22,373       24,500           2,127         91.3%
                      5246 · Conf./Cont. Education               2,687            11,888                          0         11,888       24,850          12,962         47.8%
                      5247 · Expense Accounts                      789             5,926                          8          5,918        6,450             532         91.7%
                      5248 · Ministry Resources                    279             3,542                          0          3,542        5,575           2,033         63.5%
                      5250 · Worker's Compensation               3,501            18,410                          0         18,410       12,450          (5,960)       147.9%
                      5260 · New Members Reception                                     0                          0              0          600             600          0.0%
                      5290 - Personnel Committee Expenses        1,993            14,666            0            30         14,636       19,500           4,864         75.1%
                    Total 5200 · Personnel                     148,827         1,409,291          739        20,210      1,389,081    1,481,889          92,808         93.7%




6050262c-be9e-4124-bc4c-6593eb3f92d7.xls 2/7/2011 5:53 PM
                                      JERSEY BAPTIST CHURCH
                                       FINANCIAL STATEMENT
                                 For The Period Ended August 31, 2007

                                            Section VII Cash Flow

                                                                    Current
                                                                    Month        Year to Date
Beginning Cash                                                       618,392           557,319
Ending Cash                                                          568,524           568,524
Total Cash Flow                                                      (49,868)           11,205

Budget Accounts
   Undesignated Budget Receipts                                      195,861         2,747,120
   Designated Receipts to Budget Accounts                             23,242           184,552
   Budget Account Expenses                                          (277,566)       (2,912,268)
   Impact on Cash Flow                                               (58,463)           19,404

Designated Accounts
    Designated Receipts                                               16,180           422,439
    Designated Expenses                                              (20,159)         (463,331)
    Impact on Cash Flow                                               (3,979)          (40,891)

Interest & Dividends Earned                                             2,595          29,585

Bank Charges                                                             (601)          (7,440)

Payroll Liabilities
    Beginning Liabilities                                             (2,207)           (1,184)
    Ending Liabilities                                                 5,453             5,453
    Impact on Cash Flow                                                3,246             4,270

Accounts Payable
    Beginning Accounts Payable                                        18,764           18,793
    Ending Accounts Payable                                           26,097           26,097
    Impact on Cash Flow                                                7,333            7,303

Susan E. Legg Memorial Scholarship Fund
    Expenses                                                                0           (1,025)
    Total                                                                   0           (1,025)

Total Cash Flow                                                      (49,868)          11,205

				
DOCUMENT INFO
Description: Financial Statement of a Church document sample