Please use the following template and complete the bank reconciliation
Dunlap's Cash account shows a balance of $16,740 at December 31. On December 31 , Dunlap Insurance received the following bank statement: Ending Balance 17,350 Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge. Additional data for the bank reconciliation follows: 1. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. 2. The NSF check was received from a customer. 3. The $1,400 bank collection was for a note receivable. 4. The correct amount of check 1419 for rent expense is $1,940. Dunlap's controller mistakenly recorded the check for $1,490 Requirements: AD34 [G Copy Clipboard y Font Alignment General \begin{tabular}{l|l|l} & B & C \\ \hline 4 \end{tabular} D E G H BANK RECONCILIATION Date 12/31/2012 BANK: 10 Balance, December 31, 2012 11 12 Add: Deposits in Transit 13 14 15 Less: Outstanding Checks: 16 Check No. 17 Check No. 18 Check No. 1420 19 ADJUSTED BANK BALANCE, DECEMBER 31, 2012 24 Balance, December 31, 2012 Add: EFT Collection of Rent 7 Add: Bank Collection of Note Receivable 29 Less: 30 CHECK \#1419 ERROR 31 NSF CHECK 32 EFT PAYMENT OF INSURANCE 33 BANK SERVICE CHARGE 34 ADJUSTED BOOK BALANCE, DECEMBER 31, 2012 3635 37 BALANCED? \begin{tabular}{lll} & $ \\ & 1 \\ & & $ \\ S & - & \\ S & - & $ \\ \hline \end{tabular} \begin{tabular}{l} $ \\ $ \\ \hline \end{tabular} $ S $ 3938 40 JOURNAL ENTRIES 42 DEBIT: CASH 43 CREDIT: RENT RECEIVABLE $ DEBIT: CASH CREDIT: NOTE RECEIVABLE DEBIT: BANK FEES CREDIT: CASH 51 DEBIT: INSURANCE EXPENSE 52 CREDIT: CASH 54 DEBIT: BANK FEES 55 CREDIT: CASH 57 DEBIT: CHECK ERROR \#1419 CREDIT: CASH is 5958 i 4 $ 22BC Checks a 12/8/201 11 19 29 Che 31 (Chec 31 Ending B Eu 6160 $ $ $ $ equ Ready Scroll Lock 72F Dunlap's Cash account shows a balance of $16,740 at December 31. On December 31 , Dunlap Insurance received the following bank statement: Ending Balance 17,350 Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge. Additional data for the bank reconciliation follows: 1. The EFT credit was a receipt of rent. The EFT debit was an insurance payment. 2. The NSF check was received from a customer. 3. The $1,400 bank collection was for a note receivable. 4. The correct amount of check 1419 for rent expense is $1,940. Dunlap's controller mistakenly recorded the check for $1,490 Requirements: AD34 [G Copy Clipboard y Font Alignment General \begin{tabular}{l|l|l} & B & C \\ \hline 4 \end{tabular} D E G H BANK RECONCILIATION Date 12/31/2012 BANK: 10 Balance, December 31, 2012 11 12 Add: Deposits in Transit 13 14 15 Less: Outstanding Checks: 16 Check No. 17 Check No. 18 Check No. 1420 19 ADJUSTED BANK BALANCE, DECEMBER 31, 2012 24 Balance, December 31, 2012 Add: EFT Collection of Rent 7 Add: Bank Collection of Note Receivable 29 Less: 30 CHECK \#1419 ERROR 31 NSF CHECK 32 EFT PAYMENT OF INSURANCE 33 BANK SERVICE CHARGE 34 ADJUSTED BOOK BALANCE, DECEMBER 31, 2012 3635 37 BALANCED? \begin{tabular}{lll} & $ \\ & 1 \\ & & $ \\ S & - & \\ S & - & $ \\ \hline \end{tabular} \begin{tabular}{l} $ \\ $ \\ \hline \end{tabular} $ S $ 3938 40 JOURNAL ENTRIES 42 DEBIT: CASH 43 CREDIT: RENT RECEIVABLE $ DEBIT: CASH CREDIT: NOTE RECEIVABLE DEBIT: BANK FEES CREDIT: CASH 51 DEBIT: INSURANCE EXPENSE 52 CREDIT: CASH 54 DEBIT: BANK FEES 55 CREDIT: CASH 57 DEBIT: CHECK ERROR \#1419 CREDIT: CASH is 5958 i 4 $ 22BC Checks a 12/8/201 11 19 29 Che 31 (Chec 31 Ending B Eu 6160 $ $ $ $ equ Ready Scroll Lock 72F
