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)...
-
What must the water pressure be to supply the second floor (18.0 ft up) with a pressure of 50.0 lb/in2 at that level?
-
In the calculation of earnings per share, why is the weighted average number of common shares used instead of the number of common shares at the end of the year?
-
The impact of employee and management fraud is staggering both in terms of dollar costs and the effect on the victims. For each of the following independent cases of employee fraud, describe the...
-
Theory of constraints, contribution margin , sensitivity analysis. Low Tech Toys (LTT) produces dolls in two processes: molding and assembly. LTT is currently producing two models: Chatty Chelsey and...
-
Match the following descriptions with the correct order of trusts: Allows naming donor as income beneficiary and charity as remainder beneficiary. Trust pays fixed annuity to donor based on the...
-
Using exponential smoothing with trend, a smoothing constant of 4, if the forecast for January had been 110, compute what the exponential forecast would have been for the month of April using January...
-
Define primary key and foreign key. Name and describe the components of a Database Management System (DBMS) Name and describe the five characteristics of a data warehouse. Describe Online Transaction...
-
Define uncovered interest rate parity (UIP). Derive the equations of UIP in both levels and logs. (b) Let the spot rate between the UK and Canada be 3.5 CAD/GBP, and the Canadian 6 month (annualized)...
-
Jim Smith holds a $150,000 portfolio consisting of the following stocks: Stock A B Total Investment (S) 60,000 90,000 $150,000 What is the portfolio's beta? (Hint: take a weighted average.) Beta 0.95...
-
The following three defense stocks are to be combined into a stock index in January 2019 (perhaps a portfolio manager believes these stocks are an appropriate benchmark for his or her performance)....
-
Tango Company produces joint products M, N, and T from a joint process. This information concerns a batch produced in April at a joint cost of $155,000: After Split-Off Product Units Produced and...
-
A company's fixed operating costs are $670,000, its variable costs are $3.15 per unit, and the product's sales price is $5.50. What is the company's break-even point; that is, at what unit sales...
-
Consider a grasshopper located at stone wants to go to stone 9. The grasshopper can jump either one or two stones at a time, and it does not take any steps back. This means that it can go to 9...
-
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...
-
Determine the months in backlog using the work on hand spreadsheet. The companys revenues for the last 12 months were \($1,607,000\).
-
The construction company needs to lease an excavator. The company has the option to lease it with an operating lease or a capital lease with a present value of \($150,000\). Using the spreadsheet you...
-
The ACWP at the end of the second week for the project in Problem 10 is \($37,900\) Determine the CPI for the project. Data From Problem 11: 11. A project consists of six tasks. Task A is scheduled...
Study smarter with the SolutionInn App