a)
Bank Reconciliation Statement of Lynbrook, INC | |||
as on 30th September 2020 | |||
Particulars | Amount in "$" | Amount in "$" | |
Opening Bank Balance | 6710 | ||
Less: | Outsatanding Cheques (Cheque No. 2810-$225, 2760-$150 & 2690-$680) | 1655 | |
Total | 1655 | ||
Add: | Depsited cash but not recorrded in Bank Statement | 7605 | |
Total | 7605 | ||
Adjusted Bank Balance | 12660 | ||
Ending Book Balance | 7820 | ||
Less: | Bank Service Charges for Septmeber | 30 | |
Dishonoured NSF Cheque from Sam Thompsan | 1400 | ||
Total | 1430 | ||
Add: | Deposit collected by bank from Scan House Properties | 6000 | |
Rent Expenses of $580 Erroneously written $850 | 270 | ||
Total | 6270 | ||
Adjusted Book Balance | 12660 |
b)
Jourmal Entries | |||
Sr. No. | Particulars | Debit '$' | Credit '$' |
1 | Bank Service Charges Account…….Debit | 30 | |
To Cash Account | 30 | ||
(Being Bank service charges made for Septmber) | |||
2 | Customer Account………………Debit | 1400 | |
To Bank Account | 1400 | ||
(Being Dishonoured NSF Cheque from Sam Thompsan ) | |||
3 | Bank Account………….Debit | 6000 | |
To Customer Account | 6000 | ||
(Being Deposit collected by bank from Scan House Properties) | |||
4 | Bank Account………….Debit | 270 | |
To Rent Expenses | 270 | ||
(Being Rent Expenses of $580 Erroneously written $850) |
c)
Cash Statement | Amount in "$" | Amount in "$" | |
Outflow | Bank Service Charges for Septmeber | 30 | |
Dishonoured NSF Cheque from Sam Thompsan | 1400 | ||
Total | 1430 | ||
Inflow | Deposit collected by bank from Scan House Properties | 6000 | |
Rent Expenses of $580 Erroneously written $850 | 270 | ||
Total | 6270 | ||
Cash need to include in Balance sheet as on 30th Septmeber | 4840 |
As part of your role as the controller for Lynbrook Security, Inc., you are asked to...
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...
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...
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...
connect ACCOUNTING Problem Set A -07-3 EM 7.1A. onciliation The cash transactions and cash balances of Banner, Inc., for July were as follows: 1. The ledger account for Cash showed a balance at July 31 of $125,568. 2. The July bank statement showed a closing balance of $114,828. 3. The cash received on July 31 amounted to $16,000. It was left at the bank in the night deposi. tory chute after banking hours on July 31 and therefore was not...
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,364. The company's Cash account in its general ledger showed a $1,010 debit balance. The following information was also available as of September 30. • The bank deducted $130 for an NSF check from a customer deposited on September 15. • The September 30 cash receipts, $1,260, were placed in the bank's night depository after banking hours on that date and this amount did not appear on the September 30...
Need help in bank reconciliation and general journal. McDermott Company's bank statement for September 30 showed an ending cash balance of $1,420. The company's Cash account in its general ledger showed a $1,070 debit balance. The following information was also available as of September 30. • The bank deducted $150 for an NSF check from a customer deposited on September 15. • The September 30 cash receipts, $1,300, were placed in the bank's night depository after banking hours on that...
Bank Reconciliation The Seattle Boat Company's bank statement for the month of September indicated a balance of $15,400. The company's cash account in the general ledger showed a balance of $12,450 on September 30. Other relevant information includes the following: 1. Deposits in transit on September 30 total $11,440. 2. The bank statement shows a debit memorandum for a check printing charge of $88. 3. Check number 238 payable to Simon Company was recorded in the accounting records for $546...
1. CUNILIUL L UI howed a balance of Bank Reconciliation The Seattle First Company's bank statement for the month of September: cated a balance of $13,375. The company's cash account in the general ledger showed a bal $10,030 on September 30. Other relevant information includes the following: 1. Deposits in transit on September 30 total $9,850. 2. The bank statement shows a debit memorandum for a $95 check printing charge. 3. Check number 238 payable to Simon Company was recorded...
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,364. The company's Cash account in its general ledger showed a $1,010 debit balance. The following information was also available as of September 30. The bank deducted $130 for an NSF check from a customer deposited on September 15. • The September 30 cash receipts, $1,260, were placed in the bank's night depository after banking hours on that date and this amount did not appear on the...