Date run 3/2/2023
Profit And Loss by Office
Run for Company Excellence Realty for all Offices for all Regions for all Divisions for Date range from 01/01/2022 to 12/31/2022 using Calculated Data
expand GL accts
Balance
Arlington
Cambridge
Danvers
Corporate
Everett
Franklin
Bucks County
Cary
Plainville
Zaelle
Springfield
Thompson
Telluride
Telluride Commercial
Unsula
Zaelle Commercial
Income
34,244,044.14
2,282,196.51
7,507,016.51
524,348.44
63,548.63
4,042,768.90
821,160.50
3,423,552.84
340,808.63
873,405.90
3,650,412.40
2,252,387.64
2,064,217.55
2,361,759.06
970,465.25
2,740,933.24
325,062.14
 
Gross Sales Commission
32,955,446.56
2,253,841.51
7,212,820.39
501,609.44
-
3,879,036.55
795,661.20
3,334,477.53
338,558.63
853,321.97
3,482,490.28
2,113,485.90
2,016,448.47
2,249,728.29
966,377.75
2,643,371.51
314,217.14
 
Desk Fee or Monthly Fee Income
158,715.09
-
64,852.09
11,892.00
-
534.00
534.00
2,136.00
-
979.00
1,602.00
890.00
9,000.00
62,988.00
1,350.00
1,958.00
-
 
Lead Gen Referral Income (Client Care)
15,686.24
-
5,276.16
-
4,252.50
646.13
1,598.05
-
-
-
-
-
-
1,307.72
-
2,605.68
-
 
E/O Income
129,960.00
7,560.00
32,400.00
3,960.00
($720.00)
23,400.00
2,170.00
9,720.00
2,160.00
3,600.00
14,400.00
9,360.00
8,640.00
11,900.00
1,050.00
-
360.00
 
Other Income
984,236.25
20,795.00
191,667.87
6,887.00
60,016.13
139,152.22
21,197.25
77,219.31
90.00
15,504.93
151,920.12
128,651.74
30,129.08
35,835.05
1,687.50
92,998.05
10,485.00
   
Total Income
34,244,044.14
2,282,196.51
7,507,016.51
524,348.44
63,548.63
4,042,768.90
821,160.50
3,423,552.84
340,808.63
873,405.90
3,650,412.40
2,252,387.64
2,064,217.55
2,361,759.06
970,465.25
2,740,933.24
325,062.14
Cost of Sales
28,837,936.23
1,996,264.90
6,693,497.00
408,175.73
130,338.47
3,460,204.81
708,258.80
2,847,797.37
230,336.22
730,895.98
2,943,397.86
1,867,696.37
1,682,160.04
2,025,845.06
742,103.61
2,089,935.05
281,028.96
 
Sales Commission Expense
25,786,705.94
1,844,480.14
6,077,905.80
370,818.71
-
3,083,026.46
639,020.37
2,567,964.73
208,257.17
663,784.72
2,576,070.60
1,612,316.62
1,528,214.13
1,849,714.57
682,742.12
1,830,698.86
251,690.94
 
Referral Fees
919,369.40
16,240.00
178,560.71
6,927.00
5,430.60
142,374.48
21,197.25
73,319.31
-
15,696.93
155,808.18
128,088.16
31,719.13
36,438.80
1,687.50
95,396.35
10,485.00
 
Royalty (Franchise Fees)
1,984,545.78
135,184.76
433,662.10
30,070.02
-
233,388.87
48,001.18
201,124.40
21,879.05
51,094.33
209,801.44
126,860.59
120,960.40
137,226.31
57,673.99
158,765.32
18,853.02
 
National Advertising Fund
92,657.86
-
-
-
92,657.86
-
-
-
-
-
-
-
-
-
-
-
-
 
Misc Fees
54,657.25
360.00
3,368.39
360.00
32,250.01
1,415.00
40.00
5,388.93
200.00
320.00
1,717.64
431.00
1,266.38
2,465.38
-
5,074.52
-
   
Total Cost of Sales
28,837,936.23
1,996,264.90
6,693,497.00
408,175.73
130,338.47
3,460,204.81
708,258.80
2,847,797.37
230,336.22
730,895.98
2,943,397.86
1,867,696.37
1,682,160.04
2,025,845.06
742,103.61
2,089,935.05
281,028.96
   
Gross Profit
5,406,107.91
285,931.61
813,519.51
116,172.71
($66,789.84)
582,564.09
112,901.70
575,755.47
110,472.41
142,509.92
707,014.54
384,691.27
382,057.51
335,914.00
228,361.64
650,998.19
44,033.18
Expense
5,413,984.24
361,363.58
884,428.37
43,209.73
($313,933.69)
734,822.92
113,133.18
328,500.48
28,732.07
229,513.67
747,258.16
455,767.72
358,728.46
500,287.36
52,658.35
887,374.37
-
 
Executive Team
272,615.31
-
500.00
-
272,115.31
-
-
-
-
-
-
-
-
-
-
-
-
 
Sales Leader/Managers Salaries
789,022.69
22,549.04
500.00
6,756.20
199,171.00
-
-
-
5,508.53
80,499.92
80,499.92
26,322.17
28,222.01
68,922.78
22,466.90
247,604.22
-
 
Office Administrators Payroll Expense
498,992.74
33,263.13
37,901.07
-
13,043.91
35,588.85
-
222.50
-
14,392.89
99,567.55
34,918.79
33,239.47
61,236.22
-
135,618.36
-
 
Corporate Staff Payroll Expense
456,855.33
-
-
-
388,530.43
67,324.90
-
-
-
500.00
-
500.00
-
-
-
-
-
 
Payroll Taxes
152,275.43
2,977.85
3,403.97
-
64,953.05
8,753.79
-
15.30
-
8,141.21
15,510.03
3,137.59
2,976.04
12,120.79
-
30,285.81
-
 
Employee Benefits/Insurance
111,559.51
654.84
665.62
-
48,282.69
2,170.32
-
0.36
-
7,447.87
8,840.59
6,464.50
654.81
8,680.33
-
27,697.58
-
 
Payroll Other
3,005.71
-
-
-
2,841.88
-
-
-
-
-
-
-
-
-
-
163.83
-
 
Advertising
84,341.25
6,765.62
7,624.41
1,399.21
26,005.02
2,942.93
761.23
5,713.44
1,151.58
500.76
1,581.28
1,683.91
3,602.56
14,094.34
-
10,514.96
-
 
Agent Co-op Programs
80,257.87
9,615.88
3,418.09
2,131.52
26,754.46
717.91
45.56
8,157.97
1,567.23
283.85
3,635.04
3,454.96
5,813.88
13,087.92
-
1,573.60
-
 
Sales Marketing
25,039.19
9.18
467.29
345.93
12,207.27
547.76
303.16
2,431.86
205.92
333.84
2,244.46
201.89
1,114.88
2,150.99
-
2,474.76
-
 
Sponsorships
46,988.27
233.71
7,247.10
-
1,543.13
1,461.83
2,271.51
6,043.30
2,963.00
1,987.60
4,320.45
2,783.35
3,480.80
7,194.14
-
5,458.35
-
 
Materials
48,326.93
630.47
3,792.17
-
26,840.21
3,292.21
-
1,159.09
-
774.26
2,262.47
1,282.98
1,428.38
1,885.68
-
4,979.01
-
 
Services
45,708.13
68.11
-
-
45,040.02
600.00
-
-
-
-
-
-
-
-
-
-
-
 
Marketing Other
70,796.20
-
182.94
-
55,760.26
-
-
-
-
-
1,000.00
-
-
-
-
13,853.00
-
 
Building Rental
801,545.17
73,469.00
110,544.30
22,278.00
11,533.54
83,625.04
18,000.00
64,227.50
10,200.00
16,029.26
127,796.85
85,432.90
51,870.80
66,537.98
-
60,000.00
-
 
Utilities
146,440.67
12,509.95
16,018.97
3,685.06
-
11,039.42
4,076.24
8,197.78
3,645.24
6,082.54
19,847.64
24,232.02
11,592.89
-
-
25,512.92
-
 
Building Insurance
9,384.82
-
-
-
8,617.82
-
-
-
-
-
767.00
-
-
-
-
-
-
 
Maintenance, Repairs & Services
61,326.13
7,231.75
6,827.00
1,331.02
419.58
9,642.93
266.88
4,869.59
261.50
806.05
8,711.06
6,613.88
8,364.28
1,642.32
-
4,338.29
-
 
Real Property Taxes
53,332.06
4,945.00
2,716.44
887.51
-
1,945.64
6,583.19
-
805.26
-
10,292.26
23,744.78
1,411.98
-
-
-
-
 
Janitorial/Grounds Services
105,445.11
13,602.38
9,809.52
-
-
4,693.36
4,920.18
16,169.92
-
3,659.90
14,174.03
17,086.53
11,098.75
977.32
-
9,253.22
-
 
Furniture & Equipment Rental
3,609.44
-
-
-
1,970.01
-
-
169.23
-
-
-
-
1,470.20
-
-
-
-
 
Copier, Fax & Servers
250.00
-
-
-
-
-
-
-
-
250.00
-
-
-
-
-
-
-
 
Computer Expenses
7,696.58
467.19
659.16
131.13
2,229.15
107.09
-
-
-
148.24
306.11
68.30
1,917.35
235.45
-
1,427.41
-
 
Building/Eqip Other
54,564.08
3,713.40
1,879.64
357.83
1,815.50
7,354.86
123.78
445.36
-
3,260.08
6,193.41
2,309.20
17,208.95
3,978.07
-
5,924.00
-
 
Promotion & Publicity
16,105.97
-
-
-
16,105.97
-
-
-
-
-
-
-
-
-
-
-
-
 
Travel & Related Expenses
33,811.87
-
389.14
-
32,117.55
-
-
-
-
-
-
-
-
-
-
312.46
-
 
Meals & Entertainment
14,050.07
304.64
286.44
-
10,044.50
66.62
-
201.86
-
396.41
256.70
1,127.17
653.66
336.16
-
375.91
-
 
Meeting & Conferences
26,656.16
-
300.00
-
16,017.75
3,680.75
162.20
162.20
-
743.06
2,239.02
1,857.96
140.64
1,107.37
-
245.21
-
 
Empower
40,988.85
-
45.45
-
40,567.61
-
-
($55.00)
-
-
-
-
-
36.10
-
394.69
-
 
Company Trip (Elite Retreat)
($3,049.63)
-
-
-
($1,048.47)
-
-
($2,500.54)
-
-
-
-
-
499.38
-
-
-
 
Awards & Recognition
140.41
-
-
-
140.41
-
-
-
-
-
-
-
-
-
-
-
-
 
Promotion Other
4,052.03
-
40.75
-
22,169.69
210.35
-
1,394.67
-
-
4,643.42
($480.00)
($24,070.85)
-
-
144.00
-
 
Printing & Reproduction
63,901.22
1,926.24
6,245.13
1,926.24
6,237.92
6,291.03
1,823.00
3,852.48
422.31
1,926.24
3,852.48
-
-
3,852.48
-
25,545.67
-
 
Dues, Subscriptions, Membership fees
42,548.66
824.25
206.00
-
35,187.56
206.00
400.00
966.00
-
570.19
560.00
206.00
1,010.00
944.00
-
1,468.66
-
 
Multiple Listing Service
14,793.09
($3,876.00)
1,671.25
600.00
9,043.65
575.00
-
1,590.19
-
266.00
540.00
1,100.00
($6,278.00)
3,552.00
($702.00)
6,711.00
-
 
Office Supplies
38,946.28
2,353.86
7,892.20
205.91
3,386.47
4,990.15
133.28
3,477.17
85.58
2,791.31
3,650.80
3,692.77
1,894.95
2,971.93
-
1,419.90
-
 
Tech Costs (Software, Licenses)
118,235.41
-
133.89
-
103,208.60
-
-
-
-
-
-
-
-
5,378.99
-
9,513.93
-
 
Postage
8,095.27
387.31
375.31
-
2,354.30
1,304.39
-
64.98
-
-
39.98
1,775.89
320.79
129.74
-
1,342.58
-
 
Connectivity
75,391.93
5,798.11
3,103.31
1,563.24
11,293.25
4,832.41
5,763.32
4,931.84
2,466.32
3,817.36
3,843.22
4,735.26
3,766.63
4,964.10
-
13,481.77
-
 
Auto Expenses
24,328.91
236.74
518.55
71.43
14,345.87
517.48
-
162.04
152.30
2,949.61
676.46
55.04
1,092.48
1,860.24
-
1,690.67
-
 
Sign Installation
25,302.94
684.43
-
-
2,581.38
($35.00)
-
490.58
-
-
-
-
-
12,288.10
9,293.45
-
-
 
Other Specify
15,864.66
1,058.40
408.60
340.50
9,280.60
331.96
-
549.82
-
-
474.60
425.94
1,359.90
134.34
-
1,500.00
-
 
Recruitment
25,962.87
927.85
2,987.07
-
12,909.23
311.40
-
704.77
-
-
718.70
899.00
15.42
1,402.77
-
5,086.66
-
 
Training
15,351.65
-
3,109.00
-
6,438.25
169.07
-
592.22
-
90.00
595.65
-
1,100.00
-
-
3,142.46
-
 
Employee Relations
13,994.20
643.95
5,664.28
-
943.37
2,288.09
133.65
($1,100.00)
-
-
1,571.33
1,370.53
1,354.78
792.59
-
331.63
-
 
Donations and Contributions
1,801.09
-
-
-
1,766.09
35.00
-
-
-
-
-
-
-
-
-
-
-
 
Insurance
11,284.85
-
-
-
11,284.85
-
-
-
-
-
-
-
-
-
-
-
-
 
Courier
1,291.26
51.30
18.31
-
204.44
96.38
-
-
15.30
22.22
61.65
30.01
76.03
42.74
-
672.88
-
 
Other Taxes, Licenses & Fees
567.00
-
-
-
98.00
-
168.00
-
-
-
-
-
-
11.00
-
290.00
-
 
Legal Fees
10,312.47
-
-
-
2,487.50
-
4,000.00
-
-
-
-
-
-
-
-
3,824.97
-
 
Other Professional Services
12,857.57
($1,424.00)
($4,984.00)
($801.00)
51,240.57
($1,602.00)
($1,602.00)
($6,408.00)
($1,068.00)
($1,157.00)
($8,196.00)
($3,204.00)
($3,576.00)
($4,361.00)
-
-
-
 
Bad Debt
3,033.40
360.00
1,060.00
-
-
745.00
-
-
350.00
-
180.00
338.40
-
-
-
-
-
 
Other
29,192.60
-
-
-
29,192.60
-
-
-
-
-
-
-
-
-
-
-
-
 
Coroporate Allocation Expense
798,792.56
158,400.00
640,800.00
-
($1,973,207.44)
468,000.00
64,800.00
201,600.00
-
72,000.00
324,000.00
201,600.00
194,400.00
201,600.00
21,600.00
223,200.00
-
"Print 8.5 x 11 landscape "
/AT2017_Reports/rptProfitAndLoss_byOffice
Page 1/2
Date run 3/2/2023
Profit And Loss by Office
   
Total Expense
5,413,984.24
361,363.58
884,428.37
43,209.73
($313,933.69)
734,822.92
113,133.18
328,500.48
28,732.07
229,513.67
747,258.16
455,767.72
358,728.46
500,287.36
52,658.35
887,374.37
-
   
Operating Profit
($7,876.33)
($75,431.97)
($70,908.86)
72,962.98
247,143.85
($152,258.83)
($231.48)
247,254.99
81,740.34
($87,003.75)
($40,243.62)
($71,076.45)
23,329.05
($164,373.36)
175,703.29
($236,376.18)
44,033.18
Other Income
1,054,140.44
68,528.23
223,213.13
15,811.65
-
144,444.04
24,619.21
105,271.81
11,012.39
26,389.70
117,464.10
65,222.74
63,767.02
71,265.01
29,974.85
77,085.02
10,071.54
 
Premiums
1,021,706.44
68,528.23
223,213.13
15,811.65
-
122,366.04
24,619.21
105,271.81
11,012.39
26,389.70
107,108.10
65,222.74
63,767.02
71,265.01
29,974.85
77,085.02
10,071.54
 
Mortgage
32,434.00
-
-
-
-
22,078.00
-
-
-
-
10,356.00
-
-
-
-
-
-
 
Home Warranty
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
   
Total Other Income
1,054,140.44
68,528.23
223,213.13
15,811.65
-
144,444.04
24,619.21
105,271.81
11,012.39
26,389.70
117,464.10
65,222.74
63,767.02
71,265.01
29,974.85
77,085.02
10,071.54
Other Expense
718.84
615.85
-
-
-
-
-
-
-
-
-
37.99
-
65.00
-
-
-
 
Other Expenses
718.84
615.85
-
-
-
-
-
-
-
-
-
37.99
-
65.00
-
-
-
   
Total Other Expense
718.84
615.85
-
-
-
-
-
-
-
-
-
37.99
-
65.00
-
-
-
                  
                     
   
Net Profit
1,045,545.27
($7,519.59)
152,304.27
88,774.63
247,143.85
($7,814.79)
24,387.73
352,526.80
92,752.73
($60,614.05)
77,220.48
($5,891.70)
87,096.07
($93,173.35)
205,678.14
($159,291.16)
54,104.72
                     
                     
"Print 8.5 x 11 landscape "
/AT2017_Reports/rptProfitAndLoss_byOffice
Page 2/2