Question

In: Accounting

The bank statement for Adcock Company indicates a balance of $830 on July 31. The cash...

The bank statement for Adcock Company indicates a balance of $830 on July 31. The cash balance per books had a balance of $390 on this date. The following information pertains to the bank transactions for the company.
1. Deposit of $840, representing cash receipts of July 31, did not appear on the bank statement.
2. Outstanding checks totaled $390.
3. Bank service charges for June amounted to $30.
4. The bank collected a note receivable for the company for $1,200 plus $48 interest revenue.
5. A NSF check for $328 from a customer was returned with the statement.
Prepare a bank reconciliation for July 31.
ADCOCK COMPANY
Bank Reconciliation
July 31

Cash Balance Per BankDeposit in TransitOutstanding ChecksNSF CheckAdjusted Cash Balance Per BooksAccounts Payable ErrorCollection of Note and InterestBank Service ChargeAdjusted Cash Balance Per Bank

$

AddLess

:

Collection of Note and InterestOutstanding ChecksCash Balance Per BankAdjusted Cash Balance Per BankBank Service ChargeNSF CheckDeposit in TransitAdjusted Cash Balance Per BooksAccounts Payable Error

LessAdd

:

Deposit in TransitOutstanding ChecksCash Balance Per BankAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksNSF CheckCollection of Note and InterestAccounts Payable ErrorBank Service Charge

Cash Balance Per BankCollection of Note and InterestDeposit in TransitOutstanding ChecksAdjusted Cash Balance Per BooksAccounts Payable ErrorBank Service ChargeNSF CheckAdjusted Cash Balance Per Bank

$

Bank Service ChargeAdjusted Cash Balance Per BankOutstanding ChecksAdjusted Cash Balance Per BooksNSF CheckCash Balance Per BooksAccounts Payable ErrorDeposit in TransitCollection of Note and Interest

$

LessAdd

:

Bank Service ChargeOutstanding ChecksNSF CheckDeposit in TransitAdjusted Cash Balance Per BooksAccounts Payable ErrorAdjusted Cash Balance Per BankCollection of Note and InterestCash Balance Per Books

AddLess

:

    Deposit in Transit    Adjusted Cash Balance Per Bank    Adjusted Cash Balance Per Books    Outstanding Checks    Bank Service Charge    NSF Check    Accounts Payable Error    Cash Balance Per Books    Collection of Note and Interest    

$

    Accounts Payable Error    Deposit in Transit    Outstanding Checks    Adjusted Cash Balance Per Books    NSF Check    Collection of Note and Interest    Bank Service Charge    Adjusted Cash Balance Per Bank    Cash Balance Per Books    

Collection of Note and InterestDeposit in TransitNSF CheckBank Service ChargeAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksCash Balance Per BooksOutstanding ChecksAccounts Payable Error

$
Prepare any adjusting entries necessary as a result of the bank reconciliation. (Credit account titles are automatically indented when the amount is entered. Do not indent manually.)

Date

Account Titles and Explanation

Debit

Credit

July. 31

(To record collection of note receivable and interest by the bank)

31

(To record NSF check)

31

Solutions

Expert Solution

ADCOCK COMPANY
Bank Reconciliation
July 31
Cash balance per bank 830
Add: Deposit in Transit 840
Less: Outstanding Checks 390
Adjusted Cash Balance Per Bank 1280
Cash Balance Per Books 390
Add: Collection of Note and Interest 1248
Less:
Bank service charge 30
NSF check 328 358
Adjusted cash balance per books 1280
Jul-31 Cash 1248
                      Notes Receivable 1200
                      Interest Revenue 48
(To record collection of note receivable and interest by the bank)
Jul-31 Accounts Receivable 328
                      Cash 328
(To record NSF check)
Jul-31 Miscellaneous Expense 30
                      Cash 30
Note: Bank Service charge expense can alternatively be used for Miscellaneous Expense

Related Solutions

Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash balance of $5,000.17. •The cash ledger account on that date shows a balance of $4,262.83. •Four outstanding checks totaled $717.75. •A $410.90 deposit made after banking hours on July 31 does not appear in the bank statement. •On July 30, the bank returned J.B. Ball’s NSF check for $50.25, received as payment of an account receivable. •The bank statement showed $24.74 interest earned on...
The bank statement for Allen Co. indicates a balance of $7,100.00 on June 30. The cash...
The bank statement for Allen Co. indicates a balance of $7,100.00 on June 30. The cash account balance had a balance of $3,975.00. Prepare bank reconciliation on the basis of the following information, and journalize the changes on the company’s cash balance. Cash Receipts of $672 had been recorded on the company’s books as $654, Deposits in transit not record by the bank, $400 Bank service charges, $20 Note collected by the bank and not yet notified to the company,$1,550...
The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.
  The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.    On July 31, the company’s Cash account has a $25,640 debit balance, but its July bank statement shows a $26,661 cash balance. Check No. 3031 for $1,000 and Check No. 3040 for $492 were outstanding on the June 30 bank reconciliation. Check No. 3040 is listed with the July canceled checks, but Check No....
A company has the following information. 1. Cash balance per bank, July 31, $7,328 2. July...
A company has the following information. 1. Cash balance per bank, July 31, $7,328 2. July bank service charge on bank statement, $40 3. Cash balance per company books, July 31, $7,280 4. Bank statement shows a Note Receivable of $2,000 plus $16 of interest was collected by the bank. 5. Outstanding checks, July 31, $772 6. Deposits in transit, July 31, $2,700 Compute the adjusted cash balance per company books. Do not enter a dollar sign or any commas.
On July 31, 2022, Pharoah Company had a cash balance per books of $6,320.00. The statement...
On July 31, 2022, Pharoah Company had a cash balance per books of $6,320.00. The statement from Dakota State Bank on that date showed a balance of $7.870.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $21.00. 2. The bank collected $1,700.00 from a customer for Pharoah Company through electronic funds transfer. 3. The July 31 receipts of $1,377.30 were not included in the bank deposits for July. These...
On July 31, 2017, Ivanhoe Company had a cash balance per books of $6,255.00. The statement...
On July 31, 2017, Ivanhoe Company had a cash balance per books of $6,255.00. The statement from Dakota State Bank on that date showed a balance of $7,805.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $22.00. 2. The bank collected $1,635.00 for Ivanhoe Company through electronic funds transfer. 3. The July 31 receipts of $1,311.30 were not included in the bank deposits for July. These...
On July 31, 2020, Crane Company had a cash balance per books of $6,190.00. The statement...
On July 31, 2020, Crane Company had a cash balance per books of $6,190.00. The statement from Dakota State Bank on that date showed a balance of $7,700.00. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $25. 2. The bank collected $1,500 for Keeds Company through electronic funds transfer. 3. The July 31 receipts of $1,200.00 were not included in the bank deposits for July. These...
The following information is for Blossom Company: 1. Cash balance per bank, July 31, $8,836. 2....
The following information is for Blossom Company: 1. Cash balance per bank, July 31, $8,836. 2. July bank service charge not recorded by the depositor, $28. 3. The bank erroneously charged another company’s $840 cheque against Blossom’s account. 4. Cash balance per books, July 31, $10,541. 5. The bank charged Blossom’s account $420 for a customer’s NSF cheque. 6. Deposits in transit, July 31, $2,640. 7. Blossom recorded a cash receipt for a cash sale from a customer as $32....
At 31 July Ridley Pty Ltd has this bank information: cash balance as per bank $8420;...
At 31 July Ridley Pty Ltd has this bank information: cash balance as per bank $8420; unpresented cheques $862; outstanding deposits $2700; and a bank service charge $20. Determine the balance of the Cash at Bank account after any required adjustments. Prepare entry to replenish a petty cash fund. Please help me with this question
The following information pertains to Sheridan Video Company. 1. Cash balance per bank, July 31, $7,943....
The following information pertains to Sheridan Video Company. 1. Cash balance per bank, July 31, $7,943. 2. July bank service charge not recorded by the depositor $37. 3. Cash balance per books, July 31, $7,964. 4. Deposits in transit, July 31, $1,840. 5. Bank collected $1,240 note for Sheridan in July, plus interest $45, less fee $29. The collection has not been recorded by Sheridan, and no interest has been accrued. 6. Outstanding checks, July 31, $600.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT