50.1K

Verified Solution

Link Copied!

create bank recon for the following

Business Checking Beginning Balance Deposit / Credits Withdraws / Debits $0.00 $ 47,115.00 $ 19,259.00 Trans. Date 1-Jul Cash deposit at the branch 5-Jul Ch # 001 5-Jul Deposit by check 6-Jul Ch # 002 6-Jul Deposit by check 10-Jul Ch # 003 12-Jul Ch # 004 16-Jul Ch # 005 17-Jul Cash deposit at the branch 18-Jul Debit card transaction 24-Jul Cash deposit at the branch 26-Jul Deposit by check 28-Jul Ch # 006 30-Jul Cash deposit at the branch 31-Jul Deposit Interest rate 0.100% 31-Jul Branch service fee 31-Jul Withdraw Debit Card, Intuit QuickBooks 800-466-8848 Ending Balance YTD Interest $ 27,856.00 $ 15.00 Deposit Withdraw Balance 13500 13500 5000 8500 5500 14000 4500 9500 15300 24800 400 24400 5200 19200 1750 17450 450 17900 600 17300 200 17500 12000 29500 1750 27750 150 27900 27915 27905 49 27856 Cleared checks (amounts already deducted in above section): Check# Date Amount Check # Date Ch # 001 5000 Ch #004 12-Jul Ch # 002 6-Jul 4500 Ch # 005 16-Jul Ch # 003 10-Jul 400 Ch # 006 28-Jul 5-Jul Amount 5200 1750 1750 Business Checking Beginning Balance Deposit / Credits Withdraws / Debits $0.00 $ 47,115.00 $ 19,259.00 Trans. Date 1-Jul Cash deposit at the branch 5-Jul Ch # 001 5-Jul Deposit by check 6-Jul Ch # 002 6-Jul Deposit by check 10-Jul Ch # 003 12-Jul Ch # 004 16-Jul Ch # 005 17-Jul Cash deposit at the branch 18-Jul Debit card transaction 24-Jul Cash deposit at the branch 26-Jul Deposit by check 28-Jul Ch # 006 30-Jul Cash deposit at the branch 31-Jul Deposit Interest rate 0.100% 31-Jul Branch service fee 31-Jul Withdraw Debit Card, Intuit QuickBooks 800-466-8848 Ending Balance YTD Interest $ 27,856.00 $ 15.00 Deposit Withdraw Balance 13500 13500 5000 8500 5500 14000 4500 9500 15300 24800 400 24400 5200 19200 1750 17450 450 17900 600 17300 200 17500 12000 29500 1750 27750 150 27900 27915 27905 49 27856 Cleared checks (amounts already deducted in above section): Check# Date Amount Check # Date Ch # 001 5000 Ch #004 12-Jul Ch # 002 6-Jul 4500 Ch # 005 16-Jul Ch # 003 10-Jul 400 Ch # 006 28-Jul 5-Jul Amount 5200 1750 1750

Answer & Explanation Solved by verified expert

See Answer