Question

In: Accounting

Bank Reconciliation 18. You have been supplied with the following information produced by comparing the records...

Bank Reconciliation
18. You have been supplied with the following information produced by comparing the records of Japan Ltd with its most recent bank statement:
a) Debit Balance as per cash at bank account in ledger as at 30 June 2019, $13,144
b) Credit balance as per bank statement as at 30 June 2019, $17,979
c) Deposits not reflected on bank statement, $2,200
d) Outstanding cheques at the end of June were: No.114, $1,650; No.192, $2,195; No.201, $2,800
e) Bank charge on bank statement not reflected in Japans Ltd’s general ledger, $30
f) Error by bank – a cheque payment from Samoa Ltd was incorrectly withdrawn from Japan Ltd’s bank account, $840.
g) Cheque for rent expense, $1,250, incorrectly recorded in general ledger as $2,510
Required:
Prepare a bank reconciliation statement for Japan Ltd as at 30 June 2019

Solutions

Expert Solution

JAPAN LTD
Bank Reconciliation
As at June 30 2019
Balance as per Bank Statement              17,979
Add :
Deposit in Transit                2,200
Bank Error                    840                 3,040
             21,019
Less :
Oustanding Checks : No 114                1,650
                                     No 192                2,195
                                     No 201                2,800                 6,645
Adjusted Balance              14,374
Balance as per Bank Statement              13,144
Add :
Rent Check Error ( 2510 - 1250 )                 1,260
             14,404
Less :
Bank Service Charges                      30
Adjusted Balance              14,374
Thank You!
Please comment for any query!

Related Solutions

Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31: The balance on the May 31 bank statement is $8,432.11. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31. A comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at May 31: No. 123 $23.40 No. 127 145.00...
Question 1                      BANK RECONCILIATION The information given below was extracted from the accounting records of Mika...
Question 1                      BANK RECONCILIATION The information given below was extracted from the accounting records of Mika Stores. Required 1.1 Complete the Cash Receipts Journal and Cash payments Journal of Mika Stores for March 2018 after taking the information provided into account. Use only the columns illustrated below. In the details column write down the name of the contra account e.g Rent income. (11) Cash Receipts Journal Details Bank Total b/f Cash Payments Journal Debit Credit Total b/f 1.2 Post to...
The cash records of the Margo Company show the following: 1. The March 31 bank reconciliation...
The cash records of the Margo Company show the following: 1. The March 31 bank reconciliation indicated that deposits in transit totaled $390 2. During April the Cash account shows deposits of $11,800, but the bank statement indicates that only $9,540 in deposits were received during the month 3. The March 31 bank reconciliation also reported outstanding checks of $850 4. During the month of April, the Margo Company books show that $11,670 of checks were issued, yet the bank...
QUESTION 1 BANK RECONCILIATION (20 MARKS) The information given below was extracted from the accounting records...
QUESTION 1 BANK RECONCILIATION The information given below was extracted from the accounting records of Mika Stores. REQUIRED 1.1 Complete the Cash Receipts Journal and Cash Payments Journal of Mika Stores for March 2018 after taking the information provided into account. Use only the columns illustrated below. In the details column write down the name of the contra account e.g. Rent income. (11) Cash Receipts Journal Details Bank Total b/f Cash Payments Journal Details Bank Total b/f MODULE FUNDAMENTALS OF...
Use the following information to answer questions 6–8. You are doing a bank reconciliation for May,...
Use the following information to answer questions 6–8. You are doing a bank reconciliation for May, 20X1. You have a $2,785 unadjusted ledger cash balance and the following data: Outstanding checks: No. 719, $200; No. 727, $800; No. 732, $625 Deposits in transit, $1,200 Check No. 742 (for repairs) written for $505 but incorrectly recorded as $550 NSF check from a customer, $500 Bank service charge for May, $5 Balance per bank statement, $2,750 8. Which adjustment will you need...
the following information was taken from a company’s bank reconciliation at the end of the year:...
the following information was taken from a company’s bank reconciliation at the end of the year: Bank balance $ 8,900 Checks outstanding $ 7,700 Note collected by the bank $ 1,300 Service fee $ 25 Deposits outstanding $ 4,100 NSF check $ 300 What is the correct cash balance that should be reported in the company's balance sheet at the end of the year? a.$5,275. b.$9,900. c.$5,300. d.$8,600. 2 At December 31, Gill Co. reported accounts receivable of $292,000 and...
Classifying bank reconciliation items The following items could appear on a bank reconciliation:
Question Classifying bank reconciliation items The following items could appear on a bank reconciliation:a. Outstanding checks, $670.b. Deposits in transit, $1,500.c. NSF check from customer, no. 548, for $175.d. Bank collection of note receivable of $800, and interest of $80.e. Interest earned on bank balance, $20.f. Service charge, $10.g. The business credited Cash for $200. The correct amount was $2,000.h. The bank incorrectly decreased the business’s account by $350 for a check written by another business.Classify each item as (1)...
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank...
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank Reconciliation For the Month Ended June 30, 20Y7 Cash balance according to bank statement $16,185 Adjustments: Outstanding Check No.1067 $575 Outstanding Check No.1106 470 Outstanding Check No.1110 1,050 Outstanding Check No.1113 910 Deposit of June 30 not recorded by bank (6,600) Total adjustments (3,595) Adjusted balance $12,590 Cash balance according to company’s records $8,985 Adjustments: Proceeds of note collected by bank: Face value $6,000...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $8,260 Adjustments: Outstanding checks $3,960 Error by Chesner Co. in recording Check No. 1056 as $820 instead of $280 540 Note for $13,000 collected by bank, including interest 13,520 Deposit in transit on July 31 (8,410) Bank service charges (30) Total adjustments 9,580 Cash balance according to bank statement $17,840 a. From the data...
Anglin Company, a manufacturing firm, has supplied the following information from its accounting records for the...
Anglin Company, a manufacturing firm, has supplied the following information from its accounting records for the last calendar year: Direct labor cost $494,140 Purchases of direct materials 378,090 Freight-in on materials 7,360 Factory supplies used 18,320 Factory utilities 54,930 Commissions paid 78,322 Factory supervision and indirect labor 162,420 Advertising 146,890 Materials handling 15,960 Work-in-process inventory, January 1 204,880 Work-in-process inventory, December 31 118,460 Direct materials inventory, January 1 39,100 Direct materials inventory, December 31 35,400 Finished goods inventory, January 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT