Question

In: Accounting

Maple Industries Inc. deposits all cash receipts on the day when they are received and it...

Maple Industries Inc. deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on December 31, its Cash account shows a debit balance of $18,719. The company’s bank statement as of December 31 shows an ending cash balance of $16,051. The following information was also available.

Outstanding checks as of December 31 total $2,326.

Included with the bank statement was a debit memo in the amount of $100 for service charges.

Check No. 2519, listed with the canceled checks, was correctly drawn for $870 in payment of a utility bill on December 16. The company mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $980.

The December 31 cash receipts of $3,620 were placed in the bank’s night depository after banking hours and were not recorded on the December 31 bank statement.

The bank deducted $1,384 for an NSF check from a customer deposited on December 10.

Required:

Prepare the bank reconciliation as of December 31.


Solutions

Expert Solution

  BANK RECONCILATION STATEMENT

PARTICULARS

AMOUNT($)

Balance as per books

18,719

Outstanding checks as of December 31 total $2,326 (Due to this cash balance as per books is reduced. At the same time there is no change is balance as per bank statement. So we will add $ 2326)

2326

Included with the bank statement was a debit memo in the amount of $100 for service charges.( Due to this Bank balance is reduced and there is no entry is books. So we will subtract $ 100)

(100)

Check No. 2519, listed with the canceled checks, was correctly drawn for $870 in payment of a utility bill on December 16. The company mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $980. (Entry is correct in books but amount recorded is higher by 980-870=110. So we will add 110 to cash balance as we have recorded expense higher by 110)

110

The December 31 cash receipts of $3,620 were placed in the bank’s night depository after banking hours and were not recorded on the December 31 bank statement.

(Since this entry is only made is our book, so no balance will in bank. So we will subtract 3620)

(3620)

The bank deducted $1,384 for an NSF check from a customer deposited on December 10.(Since no entry is made in books so we will subtract 1384)

(1384)

Balance as per Bank Statement

16051


Related Solutions

Wright Company deposits all cash receipts on the day when they are received and it makes...
Wright Company deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on May 31, 2017, its Cash account shows a $31,300 debit balance. The company’s May 31 bank statement shows $29,600 on deposit in the bank. The May 31 bank statement lists $290 in bank service charges; the company has not yet recorded the cost of these services. Outstanding checks as of May 31 total...
Del Gato Clinic deposits all cash receipts on the day when they are received and it...
Del Gato Clinic deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on June 30, 2017, its Cash account shows an $12,286 debit balance. Del Gato Clinic’s June 30 bank statement shows $12,524 on deposit in the bank. Outstanding checks as of June 30 total $2,740. The June 30 bank statement lists a $95 service charge. Check No. 919, listed with the canceled checks, was...
Blaze Co. deposits all cash receipts on the day when they are received and makes all...
Blaze Co. deposits all cash receipts on the day when they are received and makes all cash payments by check. At the close of business on December 31, its Cash account shows a debit balance of $8,649. The company’s bank statement as of December 31 shows an ending cash balance of $17,151. The following information was also available. Outstanding checks as of December 31 total $4,476. Included with the bank statement was a debit memo in the amount of $250...
Ryan Company deposits all cash receipts on the day they are received and makes all cash payments by check.
 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,861 on deposit in the bank. Ryan's comparison of the bank statement to its cash account revealed the following:  Deposit in transit 3,750 Outstanding checks 1,458  Additionally, a $56 check correctly written and recorded by the company was recorded by the bank as a $65 deduction.  The adjusted cash balance per the bank records should be:...
BANK RECONCILIATION B. J. Nebb deposits all receipts in the bank on the day they are...
BANK RECONCILIATION B. J. Nebb deposits all receipts in the bank on the day they are received and makes all payments by check. One June 30, the Ledger Balance of Cash is $2,519 after all posting is completed. The bank statement dated June 30 shows a balance of $2,758. You are given the following information to prepare a bank reconciliation in the spaces provided below. Outstanding checks, $355. A deposit of $482 was placed in the night depository of June...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of July 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. BANK RECONCILIATION FOR PRECEDING MONTH (DATED JUNE 30): Cash balance according to bank statement $9,422.80 Add...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of July 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. BANK RECONCILIATION FOR PRECEDING MONTH (DATED JUNE 30): Cash balance according to bank statement $9,422.80 Add...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of July 31, 20Y0, have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. CASH ACCOUNT: Balance as of July 1 $ 9,578.00 CASH RECEIPTS FOR MONTH OF JULY...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a...
Bank Reconciliation and Entries Sunshine Interiors deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of July 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account. BANK RECONCILIATION FOR PRECEDING MONTH (DATED JUNE 30): Cash balance according to bank statement $9,422.80 Add...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 522,000 $ 466,600 February 411,500 356,100 March 472,000 529,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT