With the following data as on May , prepare Trial balance , bank reconcilation, Cash payment Register, Cash receipt register, Inventory ledger, AP and AR ledger and all neccessary journal entries as on 30th June. All info as as on May is given along with june transactions and closing adjustment entries , there are two products which penny sells.
Schedule of Accounts Receivable at 31 May 2019 Acc No Account 101 B Studley Amount 102 T Liner 7 250 103 B Winder 4 277 2 055 13 582 Schedule of Accounts Payable at 31 May 2019 Acc No Account 201 L Sheets Amount 202 C Woolley 5 618 203 S Satin 5 557 5 360 16 535 Inventory Subsidiary Ledger at 31 May 2019 Item No Product Name Units Unit Cost 5001 42 Amount Country Garden Quilt 245 5002 0 290 Crazy Patchwork Quilt 39 1 12 368 4 658 The May Bank Reconciliation Statement is as follows: Penny's Patchworks Bank Reconciliation Statement Balance as per Bank Statement As at 31 May 2019 Add Outstanding Deposit 76 645 Cr 2 940 79 585 Less Unpresented cheques No 491 No 500 3 125 480 No 502 1 450 5 055 Balance as per Cash at Bank Account 74 530 Dr The Trial Balance as at 31 May 2019 prepared by the old bookkeeper is as follows: Account Name Acc No Debit Credit Cash at Bank 1 - 74 530 Accounts Receivable Control 100 1- 13 582 Allowance for Doubtful Debts 1104 I- 565 Inventory Control 105 1- 14 658 Packaging Materials 115 1- 2480 Prepaid Insurance 212 I- 1 890 Warehouse Fixtures and Fittings 2125 1- 42 000 3175 Accum Depn - Warehouse Fixtures and Fittings 1- 15 000 Delivery Truck 3176 65 000 Accum Depn - Delivery Truck 3180 1- 47 000 3181 1Accounts Payable Control 2- 16 535 1200 Accrued Expense Payable 2- 215 P White, Capital 3- 120 600 1300 P White, Drawings 3- 48 205 1310 Profit and Loss Summary 3- 9000 Sale 4- 165 244 1000 Sales Returns and Other Allowances 4- 410 1005 Interest Revenue 4- 130 3410 Discount Received 4- 74 3420 Cost of Goods Sold 5- 79 540 1000 Salaries and Wages Expense 6- 17 350 2540 Telephone and Internet Expense 6- 2 145 2545 Electricity Expense 6- 3 035 2547 Insurance Expense 6- 2550 Packaging Materials Expense 6- 2556 Depn Expense - Warehouse Fixtures and Fittings 6- 2563 Depn Expense - Delivery Truck 6- 2564 Bank Fee Expense 6- 205 3580 Bad Debts Expense 6- 3590 Discount Allowed 6- 1 18 3595 $365 148 $365 148 Penny received the following bank statement from her bank for the month of June. Penny's Patchworks National Park Bank A/c No 2350 BANK STATEMENT Date Particulars 2019 Debits Credits Balance S S $ June 1 Balance forward 76 645 Cr Cash and cheques 2 940 79 585 Cr Cash and cheques 2 000 81 585 Cr 2 Cash and cheques 2 160 3 745 Cr 3 Cheque 505 5 092 78 653 Cr 9 Cash and cheques 7 170 85 823 Cr 11 Account Fee 55 85 768 Cr 12 Cheque 502 1 450 84 318 Cr Cheque 503 2 472 81 846 Cr 16 Returned Cheque (B Winder) 2 000 79 846 Cr Cash and cheques 4 500 84 346 Cr 19 Interest Earned 42 84 388 Cr 19 Cheque 509 670 83 718 Cr 2