At the end of each month, Fido receives a bank statement from its bank. This bank...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 book 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 Prepare Financial Statements Prepare Postclosing Trial Balance Prepare Adjusted Trial Balance Analyze and Record Journal Entries Record Adjusting Journal Entries Post to Ledger Accounts Prepare Unadjusted Trial Balance Courtesy of Laura K. Bantz and Ann Esarco BALANCE LAST STATEMENT Date Statement of Account $22,866.00 SCOTS FEDERAL CREDIT UNION Checks Cleared 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 12/17/20XX Check #155 12/18/20XX Check #156 12/19/20XX Check #157 12/20/20XX Check #158 12/24/20XX 12/28/20XX Check #160 12/31/20XX 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 ($ 262) EFT deposit + $1,000 Service Charge ($15) Statement Date December 31, 20XX THIS BALANCE STATEMENT $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 68 Project #11: Bank Reconciliation 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 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 Check #163 EB12/31/20XX $56,273.00 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 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 book 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 Prepare Financial Statements Prepare Postclosing Trial Balance Prepare Adjusted Trial Balance Analyze and Record Journal Entries Record Adjusting Journal Entries Post to Ledger Accounts Prepare Unadjusted Trial Balance Courtesy of Laura K. Bantz and Ann Esarco BALANCE LAST STATEMENT Date Statement of Account $22,866.00 SCOTS FEDERAL CREDIT UNION Checks Cleared 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 12/17/20XX Check #155 12/18/20XX Check #156 12/19/20XX Check #157 12/20/20XX Check #158 12/24/20XX 12/28/20XX Check #160 12/31/20XX 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 ($ 262) EFT deposit + $1,000 Service Charge ($15) Statement Date December 31, 20XX THIS BALANCE STATEMENT $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 68 Project #11: Bank Reconciliation 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 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 Check #163 EB12/31/20XX $56,273.00 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)
Reconcilation Balance as per Cash T Account 56273 Uncleared checks 3525 Dep... View the full answer
Related Book For
College Mathematics for Business Economics Life Sciences and Social Sciences
ISBN: 978-0321614001
12th edition
Authors: Raymond A. Barnett, Michael R. Ziegler, Karl E. Byleen
Posted Date:
Students also viewed these accounting questions
-
1. Use the following information to discuss some of the most likely issues to face the Venezuelan economy in light of in-class content. (a) Since 2002, Venezuela has embarked on a process of...
-
The price of pizza is pz = 20 per unit. (a) Donna spends all of her income, 100 dollars, on pizza (z) and tacos (t). Donnas utility function is U(z, t) = z 0.9 t 0.1 . (a.1) Derive Donnas demand...
-
Ann deposits $100 at the end of each month into her bank savings account. The bank paid 6% nominal interest, compounded and paid quarterly. No interest was paid on money not in the account for the...
-
a. Distinguish between internal common equity and new common stock. b. Why is there a cost associated with internal common equity? c. Describe two approaches that could be used in computing the cost...
-
a. Construct a relative frequency distribution and a percent frequency distribution for the bottle design ratings. b. Construct a cumulative frequency distribution and a cumulative percent frequency...
-
Ramon Martinez is the general manager of Classic Inn, a local mid-priced hotel with 100 rooms. His job objectives include providing resourceful and friendly service to the hotels guests, maintaining...
-
Consider the methanol oxidation data in Table B.20. Perform a thorough analysis of these data. What conclusions do you draw from this residual analysis? x x2 X3 X4 0 454 8.8 3.90 1.30 1.1 0 474 8.2...
-
The following is a trial balance of the Camping Builds Character Trust Fund of the City of Slushers Ridge as of January 1, 20X6: The endowment was in the form of an apartment building. Endowment...
-
December 3 1 mountain and meadow adjusts the accounts only at december 3 1 , the end if the fiscal year Prepare the adjusting journal entry to record the rebt expense at decemeber 3 1.
-
The paralegal is assigned the task of preparing an office legal memorandum. The memorandum is due in 10 days, and there is a 5-page limit. The facts and law are as follows: Facts: Mary was Tom's...
-
1. How can a premium bond and discount bond be built in a situation where, the price of a bond is the function of the bond's coupon, its maturity, and the level of market interest? 2. What is secured...
-
How can you determine if a running back in the NFL is suffering from wage discrimination? Would the process be the same for a lineman?
-
What are the primary reasons behind the current (and seemingly continuing) situation that there is no single, universally accepted approach for software design?
-
Why is it that the actual program code, even though it is an exact model of system behavior, is insufficient in serving as either a software requirements document or a software design document? In...
-
Why is it of utmost importance that the program code be traceable to the software design specification, and, in turn, to the software requirements specification? What are the possible consequences if...
-
How would you, as a software project manager, handle the confusing situation in which the software requirements specification contains numerous design - level details as well?
-
Using either Hurricane Irma or the Ohio Train Derailment in which an incident command system (ICS) was activated. First, describe the incident and the challenges that the incident presented to...
-
SCHEDULE OF COST OF GOODS MANUFACTURED The following information is supplied for Sanchez Welding and Manufacturing Company. Prepare a schedule of cost of goods manufactured for the year ended...
-
A laboratory technician in a medical research center is asked to formulate a diet from two commercially packaged foods, food A and food B, for a group of animals. Each ounce of food A contains 8...
-
E-Loan recently offered 36-month auto loans at 9.84% compounded monthly to applicants with fair credit ratings. If you have a fair credit rating and can afford monthly payments of $350, how much can...
-
Solve Problem using augmented matrix methods. x1 - 3x2 = -5 -3x1 - x2 = 5
-
From the following figures, compile accounts receivable ledger and accounts payable ledger control accounts for the month, and ascertain what the net balances of the respective ledgers should be on...
-
Why may some people consider this to be incorrect? That is, why is the fact that the control account is kept in the General Ledger not enough to justify saying that the control account is part of the...
-
The financial year of The Better Trading Company ended on 30 November 2014. You have been asked to prepare a Total Accounts Receivable Account and a Total Accounts Payable Account in order to produce...
Study smarter with the SolutionInn App