Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

post journal entries and prepare income statement. answer for income statement is given in below pic: check figures. SESSION DATE - APRIL 7, 2024 Memo#1

post journal entries and prepare income statement. answer for income statement is given in below pic: check figures.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
SESSION DATE - APRIL 7, 2024 Memo\#1 Dated April 1/24 Create shortcuts for General Journal entries, purchase invoices, pay expenses (other payments) and pay invoices, the journals used in this chapter. Sales Invoice \#710 Dated April 1/24 To Selkirk Community Centre, \$1 800 plus $90 GST and \$108 PST for removing and reapplying solar panels for roof replacement. Invoice total \$1 998. Terms: 1/10,n/30. Create new Group account 4120 Repairs Revenue. Receipt \#200 Dated April 2/24 From Grande Pointe Towers, cheque \#5033 for $2435.60, including $1935.60 in full payment of invoice \#699 and $500 in partial payment of invoice #703, and allowing $44.40 discount for early payment. Customize the joumal by changing the tabbing order so that the cheque number follows the customer number. Purchase Invoice \$WH-42001 Dated April 3/24 From Wheatfields Hardware, \$1 500 plus $75 CST and \$90 PST for new ladders and other tools. Invoice total \$1 665. Terms: net 15. Payment Cheque \#101 Dated April 4/24 To Beausejour Electrical Products, $10760 in payment of account, including $140 discount for early payment. Reference invoices \#B-894 and \#B-921. Payment Cheque \#102 Dated April 4/24 To Killamey Solar Equipment, $5900 in payment of invoice \#KS-1031. Sales Invoice \#7 Dated April 5/24 To Selkirk Community Centre, $18000 plus $900 CST and $1080 PST for installing additional solar panels. Invoice total \$19 980. Terms: 1/10,n/30. Memo\#2 Dated April 6/24 Create new tax code IN using taxes CST at the rate of 5% and PST at the rate of 6%. CST is included and refundable; PST is included and not refundable. Payment Cheque \#101 Dated April 4/24 To Beausejour Electrical Products, \$10 760 in payment of account, including $140 discount for early payment. Reference invoices \#B-894 and \#B-921. Payment Cheque \#102 Dated April 4/24 To Killarney Solar Equipment, $5,900 in payment of invoice \#KS-1031. Sales Invoice \#711 Dated April 5/24 To Selkirk Community Centre, \$18 000 plus $900 GST and $1080 PST for installing additional solar panels. Invoice total $19980. Terms: 1/10,n/30. Memo \#2 Dated April 6/24 Create new tax code IN using taxes GST at the rate of 5% and PST at the rate of 6%. GST is included and refundable; PST is included and not refundable. Memo \#3 Dated April 6/24 Edit the supplier record for Willow Garage. Change the default tax code to IN and create 5240 Vehicle Expenses, a new Group expense account as the default expense account for the supplier. Purchase Invoice \#W-1993 Dated April 6/24 From Willow Garage, 8120 including taxes (tax code IN) for gasoline for van. Store the transaction as a bi-weekly recurring entry. Terms: net 30. Receipt \#201 Dated April 7/24 From Regina School Board, cheque \#12488 for $19778 including $222 discount for early payment. Reference invoice \#701. Sales Invoice \#712 Dated April 7/24 To Hazel Estates (use Full Add for the new customer), $1200 plus $60 CST and $72 PST for a one-year service contract. Invoice total $1 332. Terms: 1/10,n/30. Chapter 7: Air Care Services: Receivables \& Payables Setup APTER 7 ESSION DATE - APRIL 14, 2024 Memo \#4 Dated April 8/24 From Owner: Cheque \#5033 for $2.435.60 from Grande Pointe Towers was postdated and the discount period had expired. It was incorrectly entered with the discount on April 2. The cheque was not yet deposited, so you should reverse the receipt. Memo \#5 Dated April 8/24 From Owner: Change the payment terms for Grande Pointe Towers to net 30. Notify the customer of the outstanding charges and the changes in payment terms. Memo \#6 Dated April 8/24 From Owner: The work done for Hazel Estates included $1600 plus $80 GST and $96 PST for replacement of damaged microinverters. The revised and correct invoice total is $3 108. Adjust invoice #712 to add the extra amount. MasterCard Sales Invoice \#714 Dated April 9/24 To Vinod Residence (use Full Add for the new customer), 5600 plus $30 CST and $36 PST for repairs. Invoice total $666 paid in full by MasterCard. Receipt \#202 Dated April 10/24 From Selkirk Community Centre, chegue $533 for $7978.02 including Chapter 7: Air Care Services: Receivables \& Payables Setup Memo \#6 Dated April 8/24 From Owner: The work done for Hazel Estates included $1600 plus $80 GST and $96 PST for replacement of damaged microinverters. The revised and correct invoice total is \$3 108. Adjust invoice \#712 to add the extra amount. MasterCard Sales Invoice \#714 Dated April 9/24 To Vinod Residence (use Full Add for the new customer), $600 plus $30 GST and $36 PST for repairs. Invoice total $666 paid in full by MasterCard. Receipt \#202 Dated April 10/24 From Selkirk Community Centre, cheque #533 for $7978.02, including $1978.02 in full payment of invoice \#710 with $19.98 discount for early payment, and $6000 in partial payment of invoice \#711. Purchase Invoice \#GE-2579 Dated April 10/24 From Green Earth Products Inc, $14000 plus $700 CST for microinverters. Invoice total $14700. Terms: 1/10, n/30. Store as a bi-weekly recurring entry. Cash Purchase Invoice twW-6913 Dated April 11/24 From Westrock Insurance (use Quick Add), $185 per month for a one-year car insurance policy with $2000000 liability coverage and $4000 deductible. Terms: first month payable in advance on acceptance of quote followed by monthly instalments at the end of each month. Pay first month's premium of $185 in advance. Issue cheque \#103. Store as a recurring monthly transaction. Meme \#7 Dated April 11/24 Recall the stored entry for car insurance from Westrock Insurance to enter a postdated payment for next month's premium of \$185. Issue cheque 1104 postdated for May 11. After posting recall the entry again and make a postdated payment for the premium due June 11 with cheque \#105. Payment Cheque \#106 Dated April 14/24 To Green Earth Products Inc, $14560 in payment of account, induding $140 discount for early payment. Reference invoice \#CE-2579. Receipt \#203 Dated April 14/24 From Selkirk Community Centre, cheque \#586 for $13780.20 in payment of account, including \$199.80 discount for early payment. Reference invoice \#711. SESSION DATE - APRIL 21, 2024 Bank Debit Memo \#35589 Dated April 15/24 From Flatlands Credit Union, cheque \#12488 for \$19 778 from Regina School Board has been returned because of non-sufficient funds. Enter a negative receipt to record the NSF cheque. Notify the customer of the outstanding charges. Cash Purchase Invoice \#SAA-1098 Dated April 15/24 From Starbuck Advertising Agency, \$1 100 plus $55 GST and \$66 PST for flyers on clean energy alternatives. Create new Group expense account: 5230 Promotion Expenses. Invoice total $1221. Paid by cheque \#107. Receipt \#204 Dated April 15/24 From Hazel Estates, cheque \#230 for $3076.92 in full payment of account, including $31.08 discount for early payment. Reference adjusted invoice \#712. Cash Purchase Invoice \#FX-3467 Dated April 16/24 From FedEx (use Quick Add for the new supplier), $460 for special delivery of solar panels plus $23 GST. Invoice total \$483. Issued cheque \#108 in full payment. Create new Group account 5220 Delivery Expenses. Payment Cheque \#109 Dated April 16/24 To Wheatfields Hardware, $1665 in payment of account. Reference invoice \#WH-42001. Payment Cheque \#109 Dated April 16/24 To Wheatfields Hardware, \$1 665 in payment of account. Reference invoice \#WH-42001. Cash Purchase Invoice \#SEC-44371 Dated April 19/24 From Saskatchewan Energy Corp., $200 plus $10 GST for two months of hydro service. Invoice total $210. Paid by cheque \#110. Cash Purchase Invoice \#SKT-36128 Dated April 19/24 From Saskatel, $330 plus $16.50 GST and \$19.80 PST for telephone, cellular and Internet senvice. Invoice total $366.30. Paid by cheque \#111. Cash Purchase invoice \#SKT-36128 Dated April 19/24 From Saskatel, $330 plus $16.50 GST and $19.80 PST for telephone, cellular and Internet service. Invoice total $366.30. Paid by cheque \#111. SESSION DATE - APRIL 30, 2024 Purchase Invoice \#W-3468 Dated April 22/24 From Willow Garage, $120 including taxes (use tax code IN) for gasoline for van. Terms: net 30. Recall stored entry and edit the date. Purchase Invoice \#GE-4906 Dated April 24/24 From Green Earth Products Inc., $14000 plus $700 GST for microinverters. Invoice total $14700. Terms: 1/10,n/30. Recall stored entry. Purchase Invoice \#KE-1679 Dated April 25/24 From Killarney Solar Equipment, $30000 plus $1500 GST for solar panels. Invoice total $31500. Terms: 1/5,n/30. Sales Invoice \#77 Dated April 25/24 To Grande Pointe Towers, $24000 for new subcontracting job, plus $1200 CST and $1440 PST. Invoice total $26 640. Terms: net 1. Grande Pointe Towers has provided a certified cheque in full payment of their account. Grande Pointe Towers. 77 LaPointe Cr. White City. SK SOG 5B0 Tel: (306) 322-7500 Pin - Thirty thousand eight hundred forty dollars 00 s 30,840= Tomin Ar Care Servicen onning of Deg Belair Ave. Unit 25 Regina, SK S4T 4 U2 rit x+06 suade 29294946771654 Bank Debit Memo \#55131 Dated April 30/24 38 From Flatlands Credit Union, pre-authorized monthly payroll for employees. Wages and payroll expenses Payroll services fee GST paid on payroll service Total withdrawal $780010057905 MHFO Servicesos aireare. eom clean energy for a better future New expense account required: 5170 Electrical Parts Used New expense account required: 5170 Electrical Parts Used Authorization SAAquil 30/24 Chapter 7: Air Care Services: Recelvables \& Payables Setup APTER 7 ESSION DATE - MAY 1,2024 Memo \#9 Dated May 1/24 From Owner: Received monthly statements showing missing historical information. The statement from Wheatfields Hardware included an overdue amount of \$1 100 from invoice \#WH-20001 dated March 24, 2024. The statement from Starbuck Advertising Agency included an overdue amount of $2200 from invoice \#SAA-987 dated March 14, 2024. Add the historical invoices for these two transactions in the Supplier Ledger records as historical transactions. You can open the Payables module window or use the View Suppliers shortcut to access the records for these suppliers. Pay these two invoices in the Payments Joumal as current transactions dated May 1 using cheques \#112 and #113. Memo \#10 Dated May 1/24 Check the data integrity (Maintenance menu) after entering the historical invoices. Make a backup copy of the data files and finish entering the history. Choose the History menu in the Home window and click Finish Entering History. Memo \#11 Dated May 1/24 From Owner: Print or preview customer statements. One invoice for Regina School Board is overdue. Complete sales invoice \#718 for Regina School Board for $29.39, the interest charges on the overdue amount. Terms: net 15 days, Use the No Tax code for the interest charges and choose Interest Revenue as the account. Remember to remove the early payment discount. TRIAL BALANCE AIR CARE SERVICES Manch31,204 Check Figures: Income Statement Total Revenue =$82,278.53, Total Expenses =$68,576.09, Net Income =$13,702.44 Net GST collected from revenue less paid on expenses =$1,029.68 Janiary I to March 31, 2024 AIR CARE SERVICES SESSION DATE - APRIL 7, 2024 Memo\#1 Dated April 1/24 Create shortcuts for General Journal entries, purchase invoices, pay expenses (other payments) and pay invoices, the journals used in this chapter. Sales Invoice \#710 Dated April 1/24 To Selkirk Community Centre, \$1 800 plus $90 GST and \$108 PST for removing and reapplying solar panels for roof replacement. Invoice total \$1 998. Terms: 1/10,n/30. Create new Group account 4120 Repairs Revenue. Receipt \#200 Dated April 2/24 From Grande Pointe Towers, cheque \#5033 for $2435.60, including $1935.60 in full payment of invoice \#699 and $500 in partial payment of invoice #703, and allowing $44.40 discount for early payment. Customize the joumal by changing the tabbing order so that the cheque number follows the customer number. Purchase Invoice \$WH-42001 Dated April 3/24 From Wheatfields Hardware, \$1 500 plus $75 CST and \$90 PST for new ladders and other tools. Invoice total \$1 665. Terms: net 15. Payment Cheque \#101 Dated April 4/24 To Beausejour Electrical Products, $10760 in payment of account, including $140 discount for early payment. Reference invoices \#B-894 and \#B-921. Payment Cheque \#102 Dated April 4/24 To Killamey Solar Equipment, $5900 in payment of invoice \#KS-1031. Sales Invoice \#7 Dated April 5/24 To Selkirk Community Centre, $18000 plus $900 CST and $1080 PST for installing additional solar panels. Invoice total \$19 980. Terms: 1/10,n/30. Memo\#2 Dated April 6/24 Create new tax code IN using taxes CST at the rate of 5% and PST at the rate of 6%. CST is included and refundable; PST is included and not refundable. Payment Cheque \#101 Dated April 4/24 To Beausejour Electrical Products, \$10 760 in payment of account, including $140 discount for early payment. Reference invoices \#B-894 and \#B-921. Payment Cheque \#102 Dated April 4/24 To Killarney Solar Equipment, $5,900 in payment of invoice \#KS-1031. Sales Invoice \#711 Dated April 5/24 To Selkirk Community Centre, \$18 000 plus $900 GST and $1080 PST for installing additional solar panels. Invoice total $19980. Terms: 1/10,n/30. Memo \#2 Dated April 6/24 Create new tax code IN using taxes GST at the rate of 5% and PST at the rate of 6%. GST is included and refundable; PST is included and not refundable. Memo \#3 Dated April 6/24 Edit the supplier record for Willow Garage. Change the default tax code to IN and create 5240 Vehicle Expenses, a new Group expense account as the default expense account for the supplier. Purchase Invoice \#W-1993 Dated April 6/24 From Willow Garage, 8120 including taxes (tax code IN) for gasoline for van. Store the transaction as a bi-weekly recurring entry. Terms: net 30. Receipt \#201 Dated April 7/24 From Regina School Board, cheque \#12488 for $19778 including $222 discount for early payment. Reference invoice \#701. Sales Invoice \#712 Dated April 7/24 To Hazel Estates (use Full Add for the new customer), $1200 plus $60 CST and $72 PST for a one-year service contract. Invoice total $1 332. Terms: 1/10,n/30. Chapter 7: Air Care Services: Receivables \& Payables Setup APTER 7 ESSION DATE - APRIL 14, 2024 Memo \#4 Dated April 8/24 From Owner: Cheque \#5033 for $2.435.60 from Grande Pointe Towers was postdated and the discount period had expired. It was incorrectly entered with the discount on April 2. The cheque was not yet deposited, so you should reverse the receipt. Memo \#5 Dated April 8/24 From Owner: Change the payment terms for Grande Pointe Towers to net 30. Notify the customer of the outstanding charges and the changes in payment terms. Memo \#6 Dated April 8/24 From Owner: The work done for Hazel Estates included $1600 plus $80 GST and $96 PST for replacement of damaged microinverters. The revised and correct invoice total is $3 108. Adjust invoice #712 to add the extra amount. MasterCard Sales Invoice \#714 Dated April 9/24 To Vinod Residence (use Full Add for the new customer), 5600 plus $30 CST and $36 PST for repairs. Invoice total $666 paid in full by MasterCard. Receipt \#202 Dated April 10/24 From Selkirk Community Centre, chegue $533 for $7978.02 including Chapter 7: Air Care Services: Receivables \& Payables Setup Memo \#6 Dated April 8/24 From Owner: The work done for Hazel Estates included $1600 plus $80 GST and $96 PST for replacement of damaged microinverters. The revised and correct invoice total is \$3 108. Adjust invoice \#712 to add the extra amount. MasterCard Sales Invoice \#714 Dated April 9/24 To Vinod Residence (use Full Add for the new customer), $600 plus $30 GST and $36 PST for repairs. Invoice total $666 paid in full by MasterCard. Receipt \#202 Dated April 10/24 From Selkirk Community Centre, cheque #533 for $7978.02, including $1978.02 in full payment of invoice \#710 with $19.98 discount for early payment, and $6000 in partial payment of invoice \#711. Purchase Invoice \#GE-2579 Dated April 10/24 From Green Earth Products Inc, $14000 plus $700 CST for microinverters. Invoice total $14700. Terms: 1/10, n/30. Store as a bi-weekly recurring entry. Cash Purchase Invoice twW-6913 Dated April 11/24 From Westrock Insurance (use Quick Add), $185 per month for a one-year car insurance policy with $2000000 liability coverage and $4000 deductible. Terms: first month payable in advance on acceptance of quote followed by monthly instalments at the end of each month. Pay first month's premium of $185 in advance. Issue cheque \#103. Store as a recurring monthly transaction. Meme \#7 Dated April 11/24 Recall the stored entry for car insurance from Westrock Insurance to enter a postdated payment for next month's premium of \$185. Issue cheque 1104 postdated for May 11. After posting recall the entry again and make a postdated payment for the premium due June 11 with cheque \#105. Payment Cheque \#106 Dated April 14/24 To Green Earth Products Inc, $14560 in payment of account, induding $140 discount for early payment. Reference invoice \#CE-2579. Receipt \#203 Dated April 14/24 From Selkirk Community Centre, cheque \#586 for $13780.20 in payment of account, including \$199.80 discount for early payment. Reference invoice \#711. SESSION DATE - APRIL 21, 2024 Bank Debit Memo \#35589 Dated April 15/24 From Flatlands Credit Union, cheque \#12488 for \$19 778 from Regina School Board has been returned because of non-sufficient funds. Enter a negative receipt to record the NSF cheque. Notify the customer of the outstanding charges. Cash Purchase Invoice \#SAA-1098 Dated April 15/24 From Starbuck Advertising Agency, \$1 100 plus $55 GST and \$66 PST for flyers on clean energy alternatives. Create new Group expense account: 5230 Promotion Expenses. Invoice total $1221. Paid by cheque \#107. Receipt \#204 Dated April 15/24 From Hazel Estates, cheque \#230 for $3076.92 in full payment of account, including $31.08 discount for early payment. Reference adjusted invoice \#712. Cash Purchase Invoice \#FX-3467 Dated April 16/24 From FedEx (use Quick Add for the new supplier), $460 for special delivery of solar panels plus $23 GST. Invoice total \$483. Issued cheque \#108 in full payment. Create new Group account 5220 Delivery Expenses. Payment Cheque \#109 Dated April 16/24 To Wheatfields Hardware, $1665 in payment of account. Reference invoice \#WH-42001. Payment Cheque \#109 Dated April 16/24 To Wheatfields Hardware, \$1 665 in payment of account. Reference invoice \#WH-42001. Cash Purchase Invoice \#SEC-44371 Dated April 19/24 From Saskatchewan Energy Corp., $200 plus $10 GST for two months of hydro service. Invoice total $210. Paid by cheque \#110. Cash Purchase Invoice \#SKT-36128 Dated April 19/24 From Saskatel, $330 plus $16.50 GST and \$19.80 PST for telephone, cellular and Internet senvice. Invoice total $366.30. Paid by cheque \#111. Cash Purchase invoice \#SKT-36128 Dated April 19/24 From Saskatel, $330 plus $16.50 GST and $19.80 PST for telephone, cellular and Internet service. Invoice total $366.30. Paid by cheque \#111. SESSION DATE - APRIL 30, 2024 Purchase Invoice \#W-3468 Dated April 22/24 From Willow Garage, $120 including taxes (use tax code IN) for gasoline for van. Terms: net 30. Recall stored entry and edit the date. Purchase Invoice \#GE-4906 Dated April 24/24 From Green Earth Products Inc., $14000 plus $700 GST for microinverters. Invoice total $14700. Terms: 1/10,n/30. Recall stored entry. Purchase Invoice \#KE-1679 Dated April 25/24 From Killarney Solar Equipment, $30000 plus $1500 GST for solar panels. Invoice total $31500. Terms: 1/5,n/30. Sales Invoice \#77 Dated April 25/24 To Grande Pointe Towers, $24000 for new subcontracting job, plus $1200 CST and $1440 PST. Invoice total $26 640. Terms: net 1. Grande Pointe Towers has provided a certified cheque in full payment of their account. Grande Pointe Towers. 77 LaPointe Cr. White City. SK SOG 5B0 Tel: (306) 322-7500 Pin - Thirty thousand eight hundred forty dollars 00 s 30,840= Tomin Ar Care Servicen onning of Deg Belair Ave. Unit 25 Regina, SK S4T 4 U2 rit x+06 suade 29294946771654 Bank Debit Memo \#55131 Dated April 30/24 38 From Flatlands Credit Union, pre-authorized monthly payroll for employees. Wages and payroll expenses Payroll services fee GST paid on payroll service Total withdrawal $780010057905 MHFO Servicesos aireare. eom clean energy for a better future New expense account required: 5170 Electrical Parts Used New expense account required: 5170 Electrical Parts Used Authorization SAAquil 30/24 Chapter 7: Air Care Services: Recelvables \& Payables Setup APTER 7 ESSION DATE - MAY 1,2024 Memo \#9 Dated May 1/24 From Owner: Received monthly statements showing missing historical information. The statement from Wheatfields Hardware included an overdue amount of \$1 100 from invoice \#WH-20001 dated March 24, 2024. The statement from Starbuck Advertising Agency included an overdue amount of $2200 from invoice \#SAA-987 dated March 14, 2024. Add the historical invoices for these two transactions in the Supplier Ledger records as historical transactions. You can open the Payables module window or use the View Suppliers shortcut to access the records for these suppliers. Pay these two invoices in the Payments Joumal as current transactions dated May 1 using cheques \#112 and #113. Memo \#10 Dated May 1/24 Check the data integrity (Maintenance menu) after entering the historical invoices. Make a backup copy of the data files and finish entering the history. Choose the History menu in the Home window and click Finish Entering History. Memo \#11 Dated May 1/24 From Owner: Print or preview customer statements. One invoice for Regina School Board is overdue. Complete sales invoice \#718 for Regina School Board for $29.39, the interest charges on the overdue amount. Terms: net 15 days, Use the No Tax code for the interest charges and choose Interest Revenue as the account. Remember to remove the early payment discount. TRIAL BALANCE AIR CARE SERVICES Manch31,204 Check Figures: Income Statement Total Revenue =$82,278.53, Total Expenses =$68,576.09, Net Income =$13,702.44 Net GST collected from revenue less paid on expenses =$1,029.68 Janiary I to March 31, 2024 AIR CARE SERVICES

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

Step: 3

blur-text-image

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

A Guide To Project Auditing

Authors: Association For Project Management

1st Edition

1903494745, 978-1903494745

More Books

Students also viewed these Accounting questions