Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

For Wahlen/jones/pagachs Intermediate Accounting Reporting And Analysis, , 2 Terms

Authors: James M. Wahlen, Jefferson P. Jones, Donald Pagach

2nd Edition

1305405676, 9781305405677

More Books

Students also viewed these Accounting questions

Question

Is there anything else you would like us to know about you?

Answered: 1 week ago