Question

In: Accounting

Timmins Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May...

Timmins Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2020, the company’s Cash account per its general ledger showed a balance of $6,100.50.
The bank statement from Emporia State Bank on that date showed the following balance.

Emporia State Bank
Checks and Debits Deposits and Credits Daily Balance
XXX XXX 5-31 7,209.60



A comparison of the details on the bank statement with the details in the Cash account revealed the following facts.

1. The statement included a debit memo of $50 for the printing of additional company checks.
2. Cash sales of $983.36 on May 12 were deposited in the bank. The cash receipts entry and the deposit slip were incorrectly made for $1,043.36. The bank credited Timmins Company for the correct amount.
3. Outstanding checks at May 31 totaled $53.55, and deposits in transit were $1,830.45.
4. On May 18, the company issued check No. 1181 for $671 to H. Moses, on account. The check, which cleared the bank in May, was incorrectly journalized and posted by Timmins Company for $617.
5. $3,900 was collected by the bank for Timmins Company on May 31 through electronic funds transfer.
6. Included with the canceled checks was a check issued by Tomins Company to C. Pernod for $480 that was incorrectly charged to Timmins Company by the bank.
7.

On May 31, the bank statement showed an NSF charge of $370 for a check issued by Sara Ballard, a customer, to Timmins Company on account.

Prepare the bank reconciliation at May 31, 2020. (List items that increase cash balance first.)

Solutions

Expert Solution

Timmins Company of Emporia, Kansas
Bank Reconciliation
May 31, 2020
Company's Book Bank Statement
Balance per books $ 6,100.50 Balance per bank $ 7,209.60
Add: Electronic fund transfer $ 3,900.00 Add:
Deposit in transit $ 1,830.45
Deduct: Bank error in recording of check $     480.00
Check printing charges $    50.00 $ 2,310.45
NSF Check $ 370.00
Error in recording of cash deposit ($1043.36-$983.36) $    60.00 Deduct: Outstanding check $        53.55
Error in recording of check #1181 ($671-$617) $    54.00
$     534.00
Adjusted book balance $ 9,466.50 Adjusted bank balance $ 9,466.50

You can reach me over comment box if you have any doubts. Please rate this answer


Related Solutions

Oriole Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May...
Oriole Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2022, the company’s Cash account per its general ledger showed a balance of $6,808.90. The bank statement from Emporia State Bank on that date showed the following balance. EMPORIA STATE BANK Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 7,038.00 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts....
Oriole Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May...
Oriole Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2017, the company’s Cash account per its general ledger showed a balance of $6,808.90. The bank statement from Emporia State Bank on that date showed the following balance. EMPORIA STATE BANK Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 7,038.00 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts....
Timmins Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May...
Timmins Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2020, the company’s Cash account per its general ledger showed a balance of $7,206.00. The bank statement from Emporia State Bank on that date showed the following balance. Emporia State Bank Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 8,520.00 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts....
Problem 7-5A (Part Level Submission) Ivanhoe Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer...
Problem 7-5A (Part Level Submission) Ivanhoe Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2017, the company’s Cash account per its general ledger showed a balance of $6,858.90. The bank statement from Emporia State Bank on that date showed the following balance. EMPORIA STATE BANK Checks and Debits Deposits and Credits Daily Balance XXX XXX 5-31 7,088.00 A comparison of the details on the bank statement with the details in the Cash...
Q 16 Brofe Limited retails fertilizer to farmers in Ghana. The company has approached its bankers...
Q 16 Brofe Limited retails fertilizer to farmers in Ghana. The company has approached its bankers to provide funding for next year's operations and a three months master budget has been requested for review by the bankers. You have been approached by the management as a consultant to prepare the 1st quarter budget for the banker's consideration for its next year's operations. End of Accounting year December 20X9 GHS Debtors 23,000 Bank balance 55,000 Non-current asset at cost    698,000 Provision...
[The following information applies to the questions displayed below.] OFC Company of Kansas City prints business...
[The following information applies to the questions displayed below.] OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity Cost-Driver Rate...
Required information [The following information applies to the questions displayed below.] OFC Company of Kansas City...
Required information [The following information applies to the questions displayed below.] OFC Company of Kansas City prints business forms and other specialty paper products, such as writing paper, envelopes, note cards, and greeting cards. Its Business Services division offers inventory management services and desktop delivery on request. The division uses an activity-based costing (ABC) system. The budgeted usage of each activity cost driver and cost-driver rates for January 2019 for the Business Services division are: Activity Cost Driver Budgeted Activity...
Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three...
Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $90,000 $314,000    $167,000    $78,900 $107,800 Square feet 1,500 —    1,500    4,200 4,800 Machine hours — 1,403    1,345    24,000 8,000 Purchase orders 20    40    7...
Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate...
Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $90,000 $316,000    $165,000    $78,500 $107,700 Square feet 1,500 —    1,500    4,200 4,800 Machine hours — 1,403    1,345    24,000 8,000 Purchase orders 20    40...
Direct Method and Overhead Rates Jasmine Company manufactures both pesticide and liquid fertilizer, with each product...
Direct Method and Overhead Rates Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $90,000 $312,000    $165,000    $78,500 $107,700 Square feet 1,500 —    1,500    4,200 4,800 Machine hours — 1,403    1,345    24,000 8,000 Purchase orders...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT