Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The cash balance per the books of White Company is $ 71,119 on December 31, 2020. The bank statement for White shows a cash balance

The cash balance per the books of White Company is $ 71,119 on December 31, 2020. The bank statement for White shows a cash balance of $ 76,446 on December 31. The following additional items were noted:

1. A deposit of $ 14,500 made by White on December 31 was not recorded by the bank until January 2.
2. Outstanding cheques (cheques written by White but not yet cleared by the bank) at Nov. 30 were: #1012 for $ 8,200 #1044 for $ 4,000 #1078 for $ 2,700 Outstanding cheques (cheques written by White but not yet cleared by the bank) at Dec 31 are: #1044 for $ 4,000 #1110 for $ 11,700 #1168 for $ 7,200 #1198 for $ 600
3. A review of the bank statement revealed that White Company received electronic payments from customers making payments on their accounts of $ 725 in December. The bank has also credited Whites account with $ 13 of interest revenue on December 31. White had no previous notice of these amounts and had not accrued any interest.
4. The bank statement showed an NSF charge on December 31 of $ 2,670. A cheque for $ 2,670 from a customer, Light Networks Limited, which had been deposited in December, was returned by the bank on December 31 marked "NSF".
5. Included in the cancelled cheques returned with the December bank statement was a cheque for $ 1,761 written by Brown Inc., which had been incorrectly debited to White's account by the bank.
6. A White cheque (#457) for $ 629 dated December 22 cleared the bank on December 24. This cheque, which was a payment on account to a supplier, was incorrectly journalized by White for $ 692.
7. The bank service charges for December amounted to $ 43.

Prepare the bank reconciliation for December 31, 2020. (List items that increase balance as per bank and books first.)

WHITE COMPANY Bank Reconciliation December 31, 2020
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198 $
AddLess:
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
AddLess:
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Cash Balance per BankBank ErrorBank Service ChargeCash Balance per Bank Statement, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198 $
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198 $
AddLess:
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
AddLess:
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198
Adjusted Balance per BooksBank ErrorBank Service ChargeCash Balance per Books, December 31Deposits in TransitEFT Collections from CustomersError in Recording Cheque #457Interest RevenueNSF ChequeOutstanding cheque #1044Outstanding cheque #1110Outstanding cheque #1168Outstanding cheque #1198 $

eTextbook and Media

List of Accounts

What adjusting entries are needed? (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Date

Account Titles and Explanation

Debit

Credit

Dec. 31

(To record NSF cheque)

Dec. 31

(To record bank service charges)

Dec. 31

(To correct error in recording cheque #457)

Dec. 31

(To record EFT payments received from customers)

Dec. 31

(To record interest received)

eTextbook and Media

List of Accounts

What will be the cash account balance on the statement of financial position at December 31?

Cash account balance $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Between The Lines Of The Balance Sheet The Plain Mans Guide To Published Accounts

Authors: Michael Greener

2nd Edition

0080240712, 9780080240718

More Books

Students also viewed these Accounting questions

Question

=+What action steps will you take to handle this situation?

Answered: 1 week ago