Question

Negros Island Navigation has the following information for bank reconciliation Bank Balance as of December 1,...

Negros Island Navigation has the following information for bank reconciliation
Bank Balance as of December 1, 2020 —————————50,000.00
Deposits—————————————————————————-90,000.00
Checks Issued ———————————————-——————-45,000.00
Bank Service Charge ————————————————-————500.00
Note Collected, including interest of P300.00,0—————-5,600.00
A check amounting to 1,000.00 was recorded by the bank as disbursement for 10,000.00.
All outstanding checks in November was negotiated while on December, P65,000.00. is still outstanding.
December Deposit in transit is P10,000.
Collection of P6,000.00 was deposited but not recorded by the company.
A check dated January 21, 2021 was received from a customer amounting to 5,000.00 was received December 27, 2020 was included in the book.
Petty Cash Fund ————————————————20,000.00
Time Deposit, 90 days ————————————100,000.00
Investment in Equity Securities————————-50,000.00
Postal Money Order———————————————5,000.00
Payroll Fund—————————————————100,000.00
The cash in bank includes a compensating balance amounting to P25,000.00, no agreements was signed.
Prepare a two column bank reconciliation.
Prepare adjusting entries for bank reconciliation.
Compute for total amount of cash and cash equivalents to be reflected in the statement of financial position as of December 31, 2020.

Homework Answers

Answer #1
Date Decription Credits Debit Balance
01 Dec 2020 Opening Balance 50000.00 50000.00
Deposits 90000.00 140000.00
Checks Issued 45000.00 95000.00
Bank Service Charges 500.00 94500.00
A Check Accounting 1000.00 93500.00
Collection 6000.00 99500.00
Petty cash 20000.00 79500.00
Time Deposit 100000.00 179000.00
Investment in Equity Securites 50000.00 129500.00
Posta Money Order 5000.00 124500.00
Payroll fund 100000.00 24500.00
TOTAL 246000.00 221500.00
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Kyu’s Store has the following balances as of December 31, 2020. Book Balance, 90,000.00, Bank Balance...
Kyu’s Store has the following balances as of December 31, 2020. Book Balance, 90,000.00, Bank Balance 20,000.00, Deposit in transit is 100,000.00, Outstanding Check is 40,000.00. Bank Service Charge is 10,000.00 How much is the adjusted balance?
54. Based on the following information, prepare the bank reconciliation for Cougar Corp. as of December...
54. Based on the following information, prepare the bank reconciliation for Cougar Corp. as of December 31.    A. On December 31, Cougar Corp. general ledger showed a cash balance of $26,775. The company's bank statement showed an ending balance of $29,558.                                                                                                                               B. A deposit on December 31 for $3,600 was not recorded by the bank until January 1.                                                                                                                           C. A check for $175 received from one of Cougar's customers was noted as NSF by the bank.                                                                                                                              ...
The following information is provided for preparing bank reconciliation for Rush Company as of December 31....
The following information is provided for preparing bank reconciliation for Rush Company as of December 31. 1. The cash ledger account of Rush Company reveals an ending balance of $8,374.33 as of December 31. 2. Comparison of the company’s records and the bank statement for December indicates that, the following checks are issued and appear in the company’ records but are not listed among the paid checks by the bank: Ck.no.423 $125 Ck.no.424 $387 3. Comparison of the company’s records...
The following information is provided for preparing bank reconciliation for Rush Company as of December 31....
The following information is provided for preparing bank reconciliation for Rush Company as of December 31. 1. The cash ledger account of Rush Company reveals an ending balance of $8,374.33 as of December 31. 2. Comparison of the company’s records and the bank statement for December indicates that, the following checks are issued and appear in the company’ records but are not listed among the paid checks by the bank: Ck.no.423 $125 Ck.no.424 $387 3. Comparison of the company’s records...
Bank Reconciliation A bank reconciliation explains the causes for any differences between a company's cash balance...
Bank Reconciliation A bank reconciliation explains the causes for any differences between a company's cash balance on its bank statement and its cash balance on the books (that is, in the ledger. ) Allez Company's monthly bank statement shows an account balance of $6127.23. The cash balance in its ledger is $5301.05. A thorough bank reconciliation investigation yields the following information: The bank erroneously deducted $346.70 from the company's account when the actual amount of a check written by the...
Note the following information related to a company’s cash account : Cash Balance per Bank Cash...
Note the following information related to a company’s cash account : Cash Balance per Bank Cash balancer per bank, 12/31/19 9,610 Check #6832 cleared the bank for $240, but erroneously recorded by company for $268 Outstanding checks 2,417 Deposit by ABC Inc erroneously recorded to the company by the bank 486 NSF check returned by bank 281 Cash balance per books, 12/31/19 7,430 December 2019 interest per bank 30 Check mailed to bank for a deposit that had not reached...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $28,850. Cash balance according to the bank statement at July 31, $30,060. Checks outstanding, $5,860. Deposit in transit, not recorded by bank, $4,700. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $40. a. Prepare a...
Prepare a bank reconciliation for Party USA based on the following information and then prepare journal...
Prepare a bank reconciliation for Party USA based on the following information and then prepare journal entries to adjust the general ledger cash balance. Party USA           Bank Reconciliation Dec. 31, 2019 Bank Side Book side Bank Balance Dec 31     General Ledger Balance Dec. 31 Add: Add: Less: Less: Adjusted Bank Balance Adjusted Book Balance Bank Balance 10,450 General ledger cash balance 10,563 Total Deposits in December 64,300 total Checks written in December 12,767 Outstanding Checks as of...
Lazer Company had the following bank reconciliation on June 30: Balance per bank statement, June 30                          
Lazer Company had the following bank reconciliation on June 30: Balance per bank statement, June 30                                                                                     3,000,000 Deposit in transit                                                                                                                                  400,000 Total                                                                                                                                                      3,400,000 Outstanding checks                                                                                                                        (900,000) Balance per book, June 30                                                                                                           2,500,000 The bank statement for the month of July showed the following: Deposits, including P200, 000 note collected for Lazer                                                     9,000,000 Disbursements, including P140, 000 NSF customer check                 and P10,000 service charge                                                                                          7,000,000 All reconciling items on June 30 cleared through the bank in July. The...
Refer to the information given below: The August 31 balance shown on the bank statement is...
Refer to the information given below: The August 31 balance shown on the bank statement is $9,822. There is a deposit in transit of $1,241 at August 31. Outstanding checks at August 31 totaled $1,883. Interest credited to the account during August but not recorded on the company's books amounted to $102. A bank charge of $35 for checks was made to the account during August. Although the company was expecting a charge, the amount was not known until the...