Treasurer's Report4/29/2008 Page 1 Concordia Lutheran Church06:14p April of Fiscal Year 2008 Responsibility: All Fund: 01 - General Fund April Year-to-date Annual Percent of Actual Actual Budget Budget Income Major: Gen. Income / Minor: Gen. Income Collections 33,048.47 267,382.12 300,000.00 89.13% Sunday School 1.00 44.24 150.00 29.49% Bible Class 0.00 0.00 0.00 0.00% Adopt-A-Bill 0.00 0.00 0.00 0.00% Rental Income 0.00 50.00 300.00 16.67% Investment Inc/Loss 0.00 0.00 0.00 0.00% Interest Income - Reg 8.38 95.44 100.00 95.44% Utility Reimb. Preschool 833.33 8,333.30 10,000.00 83.33% Utility Reimb. Lunch 0.00 0.00 0.00 0.00% PS Admin. Reimb. 183.33 1,833.30 2,200.00 83.33% Miscellaneous -4,998.00 2,246.94 2,000.00 112.35% Gen. Income Total 29,076.51 279,985.34 314,750.00 88.95% Major: Gen. Income / Minor: School Fair Share & Tuition 16,743.17 128,225.61 152,000.00 84.36% Financial Aide 0.00 0.00 0.00 0.00% Collection Prior Yr Rec 0.00 740.00 2,000.00 37.00% School Total 16,743.17 128,965.61 154,000.00 83.74% Major: Gen. Income / Minor: Miscellaneous Transfer General Fund -5,000.00 0.00 500.00 0.00% Lynn Fund - Transfer 0.00 0.00 1,700.00 0.00% Miscellaneous Total -5,000.00 0.00 2,200.00 0.00% Total Income 40,819.68 408,950.95 470,950.00 86.84% Expense Major: General / Minor: Salary Exp - Accrued Taxable Life Ins Income 0.00 0.00 0.00 0.00% Taxable Life Ins Deduct 0.00 0.00 0.00 0.00% Salary Exp - Accrued Total 0.00 0.00 0.00 0.00% Major: Elder's Payroll Exp. / Minor: Pastor Pastor Salary 1,341.04 13,410.40 16,092.00 83.34% Pastor Housing 2,500.00 25,000.00 30,000.00 83.33% Misc Expense 0.00 0.00 0.00 0.00% Pastor Total 3,841.04 38,410.40 46,092.00 83.33% Major: Elder's Payroll Exp. / Minor: Asst Pastor Asst Pastor Salary 0.00 0.00 0.00 0.00% Asst Pastor Housing 0.00 2,417.96 14,500.00 16.68% Value of Parsonage 0.00 0.00 0.00 0.00% Asst Pastor Total 0.00 2,417.96 14,500.00 16.68% Major: Elder's Payroll Exp. / Minor: Car Expense Pastor Car Expense 366.66 3,649.94 4,400.00 82.95% Asst Pastor Car Exp 0.00 187.50 1,200.00 15.63% Car Expense Total 366.66 3,837.44 5,600.00 68.53% Major: Elder's Payroll Exp. / Minor: Secretary Secretary Wages 2,529.96 23,246.36 23,073.00 100.75% Sub. Secretary 0.00 0.00 0.00 0.00% Secretary Total 2,529.96 23,246.36 23,073.00 100.75% Major: Elder's Payroll Exp. / Minor: WBP Pastor WBP 1,813.97 17,463.32 21,436.00 81.47% Asst. Pastor WBP 0.00 695.68 4,383.00 15.87% Secretary WBP 775.81 7,413.79 8,572.00 86.49% WBP Total 2,589.78 25,572.79 34,391.00 74.36% Major: Elder's Payroll Exp. / Minor: Workman's Comp Elder's Workman's Comp 42.05 422.89 552.00 76.61% Workman's Comp Total 42.05 422.89 552.00 76.61% Major: Elder's Payroll Exp. / Minor: FICA Elder's FICA 193.54 1,785.61 1,765.00 101.17% FICA Total 193.54 1,785.61 1,765.00 101.17% Major: Bd. of Ed. Payroll Exp. / Minor: Principal Salary - Principal 2,148.98 21,489.80 25,788.00 83.33% Principal Housing 2,068.98 20,689.80 24,828.00 83.33% Principal Total 4,217.96 42,179.60 50,616.00 83.33% Major: Bd. of Ed. Payroll Exp. / Minor: 6th Grade 6th Grade Teacher 1,502.88 12,023.04 14,929.00 80.53% 6th Grade Teacher Housing 1,386.88 11,095.04 13,969.00 79.43% 6th Grade Total 2,889.76 23,118.08 28,898.00 80.00% Major: Bd. of Ed. Payroll Exp. / Minor: 4th Grade 4th Gr Teacher Salary 2,003.58 20,035.80 24,043.00 83.33% 4th Grade Total 2,003.58 20,035.80 24,043.00 83.33% Major: Bd. of Ed. Payroll Exp. / Minor: 2nd Grade 2nd Grade Salary 1,668.68 16,686.80 20,024.00 83.33% 2nd Grade Housing 1,454.40 14,544.00 17,452.00 83.34% 2nd Grade Total 3,123.08 31,230.80 37,476.00 83.34% Major: Bd. of Ed. Payroll Exp. / Minor: Kindergarden Kindergarten Salary 2,519.50 20,156.00 25,195.00 80.00% Kindergarten Housing 0.00 0.00 0.00 0.00% Kindergarden Total 2,519.50 20,156.00 25,195.00 80.00% Major: Bd. of Ed. Payroll Exp. / Minor: Kindergarden Aide School Aide 418.13 1,479.38 3,500.00 42.27% Kindergarden Aide Total 418.13 1,479.38 3,500.00 42.27% Major: Bd. of Ed. Payroll Exp. / Minor: Partime Teacher Partime Teachers Sal 503.90 4,031.20 5,039.00 80.00% Music Teacher 170.97 1,823.68 1,800.00 101.32% Partime Teacher Total 674.87 5,854.88 6,839.00 85.61% Major: Bd. of Ed. Payroll Exp. / Minor: Sub Teachers Substitute Teachers Wages 31.79 604.01 800.00 75.50% Sub Teachers Total 31.79 604.01 800.00 75.50% Major: Bd. of Ed. Payroll Exp. / Minor: WBP Principal WBP 1,849.60 17,801.56 21,847.00 81.48% 6th Grade Teacher WBP 1,322.57 12,738.14 15,641.00 81.44% 4th Grade WBP 189.34 1,732.36 2,048.00 84.59% 2nd Grade WBP 807.33 7,737.42 9,467.00 81.73% Kindergarden WBP 743.41 7,147.30 8,765.00 81.54% WBP Total 4,912.25 47,156.78 57,768.00 81.63% Major: Bd. of Ed. Payroll Exp. / Minor: Worker Comp Education Worker Comp 104.80 954.75 1,171.00 81.53% Worker Comp Total 104.80 954.75 1,171.00 81.53% Major: Bd. of Ed. Payroll Exp. / Minor: FICA Education FICA 432.08 3,688.19 4,619.00 79.85% FICA Total 432.08 3,688.19 4,619.00 79.85% Major: School Expense / Minor: School Expense Continuing Ed 0.00 0.00 350.00 0.00% Parish Ed 0.00 2,115.60 3,000.00 70.52% Workshops 0.00 29.02 800.00 3.63% School Funiture 0.00 0.00 0.00 0.00% Scholarships 0.00 1,000.00 1,000.00 100.00% Tuition Processing 0.00 0.00 0.00 0.00% Moving Expense 0.00 0.00 0.00 0.00% Advertising/School 0.00 0.00 0.00 0.00% Postage 2.47 26.80 0.00 0.00% School Expense Total 2.47 3,171.42 5,150.00 61.58% Major: Organist / Minor: Organist Organist Wages 600.00 4,120.00 4,500.00 91.56% Organist Total 600.00 4,120.00 4,500.00 91.56% Major: Organist / Minor: Worker Comp Organist Worker Comp 4.52 32.75 30.00 109.17% Worker Comp Total 4.52 32.75 30.00 109.17% Major: Organist / Minor: FICA Organist FICA 45.90 315.18 344.00 91.62% FICA Total 45.90 315.18 344.00 91.62% Major: Choir Director Exp / Minor: Choir Director Exp Choir Director Wages 83.34 833.40 1,000.00 83.34% Choir Director Exp Total 83.34 833.40 1,000.00 83.34% Major: Choir Director Exp / Minor: Worker Comp Choir Dir Worker Comp 0.00 0.00 7.00 0.00% Worker Comp Total 0.00 0.00 7.00 0.00% Major: Choir Director Exp / Minor: FICA Choir Dir FICA 6.38 63.80 77.00 82.86% FICA Total 6.38 63.80 77.00 82.86% Major: Elders / Minor: Elders Pastoral Services 933.34 3,266.69 0.00 0.00% Guest Pastor - Fee 0.00 325.00 200.00 162.50% Supplies/Elders 303.89 2,948.66 3,000.00 98.29% Paper/Elders 302.22 1,285.52 2,300.00 55.89% Postage 324.00 1,285.00 1,800.00 71.39% Workshops 80.00 255.20 800.00 31.90% Advertising 0.00 0.00 0.00 0.00% Moving Expense 0.00 0.00 0.00 0.00% Elders Total 1,943.45 9,366.07 8,100.00 115.63% Major: Custodians / Minor: Custodian's Worker Comp. Custodian FICA 75.28 755.95 809.00 93.44% Custodians Worker Comp 52.54 515.84 565.00 91.30% Custodian's Worker Comp. Total 127.82 1,271.79 1,374.00 92.56% Major: Custodians / Minor: Custodians Custodians 984.00 9,660.42 10,575.00 91.35% Snow Removal 0.00 120.00 200.00 60.00% Custodians Total 984.00 9,780.42 10,775.00 90.77% Major: Custodians / Minor: Worker Benefit Plan Custodian WBP 83.28 790.50 960.00 82.34% Worker Benefit Plan Total 83.28 790.50 960.00 82.34% Major: Trustees / Minor: Trustees Asbestos 0.00 520.00 600.00 86.67% Maintenance 895.30 4,266.06 5,000.00 85.32% Supplies/Trustees 788.87 5,796.48 7,000.00 82.81% Water & Electric 1,571.05 16,889.31 18,000.00 93.83% Natural Gas 998.97 8,609.82 15,000.00 57.40% Telephone 122.79 1,985.82 2,500.00 79.43% Garbage Removal 134.89 1,299.80 1,400.00 92.84% Office Machines 1,161.37 3,718.65 4,000.00 92.97% Trustees Total 5,673.24 43,085.94 53,500.00 80.53% Major: Worship / Minor: Worship Bullitins 0.00 0.00 0.00 0.00% Music 0.00 547.20 200.00 273.60% Periodicals 0.00 0.00 150.00 0.00% Alter Supplies 27.00 176.85 300.00 58.95% Worship Total 27.00 724.05 650.00 111.39% Major: Adult Activity(75 Anniv) / Minor: Adult Activity(75 Anniv) Adult Activity-75 Anniver 0.00 0.00 0.00 0.00% Adult Activity(75 Anniv) Total 0.00 0.00 0.00 0.00% Major: Youth / Minor: Youth Youth 31.42 209.17 300.00 69.72% Youth Total 31.42 209.17 300.00 69.72% Major: Stewardship / Minor: Stewardship Stewardship 0.00 751.04 750.00 100.14% Stewardship Total 0.00 751.04 750.00 100.14% Major: Evangelism / Minor: Evangelism Evangelism 0.00 0.00 300.00 0.00% Evangelism Total 0.00 0.00 300.00 0.00% Major: Missions / Minor: Missions Missions 1,750.00 17,500.00 21,000.00 83.33% Missions Total 1,750.00 17,500.00 21,000.00 83.33% Major: Mortgage / Minor: Mortgage Mortgage 0.00 0.00 0.00 0.00% Mortgage Total 0.00 0.00 0.00 0.00% Major: Lutheran High / Minor: Lutheran High Lutheran High 2,091.00 21,735.00 28,300.00 76.80% Lutheran High Total 2,091.00 21,735.00 28,300.00 76.80% Major: Misc / Minor: Insurance Insurance 0.00 4,638.11 7,000.00 66.26% Insurance Total 0.00 4,638.11 7,000.00 66.26% Major: Misc / Minor: Misc Payroll Processing 0.00 0.00 0.00 0.00% Misc/NSF/Refund 0.00 22.25 200.00 11.13% Misc Total 0.00 22.25 200.00 11.13% Total Expenses 44,344.65 410,562.61 511,215.00 80.31% Income Less Expense -3,524.97 -1,611.66 -40,265.00 (* = Inactive)