Question
Ivanhoe Food Store used the following information in recording its bank reconciliation for the month of April. Balance per books April 30 $ 910 Balance
Ivanhoe Food Store used the following information in recording its bank reconciliation for the month of April.
Balance per books April 30 | $ 910 | |
Balance per bank statement April 30 | $ 13,600 |
(1) | Checks written in April but still outstanding $ 7,900. | ||
(2) | Checks written in March but still outstanding $ 4,500. | ||
(3) | Deposits of April 30 not yet recorded by bank $ 5,800. | ||
(4) | NSF check of customer returned by bank $ 520. | ||
(5) | Check No. 210 for $ 783 was correctly issued and paid by the bank but incorrectly entered in the cash payments journal as payment on account for $ 738. | ||
(6) | Bank service charge for April was $ 35. | ||
(7) | A payment on account was incorrectly entered in the cash payments journal and posted to the accounts payable subsidiary ledger for $ 615 when Check No. 318 was correctly prepared for $ 165. The check cleared the bank in April. | ||
(8) | The bank collected a note receivable for the company of $ 6,000 plus $ 240 interest revenue. |
Prepare a bank reconciliation at April 30.
IVANHOE FOOD STORE Bank Reconciliation April 30For the Month Ended April 30For the Year Ended April 30 | ||||
---|---|---|---|---|
select an opening name for section one Bank Service ChargeError on Check No. 210NSF CheckError on Check No. 318Apr. Outstanding ChecksCash Balance Per BankAdjusted Cash Balance Per BankMar. Outstanding ChecksCollection of Note and InterestDeposit in Transit | $ enter a dollar amount | |||
select between addition and deduction AddLess: select a reconciling item Deposit in TransitCollection of Note and InterestError on Check No. 210Adjusted Cash Balance Per BankMar. Outstanding ChecksError on Check No. 318Cash Balance Per BankApr. Outstanding ChecksNSF CheckBank Service Charge | enter a dollar amount | |||
enter a subtotal of the two previous amounts | ||||
select between addition and deduction AddLess: | ||||
select a reconciling item Adjusted Cash Balance Per BankMar. Outstanding ChecksError on Check No. 210Collection of Note and InterestCash Balance Per BankBank Service ChargeDeposit in TransitNSF CheckApr. Outstanding ChecksError on Check No. 318 | enter a dollar amount | |||
select a reconciling item Collection of Note and InterestError on Check No. 318Deposit in TransitAdjusted Cash Balance Per BankMar. Outstanding ChecksNSF CheckCash Balance Per BankBank Service ChargeApr. Outstanding ChecksError on Check No. 210 | enter a dollar amount | |||
enter a subtotal of the two previous amounts | ||||
select a closing name for section one Bank Service ChargeDeposit in TransitNSF CheckAdjusted Cash Balance Per BankApr. Outstanding ChecksError on Check No. 318Collection of Note and InterestError on Check No. 210Cash Balance Per BankMar. Outstanding Checks | $ enter a total amount for the first section | |||
select an opening name for section two Adjusted Cash Balance Per BooksError on Check No. 318Error on Check No. 210Mar. Outstanding ChecksDeposit in TransitCash Balance Per BooksNSF CheckApr. Outstanding ChecksBank Service ChargeCollection of Note and Interest | $ enter a dollar amount | |||
select between addition and deduction AddLess: | ||||
select a reconciling item Deposit in TransitBank Service ChargeError on Check No. 318NSF CheckMar. Outstanding ChecksCash Balance Per BooksAdjusted Cash Balance Per BooksCollection of Note and InterestError on Check No. 210Apr. Outstanding Checks | $ enter a dollar amount | |||
select a reconciling item Cash Balance Per BooksMar. Outstanding ChecksDeposit in TransitError on Check No. 318Error on Check No. 210Collection of Note and InterestBank Service ChargeNSF CheckAdjusted Cash Balance Per BooksApr. Outstanding Checks | enter a dollar amount | |||
enter a subtotal of the two previous amounts | ||||
enter a subtotal of the two previous amounts | ||||
select between addition and deduction AddLess: | ||||
select a reconciling item Deposit in TransitError on Check No. 318Error on Check No. 210NSF CheckCollection of Note and InterestApr. Outstanding ChecksBank Service ChargeCash Balance Per BooksMar. Outstanding ChecksAdjusted Cash Balance Per Books | enter a dollar amount | |||
select a reconciling item Deposit in TransitMar. Outstanding ChecksError on Check No. 318Adjusted Cash Balance Per BooksNSF CheckCollection of Note and InterestBank Service ChargeCash Balance Per BooksApr. Outstanding ChecksError on Check No. 210 | enter a dollar amount | |||
select a reconciling item Bank Service ChargeNSF CheckMar. Outstanding ChecksAdjusted Cash Balance Per BooksApr. Outstanding ChecksError on Check No. 210Deposit in TransitError on Check No. 318Cash Balance Per BooksCollection of Note and Interest | enter a dollar amount | |||
enter a subtotal of the three previous amounts | ||||
select a closing name for section two Deposit in TransitAdjusted Cash Balance Per BooksBank Service ChargeMar. Outstanding ChecksError on Check No. 318Error on Check No. 210Apr. Outstanding ChecksCash Balance Per BooksCollection of Note and InterestNSF Check | $ enter a total amount for the second section |
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