Homework answers / question archive / Computerized Accounting with QuickBooks (B10680) Final Exam — Page 2 of 11 SD38: Sales Receipt #37 Dated February 26, 2019 To Cash Sales customers Payment Method: Cash 3 Clothing style consultations $190

Computerized Accounting with QuickBooks (B10680) Final Exam — Page 2 of 11 SD38: Sales Receipt #37 Dated February 26, 2019 To Cash Sales customers Payment Method: Cash 3 Clothing style consultations $190

Accounting

Share With

---

Computerized Accounting with QuickBooks (B10680) Final Exam — Page 2 of 11

SD38: Sales Receipt #37 Dated February 26, 2019
To Cash Sales customers
Payment Method: Cash

3 Clothing style consultations $190.00 each $570.00
2 Hair consultations 150.00 each 300.00
4 Makeup consultations 120.00 each 480.00
1 Makeovers 390.00 each 390.00
3 Reports 90.00 each 270.00

HST 13% 261.30
Sales receipt total cash held for deposit $2,271.30

Use the memorized transaction.

SD39: Memo #9 Dated February 28, 2019
From Partners: Deposit all cheques and cash held for weekly deposit to Bank Chequing
account. Total deposit is $2,898.45.

SD40: Memo #10 Dated February 28, 2019
From Partners: Complete adjusting entries for one month of depreciation:

Computer equipment $280.00
Salon 830.00
Salon Equipment 45.00
Salon Furniture 185.00

SD41: Memo #11 Dated February 28, 2019

From Partners: Complete adjusting entries for supplies used during February:
Cosmetics supplies $340.00
Hair care supplies 112.00
Office and computer supplies 59.00

SD42: Memo #12 Dated February 28, 2019
From Partners: Complete adjusting entry for prepaid expenses expired:

Insurance $1,050.00

SD43: Bank Debit Memo DM-58284 Dated February 28, 2019
From Capital Bank: Authorized withdrawals from Bank Chequing account for service
charges and loan payments. Create a new Expense account: Bank Charges.

Monthly Bank Service Charges $42.00
Mortgage ($1,000 principal; $150 interest) 1,150.00
Long-Term Loan ($700 principal; $200 interest) 900.00
SD44: Bank Credit Memo CM-204552 Dated February 28, 2019
From Capital Bank: Interest earned on bank deposits.
Chequing account $10.00
Savings account 29.00
© 2018 January 8, 2018

SD44: Bank Credit Memo CM-204552 Dated February 28, 2019
From Capital Bank: Interest earned on bank deposits.
Chequing account $10.00
Savings account 29.00
© 2018 January 8, 2018
Computerized Accounting with QuickBooks (B10680) Final Exam — Page 3 of 11
2. Print the Trial Balance as of February 28, 2019
3. Print the Journal from February | to February 28, 2019
4. Print the Profit and Loss Standard from February | to February 28, 2019
5. Print the A/R Aging Detail Report at February 28, 2019
6. Print the A/P Aging Detail Report at February 28, 2019

Computerized Accounting with QuickBooks (B10680) Final Exam — Page 1 of 11

SD29: Sales Receipt #36 Dated February 19, 2019
To Cash Sales customers

Payment Method: Cash
8 Clothing style consultations $190.00 each $1,520.00
6 Hair consultations 150.00 each 900.00
9 Makeup consultations 120.00 each 1,080.00
2 Makeovers 390.00 each 780.00
7 Reports 90.00 each 630.00
HST 13% 638.30
Sales receipt total cash held for deposit $5,548.30
Use the memorized transaction.

SD30: Pay Bill Dated February 21, 2019
To Keep It Clean, $339.00 in payment of account. Reference Bills #KC-701 and #KC-
724. Cheque #250.

SD31: Pay Bill Dated February 21, 2019
To Office Outfitters, $587.60 in payment of account. Reference Bill 400-520. Cheque
#251,

SD32: Invoice Dated February 21, 2019
Invoice #3123 to Jammers, $250.00 plus $32.50 HST for a customized seminar for
executives on how to dress to make a good first impression. Invoice totals $282.50.
Terms Net 15 days.

SD33: Memo #6 Dated February 21, 2019
From Partners: Cheque #249 to Crystal Wireless was entered incorrectly. The actual
amount of the bill was $172.00 plus $22.36 HST. The bill totalled $194.36. Edit the
Cheque to make the correction.

SD34: Memo #7 Dated February 21, 2019
From Partners: Print customer Invoices #3122 and #3123.

SD35: Memo #8 Dated February 21, 2019
From Partners: Deposit all cheques and cash held for weekly deposit to Bank Chequing
account. Total deposit is $15,258.60.

SD36: Pay Bill Dated February 24, 2019
To Direct Marketing, $226.00 in payment of account. Reference Bill ##DM-55. Cheque
#252.

SD37: Customer Payment Dated February 25, 2019
From OTV News, cheque #353 for $627.15 in payment of account. Reference Invoice
#3121. Cheque held for deposit.

© 2018 January 8, 2018

Computerized Accounting with QuickBooks (B10680) Final Exam — Page 2 of 11

SD38: Sales Receipt #37 Dated February 26, 2019
To Cash Sales customers
Payment Method: Cash

3 Clothing style consultations $190.00 each $570.00
2 Hair consultations 150.00 each 300.00
4 Makeup consultations 120.00 each 480.00
1 Makeovers 390.00 each 390.00
3 Reports 90.00 each 270.00

HST 13% 261.30
Sales receipt total cash held for deposit $2,271.30

Use the memorized transaction.

SD39: Memo #9 Dated February 28, 2019
From Partners: Deposit all cheques and cash held for weekly deposit to Bank Chequing
account. Total deposit is $2,898.45.

SD40: Memo #10 Dated February 28, 2019
From Partners: Complete adjusting entries for one month of depreciation:

Computer equipment $280.00
Salon 830.00
Salon Equipment 45.00
Salon Furniture 185.00

SD41: Memo #11 Dated February 28, 2019

From Partners: Complete adjusting entries for supplies used during February:
Cosmetics supplies $340.00
Hair care supplies 112.00
Office and computer supplies 59.00

SD42: Memo #12 Dated February 28, 2019
From Partners: Complete adjusting entry for prepaid expenses expired:

Insurance $1,050.00

SD43: Bank Debit Memo DM-58284 Dated February 28, 2019
From Capital Bank: Authorized withdrawals from Bank Chequing account for service
charges and loan payments. Create a new Expense account: Bank Charges.

Monthly Bank Service Charges $42.00
Mortgage ($1,000 principal; $150 interest) 1,150.00
Long-Term Loan ($700 principal; $200 interest) 900.00
SD44: Bank Credit Memo CM-204552 Dated February 28, 2019
From Capital Bank: Interest earned on bank deposits.
Chequing account $10.00
Savings account 29.00
© 2018 January 8, 2018

Computerized Accounting with QuickBooks (B10680) Final Exam — Page 3 of 11

SD23: Bill Dated February 14, 2019
Bill #DM-55 received from Direct Marketing (Setup new vendor), $200.00 plus $26.00
HST for an internet marketing campaign. The bill totals $226.00. Terms Net 20 days.
Direct Marketing Fax: (613) 753-0962
2753 Telegraph Rd Email: dchatter@dmnow.com
Ottawa ON K3Y 486 Terms: Net 10
Contact: Dean Chatter Credit Limit: $2,000
Phone: (613) 753-9135 Business Number: 289 532 733

SD24: Bill Dated February 15, 2019
Bill #F-5043 received from Faces, Inc., $660.00 plus $85.80 HST for cosmetics supplies.
The bill totals $745.80. Terms Net 30 days.

SD25: Bill Dated February 17, 2019
Bill #KC-798 received from Keep It Clean, $150.00 plus $19.50 HST for weekly
cleaning of salon. The bill totals $169.50. Terms Net 15 days. Use memorized
transaction.

SD26: Invoice Dated February 18, 2019
Invoice #3122 to Hannah Harris (QuickAdd the new customer), makeup and hair
consultations for the “Mom’s Day Out” group event.

6 Hair consultations 150.00 each 900.00
6 Makeup consultations 120.00 each 720.00
6 Reports 90.00 each 540.00
HST 13% 280.80
Invoice Total $2,440.80
Terms Net 15 days

SD27: Customer Payment Dated February 19, 2019
From Reality Unlimited, cheque #623 for $7,571.00 in payment of account. Reference
Invoice #3119. Cheque held for deposit.

SD28: Write Cheque Dated February 19, 2019
To pay for cash purchase received with Bill #CW-214 from Crystal Wireless for $180.00
plus $23.40 HST for a monthly telephone, internet and cell phone service. The bill total
of $203.40 is paid in full with Cheque #249.

Computerized Accounting with QuickBooks (B10680) Final Exam — Page 1 of 11

SD7: Pay Bill Dated February 4, 2019
To Faces Inc., $805.00 in payment of account. Reference Bill #F-4910. Cheque #246.

SD8: Sales Receipt #34 Dated February 5, 2019
To Cash Sales customers Payment Method: Cash

6 Clothing style consultations $190.00 each $1,140.00
3 Hair consultations 150.00 each 450.00
8 Makeup consultations 120.00 each 960.00
3 Makeovers 390.00 each 1,170.00
5 Reports 90.00 each 450.00

HST 13% 542.10
Sales receipt total cash held for deposit $4,712.10

Memorize the transaction with weekly reminders starting February 12.

SD9: Memo #1 Dated February 5, 2019
From Partners: Deposit all cheques and cash held for weekly deposit to the Bank
Chequing account. Total deposit is $5,910.50.

SD10: Bank Debit Memo #CB-4732 Dated February 6, 2019
From Capital Bank: Cheque #454 for $588.50 from AIM International for invoice #3084
was returned as NSF. The bank charged $25.00 as an NSF fee. Create invoice #3120 to
record the returned cheque and NSF charges. No taxes are charged on these amounts.
Invoice total $613.50. Terms: Due on Receipt. Update customer record with new terms.

SD11: Customer Payment Dated February 8, 2019
From ODSB, cheque #2031 for $800.00 in payment of account. Reference Invoice
#3101. Cheque held for deposit.

SD12: Write Cheque Dated February 8, 2019
To pay for cash purchase received with Bill #SU-3462 from Spaces-R-Us (use QuickAdd
for the new Vendor) for $250.00 plus $32.50 HST for a storage unit to hold extra salon
equipment. The bill total of $282.50 is paid in full with Cheque #247. (Create new
expense account Storage Fees).

SD13: Memo #2 Dated February 9, 2019
From Partners: Print customer Invoices #3119 and 3120 (or save as pdf as directed by
instructor).

SD14: Bill Dated February 10, 2019
Bill #KC-724 received from Keep It Clean, $150.00 plus $19.50 HST for weekly
cleaning of salon. The bill totals $169.50. Terms Net 15 days. Use memorized
transaction.