1/31/2018
Your Name
January Withdrawal
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Practice Set 3, Document 94
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 674 of 690
Type Date Num Name Cl
r
Amount Balance
Beginning Balance 130,870.25
Cleared Transactions
Checks and Payments – 10 items
Bill Pmt -Check 01/08/2018 1 Textbook Co. X -1,000.00 -1,000.00
Deposits and Credits – 6 items
Deposit 01/05/2018 X 2,616.85 2,616.85
Deposit 01/10/2018 X 1,378.33 3,995.18
Deposit 01/15/2018 X 1,174.86 5,170.04
Uncleared Transactions
Checks and Payments – 11 items
Bill Pmt -Check 01/30/2018 7 Sacramento Rental -1,200.00 -1,200.00
Bill Pmt -Check 01/30/2018 8 Supplies Co. -822.05 -2,022.05
Check 01/30/2018 9 CA Utilities & Telephone -446.00 -2,468.05
Check 01/31/2018 17 Your Name -2,000.00 -4,468.05
Y
our Name’s Madison Avenue Books
Reconciliation Detail
Checking, Period Ending 01/31/2018
Practice Set 3, Document 95
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 675 of 690
Jan 18
Ordinary Income/Expense
Income
Returned Check Charges 40.00
Sales and Services Income
Book Sales 20,949.35
Keyboarding Services 148.00
Supplies Sales 861.88
Cost of Goods Sold
Cost of Goods Sold
Merchandise Discounts -88.85
Interest Expense 124.71
Merchandise Adjustments 5.00
Payroll Expenses 4,882.05
Other Income/Expense
Other Income
Interest Income 1,976.10
Y
our Name’s Madison Avenue Books
Profit & Loss
January 2018
Practice Set 3, Document 96
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 676 of 690
Jan 31, 18
ASSETS
Current Assets
Checking/Savings
Checking 124,798.43
Fixed Assets
Store Equipment & Fixtures
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Accounts Payable
Accounts Payable 705.00
Equity
First & Last Name, Capital
First & Last Name, Investment 75,000.00
First & Last Name, Capital – Othe
r
174,642.96
Y
our Name’s Madison Avenue Books
Balance Sheet
As of January 31, 2018
Practice Set 3, Document 97
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 677 of 690
Trans # Type Date Num Adj Name Memo Account Debit Credit
1 Deposit 12/31/2017
A
ccount Opening Balance Checking 130,870.25
A
ccount Opening Balance First & Last Name, Capital 130,870.25
130,870.25 130,870.25
7 General Journal 12/31/2017 3
A
ccount Opening Balance Store Equipment & Fixtures Loan 8,000.00
A
ccount Opening Balance First & Last Name, Capital 8,000.00
8,000.00 8,000.00
8 Invoice 12/31/2017 Complete Training, Inc. Opening balance
A
ccounts Receivable 1,400.00
Complete Training, Inc. Opening balance Uncategorized Income 1,400.00
A
A
A
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 678 of 690
A
A
A
A
A
A
A
A
A
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
13 Bill 12/31/2017 Pens Aplenty Opening balance
A
ccounts Payable 500.00
Pens Aplenty Opening balance Uncategorized Expenses 500.00
16 Inventory Adjust 12/31/2017 Paperback Books Opening balance First & Last Name, Capital 180.00
Paperback Books Opening balance Inventory Asset 180.00
180.00 180.00
17 Inventory Adjust 12/31/2017 Pens, etc. Opening balance First & Last Name, Capital 250.00
Pens, etc. Opening balance Inventory Asset 250.00
250.00 250.00
18 Inventory Adjust 12/31/2017 Stationery Opening balance First & Last Name, Capital 225.00
r
Cash Custome
r
Keyboarding Services Keyboarding Services 25.00
Cash Custome
r
Textbooks Book Sales 80.00
Cash Custome
r
Textbooks Inventory Asset 50.00
Cash Custome
r
Textbooks Cost of Goods Sold 50.00
r
r
r
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 679 of 690
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
23 Invoice 01/02/2018 1 Complete Training, Inc.
A
ccounts Receivable 3,078.00
26 Sales Receipt 01/02/2018 2 Cash Custome
r
Undeposited Funds 632.80
Cash Custome
r
Textbooks Book Sales 79.99
Cash Custome
r
Textbooks Inventory Asset 50.00
Cash Custome
r
Textbooks Cost of Goods Sold 50.00
Cash Custome
r
Textbooks Book Sales 95.99
Cash Custome
r
Textbooks Inventory Asset 50.00
Cash Custome
r
Textbooks Cost of Goods Sold 50.00
Cash Custome
r
Textbooks Book Sales 125.00
r
r
r
r
r
r
r
r
29 Invoice 01/02/2018 2 Sacramento Schools
A
ccounts Receivable 280.48
Sacramento Schools Pens, etc. Supplies Sales 224.75
Sacramento Schools Pens, etc. Inventory Asset 125.00
Sacramento Schools Pens, etc. Cost of Goods Sold 125.00
Sacramento Schools Paper Supplies Supplies Sales 34.95
A
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 680 of 690
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
31 Invoice 01/03/2018 3 Slater, Abby
A
ccounts Receivable 87.40
Slater, Abby Pens, etc. Supplies Sales 25.98
Complete Training, Inc.
A
ccounts Receivable 1,400.00
1,400.00 1,400.00
33 Invoice 01/05/2018 4 Gonzalez, Hector
A
ccounts Receivable 270.00
Gonzalez, Hector Textbooks Book Sales 250.00
Gonzalez, Hector Textbooks Inventory Asset 100.00
Gonzalez, Hector Textbooks Cost of Goods Sold 100.00
State Board of Equalization CA Sales Tax Sales Tax Payable 20.00
370.00 370.00
A
A
38 Credit Memo 01/07/2018 5 Slater, Abby
A
ccounts Receivable 28.06
Slater, Abby Pens, etc. Supplies Sales 25.98
Slater, Abby Pens, etc. Inventory Asset 7.59
Slater, Abby Pens, etc. Cost of Goods Sold 7.59
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 681 of 690
Trans # Type Date Num Adj Name Memo Account Debit Credit
39 Invoice 01/07/2018 6 Capitol Schools
A
ccounts Receivable 3,280.35
Capitol Schools Textbooks Book Sales 3,300.00
Capitol Schools Textbooks Inventory Asset 1,500.00
Capitol Schools Textbooks Cost of Goods Sold 1,500.00
Slater, Abby Keyboarding Services Keyboarding Services 75.00
Slater, Abby Paper Supplies Supplies Sales 59.90
Slater, Abby Paper Supplies Inventory Asset 50.00
Slater, Abby Paper Supplies Cost of Goods Sold 50.00
State Board of Equalization CA Sales Tax Sales Tax Payable 4.79
189.69 189.69
42 Bill Pmt -Check 01/08/2018 1 Textbook Co. Opening balance Checking 1,000.00
Textbook Co. Opening balance
A
ccounts Payable 1,000.00
45 Invoice 01/10/2018 8 Sacramento Schools
A
ccounts Receivable 950.40
Sacramento Schools Textbooks Book Sales 880.00
Sacramento Schools Textbooks Inventory Asset 400.00
Sacramento Schools Textbooks Cost of Goods Sold 400.00
State Board of Equalization CA Sales Tax Sales Tax Payable 70.40
A
A
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 682 of 690
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
47 Payment 01/10/2018 Complete Training, Inc. Partial Payment Undeposited Funds 1,000.00
Complete Training, Inc. Partial Payment
A
ccounts Receivable 1,000.00
Cash Custome
r
Paperback Books Book Sales 134.85
Cash Custome
r
Paperback Books Inventory Asset 60.00
Cash Custome
r
Paperback Books Cost of Goods Sold 60.00
Cash Custome
r
Pens, etc. Supplies Sales 71.98
Cash Custome
r
Pens, etc. Inventory Asset 7.59
Cash Custome
r
Pens, etc. Cost of Goods Sold 7.59
State Board of Equalization CA Sales Tax Sales Tax Payable 16.55
290.97 290.97
51 Sales Receipt 01/11/2018 5 Cash Custome
r
Undeposited Funds 88.43
Cash Custome
r
Paper Supplies Supplies Sales 59.90
Cash Custome
r
Paper Supplies Inventory Asset 50.00
Cash Custome
r
Paper Supplies Cost of Goods Sold 50.00
Cash Custome
r
Pens, etc. Supplies Sales 8.99
r
r
r
r
r
A
53 Bill 01/15/2018 Brilliant Gifts
A
ccounts Payable 75.00
Brilliant Gifts Gift Ware Inventory Asset 75.00
75.00 75.00
54 Payment 01/13/2018 1265 Slater, Abby Undeposited Funds 58.15
Slater, Abby
A
ccounts Receivable 58.15
A
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Page 683 of 690
r
r
Trans # Type Date Num Adj Name Memo Account Debit Credit
56 General Journal 01/13/2018 6 Kim, Binh Bounced Check# 915
A
ccounts Receivable 350.00
Kim, Binh Bounced Check# 915 Checking 350.00
Kim, Binh Bounced Check# 915 Returned Check Charges 40.00
State Board of Equalization CA Sales Tax Sales Tax Payable 0.00
40.00 40.00
59 Payment 01/14/2018 10283 Gonzalez, Hector Undeposited Funds 270.00
Gonzalez, Hector
A
ccounts Receivable 270.00
270.00 270.00
60 Payment 01/14/2018 Kim, Binh Undeposited Funds 398.00
Kim, Binh
A
ccounts Receivable 398.00
398.00 398.00
61 Bill 01/14/2018 Supplies Co.
A
ccounts Payable 52.50
Supplies Co. Stationery Inventory Asset 52.50
A
A
A
Slater, Abby Deposit Undeposited Funds 58.15
Gonzalez, Hector Deposit Undeposited Funds 270.00
Slater, Abby Deposit Undeposited Funds 136.90
Cash Custome
r
Deposit Undeposited Funds 223.38
r
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Page 684 of 690
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
66 Bill Pmt -Check 01/15/2018 3 Textbook Co. Checking 2,254.00
70 Credit Memo 01/17/2018 12 Gonzalez, Hector
A
ccounts Receivable 135.00
Gonzalez, Hector Textbooks Book Sales 125.00
Gonzalez, Hector Textbooks Inventory Asset 50.00
Gonzalez, Hector Textbooks Cost of Goods Sold 50.00
State Board of Equalization CA Sales Tax Sales Tax Payable 10.00
A
A
r
r
r
Cash Custome
r
Textbooks Cost of Goods Sold 200.00
Cash Custome
r
Textbooks Book Sales 89.95
Cash Custome
r
Textbooks Inventory Asset 50.00
Cash Custome
r
Textbooks Cost of Goods Sold 50.00
Cash Custome
r
Gift Ware Supplies Sales 15.90
Cash Custome
r
Gift Ware Inventory Asset 5.00
r
A
A
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 685 of 690
A
A
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
75 Bill Pmt -Check 01/20/2018 5 Supplies Co. Checking 14.70
Supplies Co.
A
ccounts Payable 14.70
2,000.00 2,000.00
77 Deposit 01/20/2018 Deposit Checking 1,520.86
Sacramento Schools Deposit Undeposited Funds 931.39
Cash Custome
r
Deposit Undeposited Funds 589.47
1,520.86 1,520.86
78 Invoice 01/21/2018 13 Gonzalez, Hector
A
ccounts Receivable 84.25
Gonzalez, Hector Keyboarding Services Keyboarding Services 40.00
State Board of Equalization CA Sales Tax Sales Tax Payable 3.28
Gonzalez, Hector Pens, etc. Supplies Sales 25.98
A
Slater, Abby Gift Ware Cost of Goods Sold 25.00
Slater, Abby Paperback Books Book Sales 26.97
Slater, Abby Paperback Books Inventory Asset 12.00
Slater, Abby Paperback Books Cost of Goods Sold 12.00
Slater, Abby Pens, etc. Supplies Sales 26.97
Slater, Abby Pens, etc. Inventory Asset 11.38
Slater, Abby Pens, etc. Cost of Goods Sold 11.38
State Board of Equalization CA Sales Tax Sales Tax Payable 12.31
A
A
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Page 686 of 690
A
A
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
83 Payment 01/29/2018 4325 Gonzalez, Hector Undeposited Funds 84.25
Gonzalez, Hector
A
ccounts Receivable 84.25
86 Bill 01/29/2018 Textbook Co.
A
ccounts Payable 80.00
Textbook Co. Paperback Books Inventory Asset 80.00
80.00 80.00
87 Bill 01/29/2018 Brilliant Gifts
A
ccounts Payable 50.00
Brilliant Gifts Gift Ware Inventory Asset 50.00
50.00 50.00
A
89 Deposit 01/30/2018 Deposit Checking 2,162.25
Gonzalez, Hector Deposit Undeposited Funds 84.25
Complete Training, Inc. Deposit Undeposited Funds 2,078.00
2,162.25 2,162.25
A
A
A
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Page 687 of 690
A
A
Trans # Type Date Num Adj Name Memo Account Debit Credit
93 Paycheck 01/31/2018 10 Delgado, Mary Checking 531.15
Delgado, Mary Payroll Expenses 640.00
Delgado, Mary Payroll Liabilities 9.28
Delgado, Mary Payroll Liabilities 9.28
94 Paycheck 01/31/2018 11 Nunez, Sherry Checking 1,801.09
Nunez, Sherry Payroll Expenses 2,139.59
Nunez, Sherry Payroll Expenses 27.08
Nunez, Sherry Payroll Liabilities 30.00
Nunez, Sherry Payroll Liabilities 30.00
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 688 of 690
Trans # Type Date Num Adj Name Memo Account Debit Credit
95 Paycheck 01/31/2018 12 Peterson, Devon Checking 1,374.68
Peterson, Devon Payroll Expenses 1,440.00
Peterson, Devon Payroll Expenses 45.00
Peterson, Devon Payroll Expenses 0.00
Peterson, Devon Payroll Liabilities 101.99
Peterson, Devon Payroll Expenses 23.85
Peterson, Devon Payroll Liabilities 23.85
Peterson, Devon Payroll Liabilities 23.85
Peterson, Devon Payroll Expenses 9.87
Peterson, Devon Payroll Liabilities 9.87
Employment Development Department 999-9999-9 Payroll Liabilities 35.52
Employment Development Department 999-9999-9 Payroll Liabilities 3.56
Employment Development Department 999-9999-9 Payroll Liabilities 120.76
Employment Development Department 999-9999-9 Payroll Liabilities 85.95
United States Treasury 46-6521446 Payroll Liabilities 238.53
United States Treasury 46-6521446 Payroll Liabilities 64.55
United States Treasury 46-6521446 Payroll Liabilities 64.55
United States Treasury 46-6521446 Payroll Liabilities 0.00
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Page 689 of 690
Trans # Type Date Num Adj Name Memo Account Debit Credit
102 General Journal 01/31/2018 10 *
A
djusting Entry Fire Insurance 50.00
*
A
djusting Entry Liability Insurance 50.00
*
A
djusting Entry Prepaid Insurance 100.00
147.36 147.36
105 Check 01/31/2018 Service Charge Checking 15.00
Service Charge Bank Service Charges 15.00
15.00 15.00
Your Name’s Madison Avenue Books
Journal
December 31, 2017 through January 31, 2018
Practice Set 3, Document 98
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 690 of 690
A
A
A
A