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
 
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
 
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
 
Commercial 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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
Wages Related
3,090.63
 
-
825.00
540.24
-
-
172.93
90.00
600.00
154.84
-
-
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
 
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
 
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