Question

In: Accounting

Prepare a bank reconciliation using the above data given

The following data were accumulated for use in reconciling the bank account of creative Design co for August 20Y6

1.Cash Balance according to the company's records at August 31, $27,210

2.Cash Balance according to the bank statement at August 31,$28,330

3.Checks outstanding,$5,520

4.Deposit in transit, not recorded by bank $4,440

5. A check for $340 in payment of an account was erroneously  recorded in the check register as $430

6.Bank debit memo for service charges , $50

Req (a). prepare the bank reconciliation statement using the above given data

Solutions

Expert Solution

Bank Reconciliation 

August 31,20Y6

Particulars Amount$
Cash balance according to bank statement 28,330
Add : Deposit in transit on Aug 31 4,440
Less : Oustanding Checks 5,520
Adjusted Balance 27,250
Cash balance according to company's record 27,210
Add : Error in recording check ($430 - 340) 90
Less : Bank Service Charge 50
Adjusted Balance 27,250

Answer to the above question clearly shown in the explanation option

Related Solutions

Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the following format. I am not going to be particular about how you show your numbers as long as you have them in the right spot and can get to the correct adjusted balances. Bank Balance: Cash Balance: Add: Add: Deduct: Deduct: Adjusted Balance: Adjusted Balance: Journalize the necessary entries. After completing the bank reconciliation show any necessary journal entries. Pretend you have a general...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris Company at August 31, 2017, was as follows: KATSARIS COMPANYBank Reconciliation August 31, 2017 Cash balance per bank $13,229 Add: Deposits in transit 2,350 15,579 Less: Outstanding cheques #4451 $1,740 #4460 549 #4461 723 #4462 1,840 #4464 620 5,472 Adjusted cash balance per bank $10,107 The unadjusted cash balance per books on September 30, 2017, was $10,228. The September bank statement showed the following:...
Q4. What is the bank reconciliation? why is it important for companies to prepare bank reconciliation...
Q4. What is the bank reconciliation? why is it important for companies to prepare bank reconciliation periodically?
What is the bank reconciliation? why is it important for companies to prepare bank reconciliation periodically?
What is the bank reconciliation? why is it important for companies to prepare bank reconciliation periodically? 
What is the bank reconciliation? why is it important for companies to prepare bank reconciliation periodically?
  Q1-A. What is the bank reconciliation? why is it important for companies to prepare bank reconciliation periodically? Q1-B A company that uses a perpetual inventory system made the following cash purchases and sales. There was no beginning inventory. January 1: Purchased 30 units at SAR11 per unit February 5: Purchased 30 units at SAR 13 per unit March 16: Sold 50 Units for SAR 15 per unit A.Prepare general journal entries to record the March 16 sale using the...
Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a)...
Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a) The bank statement balance is $3,936. (b) The cash account balance is $4,194. (c) Outstanding checks amounted to $465. (d) Deposits in transit are $655. (e) The bank service charge is $50. (f) A check for $97 for supplies was recorded as $79 in the ledger.
Why is it important to prepare a bank reconciliation for each bank account at the end...
Why is it important to prepare a bank reconciliation for each bank account at the end of the month b) Does it make sense for the same person who prepares the daily cash deposits for the company to also perform the monthly bank reconciliation (in your answer, be sure to name any specific internal control procedures that may be applicable)? c) Describe the different types of audit opinions.
Prepare a Bank Reconciliation Statement from the information provided and prepare adjusting Journal Entries.
Prepare a Bank Reconciliation Statement from the information provided and prepare  adjusting Journal Entries.The information below relates to the Cash account in the ledger of Bramble Company.Balance September 1—$17,010; Cash deposited—$64,500.Balance September 30—$17,664; Checks written—$63,846.The September bank statement shows a balance of $16,682 on September 30 and the following memoranda.Credits DebitsCollection of $1,621 note plus interest $39 $1,660 NSF check: Richard Nance $555Interest earned on checking account $54 Safety deposit box rent $74At September 30, deposits in transit were $4,580,...
Prepare a bank reconciliation at November 30 List items that increase balance as per bank &...
Prepare a bank reconciliation at November 30 List items that increase balance as per bank & books first The bank portion of last month’s bank reconciliation for Crane Limited at October 31 is shown here: CRANE LIMITED Bank Reconciliation October 31 Cash balance per bank $24,920 Add: Deposits in transit 2,972 27,892 Less: Outstanding cheques                #2472 $1,430                #2473 1,600                #2474 1,038 4,068 Reconciled cash balance $23,824 The reconciled cash balance per bank agreed with the reconciled cash balance per books...
Introduction to Accounting Problem #5- Bank Reconciliation A) From the facts listed below, prepare a Bank...
Introduction to Accounting Problem #5- Bank Reconciliation A) From the facts listed below, prepare a Bank Reconcilation for the Ryan Company at 11/30/18: 1) Balance per General Ledger Account- Cash $2,549.99 2) Balance per Citibank bank checking Account $3,359.78 3) Checks issued which did not clear the bank statement at 11/30/16 $1544.99 4) Deposits made which did not clear the bank account at 11/30/16 $816.20 5) CM on Citibank Statement for Note Receivable of $408.00: Note Receivable $400.00 + Interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT