TO: Interested School Ministry FROM: Jim Bramer
FILE: 0744-07 qbsamRE: QB School Sample Actual to Budget (A to B) report UPTD: April 27, 2008
Below is the QB School Sample Actual to Budget (A to B) report for the year to date beginning July 1, XXX0 through October 31, XXX0. This report reflects the entire General Purpose Fund ... of course, you can filter and produce A to B reports for different departments. Link to 0749-07 for other QB School Samples.
Jul - Oct 'XXX0
Budget
$ Over Budget
Income
3100 · Tuition Billed
165,903
166,618
(715)
3102 · Scholarship Offset
(2,196)
(2,196)
0
3109 · Less Billing Uncollected
0
(1,500)
1,500
3110 · Regis-After 7/1 Reg School
8,545
8,545
0
3120 · Regis-B4 6/30 Reg School
14,050
14,050
0
3130 · 8th Grade Grad Fee
441
441
0
3140 · Music Fees
53
47
6
3300 · Day Care
14,653
14,526
127
3400 · Hot Lunch
5,703
5,689
14
3500 · Summer Math Class
120
120
0
3600 · Regular School Misc.
657
615
42
3650 · Scrip
1,297
1,285
12
3700 · Interest
70
22
48
3750 · Late Charges Billed
990
1,005
(15)
3760 · Donations
168
178
(10)
3800 · Preschool Tuition
32,196
32,103
93
3810 · Preschool Registration
1,375
1,375
0
3820 · Preschool Other Income
304
407
(103)
3900 · After-7/1-Day Camp Fees
33,151
33,151
0
3910 · Before 6/30 Day Camp Fees
12,466
12,466
0
3920 · Day Camp Other Income
640
640
0
Total Income
290,586
289,587
999
Expense
4009 · Summer Sal to 6/xx
(35,669)
(35,669)
0
4019 · Summer xxx0 Accrual
2,833
5,666
(2,833)
4020 · Salaries
120,719
119,785
934
4021 · Substitute Salaries
1,482
1,104
378
4030 · FICA
13,450
13,416
34
4040 · Medical lnsurance
14,052
13,982
70
4050 · Workmans Comp Insurance
1,447
1,464
(17)
4060 · Life Insurance
268
275
(7)
4061 · Payroll Service
1,340
1,311
29
4071 · Honorariums
158
103
55
4110 · Parking Lot Rent
240
240
0
4150 · Maintenance Supplies
5,456
7,005
(1,549)
4170 · Property Insurance
3,278
3,278
0
4190 · Utilities
13,267
12,733
534
4210 · Regular School Books
13,884
14,049
(165)
4220 · Teachers Supplies/Exp
1,568
1,568
0
4221 · Regular School Equipment
556
555
1
4230 · School Nutrition
733
717
16
4235 · Student Activities
80
80
0
4240 · Student Insurance
2,124
2,124
0
4251 · ARC Expense
288
240
48
4260 · Sports
669
919
(250)
4262 · Electives
698
810
(112)
4270 · Sick Room Supplies
72
72
0
4271 · Year Book Fees
2,625
75
2,550
4290 · Misc Expense
585
587
(2)
4310 · Gasoline
115
119
(4)
4340 · Buses Chartered
118
118
0
4420 · Advertising
8,606
8,606
0
4430 · Office Supplies
486
476
10
4441 · Bank Charges
188
194
(6)
4442 · Check Charges-Parents
(105)
(120)
15
4443 · Credit Card Charges
349
345
4
4450 · Computer class
1,296
1,346
(50)
4451 · Duplicating Expense
738
750
(12)
4452 · Postage
967
1,031
(64)
4453 · Canon Copier Expense
1,076
1,086
(10)
4454 · Computer/Copy Paper
230
233
(3)
4455 · Special Expenses
330
330
0
4460 · Professional Services
197
198
(1)
4462 · Developmental Expenses
300
300
0
4470 · Misc. Administration
33
43
(10)
4480 · Conference Expense
649
650
(1)
4481 · Organizational Fees
1,387
1,387
0
4490 · Daycare Salaries
7,203
7,317
(114)
4491 · Daycare Supplies
44
44
0
4512 · Preschool Salaries
20,178
20,192
(14)
4520 · Preschool Supplies
125
124
1
4523 · Preschool Advertising
837
836
1
4529 · Preschool Mortgage
6,705
6,704
1
4540 · Preschool Utilities
870
780
90
4550 · Preschool Nutrition
613
625
(12)
4555 · Preschool Lunch
(32)
14
(46)
4560 · Preschool Maintenance
450
450
0
4570 · Preschool Misc.
685
400
285
4610 · Hot Lunch Food
3,740
3,687
53
4614 · Hot Lunch Supplies
115
115
0
4701 · Camp Pd Prior 6/xxxx
0
4710 · Camp Supplies
109
110
(1)
4711 · Camp Nutrition
304
304
0
4712 · Camp Salaries
16,256
16,256
0
4713 · Camp Parking
15
15
0
4720 · Camp Field Trips
8,156
8,348
(192)
4731 · Camp Shirts
956
956
0
4732 · Camp Buses Chartered
3,984
3,985
(1)
5212 · Phone Rent
449
448
1
5213 · Debt Service #1
8,410
8,410
0
5215 · Debt Service #2
2,080
2,080
0
Total Expense
265,415
265,781
(366)
Difference 25,171
23,806
1,365
Please Click Here for a List of Reports as provided per QuickBooks on our www.bcidot.org. The bulk of this Publication originated in April 2000 and was UPTD: April 27, 2008
HOME | ABOUT US | OUR PURPOSE | SITEMAP | COMPUTER FUND ACCTG | HELPS
