Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Company Information: BODY ART, an Ontario company, specializes in high quality aesthetic body art with sterile equipment. The manager of the store buys tattoo designs

Company Information: BODY ART, an Ontario company, specializes in high quality aesthetic body art with sterile equipment. The manager of the store buys tattoo designs from other artists and also creates custom designs as per special requests. Her assistant completes much of the tattoo work. Temporary tattoos are also available. The ink used for tattoos is charged to customers as inventory sales. The tattoo application and custom design work are charged as services on the basis of time. Change the session date to April 8, 2022. 1. Cash Purchase Invoice #LG-35887 Dated April 2, 2022 From Lee Gull (choose Quick Add for new supplier), $2 373, including HST, for legal fee to draw up legal waiver form for business. Paid by cheque #432. Create new Group expense account 5240 Legal Expenses. Type your name in additional information. (3 marks) 2. Purchase Order #55 Dated April 3, 2022 Shipping Date April 11, 2022 From Skin Decals, Inc. 20 Designs Small $260.00 10 Designs Medium 270.00 10 Designs Large 580.00 Freight 40.00 HST Paid 13% Terms: 1/10, net 30. Create a snippet and add to your Word document. (1 mark) 3. Cash Receipt #356 Dated April 4, 2022 From Stan Stoner, cheque #2773 for $2 757 in full payment of invoice #3104, taking into account 1% sales discount for early payment. (2 marks) 4. Purchase Invoice #NN-601 Dated April 4, 2022 From Neds Needles (Quick Add), $250, plus 13% HST for sterilized needles that fit tattoo gun. Terms: 1/15, net 30. (3 marks) 2 5. Payment Cheque #433 Dated April 4, 2022 To Skin Decals, Inc., $3 479.80 in payment of invoices #SD-621 and SD-808, including discount for early payment, and $200 as prepayment for purchase order #55. Total cheque amount is $3 679.80. (3 marks) 6. Purchase Invoice #CS-4972 Dated April 5, 2022 From Colour Your Skin (Quick-Add), 30 Ink Permanent Colour $120.00 30 Ink Permanent Outline 150.00 30 Ink Temporary Colour 150.00 30 Ink Temporary Outline 120.00 HST Paid 13% Issue cheque #434 in full payment. Type your name in additional information. (3 marks) 7. Sales Quote #32 Dated April 6, 2022 Delivery Date April 15, 2022 To Hart Bridal Party, love knot & heart design tattoos for members of wedding party: 10 Ink Temporary Colour $7 /tube 10 Ink Temporary Outline 5 /tube 20 Designs Small 20 each 10 Tattoo applications 70 /session HST Charged 13 % Terms: 1/15, net 30. (1 mark) Create a snippet and add to your Word document. 8. Sales Invoice #3110 Dated April 6, 2022 To Wanda Wonder (Use Quick Add for new customer) 15 Ink Permanent Colour $ 10 /tube 6 Ink Permanent Outline 10 /tube 2 Designs Medium 60 each 1 Design Large 100 each 5 Tattoo applications 80 /session HST Charged 13 % Terms: 1/15, net 30. (2 marks) 9. Memo #1 Dated April 6, 2022 Bonnie Hart has accepted the sales quote to Hart Bridal Party and is placing an order. Convert Quote #32 to Order #32 using the same shipping date, prices and terms. (1 mark) Create a snippet and add to your Word document. 10.Cash Receipt #357 Dated April 7, 2022 From Hart Bridal Party, cheque #188 for $400 as deposit #106 to accept sales order #32. (2 marks) 3 11.Deposit Slip #607 Dated April 7, 2022 Deposit two cheques received in the past week. Total deposit is $3 157. (2 marks) 12.Cash Sales Invoice #3111 Dated April 8, 2022 To One-time cash customers (paid in cash) 12 Ink Permanent Colour $10 /tube 5 Ink Permanent Outline 10 /tube 6 Ink Temporary Colour 8 /tube 2 Ink Temporary Outline 7 /tube 15 Designs Small 25 each 15 Tattoo applications 80 /session HST Charged 13 % (3 marks) Change the session date to April 15, 2022. 13. SKIN DECALS April 11, 2022 Invoice # SD-986 Bill To Customer Body Art Address 9999-A New St. Toronto, Ontario M5W 1G6 Phone (647) 523-8191 Payment Terms 1/10, net 30 Supplier Order # 55 Qty. Description Unit Price Line Total 20 Designs - Small $13 $260.00 10 Designs - Medium $27 270.00 10 Designs - Large $58 580.00 Courier Freight Charge 40.00 HST Paid 149.50 Total $1,299.50 Thank you for your business (2 marks) 14.Cash Receipt #358 Dated April 11, 2022 From Wanda Wonder, cheque #344 for $928.52 in payment of invoice #3110, taking into account 1% sales discount for early payment. (2 marks) 4 15.Cash Receipt #359 Dated April 11, 2022 From Stan Stoner, cheque #2789 for $1 000 as deposit #107 in prepayment for tattoo work to be completed over several weeks. (2 marks) 16. BODY ART April 13, 2022 Invoice # 3112 Bill To Customer Stan Stoner Address 110 Abbey Rd. Toronto, ON M8C 9A1 Phone (416) 592-9001 Payment Terms 1/15, net 30 Qty. Description Unit Price Line Total 4 Design - Large $100 $400 10 Ink Permanent Outline $10 / tube 100 40 Ink Permanent Colour $10 / tube 400 20 Tattoo Application $80 / session 1,600 Subtotal 2,500 HST @13% 325 Total $2,825 Thank you for your business Type your name in additional information. (3 marks) 17.Sales Invoice #3113 Dated April 14, 2022 5 To Hart Bridal Party, to fill sales order #32 10 Ink Temporary Colour $7 /tube 10 Ink Temporary Outline 5 /tube 20 Designs Small 20 each 10 Tattoo application 70 /session HST Charged 13 % Terms: 1/15, net 30. (2 marks) 18.Deposit Slip #608 Dated April 15, 2022 Deposit the two cheques received in the past week, plus the following in cash: 15 x $5; 21 x $10; 25 x $20; 9 x $50; 8 x $100; coin $6.91.Total deposit amount was $3,970.43. Type your name in additional information. (3 marks) 19.Memo #6 Dated April 15, 2022 Transfer $4 000 from the credit card to the chequing account. (2 marks) 20.Bank Debit Memo #RCU-4433 Dated April 15, 2022 From Rainbow Credit Union, $600 for loan payment including $100 interest and $500 principal. Total amount withdrawn was $600. (3 marks) 21.Bank reconciliation Dated April 15, 2022 Set up account 1080 for account reconciliation. (2 marks) Use the following linked accounts. Create new accounts if necessary. Income: Interest 4280 Revenue from Interest Expense1: Bank Charges 5010 Credit Card & Bank Fees Expense2: NSF fee 5010 Credit Card & Bank Fees Adjustment: 5005 Reconciliation Adjustments Reconcile the account using the default start date and April 15 as the statement end date and the reconciliation date. There are two outstanding prior transactions (2 marks) Source Description Date Amount 606 Deposit slip Mar 29 Deposit $2 600 431 Skin Decals, Inc. Mar 30 Payment $1 800 (Hint: after adding the first outstanding transaction, click Insert Outstanding again to access a new transaction line.) Use the following bank statement details to complete the reconciliation. (6 marks) 6 Date Description Deposits Withdrawals Balance Mar. 15 Balance Forward 23,330.00 Mar. 29 Deposit 606 2,600.00 25,930.00 Mar. 30 Cheque 431 1,800.00 24,130.00 Apr. 1 Interest on account 15.00 24,145.00 Apr. 4 Cheque 432 2,373.00 21,772.00 Apr. 8 Deposit 607 3,157.00 24,929.00 Apr. 9 Cheque 433 3,679.80 21,249.20 Apr. 13 Cheque 434 610.20 20,639.00 Apr. 15 Deposit 608 3,970.43 24,609.43 Apr. 15 Transfer from 04328-476199 4,000.00 28,609.43 Apr. 15 Debit memo 600.00 28,009.43 Apr. 15 Service fee 45.00 27,964.4

Its automated accounting on sage 50 so can you please provide me journal entries and a trial balance sheet please as soon as possible

so can you find from some where and send me please

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Numerical Methods In Finance

Authors: René Carmona, Pierre Del Moral, Peng Hu, Nadia Oudjane

2012th Edition

3642257453, 978-3642257452

More Books

Students explore these related Finance questions