Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi Can anyone help me answer this one please. What are the journal entries for this. Please help. Thank you! 17. flack up your worlu

Hi Can anyone help me answer this one please. What are the journal entries for this. Please help. Thank you!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
17. flack up your worlu Continue with the original working copy, DERMAL. SAL Vinish eatering the history 18. Change the session date to April, 2022 Add the shortcuts you need and then enter the following transactions: NOTE: Be sure to use the correct bank account for each transaction. If you have set up the accounts correctly, the default account will be correct, Enter Carmine Painter as the salesperson for all sales. Cheque Purchase Invoice WLG-35887 Dated April 2, 2022 From Lee Gull. 52 373, including HST. for legal fee to draw up legal walver form for business. Pald by choque 432. Create new Group expense account S240 Legal Expenses. Allocate 20% of expense 10 Sales Division and 80% to Services. Use Quick Add for the new supplier Purchase Order NS5 Dated April 3.2022 Shipping Date April 11, 2022 From Skin Decals, Inc. 20 Designs - Small (513.ca) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large (558ca) 50.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total SI 299.50 Terms: 1/10, net 30. Edit the default prices and terms. Cash Receipt #356 Duted April 4, 2022 From Stan Stoner, cheque #2773 for $2757 in full payment of invoice #3104, taking into account 1% sales discount of S43 for early payment Purchase involce ANN-601 Dated April 4, 2022 From Ned's Needles, $250, plus 13% HST for sterilized needles that fit tattoo gun. Invoice total 5282.50. Terms: 1/15, net 30. Use Quick Add for new supplier Payment Cheque #433 Dated April 4, 2022 To Skin Decals, Inc., S3 479.80 in payment of invoices SD-621 and SD-808, including $30.20 discount for early payment, and $200 as deposit for purchase order 155. Total cheque amount is 53 679.80. Purchase Invoice WFS-1972 Duted April 5, 2022 From Full Spectrum. 4 boxes Ink-Permanent Colour (S40 en) S160.00 USD 4 boxes Ink - Permanent Outline (S45 ea) 180.00 USD 4 boxes Ink - Temporary Colour ($45 ea) 180.00 USD 4 boxes Ink - Temporary Outline (540 ca) 160.00 USD HST Paid 88.40 USD Invoice Total $768.40 USD Terms: 2/15, net 30 The exchange rate is 1.001 (the exchange rate difference amount may not be allocated) Edit the default prices. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Pago 11 Cheque Copy #119 Dated April 6, 2022 To Full Spectrum, 8970 USD in full payment of invoice FS-3904. The exchange rate is 0.990. Paid from Bank: USD Chequing Account Sales Quote #32 Delivery Date April 15, 2022 Dated April 6, 2022 To Hart Bridal Party (love knot & heart design tattoos for 10 members of wedding party) 10 Ink - Temporary Colour $ /tube 10 Ink - Temporary Outline 5 /tube 20 Designs - Small 20 each 10 Tattoo applications 70 session HST Charged 13% Terms: 1/15, nct 30. Sales Invoice N3110 Dated April 6, 2022 To Wanda Wonder (Use Quick Add for new Regular customer) 15 Ink - Permanent Colour $ 10/tube 6 Ink - Permanent Outline 6 tube 2 Designs - Medium 60 each 1 Design - Large 100 thch 5 Tattoo applications 80 session HST Charged 1396 Terms: 1/15, net 30. Allocate 100% of sales to Sales Division and 100% of services to Services Division Memo #1 Dated April 6, 2022 Bonnie Hart has accepted the sales quote to Hart Bridal Party and is placing an order. Convert Sales Quote #32 to Sales Order #32 using the same shipping date, prices and terms. Cash Receipt 357 Dated April 7, 2022 From Hart Bridal Party, cheque 188 for $400 as deposit 106 to accept sales order #32. Deposit Slip 11607 Dated April 7.2022 Deposit two cheques received in the past week. Total deposit is $3 157. Sales Invoice #3111 Dated April 8, 2022 To One-time customers 12 Ink - Permanent Colour S10 /tube 5 Ink - Permanent Outline 6 /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 % S2019.31 received by cheque #354 Allocate 100% of sales to Sales Division and 100% of services to Services Division Edit the default prices. Memo #2 Dated April 8, 2022 Pay hourly employee, Magenta Dyes for 35 hours regular work. Recover $50 advance. Dyes should be paid for serving 10 clients (No. Clients piece rate pay). Allocate 30% of payroll expenses to Sales and 70% to Service. Issue deposit slip #68. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Page 12 Flints: Use Payroll cheque run. Accept: Payroll Tables are out of date 19. Back up the data files. Continue with the file DERMAL.SAL. Change the session date to April 15, 2022. Enter the following transactions Purchase Invoice #SD-986 Dated April 11.2022 To fill Purchase Order 1155 From Skin Decals, Inc. 20 Designs - Small ($13 en) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large (S58 ea) 580.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total SI 299.50 Terms: 1/10, net 30 (new payment terms). Allocate 100% of freight expense to Sales Division. Memo #3 Dated April 11, 2022 Several boxes of supplies and inventory were damaged after a prolonged power failure. The following items were not usable and should be written off: Sterilized needles SI20 Other supplies 580 Tattoo gun S250 30 tubes Ink - Permanent Colour accept cost price 20 tubes Ink - Temporary Colour accept cost price Allocate 100% of the cost of equipment and supplies to the Services division and 100% of the cost of damaged ink inventory to the Sales division. Create new General Ledger Group expense account 5210 Damaged Supplies and Equipment. (Hint: two journal entries are required.) Cash Receipt N358 Dated April 11, 2022 From Wanda Wonder, cheque #344 for $901.67 in payment of invoice #3110, taking into account 1% sales discount of $9.11 for early payment. 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. Sales Invoice #3112 Dated April 13, 2022 To Stan Stoner 4 Designs - Large $100 each 10 Ink-Permanent Outline 10 tube 40 Ink-Permanent Colour 10 tube 20 Tattoo application 80 /session HST Charged 13 % Terms: 1/15, net 30 Allocate 100% of sales to Sales Division and 100% of services to services Division. Accept message. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Pago 13 Sales tavoice M3113 Dated April 15, 2022 To Hart Bridal Party, to fill sales order i32 10 Ink - Temporary Colour $7 Aube 10 Ink - Temporary Outline 5 /tube 20 Designs - Small 20 each 10 Tattoo application 70 /session HST Charged 13 % Terms: 1/15, net 30. Allocate 100% of sales to Sales Division and 100% of services to services Division Credit Card Sales Invoice #3114 Dated April 15, 2022 To One-time credit card customers 20 Ink-Permanent Colour SIO tube 9 Ink - Permanent Outline 10 tube 8 Ink - Temporary Colour 8/tube 4 Ink - Temporary Outline 7 ube 10 Designs - Medium 60 each 20 Tattoo application 80 /session HST Charged 13 % Invoice total $2917.66 paid by Wishful. Allocate 100% of sales to Sales Division and 100% of services to Services Division Edit the default prices Purchase Order #56 Dated April 15, 2022 Delivery Date: April 28, 2022 From Full Spectrum, one tattoo gun to replace the damaged equipment. The cost of the new gun is $320 plus HST 541.60. Invoice total 361.60 (USD). Terms: 2/15, net 30. The exchange rate is 0.985. Purchase Invoice MS-903 Dated April 15, 2022 From Medi-Specs, S260 plus $33.80 HST for routine site and equipment inspection. Invoice total $293.80. Terms: net IS. Create new Group expense account 5250 Licenses and Inspections. Allocate 40% of the expense to Sales Division and 60% to the Services Division Deposit Slip #608 Dated April 15, 2022 Deposit three cheques received in the past weeks totaling $3,920.98. Total deposit amount was $3 920.98. Memo #4 Dated April 15, 2022 Pay hourly employee, Magenta Dyes for 35 hours regular work. Recover $50 advance. Dyes took one day sick leave during the week. Dyes should be paid for serving 11 clients (No. Clients piece rate pay). Issue deposit slip #69. Allocate 40% of payroll expenses to Sales and 60% to Service. Ignore messages Memo #5 Dated April 15, 2022 Pay salaried employee. Carmine Painter S2 200 her regular bi-monthly salary. Calculate and include sales commission for Painter. Painter took one day sick leave during the pay period (allow negative days to accrue). Issue deposit slip #70. Allocate 30% of payroll expenses to Sales and 70% to Service. Note: Record hours worked per pay period. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Page 14 6 for $4 000 from Bank: Credit Card to Bank to CAD Chequing Account Dated April 15, 2022 transfer S2.000 USD from Bank: CAD Chequing Account to Bank: USD Chequing to cover upcoming payments. The exchange rate is 1.02. Bank Debit Memo #RCU-4433 From Rainbow Credit Union, S600 for loan payment including S100 interest and S500 principal. Dated April 15, 2022 Total amount withdrawn from CAD Chequing bank account was $600 Allocate 40% of the interest expenses to the Sales Division and 60% to the Services Division Memo 7 Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 2022 Dated April 15, 2022 Include remittance for income tax, El and CPP. Issue cheque 434. 20. Bank reconciliation. Set up account 1080 for account reconciliation. Use the following linked accounts. Create new accounts if necessary. Income: Interest 4280 Revenue from interest Expensel: Bank Charges 5010 Bank & Credit Card Fees Expense2: NSF fee 5010 Bank & Credit Card Fees Adjustment: 5005 Reconciliation Adjustments Reconcile the account using April 1 start date and April 15 as the statement end date and the reconciliation date. There are two outstanding prior transactions Source Description Date Amount 606 Deposit slip Mar 29 Deposit $2600 431 Skin Decals, Inc. Mar 30 Payment SI 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 Withdrawals deposits balance Mar. 15 Balance forward 23 330.00 Mar. 29 2 600.00 Deposit 606 Mar. 30 Cheque 431 1 800.00 Interest on account Cheque 432 2 373.00 Cheque 433 3 679.80 Deposit 607 3 157.00 Payroll transfer Ref 168 468.32 Deposit 608 3 920.98 Debit memo 600.00 Transfer from 04328-476199 4000.00 Transfer to 04328-59990 2040,00 Payroll transfer Ref #69 472.01 Payroll transfer Ref #70 1626.99 Service fee 45.00 Closing Balance 23 917.86 15.00 Apr. 1 Apr. 1 Apr. 4 Apr. 8 Apr. 8 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 21. Computerized Accounting with Sage 50 Level 2 (S120) riaal Doint 1 17. flack up your worlu Continue with the original working copy, DERMAL. SAL Vinish eatering the history 18. Change the session date to April, 2022 Add the shortcuts you need and then enter the following transactions: NOTE: Be sure to use the correct bank account for each transaction. If you have set up the accounts correctly, the default account will be correct, Enter Carmine Painter as the salesperson for all sales. Cheque Purchase Invoice WLG-35887 Dated April 2, 2022 From Lee Gull. 52 373, including HST. for legal fee to draw up legal walver form for business. Pald by choque 432. Create new Group expense account S240 Legal Expenses. Allocate 20% of expense 10 Sales Division and 80% to Services. Use Quick Add for the new supplier Purchase Order NS5 Dated April 3.2022 Shipping Date April 11, 2022 From Skin Decals, Inc. 20 Designs - Small (513.ca) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large (558ca) 50.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total SI 299.50 Terms: 1/10, net 30. Edit the default prices and terms. Cash Receipt #356 Duted April 4, 2022 From Stan Stoner, cheque #2773 for $2757 in full payment of invoice #3104, taking into account 1% sales discount of S43 for early payment Purchase involce ANN-601 Dated April 4, 2022 From Ned's Needles, $250, plus 13% HST for sterilized needles that fit tattoo gun. Invoice total 5282.50. Terms: 1/15, net 30. Use Quick Add for new supplier Payment Cheque #433 Dated April 4, 2022 To Skin Decals, Inc., S3 479.80 in payment of invoices SD-621 and SD-808, including $30.20 discount for early payment, and $200 as deposit for purchase order 155. Total cheque amount is 53 679.80. Purchase Invoice WFS-1972 Duted April 5, 2022 From Full Spectrum. 4 boxes Ink-Permanent Colour (S40 en) S160.00 USD 4 boxes Ink - Permanent Outline (S45 ea) 180.00 USD 4 boxes Ink - Temporary Colour ($45 ea) 180.00 USD 4 boxes Ink - Temporary Outline (540 ca) 160.00 USD HST Paid 88.40 USD Invoice Total $768.40 USD Terms: 2/15, net 30 The exchange rate is 1.001 (the exchange rate difference amount may not be allocated) Edit the default prices. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Pago 11 Cheque Copy #119 Dated April 6, 2022 To Full Spectrum, 8970 USD in full payment of invoice FS-3904. The exchange rate is 0.990. Paid from Bank: USD Chequing Account Sales Quote #32 Delivery Date April 15, 2022 Dated April 6, 2022 To Hart Bridal Party (love knot & heart design tattoos for 10 members of wedding party) 10 Ink - Temporary Colour $ /tube 10 Ink - Temporary Outline 5 /tube 20 Designs - Small 20 each 10 Tattoo applications 70 session HST Charged 13% Terms: 1/15, nct 30. Sales Invoice N3110 Dated April 6, 2022 To Wanda Wonder (Use Quick Add for new Regular customer) 15 Ink - Permanent Colour $ 10/tube 6 Ink - Permanent Outline 6 tube 2 Designs - Medium 60 each 1 Design - Large 100 thch 5 Tattoo applications 80 session HST Charged 1396 Terms: 1/15, net 30. Allocate 100% of sales to Sales Division and 100% of services to Services Division Memo #1 Dated April 6, 2022 Bonnie Hart has accepted the sales quote to Hart Bridal Party and is placing an order. Convert Sales Quote #32 to Sales Order #32 using the same shipping date, prices and terms. Cash Receipt 357 Dated April 7, 2022 From Hart Bridal Party, cheque 188 for $400 as deposit 106 to accept sales order #32. Deposit Slip 11607 Dated April 7.2022 Deposit two cheques received in the past week. Total deposit is $3 157. Sales Invoice #3111 Dated April 8, 2022 To One-time customers 12 Ink - Permanent Colour S10 /tube 5 Ink - Permanent Outline 6 /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 % S2019.31 received by cheque #354 Allocate 100% of sales to Sales Division and 100% of services to Services Division Edit the default prices. Memo #2 Dated April 8, 2022 Pay hourly employee, Magenta Dyes for 35 hours regular work. Recover $50 advance. Dyes should be paid for serving 10 clients (No. Clients piece rate pay). Allocate 30% of payroll expenses to Sales and 70% to Service. Issue deposit slip #68. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Page 12 Flints: Use Payroll cheque run. Accept: Payroll Tables are out of date 19. Back up the data files. Continue with the file DERMAL.SAL. Change the session date to April 15, 2022. Enter the following transactions Purchase Invoice #SD-986 Dated April 11.2022 To fill Purchase Order 1155 From Skin Decals, Inc. 20 Designs - Small ($13 en) $260.00 10 Designs - Medium ($27 ea) 270.00 10 Designs - Large (S58 ea) 580.00 Courier Freight Charge 40.00 HST Paid 149.50 Invoice Total SI 299.50 Terms: 1/10, net 30 (new payment terms). Allocate 100% of freight expense to Sales Division. Memo #3 Dated April 11, 2022 Several boxes of supplies and inventory were damaged after a prolonged power failure. The following items were not usable and should be written off: Sterilized needles SI20 Other supplies 580 Tattoo gun S250 30 tubes Ink - Permanent Colour accept cost price 20 tubes Ink - Temporary Colour accept cost price Allocate 100% of the cost of equipment and supplies to the Services division and 100% of the cost of damaged ink inventory to the Sales division. Create new General Ledger Group expense account 5210 Damaged Supplies and Equipment. (Hint: two journal entries are required.) Cash Receipt N358 Dated April 11, 2022 From Wanda Wonder, cheque #344 for $901.67 in payment of invoice #3110, taking into account 1% sales discount of $9.11 for early payment. 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. Sales Invoice #3112 Dated April 13, 2022 To Stan Stoner 4 Designs - Large $100 each 10 Ink-Permanent Outline 10 tube 40 Ink-Permanent Colour 10 tube 20 Tattoo application 80 /session HST Charged 13 % Terms: 1/15, net 30 Allocate 100% of sales to Sales Division and 100% of services to services Division. Accept message. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Pago 13 Sales tavoice M3113 Dated April 15, 2022 To Hart Bridal Party, to fill sales order i32 10 Ink - Temporary Colour $7 Aube 10 Ink - Temporary Outline 5 /tube 20 Designs - Small 20 each 10 Tattoo application 70 /session HST Charged 13 % Terms: 1/15, net 30. Allocate 100% of sales to Sales Division and 100% of services to services Division Credit Card Sales Invoice #3114 Dated April 15, 2022 To One-time credit card customers 20 Ink-Permanent Colour SIO tube 9 Ink - Permanent Outline 10 tube 8 Ink - Temporary Colour 8/tube 4 Ink - Temporary Outline 7 ube 10 Designs - Medium 60 each 20 Tattoo application 80 /session HST Charged 13 % Invoice total $2917.66 paid by Wishful. Allocate 100% of sales to Sales Division and 100% of services to Services Division Edit the default prices Purchase Order #56 Dated April 15, 2022 Delivery Date: April 28, 2022 From Full Spectrum, one tattoo gun to replace the damaged equipment. The cost of the new gun is $320 plus HST 541.60. Invoice total 361.60 (USD). Terms: 2/15, net 30. The exchange rate is 0.985. Purchase Invoice MS-903 Dated April 15, 2022 From Medi-Specs, S260 plus $33.80 HST for routine site and equipment inspection. Invoice total $293.80. Terms: net IS. Create new Group expense account 5250 Licenses and Inspections. Allocate 40% of the expense to Sales Division and 60% to the Services Division Deposit Slip #608 Dated April 15, 2022 Deposit three cheques received in the past weeks totaling $3,920.98. Total deposit amount was $3 920.98. Memo #4 Dated April 15, 2022 Pay hourly employee, Magenta Dyes for 35 hours regular work. Recover $50 advance. Dyes took one day sick leave during the week. Dyes should be paid for serving 11 clients (No. Clients piece rate pay). Issue deposit slip #69. Allocate 40% of payroll expenses to Sales and 60% to Service. Ignore messages Memo #5 Dated April 15, 2022 Pay salaried employee. Carmine Painter S2 200 her regular bi-monthly salary. Calculate and include sales commission for Painter. Painter took one day sick leave during the pay period (allow negative days to accrue). Issue deposit slip #70. Allocate 30% of payroll expenses to Sales and 70% to Service. Note: Record hours worked per pay period. Computerized Accounting with Sage 50 Level 2 (S120) Final Project 1 Page 14 6 for $4 000 from Bank: Credit Card to Bank to CAD Chequing Account Dated April 15, 2022 transfer S2.000 USD from Bank: CAD Chequing Account to Bank: USD Chequing to cover upcoming payments. The exchange rate is 1.02. Bank Debit Memo #RCU-4433 From Rainbow Credit Union, S600 for loan payment including S100 interest and S500 principal. Dated April 15, 2022 Total amount withdrawn from CAD Chequing bank account was $600 Allocate 40% of the interest expenses to the Sales Division and 60% to the Services Division Memo 7 Make payroll tax remittance to the Receiver General for the pay periods ending April 15, 2022 Dated April 15, 2022 Include remittance for income tax, El and CPP. Issue cheque 434. 20. Bank reconciliation. Set up account 1080 for account reconciliation. Use the following linked accounts. Create new accounts if necessary. Income: Interest 4280 Revenue from interest Expensel: Bank Charges 5010 Bank & Credit Card Fees Expense2: NSF fee 5010 Bank & Credit Card Fees Adjustment: 5005 Reconciliation Adjustments Reconcile the account using April 1 start date and April 15 as the statement end date and the reconciliation date. There are two outstanding prior transactions Source Description Date Amount 606 Deposit slip Mar 29 Deposit $2600 431 Skin Decals, Inc. Mar 30 Payment SI 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 Withdrawals deposits balance Mar. 15 Balance forward 23 330.00 Mar. 29 2 600.00 Deposit 606 Mar. 30 Cheque 431 1 800.00 Interest on account Cheque 432 2 373.00 Cheque 433 3 679.80 Deposit 607 3 157.00 Payroll transfer Ref 168 468.32 Deposit 608 3 920.98 Debit memo 600.00 Transfer from 04328-476199 4000.00 Transfer to 04328-59990 2040,00 Payroll transfer Ref #69 472.01 Payroll transfer Ref #70 1626.99 Service fee 45.00 Closing Balance 23 917.86 15.00 Apr. 1 Apr. 1 Apr. 4 Apr. 8 Apr. 8 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 Apr. 15 21. Computerized Accounting with Sage 50 Level 2 (S120) riaal Doint 1

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

Public Sector Audit

Authors: Carolyn J. Cordery, David C. Hay

1st Edition

0367650622, 9780367650629

More Books

Students also viewed these Accounting questions

Question

Provide a business example illustrating opportunity costs.

Answered: 1 week ago