Sample of Custom Reports on QBO
GOODMAN’S LLC
Income after Loan, Owner pay and Sale Tax Reports
For the months from January 2024 to June 2024
Jan 2024
Feb 2024
Mar 2024
Apr 2024
May 2024
Jun 2024
Total
Income
31,833.30
Cash- Metal Sale
34,475.56
9,596.95
40,106.85
116,-
Ebay - Goodmans Antique
Ebay Sales
Ebay Other fee
Ebay Refund
Total Ebay - Goodmans Antique
$
4,472.76
2,487.67
4,175.68
3,529.99
-27.95
-27.95
-27.95
-27.95
-171.37
-43.82
4,273.44
$
2,415.90
$
4,147.73
$
3,502.04
$
10,269.15
6,308.98
31,244.23
-27.95
-27.95
-167.70
-328.54
-50.05
-593.78
9,912.66 $
6,230.98 $
717.50
Ebay Sale
607.27
3,069.28
-154.18
-6.98
7,344.91
Ebay Other fee
Ebay Refunds
Total Ebay Sales - AlansWorld
30,-
Ebay Sales - AlansWorld
$
717.50
$
453.09
$
3,062.30
$
3,293.66
1,491.98
16,524.60
-51.01
-51.01
-1.42
-162.58
7,292.48
$
3,293.66 $
1,491.98 $
16,-
Etsy Shop Sales
1,916.21
2,431.60
1,928.85
2,222.90
2,822.69
Etsy - Processing fees
-53.64
-85.08
-61.88
-76.11
-84.80
-361.51
Etsy - Transaction fees
-99.78
-158.13
-115.05
-144.53
-160.13
-677.62
Etsy Advertisement fee
-13.20
-41.40
-8.40
-35.88
-63.36
-162.24
-52.60
-41.60
-30.20
-33.40
-285.78
0.00
-32.79
Etsy Sales
Etsy Listing Fee
Etsy refund
Total Etsy Shop Sales
$
1,411.21
$
2,105.39
$
1,680.53
$
1,932.98
$
101.65
-64.80
-7.60
-230.20
-179.82
-101.65
-600.04
2,269.78
-$
7.60 $
24,997.05
Shopify Sales - Gloucester Courthouse
Shopify Sales - Gloucester Point
18,364.39
16,728.44
16,964.81
20,837.45
18,199.56
116,091.70
21,085.21
26,944.66
44,583.79
23,231.69
20,833.00
136,678.35
5,961.66
2,680.22
24,335.40
7,939.28
4,485.60
46,277.72
1,245.00
2,174.13
706.00
500.99
338.99
4,965.11
1,192.36
728.00
395.00
5,715.00
1,223.00
9,809.67
449.00
560.00
400.00
807.00
2,075.00
4,291.00
90.00
697.00
7,053.96
3,525.64
5,333.00
23,462.98
1,000.25
Shopify Sales - Williamsburg
875.56
Cash Sales - Gloucester Courthouse
Cash Sales - Gloucester Point
556.31
Check Sales - Gloucester Courthouse
Check Sales - Gloucester Point
Other Shopify Sales
4,193.01
Sales - Online Store
1,000.25
12.00
595.00
1,567.00
1,790.37
50.00
Shopify Shipping Income
Shopify Discount
Shopify Refund
Total Income
9,-
Shopify Sales
Total Shopify Sales
11,423.90
50.00
-2,660.27
-3,766.84
-4,734.73
-5,850.17
-3,511.01
-5,198.75
-25,721.77
-462.51
-2,457.55
-63.75
-837.00
-349.55
-4,947.05
-9,117.41
$
27,499.15
$
44,652.48
$
47,402.34
$
87,751.79
$
58,746.49 $
42,432.35 $
308,484.60
$
33,901.30
$
81,460.16
$
90,768.46 $ 110,076.24
$
114,329.44 $
50,147.71 $
480,683.31
47,607.00
25,783.90
164,368.77
17.66
82.81
2,498.73
Cost of Goods Sold
0.00
Cost of goods sold
Inventory Purchases
Shipping
10,485.13
5,718.00
32,548.24
881.56
750.00
766.70
215.77
42,226.50
342.56
449.44
Total Cost of goods sold
$
11,366.69
$
6,683.77
$
33,642.19
$
43,369.41
$
47,967.22 $
26,316.15 $
169,345.43
Total Cost of Goods Sold
$
11,366.69
$
6,683.77
$
33,642.19
$
43,369.41
$
47,967.22 $
26,316.15 $
169,345.43
Gross Profit
$
22,534.61
$
74,776.39
$
57,126.27
$
66,706.83
$
66,362.22 $
23,831.56 $
311,337.88
Supplies & materials - COGS
327.25
1,142.91
2,477.93
Expenses
10,000.00
Abnormal Loss
53.89
Advertising
386.44
8,750.00
Contract labor
438.76
827.00
2,081.50
2,556.50
10,000.00
325.00
410.45
2,116.54
1,699.00
15,412.00
500.00
Contributions to charities
500.00
600.00
Employees Benefits Expense
-
General business expenses
Bank fees & service charges
727.55
Memberships & subscriptions
190.00
Total General business expenses
$
917.55
989.11
1,274.73
1,712.03
1,334.42
1,185.14
325.00
$
989.11
$
1,599.73
7,-
$
1,712.03
$
1,334.42 $
1,185.14 $
7,737.98
Insurance
0.00
Business insurance
0.00
Insurance- Workers Compensation
409.00
Travelers Insurance
662.25
-
662.27
662.27
662.27
662.27
3,973.60
Total Business insurance
$
1,071.25
$
662.27
$
662.27
$
662.27
$
662.27
$
662.27 $
4,382.60
Total Insurance
$
1,071.25
$
662.27
$
662.27
$
662.27
$
662.27
$
662.27 $
4,382.60
800.09
Legal & Professional Services
273.00
Accounting fees
-
Legal Fees
Total Legal & Professional Services
Meals & Entertainment
800.09
$
-
$
1,-
25.00
$
0.00
$
0.00
52.43
3,067.53
2,792.53 $
4,308.62
106.81
-
1,218.36
Printing & photocopying
145.15
Shipping & postage
344.60
Small tools & equipment
193.00 $
106.39
Office expenses
Office supplies
$
441.00
2,792.53
366.29
964.39
1,-
-
1,278.02
-
743.18
5,531.55
352.57
794.84
1,231.07
1,786.36
1,670.21
484.30
Software & apps
Total Office expenses
$
1,137.71
479.30
$
2,187.41
615.17
$
1,584.34
1,700.46
$
2,664.85
$
1,640.74
1,803.94
4,844.56 $
4,130.76 $
140.00
Parking & tolls
6,723.91
140.00
-
Payroll Expenses
4,615.36
Officers' salaries
Payroll Processing Fee
Payroll taxes
5,769.20
$
4,615.36
4,615.36
5,769.20
29,999.84
117.00
105.00
105.00
111.00
129.95
129.95
697.90
1,769.39
1,654.36
2,138.25
1,818.48
1,911.59
11,951.92
23,223.53
19,830.98
110,935.98
30,941.16 $
26,487.88 $
153,585.64
-205.00
30.00
785.12
21,546.75
20,703.22
$
28,346.81
16,754.92
$
23,129.64
16,268.79
$
23,133.40
$
960.12
Permits & License
Rent
480.00
440.00
Repairs & maintenance
428.29
50.85
8,728.92
11,667.04
Repairs and Maintenance - Building
4,615.36
2,-,154.54
Salaries & wages
Total Payroll Expenses
440.00
440.00
440.00
440.00
2,680.00
1,388.40
2,186.30
628.57
4,682.41
1,034.91
21,-
Travel
349.54
Hotels
Total Travel
16,549.63
$
0.00
$
-171.15
Uncategorized Expense
0.00
$
0.00
$
0.00
$
0.00
$
349.54
349.54
$
171.15
-
Utilities
Disposal & waste fees
138.00
65.07
883.51
799.73
Electricity
555.53
Heating Fuel
303.49
Internet & TV services
267.67
807.67
115.04
Natural Gas
162.96
144.43
29.43
Phone service
303.74
303.74
321.94
437.07
705.61
758.49
4,393.80
1,036.16
42.75
Water & sewer
-
390.45
1,-
738.53
2,-
315.62
-102.76
315.62
278.83
1,560.66
68.24
253.15
930.66
Total Utilities
$
1,636.14
$
2,667.80
$
2,264.61
$
1,285.38
$
1,461.40 $
1,750.17 $
11,065.50
Total Expenses
$
40,448.64
$
44,017.96
$
29,616.00
$
30,227.99
$
47,410.52 $
35,780.98 $
227,502.09
Net Operating Income
-$
17,914.03
$
30,758.43
$
27,510.27
$
36,478.84
$
18,951.70
11,949.42 $
83,835.79
-$
Other Income
Banking Rewards
Grant Income
32.00
1.10
4,000.00
9,203.44
81.70
1.35
98.80
-,203.44
3,250.00
Other Miscellaneous Income
Total Other Income
85.59
$
4,032.00
$
9,204.54
$
3,331.70
3,250.00
$
85.59
$
1.35
$
98.80 $
16,753.98
Other Expenses
0.00
Vehicle expenses
127.99
Vehicle gas & fuel
-
Vehicle registration
16.00
32.00
Total Vehicle expenses
$
0.00
$
0.00
$
0.00
$
127.99
$
16.00
$
16.00
$
159.99
Total Other Expenses
$
0.00
$
0.00
$
0.00
$
127.99
$
16.00
$
16.00
$
159.99
Net Other Income
$
4,032.00
$
9,204.54
$
3,331.70
-$
42.40
-$
14.65
$
Net Income
-$
13,882.03
$
39,962.97
$
30,841.97
$
36,436.44
$
18,937.05
-$
82.80 $
16,593.99
11,866.62 $
100,429.78
Long Term Liabilities
Interest paid
Commercial Loan
2,748.67
2,748.66
2,571.34
2,748.66
2,660.00
2,748.67
16,226.00
Real Estate Loan
1,940.02
1,936.94
1,809.26
1,809.26
1,865.26
1,924.24
11,284.98
360.02
360.02
391.71
383.92
353.72
359.23
2,208.62
SBA Interest
Total Interest paid
$
5,048.71
$
5,045.62
$
4,772.31
$
4,941.84
$
4,878.98 $
5,032.14 $
29,719.60
Principal Amount
Commercial Loan
Real Estate Loan
SBA Interest
Total Principal Amount
$
-
-
-
-
-
-
-
659.36
662.44
790.12
790.12
734.12
675.14
4,311.30
2,161.98
2,161.98
2,130.29
2,138.08
2,168.28
2,162.77
12,923.38
2,902.40 $
2,837.91 $
17,234.68
2,821.34
$
2,824.42
$
2,920.41
$
2,928.20
$
Total Payment
Commercial Loan
2,748.67
2,748.66
2,571.34
2,748.66
2,660.00
2,748.67
16,226.00
Real Estate Loan
2,599.38
2,599.38
2,599.38
2,599.38
2,599.38
2,599.38
15,596.28
SBA Interest
2,522.00
2,522.00
2,522.00
2,522.00
2,522.00
2,522.00
15,132.00
Total Payment
$
7,870.05
$
7,870.04
$
7,692.72
$
7,870.04
$
7,781.38 $
7,870.05 $
46,954.28
Sale Tax Paid
$
2,547.69
$
1,158.24
$
2,078.13
$
2,937.70
$
3,773.36 $
2,602.95 $
15,098.07
Owner Equity
Alan Goodman
138.27
Insurance Distributions
Partner Distributions
Total
$
138.27
$
387.08
891.66
3,000.00
1,000.00
3,387.08
$
1,891.66
757.33
892.63
504.39
3,571.36
4,000.00
$
757.33
$
892.63
$
504.39 $
7,571.36
Lisa Goodman
Insurance Distributions
Partner Distributions
$
Total Amount after loan, Owner
Distributions and Sale Tax paid
-$
207.41
580.61
1,307.50
1,136.00
1,338.95
756.60
5,327.07
8,500.00
4,500.00
7,500.00
18,500.00
9,500.00
4,735.94
53,235.94
5,492.54 $
58,563.01
8,707.41
$
5,080.61
$
8,807.50
$
19,636.00
$
33,145.45
$
22,467.00
$
10,371.96
$
5,235.37
-$
10,838.95 $
4,349.27
-$
28,336.55
-$
27,756.94