Question 3H. Angula, for whom you work as a trainee accountant, has provided you with the followingbank statement and bank account details in respect of the month ended 31 May 2017.STATEMENT OF ACCOUNT - YOUR BANKLTD Statement date - 31 May 2017. AccountNo 7654321DateParticulars01-May-17 Balance forward03-May-17 Cheque 59603-May-17 Lodgment06-May-17 Cheque 59706-May-17 Direct debit12-May-17 Credit transfer13-May-17 Cheque 60014-May-17 Cheque 60116-May-17 Lodgment19-May-17 Cheque 59923-May-17 Bank charges for May 201725-May-17 Quarterly interest received27-May-17 Dishonoured cheque27-May-17 Cheque 59830-May-17 Cheque 60331-May-17 Lodgment31-May-17 Standing order: rent third quarter 2017DebitN$1 250601 0107106 0149 00221180013 0452 52413 500CreditN$7 0702 3304 500317 250BalanceN$27 97026 72033 79033 73032 72035 05034 34028 32632 82623 82423 61323 64422 8449 7997 27514 5251 025CrCrCrCrCrCrCrCrCrCrCrCrCrCrCrCrCr The books and records of H. Angula show the followings transactions through the bankaccount for the month of May 2017:Date1/05/17ReceiptsBalance12/05/17 Deposit16/05/17 Deposit28/05/17 Deposit31/05/17 Deposit1/6/2017 BalanceN$33 7902 3304 5007 350411052 08014 779Date4/05/176/05/1710/05/1711/05/1712/05/1718/05/1720/05/1730/05/1731/05/17PaymentsCheque 597Cheque 598Cheque 599Cheque 600Cheque 601Cheque 602Cheque 603Cheque 604BalanceN$6013 0009002710601459492 5244214 77952 080You are required to:i. Reconcile the opening balance as per the cash book to the balanceas per the bank statement.ii. Prepare the adjusted cash book for the month of May 2017.iii. Prepare a statement on 31 May 2017, reconciling the adjusted cashbook with the bank statement balance.

Bank reconciliation statement is a statement to reconcile cash book with bank statement. In…

The books and records of H. Angula show the followings transactions through the bank account for the month of May 2017: Date 1/05/17 Receipts Balance 12/05/17 Deposit 16/05/17 Deposit 28/05/17 Deposit 31/05/17 Deposit 1/6/2017 Balance N$ 33 790 2 330 4 500 7 350 4110 52 080 14 779 Date 4/05/17 6/05/17 10/05/17 11/05/17 12/05/17 18/05/17 20/05/17 30/05/17 31/05/17 Payments Cheque 597 Cheque 598 Cheque 599 Cheque 600 Cheque 601 Cheque 602 Cheque 603 Cheque 604 Balance N$ 60 13 000 9002 710 6014 5949 2524 42 14 779 52 080 You are required to: i. Reconcile the opening balance as per the cash book to the balance as per the bank statement. ii. Prepare the adjusted cash book for the month of May 2017. iii. Prepare a statement on 31 May 2017, reconciling the adjusted cash book with the bank statement balance.

The books and records of H. Angula show the followings transactions through the bank account for the month of May 2017: Date 1/05/17 Receipts Balance 12/05/17 Deposit 16/05/17 Deposit 28/05/17 Deposit 31/05/17 Deposit 1/6/2017 Balance N$ 33 790 2 330 4 500 7 350 4110 52 080 14 779 Date 4/05/17 6/05/17 10/05/17 11/05/17 12/05/17 18/05/17 20/05/17 30/05/17 31/05/17 Payments Cheque 597 Cheque 598 Cheque 599 Cheque 600 Cheque 601 Cheque 602 Cheque 603 Cheque 604 Balance N$ 60 13 000 9002 710 6014 5949 2524 42 14 779 52 080 You are required to: i. Reconcile the opening balance as per the cash book to the balance as per the bank statement. ii. Prepare the adjusted cash book for the month of May 2017. iii. Prepare a statement on 31 May 2017, reconciling the adjusted cash book with the bank statement balance.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: From the following particulars of Al Zahra LLC, prepare bank reconciliation statement as on Oct 31,…

A: Bank reconciliation statement is a statement prepared on periodical basis to check whether bank…

Q: On December 15, you received your bank statement showing a balance of $2,275.34. Your checkbook…

A: The bank reconciliation statement is prepared to equate the balances of cash book and passbook with…

Q: comparison, the following items of differences were found with pass book. On 30th June 2018 the cash…

A: Note:We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: Murad Co. Ltd. bank statement for May 2017 shows the following data. Balance 1/5 $126,500 Balance…

A: Bank reconciliation: It is a statement which is prepared to reconcile the balance as per cash book…

Q: The following information of Mimosa General Dealers for July 2021 has been provided to you: •…

A: The process of recording business transactions in the books of accounts for the first time is…

Q: Sarah has received her bank statement for the month ending November 30, which showed the following:…

A: Answer to Question:- BANK…

Q: Below is information about Lisa Ltd's cash position for the month of June 2019. 1. The…

A: a) Requirment a Total Receipts as per original cash book $ 292,704 ETF from customer $644…

Q: Problem 17: Use the following information for the next five questions: Sky Blue Corporation's bank…

A: Hi, since you have asked a question with multiple sub parts we are solving the 1st 3 subparts for…

Q: At November 17, Icon Company has this bank information: cash balance per bank $6,950; outstanding…

A: Adjusted cash balance per bank means where the bank balance has been adjusted with outstanding…

Q: Prepare a Bank Reconciliation Statement using: a. Adjusted Balance Method b. Book to Bank Method…

A: Bank reconciliation statement is a statement prepared to reconcile or agree the bank balance as…

Q: LILA company has the below information in its Bank Statement and the company book at the end of the…

A: Bank reconciliation statement: This statement is prepared to reconcile the entity cash balance with…

Q: At October 31, Matrah Company has this bank information: cash balance per bank RO 8,950; outstanding…

Q: The following is from Tyrone's bank statement for April: April 1 Beginning Balance.... $ 136.00 3…

A: This statement is prepared to reconcile the balance between books and bank statement . There may be…

Q: Prepare any necessary journal entries based on the following data regarding the bank reconciliation…

A: Journal entries, in the books of an entity, are recorded to prepare a daily report of the…

Q: On September 1, Sharon Santos was given his monthly bank statement with a bank balance of P…

A: The bank reconciliation statement is prepared to equate the balances of cash book and passbook with…

Q: Jansen Company's general ledger showed a checking account balance of $23,920 at the end of May 2016.…

A: Bank reconciliation statement :— It is the statement that shows the reconciliation of balance as per…

Q: ABC Corporation had a general ledger balance of $3,999.85 @ February 28, 2023. The February bank…

A: Bank Reconciliation StatementAn accounting document known as a…

Q: David had the following activity with his checking account during the month of July: Starting…

A: Statement showing checkbook balance as on 31st July Particular Amount (in $) Opening balance…

Q: The following information of Mimosa General Dealers for July 2021 has been provided to you: ● ● ● ●…

A: Bank Reconciliation Statement (BRS) is the process of Identifying the transactions individually and…

Q: The following information has been extracted from the accounting records a bank statement of ABCJM…

A: Bank reconciliation: It is a statement drawn up by the business to verify the cash book balance with…

Q: The following information was taken from the books of Zia Traders on 30 June 2019: 1. The items…

A: Calculation of bank balance at 31st May 2019 : Particulars Amount Balance as per bank…

Q: Calculate the correct bank balance at 30 June 2019. (Hint – Start by calculating the bank balance…

Concept explainers

Bank Reconciliation Statement

As a commerce student, we all know that every business has to maintain a cash book to maintain all his cash and bank transactions. A cash book is a book which has two columns, one cash column and one bank column.

Question

The books and records of H. Angula show the followings transactions through the bank
account for the month of May 2017:
Date
1/05/17
Receipts
Balance
12/05/17 Deposit
16/05/17 Deposit
28/05/17 Deposit
31/05/17 Deposit
1/6/2017 Balance
N$
33 790
2 330
4 500
7 350
4110
52 080
14 779
Date
4/05/17
6/05/17
10/05/17
11/05/17
12/05/17
18/05/17
20/05/17
30/05/17
31/05/17
Payments
Cheque 597
Cheque 598
Cheque 599
Cheque 600
Cheque 601
Cheque 602
Cheque 603
Cheque 604
Balance
N$
60
13 000
9002
710
6014
5949
2 524
42
14 779
52 080
You are required to:
i. Reconcile the opening balance as per the cash book to the balance
as per the bank statement.
ii. Prepare the adjusted cash book for the month of May 2017.
iii. Prepare a statement on 31 May 2017, reconciling the adjusted cash
book with the bank statement balance.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Please help.me to do part a and b. Thank you for your help
c) The followings are the cash book and the bank statement of Alison Baker for the month of November 2017: i) Date 2021 ii) Nov 16 G. Philip 21 J. Forker 31 S. O'Hare 31 Balance c/d REQUIRED: Date 2021 Nov 1 8 16 20 21 31 31 31 Details Balance T. MacLeod Cheque W. Milne Cash book Bank 292 369 192 1,682 5,048 Cheque G. Frank: trader's credit Standing Order Bank Charges Date 2021 Bank statement Illustrate the cash book up to date. Nov 1 6 30 W. Milne 29 S. Porter Balance T. MacLeod Debit 184 160 32 19 292 369 88 Bank Credit Balance Illustrate a bank reconciliation statement as at 31 November 2021. 4,200 184 160 504 5,048 4,200 O/D 4,384 O/D 4,092 O/D 4,252 O/D 3,883 O/D 3,795 0/D 3,827 0/D 3,846 O/D
On April 3, Erin Gardner received her bank statement showing a balance of $2,086.93. Her checkbook showed a balance of $1,912.47. Outstanding checks were $234.15, $317.80, $78.10, $132.42, and $212.67. The account earned $20.43. Deposits in transit amount to $814.11, and there is a service charge of $7.00. Use the form below to calculate the reconciled balance. CHECKBOOK BALANCE Add: Interest Earned & Other Credits SUBTOTAL Deduct: Service Charges & Other Debits ADJUSTED CHECKBOOK BALANCE tA ta ta ta tA STATEMENT BALANCE Add: Deposits in Transit SUBTOTAL Deduct: Outstanding Checks LA tA ·SA $ LA ADJUSTED STATEMENT BALANCE $ LA E
On 30 June 2016, the cash at bank account for Holmes Traders showed a debit balance of $13,398 and the bank statement showed a credit balance of 20,008. A comparison of the two sets of records disclosed: that there was a bank service fee of $10 the bank had collected $1000 on behalf of Holmes Traders on the maturity of a note unpresented cheques totalling $8340 that the date of a deposit of $2740 was shown by Holmes Traders as 30 June 2016, whereas the bank did not record the deposit until 1 July 2016 the bank statement shows interest received on bank account, $20 Required: 1.Prepare the bank reconciliation statement for Holmes Traders for the month ended at 30 June 2016. 2.Do you agree with the statement: “Internal control of cash is strengthened by requiring that each day’s receipts are deposited intact and that all payments are made by cheque or electronic transfer”? Discuss.
Use the following bank statement and T-account to prepare any journal entries needed as a result of the May 31 bank recor no entry Is requlred for a transactlon/event, select "No Journal Entry Requlred" In the first account fleld.) BANK STATEMENT
a) prepare the genral journal entries necessary to update the Bank account in the general ledger for Nov 2017\ b) prepare the bank reconcilation as at 30 Nov 2017
What is the adjusted cash in bank as of March 31 per bank and per books?