Splish Brothers Inc.’s bank statement from Main Street Bank at
August 31, 2022, gives the following information.
Balance, August 1 |
$18,540 |
Bank debit memorandum: |
||||
---|---|---|---|---|---|---|
August deposits |
71,140 |
Safety deposit box fee |
$ 50 | |||
Checks cleared in August |
68,653 |
Service charge |
75 | |||
Bank credit memorandum: |
Balance, August 31 |
20,972 | ||||
Interest earned |
70 |
A summary of the Cash account in the ledger for August shows the
following: balance, August 1, $18,840; receipts $74,140;
disbursements $73,545; and balance, August 31, $19,435. Analysis
reveals that the only reconciling items on the July 31 bank
reconciliation were a deposit in transit for $4,825 and outstanding
checks of $4,525. In addition, you determine that there was an
error involving a company check drawn in August: A check for $400
to a creditor on account that cleared the bank in August was
journalized and posted for $40.
Prepare a bank reconciliation at August 31. (List
items that increase balance as per bank & books
first.)
SPLISH BROTHERS INC. |
|||||
---|---|---|---|---|---|
select an opening name for section one Adjusted cash balance per bankDeposits in transitSafety deposit box rentInterest earnedError in recording checkCash balance per bank statementOutstanding checksService charge |
$enter a dollar amount |
||||
select between addition and deduction AddLess: |
select a reconciling item Interest earnedAdjusted cash balance per bankCash balance per bank statementDeposits in transitOutstanding checksService chargeSafety deposit box rentError in recording check |
enter a dollar amount |
|||
enter a subtotal of the two previous amounts |
|||||
select between addition and deduction AddLess: |
select a reconciling item Service chargeError in recording checkDeposits in transitInterest earnedCash balance per bank statementSafety deposit box rentAdjusted cash balance per bankOutstanding checks |
enter a dollar amount |
|||
select a closing name for section one Safety deposit box rentService chargeInterest earnedDeposits in transitOutstanding checksError in recording checkCash balance per bank statementAdjusted cash balance per bank |
$enter a total amount for the first section |
||||
select an opening name for section two Safety deposit box rentError in recording checkAdjusted cash balance per booksCash balance per booksInterest earnedOutstanding checksDeposits in transitService charge |
$enter a dollar amount |
||||
select between addition and deduction AddLess: |
select a reconciling item Adjusted cash balance per booksCash balance per booksInterest earnedSafety deposit box rentDeposits in transitOutstanding checksService chargeError in recording check |
enter a dollar amount |
|||
enter a subtotal of the two previous amounts |
|||||
select between addition and deduction AddLess: |
|||||
select a reconciling item Service chargeError in recording checkCash balance per booksAdjusted cash balance per booksInterest earnedDeposits in transitSafety deposit box rentOutstanding checks |
$enter a dollar amount |
||||
select a reconciling item Error in recording checkInterest earnedOutstanding checksSafety deposit box rentDeposits in transitCash balance per booksService chargeAdjusted cash balance per books |
enter a dollar amount |
||||
select a reconciling item Interest earnedSafety deposit box rentDeposits in transitOutstanding checksAdjusted cash balance per booksError in recording checkService chargeCash balance per books |
enter a dollar amount |
||||
enter a subtotal of the three previous amounts |
|||||
select a closing name for section two Safety deposit box rentAdjusted cash balance per booksCash balance per booksOutstanding checksInterest earnedDeposits in transitService chargeError in recording check |
$enter a total amount for the second section |
SPLISH BROTHERS INC. | |||
Bank Reconciliation | |||
August 31, 2022 | |||
Cash balance per bank statement | 20972 | ||
Add: Deposits in transit | 7825 | =4825+(74140-71140) | |
28797 | |||
Less: Outstanding checks | 9777 | =4525+(73545-68653)+360 | |
Adjusted cash balance per bank | 19020 | ||
Cash balance per books | 19435 | ||
Add: Interest earned | 70 | ||
19505 | |||
Less: | |||
Safety deposit box rent | 50 | ||
Service charge | 75 | ||
Error in recording check | 360 | ||
485 | |||
Adjusted cash balance per books | 19020 |
Splish Brothers Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following...
Splish Brothers Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,540 Bank debit memorandum: August deposits 71,140 Safety deposit box fee $ 50 Checks cleared in August 68,653 Service charge 75 Bank credit memorandum: Balance, August 31 20,972 Interest earned 70 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,840; receipts $74,140; disbursements $73,545; and balance, August 31, $19,435. Analysis reveals...
On July 31, 2022, Sunland Company had a cash balance per books of $6,275.00. The statement from Dakota State Bank on that date showed a balance of $7,825.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $17.00. 2. The bank collected $1,655.00 from a customer for Sunland Company through electronic funds transfer. 3. The July 31 receipts of $1,336.30 were not included in the bank deposits...
Splish Brothers Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,540 Bank debit memorandum: August deposits 71,140 Safety deposit box fee $ 50 Checks cleared in August 68,653 Service charge 75 Bank credit memorandum: Balance, August 31 20,972 Interest earned 70 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,840; receipts $74,140; disbursements $73,545; and balance, August 31, $19,435. Analysis reveals...
Using the following information, prepare a bank reconciliation for Crane Company for July 31, 2022. a. The bank statement balance is $3,510. b. The cash account balance is $4,050. c. Outstanding checks totaled $1,240. d. Deposits in transit are $1,690. e. The bank service charge is $81. f. A check for $76 for supplies was recorded as $67 in the ledger. Crane Company Bank Reconciliation For the Month Ended July 31, 2022July 31, 2022For the Year Ended July 31, 2022...
The following information pertains to Cullumber Company. 1. Cash balance per bank, July 31, $7,988. 2. July bank service charge not recorded by the depositor $53. 3. Cash balance per books, July 31, $8,024. 4. Deposits in transit, July 31, $3,360. 5. $2,676 collected for Cullumber Company in July by the bank through electronic funds transfer. The collection has not been recorded by Cullumber Company. 6. Outstanding checks, July 31, $701. repare a bank reconciliation at July 31, 2017. (List...
Sage Hill Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks cleared in August 68,663 Service charge 65 Bank credit memorandum: Balance, August 31 21,162 Interest earned 60 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,935; receipts $74,235; disbursements $73,555; and balance, August 31, $19,615. Analysis reveals...
Using the following information, prepare a bank reconciliation for Ivanhoe Company for July 31, 2022. a. The bank statement balance is $3,760. b. The cash account balance is $4,200. c. Outstanding checks totaled $1,450. d. Deposits in transit are $1,780. e. The bank service charge is $83. f. A check for $85 for supplies was recorded as $58 in the ledger. Ivanhoe Company Bank Reconciliation For the Year Ended July 31, 2022For the Month Ended July 31, 2022July 31, 2022...
Using the following information, prepare a bank reconciliation for Blossom Company for July 31, 2022. a. The bank statement balance is $3,500. b. The cash account balance is $3,950. c. Outstanding checks totaled $1,200. d. Deposits in transit are $1,600. e. The bank service charge is $32. f. A check for $86 for supplies was recorded as $68 in the ledger. Blossom Company Bank Reconciliation For the Month Ended July 31, 2022For the Year Ended July 31, 2022July 31, 2022...
Ivanhoe Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2022, the company’s Cash account per its general ledger showed a balance of $6,803.90. The bank statement from Emporia State Bank on that date showed the following balance. EMPORIA STATE BANK Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 7,033.00 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts....
Shamrock, Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,590 Bank debit memorandum: August deposits 71,190 Safety deposit box fee $90 Checks cleared in August 68,613 Service charge 115 Bank credit memorandum: Balance, August 31 21,072 Interest earned 110 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,890; receipts $74,190; disbursements $73,505; and balance, August 31, $19,575. Analysis reveals that the...