Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Using the Malin's Makeovers QuickBooks data file (Malin.qbw or Malin), record entries for the source documents for February. This company has been used before,
1. Using the Malin's Makeovers QuickBooks data file (Malin.qbw or Malin), record entries for the source documents for February. This company has been used before, but you need to use the copy of the data file provided here or you will not have the correct answers. Click the Malin.QBW link below to download the file. Malin.QBW SD1: Bill Dated February 1, 2021 Bill \#OO-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. SD2: Customer Payment Dated February 2, 2021 From AIM International, cheque \#454 for \$588.50 in payment of account. Reference Invoice \#3084. Cheque held for deposit. SD3: Customer Payment Dated February 3, 2021 From Jammers, cheque #793 for $609.90 in payment of account. Reference Invoice \#3092. Cheque held for deposit SD4: Bill Dated February 3, 2021 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, 2021 To Keep It Clean, $321.00 in payment of account. Reference Bills \#KC-662 and KC-688. Cheque \#245. SD6: Invoice Dated February 4, 2021 Invoice \#3119 to Reality Unlimited (Use Set up for the new customer) for contestants on their new dating show SD7: Pay Bill Dated February 4, 2021 To Faces Inc., $805.00 in payment of account. Reference Bill \#F-4910. Cheque \#246. SD8: Sales Receipt \#34 Dated February 5, 2021 To Cash Sales customers Payment Method: Cash Memorize the transaction with weekly reminders starting February 12. SD9: Memo \#1 Dated February 5, 2021 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, 2021 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, 2021 From ODSB, cheque \#2031 for $800.00 in payment of account. Reference Invoice \#3101. Cheque held for deposit. SD12: Write Cheque Dated February 8, 2021 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, 2021 From Partners: Open customer Invoices \#3119 and 3120 and save as pdf as directed by instructor. SD14: Bill Dated February 10, 2021 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, 2021 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 Dated February 12, 2021 From Partners: Open customer Invoice \#3121 and save as pdf SD17: Memo \#4 Dated February 12, 2021 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, 2021 To Office Outfitters, $1,380.00 in payment of account. Reference Bill \#OO-500. Cheque \#248. SD19: Sales Receipt \#35 Dated February 12, 2021 To Cash Sales customers Pavment Method: Cash SD20: Customer Payment Dated February 12, 2021 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. SD21: Memo \#5 Dated February 12, 2021 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, 2021 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, 2021 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 Fax: (613) 753-0962 Email: dchatter@dmnow.com Terms: Net 10 Credit Limit: \$2,000 Business Number: 289532733 SD24: Bill Dated February 15, 2021 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, 2021 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, 2021 Invoice \#3122 to Hannah Harris (QuickAdd the new customer), makeup and hair consultations for the "Mom's Day Out" group event. Terms Net 15 days SD27: Customer Payment Dated February 19, 2021 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, 2021 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 Dated February 19, 2021 To Cash Sales customers Payment Method: Cash use tne memorized transacion. SD30: Pay Bill Dated February 21, 2021 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, 2021 To Office Outfitters, $587.60 in payment of account. Reference Bill \#OO-520. Cheque \#251. SD32: Invoice Dated February 21, 2021 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. SD32: Invoice Dated February 21, 2021 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, 2021 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, 2021 From Partners: Open customer Invoices \#3122 and \#3123 and save as pdf. SD35: Memo \#8 Dated February 21, 2021 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, 2021 To Direct Marketing, \$226.00 in payment of account. Reference Bill \#\#DM-55. Cheque \#252. SD37: Customer Payment Dated February 25, 2021 From OTV News, cheque \#353 for $627.15 in payment of account. Reference Invoice \#3121. Cheque held for deposit. SD38: Sales Receipt \#37 Dated February 26, 2021 To Cash Sales customers Pavment Method: Cash SD39: Memo \#9 Dated February 28, 2021 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, 2021 From Partners: Complete adjusting entries for one month of depreciation: SD41: Memo \#11 Dated February 28, 2021 From Partners: Complete adjusting entries for supplies ..... SD42: Memo \#12 Dated February 28, 2021 From Partners: Complete adjusting entry for prepaid expenses expired: Insurance $1,050.00 SD43: Bank Debit Memo DM-58284 Dated February 28, 2021 From Capital Bank: Authorized withdrawals from Bank Chequing account for service charges and loan payments. Create a new Expense account: Bank Charges. SD44: Bank Credit Memo CM-204552 Dated February 28, 2021 From Capital Bank: Interest earned on bank deposits. Chequing account $10.00 Savings account 29.00 2. Prepare the Trial Balance as of February 28, 2021 and save as a pdf 3. Prepare the Journal from February 1 to February 28, 2021 and save as a pdf 4. Prepare the Profit and Loss Standard from February 1 to February 28, 2021 and save as a pdf 5. Prepare the A/R Aging Detail Report at February 28, 2021 and save as a pdf 6. Prepare the A/P Aging Detail Report at February 28, 2021 and save as a pdf 7. Email the 5 reports and invoice pdfs from SD13, SD16 and SD34 to your instructor for grading
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started