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
EBK FINANCIAL & MANAGERIAL ACCOUNTING
- Noyan Carter's weekly gross earnings for the week ending August 15th were $3,200, and his federal income tax withholding was $650. Assuming the Social Security rate is 6.2% and Medicare is 1.5% of all earnings, What is Carter's net pay?arrow_forwardSuppose that Cullumber Automated Retail Company has the following inventory data: Nov. 1 Inventory 23 units @ $4.70 each 8 Purchase 94 units @ $5.05 each 17 Purchase 47 units @ $4.90 each 25 Purchase 70 units @ $5.10 each The company uses a periodic inventory system. A physical count of merchandise inventory on November 30 reveals that there are 78 units on hand. Cost of goods sold under LIFO rounded to the nearest dollar is $386. $396. $784. $774.arrow_forwardOn May 1, Sandhill Company had beginning inventory consisting of 360 units with a unit cost of $8. During May, the company purchased inventory as follows: 720 units at $8 1080 units at $9 The company sold 1800 units during the month for $14 per unit. Sandhill uses the average-cost method. Assuming that a periodic inventory system is used, the value of Sandhill's inventory at May 31 is (Round average cost per unit to 2 decimal places, e.g. 12.52.) ○ $3240 ○ $18360 ○ $3060 ○ $2880arrow_forward
- Suppose that Sandhill Trading Post has the following inventory data: July 1 Beginning inventory 46 units at $23 $1058 7 Purchases 162 units at $24 3888 22 Purchases 23 units at $26 598 $5544 The company uses a periodic inventory system. A physical count of merchandise inventory on July 31 reveals that there are 58 units on hand. Using the LIFO inventory method, the amount allocated to cost of goods sold for July is ○ $4198. ○ $4036. ○ $3932. ○ $4106.arrow_forwardSuppose that Sandhill Trading Post has the following inventory data: July 1 Beginning inventory 46 units at $23 $1058 7 Purchases 162 units at $24 3888 22 Purchases 23 units at $26 598 $5544 The company uses a periodic inventory system. A physical count of merchandise inventory on July 31 reveals that there are 58 units on hand. Using the LIFO inventory method, the amount allocated to cost of goods sold for July is ○ $4198. ○ $4036. ○ $3932. ○ $4106.arrow_forwardSuppose that Ivanhoe Depot Inc. has the following inventory data: July 1 Beginning inventory 24 units at $19 $456 7 Purchases 84 units at $20 1680 22 Purchases 12 units at $22 264 $2400 The company uses a periodic inventory system. A physical count of merchandise inventory on July 31 reveals that there are 40 units on hand. Using the FIFO inventory method, the amount allocated to ending inventory for July is ○ $824. 000 $800. ○ $880. ○ $776.arrow_forward
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage



