The books of Manila's Service, Inc. disclosed a cash balance of P687,570 on December 31, 2018. The bank statement as of December 31 showed a balance of P547,800. Additional information that might be useful in reconciling the two balances follows:(a) Check number 748 for P30,000 was originally recorded on the books as P45,000.(b) A customer's note dated September 25 was discounted on October 12. The note was dishonored on December 29 (maturity date). The bank charged Manila's account for P142,650, including a protest fee of P2,650.(c) The deposit of December 24 was recorded on the books as P28,950, but it was actually a deposit of P27,000.(d) Outstanding checks totaled P98,850 as of December 31.(e) There were bank service charges for December of P2,100 not yet recorded on the books.(f) Manila's account had been charged on December 26 for a customer's NSF check for P12,960.(g) Manila properly deposited P6,000 on December 3 that was not recorded by the bank. Receipts of December 31 for P134,250 were recorded by the bank on January 2.(i) A bank memo stated that a customer's note for P45,000 and interest of P1,650 had been collected on December 27, and the bank charged a P360 collection fee. Based on the above and the result of your audit, determine the adjusted cash in bank balance.
Question
The books of Manila's Service, Inc. disclosed a cash balance of P687,570 on December 31, 2018. The bank statement as of December 31 showed a balance of P547,800. Additional information that might be useful in reconciling the two balances follows:(a) Check number 748 for P30,000 was originally recorded on the books as P45,000.(b) A customer's note dated September 25 was discounted on October 12. The note was dishonored on December 29 (maturity date). The bank charged Manila's account for P142,650, including a protest fee of P2,650.(c) The deposit of December 24 was recorded on the books as P28,950, but it was actually a deposit of P27,000.(d) Outstanding checks totaled P98,850 as of December 31.(e) There were bank service charges for December of P2,100 not yet recorded on the books.(f) Manila's account had been charged on December 26 for a customer's NSF check for P12,960.(g) Manila properly deposited P6,000 on December 3 that was not recorded by the bank. Receipts of December 31 for P134,250 were recorded by the bank on January 2.(i) A bank memo stated that a customer's note for P45,000 and interest of P1,650 had been collected on December 27, and the bank charged a P360 collection fee. Based on the above and the result of your audit, determine the adjusted cash in bank balance.
Solution
To determine the adjusted cash in bank balance, we need to reconcile the book balance and the bank balance.
-
Start with the book balance: P687,570
-
Adjustments to the book balance: (a) Subtract the overstatement of check number 748: P687,570 - (P45,000 - P30,000) = P672,570 (b) Add the dishonored note and protest fee: P672,570 + P142,650 = P815,220 (c) Subtract the overstatement of the December 24 deposit: P815,220 - (P28,950 - P27,000) = P813,270 (e) Subtract the bank service charges: P813,270 - P2,100 = P811,170 (f) Subtract the customer's NSF check: P811,170 - P12,960 = P798,210 (i) Add the collected customer's note and interest, then subtract the collection fee: P798,210 + P45,000 + P1,650 - P360 = P844,500
-
Start with the bank balance: P547,800
-
Adjustments to the bank balance: (d) Add the outstanding checks: P547,800 + P98,850 = P646,650 (g) Add the unrecorded deposit: P646,650 + P6,000 = P652,650 (i) Add the receipts of December 31: P652,650 + P134,250 = P786,900
The adjusted book balance and the adjusted bank balance should now be equal. However, in this case, they are not. The adjusted book balance is P844,500 and the adjusted bank balance is P786,900. There seems to be a discrepancy of P57,600. This discrepancy needs to be investigated further.
Similar Questions
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
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:
Bayani Corp has the following information relating to cash at December 31, 2011:Bank statement balance 2,500,000Checkbook balance 2,600,000Deposits in transit 700,000Outstanding checks 200,000Bayani's December 31, 2011 Balance Sheet should report cash as:
On Jan. 1, 2021, Entity N sold a machine that had a cash price of P900,000. The buyer paid P100,000 cash and signed a 4-year note. The note specified that it would be paid off infour equal annual payments of P274,565 each starting on Dec. 31, 2021. The payments include 14% interest. The carrying amount of the note receivable on Dec. 31, 2021 is
You were able to gather the following from the December 31, 2018 trial balance of Mandaluyong Corporation in connection with your audit of the company: Cash on handP 500,000Petty cash fund10,000BPI current account1,000,000Security Bank current account No. 011,080,000Security Bank current account No. 02(80,000)PNB savings account1,200,000PNB time deposit500,000 Cash on hand includes the following items: a. Customer’s check for P40,000 returned by bank on December 26, 2018 due to insufficient fund but subsequently redeposited and cleared by the bank on January 8, 2019.b. Customer’s check for P20,000 dated January 2, 2019, received on December 29, 2018.c. Postal money orders received from customers, P30,000. The petty cash fund consisted of the following items as of December 31, 2018. Currency and coinsP 2,000Employees’ vales1,600Currency in an envelope marked “collections for charity” with names attached 1,200Unreplenished petty cash vouchers1,300Check drawn by Mandaluyong Corporation, payable to the petty cashier 4,000 P10,100 Included among the checks drawn by Mandaluyong Corporation against the BPI current account and recorded in December 2018 are the following: a. Check written and dated December 29, 2018 and delivered to payee on January 2, 2019, P80,000.b. Check written on December 27, 2018, dated January 2, 2019, delivered to payee on December 29, 2018, P40,000. The credit balance in the Security Bank current account No. 2 represents checks drawn in excess of the deposit balance. These checks were still outstanding at December 31, 2018. The savings account deposit in PNB has been set aside by the board of directors for acquisition of new equipment. This account is expected to be disbursed in the next 3 months from the balance sheet date.Based on the above and the result of your audit, determine the adjusted balance of cash on hand.
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.