In: Accounting
The Oriole Boat Company's bank statement for the month of November showed a balance per bank of $8,800. The company's Cash account in the general ledger had a balance of $6,778 at November 30. Other information is as follows:
(1) | Cash receipts for November 30 recorded on the company's books were $6,020 but this amount does not appear on the bank statement. | ||
(2) | The bank statement shows a debit memorandum for $40 for check printing charges. | ||
(3) | Check No. 119 payable to Ivanhoe Company was recorded in the cash payments journal and cleared the bank for $348. A review of the accounts payable subsidiary ledger shows a $36 credit balance in the account of Ivanhoe Company and that the payment to them should have been for $384. | ||
(4) | The total amount of checks still outstanding at November 30 amounted to $5,420. | ||
(5) | Check No. 138 was correctly written and paid by the bank for $408. The cash payment journal reflects an entry for Check No. 138 as a debit to Accounts Payable and a credit to Cash in Bank for $480. | ||
(6) | The bank returned an NSF check from a customer for $510. | ||
(7) | The bank included a credit memorandum for $3,100 which represents a collection of a customer's note by the bank for the company; the principal amount of the note was $3,011 and interest was $89. Interest has not been accrued. |
Prepare a bank reconciliation for the Oriole Boat Company at November 30.
ORIOLE BOAT COMPANY Bank Reconciliation For the Year Ended November 30For the Month Ended November 30November 30 |
|||||
---|---|---|---|---|---|
select an opening name for section one Outstanding ChecksCheck PrintingAdjusted Cash Balance Per BankCollection of Note and InterestCash Balance Per BankAccounts Payable ErrorDeposit in TransitAdjusted Cash Balance Per BooksNSF Check | $enter a dollar amount | ||||
select between addition and deduction AddLess: select a reconciling item Check PrintingAdjusted Cash Balance Per BankAccounts Payable ErrorAdjusted Cash Balance Per BooksDeposit in TransitOutstanding ChecksCollection of Note and InterestCash Balance Per BankNSF Check |
enter a dollar amount | ||||
enter a subtotal of the two previous amounts | |||||
select between addition and deduction AddLess: select a reconciling item Accounts Payable ErrorOutstanding ChecksCheck PrintingCash Balance Per BankDeposit in TransitAdjusted Cash Balance Per BankCollection of Note and InterestAdjusted Cash Balance Per BooksNSF Check |
enter a dollar amount | ||||
select a closing name for section one Deposit in TransitAdjusted Cash Balance Per BooksAdjusted Cash Balance Per BankOutstanding ChecksCollection of Note and InterestAccounts Payable ErrorCash Balance Per BankNSF CheckCheck Printing | $enter a total amount for the first section | ||||
select an opening name for section two Accounts Payable ErrorCheck PrintingDeposit in TransitNSF CheckCash Balance Per BooksOutstanding ChecksAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksCollection of Note and Interest | $enter a dollar amount | ||||
select between addition and deduction LessAdd: |
|||||
select a reconciling item Check PrintingDeposit in TransitCollection of Note and InterestNSF CheckAccounts Payable ErrorCash Balance Per BooksAdjusted Cash Balance Per BankOutstanding ChecksAdjusted Cash Balance Per Books | $enter a dollar amount | ||||
select a reconciling item Outstanding ChecksCheck PrintingAdjusted Cash Balance Per BooksCollection of Note and InterestAccounts Payable ErrorAdjusted Cash Balance Per BankNSF CheckDeposit in TransitCash Balance Per Books | aenter a dollar amount | ||||
enter a subtotal of the two previous amounts | |||||
enter a subtotal of the two previous amounts | |||||
select between addition and deduction LessAdd: |
|||||
select a reconciling item Cash Balance Per BooksAdjusted Cash Balance Per BooksAdjusted Cash Balance Per BankOutstanding ChecksNSF CheckCollection of Note and InterestAccounts Payable ErrorCheck PrintingDeposit in Transit | enter a dollar amount | ||||
select a reconciling item NSF CheckAccounts Payable ErrorAdjusted Cash Balance Per BooksAdjusted Cash Balance Per BankOutstanding ChecksCollection of Note and InterestDeposit in TransitCash Balance Per BooksCheck Printing | enter a dollar amount | ||||
enter a subtotal of the two previous amounts | |||||
select a closing name for section two Check PrintingDeposit in TransitNSF CheckAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksAccounts Payable ErrorOutstanding ChecksCash Balance Per BooksCollection of Note and Interest | $enter a total amount for the second section |
Prepare any adjusting entries necessary as a result of the bank reconciliation.