A+L+L Project #11 Bank Reconciliation Preview of Chapter At the end of each month, Fido receives...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A+L+L Project #11 Bank Reconciliation Preview of Chapter At the end of each month, Fido receives a bank statement from its bank. This bank statement shows the information that the bank has processed from the beginning of the month to the end of the month. The accountant must "reconcile" the bank statement details to Fido's accounting records. To do this, the accountant reviews Fido's Cash ledger account to determine where the bank statement and Fido's Cash ledger account do not agree. Most often these differences are expected on a monthly basis. For instance, many banks charge a monthly service fee. This fee would not be recorded on the company's books until the monthly bank statement arrives, because the company would not know the amount of the charge until that time. The accountant prepares worksheets to show this recon ciliation, then makes a journal entry to record transaction that may need to be recorded on Fido's Cash ledger account. The accountant should always keep a watchful eye for any transactions that are not the company's responsibility. In those cases, the accountant would contact the bank and ask for a correction of the bank error. Fido's does not have any bank errors in this project. All differences between the bank and the books need to be recorded. The "change is cash" is always calculated by referencing the beginning of the period bosk balance to the end of the period reconciled book balance. Students often confuse this as the change between the recon- ciled and unreconciled balance. The change is the change for the entire accounting period. Again, that is the beginning of the month balance com- pared to the reconciled end of the month balance. Note: The financial statement prepared for this project are needed for the remaining pro- jects. No further financial statement will be prepared. Record Closing Journal Entries Prepar Financial Statements Prepare Postclosing Tra Balance Prepare Adjusted Tra Balance Analyze and Recond Journal Entries Record Adjusting Journal Enties Post to Ledger Accounts County of Laurs K. Bars and Ans Ere Prepare Unaduated Trial Balance 67 BALANCE LAST STATEMENT Date Statement of Account $22,866.00 12/1/20XX 12/3/20XX Check #150 12/7/20XX Check #151 12/9/20XX Check #154 12/12/20XX Check #152 12/16/20XX Check #153 SCOTS FEDERAL CREDIT UNION Checks Cleared 12/17/20XX Check #155 12/18/20XX Check #156 1 12/19/20XX Check #157. 12/20/20XX Check #158 12/24/20XX 12/28/20XX Check #160 12/31/20XX 111 Checks and Other Deposits and Debits Other Credits No. Total No. Total 12 $18,607,00 5 $48,762.00 Deposits Made $480.00 $2,300.00 $1,250,00 $1,200.00 $1,000.00 $3,000.00 $500.00 $1,200.00 $1,000.00 $6,400.00 $10,000.00 $12,500.00 $15,000.00 $10,262.00 Account Number 8900-14-124-106 Other Transactions NSF check EFT deposit Statement Date December 31, 20XX BALANCE THIS STATEMENT Stjc Bank Reconciliation $53,021.00 Daily Balance $22,866.00 $32,386.00 $30,086.00 $28,836.00 $40,136.00 $39,136.00 $36,136.00 $50,636.00 $49,436.00 $48,174.00 $59,436.00 $53,021.00 ($ 262) $1,000 Service Charge ($15) BB12/1/20XX EB12/31/20XX Fido's Food Mart-T Account CASH $22,866,00 $10,000.00 $12,500.00 $15,000.00 $10,262.00 $3,000.00 $4,500.00 $56,273.00 $480,00 $2,300.00 $1,200.00 $1,000.00 $1,250.00 $3,000.00 $500.00 $1,200.00 $1,000.00 $600.00 $6,400.00 $1,100.00 $700.00 $1,125.00 Check #150 Check #151 Check #152 Check #153 Check #154 Check #155 Check #156 Check #157 Check #158 Check #159 Check #160. Check #161 Check #162 Check #163 69 The bank statement arrived in the mail. Now, the accountant has to complete the following tasks: Required: 1. Reconcile the bank statement with the Cash T-Account. See the worksheets provided at the end of this project. 2. Record the journal entry to show the changes that need to be made to the Cash T-account. a. Show the balancing effects on the accounting equation b. Record the adjusting journal entry in two-line format using a debit and a credit. c. Show T-Accounts with beginning balances, transactions, and end balances. 3. Calculate the change in cash for the month of December. 4. Prepare a new Adjusted Trial Balance and highlight the accounts and amounts changed. 5. Using the Updated Trial Balance prepared in step 4, prepare the following: a. Multi-Step Income Statement b. Statement of Retained Earnings c. Classified Balance Sheet EB12/31/20XX $3,000,00 $4,500.00 $56,273.00 $6,4AXUD $1,100.00 $700.00 $1,125.00 $100 Check #161 Check #162 Check #163 The bank statement arrived in the mail. Now, the accountant has to complete the following tasks: Required: 1. Reconcile the bank statement with the Cash T-Account. See the worksheets provided at the end of this project. 2. Record the journal entry to show the changes that need to be made to the Cash T-account. a. Show the balancing effects on the accounting equation b. Record the adjusting journal entry in two-line format using a debit and a credit. c. Show T-Accounts with beginning balances, transactions, and end balances. 3. Calculate the change in cash for the month of December. 4. Prepare a new Adjusted Trial Balance and highlight the accounts and amounts changed. 5. Using the Updated Trial Balance prepared in step 4, prepare the following: a. Multi-Step Income Statement b. Statement of Retained Earnings c. Classified Balance Sheet A+L+L Project #11 Bank Reconciliation Preview of Chapter At the end of each month, Fido receives a bank statement from its bank. This bank statement shows the information that the bank has processed from the beginning of the month to the end of the month. The accountant must "reconcile" the bank statement details to Fido's accounting records. To do this, the accountant reviews Fido's Cash ledger account to determine where the bank statement and Fido's Cash ledger account do not agree. Most often these differences are expected on a monthly basis. For instance, many banks charge a monthly service fee. This fee would not be recorded on the company's books until the monthly bank statement arrives, because the company would not know the amount of the charge until that time. The accountant prepares worksheets to show this recon ciliation, then makes a journal entry to record transaction that may need to be recorded on Fido's Cash ledger account. The accountant should always keep a watchful eye for any transactions that are not the company's responsibility. In those cases, the accountant would contact the bank and ask for a correction of the bank error. Fido's does not have any bank errors in this project. All differences between the bank and the books need to be recorded. The "change is cash" is always calculated by referencing the beginning of the period bosk balance to the end of the period reconciled book balance. Students often confuse this as the change between the recon- ciled and unreconciled balance. The change is the change for the entire accounting period. Again, that is the beginning of the month balance com- pared to the reconciled end of the month balance. Note: The financial statement prepared for this project are needed for the remaining pro- jects. No further financial statement will be prepared. Record Closing Journal Entries Prepar Financial Statements Prepare Postclosing Tra Balance Prepare Adjusted Tra Balance Analyze and Recond Journal Entries Record Adjusting Journal Enties Post to Ledger Accounts County of Laurs K. Bars and Ans Ere Prepare Unaduated Trial Balance 67 BALANCE LAST STATEMENT Date Statement of Account $22,866.00 12/1/20XX 12/3/20XX Check #150 12/7/20XX Check #151 12/9/20XX Check #154 12/12/20XX Check #152 12/16/20XX Check #153 SCOTS FEDERAL CREDIT UNION Checks Cleared 12/17/20XX Check #155 12/18/20XX Check #156 1 12/19/20XX Check #157. 12/20/20XX Check #158 12/24/20XX 12/28/20XX Check #160 12/31/20XX 111 Checks and Other Deposits and Debits Other Credits No. Total No. Total 12 $18,607,00 5 $48,762.00 Deposits Made $480.00 $2,300.00 $1,250,00 $1,200.00 $1,000.00 $3,000.00 $500.00 $1,200.00 $1,000.00 $6,400.00 $10,000.00 $12,500.00 $15,000.00 $10,262.00 Account Number 8900-14-124-106 Other Transactions NSF check EFT deposit Statement Date December 31, 20XX BALANCE THIS STATEMENT Stjc Bank Reconciliation $53,021.00 Daily Balance $22,866.00 $32,386.00 $30,086.00 $28,836.00 $40,136.00 $39,136.00 $36,136.00 $50,636.00 $49,436.00 $48,174.00 $59,436.00 $53,021.00 ($ 262) $1,000 Service Charge ($15) BB12/1/20XX EB12/31/20XX Fido's Food Mart-T Account CASH $22,866,00 $10,000.00 $12,500.00 $15,000.00 $10,262.00 $3,000.00 $4,500.00 $56,273.00 $480,00 $2,300.00 $1,200.00 $1,000.00 $1,250.00 $3,000.00 $500.00 $1,200.00 $1,000.00 $600.00 $6,400.00 $1,100.00 $700.00 $1,125.00 Check #150 Check #151 Check #152 Check #153 Check #154 Check #155 Check #156 Check #157 Check #158 Check #159 Check #160. Check #161 Check #162 Check #163 69 The bank statement arrived in the mail. Now, the accountant has to complete the following tasks: Required: 1. Reconcile the bank statement with the Cash T-Account. See the worksheets provided at the end of this project. 2. Record the journal entry to show the changes that need to be made to the Cash T-account. a. Show the balancing effects on the accounting equation b. Record the adjusting journal entry in two-line format using a debit and a credit. c. Show T-Accounts with beginning balances, transactions, and end balances. 3. Calculate the change in cash for the month of December. 4. Prepare a new Adjusted Trial Balance and highlight the accounts and amounts changed. 5. Using the Updated Trial Balance prepared in step 4, prepare the following: a. Multi-Step Income Statement b. Statement of Retained Earnings c. Classified Balance Sheet EB12/31/20XX $3,000,00 $4,500.00 $56,273.00 $6,4AXUD $1,100.00 $700.00 $1,125.00 $100 Check #161 Check #162 Check #163 The bank statement arrived in the mail. Now, the accountant has to complete the following tasks: Required: 1. Reconcile the bank statement with the Cash T-Account. See the worksheets provided at the end of this project. 2. Record the journal entry to show the changes that need to be made to the Cash T-account. a. Show the balancing effects on the accounting equation b. Record the adjusting journal entry in two-line format using a debit and a credit. c. Show T-Accounts with beginning balances, transactions, and end balances. 3. Calculate the change in cash for the month of December. 4. Prepare a new Adjusted Trial Balance and highlight the accounts and amounts changed. 5. Using the Updated Trial Balance prepared in step 4, prepare the following: a. Multi-Step Income Statement b. Statement of Retained Earnings c. Classified Balance Sheet
Expert Answer:
Answer rating: 100% (QA)
ANSWER Scots Federal Credit Union For the Month of December 2... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
At the end of each year, Tom invests $2,000 in a retirement account. Joan also invests $2,000 in a retirement account but makes her deposits at the beginning of each year. They both earn 9 percent on...
-
At the end of each year, Threads Crafts Inc. pays $1000 into a savings account. If interest earned on the account is 3.24% compounded monthly, what would the account balance be in four years?
-
A young executive deposits $300 at the end of each month for 8 years and then increases the deposits. If the account earns 7.2%, compounded monthly, how much (to the nearest dollar) should each new...
-
Jeremiah Wedgewood, the CFO, is adamant that the company needs to move ahead with the new division. While Josey also thinks that creating a new division with a new product line is a good idea, she is...
-
Highlander Cutlery manufactures kitchen knives. One of the employees, whose job is to cut out wooden knife handles, worked 48 hours during a week in January. The employee earns $12 per hour for a...
-
The amounts (in billions of dollars) the U.S. federal government spent on research and development for defense from 2010 through 2014 can be approximated by the model y = 0.5079t2 8.168t + 95.08...
-
Refer to Exercise 9. For the result that was statistically significant, the P-value was 0.01. What P-value would be needed to conclude at the = 0.05 level that the time spent studying differs...
-
Ruddy Automobile Repair, Inc., currently has three repair shops in Boston. Wallis Ruddy, the president and chief executive officer, is facing a pleasant dilemma: the business has continued to grow...
-
Please compute for the following requirements and show solution in good accounting form so I can compare it with my own answer. Thank you! 1. Uncle Ben Corp. sells a product for P5 per unit. The...
-
1. Compare and contrast the various segments of Chinese luxury consumers and customers profiled in the case. 2. How have luxury goods brands responded to President Xi Jinpings crackdown on...
-
Design a recruiting strategy to fill a vacancy (real or fictitious) in your organization, including position title, recruiting strategy and sources, and staffing process (pre- employment testing,...
-
Waters Corporation purchased Jang Group 3 years ago and at that time recorded goodwill of HK\($400\),000. The Jang Divisions net assets, including the goodwill, have a carrying amount of...
-
Ott Company had 210,000 ordinary shares outstanding on December 31, 2015. During the year 2016, the company issued 8,000 shares on May 1 and retired 14,000 shares on October 31. For the year 2016,...
-
Lockard Company purchased machinery on January 1, 2015, for 80,000. The machinery is estimated to have a residual value of 8,000 after a useful life of 8 years. (a) Compute 2015 depreciation expense...
-
On January 2, 2015, Parton Company issues a 5-year, $10,000,000 note at LIBOR, with interest paid annually. The variable rate is reset at the end of each year. The LIBOR rate for the first year is...
-
Brazil Group purchases a tractor at a cost of 50,000 on January 2, 2015. Individual components of the tractor and useful lives are as follows (zero residual value). Instructions (a) Compute...
-
Age and risk have direct relationship as younger investors can take on less risk. True False
-
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Jerry made the following contributions during 2012: His synagogue (by check).....................................................$680 The Democratic Party (by check)...
-
Teresa is a civil engineer who uses her automobile for business. Teresa drove her automobile a total of 21,732 miles during 2012, of which 95 percent was business mileage. The actual cost of...
-
What is the relative frequency of direct hits that were AT MOST a category 3 storm? a. 0.3480 b. 0.9231 c. 0.2601 d. 0.3370 Table 1.18 contains data on hurricanes that have made direct hits on the...
-
A survey of 250 members from an organized union of over 20,000 members. In Exercises 1120, determine whether the data set is a population or a sample. Explain your reasoning.
-
The carbon monoxide levels of 12 of 49 people who escaped a burning building. In Exercises 1120, determine whether the data set is a population or a sample. Explain your reasoning.
Study smarter with the SolutionInn App