Question

In: Accounting

Gunnar Company gathered the following reconciling information in preparing its September bank reconciliation. Calculate the adjusted...

Gunnar Company gathered the following reconciling information in preparing its September bank reconciliation. Calculate the adjusted cash balance per books on September 30.

Cash balance per books, September 30 $ 3,181
Deposits in transit 421
Notes receivable and interest collected by bank 888
Bank charge for check printing 29
Outstanding checks 1,347
NSF check 144

a.$2,970

b.$3,896

c.$2,255

d.$3,114

Bank Reconciliation

The following data were accumulated for use in reconciling the bank account of Mathers Co. for July:

Cash balance according to the company's records at July 31 $15,470.

Cash balance according to the bank statement at July 31, $16,510.

Checks outstanding, $3,140.

Deposit in transit, not recorded by bank, $2,520.

A check for $270 in payment of an account was erroneously recorded in the check register as $720.

Bank debit memo for service charges, $30.

a. Prepare a bank reconciliation, using the format shown in Exhibit 14.

Mathers Co.
Bank Reconciliation
July 31
Cash balance according to bank statement $
Adjusted balance $
Cash balance according to company's records $
Adjusted balance $

b. If the balance sheet is prepared for Mathers Co. on July 31, what amount should be reported for cash?
$

c. Must a bank reconciliation always balance (reconcile)?

Consider the following information taken from the cash account. Assume cash payments were 80% of collections.

Cash
?? Beginning balance
$115,375 Collections
?? Disbursements
$80,275 Ending balance


How much was the beginning balance of the cash account?

a.$92,300

b.$103,350

c.$57,200

d.$35,100

Solutions

Expert Solution

1
Cash balance per books, September 30 3181
Add: Notes receivable and interest collected by bank 888
Less: Bank charge for check printing 29
Less: NSF check 144
Adjusted cash balance per books 3896
Option B is correct
2
a
Mathers Co.
Bank Reconciliation
July 31
Cash balance according to bank statement 16510
Add deposit in transit, not recorded by bank 2520
Deduct outstanding checks 3140
Adjusted balance 15890
Cash balance according to company's records 15470
Add error in recording check as $720 instead of $270 450 =720-270
Deduct bank service charge 30
Adjusted balance 15890
b
Amount reported for cash $15890
c
Yes, a bank reconciliation must always balance (reconcile)
3
Ending balance 80275
Add: Disbursements 92300 =115375*80%
Less: Collections 115375
Beginning balance 57200
Option C is correct

Related Solutions

Derek Company gathered the following reconciling information in preparing its September bank reconciliation: Cash balance per...
Derek Company gathered the following reconciling information in preparing its September bank reconciliation: Cash balance per books, 9/30 $2,190 Deposits in transit 572 Notes receivable and interstate's collected by bank. 879 Bank charge for check printing   29 Outstanding checks 1,322 NSF 178 Find the adjusted cash balance per books on September 30. Select the correct answer. $2,862 $2,112 $1,440 $2,290
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance...
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance before reconciliation                           $23,000 Note receivable collected by bank                                 7,500 Outstanding checks                                                     15,000 Deposits in transit                                                          8,000 Bank service charge                                                          100 NSF check                                                                        1,800 Determine the cash balance per books (before adjustments) for Kreiger. 2. Kendall Corporation had a 1/1/19 balance in the Allowance for Doubtful Accounts of $18,000. During 2019, it wrote off $11,500 of accounts and collected...
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea...
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea Company: Balance per bank $ 17,300 Balance per company records 8,170 Bank service charges 20 Deposit in transit 3,050 Note collected by bank with $150 interest 4,750 Outstanding checks 7,450 a. What is the adjusted balance on the bank reconciliation? $ b. Journalize any necessary entries for Azalea Company based on the bank reconciliation. If an amount box does not require an entry, leave...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31: The balance on the May 31 bank statement is $8,432.11. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31. A comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at May 31: No. 123 $23.40 No. 127 145.00...
Which of the following is a reconciling item on the bank side of a bank reconciliation?...
Which of the following is a reconciling item on the bank side of a bank reconciliation? 1. Cancelled cheques 2. Outstanding cheques 3. both outstanding cheques and NSF cheques 4. NSF cheques A cheque returned by a bank because the issuer's cash account balance could not cover the cheque is called: 1. a blank cheque 2. a certified cheque 3. a NSF cheque 4. an outstanding cheque On 1 January, Bochao Properties establishes a petty cash fund for $200. On...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the month of June. It reconciles the bank balance and the book balance to the correct balance. For each of the following items, indicate whether the item is an addition to the bank balance, an addition to the book balance, a deduction from the bank balance, a deduction from the book balance, or would not appear on the June reconciliation. Also, choose Yes or No...
National Surf Board Co. (NSB) gathered the following information for its August 31 bank reconciliation: Cash...
National Surf Board Co. (NSB) gathered the following information for its August 31 bank reconciliation: Cash balance per books, August 31                  $3,872 Cash balance per bank, August 31                    $ (332) (account is overdrawn; a negative balance) August 31st cash receipts of $8,000 were locked in NSB’s Treasurer’s office with a plan to deposit them at the bank the next day. Outstanding cheques issued by NSB at August 31st totalled $4,023 A check originally issued by a customer for $257 was...
Preparing a bank reconciliation
Question Preparing a bank reconciliationThe Cash account of Guard Dog Security Systems reported a balance of $2,540 at December 31, 2018. There were outstanding checks totaling $400 and a December 31 deposit in transit of $100. The bank statement, which came from Park Cities Bank, listed the December 31 balance of $3,340. Included in the bank balance was a collection of $510 on account from Brendan Ballou, a Guard Dog customer who pays the bank directly. The bank statement also...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $20,300. Cash balance according to the bank statement at August 31, $21,600. Checks outstanding, $4,120. Deposit in transit, not recorded by bank, $3,310. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $50. a....
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $20,180. Cash balance according to the bank statement at August 31, $21,020. Checks outstanding, $4,100. Deposit in transit, not recorded by bank, $3,290. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $60. a....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT