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 teller 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 $801.15 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.) BANK RECONCILIATION Checkbook balance Bank balance Add: Add: Subtotal Subtotal Deduct: Deduct: Reconciled balance Reconciled balance

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 teller 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 $801.15 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.) BANK RECONCILIATION Checkbook balance Bank balance Add: Add: Subtotal Subtotal Deduct: Deduct: Reconciled balance Reconciled balance

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter5: Bank Reconciliation (bankrec)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

A customer was unable to pay the accounts receivable on time in the amount of $34,000. The customer was able to negotiate with the company and transferred the accounts receivable into a note that includes interest, along with an up-front cash payment of $6,000. The note maturity date is 24 months with a 15% annual interest rate. What is the entry to recognize this transfer?
What is the journal entry to record an NSF check, from J. Smith for 250, that is returned with the bank statement? a. Cash 250 DR; NSF Check 250 CR b. Accounts Receivable 250 DR; Cash 250 CR c. NSF Check 250 DR; Accounts Receivable 250 CR d. Cash 250 DR; Accounts Receivable 250 CR e. Cash 250 DR; Miscellaneous Expense 250 DR
Using the following information, prepare a bank reconciliation. Bank balance: $12,565. Book balance: $13,744. Deposits in transit: $2,509. Outstanding checks: $1,777. Bank charges: $125. Bank incorrectly charged the account for $412. The bank will correct the error next month. Check number 1879 correctly cleared the bank in the amount of $562 but posted in the accounting records as $652. This check was expensed to Utilities Expense.
Calculating the net costs of checking accounts. Determine the annual net cost of these checking accounts: a. Monthly fee 4, check-processing fee of 20 cents, average of 23 checks written per month b. Annual interest of 1.5 percent paid if balance exceeds 750, 8 monthly fee if account falls below minimum balance, average monthly balance 815, account falls below 750 during four months
Blue Company, an architectural firm, has a bookkeeper who maintains a cash receipts and disbursements journal. At the end of the year (2019), the company hires you to convert the cash receipts and disbursements into accrual basis revenues and expenses. The total cash receipts are summarized as follows. The accounts receivable from customers at the end of the year are 120,000. You note that the accounts receivable at the beginning of the year were 190,000. The cash sales included 30,000 of prepayments for services to be provided over the period January 1, 2019, through December 31, 2021. a. Compute the companys accrual basis gross income for 2019. b. Would you recommend that Blue use the cash method or the accrual method? Why? c. The company does not maintain an allowance for uncollectible accounts. Would you recommend that such an allowance be established for tax purposes? Explain.