1. Using the Malin's Makeovers QuickBooks data file (Malin.qbw or Malin), record entries for the source...

             

Transcribed Image Text:

1. Using the Malin's Makeovers QuickBooks data file (Malin.qbw or Malin), record entries for the source documents for February. If you have completed the source documents using this company in the text or the Additional Transactions exercise, please recopy the data file from the student data on the DVD before starting, or ask your instructor for fresh copy. SD1: Bill Dated February 1, 2019 Bill #00-520 received from Office Outfitters, $520.00 plus $67.60 HST for paper, printer cartridges and other office supplies. The bill totals $587.60. Terms Net 20 days. Dated February 2, 2019 SD2: Customer Payment From AIM International, cheque # 454 for $588.50 in payment of account. Reference Invoice #3084. Cheque held for deposit. SD3: Customer Payment From Jammers, cheque # 793 for $609.90 in payment of account. Reference Invoice # 3092. Cheque held for deposit Dated February 3, 2019 SD4: Bill Dated February 3, 2019 Bill #KC-701 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. Memorize the transaction with weekly reminders starting February 10. SD5: Pay Bill Dated February 4, 2019 To Keep It Clean, $321.00 in payment of account. Reference Bills # KC-662 and KC-688. Cheque # 245. SD6: Invoice Dated February 4, 2019 Invoice # 3119 to Reality Unlimited (Use Set up for the new customer) for contestants on their new dating show SD6: Invoice Dated February 4, 2019 Invoice # 3119 to Reality Unlimited (Use Set up for the new customer) for contestants on their new dating show 10 Clothing style consultations 10 Makeovers 10 Reports HST 13% Invoice Total Terms: Net 15 days Reality Unlimited 783-C Burbank Drive Ottawa ON K6T 1P4 Contact: Guy Smiley Phone: (613) 753-2873 Fax: (613) 753-4834 $190.00 each 390.00 each 90.00 each $1,900.00 3,900.00 900.00 871.00 $7.571.00 Email: hostguy@realityu.ca Tax Code: HST Terms Net 15 Credit Limit: $10,000 Pay by: Cheque 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 To Cash Sales customers 6 Clothing style consultations 3 Hair consultations 8 Makeup consultations 3 Makeovers 5 Reports $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each Dated February 5, 2019 Payment Method: Cash $1,140.00 450.00 960.00 1,170.00 450.00 542.10 $4.712.10 HST 13% Sales receipt total cash held for deposit Memorize the transaction with weekly reminders starting February 12. SD9: Memo #1 From Partners: Deposit all cheques and cash held for weekly deposit to the Bank Chequing account. Total deposit is $5,910.50. Dated February 5, 2019 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). Dated February 10, 2019 SD14: Bill 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. SD15: Invoice Dated February 12, 2019 Invoice # 3121 to OTV News, $555.00 plus $72.15 HST for 2 customized seminars for sales representatives on finding their best look. Invoice totals $627.15. Terms Net 15 days. SD16: Memo #3 From Partners: Print customer Invoice # 3121. SD17: Memo #4 Dated February 12, 2019 From Partners: The payment from ODSB was entered incorrectly. The actual amount of the payment was $856.00. Edit the customer payment to make the correction. SD18: Pay Bill Dated February 12, 2019 To Office Outfitters, $1,380.00 in payment of account. Reference Bill #00-500. Cheque # 248. SD19: Sales Receipt # 35 To Cash Sales customers Payment Method: Cash 4 Clothing style consultations 5 Hair consultations 5 Makeup consultations 2 Makeovers 3 Reports Dated February 12, 2019 $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each HST 13% Sales receipt total cash held for deposit Use the memorized transaction. Dated February 12, 2019 $760.00 750.00 600.00 780.00 270.00 410.80 $3.570.80 SD20: Customer Payment Dated February 12, 2019 From AIM International, cheque # 497 for $1,790.50 in payment of account and NSF charges. Reference invoices # 3118 and #3120. Cheque held for deposit. Dated February 12, 2019 SD21: Memo #5 From Partners: Deposit all cheques and cash held for weekly deposit to the Bank Chequing account. Total deposit is $6,217.30. SD22: Customer Payment Dated February 13, 2019 From OTV News, cheque #8125 for $2,139.30 in payment of account. Reference Invoice # 3097. Cheque held for deposit. 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 2753 Telegraph Rd Ottawa ON K3Y 4S6 Contact: Dean Chatter Phone: (613) 753-9135 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 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. Fax: (613) 753-0962 Email: dchatter @dmnow.com Terms: Net 10 Credit Limit: $2,000 Business Number: 289 532 733 HST 13% Invoice Total Dated February 17, 2019 SD26: Invoice 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 120.00 each 6 Makeup consultations 6 Reports 90.00 each Terms Net 15 days Dated February 18, 2019 900.00 720.00 540.00 280.80 $2,440.80 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. SD29: Sales Receipt # 36 To Cash Sales customers Payment Method: Cash 8 Clothing style consultations 6 Hair consultations 9 Makeup consultations 2 Makeovers 7 Reports $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each HST 13% Sales receipt total cash held for deposit Use the memorized transaction. Dated February 19, 2019 $1,520.00 900.00 1,080.00 780.00 630.00 638.30 $5.548.30 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 #00-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 From Partners: Print customer Invoices #3122 and #3123. Dated February 21, 2019 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. SD38: Sales Receipt # 37 To Cash Sales customers Payment Method: Cash 3 Clothing style consultations 2 Hair consultations 4 Makeup consultations 1 Makeovers 3 Reports HST 13% Sales receipt total cash held for deposit Use the memorized transaction. $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each Dated February 26, 2019 Salon Salon Equipment Salon Furniture $570.00 300.00 480.00 390.00 270.00 261.30 $2,271.30 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 From Partners: Complete adjusting entries for one month of depreciation: Computer equipment $280.00 830.00 45.00 185.00 Dated February 28, 2019 SD41: Memo #11 From Partners: Complete adjusting entries for supplies used during February: Cosmetics supplies Hair care supplies Office and computer supplies SD42: Memo # 12 Mortgage ($1,000 principal; $150 interest) Long-Term Loan ($700 principal; $200 interest) Dated February 28, 2019 From Partners: Complete adjusting entry for prepaid expenses expired: Insurance $1,050.00 SD44: Bank Credit Memo CM-204552 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 1,150.00 900.00 From Capital Bank: Interest earned on bank deposits. $340.00 112.00 59.00 Chequing account Savings account Dated February 28, 2019 Dated February 28, 2019 $10.00 29.00 2. Print the Trial Balance as of February 28, 2019 3. Print the Journal from February 1 to February 28, 2019 4. Print the Profit and Loss Standard from February 1 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 1. Using the Malin's Makeovers QuickBooks data file (Malin.qbw or Malin), record entries for the source documents for February. If you have completed the source documents using this company in the text or the Additional Transactions exercise, please recopy the data file from the student data on the DVD before starting, or ask your instructor for fresh copy. SD1: Bill Dated February 1, 2019 Bill #00-520 received from Office Outfitters, $520.00 plus $67.60 HST for paper, printer cartridges and other office supplies. The bill totals $587.60. Terms Net 20 days. Dated February 2, 2019 SD2: Customer Payment From AIM International, cheque # 454 for $588.50 in payment of account. Reference Invoice #3084. Cheque held for deposit. SD3: Customer Payment From Jammers, cheque # 793 for $609.90 in payment of account. Reference Invoice # 3092. Cheque held for deposit Dated February 3, 2019 SD4: Bill Dated February 3, 2019 Bill #KC-701 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. Memorize the transaction with weekly reminders starting February 10. SD5: Pay Bill Dated February 4, 2019 To Keep It Clean, $321.00 in payment of account. Reference Bills # KC-662 and KC-688. Cheque # 245. SD6: Invoice Dated February 4, 2019 Invoice # 3119 to Reality Unlimited (Use Set up for the new customer) for contestants on their new dating show SD6: Invoice Dated February 4, 2019 Invoice # 3119 to Reality Unlimited (Use Set up for the new customer) for contestants on their new dating show 10 Clothing style consultations 10 Makeovers 10 Reports HST 13% Invoice Total Terms: Net 15 days Reality Unlimited 783-C Burbank Drive Ottawa ON K6T 1P4 Contact: Guy Smiley Phone: (613) 753-2873 Fax: (613) 753-4834 $190.00 each 390.00 each 90.00 each $1,900.00 3,900.00 900.00 871.00 $7.571.00 Email: hostguy@realityu.ca Tax Code: HST Terms Net 15 Credit Limit: $10,000 Pay by: Cheque 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 To Cash Sales customers 6 Clothing style consultations 3 Hair consultations 8 Makeup consultations 3 Makeovers 5 Reports $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each Dated February 5, 2019 Payment Method: Cash $1,140.00 450.00 960.00 1,170.00 450.00 542.10 $4.712.10 HST 13% Sales receipt total cash held for deposit Memorize the transaction with weekly reminders starting February 12. SD9: Memo #1 From Partners: Deposit all cheques and cash held for weekly deposit to the Bank Chequing account. Total deposit is $5,910.50. Dated February 5, 2019 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). Dated February 10, 2019 SD14: Bill 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. SD15: Invoice Dated February 12, 2019 Invoice # 3121 to OTV News, $555.00 plus $72.15 HST for 2 customized seminars for sales representatives on finding their best look. Invoice totals $627.15. Terms Net 15 days. SD16: Memo #3 From Partners: Print customer Invoice # 3121. SD17: Memo #4 Dated February 12, 2019 From Partners: The payment from ODSB was entered incorrectly. The actual amount of the payment was $856.00. Edit the customer payment to make the correction. SD18: Pay Bill Dated February 12, 2019 To Office Outfitters, $1,380.00 in payment of account. Reference Bill #00-500. Cheque # 248. SD19: Sales Receipt # 35 To Cash Sales customers Payment Method: Cash 4 Clothing style consultations 5 Hair consultations 5 Makeup consultations 2 Makeovers 3 Reports Dated February 12, 2019 $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each HST 13% Sales receipt total cash held for deposit Use the memorized transaction. Dated February 12, 2019 $760.00 750.00 600.00 780.00 270.00 410.80 $3.570.80 SD20: Customer Payment Dated February 12, 2019 From AIM International, cheque # 497 for $1,790.50 in payment of account and NSF charges. Reference invoices # 3118 and #3120. Cheque held for deposit. Dated February 12, 2019 SD21: Memo #5 From Partners: Deposit all cheques and cash held for weekly deposit to the Bank Chequing account. Total deposit is $6,217.30. SD22: Customer Payment Dated February 13, 2019 From OTV News, cheque #8125 for $2,139.30 in payment of account. Reference Invoice # 3097. Cheque held for deposit. 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 2753 Telegraph Rd Ottawa ON K3Y 4S6 Contact: Dean Chatter Phone: (613) 753-9135 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 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. Fax: (613) 753-0962 Email: dchatter @dmnow.com Terms: Net 10 Credit Limit: $2,000 Business Number: 289 532 733 HST 13% Invoice Total Dated February 17, 2019 SD26: Invoice 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 120.00 each 6 Makeup consultations 6 Reports 90.00 each Terms Net 15 days Dated February 18, 2019 900.00 720.00 540.00 280.80 $2,440.80 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. SD29: Sales Receipt # 36 To Cash Sales customers Payment Method: Cash 8 Clothing style consultations 6 Hair consultations 9 Makeup consultations 2 Makeovers 7 Reports $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each HST 13% Sales receipt total cash held for deposit Use the memorized transaction. Dated February 19, 2019 $1,520.00 900.00 1,080.00 780.00 630.00 638.30 $5.548.30 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 #00-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 From Partners: Print customer Invoices #3122 and #3123. Dated February 21, 2019 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. SD38: Sales Receipt # 37 To Cash Sales customers Payment Method: Cash 3 Clothing style consultations 2 Hair consultations 4 Makeup consultations 1 Makeovers 3 Reports HST 13% Sales receipt total cash held for deposit Use the memorized transaction. $190.00 each 150.00 each 120.00 each 390.00 each 90.00 each Dated February 26, 2019 Salon Salon Equipment Salon Furniture $570.00 300.00 480.00 390.00 270.00 261.30 $2,271.30 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 From Partners: Complete adjusting entries for one month of depreciation: Computer equipment $280.00 830.00 45.00 185.00 Dated February 28, 2019 SD41: Memo #11 From Partners: Complete adjusting entries for supplies used during February: Cosmetics supplies Hair care supplies Office and computer supplies SD42: Memo # 12 Mortgage ($1,000 principal; $150 interest) Long-Term Loan ($700 principal; $200 interest) Dated February 28, 2019 From Partners: Complete adjusting entry for prepaid expenses expired: Insurance $1,050.00 SD44: Bank Credit Memo CM-204552 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 1,150.00 900.00 From Capital Bank: Interest earned on bank deposits. $340.00 112.00 59.00 Chequing account Savings account Dated February 28, 2019 Dated February 28, 2019 $10.00 29.00 2. Print the Trial Balance as of February 28, 2019 3. Print the Journal from February 1 to February 28, 2019 4. Print the Profit and Loss Standard from February 1 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

Answer rating: 100% (QA)

Worksheet Trial Balance as of February 28 2019 Account Name Debit Credit Cash 1525860 Accounts Recei... View the full answer