25 AR CARE SERVICES - RECEIVABLES & PAYABLES SETUP for vi Acro to po B you the the Un DU C QU SOURCE DOCUMENTS SESSION DATE - APRIL 7, 2021 Dated April 1/21 Meme 1 Create shortcuts for General Joumal entries, purchase invoices, pay expenses (other payments) and pay invoices, the journals used in this chapter. Sales Invoice 710 Dated April 1/21 To Selkirk Community Centre, S1 800 plus $90 GST and 5108 PST for removing and reapplying solar panels for roof replacement. Invoice total 51 998. Terms: 1/10,n/30 Create new Group account 4120 Repairs Revenue. Receipt 8200 Dated April 2/21 From Grande Pointe Towers, cheque #5033 for 52 435.60, including 51 935.60 in full payment of invoice +699 and 5500 in partial payment of invoice #703, and allowing 544,40 discount for early payment. Customize the journal by changing the tabbing order so that the cheque number follows the customer number. Purchase invoice WWW-42001 Dated April 3/21 From Wheatfields Hardware, 51 500 plus $75 GST and $90 PST for new ladders and other tools. Invoice total $1 665. Terms: net 15. Payment Cheque #101 Dated April 4/21 To Beausejour Electrical Products, $10 760 in payment of account, including $140 discount for early payment. Reference invoices #8-894 and B-921. Payment Cheque #102 Dated April 4/21 To Killarney Solar Equipment, 900 in payment of invoice KS-1031. Sales Invoice #711 Dated April 5/21 To Selkirk Community Centre, $18 000 plus $900 GST and $1080 PST for installing additional solar panels. Invoice total $19 980. Terms: 1/10,n/50. Meme 2 Dated April 6/21 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. The description is not included, so you must add it. Memo #3 Dated April 6/21 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/21 10 From Willow Garage, 5120 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/21 11 From Regina School Board, cheque *12488 for $19 778 including $222 discount for early payment. Reference invoice #701. Sales Invoice W712 12 To Hazel Estates (use Full Add for the new customer). 51 200 plus 560 GST and 572 PST for a one-year service contract. Invoice total $1 332. Terms: 1/10, 1/30. C Dated April 7/21 CHAPTER Dated April 7/21 13 Visa Sales Invoice #713 Sales Summary To various one-time customers Repairs revenue Service contract revenue GST charged PST charged Total deposited to Visa bank account 53 600 2 800 320 384 $7 104 15 16 17 SESSION DATE - APRIL 14, 2021 Bank Debit Memo #14321 Dated April 8/21 From Flatlands Credit Union, cheque #5033 for $2 435.60 from Grande Pointe Towers has been returned because of non-sufficient funds. Reverse the payment and notify the customer of the outstanding charges. Memo #4 Dated April 8/21 From Owner: Change the payment terms for Grande Pointe Towers to net 1. Certified cheques will be requested in the future. Set the credit limit to zero. Memo #5 Dated April 8/21 From Owner: The work done for Hazel Estates included 51 600 plus 580 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/21 To Vinod Residence (use Full Add for the new customer), 5600 plus $30 GST and $36 PST for repairs. Invoice total 5666 paid in full by MasterCard. Receipt #202 Dated April 10/21 From Selkirk Community Centre, cheque #533 for 57 978.02, including $1978.02 in full payment of invoice #710 with $19.98 discount for early payment, and 56 000 in partial payment of invoice #711. Purchase Invoice #GE-2579 Dated April 10/21 From Green Earth Products Inc., 514 000 plus 5700 GST for microinverters. Invoice total 514 700. Terms: 1/10, 1/30. Store as a bi-weekly recurring entry. Cash Purchase Invoice #W1-6913 Dated April 11/21 From Westrock Insurance (use Quick Add). S185 per month for a one-year car insurance policy with $2 000 000 liability coverage and 54 000 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. Memo #6 18 19 20 21 Dated April 11/21 Recall the stored entry for car insurance from Westrock Insurance to enter a postdated payment for next month's premium of $185. Issue cheque #104 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/21 To Green Earth Products Inc, 514 560 in payment of account, including $140 discount for early payment. Reference invoice #GE-2579. 22 23 Receipt #203 Dated April 14/21 From Selkirk Community Centre, cheque #586 for $13 780.20 in payment of account, including $199.80 discount for early payment. Reference invoice #711. SESSION DATE - APRIL 21, 2021 Bank Debit Memo #35589 Dated April 18/21 24 From Flatlands Credit Union, cheque #12488 for $19 778 from Regina School Board has been returned because of non-sufficient funds. Reverse the payment and notify the customer of the outstanding charges. Cash Purchase Invoice #SAA-1098 Dated April 15/21 25 From Starbuck Advertising Agency, S1 100 plus $55 GST and $66 PST for flyers on clean energy alternatives. Create new Group expense account: 5230 Promotion Expenses. Invoice total $1 221. Paid by cheque #107. Receipt #204 Dated April 15/21 26 From Hazel Estates, cheque #230 for $3 076.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/21 27 From FedEx (use Quick Add for the new supplier), S460 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/21 To Wheatfields Hardware, $1 665 in payment of account. Reference invoice #WH-42001. N ch the purc 28 29 AirCare Services YO default Banque lovelice 715 Date: April 19, 2021 Seld to: Oak Bluff Banquet Hall (Ann Oakley) aircare.com clean energy for better future 4 Celebration Ave. 100 Belair Ave, Unit 25 Regina, SK S4V 3H7 Regina, SK SITUZ Phone: (06) 456-1209 Toll free (5) 455-7194 Fax: (06) 456JIS Description Tax Code Amount Installation of additional solar panels GP 20 000.00 Adjustments to older solar panels GP 2 000.00 Authorizations to encued oredet limit: Siren later Customer Initials Interest at 1.5% charged on accounts over 30 days. Payment Terms 1/10, net 30 GSTU766457 GST 1 100.00 PST 1 320.00 A0 TOTAL 24 420.00 256 CHAPTER 30 Cash Purchase Invoice #SEC-44371 Dated April 19/21 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/21 From Saskatel, 5330 plus $16.50 GST and $19.80 PST for telephone, cellular and Internet service. Invoice total 5366.30. Paid by cheque #111. 31 32 AirCare Services levier Date Sold: 716 April 20, 2021 Sales Summary clean energy for better future RSK SATU Phone: 006) 456-130 Toll free (3) 456-7194 Fax (06) 456-3188 Te Code Ama GP GP 6 000.00 900.00 Installation upgrades Service contracts Deposited to Vida bank account April 20/21 Siren later GST Payment term: Customer Visa Credit Card Thank you. 345.00 414.00 7 659.00 Business Ne374457 TOTAL SESSION DATE - APRIL 30, 2021 Purchase Invoice #W-3468 Dated April 22/21 55 From Willow Garage, 8120 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/21 54 From Green Earth Products Inc, 514 000 plus $700 GST for microinverters. Invoice total 514 700. Terms: 1/10, n/30. Recall stored entry. Purchase Invoice #KE-1679 Dated April 25/21 55 From Killarney Solar Equipment, 30 000 plus 51 500 GST for solar panels. Invoice total $31 500. Terms: 1/5, n/30. Sales Invoice #717 Dated April 25/21 To Grande Pointe Towers, $24 000 for new subcontracting job, plus S1 200 GST and S1 440 PST. Invoice total s26 640. Terms: net 1. Grande Pointe Towers has provided a certified cheque in full payment of their account. Se 36 37 Grande Plate Temers 17 C White City, SK SOGBO Tel: 006) 323-7500 Date 26 2020 Thirty thousand eight hundred forty dollars 00 0,84 TO THE Air Care Services 100 Belair Ave. Unit 25 Regina, SK 54T 402 Sophie Deende $30,840.00 April 26, 2021 Mes certified cheque pays invoices -699, 703, 717 (receipt 1205) Bank Debit Memo #55131 Dated April 30/21 From Flatlands Credit Union, pre-authorized monthly payroll for employees. Wages and payroll expenses 57 000 Payroll services fee 100 GST paid on payroll service 5 Total withdrawal $7 105 Bank Debit Memo #56159 Dated April 30/21 From Flatlands Credit Union, pre-authorized withdrawals for service charges, mortgage and loan payments. Bank charges, including NSF cheques $ 120 Loan interest 125 Mortgage interest 1 775 Loan principal repayment 1 000 Mortgage principal repayment 500 39 MEMO 27 AirCare Services 2. Una S, Regina SK SATUR Date: April 30, 2021 Pross Simon Arturro Rei End of month adjustments needed Supplies used in April: Solar Panels $29 000 Inverters 24 200 Electrical Supplies 2 550 Office Supplies 150 New expense account required: 5170 Electrical Parts Used Authorization SA April 30/21 AIR CARE SERVICES - RECEN Grande Plate Towers 37 Date 31032016 Tel: 006) 323-7500 Thirty thousand eight hundred forty dollars Os 30,840 Pay Air Care Services 100 Belair Ave. Unit 25 Regina, SK 54T 402 Sophie Brands ----92999.77 LIL $30,840.00 Nec 14 April 26, 2021 Ret certified cheque pays invoices #699, 703, 717 (receipt #205) 30 Bank Debit Memo #55131 Dated April 30/21 From Flatlands Credit Union, pre-authorized monthly payroll for employees. Wages and payroll expenses 57 000 Payroll services fee 100 GST paid on payroll service 5 Total withdrawal $7 105 Bank Debit Memo #56159 Dated April 30/21 From Flatlands Credit Union, pre-authorized withdrawals for service charges, mortgage and loan payments. Bank charges, including NSF cheques $ 120 Loan interest 125 Mortgage interest 1 775 Loan principal repayment 1 000 Mortgage principal repayment 500 39 MEMO.7 AirCare Services 40 BUS. Regina SK SATUR Datei From: Re: April 30, 2021 Simon Arturo End of month adjustments needed Supplies used in Aprili Solar Panels Inverters Electrical Supplies office Supplies $29 000 24 200 2 550 150 New expense account required 5170 Electrical Parts Used Authorization SA April 30/21 ay las 41 reminds ger here is -refer se historical its as will be ry SESSION DATE - MAY 1, 2021 Memo #8 Dated May 1/21 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, 2021. The statement from Starbuck Advertising Agency included an overdue amount of $2 200 from invoice #SAA-987 dated March 14, 2021. 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 Journal as current transactions dated May 1 using cheques #112 and #113. Memo #9 Dated May 1/21 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 #10 Dated May 1/21 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. you torical 43 REVIEW The Student DVD with Data Files includes Review Questions and Supplementary Cases for this chapter.