Account Balances Report4/29/2008 Page 1 06:13p as of the end of April, Fiscal Year 2008 Concordia Lutheran Church Fund: 01 General Fund Activity through Beginning Current Account (* = Inactive) April Bal. for Year Balance Assets 011-10-00-00 Checking Acct 13909 10,514.34 19,472.13 29,986.47 011-11-05-00 Stock Etc. 0.00 0.00 0.00 011-11-10-00 Credits 0.00 0.00 0.00 011-12-10-85 Preschool Teacher 49,849.20 0.00 49,849.20 011-12-10-88 Extended Care Wages 4,510.35 0.00 4,510.35 011-12-10-90 Preschool Aide Wages 16,417.30 0.00 16,417.30 011-12-10-96 P S Util. etc Receivable 9,858.65 100.00 9,958.65 011-12-10-98 P S Admin Exp Receivable 1,833.30 0.00 1,833.30 011-12-10-99 P S Receivables/Pmts -82,568.80 0.00 -82,568.80 011-12-12-10 Cook Wages 14,029.95 0.00 14,029.95 011-12-12-99 Lunch Receivable/Pmts -14,029.95 0.00 -14,029.95 Total Assets: 10,414.34 19,572.13 29,986.47 Liabilities 012-01-01-01 Salary Exp Payable 0.00 6,500.00 6,500.00 012-10-35-02 Prepaid Fair Share 1,411.64 45.00 1,456.64 012-15-15-01 WBP Payable 7,616.08 -7,616.08 0.00 012-15-21-10 Pastor TSA Payable 0.00 0.00 0.00 012-15-21-11 Pastor TSA Pmts 0.00 0.00 0.00 012-15-21-31 Principal TSA Payable 0.00 0.00 0.00 012-15-21-32 Preschool TSA Payable 0.00 0.00 0.00 012-15-21-33 K Grade TSA Payable 0.00 0.00 0.00 012-15-21-34 2nd Grade TSA Payable -51.68 -25.08 -76.76 012-15-21-35 4th Grade TSA Payable 0.00 0.00 0.00 012-15-21-36 6th Grade TSA Payable 0.00 0.00 0.00 012-15-21-38 Secretary TSA Payable 0.00 0.00 0.00 012-15-21-39 Cook TSA Payable 0.00 0.00 0.00 012-15-23-97 Pmt - FICA/Medicare -24,774.70 0.00 -24,774.70 012-15-23-98 FICA/Medicare 12,387.35 0.00 12,387.35 012-15-23-99 FICA Employer Share 12,387.35 0.00 12,387.35 012-15-24-97 Pmt - Fed. Inc. Tax -25,949.19 0.00 -25,949.19 012-15-24-99 Fed Withholding 25,949.19 0.00 25,949.19 012-15-25-97 Pmt - State Inc. Tax -6,258.31 0.00 -6,258.31 012-15-25-99 State W/H 6,258.31 0.00 6,258.31 012-15-29-80 Worker Comp Payable 847.83 764.67 1,612.50 012-30-30-01 Missions Payable -1,708.33 1,708.33 0.00 012-40-40-01 Mortgage Payable 0.00 0.00 0.00 012-50-50-01 Lutheran High Payable -275.00 2,366.00 2,091.00 Total Liabilities: 7,840.54 3,742.84 11,583.38 Income 015-10-00-10 Collections 267,382.12 0.00 267,382.12 015-10-00-40 Sunday School 44.24 0.00 44.24 015-10-00-41 Bible Class 0.00 0.00 0.00 015-10-00-50 Adopt-A-Bill 0.00 0.00 0.00 015-10-00-80 Rental Income 50.00 0.00 50.00 015-10-00-82 Investment Inc/Loss 0.00 0.00 0.00 015-10-00-85 Interest Income - Reg 95.44 0.00 95.44 015-10-00-88 Utility Reimb. Preschool 8,333.30 0.00 8,333.30 015-10-00-90 Utility Reimb. Lunch 0.00 0.00 0.00 015-10-00-93 PS Admin. Reimb. 1,833.30 0.00 1,833.30 015-10-00-95 Miscellaneous 2,246.94 0.00 2,246.94 015-10-30-02 Fair Share & Tuition 128,225.61 0.00 128,225.61 015-10-30-03 Financial Aide 0.00 0.00 0.00 015-10-30-04 Collection Prior Yr Rec 740.00 0.00 740.00 015-10-90-01 Transfer General Fund 0.00 0.00 0.00 015-10-90-02 Lynn Fund - Transfer 0.00 0.00 0.00 Total Income: 408,950.95 0.00 408,950.95 Expense 016-01-01-02 Taxable Life Ins Income 0.00 0.00 0.00 016-01-01-03 Taxable Life Ins Deduct 0.00 0.00 0.00 016-20-10-01 Pastor Salary 13,410.40 0.00 13,410.40 016-20-10-03 Pastor Housing 25,000.00 0.00 25,000.00 016-20-10-06 Misc Expense 0.00 0.00 0.00 016-20-15-01 Asst Pastor Salary 0.00 0.00 0.00 016-20-15-03 Asst Pastor Housing 2,417.96 0.00 2,417.96 016-20-15-05 Value of Parsonage 0.00 0.00 0.00 016-20-17-10 Pastor Car Expense 3,649.94 0.00 3,649.94 016-20-17-15 Asst Pastor Car Exp 187.50 0.00 187.50 016-20-20-01 Secretary Wages 23,246.36 0.00 23,246.36 016-20-20-20 Sub. Secretary 0.00 0.00 0.00 016-20-90-10 Pastor WBP 17,463.32 0.00 17,463.32 016-20-90-15 Asst. Pastor WBP 695.68 0.00 695.68 016-20-90-20 Secretary WBP 7,413.79 0.00 7,413.79 016-20-91-99 Elder's Workman's Comp 422.89 0.00 422.89 016-20-92-99 Elder's FICA 1,785.61 0.00 1,785.61 016-30-01-01 Salary - Principal 21,489.80 0.00 21,489.80 016-30-01-03 Principal Housing 20,689.80 0.00 20,689.80 016-30-02-01 6th Grade Teacher 12,023.04 0.00 12,023.04 016-30-02-03 6th Grade Teacher Housin 11,095.04 0.00 11,095.04 016-30-03-01 4th Gr Teacher Salary 20,035.80 0.00 20,035.80 016-30-04-01 2nd Grade Salary 16,686.80 0.00 16,686.80 016-30-04-03 2nd Grade Housing 14,544.00 0.00 14,544.00 016-30-05-01 Kindergarten Salary 20,156.00 0.00 20,156.00 016-30-05-03 Kindergarten Housing 0.00 0.00 0.00 016-30-10-01 School Aide 1,479.38 0.00 1,479.38 016-30-28-01 Partime Teachers Sal 4,031.20 0.00 4,031.20 016-30-28-26 Music Teacher 1,823.68 0.00 1,823.68 016-30-30-01 Substitute Teachers Wage 604.01 0.00 604.01 016-30-90-01 Principal WBP 17,801.56 0.00 17,801.56 016-30-90-02 6th Grade Teacher WBP 12,738.14 0.00 12,738.14 016-30-90-03 4th Grade WBP 1,732.36 0.00 1,732.36 016-30-90-04 2nd Grade WBP 7,737.42 0.00 7,737.42 016-30-90-05 Kindergarden WBP 7,147.30 0.00 7,147.30 016-30-91-99 Education Worker Comp 954.75 0.00 954.75 016-30-92-99 Education FICA 3,688.19 0.00 3,688.19 016-45-00-01 Continuing Ed 0.00 0.00 0.00 016-45-00-03 Parish Ed 2,115.60 0.00 2,115.60 016-45-00-05 Workshops 29.02 0.00 29.02 016-45-00-06 School Funiture 0.00 0.00 0.00 016-45-00-07 Scholarships 1,000.00 0.00 1,000.00 016-45-00-08 Tuition Processing 0.00 0.00 0.00 016-45-00-09 Moving Expense 0.00 0.00 0.00 016-45-00-12 Advertising/School 0.00 0.00 0.00 016-45-00-20 Postage 26.80 0.00 26.80 016-50-01-01 Organist Wages 4,120.00 0.00 4,120.00 016-50-91-99 Organist Worker Comp 32.75 0.00 32.75 016-50-92-99 Organist FICA 315.18 0.00 315.18 016-55-00-00 Choir Director Wages 833.40 0.00 833.40 016-55-91-00 Choir Dir Worker Comp 0.00 0.00 0.00 016-55-92-00 Choir Dir FICA 63.80 0.00 63.80 016-60-00-00 Pastoral Services 3,266.69 0.00 3,266.69 016-60-00-01 Guest Pastor - Fee 325.00 0.00 325.00 016-60-00-02 Supplies/Elders 2,948.66 0.00 2,948.66 016-60-00-03 Paper/Elders 1,285.52 0.00 1,285.52 016-60-00-04 Postage 1,285.00 0.00 1,285.00 016-60-00-05 Workshops 255.20 0.00 255.20 016-60-00-06 Advertising 0.00 0.00 0.00 016-60-00-07 Moving Expense 0.00 0.00 0.00 016-65-09-98 Custodian FICA 755.95 0.00 755.95 016-65-09-99 Custodians Worker Comp 515.84 0.00 515.84 016-65-10-01 Custodians 9,660.42 0.00 9,660.42 016-65-10-02 Snow Removal 120.00 0.00 120.00 016-65-90-01 Custodian WBP 790.50 0.00 790.50 016-70-00-02 Asbestos 520.00 0.00 520.00 016-70-00-03 Maintenance 4,266.06 0.00 4,266.06 016-70-00-04 Supplies/Trustees 5,796.48 0.00 5,796.48 016-70-00-05 Water & Electric 16,889.31 0.00 16,889.31 016-70-00-06 Natural Gas 8,609.82 0.00 8,609.82 016-70-00-07 Telephone 1,985.82 0.00 1,985.82 016-70-00-08 Garbage Removal 1,299.80 0.00 1,299.80 016-70-00-09 Office Machines 3,718.65 0.00 3,718.65 016-80-00-01 Bullitins 0.00 0.00 0.00 016-80-00-02 Music 547.20 0.00 547.20 016-80-00-03 Periodicals 0.00 0.00 0.00 016-80-00-04 Alter Supplies 176.85 0.00 176.85 016-89-00-01 Adult Activity-75 Annive 0.00 0.00 0.00 016-90-00-01 Youth 209.17 0.00 209.17 016-91-00-01 Stewardship 751.04 0.00 751.04 016-92-00-01 Evangelism 0.00 0.00 0.00 016-93-10-10 Missions 17,500.00 0.00 17,500.00 016-94-20-10 Mortgage 0.00 0.00 0.00 016-96-10-00 Lutheran High 21,735.00 0.00 21,735.00 016-99-40-00 Insurance 4,638.11 0.00 4,638.11 016-99-99-10 Payroll Processing 0.00 0.00 0.00 016-99-99-20 Misc/NSF/Refund 22.25 0.00 22.25 Total Expense: 410,562.61 0.00 410,562.61 Dedicated 017-10-00-01 School Reg./Books 3,876.64 1,500.00 5,376.64 017-10-00-03 Future Yr. School Reg. -1,834.18 1,834.18 0.00 017-10-00-04 School Spec. Gifts 6,194.14 9,915.33 16,109.47 017-10-00-05 Food Pantry (was Roof Fd -74.28 552.02 477.74 017-10-00-06 Bd. of Special Ministrie -41.00 198.32 157.32 017-10-00-10 Brian Hanebutt Soc. Serv 1,032.36 1,444.45 2,476.81 017-10-00-15 Huber Evan/Promotion Fun 3,547.14 0.00 3,547.14 017-10-00-16 Huber Sanctuary Fund 500.00 0.00 500.00 017-10-00-20 Adult Activity Fund 0.00 140.00 140.00 017-10-00-34 Confirmation Trip/Exp 0.00 -34.50 -34.50 017-10-00-40 Flowers 0.00 0.00 0.00 017-10-00-50 Fund High Sch Youth Conf -209.90 2,402.43 2,192.53 017-10-00-55 Fund 7th-8th Youth 20.00 291.23 311.23 017-10-00-59 Building Fund -1,899.15 -1,640.15 -3,539.30 017-10-00-60 Time to Build Up 0.00 0.00 0.00 017-10-00-61 Parsonage Escrow 0.00 0.00 0.00 017-10-00-62 Life Safety -672.60 1,161.00 488.40 017-10-00-65 Office Equip/Safety Fund 0.00 250.00 250.00 017-10-00-70 Lynn Foundation 574.90 0.00 574.90 017-10-00-75 Memorial Fund -9,514.34 21,789.15 12,274.81 017-10-00-79 Adult Bible Class -Sunda -363.35 449.66 86.31 017-10-00-80 Fellowship was Music Fd 1,117.00 30.34 1,147.34 017-10-00-81 Church Library 0.00 0.00 0.00 017-10-00-82 Music Choir (was Play Gn 600.00 100.00 700.00 017-10-00-84 Nursery 0.00 161.00 161.00 017-10-00-85 Special In/Out 20.00 59.00 79.00 017-10-00-90 Fund Vacation Bible Scho -200.46 299.48 99.02 017-10-90-03 Bethesda 0.00 0.00 0.00 017-10-90-05 Bible Translators 0.00 0.00 0.00 017-10-90-20 Fort Wayne Seminary 0.00 0.00 0.00 017-10-90-35 Lutheran Witness 88.16 71.50 159.66 017-10-90-40 Lutherans for Life -420.00 420.00 0.00 017-10-90-42 Lutheran Hour 0.00 0.00 0.00 017-10-90-45 Lutheran TV 0.00 0.00 0.00 017-10-90-47 Fund Lutheran High 0.00 0.00 0.00 017-10-90-50 Fund LWML 0.00 20.00 20.00 017-10-90-65 Fund Missions 0.00 0.00 0.00 017-10-90-70 Concordia Histotical Ins 0.00 15.00 15.00 017-10-90-75 Seminary Training 0.00 0.00 0.00 017-10-90-85 World Relief 0.00 0.00 0.00 017-30-00-05 AAL Preschool Grant 0.00 0.00 0.00 017-30-00-10 AAL Early Childhood Gran 0.00 0.00 0.00 017-30-00-15 Education Foundation 0.00 15.00 15.00 017-30-00-16 Rel. Coll Scholarship Fd 538.00 0.00 538.00 017-30-00-17 Pastor Continuing Ed Fun 1,456.66 0.00 1,456.66 017-30-00-19 K-8 Scholarships -150.28 1,761.94 1,611.66 017-30-00-20 Huber Scholar Fd/Bequest 0.00 0.00 0.00 017-30-00-25 PTL Scholship 0.00 0.00 0.00 017-30-00-30 Nitz Scholarship Fund 0.00 709.68 709.68 Total Dedicated: 4,185.46 43,916.06 48,101.52 Summary of Account Balances Assets: 10,414.34 19,572.13 29,986.47 - Liabilities: 7,840.54 3,742.84 11,583.38 - Dedicated: 4,185.46 43,916.06 48,101.52 Expected Equity: -1,611.66 -28,086.77 -29,698.43 Equity Accounts: 0.00 0.00 0.00 + Fund Balance: -1,611.66 -28,086.77 -29,698.43 Actual Equity: -1,611.66 -28,086.77 -29,698.43 Income: 408,950.95 0.00 408,950.95 - Expense: 410,562.61 0.00 410,562.61 Income Less Expense: -1,611.66 0.00 -1,611.66