Paste Clipboard A1 3 4 5 6 1.000 7 8 9 10 11 FILE 2 ...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Paste Clipboard A1 3 4 5 6 1.000 7 8 9 10 11 FILE 2 日か 12 13 14 15 5 6 16 1. Prepare a bank reconciliation using a company's bank statement and cash account. HOME Г Date June 1 3 8545NOWO ∞ A 10 13 A B с D E 1 The June bank statement and the cash T-account for Superior Printing Company is shown below. 2 20 22 26 27 29 Calibri 30 INSERT B I U Y Font X 11 T ▾ PAGE LAYOUT Checks A A Preparing a bank reconciliation. - Excel FORMULAS DATA REVIEW 5 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 % Alignment Number Conditional Format as Cell Formatting Table Styles Styles fix The June bank statement and the cash T-account for Superior Printing Company BANK STATEMENT Deposits 10,000 35,000 17,000 Other VIEW NSF Serv. Charge Cells Editing No 840 50 F Balance Sign In n 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 X V 4 Paste A1 16 Clipboard G FILE 17 18 19 20 21 22 23 24 25 26 27 7898 28 29 30 1. Prepare a bank reconciliation using a company's bank statement and cash account. HOME A 30 30 Calibri INSERT BIU Font B PAGE LAYOUT 11 A A June 1 Bal. June 13 deposit June 22 deposit June 29 deposit June 30 deposit 920 600 Preparing a bank reconciliation. - Excel FORMULAS DATA REVIEW G с Cash % Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles The June bank statement and the cash T-account for Superior Printing Company 18,500 10,000 35,000 17,000 28,000 D Serv. Charge Interest Earned ^^^ 440 Check # 100 1,200 Check #101 500 1,200 250 80 9,800 350 4,600 770 E Check #102 Check #103 VIEW Check # 104 Check #105 Check #106 Check #107 Check # 108 Check #109 AL HAAA 50 30 GJ F ♫ Sign In 59,570 59,000 X Y 28 29 30 800 OWNHO 31 32 33 34 35 42 43 4 45 45 47 48 45 50 51 44 A 46 49 June 30 Bal. B READY Attempt(s) C 36 37 Required: 38 Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. 39 Additional information: 40 There were no deposits in transit or outstanding checks at May 31. 41 Note: Columns C and F must be entered as positive values. In columns B & E, use cell references 42 to the appropriate items from the list below. List "Deductions" in chronological order (earliest item first). Bank Error NSF Check Outstanding Checks Recording Error Service Charge Deposits in Transit EFT from Customer Interest Earned 82,190 D Updates to Bank Statement Sheet 1 350 4,600 770 4,900 700 920 600 E Check #107 Check # 108 SUPERIOR PRINTING COMPANY Bank Reconciliation At June 30 Check #109 Check #110 Check #111 Check #112 Check #113 F Updates to Company's Books Hint 1 + Show Me 4 ▸ 100% i A 49 50 51 52 Bank statement balance 53 Additions: 54 55 Deductions: 56 57 58 Adjusted bank balance 59 60 61 62 READY Attempt(s) Updates to Bank Statement B Sheet 1 +) C Bank Reconciliation At June 30 D Book balance Additions: Deductions: Updates to Company's Books Adjusted book balance E 4 F Hint ▸ 100% Show Me Paste Clipboard A1 3 4 5 6 1.000 7 8 9 10 11 FILE 2 日か 12 13 14 15 5 6 16 1. Prepare a bank reconciliation using a company's bank statement and cash account. HOME Г Date June 1 3 8545NOWO ∞ A 10 13 A B с D E 1 The June bank statement and the cash T-account for Superior Printing Company is shown below. 2 20 22 26 27 29 Calibri 30 INSERT B I U Y Font X 11 T ▾ PAGE LAYOUT Checks A A Preparing a bank reconciliation. - Excel FORMULAS DATA REVIEW 5 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 % Alignment Number Conditional Format as Cell Formatting Table Styles Styles fix The June bank statement and the cash T-account for Superior Printing Company BANK STATEMENT Deposits 10,000 35,000 17,000 Other VIEW NSF Serv. Charge Cells Editing No 840 50 F Balance Sign In n 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 X V 4 Paste A1 16 Clipboard G FILE 17 18 19 20 21 22 23 24 25 26 27 7898 28 29 30 1. Prepare a bank reconciliation using a company's bank statement and cash account. HOME A 30 30 Calibri INSERT BIU Font B PAGE LAYOUT 11 A A June 1 Bal. June 13 deposit June 22 deposit June 29 deposit June 30 deposit 920 600 Preparing a bank reconciliation. - Excel FORMULAS DATA REVIEW G с Cash % Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles The June bank statement and the cash T-account for Superior Printing Company 18,500 10,000 35,000 17,000 28,000 D Serv. Charge Interest Earned ^^^ 440 Check # 100 1,200 Check #101 500 1,200 250 80 9,800 350 4,600 770 E Check #102 Check #103 VIEW Check # 104 Check #105 Check #106 Check #107 Check # 108 Check #109 AL HAAA 50 30 GJ F ♫ Sign In 59,570 59,000 X Y 28 29 30 800 OWNHO 31 32 33 34 35 42 43 4 45 45 47 48 45 50 51 44 A 46 49 June 30 Bal. B READY Attempt(s) C 36 37 Required: 38 Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. 39 Additional information: 40 There were no deposits in transit or outstanding checks at May 31. 41 Note: Columns C and F must be entered as positive values. In columns B & E, use cell references 42 to the appropriate items from the list below. List "Deductions" in chronological order (earliest item first). Bank Error NSF Check Outstanding Checks Recording Error Service Charge Deposits in Transit EFT from Customer Interest Earned 82,190 D Updates to Bank Statement Sheet 1 350 4,600 770 4,900 700 920 600 E Check #107 Check # 108 SUPERIOR PRINTING COMPANY Bank Reconciliation At June 30 Check #109 Check #110 Check #111 Check #112 Check #113 F Updates to Company's Books Hint 1 + Show Me 4 ▸ 100% i A 49 50 51 52 Bank statement balance 53 Additions: 54 55 Deductions: 56 57 58 Adjusted bank balance 59 60 61 62 READY Attempt(s) Updates to Bank Statement B Sheet 1 +) C Bank Reconciliation At June 30 D Book balance Additions: Deductions: Updates to Company's Books Adjusted book balance E 4 F Hint ▸ 100% Show Me
Expert 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 accounting questions
-
Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller...
-
create a Memo Analysis below: evaluate a cost analysis and make a decision based on cost comparatives of two or more alternatives, the manager consider relevant and incremental costs only. Thank you....
-
Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, If in a blank cell, "= entered, the formula would output the result from cell C6, or...
-
Q1 The spectrum of two light sources A and B are shown in Figure 1(a) and Figure 1(b) respectively: W Light Source A 10. wwwth [nm] 1.045,24 11.A Light Source B MA MA 1 ww.alanghem MA Figure 1(a)...
-
1. What are some competitive forces that human resource management consultant will consider in conducting a strategic analysis to determine compensation practices? 2. How will being in the growth...
-
In Fig. 2: Find the shaded area A 2 . Y 0 A Figure 2 cos x Td4 TV2 Ag sin x T Xx
-
Discuss the importance of reporting births and deaths.
-
A firm has $ 1.5 million in sales, a Lerner index of 0.57, and a marginal cost of $ 50, and competes against 800 other firms in its relevant market. a. What price does this firm charge its customers?...
-
Hemingway Company purchases equipment by issuing a 7-year, $280,000 non-interest-bearing note, when the market rate for this type of note is 8%. Hemingway will pay off the note with equal payments to...
-
A cone rolls without slipping on a table. The half-angle at the vertex is ?, and the axis of the cone has length h (see Fig.). Let the speed of the center of the base (label this as point P) be v....
-
III. GregIFER inc., a Spain-based company, imports merchandise produced in Argentina. The price in the factory is 2,000,000. The expenses incurred during the transaction are: Transport costs from...
-
Watch three advertisements for any sporting goods on television. Briefly describe the advertisement and then suggest which core American value(s) are reflected in the theme of the advertisement.
-
Interview five adult sports participants and ask them to describe the sports socialization process as it relates to their personal experience. Attempt to interview people with different sports...
-
Prepare a report that describes how time pressures are influencing sports participation in the United States. How are sports marketers responding to increasing time pressures?
-
Using the World Wide Web, prepare a report that examines sport participation in Australia. What are the similarities and differences in the sports culture of Australia versus that of the United...
-
Interview five children (between the ages of eight and 12) to determine what role the family and other reference group influences have had on their decision to participate in sports. Suggest...
-
1. With neat diagram, Explain the construction, working, advantages, disadvantages and application of Axial Piston Pump in detail. (4 marks) 2.A hydraulicu intensifier chamber cylinder gets the low...
-
During the month, services performed for customers on account amounted to $7,500 and collections from customers in payment of their accounts totaled $6,000. At the end of the month, the Accounts...
-
While preparing Massie Miller's 2012 Schedule A, you review the following list of possible charitable deductions provided by Massie: Cash contribution to a family whose house burned...
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
Please answer the following questions regarding the taxability of Social Security: a. A 68-year-old taxpayer has $20,000 in Social Security income and $100,000 in tax-free municipal bond income. Does...
-
Why is macroeconomic forecasting so difficult? Does this difficulty mean economics is a worthless field of study?
-
Which of the following statements are positive in nature and which are normative? a. A tax cut will raise interest rates. b. A reduction in the payroll tax would primarily benefit poor and...
-
Graph the behavior of the civilian unemployment rate from 1961 until the present using monthly data. Can you see the periods of recession that occurred in 19691970, 19731975, 1980, 19811982,...
Study smarter with the SolutionInn App