Question

The auditors of Steffey Ltd. decided to study the cash receipts and disbursements for the month...

The auditors of Steffey Ltd. decided to study the cash receipts and disbursements for the month of July of the current year under audit. They obtained the bank reconciliations and the cash journals prepared by the company accountants, which revealed the following:

June 30: Bank balance, $355,001; deposits in transit, $86,899; outstanding checks, $42,690; general ledger cash balance, $399,210.
July 1: Cash receipts journal, $650,187; cash disbursements journal, $565,397.
July 31: Bank balance, $506,100; deposits in transit, $51,240; outstanding checks, $73,340; general ledger cash balance, $484,000. Bank statement record of deposits: $835,846; of payments: $684,747.

Required:

In Excel, prepare a four-column proof of cash covering the month of July of the current year. Identify problems, if any.

Homework Answers

Answer #1

Answer:

Four-column proof of cash covering the month of July of the current year is prepared, based on information provided, as below:

The bank statement balances and general ledger cash balances are reconciled and there is no problem identified.

Bank statement balance:

Beginning balance + Deposits - Disbursement = Ending bank balance

$355,001+ $835,846 - $684,747 = $506,100

General ledger cash balance:

$399,210 + $650,187 - $565,397 = $484,000

Reconciliation:

Ending balance -June 30:

Bank balance + Deposits in transit - Outstanding check = General ledger balannce

$355,001 + $86,899 - $42,690 = $399,210

Ending balance -July 31:

$506,100 + $51,240 - $73,340 = $484,000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The cash records of Jasmin Company show the following four situations: 1) The June 30 bank...
The cash records of Jasmin Company show the following four situations: 1) The June 30 bank reconciliation indicated that deposits in transit total $2,110. During July the general ledger account Cash shows deposits of $23,620, but the bank statement indicates that only $23,400 in deposits were received during the month. 2) The June 30 bank reconciliation also reported outstanding checks of $1,250. During the month of July, Jasmin Company books show that $25,800 of checks were issued. The bank statement...
The cash records of Sunland Company show the following. For July: 1. The June 30 bank...
The cash records of Sunland Company show the following. For July: 1. The June 30 bank reconciliation indicated that deposits in transit total $700. During July, the general ledger account Cash shows deposits of $18,870, but the bank statement indicates that only $15,810 in deposits were received during the month. 2. The June 30 bank reconciliation also reported outstanding checks of $910. During the month of July, Sunland Company books show that $17,980 of checks were issued, yet the bank...
Brockton Carpet Cleaning prepares a bank reconciliation at the end of every month. At the end...
Brockton Carpet Cleaning prepares a bank reconciliation at the end of every month. At the end of July, the balance in the general ledger checking account was $2,830 and the bank balance on the bank statement was $3,020. Outstanding checks totaled $720 and deposits in transit were $440. The bank statement revealed that a check written for $160 was incorrectly recorded by Brockton as a $260 disbursement. The bank statement listed service charges and NSF check charges totaling $190. The...
The cash records of Mercury Company show the following: 1. The June 30 bank reconciliation indicated...
The cash records of Mercury Company show the following: 1. The June 30 bank reconciliation indicated that deposits in transit totaled $790. During July the general ledger account Cash shows deposits of $9,800, but the bank statement indicates that only $8,240 in deposits were received during the month. 2. The June 30 bank reconciliation also reported outstanding checks of $1,200. During the month of July, Mercury Company books show that $11,570 of checks were issued, yet the bank statement showed...
Park Playground, Inc. has lost some of its accounting records regarding its July cash receipts and...
Park Playground, Inc. has lost some of its accounting records regarding its July cash receipts and payments. It reconciled its June 30, 2020 bank statement on July 2 and made the related adjusting entries at that time. The company has not reconciled its July 31, 2020 bank statement. It provides you with the following information on August 3: 7/31/2020 Cash account balance $3,278 Bank statement balance 7,010 Deposits in transit 564 Outstanding checks (cleared next month) 920 Bank service charge...
Ryan Company deposits all cash receipts on the day they are received and makes all cash...
Ryan Company deposits all cash receipts on the day they are received and makes all cash payments by check. Ryan's June bank statement shows $24,861 on deposit in the bank. Ryan's comparison of the bank statement to its cash account revealed the following: Deposit in transit 2,750 Outstanding checks 1,188 Additionally, a $35 check written and recorded by the company correctly, was recorded by the bank as a $53 deduction. The adjusted cash balance per the bank records should be:
Using Bank Reconciliation to Determine Cash Receipts Stolen Alaska Impressions Co. records all cash receipts on...
Using Bank Reconciliation to Determine Cash Receipts Stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: Cash in bank according to the general ledger $11,680 Cash according to the October 31, 20Y3, bank statement 13,275 Outstanding checks...
Ryan Company deposits all cash receipts on the day they are received and makes all cash...
Ryan Company deposits all cash receipts on the day they are received and makes all cash payments by check. Ryan's June bank statement shows $29,361 on deposit in the bank. Ryan's comparison of the bank statement to its cash account revealed the following: Deposit in transit 3,650 Outstanding checks 1,431 Additionally, a $49 check correctly written and recorded by the bank as a $94 deduction. The adjusted cash balance per the bank records should be: Multiple Choice $24,325 $34,487 $31,580...
Below is information about Adam Ltd’s cash position for the month of May 2020. 1. The...
Below is information about Adam Ltd’s cash position for the month of May 2020. 1. The general ledger Cash at Bank account had a balance of $42,400 on 30 April. 2. The cash receipts journal showed total cash receipts of $585,408 for May. 3. The cash payments journal showed total cash payments of $530,148 for May. 4. The June bank statement reported a bank balance of $82,368 on 30 May. 5. Outstanding cheques at the end of May were: no....
Please Finish the following using Canadian Accounting version of Bank reconciliation statement: Neopolitan Ltd Bank Reconciliation...
Please Finish the following using Canadian Accounting version of Bank reconciliation statement: Neopolitan Ltd Bank Reconciliation July 31 Cash Balance Per Bank $10670 Add: Deposits in transit 1968 8702 Less: Outstanding Cheques 2359 Reconciled Cash balancer per bank 6343 Cash Balance Per Books Add: EFT collections on Account 1276 Less: NSF cheque and fee Bank Service Charge 40 Reconciled Cash Balance Per books                                                                USE THE FOLLOWING INFORMATION to complete or correct the above bank reconociliations statement The following information is...