Banner Inc.'s BRS | |||||
Cash Balance according to statement | 114828 | Cash Balance according to books | 125568 | ||
Add: | Add:- | ||||
Deposit in transit | 16000 | Proceeds of note collected by bank | 4000 | ||
130828 | Error ( 915 - 519 ) ( excess payment was recorded ) | 396 | 4396 | ||
Less:- Outstanding Checks | Less:- | 129964 | |||
Ch. No. 811 | 314 | NSF check | 200 | ||
Ch. No. 814 | 625 | Bank Service charges | 50 | ||
Ch. No. 823 | 175 | ||||
1114 | 250 | ||||
Adjusted Balance | 129714 | Adjusted Balance | 129714 | ||
Journal entries | |||||
Accounts receivable -Williams | 200 | ||||
Cash | 200 | ||||
( To record NSF check ) | |||||
Bank charges | 50 | ||||
cash | 50 | ||||
( to record service charges ) | |||||
Cash | 396 | ||||
Office equipment | 396 | ||||
( to record error made in recognising payment made ) | |||||
cash | 4000 | ||||
Notes receivable | 4000 | ||||
( to record collection of note ) | |||||
No adjusting entry is required for outstanding checks and deposit in transits as it will get auto corrected in the next period. | |||||
Part c - $ 129714 | |||||
Part d - | |||||
Purpose of bank reconciliation- Why we need this ??? | |||||
Each entity needs bank recociliation in order to know that whether the balance showing in the books of entity | |||||
is the same as the balance showing in the statement or not. If not, then what is the amount of difference and | |||||
what are the possible reasons of such differences - whether these differences will get auto corrected in the passage | |||||
of time or needs correction and if it needs correction, then who needs to pass that correcting entry - entity or bank . | |||||
Bank reconciliation can also perform an auto check on the entity 's performance as one can measure that the differences | |||||
that arose were natural or were due to errors. | |||||
It happens that there arises a need to tally the bank balance as per statement and as per books as | |||||
there can be several reasons for differences between them like :- | |||||
1. Checks may have been issued to the creditors etc. but they may have not presented for payment in the | |||||
bank due to which book balance will show a decreased amount and bank balance will show an increased amount. | |||||
2. Checks may have been received by the debtors etc. but have not been presented in the bank for collection | |||||
due to which book balance will show a increased amount and bank balance will show a decreased amount. | |||||
3. Amount directly collected by the bank . | |||||
4. Amount directly paid by the bank according to the standing instructions. | |||||
5. Dishonoured cheques | |||||
6. Bank charges, interest collected. | |||||
The balance per the company's bank statement is often larger since the adjustments for deposit in transit and outstsanding checks | |||||
have not been made. |
connect ACCOUNTING Problem Set A -07-3 EM 7.1A. onciliation The cash transactions and cash balances of Banner, Inc....
Part 1 As the controller of Lynbrook, Inc. you are responsible for preparing the monthly bank reconciliation. Using the information below, prepare the bank reconciliation for January 31, 2020. 1. The ledger account for Cash showed a balance at January 31 of $127,500. 2. The January bank statement showed a closing balance of $108.750. 3. The cash received on January 31 amounted to $28,000. It was left at the bank in the night depository chute after banking hours on January...
Part 1 As the controller of Lynbrook, Inc. you are responsible for preparing the monthly bank reconciliation. Using the information below, prepare the bank reconciliation for January 31, 2020. 1. The ledger account for Cash showed a balance at January 31 of $127,500. 2. The January bank statement showed a closing balance of $108,750. 3. The cash received on January 31 amounted to $28,000. It was left at the bank in the night depository chute after banking hours on January...
As part of your role as the controller for Lynbrook Security, Inc., you are asked to prepare a monthly bank reconciliation. The information you need to prepare the September 30, 2020 bank reconciliation for Lynbrook is listed below: 1. The ledger account for Cash showed a balance at September 30 of $7,820. 2. The September bank statement showed a closing balance of $6,710. 3. The cash received on September 30 amounted to $7,605. It was left at the bank in...
Question 2 (30 marks) The cash transactions and cash balances of Juno Company for July 2018 were as follows: 1 The ledger account for cash showed a balance of $125,868 at 31 July. 2 The July bank statement showed a closing balance of $115,128. Cash received on 31 July amounted to $16,000. It was left at the bank in the night depository box after banking hours on 31 July and therefore was not recorded by the bank in the July...
We just started learning bank reconciliation and the help would he greatly appreciated!! Bus 211 Financial Accounting Chapter 04 Excel Homework Problem Due Date: September 24, 2020 by 11:59 pm As part of your role as the controller for Lynbrook Security, Inc., you are asked to prepare a monthly bank reconciliation. The information you need to prepare the September 30, 2020 bank reconciliation for Lynbrook is listed below: 1. The ledger account for Cash showed a balance at September 30...
Accounting 350 - Computer Spreadsheet Assignment #1 (Chapter 7) Brachycephalic Inc. received its September 30, 2018 bank statement. It showed a balance of $10,600. It also showed bank charges of $35, collection of Louis Brandeis’ note for $1,891 and interest of $52, a collection fee of $11, and that Willy Brandt’s check of $506.40 was uncollectible. Brachycephalic Inc.’s ledger showed a cash balance of $5,362.45. Comparison of the records with the bank statement revealed the following: A deposit in transit...
On July 31, 2019, Crane Company had a cash balance per books of $6,355.00. The statement from Dakota State Bank on that date showed a balance of $7,905.80. A comparison of the bank statement with the Cash account revealed the following facts.1.The bank service charge for July was $19.00.2.The bank collected $1,630 for Crane Company through electronic funds transfer.3.The July 31 receipts of $1,309.30 were not included in the bank deposits for July. These receipts were deposited by the company...
Problem: The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31, 2019. A. On July 31, the company's Cash account has a $27,497 debit balance, but its July bank statement shows a $27,233 cash balance. B. Check No. 3031 for $1,482 and Check No: 3040 for $558 were outstanding on the June 30 bank reconciliation. Check No. 3040 is listed with the July canceled checks, but Check...
The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31, 2017. a. On July 31, the company's Cash account has a $25,644 debit balance, but its July bank statement shows a $26,809 cash balance. b. Check No. 3031 for $1,060 and Check No. 3040 for $522 were outstanding on the June 30 bank reconciliation. Check No. 3040 is listed with the July canceled checks, but Check No. 3031 is...
The following information is available to reconcile Branch Company's book balance of cash with its bank statement cash balance as of July 31, 2017. a. On July 31, the company's Cash account has a $25,756 debit balance, but its July bank statement shows a $26774 cash balance. b. Check No. 3031 for $1,000 and Check No. 3040 for $492 were outstanding on the June 30 bank reconciliation. Check No. 3040 is listed with the July canceled checks, but Check No. 3031 is...