In 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.
Question
In 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.
Solution
Para determinar el saldo ajustado de efectivo al 30 de noviembre de 2018, debemos revisar y ajustar la conciliación bancaria proporcionada por el contador de la empresa Pasig. Aquí están los pasos detallados:
-
Revisar la conciliación bancaria original:
- Saldo del banco al 30 de noviembre de 2018: P90,800
- Colecciones no depositadas: P5,000
- Cargos por servicios bancarios: P100
- Cobro de nota del cliente por el banco: (P8,000)
- Cheques pendientes:
- Número 7159: P3,000
- Número 7767: P5,000
- Número 7915: P2,000
- Total cheques pendientes: (P10,000)
- Saldo del libro al 30 de noviembre de 2018: P77,900
-
Ajustes necesarios:
- Cheque No. 7159: El cheque fue registrado como P3,000 pero el monto real fue P30,000. Esto significa que hay un error de P27,000 (P30,000 - P3,000) que debe ser ajustado.
- Cheque No. 7767: Este cheque fue reemplazado por el cheque No. 8113, pero no se hizo ninguna entrada para cancelar el cheque No. 7767. Por lo tanto, el cheque No. 7767 no debería estar en la lista de cheques pendientes.
- Cheque de Sipag Company: Un cheque de P1,500 de otra compañía fue incluido en el estado de cuenta del banco.
- Cargos por servicios bancarios: El cargo por servicio de diciembre de P150 fue cargado a otra cuenta, por lo que no debe ser considerado.
- Cobro de nota por el banco: El banco cobró una nota de P7,000 el 28 de diciembre de 2018, que no fue registrada a tiempo.
-
Recalcular el saldo ajustado del banco:
- Saldo del banco al 30 de noviembre de 2018: P90,800
- Ajuste por cheque No. 7159: (P27,000)
- Ajuste por cheque de Sipag Company: P1,500
- Ajuste por cargos por servicios bancarios: P150
- Ajuste por cobro de nota por el banco: P7,000
- Total ajustes: (P18,350)
- Saldo ajustado del banco: P90,800 - P18,350 = P72,450
-
Recalcular el saldo ajustado del libro:
- Saldo del libro al 30 de noviembre de 2018: P77,900
- Ajuste por cheque No. 7159: (P27,000)
- Ajuste por cheque No. 7767: P5,000
- Ajuste por cobro de nota por el banco: P7,000
- Total ajustes: (P15,000)
- Saldo ajustado del libro: P77,900 - P15,000 = P62,900
-
Conciliar el saldo ajustado del banco y del libro:
- Saldo ajustado del banco: P72,450
- Saldo ajustado del libro: P62,900
- Diferencia: P72,450 - P62,900 = P9,550
-
Revisar la diferencia:
- La diferencia de P9,550 puede ser explicada por los cheques pendientes y las colecciones no depositadas:
- Cheques pendientes al 30 de noviembre de 2018: P10,000
- Colecciones no depositadas al 30 de noviembre de 2018: P5,000
- Diferencia neta: P10,000 - P5,000 = P5,000
- La diferencia de P9,550 puede ser explicada por los cheques pendientes y las colecciones no depositadas:
-
Ajustar la diferencia:
- La diferencia de P9,550 menos la diferencia neta de P5,000 da una diferencia final de P4,550 que debe ser investigada más a fondo.
Por lo tanto, el saldo ajustado de efectivo al 30 de noviembre de 2018 es P62,900, sujeto a la investigación adicional de la diferencia de P4,550.
Similar Questions
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:
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.
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
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?
Your audit disclosed that on December 31, 2018, the accounts receivable control account of Alilem Company had a balance of P2,865,000. An analysis of the accounts receivable account showed the following: Accounts known to be worthlessP 37,500Advance payments to creditors on purchase orders150,000Advances to affiliated companies375,000Customers’ accounts reporting credit balances arising from sales return (225,000)Interest receivable on bonds150,000Other trade accounts receivable – unassigned750,000Subscriptions receivable for common stock due in 30 days825,000Trade accounts receivable - assigned (Finance company’s equity in assigned accounts is P150,000) 375,000Trade installment receivable due 1 – 18 months, including unearned finance charges of P30,000 330,000Trade receivables from officers due currently22,500Trade accounts on which post-dated checks are held (no entries were made on receipts of checks) 75,000 P2,865,000 Based on the above and the result of your audit, determine the adjusted balance of the trade accounts receivable as of December 31, 2018.Select one:a.P1,447,500b.P1,485,000c.P1,147,500d.P1,522,500
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.