Treasurer's Report6/26/2007 Page 1 Concordia Lutheran Church11:27a June of Fiscal Year 2007 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 18,756.24 302,660.01 303,000.00 99.89% Sunday School 5.48 128.60 200.00 64.30% 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 250.00 500.00 50.00% Investment Inc/Loss 0.00 0.00 0.00 0.00% Interest Income - Reg 9.86 115.02 75.00 153.36% Utility Reimb. Preschool 833.33 9,999.96 10,000.00 100.00% Utility Reimb. Lunch 4,000.00 4,000.00 0.00 0.00% PS Admin. Reimb. 183.33 2,199.96 2,200.00 100.00% Miscellaneous 8.25 941.76 2,000.00 47.09% Gen. Income Total 23,796.49 320,295.31 317,975.00 100.73% Major: Gen. Income / Minor: School Fair Share & Tuition 3,054.00 151,497.00 132,000.00 114.77% Financial Aide 0.00 0.00 0.00 0.00% Collection Prior Yr Rec 0.00 3,179.00 0.00 0.00% School Total 3,054.00 154,676.00 132,000.00 117.18% Major: Gen. Income / Minor: Miscellaneous Transfer General Fund 7,202.56 7,284.91 1,000.00 728.49% Lynn Fund - Transfer 0.00 1,670.85 600.00 278.48% Miscellaneous Total 7,202.56 8,955.76 1,600.00 559.74% Total Income 34,053.05 483,927.07 451,575.00 107.16% 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 14,858.47 14,092.00 105.44% Pastor Housing 2,500.00 31,166.62 32,000.00 97.40% Misc Expense 0.00 0.00 0.00 0.00% Pastor Total 3,841.04 46,025.09 46,092.00 99.85% Major: Elder's Payroll Exp. / Minor: Asst Pastor Asst Pastor Salary 0.00 0.00 0.00 0.00% Asst Pastor Housing 1,208.98 14,486.60 14,500.00 99.91% Value of Parsonage 0.00 0.00 0.00 0.00% Asst Pastor Total 1,208.98 14,486.60 14,500.00 99.91% Major: Elder's Payroll Exp. / Minor: Car Expense Pastor Car Expense 333.34 4,000.08 4,000.00 100.00% Asst Pastor Car Exp 75.00 900.00 900.00 100.00% Car Expense Total 408.34 4,900.08 4,900.00 100.00% Major: Elder's Payroll Exp. / Minor: Secretary Secretary Wages 2,036.88 23,088.14 23,073.00 100.07% Sub. Secretary 0.00 0.00 0.00 0.00% Secretary Total 2,036.88 23,088.14 23,073.00 100.07% Major: Elder's Payroll Exp. / Minor: WBP Pastor WBP 1,701.24 19,959.00 20,673.00 96.55% Asst. Pastor WBP 347.84 3,978.00 994.00 400.20% Secretary WBP 680.33 7,962.18 8,226.00 96.79% WBP Total 2,729.41 31,899.18 29,893.00 106.71% Major: Elder's Payroll Exp. / Minor: Workman's Comp Elder's Workman's Comp 46.77 551.70 552.00 99.95% Workman's Comp Total 46.77 551.70 552.00 99.95% Major: Elder's Payroll Exp. / Minor: FICA Elder's FICA 155.82 1,770.16 1,765.00 100.29% FICA Total 155.82 1,770.16 1,765.00 100.29% Major: Bd. of Ed. Payroll Exp. / Minor: Principal Salary - Principal 2,148.98 25,747.98 25,788.00 99.84% Principal Housing 2,068.98 24,797.85 24,828.00 99.88% Principal Total 4,217.96 50,545.83 50,616.00 99.86% Major: Bd. of Ed. Payroll Exp. / Minor: 6th Grade 6th Grade Teacher 1,502.88 15,028.80 14,449.00 104.01% 6th Grade Teacher Housing 1,386.88 13,868.80 14,449.00 95.98% 6th Grade Total 2,889.76 28,897.60 28,898.00 100.00% Major: Bd. of Ed. Payroll Exp. / Minor: 4th Grade 4th Gr Teacher Salary 2,003.58 23,385.09 22,543.00 103.74% 4th Grade Total 2,003.58 23,385.09 22,543.00 103.74% Major: Bd. of Ed. Payroll Exp. / Minor: 2nd Grade 2nd Grade Salary 1,668.68 20,027.24 20,023.00 100.02% 2nd Grade Housing 1,454.40 17,395.88 17,453.00 99.67% 2nd Grade Total 3,123.08 37,423.12 37,476.00 99.86% Major: Bd. of Ed. Payroll Exp. / Minor: Kindergarden Kindergarten Salary 2,519.50 25,195.00 25,195.00 100.00% Kindergarten Housing 0.00 0.00 0.00 0.00% Kindergarden Total 2,519.50 25,195.00 25,195.00 100.00% Major: Bd. of Ed. Payroll Exp. / Minor: Kindergarden Aide School Aide 220.48 3,715.47 0.00 0.00% Kindergarden Aide Total 220.48 3,715.47 0.00 0.00% Major: Bd. of Ed. Payroll Exp. / Minor: Partime Teacher Partime Teachers Sal 503.90 5,039.00 5,039.00 100.00% Music Teacher 56.99 1,937.66 1,800.00 107.65% Partime Teacher Total 560.89 6,976.66 6,839.00 102.01% Major: Bd. of Ed. Payroll Exp. / Minor: Sub Teachers Substitute Teachers Wages 222.53 762.96 800.00 95.37% Sub Teachers Total 222.53 762.96 800.00 95.37% Major: Bd. of Ed. Payroll Exp. / Minor: WBP Principal WBP 1,733.86 20,328.00 21,041.00 96.61% 6th Grade Teacher WBP 1,241.31 14,595.00 15,152.00 96.32% 4th Grade WBP 162.50 1,817.82 1,787.00 101.72% 2nd Grade WBP 751.35 8,737.92 8,967.00 97.45% Kindergarden WBP 695.61 8,133.30 8,394.00 96.89% WBP Total 4,584.63 53,612.04 55,341.00 96.88% Major: Bd. of Ed. Payroll Exp. / Minor: Worker Comp Education Worker Comp 104.00 1,167.51 1,138.00 102.59% Worker Comp Total 104.00 1,167.51 1,138.00 102.59% Major: Bd. of Ed. Payroll Exp. / Minor: FICA Education FICA 422.83 4,604.29 4,236.00 108.69% FICA Total 422.83 4,604.29 4,236.00 108.69% Major: School Expense / Minor: School Expense Continuing Ed 0.00 0.00 350.00 0.00% Parish Ed 144.95 2,021.23 3,000.00 67.37% * School Supplies 0.00 0.00 0.00 0.00% Workshops 275.00 877.87 800.00 109.73% 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 43.83 43.83 0.00 0.00% School Expense Total 463.78 3,942.93 5,150.00 76.56% Major: Organist / Minor: Organist Organist Wages 360.00 4,800.00 4,500.00 106.67% Organist Total 360.00 4,800.00 4,500.00 106.67% Major: Organist / Minor: Worker Comp Organist Worker Comp 2.93 38.09 30.00 126.97% Worker Comp Total 2.93 38.09 30.00 126.97% Major: Organist / Minor: FICA Organist FICA 27.54 373.58 344.00 108.60% FICA Total 27.54 373.58 344.00 108.60% Major: Choir Director Exp / Minor: Choir Director Exp Choir Director Wages 83.34 958.41 1,000.00 95.84% Choir Director Exp Total 83.34 958.41 1,000.00 95.84% 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 66.99 77.00 87.00% FICA Total 6.38 66.99 77.00 87.00% Major: Elders / Minor: Elders Guest Pastor - Fee 110.00 110.00 130.00 84.62% Supplies/Elders 65.90 2,361.21 2,500.00 94.45% Paper/Elders 595.51 2,690.65 2,100.00 128.13% Postage 0.00 1,678.59 1,800.00 93.26% Workshops 0.00 248.57 800.00 31.07% Advertising 0.00 0.00 0.00 0.00% Moving Expense 0.00 0.00 0.00 0.00% Elders Total 771.41 7,089.02 7,330.00 96.71% Major: Custodians / Minor: Custodian's Worker Comp. Custodian FICA 73.77 842.16 809.00 104.10% Custodians Worker Comp 51.49 583.54 565.00 103.28% Custodian's Worker Comp. Total 125.26 1,425.70 1,374.00 103.76% Major: Custodians / Minor: Custodians Custodians 964.32 10,926.78 10,575.00 103.33% Snow Removal 0.00 0.00 200.00 0.00% Custodians Total 964.32 10,926.78 10,775.00 101.41% Major: Custodians / Minor: Worker Benefit Plan Custodian WBP 76.23 844.92 822.00 102.79% Worker Benefit Plan Total 76.23 844.92 822.00 102.79% Major: Trustees / Minor: Trustees Asbestos 0.00 800.00 600.00 133.33% Maintenance 0.00 3,860.20 4,000.00 96.51% Supplies/Trustees 574.88 7,404.52 6,000.00 123.41% Water & Electric 1,740.54 17,184.57 17,000.00 101.09% Natural Gas 201.30 9,239.67 15,000.00 61.60% Telephone 157.27 2,471.58 2,200.00 112.34% Garbage Removal 113.97 1,280.42 1,300.00 98.49% Office Machines 156.61 3,603.29 4,000.00 90.08% Trustees Total 2,944.57 45,844.25 50,100.00 91.51% Major: Worship / Minor: Worship Bullitins 0.00 0.00 0.00 0.00% Music 0.00 156.38 250.00 62.55% Periodicals 0.00 94.92 250.00 37.97% Alter Supplies 49.09 268.18 600.00 44.70% Worship Total 49.09 519.48 1,100.00 47.23% Major: Adult Activity(75 Anniv) / Minor: Adult Activity(75 Anniv) Adult Activity-75 Anniver 0.00 1,500.00 1,500.00 100.00% Adult Activity(75 Anniv) Total 0.00 1,500.00 1,500.00 100.00% Major: Youth / Minor: Youth Youth 42.06 92.06 300.00 30.69% Youth Total 42.06 92.06 300.00 30.69% Major: Stewardship / Minor: Stewardship Stewardship 0.00 734.94 1,000.00 73.49% Stewardship Total 0.00 734.94 1,000.00 73.49% Major: Evangelism / Minor: Evangelism Evangelism 0.00 198.34 500.00 39.67% Evangelism Total 0.00 198.34 500.00 39.67% Major: Missions / Minor: Missions Missions 1,708.33 20,499.96 20,500.00 100.00% Missions Total 1,708.33 20,499.96 20,500.00 100.00% 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,366.00 22,512.00 27,540.00 81.74% Lutheran High Total 2,366.00 22,512.00 27,540.00 81.74% Major: Misc / Minor: Insurance Insurance 1,584.50 6,702.00 6,800.00 98.56% Insurance Total 1,584.50 6,702.00 6,800.00 98.56% Major: Misc / Minor: Misc Payroll Processing 0.00 0.00 0.00 0.00% Misc/NSF/Refund 0.00 266.18 350.00 76.05% Misc Total 0.00 266.18 350.00 76.05% Total Expenses 42,872.22 488,342.15 494,956.00 98.66% Income Less Expense -8,819.17 -4,415.08 -43,381.00 (* = Inactive)