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 for July. These receipts were deposited by the company in a night deposit vault on July 31. | |
4. | Company check No. 2480 issued to L. Taylor, a creditor, for $384.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $348.00. | |
5. | Checks outstanding on July 31 totaled $1,995.10. | |
6. | On July 31, the bank statement showed an NSF charge of $710.00 for a check received by the company from W. Krueger, a customer, on account. |
Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.)
SUNLAND COMPANY |
|||||
---|---|---|---|---|---|
select an opening name for section one Deposits in transitElectronic funds transfer receivedBank service chargeCash balance per bank statementOutstanding checksError in recording check No. 2480NSF checkAdjusted cash balance per bank |
$enter a dollar amount |
||||
select between addition and deduction AddLess: |
select a reconciling item Error in recording check No. 2480Cash balance per bank statementAdjusted cash balance per bankBank service chargeDeposits in transitOutstanding checksElectronic funds transfer receivedNSF check |
enter a dollar amount |
|||
enter a subtotal of the two previous amounts |
|||||
select between addition and deduction AddLess: |
select a reconciling item NSF checkError in recording check No. 2480Deposits in transitCash balance per bank statementElectronic funds transfer receivedOutstanding checksBank service chargeAdjusted cash balance per bank |
enter a dollar amount |
|||
select a closing name for section one Outstanding checksCash balance per bank statementBank service chargeNSF checkElectronic funds transfer receivedDeposits in transitAdjusted cash balance per bankError in recording check No. 2480 |
$enter a total amount for the first section |
||||
select an opening name for section two Deposits in transitBank service chargeError in recording check No. 2480NSF checkAdjusted cash balance per booksCash balance per booksElectronic funds transfer receivedOutstanding checks |
$enter a dollar amount |
||||
select between addition and deduction AddLess: |
select a reconciling item Cash balance per booksOutstanding checksError in recording check No. 2480Deposits in transitAdjusted cash balance per booksElectronic funds transfer receivedBank service chargeNSF check |
enter a dollar amount |
|||
enter a subtotal of the two previous amounts |
|||||
select between addition and deduction AddLess: |
|||||
select a reconciling item Adjusted cash balance per booksElectronic funds transfer receivedNSF checkError in recording check No. 2480Deposits in transitCash balance per booksOutstanding checksBank service charge |
$enter a dollar amount |
||||
select a reconciling item Deposits in transitError in recording check No. 2480Adjusted cash balance per booksOutstanding checksNSF checkElectronic funds transfer receivedBank service chargeCash balance per books |
enter a dollar amount |
||||
select a reconciling item NSF checkBank service chargeElectronic funds transfer receivedCash balance per booksError in recording check No. 2480Deposits in transitAdjusted cash balance per booksOutstanding checks |
enter a dollar amount |
||||
enter a subtotal of the three previous amounts |
|||||
select a closing name for section two Deposits in transitAdjusted cash balance per booksElectronic funds transfer receivedOutstanding checksError in recording check No. 2480NSF checkCash balance per booksBank service charge |
$enter a total amount for the second section |
Bank Reconciliation | ||
July 31, 2022 | ||
Cash balance per bank statement | 7825.80 | |
Add: Deposits in transit | 1336.30 | |
9162.10 | ||
Less: Outstanding checks | 1995.10 | |
Adjusted cash balance per bank | 7167.00 | |
Cash balance per books | 6275.00 | |
Add: Electronic funds transfer received | 1655.00 | |
7930.00 | ||
Less: | ||
Bank service charge | 17.00 | |
NSF check | 710.00 | |
Error in recording check No. 2480 | 36.00 | |
763.00 | ||
Adjusted cash balance per books | 7167.00 |
On July 31, 2022, Sunland Company had a cash balance per books of $6,275.00. The statement...
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...
1. 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. Prepare a bank reconciliation at July 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....
Carla Vista Co. of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2019, the company’s Cash account per its general ledger showed a balance of $6,828.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,058.00 A comparison of the details on the bank statement with the details in the Cash account revealed the following...
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 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...
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 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...
On July 31, 2022, Cullumber Company had a cash balance per books of $6,250.00. The statement from Dakota State Bank on that date showed a balance of $7,800.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $20.00. 2. The bank collected $1,630.00 from a customer for Cullumber Company through electronic funds transfer. 3. The July 31 receipts of $1,308.30 were not included in the bank deposits...
On July 31, 2022, Splish Brothers Company had a cash balance per books of $6,330. The statement from Dakota State Bank on that date showed a balance of $7,880.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. 2 3. 4. The bank service charge for July was $22. The bank collected $1,710.00 for Splish Brothers Company through electronic funds transfer. The July 31 receipts of $1,386,30 were not included in the bank deposits...