Question
Review of COMPANY, RECEIVABLES, PAYABLES, INVENTORY & SERVICES modules and Reconciliation & Deposits.Engine Repairs Ltd. is a service company that repairs and maintains small engines
Review of COMPANY, RECEIVABLES, PAYABLES, INVENTORY & SERVICES modules and Reconciliation & Deposits.Engine Repairs Ltd. is a service company that repairs and maintains small engines (lawn movers, garden tillers, small tractors, etc.). The manual accounting records were converted to Sage 50 Accounting using the following modules at May 31, 2023. GENERAL RECEIVABLES PAYABLESINVENTORY & SERVICESYou have assumed the position of Bank Reconciliation clerk as of June 30. The previous clerk did not record any bank activity for June 2023. 1 Refer to Exercise 1-1b, to unzip the TM-4 Engine exe file. 2 Open the TM-4 Engine file and accept the May 31, 2023 date. Note: Engine Repairs Ltd. does not print invoices or cheques. Sales terms, if any, are identified with Cash Receipts information. The owner of Engine Repairs Ltd. has asked you to:3 Set up the linking accounts for the Reconciliation & Deposits Journal for May 31 to June 30.4 Record the manual Cash Receipts Journal (containing bank account entries) as indicated next. Cheque Invoice Deposit Date Customer # # Amount Reason/ItemJun 01 Cotta Dairy Farm 2461210 $450.00Invoice in Receivable Jun 04 Debly's Dept Store1416198520.00Invoice in ReceivableJun 07 Villa Golf Course Ltd. 1976202 273.00Invoice in ReceivableJun 14 Chalmers Industrial 689211238.43SR $211.00 plus HST Jun 15 Cotta Dairy Farm2497212 211.88SR $187.50 plus HST Jun 21 Cotta Dairy Farm2536213 126.56SR $112.00 plus HST Jun 22 Villa Golf Course Ltd. 2016214 259.90SR $230.00 plus HST Jun 29 Chalmers Industrial 712 215 177.86 SR $157.40 plus HST 5 Record the manual Cash Disbursements Journal (containing bank account entries) as indicated next. Cheque Invoice Date Vendor # # AmountReason Jun 01 Brigs Engine Supplies 607 9653 $850.00Invoice in Payable Jun 04 Danco Parts Ltd.60898712320.00Invoice in Payable Jun 08 Jason Tools Ltd.6094152135.60Small tools $120.00 plus HST Jun 08 Peel County Telephone 610May/Tel254.25Telephone $225.00 plus HST Jun 11 Caledon Gas Company 611May/Gas361.60May/Gas $320.00 plus HST Jun 13 A-1 Properties Inc.612Jun Rent700.60Rent $620.00 plus HST Jun 15 Office Place Ltd.61314568 90.40Supplies Exp$80.00 plus HST Jun 18 Brigs Engine Supplies6149701237.30Small Tools $210.00 plus HST Jun 25 Danco Parts Ltd.61598879179.22Small Tools $158.60 plus HST
6Advance the date to June 30 and complete the June 30th bank reconciliation. Prepare and post journal entries as required. Relevant information is presented below. a) May 31 bank reconciliation.The bank reconciliation at May 31, 2023 is as follows:Balance per Bank Statement May 31, 2023$4,238.75Add: Outstanding Deposit May 31 415.00Sub-total$4,653.75Less: Outstanding cheques #598$312.00 #604$211.86$ 523.86Balance per Bank Account and General Ledger May 31, 2023$4,129.89b) June 30 bank statement as follows:CBCommercial Bank51Centennial Road, Orangeville, Ontario L9W 3R1Engine Repairs Ltd.568 Northgate DriveOrangeville, OntarioL9W 2J5STATEMENT OF ACCOUNT0225-315544Date: June 1 June 30, 2023DATEDESCRIPTIONWITHDRAWALSDEPOSITSBALANCE Jun 1 Jun 1 Jun 1 Jun 1 Jun 6 Jun 6 Jun 6 Jun 8 Jun 11 Jun 11 Jun 13 Jun 14 Jun 14 Jun 15 Jun 18 Jun 18 Jun 22 Jun 22 Jun 27 Jun 27 Jun 29 Jun 29Balance forwardDepositCheque 604DepositDepositCheque 607Cheque 608DepositCheque 609Cheque 610Cheque 611DepositCheque 612DepositCheque 613Cheque 614DepositDepositCheque 615Cheque NSFService ChargeLoan Payment/Interest211.86850.00320.00135.60254.25361.60700.6090.40237.30179.22259.9011.80300.00415.00450.00520.00273.00238.43211.88126.56259.904,238.754,653.754,441.894,891.895,411.894,561.894,241.894,514.894,379.294,125.043,763.444,001.873,301.273,513.153,422.753,185.453,312.013,571.913,392.693,132.793,120.99
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started