TRANSACTION EXERCISE

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

SD1:BillDated November 1, 2021

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 PaymentDated November 2, 2021

From AIM International, cheque #454 for $588.50 in payment of account.Reference Invoice #3084.Cheque held for deposit.

SD3: Customer PaymentDated November 3, 2021

From Jammers, cheque #793 for $609.90 in payment of account.Reference Invoice #3092.Cheque held for deposit

SD4:BillDated November 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 November 10, 2021.

SD5:Pay BillDated November 4, 2021

To Keep It Clean, $321.00 in payment of account.Reference Bills #KC-662 and KC-688.Automatically assign Cheque #245.

SD6: Invoice Dated November 4, 2021

Invoice #3119 to Reality Unlimited (Set up new customer) for contestants on their new dating show

10Clothing style consultations$190.00 each$1,900.00

10Makeovers390.00 each3,900.00

10Reports90.00 each900.00

HST 13%871.00

Invoice Total $7,571.00

Terms: Net 15 days

Reality Unlimited

783-C Burbank DriveOttawa, ONK6T 1P4

Contact:Guy Smiley

Phone: (613) 753-2873

Fax: (613) 7..y@realityu.ca

Tax Code:HST

Terms Net 15

Credit Limit: $10,000

Pay by:Cheque

SD7:Pay BillDated November 4, 2021

To Faces Inc., $805.00 in payment of account.Reference Bill #F-4910.Automatically assign Cheque #246.

SD8:Sales Receipt #34Dated November 5, 2021

To Cash Sales customers

Payment Method:Cash

6Clothing style consultations$190.00 each$1,140.00

3Hair consultations150.00 each450.00

8Makeup consultations120.00 each960.00

3Makeovers 390.00 each1,170.00

5Reports90.00 each450.00

HST 13%542.10

Sales receipt total cash held for deposit $4,712.10

Memorize the transaction with weekly reminders starting November 12, 2021.

SD9:Memo #1Dated November 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-4732Dated November 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 PaymentDated November 8, 2021

From ODSB, cheque #2031 for $800.00 in payment of account.Reference Invoice #3101.Cheque held for deposit.

SD12:Write ChequeDated November 10, 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 #2Dated November 12, 2021

From Partners:Print customer Invoices #3119 and #3120.

SD14:BillDated November 14, 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:InvoiceDated November 15, 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 #3Dated November 16, 2021

From Partners:Print customer Invoice #3121.

SD17:Memo #4Dated November 18, 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 BillDated November 20, 2021

To Office Outfitters, $1,380.00 in payment of account.Reference Bill #OO-500.Automatically assign Cheque #248.

SD19:Sales Receipt #35Dated November 22, 2021

To Cash Sales customers

Payment Method:Cash

4Clothing style consultations$190.00 each$760.00

5Hair consultations150.00 each750.00

5Makeup consultations120.00 each600.00

2Makeovers 390.00 each780.00

3Reports90.00 each270.00

HST 13%410.80

Sales receipt total cash held for deposit $3,570.80

Use the memorized transaction.

SD20:Customer PaymentDated November 24, 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 #5Dated November 25, 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 PaymentDated November 26, 2021

From OTV News, cheque #8125 for $2,139.30 in payment of account.Reference Invoice #3097.Cheque held for deposit.

SD23:BillDated November 27, 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 10 days.

Direct Marketing

2753 Telegraph Rd, Ottawa ONK3Y 4S6

Contact:Dean Chatter

Phone:(613) 753-9135

Fax:(613) 753-0962

Email: d..r@dmnow.com

Terms:Net 10

Credit Limit: $2,000

Business Number: 289 532 733

SD24:BillDated November 28, 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: BillDated November 28, 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:InvoiceDated November 28, 2021

Invoice #3122 to Hannah Harris (QuickAdd new customer), makeup and hair consultations for the "Mom's Day Out" group event.

6Hair consultations150.00 each900.00

6Makeup consultations120.00 each720.00

6Reports90.00 each540.00

HST 13%280.80

Invoice Total $2,440.80

Terms Net 15 days

2.Save and send the Trial Balance From November 1 to November 28, 2021

3.Save and Send the Journal from November 1 to November 28, 2021

4.Save and Send the Profit and Loss Standard from November 1 to November 28, 2021

5.Save and Send the A/R Aging Detail Reportat November 28, 2021

6.Save and Send the A/P Aging Detail Report at November 28, 2021