Concept explainers
Prepare bank reconciliation of Company SI as at July 31.
Answer to Problem 5PB
The adjusted cash balance per bank, and the adjusted cash balance per books of Company SI is $11,494.0
Explanation of Solution
Bank reconciliation: Bank statement is prepared by bank. The company maintains its own records from its perspective. This is why the cash balance per bank and cash balance per books seldom agree. Bank reconciliation is the statement prepared by company to remove the differences and disagreement between cash balance per bank and cash balance per books.
Debit and credit rules:
- ■ Debit an increase in asset account, increase in expense account, decrease in liability account, and decrease in
stockholders’ equity accounts. - ■ Credit decrease in asset account, increase in revenue account, increase in liability account, and increase in stockholders’ equity accounts.
Prepare bank reconciliation of Company SI as at July 31.
Company SI | ||
Bank Reconciliation | ||
At July 31 | ||
Particulars | Amount ($) | Amount ($) |
Cash balance as per bank statement | 11,601.41 | |
Add: | ||
Deposit of July 31, not recorded by bank | 1,177.84 | |
Less: Outstanding checks | ||
No : 613 | 137.50 | |
No : 628 | 837.70 | |
No : 633 | 310.08 | 1,285,.28 |
Adjusted cash balance per bank | 11,494.00 | |
Cash balance as per books | 7,664.00 | |
Add: | ||
Notes and interest receivable collected by bank | 4,160.00 | |
Error in July 23 deposit | 18.00 | |
Error in recording check no.627 | 63.00 | 4,241.00 |
Less: | ||
Checks returned because of insufficient funds | 375.00 | |
Bank service charges | 36.00 | 411.00 |
Adjusted cash balance per books | 11,494.00 | |
Table (1)
Working Notes:
Determine the balance per company’s book, June 30
Reasons
- ■ The deposits which are not recorded by the bank are referred to as deposits in transit. Since the deposits in transit are not reflected on the bank statement, the company should add deposits in transit to cash balance per bank, while preparation of
bank reconciliation statement . - ■ Outstanding checks are the checks that are issued by the company, but not yet paid by the bank. When the check is issued for payment, the company deducts the cash balance immediately. But the bank deducts only when the cash is paid for the issued check. So, company deducts the cash balance per bank to remove the differences.
- ■ Notes receivable being collected by bank, is credited to bank account. But the company is not aware of it. So, while preparing bank reconciliation statement, company should add the amount to the cash balance per books.
- ■ Error in recording checks and banks deducting service charge for the services rendered like lock box rental, or printed checks. But the company is not aware of such deductions. So, company deducts the cash balance per books while bank reconciliation preparation.
(2)
Prepare
(2)
Explanation of Solution
Prepare journal entry to record account receivable collected by bank.
Date | Account Titles and Explanation | Ref. | Debit ($) | Credit ($) | |
July | 31 | Cash | 4,241.00 | ||
Notes Receivable | 4,000.00 | ||||
Interest Revenue | 160.00 | ||||
Sales | 18.00 | ||||
Accounts payable | 63.00 | ||||
(To record receivable collected by bank) |
Table (2)
- ■ Cash is an asset account. The amount is increased because bank collected note receivable, and an increase in assets should be debited.
- ■ Notes Receivable is an asset account. The amount has decreased because the amount to be received is collected by the bank, and, a decrease in assets should be credited.
- ■ Interest revenue is a revenue account and increases the stockholders’ equity. Thus, increases in the stockholders’ equity should be credited.
- ■ Sales is revenue and increases the stockholders’ equity. So, credit the same.
- ■ Accounts payable is a liability and decreased as there is receipt of cash. So, credit accounts payable account.
Prepare journal entry to record book error amount.
Date | Accounts and Explanation | Post Ref. | Debit ($) | Credit ($) | |
June | 30 | Accounts receivables | 375.00 | ||
Miscellaneous expenses | 36.00 | ||||
Cash | 411.00 | ||||
(To record amount under-payable by accountant) |
Table (3)
- ■
Accounts receivable is an asset account. It is increased and thus, current asset is increased and debited. - ■ Miscellaneous expenses are expenses account and decrease the stockholders’ equity. Thus, decrease in the stockholders’ equity should be debited.
- ■ Cash is an asset account. The amount is decreased to pay the under-paid check, and a decrease in asset is credited.
(3)
Report amount of cash in the
(3)
Explanation of Solution
Thus, the adjusted balance from the bank reconciliation should be reported as cash on the July 31 balance sheet for SI is $11,494.00.
(4)
Explain the error to be included in the bank reconciliation.
(4)
Explanation of Solution
Error amount of $1,620 ($1,800 – $180) is the cancelled check. It is added in the “balance according to bank statement” on the bank reconciliation statement. Thus, the cancelled checks are being presented in the bank. When the check is presented to the bank, bank balance is corrected.
Want to see more full solutions like this?
Chapter 8 Solutions
Financial Accounting
- The bank reconciliation revealed that one deposit had cleared the bank two weeks after the date of the deposit. Should this be of concern? Why, or why not?arrow_forwardUsing the following information, prepare a bank reconciliation. Bank balance: $12,565. Book balance: $13,744. Deposits in transit: $2,509. Outstanding checks: $1,777. Bank charges: $125. Bank incorrectly charged the account for $412. The bank will correct the error next month. Check number 1879 correctly cleared the bank in the amount of $562 but posted in the accounting records as $652. This check was expensed to Utilities Expense.arrow_forwardUsing the following information, prepare a bank reconciliation. Bank balance: $4,587 Book balance: $5,577 Deposits in transit: $1,546 Outstanding checks: $956 Interest income: $56 NSF check: $456arrow_forward
- The bank reconciliation shows the following adjustments. Deposits in transit: $526 Outstanding checks: $328 Bank charges: $55 NSF checks: $69 Prepare the correcting journal entry.arrow_forwardBeeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. Cash Account Balance of june 1 $9,317.40 Cash receipts fro month of june $9,223.76 Duplicate Deposit tickets Date and amount of each deposit in june : Date Amount Date Amount Date Amount june 1 $1,080.50 june 10 $ 996.61 june 22 $897.34 june 3 854.17 june 15 882.95 june 24 947.21 june 8 840.50 june 17 1,606.74 june 30 1,117.74 CHECKS WRITTEN : Number and amount of each check issued in june : Check no . Amount Check no. Amount Check no. Amount 740 $237.50 747 Void 754 $449.75 741 495.15 748 $450.90 755 272.75 742 501.90 749 640.13 756 113.95 743 761.30 750 276.77 757 407.95…arrow_forwardBeeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: Balance as of June 1 $9,317.40 CASH RECEIPTS FOR MONTH OF JUNE $9,223.76 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June: Date Amount Date Amount Date Amount June 1 $1,080.50 June 10 $996.61 June 22 $897.34 3 854.17 15 882.95 24 947.21 8 840.50 17 1,606.74 30 1,117.74 CHECKS WRITTEN: Number and amount of each check issued in June: Check No. Amount Check No. Amount Check No. Amount 740 $237.50 747 Void 754 $449.75 741 495.15 748 $450.90 755 272.75 742 501.90 749…arrow_forward
- Required:1. Prepare a bank reconciliation as of February 28.2. Prepare adjusting entries for Valentine based on the information developed in the bank reconciliation.3. What is the amount of cash that should be reported on the February 28 balance sheet?arrow_forwardBank Reconciliation Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30, 20Y2, have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. Refer to the June Bank Statement (2nd attached image) Required: 1. Prepare a bank reconciliation as of June 30, 20Y2. If errors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales. All checks are written to satisfy accounts payable. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. "Add:" & "Deduct:" will automatically appear if it is required. Round your answers to two decimal places. For those boxes in which you must enter subtracted…arrow_forwardBeeler Furniture Company deposits all cash receipts cach Wednesday and Friday in a night depository after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: $9,317.40 $9,223.76 Balance as of June 1 CASH RECEIPTS FOR MONTH OF JUNE DUPLICATE DEPOSITTICKETS: Date and amount of each deposit in June: Amount Date Date Amount Date Amount $ 996.61 $1,080.50 854.17 $ 897.34 June 10 June 1 June 22 15 882.95 24 947.21 840.50 17 1,606.74 30 1,117.74 CHECKS WRITTEN: Number and amount of each check issued in June: Check No. Check No. Amount Amount Check No. Amount 740 $ 449.75 $237.50 747 Void 754 272.75 741 495.15 748 $450.90 755 742 501.90 749 640.13 756 113.95 743 276.77 761.30 750 757 407.95 744 506.88 751 299.37 758 259.60 745 117.25 752 537.01 759 901.50 746 298.66 753…arrow_forward
- A table for a monthly bank reconciliation dated September 30 is given below. For each item 1 through 12, indicate whether the item should be added to or subtracted from the book or bank balance, and whether it should or should not appear on the reconciliation.arrow_forwardBank reconciliation and entries Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproducedmas follows. The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: Balance as of June 1 $9,317.40 CASH RECEIPTS FOR MONTH OF JUNE $9,223.76 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June: Beeler Furniture Company Bank Reconciliation May 31 20Y2 Cash balance according to bank statement $ 9,447.20 Add deposit for May 31, not recorded by bank 690.25 Deduct outstanding checks: No. 731 $162.15 736 345.95 738 251.40 739 60.55 820.05 Adjusted balance $ 9,317.40 Cash balance according to company's records $ 9,352.50 Deduct bank service charges 35.10…arrow_forwardBank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal Final Questions X Instructions Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of June 30, 20Y2, have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: Balance as of June 1 $9,317.40 CASH RECEIPTS FOR MONTH OF JUNE 9,223.76 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June: Date Amount Date Amount Date Amount June 1 $1,080.50 June 10 $996.61 June 22 $897.34 3 854.17 15 882.95 24 947.21 8 840.50 17 1,606.74 30 1,117.74 CHECKS WRITTEN: Number and amount of each check issued in June:…arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning