Question

I need help with my excel spreadsheet

X for Use the following information to prepare a bank reconciliation for Handy Comp F G H om BANK RECONCILIATION & JOURNAL ENTRIES 1) Use the following information to prepare a bank reconciliation for Handy Company for August 31, 201 62) Once you complete the bank reconciliation, prepare any necessary journal entries. a) Balance per bank at August 31 is $10,279.43. b) Balance per book at August 31 is $11,769 21 c) Outstanding check 654 for $650 d) Outstanding check 649 for $21 e) Deposits in transit 8/30 for $722 f) Deposits in transit 8/31 for $1,435 g) The bank service charge is $25. h) Interest earned from bank is $3 22 1) A check to Green Software for $896 was recorded as $869 in the journal. D) An insufficient check from Henry Gold a customer was charged to our account by the bank in the a k) Cash sales for the month totaled $324 and were recorded incorrectly in the journal at $234. Assets Depreciation HANDY COMPANY Bank Reconciliation Bank Reconciliation Uncollectible Accounts Notes Receivable Select destination and press ENTER or choose Paste n Tyne here to search & B 9 Wi e B

that is all that is on the spreadsheet

Answer 1

HANDY COMPANY
Bank Reconciliation
August 31, 2019
Cash balance according to bank statement		$10,279.43
Add: Deposit in transit 8/30	$722.00
Deposit in transit 8/30	$1,435.00	$2,157.00
Subtotal		$12,436.43
Deduct: Outstanding checks 654	$650.00
Outstanding checks 649	$21.00	$671.00
Adjusted Balance		$11,765.43
Cash balance according to company's records		$11,769.21
Add: Interest Earned	$3.22
Error in recording cash sales	$90.00	$93.22
Subtotal		$11,862.43
Deduct: Bank service charges	$25.00
Error	$27.00
NSF Check	$45.00	$97.00
Adjusted Balance		$11,765.43