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: On December 15, you received your bank statement showing a balance of $2,275.34. Your checkbook…

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

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: Use the checkbook and bank statement below to balance the checkbook. What is the total amount of the…

A: A bank reconciliation statement is a financial document that reconciles the bank statement balance…

Q: Using the QBO Sample Company, Craig's Design and Landscaping Services, complete the following. 1.…

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

Q: Fill in the missing amounts in the accounts receivable subsidiary ledgers for Willis Spas and Pools.…

A: Accounts receivable is an asset and it normally has a debit balance. Accounts receivable account is…

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: You're doing a monthly bank reconciliation and have the following information: Question Current…

A: Answer:- Bank reconciliation:- An entity's bank account balance in its books of accounts is…

Q: TeleComm customer ADR circuits paid off an $9500 balance on its accounts receivable. TeleComm should…

A: Accounts receivable is the revenue that has been earned but the payment for the same has not been…

Q: BANK RECONCILIATION AND JOURNAL ENTRIES - In the Bank Reconciliation Template, prepare a bank…

A: Introduction: Journals: Recording of a business transactions in a chronological order. First step in…

Q: Suppose that Lena, who has an account at SunTrust Bank, writes a check for $140 to Jose, who has an…

A: Assets : Reserves = -$140Liabilities : Chekable deposits = -$140

Q: A $180 petty cash fund has cash of $20 and receipts of $146. Which of the following would be part of…

A: Cash Need to Replenish to Petty Cash Fund = Amount of Fund to Be - Cash Receipts - Amount of Cash…

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

A: Journal entries are made to record the transactions as the first process in the books of accounts…

Q: Journal Entry for Payee when giving note * to either the maker or a bank Debit Cash, Credit Notes…

A: Notes receivable is considered a negotiable instrument. It is a written promise to receive a certain…

Q: Using the following information, prepare the journal entries to reconcile the bank statement. • Bank…

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

Q: Using the following information, prepare the journal entries to reconcile the bank statement. Bank…

A: Journal entries refers to the act of systematically keeping or recording all the financial…

Q: I NEED HELP WITH PART 3 1. Journalize the selected transactions. Assume 360 days per year. If no…

A: Bank Reconciliation Statement (BRS) BRS is prepared to reconcile the difference between the Bank…

Q: On December 10, you receive your bank statement showing a balance of $2,984.86. Your checkbook shows…

A: ANSWER:- Reconciled balance = $2,893.61 EXPLANATION:- Unadjusted bank balance = $2,984.86 Deposit…

Q: The checkbook balance is $8,850. The total fees or charges deducted by the bank is $8.15.The…

A: Checkbook statements also contains interest income & service charges of banks along with other…

Q: The checkbook balance is $19,250.17. The total fees or charges deducted by the bank is $28.50.The…

A: Given, Checkbook balance=$19,250.17. Total fees or charges deducted=$28.50. Interest credit=$50.19.

Q: Which of the following is considered cash? a. Thirty-day certificate of deposits b. Customer’s…

A: Cash is very important current asset for the business, which is shown in balance sheet of the…

Q: Using the stylized balance sheet below, please 1) finish the balance sheet, and 2) use that…

A: Part 2: Explanation:Step 1: Calculate Interest Income:- Calculate interest income from assets: -…

Q: To be considered a Cash and cash equivalent, the account must hold: Group of answer choices…

A: Cash and cash equivalents are assets that are readily convertible to cash and are considered to be…

Q: Coasters Co. issued a note receivable to a customer. The customer made payment, principal and…

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

Q: Bank Reconciliation Lidia has the following information from her books and her August bank…

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

Q: 1. Identify and list the deposits in transit at the end of December. (You may select more than one…

A: A deposit in transit seems to be cash that has already been collected by a firm and documented in…

Q: 6. A portion of your bank statement is shown. Your previous balance was $228.73. What is your…

A: Data given: Date Particulars Deposits and Credits ($) Checks and Other Charges ($) Previous…

Q: Using the following information, prepare the journal entries to reconcile the bank statement. Bank…

A: Balance as per cash book $2,849 Balance as per bank book $4,178 Add: Notes receivables $1000 Add:…

Q: On December 3, you received your bank statement showing a balance of $5,055.06. Your checkbook shows…

A: Bank reconciliation statement: The bank reconciliation statement commonly referred to as BRS is a…

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: On October 1, Jessica Clay received her bank statement showing a balance of $374.52. Her checkbook…

A: Bank reconciliation statement is the one prepared by the entity to reconcile the differences between…

Q: C. NSF , Bank collection of note receivable of $800, and interest of $80. 75. e. Interest earned on…

A: Bank reconciliation statement shows the reconciliation of entity's bank account with its financial…

Q: Outstanding checks of $12,000. Bank service charge of $15. Deposit in transit of $2,300. Interest…

A: (1) Outstanding checks of $ 12,000No journal entry is made to a company general ledger for…

Q: Fill in the missing amounts in the accounts receivable subsidiary ledgers for Willis Spas and Pools.…

A: Accounts receivable is an asset and it normally has a debit balance. Accounts receivable account is…

Q: Accompanying the bank statement was a debit memo for an NSF check received from a customer. What…

A: Correct option is (b) Debit Accounts Receivables and Credit Cash

Q: Cy Walker invests $20,000 of his personal savings into Mookie the Beagle Concierge. MTB Concierge…

A: What type of account is owner's investment ? Owner's investment (capital ) is personal account .…

Q: 10. In Exhibit 3.6, you see a credit sale to G. H. Allen that is recorded in a paper-based…

A: Cash receipts prelist is a document that records all the receipts of cash but is separate from…

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: On December 10, you receive your bank statement showing a balance of $2,981.97. Your checkbook shows…

A: Lets understand the basics. Bank reconciliation statement is a statement which reconcile the balance…

Q: 2a) You have an account at Bank A. Your last balance statement, which you can see on your bank…

A: Beginning Balance = $520 Deposits = $3120 Withdrawals = $750 Bill Transfers = 2300 + 180 = $2480…

Q: On May 27, you received your bank statement showing a balance of $1,026.34. Your checkbook shows a…

A: Bank Reconciliation Statement: It is also called BRS. BRS is prepared to reconcile the cash balance…

Q: Minimum New Balance Finance Payments I Credits Late Previous Balance Charge Charge Payment…

A: Given, Previous Balance = 1,237.56 Paymets/Credits = $1200.00 Transactions = $2,560.67 Late…

Q: A $180 petty cash fund has cash of $15 and receipts of $180. Which of the following would be part of…

A: The petty cash fund has a receipt of $180 thus a Petty Cash Fund A/c was debited for $180 and Cash…

Q: Based on the he following information,preaper a blank reconciliation to determine the adjusted(…

A: Bank reconciliation statement is prepared to reconcile the balance between bank and cash.

Q: On December 15, you recieved your bank statement showing a balance of $2270.32. Your checkbook shows…

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

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: If a company returns an item to a supplier, the supplier will record the return as: shrinkage. O a…

A: The item purchased by the company from the supplier is Purchase for the company and Sales for the…

Q: Emporium bank lends money to a customer on a six month note. What journal entry does the bank…

A: Journal entry: A journal entry is used to record day-to-day transactions of the business by debiting…

Q: Based on the following information, prepare a check and stub: Date: January 15, 20-- Balance…

A: A check stub represents a part of a check which has been kept by the payee that contains the…

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

vable Prepare Jun's journal entry assuming the note is honored by the customer on October 31 of that same year. (Do not round intermediate calculations. Round your answers to nearest whole dollar value. Use 360 days a year.) View transaction list Journal entry worksheet 1 Record cash received on note plus interest.
On February 1, Derrick Company establishes a $200 petty cash fund. Complete the necessary journal entry by selecting the account names and dollar amounts from the drop-down menus. View transaction list Journal entry worksheet < 1 On February 1, Derrick Company establishes a $200 petty cash fund. Complete the necessary journal entry by selecting the account names and dollar amounts from the drop-down menus. Note: Enter debits before credits. Date Feb. 1 General Journal Debit Credit
How do you record a debit card purchase in Quickbooks? A. Use the Enter Bills window to enter the information, then immediately go to the Pay Bills window and prepare th check. B. Prepare a journal entry to debit the expense account of the purchase and credit cash. C. Wait until you do the bank reconciliation and enter one journal entry for all of your debit card purchases. D. Using the Write Checks window, in the No. field,type “Debit.” Enter the vendor name and amount in the check area.
Cy loans Mookie The Beagle Concierge $1,000 at 6% annual interest. Record the transaction as a loan payable as follows. Required: 1. Complete a Deposit. a. Select (+) New icon > Bank Deposit b. Select Account: 1001 Checking c. Select Date: 01/12/2023 d. In Add Funds to This Deposit section, select Account: + Add New > Account Type: Other Current Liabilities > Detail Type: Loan Payable > Name: Loan Payable> Number: 2300 > Save and Close e. Select Payment Method: Check f. Enter Reference Number: 5002 g. Enter Amount: 1000.00 h. Select Save and close i. What is the Amount of the Loan Payable? Note: Answer this question in the table shown below. Round your answer to the nearest dollar amount. i. Amount of the loan payable
On April 3, Erin Gardner received her bank statement showing a balance of $2,086.93. Her checkbook showed a balance of $1,912.47. Outstanding checks were $234.15, $317.80, $78.10, $132.42, and $212.67. The account earned $20.43. Deposits in transit amount to $814.11, and there is a service charge of $7.00. Use the form below to calculate the reconciled balance. CHECKBOOK BALANCE Add: Interest Earned & Other Credits SUBTOTAL Deduct: Service Charges & Other Debits ADJUSTED CHECKBOOK BALANCE tA ta ta ta tA STATEMENT BALANCE Add: Deposits in Transit SUBTOTAL Deduct: Outstanding Checks LA tA ·SA $ LA ADJUSTED STATEMENT BALANCE $ LA E
is the answer to this question correct If you received a check from Mr. Jones for $500 for work you performed last week, which journal would you use to record receipt of the amount they owed you? What would be recorded? This transaction will be recorded in the Cash Receipts Journal. The receipt of cash from the sale of goods, as payment on accounts receivable or from other transactions, is recorded in a cash receipts journal with a debit to cash and a credit to the source of the cash, whether that is from sales revenue, payment on an account receivable, or some other account. Chapter 7 Accounting Information Systems out of Principles of Accounting, Volume 1. CASH RECEIPTS JOURNAL Date Account Cash DR Accounts Receivable CR 2022 Mar.13 Mr. Jones $ 500 $ 500
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
Jervis sels $4,300 of its accounts receivable to Northem Bank in order to obtain necessary cash. Northem Bank charges 2 tactoing fee Wmat entry should Jervis make to record the transaction? Multiple Choice Debir Accounts Receivable $4,300; credit Factoring Fee Expense $86; credit Cash $4214 Debit Accounts Receivable $4,214; debit Factoring Fee Expense $86; credit Cash $4,300. Debit Cash $4,300; credit Factoring Fee Expense $86; credit Accounts Receivable $4,300
You have two credit cards with the following balances: Card A Credit limit: $20,000 Current Balance: $2,000 Card B Credit limit $25,000 Current Balance $ 14,000 Assuming that both cards have been held by you for the same amount of time and you make regular payments on time. Which card is harming your credit more than the other one? Show your work and explain.
11. Computing Checking Account Balance. Based on the following information, determine the true balance in your checking account. (See the related O Financial Literacy Calculations feature.) Balance in your checkbook, $ 356 Balance on bank statement, $472 Service charge and other fees, $15 Interest earned on the account, $4 Total of outstanding checks, $187 Deposits in transit, $60 O Et Type here to search
Lowell Bank reported the following checking account fees: $2 to see a real-live teller, $20 to process a bounced check, and $1 to $3 if you need an original check to prove you paid a bill or made a charitable contribution. This past month you had to transact business through a tellet six times-a total $12 cost to you. Your bank statement shows a $305,33 balance your checkbook shows a $1,009.76 balance. You received $1.10 in interest. An $80115 deposit was not recorded on your statement. The following checks were outstanding: No. 413. $28.30, No. 414, $18.60, and No. 418, $60.72. Prepare your bank reconciliation (Input all amounts as positive values. Round your answers to 2 decimal places) Checkbook balance Add: Interest Subtotal Deduct Teller fee Reconciled balance Y BANK RECONCILIATION $ 1,009 76 Bank balance Add: 1.10 $1,010.86 12.00 $ 998 58 Deposit in transit Subtotal Deduct Outstanding checks (total) Reconciled balance - ** $ 74 $ 305.33 801.15 1,106.48 107,62 998.86
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.