Question
Vintage Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The following is the bank reconciliation prepared for
Vintage Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The following is the bank reconciliation prepared for Vintage Interiors as of June 30:
Vintage Interiors Bank Reconciliation June 30 Cash balance according to bank statement $9,422.80 Add deposit of June 30, not recorded by bank 866.80 $10,289.60 Deduct outstanding checks: No. 580 $310.10 No. 602 85.50 No. 612 92.50 No. 613 137.50 625.60 Adjusted Cash Balance $9,664.00
Cash balance according to companys records $9,691.70 Deduct service charges 27.70 Adjusted Cash Balance $9,664.00
The accountant of Vintage Interiors wants to prepare bank reconciliation at July 31. The data required to reconcile the bank statement as of July 31 have been taken from various documents and records and are reproduced as follows. All checks were written for payments on account.
On July 31, Vintage Interiors receives the following bank statement from ABC Commerce Bank:
ABC Commercial Bank Customer Account No: 501234 Wall Street Vintage Interiors Bank Statement for the Month Ended July 31 Date: Amount June 30 Previous statement balance $9,422.80 Deposits and other increases (Credits) July 3 $780.80 July 5 569.50 July 7 701.80 July 9 819.24 July 12 580.70 July 14 5,000.00 (CM) July 15 400.00 (CM) July 16 600.10 July 19 701.26 July 21 731.45 July 28 601.50 Total deposits and other increases (credits) $11,236.35
Checks and other decreases (debits) Ck.No. July 3 No. 613 137.50 July 4 No. 615 350.10 July 5 No.617 395.50 July 7 No.619 320.10 July 8 No.621 309.50 July 9 No.625 158.63 July 11 No.627 318.73 July 12 No. 630 882.80 July 13 No. 632 62.40 July 15 No. 612 $92.50 July 16 No. 614 243.50 July 17 No. 616 279.90 July 18 No.618 435.40 July 19 No.620 238.87 July 20 No.624 707.01 July 21 No.626 550.03 July 22 No.629 329.90 July 23 No.631 1,081.56 July 24 No.633 310.08 July 26 24.10 SC July 28 225.40 NSF Total checks written and other decreases (debits) (8,675.01) Total withdrawals during July (2,363.61) July 31 Balance this statement 13,145.54 Explanation of Symbols: SC: Service charge NSF: Not sufficient funds
The details of the ledger account for cash in the records of Vintage Interiors is as follows:
Cash July 1 Balance $9,664.00 $243.50 July 3 July 2 $569.50 350.10 July 6 July 5 701.80 279.90 July 7 July 9 819.24 395.50 July 8 July 12 $580.70 435.40 July 9 July 16 600.10 320.10 July 11 July 19 701.26 238.87 July 13 July 23 $731.45 309.50 July 16 July 26 601.00 707.01 July 17 July 31 925.05 518.63 July 18 550.03 July 20 318.73 July 21 $ 837.70 July 21 329.90 July 22 882.80 July 23 1,081.56 July 24 62.40 July 25 310.08 July 26 503.30 July 28
The details of the credits to the cash account are as follows:
CHECKS WRITTEN: Number and amount of each check issued in July: Check No. Amount Check No. Amount Check No. Amount 614 $243.50 621 $309.50 630 882.80 615 350.10 624 707.01 631 1,081.56 616 279.90 625 518.63 632 62.40 617 395.50 626 550.03 633 310.08 618 435.40 627 318.73 634 503.30 619 320.10 628 $ 837.70 620 238.87 629 329.90
Total amount of checks issued in July $8,675.01
As a result, the Cash balance as of July 31 is $7,219.09.
Required: a. Determine the outstanding checks issued during July. b. Compute deposit in transit for July. c. Show how the cash balance of 7,219.09 is computed. d. Determine the book errors. e. Prepare bank reconciliation as of July 31. f. Make the necessary adjusting entries in general journal form. Assume that the credit memos presented in the bank statement represent collection of notes receivables. Also assume that all checks are issued for payment of accounts payable.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started