Filter Criteria includes: Report order is by ID. Report is printed in Detail Format.
Customer ID Customer Date Trans No Type Debit Amt Credit Amt Balance
ap001 Aileen Phinney 1/7/19 101 SJ 324.00 324.00
ap001 Aileen Phinney 1/18/19 106 SJ 324.00 648.00
ap001 Aileen Phinney 1/21/19 Invoice 101 CRJ 324.00 324.00
ap001 Aileen Phinney 1/25/19 Invoice 106 CRJ 324.00 0.00
bb002 Betsy Bauman 1/10/19 105 SJ 53.88 53.88
bb002 Betsy Bauman 1/21/19 109 SJ 81.00 134.88
bb002 Betsy Bauman 1/28/19 Invoice 105 CRJ 53.88 81.00
dc003 Denise Cobb 1/7/19 102 SJ 640.00 640.00
dc003 Denise Cobb 1/18/19 107 SJ 320.00 960.00
dc003 Denise Cobb 1/28/19 Invoice 102 CRJ 640.00 320.00
jp004 Judi Perin 1/7/19 104 SJ 486.00 486.00
jp004 Judi Perin 1/23/19 Invoice 104 CRJ 105.00 381.00
pm005 Peter Martin 1/7/19 103 SJ 432.00 432.00
pm005 Peter Martin 1/14/19 CM103 SJ 108.00 324.00
pm005 Peter Martin 1/14/19 Invoice 103 CRJ 324.00 0.00
pm005 Peter Martin 1/18/19 108 SJ 216.00 216.00
pm005 Peter Martin 1/25/19 Invoice 108 CRJ 216.00 0.00
Report Total 2,876.88 2,094.88 782.00
Shannon’s Service Merchandise
Customer Ledgers
For the Period From Jan 1, 2019 to Jan 31, 2019
Filter Criteria includes: Report order is by ID.
Vendor ID Vendor Date Trans No Type Paid Debit Amt Credit Amt Balance
JJH06 James Jarvis Hardware 1/3/19 56JJ PJ 300.00 300.00
JJH06 James Jarvis Hardware 1/21/19 78JJ PJ * 500.00 800.00
JJH06 James Jarvis Hardware 1/28/19 VCM78JJ PJ * 100.00 700.00
JJH06 James Jarvis Hardware 1/28/19 3037 CDJ 8.00 8.00 700.00
JJH06 James Jarvis Hardware 1/28/19 3037 CDJ 400.00 300.00
LLP07 Len Lacey Products 1/21/19 90 PJ * 432.00 432.00
LLP07 Len Lacey Products 1/25/19 VCM90 PJ * 54.00 378.00
LLP07 Len Lacey Products 1/25/19 3036 CDJ 7.56 7.56 378.00
LLP07 Len Lacey Products 1/25/19 3036 CDJ 378.00 0.00
RBF08 Ronny Becker Fabrics 1/21/19 210 PJ * 120.00 120.00
RBF08 Ronny Becker Fabrics 1/28/19 3038 CDJ 2.40 2.40 120.00
RBF08 Ronny Becker Fabrics 1/28/19 3038 CDJ 120.00 0.00
TSS09 Tom’s Sales and Service 1/14/19 112 PJ 512.00 512.00
Report Total 1,069.96 1,881.96 812.00
Shannon’s Service Merchandise
Vendor Ledgers
For the Period From Jan 1, 2019 to Jan 31, 2019
Filter Criteria includes: Report order is by Date. Report is printed in Detail Format and with shortened descriptions.
Date GL Acct ID Reference Qty Line Description Debit Amount Credit Amount
1/7/19 12000 101 2.00 Two doorknobs 100.00
1/7/19 50000 101 2.00 Two doorknobs 100.00
1/7/19 12000 102 4.00 Four rolls of vinyl flooring 216.00
1/7/19 57000 102 4.00 Four rolls of vinyl flooring 216.00
1/7/19 12000 103 4.00 Four pairs of curtains 120.00
1/7/19 50500 103 4.00 Four pairs of curtains 120.00
1/7/19 12000 104 3.00 Three curain rods 150.00
1/7/19 50000 104 3.00 Three curain rods 150.00
1/14/19 12000 CM103 -1.00 Returned one pair of curtains 30.00
1/14/19 50500 CM103 -1.00 Returned one pair of curtains 30.00
1/18/19 12000 106 2.00 Two doorknobs 100.00
1/18/19 50000 106 2.00 Two doorknobs 100.00
1/18/19 12000 107 2.00 Two rolls of vinyl flooring 108.00
1/18/19 57000 107 2.00 Two rolls of vinyl flooring 108.00
1/18/19 12000 108 2.00 Two pairs of curtains 60.00
1/30/19 12000 Cash 10.00 Ten pairs of curtains 300.00
1/30/19 50500 Cash 10.00 Ten pairs of curtains 300.00
Total 2,044.00 2,044.00
5/14/2020 at 10:54 PM Page: 3
Filter Criteria includes: Report order is by Date. Report is printed in Detail Format and with shortened descriptions.
Date GL Acct ID Reference Qty Line Description Debit Amount Credit Amount
1/16/19 12000 SL -2.00 lighting 128.00
1/16/19 57050 SL -2.00 Two damaged light fixtures 128.00
Total 128.00 128.00
Shannon’s Service Merchandise
Inventory Adjustment Journal
For the Period From Jan 1, 2019 to Jan 31, 2019
5/14/2020 at 10:54 PM Page: 4
Filter Criteria includes: 1) Stock/Assembly. Report order is by ID. Report is printed with shortened descriptions.
Item ID Item Description Units Sold Sales($) Cost($) Gross Profit($) Gross Profit(%) % of Total
001hardware hardware 17.00 2,550.00 850.00 1,700.00 66.67 40.23
002wall wall 27.00 2,700.00 810.00 1,890.00 70.00 44.72
003floor floor 6.00 960.00 324.00 636.00 66.25 15.05
004lights lighting
50.00 6,210.00 1,984.00 4,226.00 100.00
Shannon’s Service Merchandise
Inventory Profitability Report
For the Period From Jan 1, 2019 to Jan 31, 2019
5/14/2020 at 10:54 PM Page: 5
Filter Criteria includes: Report order is by ID. Report is printed in Detail Format.
Account ID Account Description Debit Amt Credit Amt
10200 Interstate Bank 80,532.25
10400 Yuma Savings & Loan 22,000.00
11000 Accounts Receivable 782.00
12000 Merchandise Inventory 27,338.00
13000 Supplies 1,750.00
14000 Prepaid Insurance 2,400.00
39009 Shannon Larsen, Drawing 1,000.00
40000 Sales-Hardware 2,550.00
40200 Sales-Wall 2,700.00
40400 Sales-Floor 960.00
40600 Service Fees 124.89
50000 Cost of Sales-Hardware 850.00
Total: 251,896.89 251,896.89
Shannon’s Service Merchandise
General Ledger Trial Balance
As of Jan 31, 2019