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.

Bank Reconciliation: To do a bank reconciliation you would match the cash balances on the balance…

Answered: In this exercise, you will complete a…

In this exercise, you will complete a ban Maintenance Corp. One of your primary stood by the end user. Use this informat Deposits in Transit: $10,100 and NSF Check: $7,150 Notes Receivable: $7,000

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: Record the amount for check #101 in her check register.

A: Since we are not given the current balance of Zoe's Account, the balance after recording the…

Q: Classify each of these transactions as an asset, a liability,or neither for each of the “players” in…

A: An asset is an economic resource that a person, company or nation possesses or regulates in…

Q: Cy loans Mookie The Beagle™ Concierge $2,000 at 6% annual interest. Record the transaction as a loan…

A: A journal entry is a form of accounting entry that is used to report a business transaction in a…

Q: 7. On 6/25 Daphne withdrew $200 from an ATM. There was a $2.50 charge for the ATM withdrawal. What…

A: Formula: Available balance = Total deposits - Withdrawal Deduction of withdrawal from total deposits…

Q: Jul 2 Recommended to the owner, Jen Beck, that she put some of the cash into a Money Market…

A: QuickBooks is an accounting software package which has various tools like accounting, inventory,…

Q: rag the boxes to match the answers special bank account that earns interest %! money subtracted from…

A: Compounding is the amount of money earned in the form of interest on Principal + Interest. It can be…

Q: Accompanying a bank statement for Marsh Land Properties is a credit memo for payment on a $15,000…

A: Journal entry: Journal entry is a set of economic events which can be measured in monetary terms.…

Q: n sage 50 how to make general entry for Memo#6 Transfer $4000 from Bank: Credit Card to Bank to CAD…

A: Here to do the assignment of enter the whole transaction into the Sage 50 Accounting software which…

Q: What is double entry for the following transaction: Paid MK20000 of the cash in hand into bank…

A: The objective of this question is to understand the double entry for the transaction where MK20000…

Q: "We have a contract with our partner bank that they pay us a monthly rebate that is calculated as a…

A: Cash back rewards are type of rebate offered by the banks to their customers. It is a rebate of a…

Q: This is the payment method used for setting up automatic monthly payments such as utility bills and…

A: A monthly payment refers to a regular, fixed amount of money that is paid on a monthly basis.

Q: Assume that a bank receives a deposit of $1,000 in cash, puts aside $200 as required reserves, and…

A: Required reserve ratio= Amount of reserves / deposit received=>Required reserve ratio= $200 /…

Q: Answer: A. B. You don't expect the customer to pay their debt. You want to transfer funds from your…

A: Journal entries are used to record business transactions. It it is the first stage of accounting…

Q: Using the check register below and the following bank statement, prepare a bank reconciliation for…

A: The question is based on the concept of Bank Reconciliation. Bank Reconciliation is a statement that…

Q: Match each of the below items into one of the following balance sheet categories: Cash Receivables…

A: The objective of this question is to categorize various items into appropriate balance sheet…

Q: Clivia Traders, a stationery shop, situated in Sea Point is owned by Daisy Garden. The business is a…

A: We are answering 4.1.1 as it is specifically mentioned to do 4.1.1.

Q: ropriate mathematical formula and cell referencing for this. Those were needed.

A: Adjusted Cash Balance The Adjusted Cash Balance shows the amount of money you should have in your…

Q: nterest on your bank balance: Suppose your bank account has a balance today of $100. Consider the…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q: Based on the bank reconciliation, prepare the journal entries. Page: DOC. POST. DATE ACCOUNT TITLE…

A: Journal is a place where accounting transactions are listed in the book keeping system before ledger…

Q: "We have a contract with our partner bank that they pay us a monthly rebate that is calculated as a…

A: Cash Back Rewards- Cash back reward Incentive is used by the banks where the percentage of the…

Q: To record the cash payment of $10,000 against a loan owing to the bank. Please select the correct…

A: In accounting, a journal entry is the documentation of a monetary transaction or other occurrence.…

Q: Q: From the following particulars, prepare the Profit and Loss Account of Bank of Community, for the…

A: According to the question given, we need to prepare the profit and loss account of the Bank of…

Q: Knowledge Check Seal Mate established a $100 petty cash fund on June 1. On June 30, the fund had $17…

A: Petty cash is money kept for small and incidental expenses. Petty cash is current account and…

Q: Need Answer please provide with Perfect Calculation

A: Step 1: Introduction to The Bank Reconciliation:Bank Reconciliation involves investigating items in…

Q: My bank requires me to establish a four digit pin My bank requires me to establish a four digit…

A: Probability is a measure of the likelihood or chance that a specific event will occur and it is…

Q: 1. The table below shows the activity on the credit card statement of Miss PepperCorn for the month…

A: DateActivityLocationAmount05/05PaymentPayment$20005/15ChargeGas$52.3705/27ChargeMacy's$105.42

Q: You are the training director for tellers at a large local bank. As part of a new training program…

A: The objective of the question is to calculate the correct balance in the check register by adding…

Q: nave $35,500 on deposit with no outstanding.checks or unclear you write a check for $4,600 and then…

A: The time it takes for a company's payment to be created, mailed, received, deposited, and submitted…

Q: Melody, Inc., accepts a national credit card. The collection fee is 6%. If credit card sales are…

A: Sales mean the amount to be received by selling the goods. Any amount deducted as fees will be…

Q: You transfer a balance of $1,500 onto the card on the first day of your billing cycle. You make…

A: Customer transfer balance because ,he want to save interest cost. interest rate in the transferee…

Q: Carmen is making an interbank transfer of $1,500 from Bank A to Bank B to cover an overdraft. What…

A: QuickBooks is an accounting software package developed and marketed by Intuit. It is used by small…

Q: Your company has loaned money to an outside entity. You earned the monthly interest on the loan but…

A: Interest earned but not received is an interest income for the business and this interest receivable…

Question

100%

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.

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

Calculate the cash discount and the net amount due the transaction (in $). (Round your answers to the nearest cent.) Amount ofInvoice Terms ofSale CashDiscount NetAmount Due $5,010.20 4/10, n/30 $ $
2. Your checkbook balance was $206.42 on March 3. The check register shows your transactions since then. What should your new balance be? Trans Type Date Description of Transaction or Check # 284 DEP AT Payment / Debit ✓ Deposit / Credit (+) (-) Balance Brought Forward 3/9 Osbourne Pharmacy 3/15 ATM Deposit 3/20 Auto trans: Gen Phone 19 32 50 80 120 49 Balance
A ____ is an interest-bearing checking account. Group of answer choices NOW account certificate of deposit Treasury bill regular checking account Series EE US savings bond
Please help me solve
Using T-accounts, show what happens to checkabledeposits in the banking system when the Fed lends$1 million to the First National Bank
eBook Using the following information, prepare the journal entries to reconcile the bank statement. Bank balance: $4,678 Book balance: $2,351 Deposits in transit: $325 Outstanding checks: $108 and $534 Bank service charges: $25 Notes receivable: $2,000; Interest income: $35 If an amount box does not require an entry, leave it blank.
Credit card companies may charge which of the following? (select all that apply) cash advance fee | annual fee over-the-limit fee late fee
Please help
Marty selected Money Bank because of the features described below. Marty plans on using network ATMS 8 times per month. What are Marty's total estimated annual fees for a checking account with direct paycheck deposit, two savings accounts, 1 overdraft, and no 2nd copies of statements? (1 Point) Feature Description Fees Amount Non-sufficient funds $34 Checking Account Free with direct 2nd copy of statement $4 deposit of paycheck 1 account free, Network ATM useage First 2 per month free, $4 for each additional Savings Account transaction each additional account $5/month Online Services Free with all checking and savings accounts
Need help on figuring out what to put for account/explanation for the journal entry
"We have a contract with our partner bank that they pay us a monthly rebate that is calculated as a portion of the total interchange revenue they receive for each transaction that is run through our platform. As part of our contract/application with our customers we offer cash back rewards that is calculated as a percentage of the revenue that we receive from the bank for each of their transactions."Q: What guidance supports that decision?