Answered step by step
Verified Expert Solution
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!
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started