Concept explainers
(a)
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.
To prepare: Bank reconciliation of Company SI as at July 31, 2016
(a)
Answer to Problem 7.5BPR
Prepare bank reconciliation of Company SI as at July 31, 2016.
Company SI | ||
Bank Reconciliation | ||
July 31, 2016 | ||
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
Explanation of Solution
- 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.
(b)
To prepare:
(b)
Explanation of Solution
Prepare journal entry to record account receivable collected by bank.
Date | Account Titles and Description | Ref. | Debit ($) | Credit ($) | |
July | 31 | Cash | 4,241.00 | ||
Notes Receivable | 4,000 | ||||
Interest Revenue | 160.00 | ||||
Sales | 18.00 | ||||
Accounts payable | 63.00 | ||||
(To record receivable collected by bank) |
Table (2)
Description:
- 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 Description | 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)
Description:
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.
(c)
To report: Amount of cash in the
(c)
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
(d)
To explain: The error to be included in the bank reconciliation.
(d)
Explanation of Solution
Error amount of $1,610 ($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 7 Solutions
Bundle: Financial & Managerial Accounting, 13th + Working Papers, Volume 1, Chapters 1-15 For Warren/reeve/duchac’s Corporate Financial Accounting, ... 13th + Cengagenow™v2, 2 Terms Access Code
- Using 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_forwardThe 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_forwardThe bank reconciliation shows the following adjustments: Deposits in transit: $1,234 Outstanding checks: $558 Bank service charges: $50 NSF checks: $250 Prepare the correcting journal entry.arrow_forward
- Using 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_forwardUsing the following information, prepare a bank reconciliation. Bank balance: $3,678 Book balance: $2,547 Deposits in transit: $321 Outstanding checks: $108 and $334 Bank charges: $25 Notes receivable: $1,000; interest: $35arrow_forwardThe 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_forward
- Catherines Cookies has a beginning balance in the Accounts Payable control total account of $8,200. In the cash disbursements journal, the Accounts Payable column has total debits of $6,800 for November. The Accounts Payable credit column in the purchases journal reveals a total of $10,500 for the current month. Based on this information, what is the ending balance in the Accounts Payable account in the general ledger?arrow_forwardBANK RECONCILIATION Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in night depository, after banking hours. The data required to reconcile the bank statement as of June 30 have been taken from various documenta 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 CASH RECEIPTS FOR THE MONTH OF JUNE DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June Date June Amount 1,080.50 Date Amount Date Amount June 10 996.61 June 2. 897.34 3. 854.17 15 882.95 24 947.21 8. 840.50 17 1606.74 30 1117.74 CHECKS WRITTEN: Number and amount of each check issued in June: Check No. Amount Check No. Amount 747 Check Nc Amount 449.75 740 237,50 Void 754 495.15 755 272.75 113.95 407.95 741 748 450.90 742 501.90 749 640.13 756 750 743 744 761.30 506.88 276.77 757 758 759 259.60 751 752 299.37 901.50 486.39 537.01 745 746 117.25 298.66…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_forward
- BANK RECONCILIATION AND RELATED JOURNAL ENTRIES The book balance in the checking account of Lyle's Salon as of Novemeber 30 is $3,282.95. The bank statement shows an ending balance of $2,127. By examining last month's bank in novemeber and noting the service charges and other debit and credit memos shown on the bank statement, the following were found: a) An ATM withdrawl of $150 on November 18 by Lyle for personal use was not recorded in the books b) A bank debit memo issued for an NSF check from a customer of $19.50 c) A bank credit memo issued for interest of $19 earned during the month d) on November 30, A deposit of 1,177 was made which is not shown on the bank statement. e) A bank debit memo issued for $17.50 for bank service charges. f) checks No. 549,561 and 562 for the amounts of $185, $21 and $9.40, respectively, were written during november but have not yet been received by the bank. g) The reconciliation from the previous month showed outstanding checks totaling $271.95…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_forwardBank Reconciliation and Related Journal Entries The book balance in the checking account of Lyle's Salon as of November 30 is $3,337.11. The bank statement shows an ending balance of $2,136.00. By examining last month's bank reconciliation, comparing the deposits and checks written per books and per bank in November, and noting the service charges and other debit and credit memos shown on the bank statement, the following were found: An ATM withdrawal of $153.00 on November 18 by Lyle for personal use was not recorded on the books. A bank debit memo issued for an NSF check from a customer of $19.40. A bank credit memo issued for interest of $19.00 earned during the month. On November 30, a deposit of $1,201.00 was made, which is not shown on the bank statement. A bank debit memo issued for $18.00 for bank service charges. Checks No. 549, 561, and 562 for the amounts of $167.00, $23.00, and $9.60, respectively, were written during November but have not yet been received by the bank.…arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCorporate Financial AccountingAccountingISBN:9781305653535Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning