In: Accounting
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
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 |