Bill
Vendor
Brilliant Gifts
125 Oak Street
Sacramento, CA 95814
Bill Due 02/28/2018
Terms Net 30
Memo
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Date
01/29/2018
Ref. No.
Items
Item Description Qty Cost Amount Customer:Job
Practice Set 3, Document 78
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 656 of 690
INVOICE
Date
1/29/2018
Invoice #
15
Bill To
Complete Training, Inc.
212 Harvard Street
Sacramento, CA 95815
Ship To
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
S.O. No.
3
P.O. No. Terms
Net 30
Project
Item Description Invoiced Rate AmountBackor…Ordered Prev. Inv…
Page 657 of 690
Practice Set 3, Document 79
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 658 of 690
Practice Set 3, Document 80
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
1/30/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
1/30/2018
Supplies Co.
95 8th Street
Sacramento, CA 95814
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Practice Set 3, Document 81
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 659 of 690
1/30/2018
CA Utilities & Telephone
8905 Richmond
Sacramento, CA 95825
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Practice Set 3, Document 82
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 660 of 690
1/31/2018
Mary Delgado
4811 Wheat Street
Sacramento, CA 95821
Pay Period: 01/01/2018 – 01/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Practice Set 3, Document 83
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Employee SSN Status (Fed/State)
A
llowances/Extra
Employee SSN Status (Fed/State)
A
llowances/Extra
Mary Delgado, 4811 Wheat Street, Sacramento, CA 95821 ***-**-3699 Single/Single Fed-0/0/CA-0/0
Mary Delgado, 4811 Wheat Street, Sacramento, CA 95821 ***-**-3699 Single/Single Fed-0/0/CA-0/0
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Earnings and Hours Hours Rate Current YTD Amount
Earnings and Hours Hours Rate Current YTD Amount
Hourly 80:00 8.00 640.00 640.00
Hourly 80:00 8.00 640.00 640.00
Taxes Current YTD Amount
Taxes Current YTD Amount
Page 661 of 690
1/31/2018
Sherry Nunez
3763 Lily Street
Sacramento, CA 95838
Pay Period: 01/01/2018 – 01/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Practice Set 3, Document 83
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Employee SSN Status (Fed/State)
A
llowances/Extra
Employee SSN Status (Fed/State)
A
llowances/Extra
Sherry Nunez, 3763 Lily Street, Sacramento, CA 95838 ***-**-5244 Single/Single Fed-0/0/CA-0
Sherry Nunez, 3763 Lily Street, Sacramento, CA 95838 ***-**-5244 Single/Single Fed-0/0/CA-0
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Earnings and Hours Qty Rate Current YTD Amount
Earnings and Hours Qty Rate Current YTD Amount
Taxes Current YTD Amount
Taxes Current YTD Amount
Medicare Employee Addl Tax 0.00
Medicare Employee Addl Tax 0.00
Federal Withholding -126.90 -126.90
Federal Withholding -126.90 -126.90
Paid Time Off Earned YTD Used Available
Paid Time Off Earned YTD Used Available
Page 662 of 690
1/31/2018
**1,407.58
One Thousand Four Hundred Seven and 58/100***********************************************************************
*
Devon Peterson
Devon Peterson
383 Oak Avenue
Sacramento, CA 95814
Pay Period: 01/01/2018 – 01/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Employee SSN Status (Fed/State)
A
llowances/Extra
Employee SSN Status (Fed/State)
A
llowances/Extra
Devon Peterson, 383 Oak Avenue, Sacramento, CA 95814 ***-**-6886 Married/Married (one income) Fed-1/0/CA-1
Devon Peterson, 383 Oak Avenue, Sacramento, CA 95814 ***-**-6886 Married/Married (one income) Fed-1/0/CA-1
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Earnings and Hours Hours Rate Current YTD Amount
Earnings and Hours Hours Rate Current YTD Amount
163:00 1,645.00 1,645.00
Taxes Current YTD Amount
Taxes Current YTD Amount
Medicare Employee Addl Tax 0.00
Medicare Employee Addl Tax 0.00
Federal Withholding -65.53 -65.53
Federal Withholding -65.53 -65.53
Social Security Employee -69.09 -69.09
Page 663 of 690
Practice Set 3, Document 83
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
1/31/2018
Mary Delgado
4811 Wheat Street
Sacramento, CA 95821
Pay Period: 01/01/2018 – 01/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Practice Set 3, Document 84
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Employee SSN Status (Fed/State)
A
llowances/Extra
Employee SSN Status (Fed/State)
A
llowances/Extra
Mary Delgado, 4811 Wheat Street, Sacramento, CA 95821 ***-**-3699 Single/Single Fed-0/0/CA-0/0
Mary Delgado, 4811 Wheat Street, Sacramento, CA 95821 ***-**-3699 Single/Single Fed-0/0/CA-0/0
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Earnings and Hours Hours Rate Current YTD Amount
Earnings and Hours Hours Rate Current YTD Amount
Hourly 80:00 8.00 640.00 640.00
Taxes Current YTD Amount
Taxes Current YTD Amount
Medicare Employee Addl Tax 0.00
Medicare Employee Addl Tax 0.00
Federal Withholding -46.10 -46.10
Federal Withholding -46.10 -46.10
Social Security Employee -39.68 -39.68
Page 664 of 690
1/31/2018
Sherry Nunez
3763 Lily Street
Sacramento, CA 95838
Pay Period: 01/01/2018 – 01/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Employee SSN Status (Fed/State)
A
llowances/Extra
Employee SSN Status (Fed/State)
A
llowances/Extra
Sherry Nunez, 3763 Lily Street, Sacramento, CA 95838 ***-**-5244 Single/Single Fed-0/0/CA-0
Sherry Nunez, 3763 Lily Street, Sacramento, CA 95838 ***-**-5244 Single/Single Fed-0/0/CA-0
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Earnings and Hours Qty Rate Current YTD Amount
Earnings and Hours Qty Rate Current YTD Amount
Taxes Current YTD Amount
Taxes Current YTD Amount
Medicare Employee Addl Tax 0.00
Medicare Employee Addl Tax 0.00
Federal Withholding -126.90 -126.90
Federal Withholding -126.90 -126.90
Social Security Employee -78.53 -78.53
djustments to Net Pay Current YTD Amount
Paid Time Off Earned YTD Used Available
Paid Time Off Earned YTD Used Available
Sick 0:00 40:00
Practice Set 3, Document 85
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 665 of 690
1/31/2018
Devon Peterson
383 Oak Avenue
Sacramento, CA 95814
Pay Period: 01/01/2018 – 01/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Your Name’s Madison Avenue Books, 4748 Madison Avenue, Sacramento, CA 95841
Employee SSN Status (Fed/State)
A
llowances/Extra
Employee SSN Status (Fed/State)
A
llowances/Extra
Devon Peterson, 383 Oak Avenue, Sacramento, CA 95814 ***-**-6886 Married/Married (one income) Fed-1/0/CA-1
Devon Peterson, 383 Oak Avenue, Sacramento, CA 95814 ***-**-6886 Married/Married (one income) Fed-1/0/CA-1
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Pay Period: 01/01/2018 – 01/31/2018 Pay Date: 01/31/2018
Earnings and Hours Hours Rate Current YTD Amount
Earnings and Hours Hours Rate Current YTD Amount
Taxes Current YTD Amount
Taxes Current YTD Amount
Medicare Employee Addl Tax 0.00
Medicare Employee Addl Tax 0.00
Federal Withholding -65.53 -65.53
Federal Withholding -65.53 -65.53
Social Security Employee -101.99 -101.99
djustments to Net Pay Current YTD Amount
djustments to Net Pay Current YTD Amount
Dental Insurance (taxable) -20.00 -20.00
Health Insurance (taxable) -20.00 -20.00
-40.00 -40.00
Net Pay 1,374.68 1,374.68
Practice Set 3, Document 86
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 666 of 690
Delgado, Mary Nunez, Sherry Peterson, Devon TOTAL
Hours Rate Jan 18 Hours Rate Jan 18 Hours Rate Jan 18 Hours Rate Jan 18
Employee Wages, Taxes and Adjustments
Gross Pay
Salary 0.00 158 2,139.59 0.00 158.00 2,139.59
Taxes Withheld
Federal Withholding -46.10 -126.90 -65.53 -238.53
Total Taxes Withheld -108.85 -305.58 -230.32 -644.75
Deductions from Net Pay
Employer Taxes and Contributions
Y
our Name’s Madison Avenue Books
Payroll Summary
January 2018
Practice Set 3, Document 87
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 667 of 690
BALANCE
Payroll Liabilities
Federal Withholding 238.53
Y
our Name’s Madison Avenue Books
Payroll Liability Balances
January 2018
Practice Set 3, Document 88
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 668 of 690
1/31/2018
Employment Development Department
1037 California Street
Sacramento, CA 95814
999-9999-9
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
1/31/2018
Insurance, Inc.
20865 Oak Street
San Francisco, CA 94101
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
1/31/2018
46-6521446
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Practice Set 3, Document 89
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 669 of 690
Sales Tax Payable
Total Sales Non-Taxable Sales Taxable Sales Tax Rate Tax Collected As of Jan 31, 18
Y
our Name’s Madison Avenue Books
Sales Tax Liability
January 2018
Page 1
Practice Set 3, Document 90
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 670 of 690
1/31/2018
Your Name’s Madison Avenue Books
4748 Madison Avenue
Sacramento, CA 95841
Practice Set 3, Document 91
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 671 of 690
Jan 18
Qty Amount % of Sales Avg Price COGS Avg COGS Gross Margin Gross Margin %
Inventory
Gift Ware 6 115.85 0.5% 19.31 30.00 5.00 85.85 74.1%
Service
Keyboarding 29 148.00 0.7% 5.10
Y
our Name’s Madison Avenue Books
Sales by Item Summary
January 2018
Practice Set 3, Document 92
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 672 of 690
Jan 31, 18
Debit Credit
Checking 124,984.69
Payroll Liabilities 0.00
Sales Tax Payable 0.00
Y
our Name’s Madison Avenue Books
Trial Balance
As of January 31, 2018
Practice Set 3, Document 93
Copyright © 2019 Pearson Education, Inc. All Rights Reserved
Page 673 of 690