In this exercise, you will complete a bank reconciliation as of 4/30/2016 for Furniture Resellers. One...
In this exercise, you will complete a bank reconciliation as of 4/30/2016 for Furniture Resellers. One of your primary goals is to ensure that the file can be easily understood by the end user. Use this information to populate the reconciliation:
- Deposits in Transit: $1,700 and $2,300
- NSF Check: $900
- Notes Receivable: $2,200
- Outstanding Checks: $400 and $700
- Bank Charges: $100
- The bank erroneously posted a deposit of $400 made by FurnitureLand to the account of Furniture Resellers.
- The bank statement reflects a 4/30/16 balance of $17,200, while the company’s general ledger reflects a 4/30/16 cash balance of $18,500.
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 $17,000. Apply a header that displays the file path and a footer that displays the current date. Ensure that all column widths, row heights, and font sizes are appropriately adjusted.
Prepare the necessary journal entries to record the adjustments required to your company’s books.
Homework Answers
Add Answer to:
In this exercise, you will complete a bank reconciliation as of
4/30/2016 for Furniture Resellers. One...
EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a...
EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a bank reconciliation for Tasters Club Corp. for the month ended December 31, 2016. The reconciliation should be partly based on these figures: Bank Statement Balance (12/31/2016) equals $16,200; Notes Receivable equals $395; NSF Check equals $4,000; Bank Charges equals $550. During the month, the bank erroneously deposited a $505 check written to Pepper Products into the bank account of Tasters Club Corp. 1. Open...
EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation...
EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year. Fixed Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $700 10 $6,750 1/1/2009 $8,400 Garage Equipment $11,000 $200...
Exercise 6-9 Bank reconciliation and adjusting entries LO P3 A table for a monthly bank reconciliation dated September 30 is given below.
Exercise 6-9 Bank reconciliation and adjusting entries LO P3 A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or deducted from the book or bank balance, or whether it should not appear on the reconciliation. 1. NSF check from customer is returned on September 25 but not yet recorded by this company. 2 Interest earned on the September cash balance in the bank 3 Deposit made...
Exercise 4-44 (Algorithmic) Bank Reconciliation
Exercise 4-44 (Algorithmic)Bank ReconciliationJohnson Corporation's bank statement for October reports an ending balance of $19,099, whereas Johnson's cash account shows a balance of $18,763 on October 31. The following additional information is available:A $875 deposit made on October 31 was not recorded by the bank until November.At the end of October, outstanding checks total $1,222.The bank statement shows bank service charges of $125 not yet recorded by the company.The company erroneously recorded as $973 a check that it had actually...
Cornerstone Exercise 4-17 Bank Reconciliation The accountant for Bellows Corp. was preparing a bank reconciliation as...
Cornerstone Exercise 4-17 Bank Reconciliation The accountant for Bellows Corp. was preparing a bank reconciliation as of April 30. The following items were identified Bellows' book balance $28,750 900 Outstanding checks Interest earned on checking account Customer's NSF check returned by the hank 380 In addition, Bellows made an error in recording a customer's check the amount was recorded in cash receipts as $370; the bank recorded the amount correctly as $730 Required: What amount will Bellows report as its...
Exercise 4-44 (Algorithmic) Bank Reconciliation Johnson Corporation's bank statement for October reports an ending balance of...
Exercise 4-44 (Algorithmic) Bank Reconciliation Johnson Corporation's bank statement for October reports an ending balance of $21,676, whereas Johnson's cash account shows a balance of $21,220 on October 31. The following additional information is available: A $755 deposit made on October 31 was not recorded by the bank until November. At the end of October, outstanding checks total $1,222. The bank statement shows bank service charges of $125 not yet recorded by the company. The company erroneously recorded as $973...
Exercise 4-44 Bank Reconciliation Johnson Corporation's bank statement for October reports an ending balance of $22,381,...
Exercise 4-44 Bank Reconciliation Johnson Corporation's bank statement for October reports an ending balance of $22,381, whereas Johnson's cash account shows a balance of $22,025 on October 31. The following additional information is available: a. A $855 deposit made on October 31 was not recorded by the bank until November b. At the end of October, outstanding checks total $1,222. C. The bank statement shows bank service charges of $125 not yet recorded by the company. d. The company erroneously...
Cornerstone Exercise 4-17 (Algorithmic) Bank Reconciliation The accountant for Bellows Corp. was preparing a bank reconciliation...
Cornerstone Exercise 4-17 (Algorithmic) Bank Reconciliation The accountant for Bellows Corp. was preparing a bank reconciliation as of April 30. The following items were identified: Bellows' book balance $28,750 Outstanding checks 900 Interest earned on checking account 83 Customer's NSF check returned by the bank 374 In addition, Bellows made an error in recording a customer's check; the amount was recorded in cash receipts as $370, the bank recorded the amount correctly as $730. Required: What amount will Bellows report...
Brief Exercise 4-27 Bank Reconciliation
Brief Exercise 4-27Bank ReconciliationHula Corp. utilizes J.P. Morgan Chase in its banking transactions. For the month of August, 2019, J.P. Morgan Chase presented Hula with its bank statement as follows:Balance, August 31, 2019$64,900Service charge for August100Interest earned during August875NSF check from Jeffrey Corp. (deposited by Hula)450Note ($11,000) and interest ($425) collected for Hula from a customer11,425Upon receiving the bank statement, Hula's accountants analyzed its cash transactions for possible reconciling items between its cash balance per books and J.P. Morgan Chase's...
E6-28 (Algo) Preparing Bank Reconciliation and Entries and Reporting Cash L06-4 The September 30 bank statement...
E6-28 (Algo) Preparing Bank Reconciliation and Entries and Reporting Cash L06-4 The September 30 bank statement for Bennett Company and the September ledger account for cash are summarized here. BANK STATEMENT Checks Balance, September 1 Deposits recorded during September Checks cleared during September $26,900 NSF checks-Betty Brown Bank service charges Balance, September 30 $26.550 180 Cash (A) Sept. Checks written Sept. 1 Balance Sept. Deposits 7,300 28,850 No outstanding checks and no deposits in transit were carried over from August,...
EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a bank reconciliation for Tasters Club Corp. for the month ended December 31, 2016. The reconciliation should be partly based on these figures: Bank Statement Balance (12/31/2016) equals $16,200; Notes Receivable equals $395; NSF Check equals $4,000; Bank Charges equals $550. During the month, the bank erroneously deposited a $505 check written to Pepper Products into the bank account of Tasters Club Corp. 1. Open...
EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year. Fixed Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $700 10 $6,750 1/1/2009 $8,400 Garage Equipment $11,000 $200...
Cornerstone Exercise 4-17 Bank Reconciliation The accountant for Bellows Corp. was preparing a bank reconciliation as of April 30. The following items were identified Bellows' book balance $28,750 900 Outstanding checks Interest earned on checking account Customer's NSF check returned by the hank 380 In addition, Bellows made an error in recording a customer's check the amount was recorded in cash receipts as $370; the bank recorded the amount correctly as $730 Required: What amount will Bellows report as its...
Exercise 4-44 Bank Reconciliation Johnson Corporation's bank statement for October reports an ending balance of $22,381, whereas Johnson's cash account shows a balance of $22,025 on October 31. The following additional information is available: a. A $855 deposit made on October 31 was not recorded by the bank until November b. At the end of October, outstanding checks total $1,222. C. The bank statement shows bank service charges of $125 not yet recorded by the company. d. The company erroneously...
Cornerstone Exercise 4-17 (Algorithmic) Bank Reconciliation The accountant for Bellows Corp. was preparing a bank reconciliation as of April 30. The following items were identified: Bellows' book balance $28,750 Outstanding checks 900 Interest earned on checking account 83 Customer's NSF check returned by the bank 374 In addition, Bellows made an error in recording a customer's check; the amount was recorded in cash receipts as $370, the bank recorded the amount correctly as $730. Required: What amount will Bellows report...
E6-28 (Algo) Preparing Bank Reconciliation and Entries and Reporting Cash L06-4 The September 30 bank statement for Bennett Company and the September ledger account for cash are summarized here. BANK STATEMENT Checks Balance, September 1 Deposits recorded during September Checks cleared during September $26,900 NSF checks-Betty Brown Bank service charges Balance, September 30 $26.550 180 Cash (A) Sept. Checks written Sept. 1 Balance Sept. Deposits 7,300 28,850 No outstanding checks and no deposits in transit were carried over from August,...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago