Hello,

I need help with this problem.

I included details in the attached document

Please create an excel bank reconciliation, to answer questions

Thank you

Bank reconciliation and Journal Entries Cash Receipts Date Cash Debit Dec. 4 $4,000 9 510 14 550 17 2,150 31 1,830 Cash Payments Check No Cash Credit 888 $840 889 170 890 680 891 1,190 892 1,470 893 1,200 894 630 ABC Comp Cash account shoes balance of $17,050 at June 31, ABC Comp Additional data 1. 2. 3. 4. EFT credit was a receipt of rent. The EFT debt was a ABC payment The NFS check was received from a customer The $1,600 bank collection was a for a note receivable The correct amount of check 891 for rent expense is $1,910. ABC Comp controller mistakenly recorded the check $1,190 Requirements 1. Prepare the bank reconciliation for ABC Company June 31,2017 2. Journalize any required from the bank reconciliation