Required informationSkip to question[The following information applies to the questions displayed below.]The bookkeeper at Jefferson Company has not reconciled the bank statement with the Cash account, saying, “I don’t have time.” You have been asked to prepare a reconciliation and review the procedures with the bookkeeper.The April 30, Current Year, bank statement and the April ledger account for cash showed the following (summarized):BANK STATEMENT Checks Deposits BalanceBalance, April 1, Current Year $31,600Deposits during April $36,800 68,400Interest collected 1,220 69,620Checks cleared during April $45,800 23,820NSF check-A. B. Wright 310 23,510Bank service charges 160 23,350Balance, April 30, Current Year 23,350Cash (A)Debit CreditApril 1 Balance 25,100 April Checks written 44,000April Deposits 42,000 A comparison of checks written before and during April with the checks cleared through the bank showed outstanding checks at the end of April of $4,700 (including $2,900 written before and $1,800 written during April). No deposits in transit were carried over from March, but a deposit was in transit at the end of April.3. What was the beginning balance in the cash account in the ledger on May 1, Current Year?
Question
Required informationSkip to question[The following information applies to the questions displayed below.]The bookkeeper at Jefferson Company has not reconciled the bank statement with the Cash account, saying, “I don’t have time.” You have been asked to prepare a reconciliation and review the procedures with the bookkeeper.The April 30, Current Year, bank statement and the April ledger account for cash showed the following (summarized):BANK STATEMENT Checks Deposits BalanceBalance, April 1, Current Year 36,800 68,400Interest collected 1,220 69,620Checks cleared during April 4,700 (including 1,800 written during April). No deposits in transit were carried over from March, but a deposit was in transit at the end of April.3. What was the beginning balance in the cash account in the ledger on May 1, Current Year?
Solution
To find the beginning balance in the cash account in the ledger on May 1, Current Year, we need to reconcile the bank statement with the Cash account for April. Here are the steps:
- Start with the ending balance in the bank statement: $23,350
- Add any deposits in transit. The problem states that a deposit was in transit at the end of April, but it doesn't provide the amount. Let's call this amount D.
- Subtract any outstanding checks. The problem states that the outstanding checks at the end of April totaled 4,700.
- Adjust for any other items that appear on the bank statement but not in the company's Cash account. In this case, add the interest collected of 310 and the bank service charges of $160.
So, the calculation is: 4,700 + 310 - $160.
Without the amount of the deposit in transit (D), we can't provide a specific number for the beginning balance in the cash account in the ledger on May 1, Current Year. However, the formula above shows how to calculate it once the amount of the deposit in transit is known.
Similar Questions
Bank Reconciliation StatementMarkson’s & cash book balance and bank statement balance at 31 March 2021 does not agree. The following information has been given to you as a student of accounting to help the company reconcile the difference:The balance per the cash book is GH¢3,300.A cheque of GH¢6,000 issued to a supplier on 30 March 2021 was still in the supplier’sInsurance paid by the bank is GH¢400. This is yet to be recorded in the cash book.An outgoing cheque of GH¢2,000 was recorded twice in the cash book. It is accurately recorded in the bankPayment of a GH¢1,000 cheque is recorded twice in the bankThe bank statement recorded an amount of GH¢1,200 as dividends received from Kankam There is no such transaction in the cash book.A cheque of GH¢1,000 received from a customer was deposited at the bank on 29 March 2021, but this amount has not yet reflected in the bank statement.Bank charges in the bank statement amounted to GH¢100.Required: a. List out the items and balances for the credit side of the updated / adjusted cashbookb. List out the items and balances for the debit side of the updated / adjusted cashbookexample: Debit: Dishonoured cheques GHS 2,000, Credit: Standing order GHS 1,000.
n the audit of Pasig Company’s cash account, you obtained the following information: The company’s bookkeeper prepared the following bank reconciliation as of November 30, 2018: Bank balance – November 30, 2018 P90,800Undeposited collections 5,000Bank service charges 100Bank collection of customer’s note (8,000)Outstanding checks: NumberAmount 7159P3,000 77675,000 79152,000 (10,000)Book balance – November 30, 2018 P77,900 Additional data are given as follows: a. Company recordings for December:Total collections from customersP165,000Total checks drawn98,000 b. Bank statement totals for December :ChargesP123,800Credits169,000 c. Check no. 7159 dated November 25, 2018, was entered as P3,000 in payment of a voucher for P30,000. Upon examination of the checks returned by the bank, the actual amount of the check was P30,000. d. Check no. 8113 dated December 20, 2018 was issued to replace a mutilated check (no.7767), which was returned by the payee. Both checks were recorded in the amount drawn, P5,000, but no entry was made to cancel check no. 7767. e. The December bank statement included a check drawn by Sipag Company for P1,500. f. Undeposited collections on December 31, 2018 - P8,000. g. The service charge for December was P150 which was charged by the bank to another client. h. The bank collected a note receivable of P7,000 on December 28, 2018, but the collection was not received on time to be recorded by Pasig.i. The outstanding checks on December 31, 2018, were: Check No.AmountCheck No.Amount7767P5,0008910P2,30088561,30089254,100 Based on the above and the result of your audit, determine the adjusted cash balance as of November 30, 2018.Select one:a.P63,800b.P58,800c.P90,800d.P85,800
Based on the May 2020 bank reconciliation completed in the following question, which of the following would not be a part of one of the three adjusting journal entries Poorten will record at May 31, 2020 to adjust the cash account balance? Group of answer choicesCredit to Interest Revenue for $25Debit to Outstanding Checks for $2,410Debit to Service Charge Expense for $25Debit to Accounts Receivable for $175
A company has a $8,000 cash balance per its books. The bank statement has a balance of $8,450. The bank reconciliation included $800 of deposits-in transits, $500 of checks outstanding, EFTs of $1,000 were received from customers, a $200 NSF check from a customer, and a $50 bank service charge. Given the above reconciling items, the up-to-date cash balance equals
A firm's bank reconciliation statement shows a book balance of $32,840, a non-interest note collected by the bank of 4,100, outstanding checks of $1,400, and a service charge of $100. Its adjusted book balance is:
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.