The following bank statement was received. Prepare a bank reconciliation for October:

Photos - 300.PNG O + E 10 tz X .. Part 4 [50 points] ) The following bank statement was received. Prepare a bank reconciliation for October Bank Statement To: Barton Corporation October 31, 2015 , Cheques/Charges/Debits Deposits/Credits Balance 923,545.50 #2927 01/Oct 5.400 918, 145.50 #2928 03/Oct 471,500 03/Oct 30,850 477,495.50 NSF Cheque 06/Oct 22.404 455,091.50 10/Oct 3,891,580 4.346,671.50 #2929 15/Oct 50,000 15/Oct 3,649 4,300,320.50 #2930 18/Oct 8.400 4,291,920.50 #2931 18/Oct 556,500 3,735,420.50 20/Oct 35,750 3,771,170.50 22/Oct 1,740,970 5,512,140.50 #2933 26/Oct 5000 5,507 140.50 #2934 26/Oct 788,900 4,718,240.50 Service Charge 31/Oct 900 4,717,340.50 Additional Information. The NSF cheque was received in September from ABC Inc. for a sale dated September 15. Prepare the nequited trial balance at Odber 31, 2015 NOTE: Do notice bene account Barton Corporation Undsted Tw Bulance October 31, 2015 Dube Cas 1,50522250 Accountable 961 400 Allowance for 1300 Notes receivable 78.326 Merchandise 1.826,300 Prepaid insurance 35.000 Office future 8.400 ACCO payable Commons Rewed Cash did edird 23.00 Interested Sales Sales de 43472 Cost of good old 1.100.100 Office 22.000 i.com internation 320.000 79.250 2.060,000 23750 3.136.000 # Sales les espere Hent sponse, office space 3.240 Rent pane, aling pace 2.180 Loss on sale of property plant and equipments 49 Tote 5.579.417.50 6.570.41750 Barton Corporation Bank Reconciliation October 31, 2015 Book balance. Add: + 5,579,417.50 Bank statement balance Add: Deduct: + = Outstanding cheques Deduct: + = Adjusted bank balance Adjusted book balance b) Prepare the appropriate adjusting entries on October 31, 2015. Hint: Some additional information is provided below but where else might you look to find details relevant to preparing the adjusting entries? It is estimated that utilities used during October totalled $3,850 Actual count of ending merchandise inventory on October 31, 2015 was $1,643,670 Management estimates uncollectible accounts receivable based on the following rates of uncollectibility applied to outstanding accounts: Not yet due (2%), 1-30 days past due (9%), 31-60 days past due (18 Income taxes are estimated to be $244 200 General Journal Account/Explanation Page Gj1 General Journal Account/Explanation Date F Debit Credit Date Page Gj2 F Debit Credit +-1 + - + = + - + - + = + = + Credit 1) The following bank statement was received. Prepare a bank reconciliation for October Bank Statement To: Barton Corporation October 31, 2015 Cheques/Charges/Debits Deposits/Credits Balance 923,545,50 #2927 01/Oct 5,400 918 145 50 #2928 03/Oct 471,500 03/Oct 30,850 477,495,50 NSF Cheque 06/Oct 22,404 455 091.50 10/Oct 3,891,580 4.346,671.50 #2929 15/Oct 50,000 15/Oct 3,649 4.300,320.50 #2930 18/Oct 8,400 4.291,920.50 #2931 18/Oct 556 500 3.735,420.50 20/Oct 35,750 3.771,170.50 22/Oct 1,740,970 5,512,140.50 #2933 26/Oct 5,000 5.507,140.50 #2934 26/Oct 799.900 4.718,240.50 Service Charge 31/Oct 900 4.717,340.50 Additional Information: The NSF cheque was received in September from ABC Inc for a sale dated September 15, a) Prepare the unadjusted trial balance at October 31, 2015. NOTE: Do not include balance accounts. Barton Corporation Unadjusted Trial Balance October 31, 2015 Debit Cash 1,165,222 50 Accounts receivable 981,400 Allowance for doubtful accounts 133,308 Notes receivable 78,326 Merchandise inventory 1,826,300 Prepaid insurance 35,000 Office furniture 8,400 Accounts payable Common shares Retained earnings Cash dividends declared Interest eamed Sales Sales discounts 43,472 Cost of goods sold 1,199, 100 Office salaries expense 22,000 Milyry.com student-serviets Case Study Servietid=11138 320,000 73.250 2,050.930 23,000 237.50 3,135,000 Barton Corporation Bank Reconciliation October 31, 2015 Book balance Add: + - 5,579,417 50 Bank statement balance Add 2:22.9.42 PM Case Study Part 3 Soon-LY Sales salaries expense- 78,000 Rent expense, office space 3,240 Rent expense, selling space 2,160 Loss on sale of property, plant and equipment assets 489 Totals 5,579,417 50 5,579,417.50 Deduct Deduct Outstanding cheques + = Adjusted bank balance Adjusted book balance ) Prepare the appropriate adjusting entries on October 31, 2015. Hint: Some additional information is provided below but where else might you look to find details relevant to preparing the adjusting entries? It is estimated that utilities used during October totalled $3,850, . $ Actual count of ending merchandise inventory on October 31, 2015 was $1,643 670 Management estimates uncollectible accounts receivable based on the following rates of uncollectibility applied to outstanding accounts: Not yet due (2%), 1-30 days past due (9%), 31-60 days past due (18 Income taxes are estimated to be $244.200 Date General Journal Account/Explanation Page Gj1 F Debit Credit General Joumal Account/Explanation Page 2 F Debit Credit Date + = +-1 + + - + - + = Photos - 300.PNG O + E 10 tz X .. Part 4 [50 points] ) The following bank statement was received. Prepare a bank reconciliation for October Bank Statement To: Barton Corporation October 31, 2015 , Cheques/Charges/Debits Deposits/Credits Balance 923,545.50 #2927 01/Oct 5.400 918, 145.50 #2928 03/Oct 471,500 03/Oct 30,850 477,495.50 NSF Cheque 06/Oct 22.404 455,091.50 10/Oct 3,891,580 4.346,671.50 #2929 15/Oct 50,000 15/Oct 3,649 4,300,320.50 #2930 18/Oct 8.400 4,291,920.50 #2931 18/Oct 556,500 3,735,420.50 20/Oct 35,750 3,771,170.50 22/Oct 1,740,970 5,512,140.50 #2933 26/Oct 5000 5,507 140.50 #2934 26/Oct 788,900 4,718,240.50 Service Charge 31/Oct 900 4,717,340.50 Additional Information. The NSF cheque was received in September from ABC Inc. for a sale dated September 15. Prepare the nequited trial balance at Odber 31, 2015 NOTE: Do notice bene account Barton Corporation Undsted Tw Bulance October 31, 2015 Dube Cas 1,50522250 Accountable 961 400 Allowance for 1300 Notes receivable 78.326 Merchandise 1.826,300 Prepaid insurance 35.000 Office future 8.400 ACCO payable Commons Rewed Cash did edird 23.00 Interested Sales Sales de 43472 Cost of good old 1.100.100 Office 22.000 i.com internation 320.000 79.250 2.060,000 23750 3.136.000 # Sales les espere Hent sponse, office space 3.240 Rent pane, aling pace 2.180 Loss on sale of property plant and equipments 49 Tote 5.579.417.50 6.570.41750 Barton Corporation Bank Reconciliation October 31, 2015 Book balance. Add: + 5,579,417.50 Bank statement balance Add: Deduct: + = Outstanding cheques Deduct: + = Adjusted bank balance Adjusted book balance b) Prepare the appropriate adjusting entries on October 31, 2015. Hint: Some additional information is provided below but where else might you look to find details relevant to preparing the adjusting entries? It is estimated that utilities used during October totalled $3,850 Actual count of ending merchandise inventory on October 31, 2015 was $1,643,670 Management estimates uncollectible accounts receivable based on the following rates of uncollectibility applied to outstanding accounts: Not yet due (2%), 1-30 days past due (9%), 31-60 days past due (18 Income taxes are estimated to be $244 200 General Journal Account/Explanation Page Gj1 General Journal Account/Explanation Date F Debit Credit Date Page Gj2 F Debit Credit +-1 + - + = + - + - + = + = + Credit 1) The following bank statement was received. Prepare a bank reconciliation for October Bank Statement To: Barton Corporation October 31, 2015 Cheques/Charges/Debits Deposits/Credits Balance 923,545,50 #2927 01/Oct 5,400 918 145 50 #2928 03/Oct 471,500 03/Oct 30,850 477,495,50 NSF Cheque 06/Oct 22,404 455 091.50 10/Oct 3,891,580 4.346,671.50 #2929 15/Oct 50,000 15/Oct 3,649 4.300,320.50 #2930 18/Oct 8,400 4.291,920.50 #2931 18/Oct 556 500 3.735,420.50 20/Oct 35,750 3.771,170.50 22/Oct 1,740,970 5,512,140.50 #2933 26/Oct 5,000 5.507,140.50 #2934 26/Oct 799.900 4.718,240.50 Service Charge 31/Oct 900 4.717,340.50 Additional Information: The NSF cheque was received in September from ABC Inc for a sale dated September 15, a) Prepare the unadjusted trial balance at October 31, 2015. NOTE: Do not include balance accounts. Barton Corporation Unadjusted Trial Balance October 31, 2015 Debit Cash 1,165,222 50 Accounts receivable 981,400 Allowance for doubtful accounts 133,308 Notes receivable 78,326 Merchandise inventory 1,826,300 Prepaid insurance 35,000 Office furniture 8,400 Accounts payable Common shares Retained earnings Cash dividends declared Interest eamed Sales Sales discounts 43,472 Cost of goods sold 1,199, 100 Office salaries expense 22,000 Milyry.com student-serviets Case Study Servietid=11138 320,000 73.250 2,050.930 23,000 237.50 3,135,000 Barton Corporation Bank Reconciliation October 31, 2015 Book balance Add: + - 5,579,417 50 Bank statement balance Add 2:22.9.42 PM Case Study Part 3 Soon-LY Sales salaries expense- 78,000 Rent expense, office space 3,240 Rent expense, selling space 2,160 Loss on sale of property, plant and equipment assets 489 Totals 5,579,417 50 5,579,417.50 Deduct Deduct Outstanding cheques + = Adjusted bank balance Adjusted book balance ) Prepare the appropriate adjusting entries on October 31, 2015. Hint: Some additional information is provided below but where else might you look to find details relevant to preparing the adjusting entries? It is estimated that utilities used during October totalled $3,850, . $ Actual count of ending merchandise inventory on October 31, 2015 was $1,643 670 Management estimates uncollectible accounts receivable based on the following rates of uncollectibility applied to outstanding accounts: Not yet due (2%), 1-30 days past due (9%), 31-60 days past due (18 Income taxes are estimated to be $244.200 Date General Journal Account/Explanation Page Gj1 F Debit Credit General Joumal Account/Explanation Page 2 F Debit Credit Date + = +-1 + + - + - + =