Profit And Loss
Date run 3/5/2023
Run for all Companies for all Offices for all Regions for all Divisions for Date range from 11/01/2022 to 11/30/2022 using Calculated Data
      
   
expand GL accts
balance
last year
variance
 
ytd
ytd last year
variance YTD
Income
471,437.13
675,546.23
($204,109.10)
 
7,725,921.55
8,070,297.31
(344,375.76)
 
Operational Income
28,012.68
36,802.58
($8,789.90)
 
445,112.35
508,728.06
($63,615.71)
  
Ad Fund withholding
($323.15)
 
($57,143.08)
  
Franchise Fee withholding
($9,651.40)
 
($4,410.80)
  
RELO Dept/B2B INCENTIVE
-
 
($641.87)
  
Lead Fee
-
 
($5,008.21)
  
RELO DEPT Reimbursements
-
 
($109.53)
  
Recruiting Incentives Forfeited
239.93
 
1,179.23
  
Property Management Income
1,047.50
 
3,299.92
  
Real Estate School Income
($102.78)
 
($781.37)
 
Listing Side Commission 100%
148,637.69
243,118.07
($94,480.38)
 
2,723,577.29
2,724,478.64
($901.35)
  
List Side Commission Income
($94,480.38)
 
($901.35)
 
Selling Side Commission 100%
246,679.83
291,571.57
($44,891.74)
 
3,605,675.86
3,637,614.10
($31,938.24)
  
Sell Side Commission Income
($44,891.74)
 
($31,938.24)
 
Commercial Income
940.00
-
940.00
 
95,861.21
55,149.83
40,711.38
  
Commercial Commission Income
940.00
 
40,711.38
 
Service Income
47,166.93
104,054.01
($56,887.08)
 
855,694.84
1,144,326.68
($288,631.84)
  
Rental Commission Income
-
($2,839.32)
 
($13,664.04)
  
Transaction Coordinator Fee Income
300.00
 
750.00
  
Referral Commission Income
($54,340.26)
 
25,348.80
  
Alternate Other Income
($7.50)
 
($3,066.68)
  
Zillow/Mtge Opt Reimbursements
-
 
($10,000.00)
  
CIB - Franchise Reim
-
 
($16,552.92)
  
Other NON TAXABLE INCOME - PPP LOAN FORGIVENESS
-
 
($279,947.00)
  
Mortgage Options-Website Sponsorship
-
 
8,500.00
   
Total Income
471,437.13
675,546.23
($204,109.10)
 
7,725,921.55
8,070,297.31
(344,375.76)
Cost of Sales
389,052.51
571,862.48
($182,809.97)
 
6,415,400.44
6,347,326.79
68,073.65
 
Cost of Sales
389,052.51
571,862.48
($182,809.97)
 
6,415,400.44
6,347,326.79
68,073.65
  
NAF (2%) Paid
($373.25)
 
825.71
  
Company $ transferred to Office
-
 
-
  
Franchise transferred to Office
($9,651.40)
 
($4,410.75)
  
Lead Fees transferred to Office
-
 
-
  
Property Management
523.75
 
1,999.34
  
List Side Commission Paid
($82,294.07)
 
23,563.43
  
Sell Side Commission Paid
($35,814.28)
 
2,131.45
  
Commercial Commission Paid
658.00
 
30,039.01
  
Rental Commission Paid
($2,129.49)
 
($10,468.83)
  
Transaction Coordinator Fee Paid
300.00
 
-
750.00
  
Referral Commission Paid
($54,029.23)
 
23,644.29
   
Total Cost of Sales
389,052.51
571,862.48
($182,809.97)
 
6,415,400.44
6,347,326.79
68,073.65
   
Gross Profit
82,384.62
103,683.75
($21,299.13)
 
1,310,521.11
1,722,970.52
($412,449.41)
Expense
91,826.59
111,321.15
($19,494.56)
 
1,081,742.44
1,122,496.23
(40,753.79)
 
Expenses
3,977.50
4,569.40
($591.90)
 
53,454.66
51,435.16
2,019.50
  
Agent expenses
-
 
($370.64)
  
Agent Personal exp
-
 
55.00
  
Recruiting Override
($117.09)
 
1,074.74
  
Manager Override
($409.26)
 
2,773.36
  
Recruiting Bonus
($27.98)
 
($451.57)
  
Aflac Cancer-Health-Acc Insurance
($37.57)
 
($445.71)
  
Bad Debt exp
-
 
($615.68)
 
Office Operations
9,157.88
10,794.77
($1,636.89)
 
132,751.29
165,883.68
($33,132.39)
  
MLS - Board Dues
($435.00)
 
2,284.83
  
Telephone And Internet
132.94
 
3,396.73
  
Visual Tour
($400.00)
 
($2,600.00)
  
Licenses & Fees
-
 
2,785.82
  
New Gville Office Building
-
 
-
1,815.24
  
Office Luncheons/Beverages
($69.20)
 
4,512.62
  
Lockboxes
1.39
 
($95.13)
  
Recruiting exp
538.00
 
860.56
  
Recruiting Meals exp
($127.11)
 
($3,339.82)
  
Advertising And Marketing Exp
($2,856.30)
 
($38,023.53)
  
Office Supplies
($1,106.68)
 
($1,065.29)
  
Website Management
($18.72)
 
2,803.14
  
Website and System Training Exp
-
 
($4,086.09)
  
Signs
118.71
 
2,612.53
  
Dues, Fees, Subscriptions
9.00
 
($1,231.13)
  
Zillow
-
 
($20,000.00)
  
Relocation Dept Expenses
900.00
 
6,453.92
  
Relo Dept Exp for Reimbursement
344.02
 
339.20
  
Travel
882.06
 
6,513.79
  
Conference Regis And Fees
-
 
5,682.32
  
Gratitude Gath-Special Events
-
 
-
119.92
  
Awards
-
 
275.79
  
Training/Coaching
450.00
 
($1,437.50)
  
Do Not Use Website Exp
-
 
($645.25)
  
Misc Office Supplies
-
 
($1,065.06)
 
Equipment & Furnishing Exp.
5,275.80
5,840.02
($564.22)
 
57,756.12
52,552.43
5,203.69
  
Equipment Purchased exp
-
 
1,941.84
  
Equipment Lease exp
($518.04)
 
($576.03)
  
Equipment Repair/Upgrades
-
 
80.85
  
Computer Software And Supplies
($83.63)
 
3,571.32
  
Dotloop
37.45
 
910.71
  
Accounttech
-
 
($725.00)
 
Occupancy And Vehicle
31,490.75
45,426.38
($13,935.63)
 
352,876.44
350,976.26
1,900.18
  
Rent exp
1,038.85
 
3,524.08
  
Utilities exp
93.85
 
574.68
  
Security System
50.00
 
1,374.00
  
Repairs And Maintenance
($2,435.00)
 
437.66
  
Vehicle Mtnce And Fuel
($57.36)
 
($2,065.72)
  
Lscape/Clean/Trash/Shred
($581.02)
 
($1,944.52)
  
Property Taxes
($12,044.95)
 
-
 
Insurance
730.47
3,060.99
($2,330.52)
 
35,689.36
34,627.62
1,061.74
  
E&O Insurance
($2,942.25)
 
1,323.19
  
Vehicle Insurance
-
 
($1,254.60)
  
Office Building Insurance
611.73
 
1,077.15
  
Workman's Comp Insurance
-
 
($84.00)
 
Wages
41,194.19
41,629.59
($435.40)
 
446,831.56
464,260.41
($17,428.85)
  
Office Staff Wages
($2,457.13)
 
($6,909.81)
  
Management Wages
2,065.60
 
($4,177.98)
  
Management Insurance Benefit
-
 
351.60
  
Managers Consulting Fees - 1099 Exp
-
 
($4,850.00)
  
Payroll Preparation exp
8.19
 
($538.47)
  
Employer FICA-Medicare Share
($20.86)
 
($935.19)
  
FUTA And SC Unemployment
($31.20)
 
($369.00)
 
Wages Related
-
-
-
 
2,383.01
2,760.67
($377.66)
  
Legal & CPA/Tax Accounting
-
 
90.00
  
Life Insurance - Management
-
 
-
  
Real Estate School Expenses
-
 
($467.66)
   
Total Expense
91,826.59
111,321.15
($19,494.56)
 
1,081,742.44
1,122,496.23
(40,753.79)
   
Operating Profit (E.B.I.T.D.A.)
($9,441.97)
($7,637.40)
($1,804.57)
 
228,778.67
600,474.29
($371,695.62)
Other Income
10,804.59
9,925.00
879.59
 
119,237.98
111,384.71
7,853.27
 
Other Income
10,804.59
9,925.00
879.59
 
119,237.98
111,384.71
7,853.27
  
Bank SVC Refunds/Interest Income
0.41
 
212.21
  
Misc Income
-
 
-
  
Agent Reimbursement Income
751.59
 
($3,681.24)
  
Kirsch Wage Income
127.59
 
11,322.30
   
Total Other Income
10,804.59
9,925.00
879.59
 
119,237.98
111,384.71
7,853.27
Other Expense
7,156.29
6,179.56
976.73
 
76,563.16
74,848.84
1,714.32
 
Other exp
7,156.29
6,179.56
976.73
 
76,563.16
74,848.84
1,714.32
  
Credit Card Interest
-
 
5.39
  
Bank Interest exp
-
 
75.62
  
Bank Charges
13.00
 
63.00
  
Misc. Exp
($28.95)
 
($889.55)
  
Property Management Misc Exp
112.95
 
550.63
  
Kirsch Wages
118.50
 
281.25
  
Patel Wages
-
 
-
  
Fuller Wages
-
 
-
  
Gifts
($119.58)
 
($935.39)
  
Donations
1,050.00
 
2,384.88
  
State Income Tax exp
-
 
378.35
  
Personal Property Tax
($169.19)
 
0.14
  
Franchise Tax
-
 
($200.00)
   
Total Other Expense
7,156.29
6,179.56
976.73
 
76,563.16
74,848.84
1,714.32
           
   
Net Profit
($5,793.67)
($3,891.96)
($1,901.71)
 
271,453.49
637,010.16
($365,556.67)
           
"Print 8.5 x 11 landscape "
Page 1/1
/AT2017_Reports/rptProfitAndLoss