Date run 3/5/2023
Profit And Loss by Month
Run for all Companies 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
 
January
February
March
April
May
June
July
August
September
October
November
December
Income
8,235,000.23
 
468,595.35
571,545.58
968,212.27
719,077.95
882,588.87
893,364.57
824,521.04
867,515.84
623,275.09
435,787.86
471,437.13
509,078.68
 
Operational Income
471,736.81
 
29,550.36
31,364.21
51,554.59
41,771.30
54,376.82
52,572.77
44,402.73
48,586.09
35,308.71
27,612.09
28,012.68
26,624.46
  
4-1070
Ad Fund withholding
742.16
 
239.50
-
161.24
-
-
-
-
-
-
117.88
223.54
-
  
4-1071
Franchise Fee withholding
440,123.60
 
25,632.97
31,021.77
49,925.85
39,034.63
48,651.10
49,172.41
42,748.96
46,861.09
32,965.77
23,948.92
25,329.21
24,830.92
  
4-1072
RELO Dept/B2B INCENTIVE
4,723.22
 
-
-
-
-
4,723.22
-
-
-
-
-
-
-
  
4-1074
Lead Fee
7,987.70
 
1,090.39
-
-
-
-
2,023.45
1,653.77
-
-
3,220.09
-
-
  
4-1075
RELO DEPT Reimbursements
164.20
 
-
-
-
-
-
-
-
-
63.28
-
-
100.92
  
4-1076
Recruiting Incentives Forfeited
1,552.23
 
-
342.44
-
-
-
-
-
-
644.66
325.20
239.93
-
  
4-1100
Property Management Income
15,119.17
 
2,587.50
-
1,467.50
2,736.67
1,002.50
1,360.00
-
1,725.00
1,035.00
-
2,220.00
985.00
  
4-1200
Real Estate School Income
1,324.53
 
-
-
-
-
-
16.91
-
-
600.00
-
-
707.62
 
Listing Side Commission 100%
2,836,411.00
 
151,819.63
202,590.91
285,960.69
248,688.86
424,263.23
321,679.17
266,256.72
316,310.90
185,702.35
171,667.14
148,637.69
112,833.71
  
4-2001
List Side Commission Income
2,836,411.00
 
151,819.63
202,590.91
285,960.69
248,688.86
424,263.23
321,679.17
266,256.72
316,310.90
185,702.35
171,667.14
148,637.69
112,833.71
 
Selling Side Commission 100%
3,873,203.07
 
238,279.85
273,847.34
484,280.72
328,153.69
335,290.97
434,345.08
395,846.42
349,998.55
324,889.91
194,063.50
246,679.83
267,527.21
  
4-3001
Sell Side Commission Income
3,873,203.07
 
238,279.85
273,847.34
484,280.72
328,153.69
335,290.97
434,345.08
395,846.42
349,998.55
324,889.91
194,063.50
246,679.83
267,527.21
 
Commercial Income
103,381.21
 
6,114.71
-
10,692.50
16,920.00
-
-
-
61,100.00
-
94.00
940.00
7,520.00
  
4-4001
Commercial Commission Income
103,381.21
 
6,114.71
-
10,692.50
16,920.00
-
-
-
61,100.00
-
94.00
940.00
7,520.00
 
Service Income
950,268.14
 
42,830.80
63,743.12
135,723.77
83,544.10
68,657.85
84,767.55
118,015.17
91,520.30
77,374.12
42,351.13
47,166.93
94,573.30
  
4-6001
Rental Commission Income
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
4-6050
Transaction Coordinator Fee Income
1,350.00
 
-
-
-
-
-
300.00
150.00
-
-
-
300.00
600.00
  
4-7001
Referral Commission Income
844,341.22
 
41,830.80
62,743.12
71,018.12
83,541.60
66,657.85
83,368.13
116,673.75
90,520.30
76,374.12
41,251.13
45,866.93
64,495.37
  
4-7002
Alternate Other Income
29,497.27
 
-
-
626.00
2.50
-
99.42
191.42
-
-
100.00
-
28,477.93
  
4-7004
Zillow/Mtge Opt Reimbursements
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
4-7005
CIB - Franchise Reim
63,079.65
 
-
-
63,079.65
-
-
-
-
-
-
-
-
-
  
4-7006
Other NON TAXABLE INCOME - PPP LOAN FORGIVENESS
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
4-7007
Mortgage Options-Website Sponsorship
12,000.00
 
1,000.00
1,000.00
1,000.00
-
2,000.00
1,000.00
1,000.00
1,000.00
1,000.00
1,000.00
1,000.00
1,000.00
 
Total Income
8,235,000.23
 
468,595.35
571,545.58
968,212.27
719,077.95
882,588.87
893,364.57
824,521.04
867,515.84
623,275.09
435,787.86
471,437.13
509,078.68
Cost of Sales
6,823,550.56
 
398,103.14
476,866.59
769,084.34
614,497.33
727,572.61
745,353.56
691,000.23
722,498.28
523,557.73
357,814.12
389,052.51
408,150.12
 
Cost of Sales
6,823,550.56
 
398,103.14
476,866.59
769,084.34
614,497.33
727,572.61
745,353.56
691,000.23
722,498.28
523,557.73
357,814.12
389,052.51
408,150.12
  
5-1003
NAF (2%) Paid
64,883.18
 
5,502.00
5,372.34
5,502.00
5,502.00
5,502.00
5,502.00
5,502.00
5,502.00
5,502.00
5,376.26
5,128.75
4,989.83
  
5-1004
Company $ transferred to Office
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
5-1005
Franchise transferred to Office
440,228.88
 
25,632.96
31,021.78
49,925.86
39,034.63
48,651.10
49,172.41
42,748.96
46,861.10
32,965.76
23,948.89
25,329.21
24,936.22
  
5-1006
Lead Fees transferred to Office
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
5-1100
Property Management
7,559.59
 
1,293.75
-
733.75
1,368.34
501.25
680.00
-
862.50
517.50
-
1,110.00
492.50
  
5-2001
List Side Commission Paid
2,318,336.35
 
126,959.81
161,625.37
241,364.64
206,062.49
345,208.58
260,537.42
215,058.98
262,480.13
152,425.56
136,240.62
118,185.19
92,187.56
  
5-3001
Sell Side Commission Paid
3,065,455.24
 
192,486.52
216,498.78
391,985.97
264,599.22
261,141.62
346,365.16
311,446.19
274,471.87
256,937.01
151,205.05
192,474.43
205,843.42
  
5-4001
Commercial Commission Paid
78,962.83
 
4,890.83
-
8,554.00
15,228.00
-
-
-
42,770.00
-
94.00
658.00
6,768.00
  
5-6001
Rental Commission Paid
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
5-6050
Transaction Coordinator Fee Paid
1,350.00
 
-
-
-
-
-
300.00
150.00
-
-
-
300.00
600.00
  
5-7001
Referral Commission Paid
838,887.49
 
41,337.27
62,348.32
71,018.12
82,702.65
66,568.06
82,796.57
116,094.10
89,550.68
75,209.90
40,949.30
45,866.93
64,445.59
  
5-7002
Alternate Other Income Paid
7,887.00
 
-
-
-
-
-
-
-
-
-
-
-
7,887.00
 
Total Cost of Sales
6,823,550.56
 
398,103.14
476,866.59
769,084.34
614,497.33
727,572.61
745,353.56
691,000.23
722,498.28
523,557.73
357,814.12
389,052.51
408,150.12
 
Gross Profit
1,411,449.67
 
70,492.21
94,678.99
199,127.93
104,580.62
155,016.26
148,011.01
133,520.81
145,017.56
99,717.36
77,973.74
82,384.62
100,928.56
Expense
1,302,324.61
 
88,006.05
96,180.63
114,263.92
96,582.47
87,772.44
105,313.59
90,831.42
104,652.30
99,271.99
107,041.04
91,826.59
220,582.17
 
Expenses
56,815.84
 
3,151.70
4,125.04
5,247.76
4,099.34
5,212.65
6,743.29
6,041.12
7,822.63
3,892.26
3,141.37
3,977.50
3,361.18
  
6-1000
Agent expenses
155.15
 
-
48.15
-
-
-
-
-
107.00
-
-
-
-
  
6-1001
Agent Personal exp
55.00
 
-
-
-
-
-
-
-
55.00
-
-
-
-
  
6-1003
Recruiting Override
13,189.94
 
718.80
1,360.16
1,387.68
645.65
975.88
1,745.23
1,421.96
2,022.58
859.10
334.80
940.57
777.53
  
6-1004
Manager Override
37,260.37
 
1,935.60
2,219.43
3,260.33
2,884.06
3,739.47
4,450.17
4,159.43
5,178.32
2,472.96
2,346.84
2,577.20
2,036.56
  
6-1006
Recruiting Bonus
380.20
 
-
-
102.45
72.33
-
50.59
-
-
100.47
-
-
54.36
  
6-1007
Aflac Cancer-Health-Acc Insurance
5,742.18
 
497.30
497.30
497.30
497.30
497.30
497.30
459.73
459.73
459.73
459.73
459.73
459.73
  
6-7000
Bad Debt exp
33.00
 
-
-
-
-
-
-
-
-
-
-
-
33.00
 
Office Operations
137,330.64
 
6,661.10
14,557.75
24,920.92
11,918.84
10,991.80
13,477.96
8,119.19
14,566.06
9,648.17
8,731.62
9,157.88
4,579.35
  
6-2001
MLS - Board Dues
9,636.93
 
303.00
225.00
2,179.60
170.00
-
1,914.00
225.00
1,740.00
1,980.33
780.00
-
120.00
  
6-2002
Telephone And Internet
18,135.09
 
1,403.41
1,199.64
1,574.90
1,648.82
1,526.98
1,452.07
1,488.15
1,470.34
1,507.35
2,957.34
1,473.93
432.16
  
6-2003
Visual Tour
1,600.00
 
400.00
400.00
400.00
400.00
-
-
-
-
-
-
-
-
  
6-2006
Licenses & Fees
8,732.56
 
-
-
8,511.56
-
75.00
125.00
21.00
-
-
-
-
-
  
6-2008
New Gville Office Building
1,815.24
 
-
-
-
-
-
1,815.24
-
-
-
-
-
-
  
6-2009
Office Luncheons/Beverages
8,690.91
 
125.94
1,364.64
200.08
89.14
181.86
655.11
627.20
168.43
2,893.92
373.61
153.98
1,857.00
  
6-2010
Lockboxes
223.42
 
16.63
16.83
16.84
16.84
16.84
16.84
16.84
16.84
16.84
18.02
18.02
36.04
  
6-2011
Recruiting exp
3,296.50
 
-
269.00
538.00
606.50
269.00
269.00
269.00
269.00
-
269.00
538.00
-
  
6-2012
Recruiting Meals exp
1,917.23
 
483.98
291.42
237.00
20.00
219.02
-
-
174.40
-
324.81
143.17
23.43
  
6-2013
Advertising And Marketing Exp
12,630.50
 
476.72
405.57
773.61
1,173.13
2,725.61
250.37
2,692.10
1,010.17
1,193.75
1,134.50
794.97
-
  
6-2018
Office Supplies
12,052.11
 
2,154.52
879.27
546.34
406.26
1,394.92
1,573.82
1,312.24
1,459.61
295.99
759.52
532.46
737.16
  
6-2020
Website Management
8,093.50
 
742.58
-
1,485.16
742.58
742.58
742.58
742.58
723.86
723.86
-
723.86
723.86
  
6-2021
Website and System Training Exp
2,764.66
 
-
-
970.00
-
1,794.66
-
-
-
-
-
-
-
  
6-2022
Signs
3,034.46
 
-
272.00
778.43
-
662.55
560.68
-
149.38
492.71
-
118.71
-
  
6-2031
Dues, Fees, Subscriptions
5,544.57
 
111.00
3,236.00
222.00
229.20
111.00
695.00
111.00
334.37
111.00
120.00
120.00
144.00
  
6-2037
Zillow
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
6-2040
Relocation Dept Expenses
19,250.38
 
432.42
3,932.42
3,989.02
3,602.14
432.42
567.44
432.42
1,832.42
432.42
432.42
2,732.42
432.42
  
6-2041
Relo Dept Exp for Reimbursement
512.48
 
-
-
-
-
-
-
31.66
31.62
-
31.90
344.02
73.28
  
6-2052
Travel
10,318.82
 
-
-
-
1,723.11
739.36
1,370.81
-
4,060.62
-
1,410.58
1,014.34
-
  
6-2053
Conference Regis And Fees
6,157.32
 
-
672.82
1,998.38
1,091.12
-
1,270.00
-
1,125.00
-
-
-
-
  
6-2054
Gratitude Gath-Special Events
119.92
 
-
-
-
-
-
-
-
-
-
119.92
-
-
  
6-2055
Awards
1,404.04
 
10.90
1,393.14
-
-
-
-
-
-
-
-
-
-
  
6-2056
Training/Coaching
900.00
 
-
-
-
-
100.00
200.00
150.00
-
-
-
450.00
-
  
6-2121
Do Not Use Website Exp
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
6-2580
Misc Office Supplies
500.00
 
-
-
500.00
-
-
-
-
-
-
-
-
-
 
Equipment & Furnishing Exp.
63,603.82
 
4,274.34
6,153.62
4,595.20
4,104.01
4,741.86
6,887.85
4,369.77
7,010.28
4,616.80
5,726.59
5,275.80
5,847.70
  
6-3001
Equipment Purchased exp
2,220.03
 
-
-
-
-
-
-
-
2,095.03
125.00
-
-
-
  
6-3002
Equipment Lease exp
12,921.03
 
1,002.19
1,085.66
1,323.63
1,085.77
1,020.28
1,042.42
1,031.84
1,142.27
642.52
1,189.64
1,160.21
1,194.60
  
6-3003
Equipment Repair/Upgrades
1,542.43
 
110.00
280.00
-
-
-
1,042.43
-
-
110.00
-
-
-
  
6-3007
Computer Software And Supplies
21,064.97
 
1,288.15
2,340.30
1,360.12
1,106.79
1,275.13
2,891.55
1,426.48
1,326.53
1,827.83
2,625.50
1,669.14
1,927.45
  
6-3009
Dotloop
12,327.61
 
749.00
1,322.66
786.45
786.45
1,321.45
786.45
786.45
1,321.45
786.45
786.45
1,321.45
1,572.90
  
6-3010
Accounttech
13,527.75
 
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,125.00
1,152.75
 
Occupancy And Vehicle
370,304.35
 
30,305.67
29,484.69
32,467.77
34,164.81
29,855.55
30,383.94
31,233.26
30,993.40
30,814.07
41,682.53
31,490.75
17,427.91
  
6-4001
Rent exp
295,633.85
 
25,074.54
25,074.54
25,074.54
30,140.32
25,241.92
25,241.92
25,241.92
25,241.92
25,241.92
25,241.92
26,113.39
12,705.00
  
6-4002
Utilities exp
25,573.46
 
2,172.67
2,514.68
2,030.79
1,745.03
1,586.99
1,891.61
2,443.16
2,540.62
2,375.56
2,064.67
1,990.85
2,216.83
  
6-4003
Security System
1,479.00
 
864.00
-
75.00
250.00
-
-
-
-
240.00
-
50.00
-
  
6-4004
Repairs And Maintenance
8,244.75
 
543.17
195.00
1,330.00
195.00
550.00
570.00
1,575.00
884.05
992.53
195.00
285.00
930.00
  
6-4005
Vehicle Mtnce And Fuel
2,682.18
 
207.52
221.70
223.67
230.25
332.43
203.45
268.03
120.58
350.29
208.22
131.96
184.08
  
6-4006
Lscape/Clean/Trash/Shred
24,646.16
 
1,443.77
1,478.77
3,733.77
1,604.21
2,144.21
2,476.96
1,705.15
2,206.23
1,613.77
1,927.77
2,919.55
1,392.00
  
6-4009
Property Taxes
12,044.95
 
-
-
-
-
-
-
-
-
-
12,044.95
-
-
 
Insurance
38,660.75
 
4,998.75
2,942.25
3,665.73
3,768.99
118.74
5,204.64
826.74
3,699.61
2,971.39
6,762.05
730.47
2,971.39
  
6-4021
E&O Insurance
31,225.85
 
2,942.25
2,942.25
2,942.25
2,942.25
-
4,599.90
-
2,971.39
2,971.39
5,942.78
-
2,971.39
  
6-4023
Vehicle Insurance
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
6-4024
Office Building Insurance
6,084.90
 
706.50
-
723.48
826.74
118.74
604.74
826.74
728.22
-
819.27
730.47
-
  
6-4025
Workman's Comp Insurance
1,350.00
 
1,350.00
-
-
-
-
-
-
-
-
-
-
-
 
Wages
632,518.58
 
38,614.49
38,092.28
42,826.30
38,526.48
36,851.84
42,442.98
40,151.34
39,960.32
47,174.46
40,996.88
41,194.19
185,687.02
  
6-5001
Office Staff Wages
241,952.15
 
18,885.33
19,987.81
24,379.01
20,493.19
19,036.84
24,154.25
19,577.81
19,477.82
21,425.17
16,466.81
16,644.57
21,423.54
  
6-5004
Management Wages
335,489.90
 
15,500.00
14,500.00
14,500.00
14,500.00
14,500.00
14,500.00
17,000.00
17,000.00
18,923.08
21,000.00
21,000.00
152,566.82
  
6-5006
Management Insurance Benefit
5,606.09
 
351.60
-
-
-
-
-
-
-
2,881.57
-
-
2,372.92
  
6-5009
Managers Consulting Fees - 1099 Exp
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
6-5012
Payroll Preparation exp
3,714.41
 
464.75
253.64
252.04
329.55
263.73
263.73
328.39
263.73
323.29
258.63
258.63
454.30
  
6-5200
Employer FICA-Medicare Share
44,674.30
 
3,061.03
3,059.39
3,491.10
3,098.06
2,986.63
3,488.13
3,228.76
3,211.62
3,617.71
3,271.44
3,290.99
8,869.44
  
6-5300
FUTA And SC Unemployment
1,081.73
 
351.78
291.44
204.15
105.68
64.64
36.87
16.38
7.15
3.64
-
-
-
 
Wages Related
3,090.63
 
-
825.00
540.24
-
-
172.93
90.00
600.00
154.84
-
-
707.62
  
6-5014
Profit Sharing - Mitzi Kirsch
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
6-5100
Legal & CPA/Tax Accounting
915.00
 
-
825.00
-
-
-
-
90.00
-
-
-
-
-
  
6-6001
Life Insurance - Management
464.52
 
-
-
154.84
-
-
154.84
-
-
154.84
-
-
-
  
6-8000
Real Estate School Expenses
1,711.11
 
-
-
385.40
-
-
18.09
-
600.00
-
-
-
707.62
 
Total Expense
1,302,324.61
 
88,006.05
96,180.63
114,263.92
96,582.47
87,772.44
105,313.59
90,831.42
104,652.30
99,271.99
107,041.04
91,826.59
220,582.17
 
Operating Profit
109,125.06
 
(17,513.84)
(1,501.64)
84,864.01
7,998.15
67,243.82
42,697.42
42,689.39
40,365.26
445.37
(29,067.30)
(9,441.97)
(119,653.61)
Other Income
135,214.31
 
10,552.37
10,442.13
11,388.63
11,569.70
9,966.29
10,813.34
11,721.95
10,234.90
12,280.69
9,463.39
10,804.59
15,976.33
 
Other Income
135,214.31
 
10,552.37
10,442.13
11,388.63
11,569.70
9,966.29
10,813.34
11,721.95
10,234.90
12,280.69
9,463.39
10,804.59
15,976.33
  
8-1015
Bank SVC Refunds/Interest Income
251.07
 
3.50
10.67
108.52
48.41
38.53
3.42
(14.46)
3.54
0.93
41.05
3.44
3.52
  
8-2500
Misc Income
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
8-3000
Agent Reimbursement Income
48,372.26
 
4,340.00
4,357.42
5,361.56
3,991.32
3,896.88
4,779.04
4,025.17
4,206.32
4,706.71
3,620.13
4,915.50
172.21
  
8-5004
Kirsch Wage Income
86,590.98
 
6,208.87
6,074.04
5,918.55
7,529.97
6,030.88
6,030.88
7,711.24
6,025.04
7,573.05
5,802.21
5,885.65
15,800.60
 
Total Other Income
135,214.31
 
10,552.37
10,442.13
11,388.63
11,569.70
9,966.29
10,813.34
11,721.95
10,234.90
12,280.69
9,463.39
10,804.59
15,976.33
Other Expense
88,499.99
 
6,165.20
6,031.95
7,860.40
7,820.76
6,236.99
8,090.66
6,217.97
6,441.83
8,600.83
5,940.28
7,156.29
11,936.83
 
Other exp
88,499.99
 
6,165.20
6,031.95
7,860.40
7,820.76
6,236.99
8,090.66
6,217.97
6,441.83
8,600.83
5,940.28
7,156.29
11,936.83
  
9-1010
Credit Card Interest
5.39
 
-
-
-
-
5.39
-
-
-
-
-
-
-
  
9-1015
Bank Interest exp
79.94
 
20.92
-
-
59.02
-
-
-
-
-
-
-
-
  
9-1500
Bank Charges
4,337.90
 
359.45
366.95
361.95
562.95
329.95
347.95
329.95
329.95
367.45
278.95
364.95
337.45
  
9-2500
Misc. Exp
1,398.54
 
28.95
31.95
111.22
206.95
196.81
31.95
130.94
31.95
-
-
-
627.82
  
9-2600
Property Management Misc Exp
1,718.02
 
127.88
129.05
127.88
31.30
200.84
252.16
129.08
226.50
127.67
-
240.58
125.08
  
9-4003
Kirsch Wages
71,829.50
 
5,628.00
5,504.00
6,756.00
5,504.00
5,504.00
6,942.00
5,628.00
5,504.00
6,942.00
5,297.00
5,374.50
7,246.00
  
9-4004
Patel Wages
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
9-4006
Fuller Wages
-
 
-
-
-
-
-
-
-
-
-
-
-
-
  
9-5000
Gifts
5,173.14
 
-
-
-
416.66
-
516.60
-
349.43
163.71
-
126.26
3,600.48
  
9-5001
Donations
3,384.88
 
-
-
100.00
1,039.88
-
-
-
-
1,000.00
195.00
1,050.00
-
  
9-6001
State Income Tax exp
403.35
 
-
-
403.35
-
-
-
-
-
-
-
-
-
  
9-6002
Personal Property Tax
169.33
 
-
-
-
-
-
-
-
-
-
169.33
-
-
  
9-6004
Franchise Tax
-
 
-
-
-
-
-
-
-
-
-
-
-
-
 
Total Other Expense
88,499.99
 
6,165.20
6,031.95
7,860.40
7,820.76
6,236.99
8,090.66
6,217.97
6,441.83
8,600.83
5,940.28
7,156.29
11,936.83
               
 
Net Profit
155,839.38
 
(13,126.67)
2,908.54
88,392.24
11,747.09
70,973.12
45,420.10
48,193.37
44,158.33
4,125.23
(25,544.19)
(5,793.67)
(115,614.11)
/AT2017_Reports/rptProfitAndLossbyMonth
Page 1/1