Hello I do not know if I am doing this Bank Reconciliation correclty. I really need help solving this problem. EA5-E3 Complete a Bank Reconciliation for PondMaintenance Corp.In this exercise, you will complete a bank reconciliation as of 12/31/2016 for PondMaintenance Corp. One of your primary goals is to ensure that the file can be easily under-stood by the end user. Use this information to populate the reconciliation:Deposits in Transit: $10,100 and $1,000• NSF Check: $7,150Notes Receivable: $7,000Outstanding Checks: $3,100 and $600Bank Charges: $1,100The bank erroneously deposited a $250 check written to TreeSky Industries into the bankaccount of Pond Maintenance Corp.The bank statement reflects a 12/31/16 balance of $94,200, while the company's generalledger reflects a 12/31/16 cash balance of $102,600.Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set aconditional formatting rule that will highlight the bank balance if it exceeds $90,000. Applya header that displays the filename and file path and a footer that displays the current time.Ensure that all column widths, row heights, and font sizes are appropriately adjusted. Maintenance Corp.Bank ReconciliationDecember 31, 2016Beginning Bank Balance:$94,200Beginning Book Balance: $102,600Add:Add:2$1,000 $$$Deposits in Transit10,100Notes Receivable7,00011,100109,600$105,300Deduct:Deduct:Outstanding Checks$$3,100NSF Check $Bank Charg $6007,150Check Error250 $3,9501,100 $8,250Adjusted Bank Balance$101,350Adjusted Book Balance$101,350

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

Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $90,000. Apply a header that displays the filename and file path and a footer that displays the current time. Ensure that all column widths, row heights, and font sizes are appropriately adjusted.

Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $90,000. Apply a header that displays the filename and file path and a footer that displays the current time. Ensure that all column widths, row heights, and font sizes are appropriately adjusted.

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: Outstanding checks: Group of answer choices Have not been received by the bank for processing Are…

A: Outstanding checks are those that the business has written to a supplier but these have not been…

Q: A voucher system is an example of an internal control procedure over cash payments. True False

A: Voucher: It is a document that states the evidence of a business transaction.

Q: bank reconciliation is Question 4 options: a part of double entry system not a part of…

A: Answer:- correct option is* not a part of double entry system

Q: What is the difference between a bank feed transaction and a manually entered transaction in…

A: In QuickBooks Online, a bank feed transaction refers to the financial transactions that are imported…

Q: K Checking Accounts. Why do individuals use checking accounts? What is the disadvantage of having…

A: The question is asking about the purpose of checking accounts, the disadvantages of having funds in…

Q: why is it important for companies to prepare bank reconciliation periodically?

A: Any businessman or a company contains a book called as Cash Book. This cash book contains the…

Q: what are the two most differences between the bank side and the book side of a bank reconciliation?

A: Bank reconciliation is a statement which explains the reasons of difference between the balance as…

Q: fill in the blanks to complete each sentence. 7. From a bank's viewpoint, a standby letter of…

A: A letter of credit is referred to as a guarantee where the bank uses the letter to give the…

Q: K Checking Accounts. Why do individuals use checking accounts? What is the disadvantage of having…

A: Explanation is given below Explanation:People frequently utilise checking accounts for a variety of…

Q: help please answer in text form with proper workings and explanation for each and every part and…

A: Comprehensive Explanation of Bank OverdraftDefinition and ExplanationA bank overdraft is a credit…

Q: whats a debit and whats credit

A: In accounting the debit and credit are most widely to use in order to make journal entry and entry…

Q: What is the purpose of preparing a bank reconciliation?

A: Bank reconciliation is prepared to reconcile the company's cash book that is reconciled with its…

Q: Which of the following is NOT Non-Authorized Deposit-Taking Institution? O a. Credit Unions O b.…

A: Authorized Deposit Taking Institutions are institutions that have been granted authorization by the…

Q: A bank reconciliation takes time and must balance. An employee was struggling in balancing the bank…

A: Concept introduction: Internal control is a set of controls that ensure smooth and effective…

Q: I need help with this problem

A: Step 1: Introduction to the Bank Reconciliation:Bank Reconciliation Statement is prepared every…

Concept explainers

Bank Reconciliation Statement

As a commerce student, we all know that every business has to maintain a cash book to maintain all his cash and bank transactions. A cash book is a book which has two columns, one cash column and one bank column.

Question

100%

Hello I do not know if I am doing this Bank Reconciliation correclty. I really need help solving this problem.

EA5-E3 Complete a Bank Reconciliation for Pond
Maintenance Corp.
In this exercise, you will complete a bank reconciliation as of 12/31/2016 for Pond
Maintenance Corp. One of your primary goals is to ensure that the file can be easily under-
stood by the end user. Use this information to populate the reconciliation:
Deposits in Transit: $10,100 and $1,000
• NSF Check: $7,150
Notes Receivable: $7,000
Outstanding Checks: $3,100 and $600
Bank Charges: $1,100
The bank erroneously deposited a $250 check written to TreeSky Industries into the bank
account of Pond Maintenance Corp.
The bank statement reflects a 12/31/16 balance of $94,200, while the company's general
ledger reflects a 12/31/16 cash balance of $102,600.
Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a
conditional formatting rule that will highlight the bank balance if it exceeds $90,000. Apply
a header that displays the filename and file path and a footer that displays the current time.
Ensure that all column widths, row heights, and font sizes are appropriately adjusted.

Maintenance Corp.
Bank Reconciliation
December 31, 2016
Beginning Bank Balance:
$
94,200
Beginning Book Balance: $
102,600
Add:
Add:
2$
1,000 $
$
$
Deposits in Transit
10,100
Notes Receivable
7,000
11,100
109,600
$
105,300
Deduct:
Deduct:
Outstanding Checks
$
$
3,100
NSF Check $
Bank Charg $
600
7,150
Check Error
250 $
3,950
1,100 $
8,250
Adjusted Bank Balance
$
101,350
Adjusted Book Balance
$
101,350

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

Why should a company prepare a bank reconciliation for each account every period? What types of issues are avoided by doing this? please no plagrisim and don't copy someone else work, I need a new work for my homework
Which of the following is a benefit of online banking a business can reconcile to the banks balance at any time be a companies book balance will always equal the banks balance see the bank reconciliation is not necessary D the business can reduce their internal controls over cash receipts
On the Excel worksheet are the T- accounts for cash and other accounts need to record the bank reconciliation. Also, the format for the bank reconciliation is provided. Complete the bank reconciliation, using formulas when possible.
Which of the following credit checks would be considered a soft check? A. Vehicle loan application B. job application C. student loan application D. Credit card application I don't need explanation just the answer :)
Certainly! Here's a detailed information on bank reconciliation presented in table format: Bank Reconciliation Information: Key Components Definition Purpose Frequency Steps in Bank Reconciliation Common Adjustments Importance of Bank Reconciliation Explanation. Bank reconciliation is a process that compares the cash balance in a company's accounting records with the balance in its bank statement. - Identify discrepancies between the company's records and the bank statement. - Ensure accuracy and completeness of financial records. Detect errors, fraud, or unauthorized transactions. Typically performed monthly, but can be more frequent for larger transactions or to catch discrepancies early. 1. Start with the ending balance of the bank statement. 2. Add deposits in transit (deposits made but not yet recorded by the bank). 3. Deduct outstanding checks (checks written but not yet cleared by the bank). 4. Add or deduct bank errors (errors made by the bank in recording transactions). 5.…
Which of the following statements about an electronic funds transfer (EFT) is false? Multiple Choice EFT are checks written by the depositor, subtracted on the depositor's books, and sent to the payee but not yet turned in for payment at the bank statement date. Companies are increasingly using EFT because of its convenience and low cost. Payroll, rent, utilities, insurance, and interest payments are usually done by EFT. EFT is the electronic transfer of cash from one party to another. Cash receipts by EFT are listed with deposits and other additions. ▬▬ Q Search #t B 5