MALIN's MAKEOVERS
Transaction exercise submit the following reports:
1. Trial Balance from February 01 to February 28, 2019
2. Journal from February 01 to February 28, 2019
3. Profit and Loss Standard from February 01 to February 28, 2019
4. Accounts Receivable Aging Detail Report at February 28, 2019
5. Accounts Payable Aging Detail Report at February 28, 2019
Chapters 2- 6 TRANSACTION EXERCISE 1. Using the Malin's Makeovers QuickBooks data file (Malin.qbw or Malin), record entries for the source documents for February 2019. If you have completed the source documents for this company in the text please recopy the data file from the Data CD before starting. SD1: Bill Dated February 1, 2019 Bill #OO-520 received from Office Outfitters, $520.00 plus $67.60 HST for paper, printer cartridges and other office supplies. Be sure to delete the Uncategorized Expense account on the Expenses tab of the bill. The bill totals $587.60. Terms Net 20 days. SD2: Customer Payment Dated February 2, 2019 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, 2019 From Jammers, cheque #793 for $609.90 in payment of account. Reference Invoice #3092. Cheque held for deposit 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, 2019. SD5: Pay Bill Dated February 4, 2019 To Keep It Clean, $321.00 in payment of account. Reference Bills #KC-662 and KC-688. Automatically assign Cheque #245. SD6: Invoice Dated February 4, 2019 Invoice #3119 to Reality Unlimited (Set up new customer) for contestants on their new dating show 10 Clothing style consultations $190.00 each $1,900.00 10 Makeovers 390.00 each 3,900.00 10 Reports 90.00 each 900.00 HST 13% 871.00 Invoice Total $7,571.00 Terms: Net 15 days 1 | PageReality Unlimited 783-C Burbank Drive Ottawa, ON KOT 1P4 Contact: Guy Smiley Phone: (613) 753-2873 Fax: (613) 753-4834 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. Automatically assign 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 50.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, 2019. 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. 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. 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 Dated February 12, 2019 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 #OO- 4500. Automatically assign Cheque #248 SD19: Sales Receipt #35 Dated February 12, 2019 To Cash Sales customers Payment Method: Cash 4 Clothing style consultations $190.00 each $760.00 5 Hair consultations 150.00 each 750.00 Makeup consultations 120.00 each 600.00 Makeovers 390.00 each 780.00 Reports 90.00 each 270.00 HST 13% 410.80 Sales receipt total cash held for deposit $3,570.80 Use the memorized transaction.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. SD21: Memo #5 Dated February 12, 2019 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 456 Contact: Dean Chatter Phone: (613) 753-9135 Fax: (613) 753-0962 Email: dchatter@dmnow.com Terms: Net 10 Credit Limit: $2,000 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 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 daysSD27: 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 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. Automatically assign Cheque #250 SD31: Pay Bill Dated February 21, 2019 To Office Outfitters, $587.60 in payment of account. Reference Bill #OO- 520. Automatically assign 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. Automatically assign 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 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.00SD43: 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 2. Print the Trial Balance From February 1 to 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
