Knowee
Questions
Features
Study Tools

The accountant for the Muntinlupa Company assembled the following data:  June 30July 31Cash account balanceP  15,822P  39,745Bank statement balance 107,082 137,817Deposits in transit   8,201  12,880Outstanding checks  27,718  30,112Bank service charge      72      60Customer's check deposited July 10, returned by bank on July 16 marked NSF, and redeposited immediately; no entry made on books for return or redeposit               8,250Collection by bank of company's notes receivable  71,815  80,900 The bank statements and the company's cash records show these totals:   Disbursements in July per bank statementP218,373Cash receipts in July per Muntinlupa's books236,452 Based on the application of the necessary audit procedures and appreciation of the above data, how much is the cash shortage as of July 31?Select one:a.P8,250b.P196,144c.P0d.P71,815

Question

The accountant for the Muntinlupa Company assembled the following data:  June 30July 31Cash account balanceP  15,822P  39,745Bank statement balance 107,082 137,817Deposits in transit   8,201  12,880Outstanding checks  27,718  30,112Bank service charge      72      60Customer's check deposited July 10, returned by bank on July 16 marked NSF, and redeposited immediately; no entry made on books for return or redeposit               8,250Collection by bank of company's notes receivable  71,815  80,900 The bank statements and the company's cash records show these totals:   Disbursements in July per bank statementP218,373Cash receipts in July per Muntinlupa's books236,452 Based on the application of the necessary audit procedures and appreciation of the above data, how much is the cash shortage as of July 31?Select one:a.P8,250b.P196,144c.P0d.P71,815

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

To calculate the cash shortage as of July 31, we need to reconcile the company's cash account balance with the bank statement balance, taking into account any deposits in transit, outstanding checks, bank service charges, returned checks, and collections by the bank.

Here's how to do it:

  1. Start with the bank statement balance as of July 31: P 137,817
  2. Add deposits in transit: P 12,880. The new total is P 150,697.
  3. Subtract outstanding checks: P 30,112. The new total is P 120,585.
  4. Subtract the bank service charge: P 60. The new total is P 120,525.
  5. Subtract the customer's check that was returned and redeposited: P 8,250. The new total is P 112,275.
  6. Subtract the collection by the bank of the company's notes receivable: P 80,900. The new total is P 31,375.

Now, compare this with the company's cash account balance as of July 31: P 39,745.

The difference between the reconciled bank balance (P 31,375) and the company's cash account balance (P 39,745) is the cash shortage.

So, the cash shortage as of July 31 is P 39,745 - P 31,375 = P 8,370.

However, this option is not available in the choices provided. There might be a mistake in the question or the provided choices.

This problem has been solved

Similar Questions

The following data was taken from a firm’s bank reconciliation statement: book balance, $7,910; deposit in transit, $150; NSF check from a customer, $200; outstanding checks, $5,000; bank service charge, $10. Its adjusted book balance is

Shown below is the bank reconciliation for Marikina Company for November 2018: Balance per bank, Nov. 30, 2018 P150,000Add:  Deposits in transit     24,000Total 174,000Less:  Outstanding checksP28,000           Bank credit recorded in error   10,000    38,000Cash balance per books, Nov. 30, 2018 P136,000 The bank statement for December 2018 contains the following data: Total depositsP110,000Total charges, including an NSF check of P8,000 and a service charge of P400 96,000 All outstanding checks on November 30, 2018, including the bank credit, were cleared in the bank in December 2018. There were outstanding checks of P30,000 and deposits in transit of P38,000 on December 31, 2018.Based on the above and the result of your audit, how much is the December disbursements per books?Select one:a.P89,600b.P96,000c.P98,000d.P79,600

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

Your customer's NSF check found on the bank statement is a reconciling item on a bank reconciliation and will need to be ______.Multiple choice question.added to the Cash balance in your accounting recordsdeducted from the Cash balance in your accounting recordsadded back to the bank balancededucted from the bank balance twice since it was added in error originally

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

1/2

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.