Treasurer's Report6/27/2006 Page 1 Concordia Lutheran Church05:45p June of Fiscal Year 2006 Responsibility: All Fund: 01 - General Fund June Year-to-date Annual Percent of Actual Actual Budget Budget Income Major: Gen. Income / Minor: Gen. Income Collections 22,016.33 300,274.02 310,000.00 96.86% Sunday School 4.98 144.07 300.00 48.02% Bible Class 0.00 0.00 0.00 0.00% Adopt-A-Bill 0.00 705.28 0.00 0.00% Rental Income 0.00 650.00 200.00 325.00% Investment Inc/Loss 0.00 0.00 0.00 0.00% Interest Income - Reg 10.89 94.84 100.00 94.84% Utility Reimb. Preschool 833.33 9,999.96 10,000.00 100.00% Utility Reimb. Lunch 0.00 0.00 0.00 0.00% PS Admin. Reimb. 183.33 2,199.96 2,200.00 100.00% Miscellaneous 13.37 8,105.37 250.00 3,242.15% Gen. Income Total 23,062.23 322,173.50 323,050.00 99.73% Major: Gen. Income / Minor: School * Tuition 0.00 0.00 0.00 0.00% Fair Share & Tuition 399.00 124,802.50 116,000.00 107.59% Financial Aide 0.00 0.00 0.00 0.00% Collection Prior Yr Rec 0.00 1,575.00 0.00 0.00% School Total 399.00 126,377.50 116,000.00 108.95% Major: Gen. Income / Minor: Miscellaneous Transfer General Fund 571.85 571.85 2,000.00 28.59% Lynn Fund - Transfer 0.00 250.00 600.00 41.67% Miscellaneous Total 571.85 821.85 2,600.00 31.61% Total Income 24,033.08 449,372.85 441,650.00 101.75% 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,039.60 10,618.30 26,708.00 39.76% Pastor Housing 2,666.66 24,632.35 26,708.00 92.23% Misc Expense 0.00 0.00 0.00 0.00% Pastor Total 3,706.26 35,250.65 53,416.00 65.99% Major: Elder's Payroll Exp. / Minor: Asst Pastor Asst Pastor Salary 0.00 0.00 0.00 0.00% Asst Pastor Housing 1,166.66 20,599.92 14,000.00 147.14% Value of Parsonage 0.00 0.00 0.00 0.00% Asst Pastor Total 1,166.66 20,599.92 14,000.00 147.14% Major: Elder's Payroll Exp. / Minor: Car Expense Pastor Car Expense 333.34 4,192.51 4,000.00 104.81% Asst Pastor Car Exp 75.00 900.00 900.00 100.00% Car Expense Total 408.34 5,092.51 4,900.00 103.93% Major: Elder's Payroll Exp. / Minor: Secretary Secretary Wages 1,965.12 22,323.87 22,266.00 100.26% Sub. Secretary 0.00 0.00 0.00 0.00% Secretary Total 1,965.12 22,323.87 22,266.00 100.26% Major: Elder's Payroll Exp. / Minor: WBP Pastor WBP 1,625.26 12,766.78 9,698.00 131.64% Asst. Pastor WBP 315.16 3,940.92 4,264.00 92.42% Secretary WBP 646.70 7,473.42 7,474.00 99.99% WBP Total 2,587.12 24,181.12 21,436.00 112.81% Major: Elder's Payroll Exp. / Minor: Workman's Comp Elder's Workman's Comp 45.13 515.91 592.00 87.15% Workman's Comp Total 45.13 515.91 592.00 87.15% Major: Elder's Payroll Exp. / Minor: FICA Elder's FICA 150.33 1,711.74 1,703.00 100.51% FICA Total 150.33 1,711.74 1,703.00 100.51% Major: Bd. of Ed. Payroll Exp. / Minor: Principal Salary - Principal 2,079.42 25,018.04 25,074.00 99.78% Principal Housing 1,999.16 23,924.92 23,870.00 100.23% Principal Total 4,078.58 48,942.96 48,944.00 100.00% Major: Bd. of Ed. Payroll Exp. / Minor: 6th Grade 6th Grade Teacher 1,394.40 13,944.00 13,944.00 100.00% 6th Grade Teacher Housing 1,394.40 13,944.00 13,944.00 100.00% 6th Grade Total 2,788.80 27,888.00 27,888.00 100.00% Major: Bd. of Ed. Payroll Exp. / Minor: 4th Grade 4th Gr Teacher Salary 1,812.84 21,754.08 23,414.00 92.91% 4th Grade Total 1,812.84 21,754.08 23,414.00 92.91% Major: Bd. of Ed. Payroll Exp. / Minor: 2nd Grade 2nd Grade Salary 1,614.84 19,168.08 19,024.00 100.76% 2nd Grade Housing 1,400.56 17,016.72 17,162.00 99.15% 2nd Grade Total 3,015.40 36,184.80 36,186.00 100.00% Major: Bd. of Ed. Payroll Exp. / Minor: Kindergarden Kindergarten Salary 2,431.32 24,313.20 28,634.00 84.91% Kindergarten Housing 0.00 0.00 0.00 0.00% Kindergarden Total 2,431.32 24,313.20 28,634.00 84.91% Major: Bd. of Ed. Payroll Exp. / Minor: Kindergarden Aide School Aide 0.00 0.00 0.00 0.00% Kindergarden Aide Total 0.00 0.00 0.00 0.00% Major: Bd. of Ed. Payroll Exp. / Minor: Partime Teacher Partime Teachers Sal 486.26 4,862.60 4,500.00 108.06% Music Teacher 0.00 1,760.00 1,736.00 101.38% Partime Teacher Total 486.26 6,622.60 6,236.00 106.20% Major: Bd. of Ed. Payroll Exp. / Minor: Sub Teachers Substitute Teachers Wages 92.03 966.30 800.00 120.79% Sub Teachers Total 92.03 966.30 800.00 120.79% Major: Bd. of Ed. Payroll Exp. / Minor: WBP Principal WBP 1,654.14 19,125.84 19,138.00 99.94% 6th Grade Teacher WBP 1,191.19 13,786.68 17,617.00 78.26% 4th Grade WBP 140.47 1,598.64 1,572.00 101.69% 2nd Grade WBP 704.97 7,881.84 7,596.00 103.76% Kindergarden WBP 659.94 6,534.64 1,493.00 437.69% WBP Total 4,350.71 48,927.64 47,416.00 103.19% Major: Bd. of Ed. Payroll Exp. / Minor: Worker Comp Education Worker Comp 97.05 1,100.02 1,083.00 101.57% Worker Comp Total 97.05 1,100.02 1,083.00 101.57% Major: Bd. of Ed. Payroll Exp. / Minor: FICA Education FICA 368.92 4,122.32 3,908.00 105.48% FICA Total 368.92 4,122.32 3,908.00 105.48% Major: School Expense / Minor: School Expense Continuing Ed 0.00 0.00 350.00 0.00% Parish Ed 0.00 1,980.76 3,000.00 66.03% * School Supplies 0.00 0.00 0.00 0.00% Workshops 0.00 0.00 800.00 0.00% 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 0.00 0.00 0.00 0.00% School Expense Total 0.00 2,980.76 5,150.00 57.88% Major: Organist / Minor: Organist Organist Wages 320.00 4,615.00 4,500.00 102.56% Organist Total 320.00 4,615.00 4,500.00 102.56% Major: Organist / Minor: Worker Comp Organist Worker Comp 2.11 30.45 30.00 101.50% Worker Comp Total 2.11 30.45 30.00 101.50% Major: Organist / Minor: FICA Organist FICA 24.48 353.05 344.00 102.63% FICA Total 24.48 353.05 344.00 102.63% Major: Choir Director Exp / Minor: Choir Director Exp Choir Director Wages 0.00 0.00 0.00 0.00% Choir Director Exp Total 0.00 0.00 0.00 0.00% Major: Choir Director Exp / Minor: Worker Comp Choir Dir Worker Comp 0.00 0.00 0.00 0.00% Worker Comp Total 0.00 0.00 0.00 0.00% Major: Choir Director Exp / Minor: FICA Choir Dir FICA 0.00 0.00 0.00 0.00% FICA Total 0.00 0.00 0.00 0.00% Major: Elders / Minor: Elders Guest Pastor - Fee 0.00 0.00 130.00 0.00% Supplies/Elders 40.00 1,651.75 2,500.00 66.07% Paper/Elders 132.34 2,708.50 1,600.00 169.28% Postage 126.00 1,796.74 1,700.00 105.69% Workshops 0.00 75.00 800.00 9.38% Advertising 0.00 0.00 0.00 0.00% Moving Expense 0.00 1,104.75 0.00 0.00% Elders Total 298.34 7,336.74 6,730.00 109.02% Major: Custodians / Minor: Custodian's Worker Comp. Custodian FICA 65.40 820.28 780.00 105.16% Custodians Worker Comp 45.66 568.13 545.00 104.24% Custodian's Worker Comp. Total 111.06 1,388.41 1,325.00 104.79% Major: Custodians / Minor: Custodians Custodians 855.00 10,640.00 10,200.00 104.31% Snow Removal 0.00 0.00 200.00 0.00% Custodians Total 855.00 10,640.00 10,400.00 102.31% Major: Custodians / Minor: Worker Benefit Plan Custodian WBP 64.59 670.08 588.00 113.96% Worker Benefit Plan Total 64.59 670.08 588.00 113.96% Major: Trustees / Minor: Trustees Asbestos 0.00 1,041.73 600.00 173.62% Maintenance 595.55 3,463.81 4,000.00 86.60% Supplies/Trustees 97.82 4,414.74 5,500.00 80.27% Water & Electric 1,490.22 14,827.74 16,000.00 92.67% Natural Gas 320.07 10,718.59 9,000.00 119.10% Telephone 144.77 3,520.03 4,500.00 78.22% Garbage Removal 102.97 1,146.40 1,100.00 104.22% Office Machines 233.50 4,768.07 5,000.00 95.36% Trustees Total 2,984.90 43,901.11 45,700.00 96.06% Major: Worship / Minor: Worship Bullitins 0.00 -77.45 400.00 -19.36% Music 0.00 34.59 200.00 17.30% Periodicals 0.00 269.53 275.00 98.01% Alter Supplies 0.00 616.20 600.00 102.70% Worship Total 0.00 842.87 1,475.00 57.14% Major: Youth / Minor: Youth Youth 0.00 0.00 300.00 0.00% Youth Total 0.00 0.00 300.00 0.00% Major: Stewardship / Minor: Stewardship Stewardship 0.00 1,028.22 750.00 137.10% Stewardship Total 0.00 1,028.22 750.00 137.10% Major: Evangelism / Minor: Evangelism Evangelism 0.00 0.00 1,000.00 0.00% Evangelism Total 0.00 0.00 1,000.00 0.00% Major: Missions / Minor: Missions Missions 1,591.00 19,092.00 19,086.00 100.03% Missions Total 1,591.00 19,092.00 19,086.00 100.03% 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,295.00 24,210.00 22,000.00 110.05% Lutheran High Total 2,295.00 24,210.00 22,000.00 110.05% Major: Misc / Minor: Insurance Insurance 1,445.00 6,174.01 7,000.00 88.20% Insurance Total 1,445.00 6,174.01 7,000.00 88.20% Major: Misc / Minor: Misc Payroll Processing 0.00 0.00 0.00 0.00% Misc/NSF/Refund 0.00 5.00 300.00 1.67% Misc Total 0.00 5.00 300.00 1.67% Total Expenses 39,542.35 453,765.34 469,500.00 96.65% Income Less Expense -15,509.27 -4,392.49 -27,850.00 (* = Inactive)