Kindly see the image for the problem.Please prepare a proof of cash and answer the following questions:How much is the cash shortage as of Dec. 31?How much is the adjusted bank receipts for december?How much is the adjusted book disbursements for December? Below are the information of CELUIZ Companyfor the preparation of proof of cash:Nov 30Dec 31A Cash Account BalanceB Bank Statement BalanceC Deposit in TransitD Outstanding ChecksE Bank Service ChargeF Customer's check depositedDec 10, returned bybank onDec16 marked NSF, andPhp 15,822Php 107,082Php 8,201Php 27,718Php 7239,745137,81712,88030,11260.009, 250redeposited immediately;no entry made on books forreturn or redepositG Notes receivable collection71,81580,900Disbursements in December per bank statement P218,373Cash receipts in December per Muntinlupa's books 236,452Please prepare proof of cash and answer the following questions:1. How much are the adjusted bank receipts for December?2. How much are the adjusted book disbursements for December?3. How much is the cash shortage as of Dec. 31?

Cash and cash equivalents refer to cash or can be converted into cash immediately. It is reported…

Below are the information of CELUIZ Companyfor the preparation of proof of cash: Nov 30 Dec 31 A Cash Account Balance Php 15,822 Php 107,082 Php 8,201 Php 27,718 Php 72 39,745 137,817 B Bank Statement Balance C Deposit in Transit D Outstanding Checks E Bank Service Charge F Customer's check deposited Dec 10, returned bybank on Dec16 marked NSF, and 12,880 30,112 60.00 9, 250 redeposited immediately; no entry made on books for return or redeposit G Notes receivable collection 71,815 80,900 Disbursements in December per bank statement P218,373 Cash receipts in December per Muntinlupa's books 236,452 Please prepare proof of cash and answer the following questions: 1. How much are the adjusted bank receipts for December? 2. How much are the adjusted book disbursements for December? 3. How much is the cash shortage as of Dec. 31?

Below are the information of CELUIZ Companyfor the preparation of proof of cash: Nov 30 Dec 31 A Cash Account Balance Php 15,822 Php 107,082 Php 8,201 Php 27,718 Php 72 39,745 137,817 B Bank Statement Balance C Deposit in Transit D Outstanding Checks E Bank Service Charge F Customer's check deposited Dec 10, returned bybank on Dec16 marked NSF, and 12,880 30,112 60.00 9, 250 redeposited immediately; no entry made on books for return or redeposit G Notes receivable collection 71,815 80,900 Disbursements in December per bank statement P218,373 Cash receipts in December per Muntinlupa's books 236,452 Please prepare proof of cash and answer the following questions: 1. How much are the adjusted bank receipts for December? 2. How much are the adjusted book disbursements for December? 3. How much is the cash shortage as of Dec. 31?

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: When the bank statement is received on July 3, it shows a balance, before reconciliation, of $5,200…

A: Bank reconciliation statement is used to reconcile the balance as per books (bank ledger) and…

Q: In preparing the bank reconciliation for the month of August, Alex Company provided the following…

A: Bank reconciliation statement is prepared to cross check the balances of cash in bank balance as per…

Q: A bank reconciliation must be performed. First you collect the data from June 30th reconciliation as…

A: The bank reconciliation statement is prepared to equate the balances of the cash book and pass book…

Q: Silver Company makes a product with peak sales in May of each year. Its sales budget for the second…

A: The account receivables represent the amount due from the customers. The cash collection schedule is…

Q: The following are examples of possible misstatements in the client's year-end cash balance (assuming…

A: If a firm has a huge number of transactions which include cash and check in large quantity, the…

Q: Bourne Incorporated reports a cash balance at the end of the month of $2,170. A comparison of the…

A: Journal entries are used to record transactions in a business. Journal entries form the basis for…

Q: Write the cash book up to date to take the above into account, and then (b) Draw up a bank…

A: The bank reconciliation statement can be defined as the financial statement being prepared by the…

Q: Clayborn Company deposits all cash receipts on the day they are received and makes all cash payments…

A: The bank reconciliation statement is prepared to equate the balances of the cash book and pass book…

Q: Suppose there was a third transfer on the interbank transfer schedule for $16,500. Assume that the…

A: The possible concern that I would have for this transfer is regarding on the possible reason as to…

Q: Alvin Electronics is in the process of reconciling its bank account for the month of November. The…

A: The objective of the question is to find the corrected cash balance at the end of November for Alvin…

Q: A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through…

A: A bank reconciliation statement is a summary of banking and business activity that reconciles an…

Q: Bowlegs, OK 74830 Statement Date: May 31, 2021 Account Summary Withdrawals and Debits Beginning…

A: Bank reconciliation is a process in which balance as per bank and as per book is matched by…

Q: In reconciling a bank statement, when a check from the previous month appears on the bank statement…

A: A Bank Reconciliation Statement is a statement prepared on a particular day to reconcile the Bank…

Q: 7. Margar Company kept all cash in a checking account. An examination of the accounting records and…

A: Bank Statement:- These statements are prepared when there is a difference between the balance as per…

Q: Santana Rey receives the March bank statement for Business Solutions on April 11, 2020. The March 31…

A: Bank reconciliation: It is a statement drawn up by the business to verify the cash book balance with…

Q: w much is left in the petty cash fund at the end of the month? Round your answer to the neareset…

A: Petty cash is a small amount of cash that a business keeps on hand to pay for small expenses that…

Q: At April 30, Mazaya Company Has the following bank information: cash balance per book $7200;…

A: Bank Reconciliation Statement: Bank statement is prepared by bank. The company maintains its own…

Q: Bourne Incorporated reports a cash balance at the end of the month of $2,320. A comparison of the…

A: Analysis and adjustment of differences between the cash balance shown on a bank statement, and the…

Q: At the end of the month of July you close the books of your company and received the bank statement.…

A: The bank reconciliation statement is prepared to equate the balances of cash book and pass book with…

Q: The following information is available to reconcile Gucci’s book balance of cash with its bank…

Q: XYZ Inc is preparing the October month-end Bank Reconciliation. The balance in the cash ledger on…

A: Bank reconciliation statement is the one which is prepared in order to reconcile the errors in…

Q: The LLYOD bank statement for the month of June shows that there is $13,300 difference with the cash…

A: Outstanding check: When company issue the check to the vendor/creditors but they do not present the…

Q: Your firm’s cash book shows a credit bank balance of $1,240 at 30 April 2021. On comparison with the…

A: A bank reconciliation statement appears to be an overview of banking and business activity that…

Q: ts checking account and a $200 NSF check written by one of Meyer's customers. Meyer's records show a…

Concept explainers

Cash Book

So, before coming to the topic of cash books, I will let you briefly explain about the cash so that you all can be familiar with the word cash. Cash comes under the category of the current asset which is used as a medium of exchange for all the financial transactions in the firm. Cash is something that is universally accepted as a mode of payment. So, now comes to the topic i.e., cash book.

Question

100%

Kindly see the image for the problem.

Please prepare a proof of cash and answer the following questions:

How much is the cash shortage as of Dec. 31?
How much is the adjusted bank receipts for december?
How much is the adjusted book disbursements for December?

Below are the information of CELUIZ Companyfor the preparation of proof of cash:
Nov 30
Dec 31
A Cash Account Balance
B Bank Statement Balance
C Deposit in Transit
D Outstanding Checks
E Bank Service Charge
F Customer's check deposited
Dec 10, returned bybank on
Dec16 marked NSF, and
Php 15,822
Php 107,082
Php 8,201
Php 27,718
Php 72
39,745
137,817
12,880
30,112
60.00
9, 250
redeposited immediately;
no entry made on books for
return or redeposit
G Notes receivable collection
71,815
80,900
Disbursements in December per bank statement P218,373
Cash receipts in December per Muntinlupa's books 236,452
Please prepare proof of cash and answer the following questions:
1. How much are the adjusted bank receipts for December?
2. How much are the adjusted book disbursements for December?
3. How much is the cash shortage as of Dec. 31?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Accounting for Cash and cash equivalents

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Please solve this
What is the cash shortage as of Dec 31?
What is the amount of cash receipts per book in December? Chris Company presented the following bank reconciliation for the month of November: Balance per bank statement, November 30 Add: Deposit in Transit Less: Outstanding checks Bank credit recorded in error Balance per book, November 30 1,200,000 200,000 Data per bank statement for the month of December follow: December deposits, including note collected of 1,000,000 for Chris December disbursements, including NSF customer check 350,000 & service charge 50,000 3,600,000 800,000 4,400,000 1,400,000 3,000,000 5,500,000 4,400,000 1 point All items that were outstanding on November 30 cleared through the bank in December, including the bank credit. In addition, checks amounting to 500,000 were outstanding and deposits of 700,000 were in transit on December 31.
The following includes transactions necessary to prepare a bank reconciliation. The following additional information must also be considered: Check #5454 was written in June but did not clear the bank until July 2. There were no other outstanding checks, and no deposits in transit at the end of June. The EFT (electronic funds transfer) on July 11 relates to the monthly utility bill; the Tackle Shop has authorized the utility to draft its account directly each month. The Tackle Shop is optimistic that they will recover the full amount, including the service charge, on the NSF check that was given to them during the month. The bank collected a $5,000 note for The Tackle Shop, plus 9% interest ($5,450). The Tackle Shop's credit card clearing company remitted funds on July 25; the Tackle Shop received an email notification of this posting and simultaneously journalized this cash receipt in the accounting records. The Tackle Shop made the deposit of $3,565.93 late in the day on July 31,…
Egrane, Incorporated's monthly bank statement showed the ending balance of cash of $19,500. The bank reconciliation for the period showed an adjustment for a deposit in transit of $2,000, outstanding checks of $3,000, an NSF check of $1,700, bank service charges of $80 and the EFT from a customer in payment of the customer's account of $2,500. What is the up-to-date ending Cash balance? Multiple Choice $18,500 O $17,780 $20,500 $22,620
Brangelina Adoption Agency's general ledger shows a cash balance of $4,586. The balance of cash in the March-end bank statement is $7,331. A review of the bank statement reveals the following information: checks outstanding of $2,796, bank service fees of $78, and interest earned of $27. Calculate the correct balance of cash at the end of March. (Amounts to be deducted should be indicated with a minus sign.)
Bourne Incorporated reports a cash balance at the end of the month of $2,620. A comparison of the company's cash records with the monthly bank statement reveals several additional cash transactions: bank service fees ($85), an NSF check from a customer ($350), a customer’s note receivable collected by the bank ($1,000), and interest earned ($35). Required: Record the necessary entries to adjust the balance of cash.
Which of the following practices contributes to efficientcash management? a. Never borrow money—maintain a cash balance suffi-cient to make all necessary payments. b. Record all cash receipts and cash payments at the endof the month when reconciling the bank statements.c. Prepare monthly forecasts of planned cash receipts,payments, and anticipated cash balances up to a year inadvance.d. Pay each bill as soon as the invoice arrives.
Safe Security Doors Ltd. undertakes bank reconciliation at the end of each month before preparing its monthly financial statements. The following information is produced by comparing the cash deposits and withdrawals recorded by the business in July with their bank statement received for the month ending 31 July 2021: The bank statement for the month of July shows a credit balance of $112,250 as at 31 July 2021. Safe Security Doors Ltd.’s cash at bank ledger account has a debit balance of $109,230 at 31 July 2021. $7,850 cash received from a customer Adam on 30 July (invoice no. 211) and $11,045 cash received from another customer Brian on 31 July (invoice no. 213) are recorded in the entity’s accounting record but are not shown in the bank statement. Interest earned on bank account is $85. Cheque no. 112 and 113 are not included in the bank statement. # 112 $ 8,045 # 113 $ 6,950 Bank deducted transaction fees of $15 for an overseas transfer by the entity. Safe Security Doors…
A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance, and whether it should or should not appear on the reconciliation.
Alvin Electronics is in the process of reconciling its bank account for the month of November. The following information is available: Balance per bank statement $ 8,325 Outstanding checks 2,400 Deposits outstanding 1,215 Bank service charges for November 35 Check written by Alvin for $300 but recorded incorrectly by Alvin as a $30 disbursement. What should be the corrected cash balance at the end of November?
Bourne Incorporated reports a cash balance at the end of the month of $2,620. A comparison of the company's cash records with the monthly bank statement reveals several additional cash transactions: bank service fees ($85), an NSF check from a customer ($350), a customer’s note receivable collected by the bank ($1,000), and interest earned ($35). Required: Record the necessary entries to adjust the balance of cash. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) 2 Service Fee Expense selected answer correct 85 selected answer correct Notes receivable incorrect answer please help me finish the problem i keep getting stuck. Its not -85 for credit and its not -35 so what is it