Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer Please thanks! FILE A1 VASAW33 fx Function Defined Formula - Calculation Library Names Auditing Options- 5 10 11 13 1. Prepare a bank reconciliation

Answer Please thanks!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
FILE A1 VASAW33 fx Function Defined Formula - Calculation Library Names Auditing Options- 5 10 11 13 1. Prepare a bank reconciliation using a company's bank statement and cash account. #1 HOME F2 X fr The June bank statement and the cash T-account for Superior Printing Compa A B C D E 1 The June bank statement and the cash T-account for Superior Printing Company is shown below. Date June 1 TEABGE22 3 4 8 10 13 20 TF3 INSERT 3 1 PAGE LAYOUT Checks $ F4 4 Calculation Calculate Now Calculate Sheet Preparing a bank reconciliation Excel FORMULAS DATA REVIEW 440 1,200 500 1,200 250 80 9800 Q BANK STATEMENT Deposits 5 a 10,000 35 000 F6 A Other 6 Prev NSF ? 1 of 1 ASUS VivoBook 08 D VIEW 7 30 840 Next > 9 8 ? D 2 F Balance 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49 190 F10 signment #1 i June 1 0 3 5 16 7 18 090423 19 21 3430322 8 10 13 26 27 29 30 30 READY Attempt(s) June 1 Bal. June 13 deposit June 22 deposit June 29 deposit Sheet 1 *** 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 600 10,000 35,000 17,000 Cash 18,500 10,000 35,000 17,000 NSF Serv. Charge Interest Earned Saved 440 Check # 100 1,200 Check #101 500 Check # 102 4 840 50 30 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 + 100% Hint /ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&lau www June 1 Bal. June 13 deposit June 22 deposit June 29 deposit June 30 deposit June 30 Bal. Sheet 1 Cash 18,500 10,000 35,000 17,000 28,000 82,190 Earned Saved 440 Check #100 1,200 Check #101 500 Check #102 1,200 Check #103 250 Check #104 80 Check # 105 Check #106 Check #107 Check #108 Check # 109 Check #110 Check #111 Check #112 Check #113 9,800 350 4,600 770 4,900 700 920 600 E signment #1 i Required: Prepare a bank reconciliation for June using the bank statement and T-account above and the information below. Additional information: 6 7 There were no deposits in transit or outstanding checks at May 31. Note: Columns C and F must be entered as positive values. In columns B & E, use cell references to the appropriate items from the list below. List "Deductions" in chronological order (earliest item first). Bank Error NSF Check 4 s Deductions: 2 Bank statement balance 3 Additions: Deposits in Transit EFT from Customer Interest Earned READY Updates to Bank Statement 8 Adjusted bank balance 9 Sheet 1 SUPERIOR PRINTING COMPANY Bank Reconciliation At June 30 Outstanding Checks Recording Error Service Charge Saved Book balance Additions: Deductions: Updates to Company's Books +100 33

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Responsibility

Authors: Tom Cannon

2nd Edition

0273738739, 9780273738732

More Books

Students also viewed these Accounting questions