Reference no: EM13519850

Bill's Lawn Care Mini Practice

In June, Billcommented to you that he could never figure out his bank statement, "it never matches the balance in my accounting records" he tells you.  So you explain that a bank reconciliation is a tool used to balance the bank statement to the accounting books.  He gives you his bank statement for June, 2014 (shown below).  The general ledger shows a balance for the account cash of $14,319.00 on June 30, 2014 (detail transactions below). Bill's business only has one checking account and no other cash accounts.

Bill has begun to have problems collecting some of his credit accounts and is considering writing off a couple of customer account balances.  He asks you how these bad debts should be recorded and has asked you to begin recording bad debt using the allowance method for June, 2014.  Selected account balances at the end of June, 2014 are:

Sales	$7.200
Sales on Credit	2,900
Accounts Receivable	3,200

As a result of increased focus on collecting accounts receivable, Bill has decided to extend credit for one customer, Alan Jones, who owes Bill's Lawn Care $500.  Bill and Alan have agreed to a 90-day 6% note for $500 issued on June 5, 2014.

Instructions:

1. Using the bank statement and the general ledger, prepare a bank reconciliation for Bill's Lawn Care as of June 30, 2014. Record any necessary journal entries.  Start with Page 6 for the journal entries.  Explanations are optional.

2. Using the information given above, calculate the amount of bad debt using:

a. Percentage of Sales on Credit = 1.5%

b. Percentage of Accounts Receivable = 1%

Using the chart of accounts, record the journal entry for bad debt expense for Bill's Lawn Care using the percentage of sales on credit method. 

3. Using the note receivable information above and the chart of accounts, record the following entries in the general journal (continue these entries on Page 6):

a. Receipt of the note in payment of the accounts receivable balance.

b. Adjusting entry at the end of June, 2014 for the note receivable.  (Round interest calculations to two decimals)

c. Assume that Alan pays the note and interest in full on the due date, record the necessary journal entry.  Assume that interest has been accrued at the end of each month. 

d. Assume that Alan defaults on the note and interest on the due date, record the necessary journal entry.  Assume that interest has been accrued at the end of each month.

Please note that calculation pages in the Excel template are for your use only and are not required or graded. 

CHECKING ACCOUNT DETAIL:

DATE	TRANSACTION TYPE & NUMBER	AMOUNT	BALANCE
BEGINNING BALANCE			$12,850.00
6/2/2014	CHECK #1570	226.00	12,624.00
6/5/2014	CHECK #1571	83.00	12,541.00
6/6/2014	EFT #43	127.00	12,414.00
6/10/2014	DEPOSIT #104	1,550.00	13,964.00
6/15/2014	CHECK #1572	145.00	13,819.00
6/15/2014	CHECK #1573	185.00	13,634.00
6/20/2014	DEPOSIT #105	885.00	14,519.00
6/24/2014	EFT #44	143.00	14,376.00
6/28/2014	CHECK #1574	87.00	14,289.00
6/28/2014	CHECK #1575	95.00	14,194.00
6/30/2014	DEPOSIT #106	425.00	14,619.00
6/30/2014	CHECK #1576	155.00	14,464.00
6/30/2014	CHECK #1577	145.00	$14,319.00

BANK STATEMENT:

FIRST NATIONAL BANK
ACCOUNT SUMMARY JUNE 30, 2014
BEGINNING BALANCE	$12,850.00
PAYMENTS	$1,021.00
DEPOSITS	2,440.00
FEES	20.00
ENDING BALANCE	$14,249.00
PAYMENTS
DATE	REFERENCE	AMOUNT
6/5/2014	1570	$266.00
6/9/2014	1571	83.00
6/10/2014	43	127.00
6/19/2014	1572	145.00
6/28/2014	1573	185.00
6/28/2014	NSF	120.00
6/30/2014	1575	95.00
TOTAL PAYMENTS		$1,021.00
DEPOSITS
DATE	REFERENCE	AMOUNT
6/11/2014	104	$1,550.00
6/23/2014	105	885.00
6/30/2014	INTEREST	5.00
TOTAL DEPOSITS		$2,440.00
FEES
6/30/2014	SVC CHG	$20.00
TOTAL FEES		$20.00

BILL'S LAWN CARE

CHART OF ACCOUNTS

 

ASSETS                                                                                    REVENUES

101      Cash                                                                           401      Lawn Service Revenue

110      Accounts Receivable                                                   410      Sales Revenue 

112      Allowance for Doubtful Accounts                                 415      Sales Returns and Allowances

115      Notes Receivable                                                        420      Interest Income

116      Interest Receivable            

120      Supplies                                                                     COST OF GOODS SOLD

130      Prepaid Insurance                                                      501      Purchases

140      Inventory                                                                   505      Purchase Returns and Allowances

150      Equipment                                                                

155      Accumulated Depreciation - Equipment                                                                                 

                                                                                                EXPENSES

LIABILITIES                                                                            620      Supplies Expense                            

201      Accounts Payable                                                       630      Fuel Expense

220      Notes Payable                                                            640      Repair and Maintenance Expense

225      Interest Payable                                                        650      Advertising Expense

                                                                                               660      Insurance Expense

OWNER'S EQUITY                                                                    670      Depreciation Expense

301      Owner's Capital                                                          680      Interest Expense

305      Owner's Drawings                                                      690      Bad Debt Expense

310      Income Summary                                                        695      Miscellaneous Expense