Rodriguez Company | |||||||
Bank Reconciliation | |||||||
July 31,2017 | |||||||
Cash balance per statement | 24,514 | ||||||
Add: | Deposit in transit | 10,400 | |||||
34,914 | |||||||
less: | outstanding checks | 8,460 | |||||
Bank Error | 100 | ||||||
8,560 | |||||||
Adjusted Cash balance per bank | 26,354 | ||||||
Cash balance per books | 21,850 | ||||||
Add: | |||||||
Collection of note receivable by bank | 4470 | ||||||
Book Error | 90 | ||||||
4560 | |||||||
26,410 | |||||||
less: | Check printing charge | 56 | |||||
Adjusted cash balance per books | 26,354 | ||||||
Adjusting Entries | |||||||
No. | Account titles & Explantions | Debit | Credit | ||||
31-Jul | Cash | 4,470 | |||||
interest revenue | 70 | ||||||
Note receivable | 4,400 | ||||||
31-Jul | Cash | 90 | |||||
Accounts payable | 90 | ||||||
31-Jul | Printing charges | 56 | |||||
cash | 56 |
Working notes: | |||||||
1) | July reciepts per books | 81,400 | |||||
july receipts per bank | 79,000 | ||||||
less:Deposits in transit,june 30 | -8000 | 71,000 | |||||
Deposit in transit ,July 31 | 10,400 | ||||||
2) | Disburesment per books | 77150 | |||||
less:book error | -90 | ||||||
total disbursements to be accounted for | 77060 | ||||||
checks clearing bank in July | 74,700 | ||||||
Add:Bank error | 100 | ||||||
less:june 30 outstanding checks | 6200 | 6100 | 68,600 | ||||
outstanding checks ,uly 31 | 8,460 |
PS 5A Rodrid selected data from Prepare a bank reconciliation and adjusting entries. (L03) Rodriguez Company...
Please provide workings!! Thanks :) P7-5A Rodriguez Company maintains a checking account at the Imura Bank. At July 31, selected data from the ledger balance and the bank statement are shown below. Cash in Bank Per Books $17,600 81,400 Balance, July 1 July receipts Julv credits July disbursements July debits Balance, July 31 Per Bank $15,800 83,470 74,756 $24,514 77,150 $21,850 Analysis of the bank data reveals that the credits consist of $79,000 of July deposits and a credit memorandum...
Problem 7-5A Rodriguez Company maintains a checking account at the Imura Bank. At July 31, selected data from the ledger balance and the bank statement are shown below. Cash in Bank Per Books Per Bank Balance, July 1 July recelpts July credits July disbursements July debits Balance, July 31 $17,708 81,508 77,258 $21,958 $15,908 83,578 74 ,8б4 Analysis of the bank data reveals that the credits consist of $78,991 of July deposits and a credit memorandum of $4,587 for the...
Rodriguez Company maintains a checking account at the Imura Bank. At July 31, selected data from the ledger balance and the bank statement are shown below. Cash in Bank Per Books Per Bank Balance, July 1 $17,770 $15,970 July receipts 81,570 July credits 83,649 July disbursements 77,320 July debits 74,926 Balance, July 31 $22,020 $24,693 Analysis of the bank data reveals that the credits consist of $79,000 of July deposits and a credit memorandum of $4,649 for the collection of...
Haverman Company maintains a checking account at the Commerce Bank. At July 31, selected data from the ledger balance and the bank statement are shown below. Cash in Bank Per Books Per Bank Balance, July 1 $26,344 $25,146 July receipts 121,840 July credits 123,441 July disbursements 115,478 July debits 111,895 Balance, July 31 $32,706 $36,692 Analysis of the bank data reveals that the credits consist of $118,247 of July deposits and a credit memorandum of $5,194 for the collection of...
Prepare bank reconciliation and adjusting entries. (LO 3), AP Perth Inc.'s bank statement from Main Street Bank at August 31, 2017, gives the following information. Balance, August 1 $18,400 Bank debit memorandum: August deposits 71,000 Safety deposit box fee $ 25 Checks cleared in August 68,678 Service charge 50 Bank credit memorandum: Balance, August 31 20,692 Interest earned 45 A summary of the Cash account in the ledger for August shows the following: balance, August...
Prepare a bank reconciliation at August 31. (List items that increase balance as per bank & books first.) SAGE HILL INC. Bank Reconciliation Announcements CALCULATOR PRINTER VERSION Question 2 Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2017. gives the following information Balance, Augusti $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks deared in August 68,663 Service charge Bank credit memorandum: Balance, August 31 21,162 Interest earned A summary of...
E7.24 (LO6) (Bank Reconciliation and Adjusting Entries) Kipling plc deposits all receipts and makes all payments by check. The following information is available from the cash records. June 30 Bank Reconciliation Balance per bank £7,000 Add: Deposits in transit 1,540 Deduct: Outstanding checks 2,000 Balance per books £6,540 Month of July Results Per Bank Per Books Balance July 31 £8,650 £9,250 July deposits 4,500 5,810 July checks 4,000 3,100 July note collected (not included in July deposits) 1,500 — July...
Shown below is the bank reconciliation for Marvelous Company for May 2019: Balance per bank, May 31, 2019 P75,000 Add: Deposits in transit 12,000 Total 87,000 Less: Outstanding checks P14,000 Bank credit recorded in error 5,000 19,000 Cash balance per books, 5/31/19 P68,000 The bank statement for June 2019 contains the following data: Total deposits P55,000 Total charges, including an NSF check of P4,000 and a service charge of P200 48,000 All outstanding checks on May 31, 2019, including the...
Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks cleared in August 68,663 Service charge 65 Bank credit memorandum: Balance, August 31 21,162 Interest earned 60 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,935; receipts $74,235; disbursements $73,555; and balance, August 31, $19,615. Analysis reveals...
The following information was used to prepare the March, bank reconciliation for Benson Machine Works. Identify the items that require adjustment to the cash balance per books and prepare the appropriate adjusting entries. 1. Included with the bank statement materials was a check from Jim Trent for $70 stamped "NSF." 2. A personal deposit by Sam Benson to his personal account in the amount of $300 for dividends on his General Motors common stock was credited to the...