Do not give answer in image formate Question 2The Bank Statement and Cash Book (bank columns only) for Austin Cambridge for the month ofMarch 2023 are as follows.DATE14-Mar20-Mar25-MarDATE1-Mar3-Mar 6500DETAILSBalance14-Mar Deposit18-Mar Bank charges20-Mar Deposit22-Mar 650124-Mar Auto debitBANK STATEMENTDR25-Mar Deposit25-Mar Deposit26-Mar Credit transfer25-Mar30-Mar31-Mar Balance c/d28-Mar ZIP#5485-FJ30-Mar 6511DETAILSCheque H. FlintCash SalesCheque Q. JacksonCheque R. BottomCheque S. M. Mane600AMT (S)8401,4001,640484784365,18496888404001,620CASHBOOKCR8401,4001,640484100BAL228 O/D828 O/D1284 O/D1,3164283882,0282,5122,6122,212592DATE1-Mar3-Mar Maintenance (6500)22-Mar Electricity (6501)DETAILSBalance b/d23-Mar Purchases (6505)30-Mar Rent (6511)30-Mar Wages (6515)AMT (S)2286008881,6601,6201885,184a) Prepare the updated Cash book to show the adjusted balance.b) Starting with the updated cash book balance, draw up a bank reconciliation statementfor Austin Cambridge for the month of March 2023.

Ideally balance as per cashbook must reconcile with balance as per bank statement. In case of any…

Question 2 The Bank Statement and Cash Book (bank columns only) for Austin Cambridge for the month of March 2023 are as follows. DATE 1-Mar 3-Mar 6500 14-Mar Deposit 18-Mar Bank charges Balance DETAILS 20-Mar Deposit 22-Mar 6501 DETAILS Cheque H. Flint BANK STATEMENT DR 24-Mar Auto debit 25-Mar Deposit 25-Mar Deposit 26-Mar Credit transfer 28-Mar ZIP#5485-FJ 30-Mar 6511 DATE 14-Mar 20-Mar Cash Sales 25-Mar Cheque Q. Jackson 25-Mar Cheque R. Bottom 30-Mar Cheque S. M. Mane 31-Mar Balance c/d AMT (S) 840 1,400 1,640 484 600 784 36 5,184 96 888 40 CASHBOOK 400 1,620 CR BAL 840 1,400 1,640 484 100 228 O/D 828 O/D 12 84 O/D 1,316 428 388 2,028 2,512 2,612 2,212 592 DATE 1-Mar Balance b/d DETAILS 3-Mar Maintenance (6500) 22-Mar Electricity (6501) 23-Mar Purchases (6505) 30-Mar Rent (6511) 30-Mar Wages (6515) AMT (S) 228 600 888 1,660 1,620 188 5,184 a) Prepare the updated Cash book to show the adjusted balance. b) Starting with the updated cash book balance, draw up a bank reconciliation statement for Austin Cambridge for the month of March 2023.

Question 2 The Bank Statement and Cash Book (bank columns only) for Austin Cambridge for the month of March 2023 are as follows. DATE 1-Mar 3-Mar 6500 14-Mar Deposit 18-Mar Bank charges Balance DETAILS 20-Mar Deposit 22-Mar 6501 DETAILS Cheque H. Flint BANK STATEMENT DR 24-Mar Auto debit 25-Mar Deposit 25-Mar Deposit 26-Mar Credit transfer 28-Mar ZIP#5485-FJ 30-Mar 6511 DATE 14-Mar 20-Mar Cash Sales 25-Mar Cheque Q. Jackson 25-Mar Cheque R. Bottom 30-Mar Cheque S. M. Mane 31-Mar Balance c/d AMT (S) 840 1,400 1,640 484 600 784 36 5,184 96 888 40 CASHBOOK 400 1,620 CR BAL 840 1,400 1,640 484 100 228 O/D 828 O/D 12 84 O/D 1,316 428 388 2,028 2,512 2,612 2,212 592 DATE 1-Mar Balance b/d DETAILS 3-Mar Maintenance (6500) 22-Mar Electricity (6501) 23-Mar Purchases (6505) 30-Mar Rent (6511) 30-Mar Wages (6515) AMT (S) 228 600 888 1,660 1,620 188 5,184 a) Prepare the updated Cash book to show the adjusted balance. b) Starting with the updated cash book balance, draw up a bank reconciliation statement for Austin Cambridge for the month of March 2023.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter5: Internal Control And Cash

Section: Chapter Questions

Problem 5.4.3P

See similar textbooks

Similar questions

lemic Calendar My MCBS Library English (en) - ndamentals of Financial Accounting Summer Session 12021/ACT 140/D2 / Final Examination/ AC In a bank reconciliation statement, explain. A. Non-sufficient-funds (NSF) check B. What is a deposit in transit? A BI - mcbs.proctoring.online is sharing your screen. Stop 11
Problem 17: Use the following information for the next five questions: Sky Blue Corporation's bank account for May and June of 2021, were as follows: May data are as follows: Balance per bank, May 31 Balance per books, May 31 Deposits in transit Checks outstanding Bank service charge 10,500 11,864 1,500 150 14 June data are as follows: Bank Books Receipts Deposits recorded Deposits received Collection by bank (P2,000 noteplus interest) Disbursements Checks issued and recorded Checks paid Service charges recorded Check payment for utilities erroneously charge by the bank against the account of Royal Blue Company on June 30 9,000 8,100 2,100 11,800 11,500 12 14 50 47. How much is the correct disbursements for the month of June? 48. How much is the correct receipts for the month of June? 49. How much is the correct cash balance for the month of June? 50. How much is the correct cash balance for the month of May? 51. How much is cash shortage/ (overage)? 52. Prepare adjusting entries, if…
Given this book and bank statement information, create an October bank reconciliation for Arrowhead company. And the journal entries required for the book side. BOOK INFO: Cash Date Debit Credit Balance 10/1/2020 Beginning Balance 8,259.86 10/1/2020 Ck 10102 Accounts Payable 1,374.12 6,885.74 10/2/2020 Ck 10103 Rent 3,420.00 3,465.74 10/2/2020 Ck 10104 Utilities 689.00 2,776.74 10/4/2020 Deposit 3,743.10 6,519.84 10/4/2020 Ck 10105 Advertising 344.21 6,175.63 10/4/2020 Ck 10106 Subscription 102.84 6,072.79 10/9/2020 Ck 10107 Internet 74.97 5,997.82 10/9/2020 Deposit 4,859.47 10,857.29 10/9/2020 Ck 10108 Telephone 221.00 10,636.29 10/9/2020 Deposit 11,339.64 21,975.93 10/12/2020 Ck 10109 Accounts Payable 1,680.00 20,295.93 10/13/2020 Ck 10110 Wages…
6. A portion of your bank statement is shown. Your previous balance was $228.73. What is your present balance Date Checks and Other Charges Number 13-Oct 18-Oct 143 27-Oct 144 31-Oct ATM AT-Phone Service Charge >>> Amount $43.60 112.76 10.64 50.00 5.14 Date Deposits and Credits Amount $146.90 188.42 135.65 5-Oct 12-Oct 19-Oct [ATM] Present Balance
The bank column in the cash book for Mac 2020 and the bank statement for that monthfor Keris Enterprise are as follows: Cash Book (Bank Account only) 2020 RM 2020 RMMac 16 Param 292 Mac 1 Balance b/d 4,20021 Joseph 369 6 Maria 18431 Opie 192 30 Melati 16031 Balance c/d 4,195 30 Suria 5045,048 5,048 Bank Statement Date Items Debit Credit BalanceMac 1 Balance 4,2008 Maria 184 4,38416 Cheque 292 4,09220 Melati 160 4,25221 Cheque 369 3,88331 Gigih Enterp : Trader’s credit 88 3,79531 TYF: standing order 32 3,82731 Bank charges 19 3,846 Required: b) Prepare the bank reconciliation statement as at 31 Mac 2020.
Epto Ergo’s bank statement from Crypto Bank at July 31, 2020, gives thefollowing information.Balance, July 1 $18,400 Bank debit memorandum:August deposits 71,000 Safety deposit box fee $ 25Checks cleared in July 68,678 Service charge 50Bank credit memorandum: Balance, July 31 20,692Interest earned 45A summary of the Cash account in the ledger for July shows the following:balance, July 1, $18,700; receipts $74,000; disbursements $73,570;and balance, July 31, $19,130.Analysis reveals that the only reconciling items on the June 30 bank reconciliation were adeposit in transit for $4,800 and outstanding checks of $4,500. In addition, you determine thatthere was an error involving a company check drawn in July: A check for $400 to a creditor onaccount that cleared the bank in July was journalized and posted for $40.Instructionsa) Determine deposits in transit.b) Determine outstanding checks. (Hint: You need to correct disbursements for thecheck error.)c) Prepare a bank reconciliation at July…
2. The bank column in the cash book for June 2020 and the bank statement for that month for Haris are as fllows: Cash Book (Bank Account only) 2020 1,410 June 5 Laila 12 Razi 2020 RM RM June 1 Balance b/d 7 Juju 180 62 519 16 Mei 75 16 Silvia 41 28 Fafau 224 29 Dovan 22 30 Gopal 582 1,591 2,353 31 Balance c/d 2,353 Bank Statement Debit Date Items June 1 Balance b/d 7 Cheque 8 Lily 16 Cheque Credit Balance 1,410 62 1,472 1,292 180 75 1,367 848 17 Razi 519 18 Silvia 41 807 28 Cheque 29 SLM Standing Order 224 1,031 979 52 30 Lisa : Trader's Credit 64 30 Bank charges 1,043 1,000 43 Required: a) Prepare the updated cashbook. b) Prepare the bank reconciliation statement as at 30 June 2020.
A -1 Prepared by Reviewed by William, Inc. Bank Confirmation - General Account December 31, 2022 Balance per Bank at December 31, 2022 $20,200.22 * Deposit in Transit - per A-1-2 2,000.00 # Outstanding Checks - per A-1-3 (5,200.00) Other - Note Collected by Bank (10,000.00) ^ Bank Service Charge (9.50) Balance per Books at December 31, 2022 $8,990.72 * f f Column footed. ^ Amount agrees to amount recorded as a deposit on the bank statement and description agrees with receipt enclosed with 12/31/22 bank statement. This note is the Kristopher note receivable that was recorded as a receipt by the client in the cash receipts journal on January 3, 2023. The receivable was appropriately credited and properly reflected in the January cash receipts journal. No adjustment needed as bank and books simply record this in different periods. #Agreed to December 31,…
Bank Reconciliation Statements lecture Homework #1 ZipFlyer Inc. 's cash T-Account for May shows the foliowing information: Cash Date Commenis Amount S13,846 1.550 2,700 Date Comments Amount Cheque 75 Cheque #76 Cheque 877 Cheque 78 Cheque #79 Cheque #80 Cheque #81 Cheque #82 Cheque #83 Cheque #84 Cheque #85 Cheque 486 Opening balance Deposit May ! May 3 May 1 May I May 3 May 15 May 21 Миу 31 5550 875 Deposit Deposit Deposit Deposit May 4 1,256 May 7 May 10 May 13 Миу 17 May 21 May 25 May 28 May 29 May 31 4.950 3.684 2.600 3,000 1,100 486 548 3,058 1,244 983 68 175 May 31 Ending Balance $14,619 The following comes from the company's April 2024 Bank Statement: Date Description Balance Forward Depasit Cheque #75 Depasit Cheque #77 NSF Cheque- W. White Cheque #76 Cheyue #78 Bank Collection Cheque #79 EFT - ltilities bill Deposit Cheque #80 Depasit EFT- Telephone Cheque #82 Cheque #83 Bank plan fee Withdrawals Deposits Balance $13846 15,396 14.846 17.546 16,290 15,690 April 30 Мay 2 May 3…
4. The bank column in the cash book for December 2020 and the bank statement for that month for King Trading are as follows: Cash Book (Bank Account only) 2020 RM 2020 RM Dec Dec 6 Peуpei Balance b/d 1,900 304 230 1 20 Ceria 265 10 Luna 31 Baiti 325 19 Wilson 261 31 Balance c/d 1,682 29 Cikmah 37 2,502 2,502 Bank Statement Date Items Debit Credit Balance 1,900 1,670 Dec 1 Balance 6 Cheque 230 1,974 1,709 13 Luna 304 20 Cheque 265 22 Wilson 30 Tox : Standing Order Rina : Trader's Credit 31 Bank charges 261 1,970 94 2,064 31 102 1,962 72 2,034 Required: a) Prepare the updated cashbook. b) Prepare the bank reconciliation statement as at 31 December 2020.
Ablema has provided you with the following bank statement and bank account details in respect of the month ended 31 January 2018. Statement date - 31 January, 2018. Account No 1452800 Date Particulars Debit Credit Balance GH¢ GH¢ GH¢ 01-Jan-18 Balance forward 67,580 Cr 06-Jan-18 Cheque 597 120 67,460 Cr 06-Jan-18 Direct debit 2,020 65,440 Cr 12-Jan-18 Credit transfer 4,660 70,100 Cr 13-Jan-18 Cheque 600 1,420 68,680 Cr 14-Jan-18 Cheque 601 12,028 56,652 Cr 16-Jan-18 Lodgement 9,000 65,652 Cr 19-Jan-18 Cheque 599 18,004 47,648 Cr 23-Jan-18 Bank charges for December 2017 422 47,226 Cr 25-Jan-18 Quarterly interest received 62 47,288 Cr 27-Jan-18 Dishonoured cheque 1,600 45,688 Cr 27-Jan-18 Cheque 598 26,090 19,598 Cr 30-Jan-18 Cheque 603 5,048 14,550 Cr 31-Jan-18 Lodgement 14,500 29,050 Cr 31-Jan-18 Standing order: rent first quarter 2018 27,000 2,050 Cr The books and records of Ablema show the followings transactions through the bank account for the month of January 2018: Date Receipts…
3. The bank column in the cash book for Mac 2020 and the bank statement for that month for Keris Enterprise are as follows: Cash Book (Bank Account only) 2020 RM 2020 RM 292 Mac 1 Balance b/d 6 Maria Mac 16 Param 4,200 21 Joseph 31 Оpie 31 Balance c/d 369 184 192 30 Melati 160 4,195 30 Suria 504 5,048 5,048 Bank Statement Date Items Debit Credit Balance Мас 1 Balance 4,200 8 Maria 184 4,384 4,092 16 Cheque 292 4,252 3,883 3,795 3,827 3,846 20 Melati 160 21 Cheque 31 Gigih Enterp : Trader's credit 31 TYF: standing order 31 Bank charges 369 88 32 19 Required: a) Prepare the updated cashbook. b) Prepare the bank reconciliation statement as at 31 Mac 2020.