APA 1111C-Simulation Project-Captain Bob's Favorite Fishing Hole

Captain Bob's Favorite Fishing Hole
Simulation Project
All worksheets are available in Excel format or in a printable pdf format. You may print out the
worksheets and complete them by hand or you may enter all entries in the Excel workbook.
To submit your work, you may do one of the following:
*If you completed in Excel format, save the workbook with the filename
BobsFishingHole_Your Name and attach in the dropbox.
*If you printed and completed the forms by hand, you may scan handwritten documents and
attach the scanned document in the dropbox.
*You may deliver the printouts to your instructor's office. After delivering, enter a message in
the dropbox saying you have delivered. Step Task Points Part 1
1. Review the general company information and the Chart of Accounts.
Review the Trial Balance from Mar 31st. These amounts have already been used
to open the General Ledgers for you. 2. Journalize the transactions for April 1-30 in the General Journals. Use Journal
pages 1, 2, 3 and 4. (You will not use the adjustment information yet.) 3. Post the journal entries to the General Ledger and to the Accounts Receivable and
Accounts Payable subsidiary Ledgers. (The ledgers have already been opened for
you.) 4. Prepare the Schedule of Accounts Receivable and the Schedule of Accounts
Payable. Verify that the totals match the balances in the AR and AP General
Ledgers. 5. Prepare a trial balance on the work sheet.
Stop and check your work.
Go to Canvas and take the Part 1 Quiz. This quiz will allow you to check the
balances in the Trial Balance column of the worksheet. 40 Submit your General Journals pages 1-4, General Ledgers, and the worksheet to
your instructor using the Part I assignment drop box in Sakai. 10 Total Points - Part 1 50 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx Captain Bob's Favorite Fishing Hole
Simulation Project
Note: You can not complete the quiz without completing steps 1-5. If you do not
submit your Excel file or pdf file showing your own work, then you will not receive
credit for the Quiz.
Part 2
Continue project using forms completed in Part 1.
6.
Correct journal entries and postings to General Ledger from Part 1 if needed.
7. Complete the remainder of the work sheet. Use the adjustment information given
below the April 1-30 transaction descriptions. 8. Journalize the adjusting entries using General Journal page 5. 9. Post the adjusting entries to the general ledger. 10. Prepare the financial statements.
Income Statement
Statement of Owners Equity
Balance Sheet 11. Journalize the closing entries using General Journal page 5. (Add closing entries
below the adjusting entries.) 12. Post the closing entries to the General Ledgers.
(Hint: If you have done everything correctly, you should have zero balances in
all ledgers from Drawing to the Depreciation Expense ledgers.) 13. Prepare a post-closing trial balance.
Check your work.
Go to Canvas and take the Part 2 Quiz. This quiz will allow you to check the
balances in the worksheet, Gen Journal page 5, the financial statements, and postclosing trial balance. 30 Submit all printouts to your instructor or submit your file using the Part 2
assignment drop box in Canvas. 20 Total Points - Part 2 50 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx Captain Bob's Favorite Fishing Hole Bob Night opened "Captain Bob's Favorite Fishing Hole." The fishing camp is open from April through September and
attracts many famous college basketball coaches during the off-season. Guests typically register for one week,
arriving on Sunday afternoon and returning home the following Saturday afternoon. The registration fee includes
room and board, the use of fishing boats, and professional instruction in fishing techniques. In addition, a small camp
store is operated for sales of bait, tackle and t-shirts. All customers at the camp store are charged 6% sales tax.
tration fees are exempt from sales tax. Employees are taxed at the following rates. The SUTA tax rate is 5.4%,
the FUTA tax rate is 0.6%, both on the first $7,000 of earnings. The Social Security Tax rate is 6.2% on the first
$110,100 of earnings. The Medicare rate is 1.45% of gross earnings. The chart of accounts for the camping
operations is provided below.
Chart of Accounts
Subsidiary Ledgers
Acct. No.
101
110
122
131
142
144
145
181
181.1 Assets
Cash
Petty Cash
Accounts Receivable
Merchandise Inventory (T-shirts, bait & tackle)
Office Supplies
Food Supplies
Prepaid Insurance
Fishing Boats
Accum. Depr. - Fishing Boats 202
211
212
213
214
215
219
231 Liabilities
Accounts Payable
Employee Income Tax Payable
Social Security Tax Payable
Medicare Tax Payable
FUTA Tax Payable
SUTA Tax Payable
Wages Payable
Sales Tax Payable 311
312
313 Owner's Equity
Bob Night, Capital
Bob Night, Drawing
Income Summary 401
410
410.1
410.2 Revenues
Sales - tration Fees
Sales - Camp Store
Sales Returns and Allowances
Sales Discounts 501
501.1
501.2
510
520
530
542
544
545
555
560
565
570
580 Expenses
Purchases
Purchase Returns and Allowances
Purchase Discounts
Wages Expense
Payroll Taxes Expense
Advertising Expense
Office Supplies Expense
Food Supplies Expense
Insurance Expense
Rent Expense
Repair Expense
Postage Expense
Utilities Expense
Depr. Exp. - Fishing Boats qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx Customers
10-111
10-487 Big Game, Inc.
Happy Trails, Inc. Vendors
A001
B046
F023
G049 Acme Super Market
Buffalo Bill's Emporium
Fred's Flat Bottom Boat Co.
Gordon's Office Supplies NOTE: Students do not need to do anything with this. These balances have already been
entered in the General Ledgers as opening balances for April 1st. Captain Bob's Favorite Fishing Hole
Trial Balance
March 31, 20xx ACCOUNT TITLE ACCOUNT
NO. DEBIT BALANCE CREDIT BALANCE Cash 101 11,000.00 Merchandise Inventory 131 2,000.00 Employee Income Tax Payable 211 1,435.00 Social Security Tax Payable 212 620.00 Medicare Tax Payable 213 145.00 FUTA Payable 214 80.00 SUTA Payable 215 540.00 Sales Tax Payable 231 180.00 Bob Night, Capital 311 10,000.00 Totals qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 13,000.00 13,000.00 THE FOLLOWING TRANSACTIONS TOOK PLACE DURING THE MONTH OF APRIL.
Date
Description
Apr. 1 Night invested additional cash in business, $75,000.
###
Paid insurance premium to Allstate Insurance for six-month camping season, $12000.
###
Established a petty cash fund for the office manager, $100.
###
Paid rent to Universal Properties for the month of April, $40,000.
###
Deposited registration fees, $35,000.
###
Purchased 10 fishing boats on account from Fred's Flat Bottom Boat Co. for $60,000. The
boats have estimated useful lives of five years, at which time they will be donated to a local
day camp. Arrangements were made to pay for the boats in July.
###
Bought food supplies from Acme Super Market on account, $12,079.
###
Purchased merchandise for camp store from Buffalo Bill's Emporium Ltd. on account, $1500,
terms 2/10, n/30.
###
Bought office supplies from Gordon Office Supplies on account, $500.
###
Deposited registration fees, $38,600.
###
Returned defective merchandise received on 4th to Buffalo Bill's Emporium Ltd. for credit on
account, $100.
###
Earned registration fees on account from a hunting trip tour guide company, Big Game, Inc.,
$6000.
##
Paid Buffalo Bill's Emporium Ltd. balance owed for April 4 purchase less April 8 return less
2% discount.
##
A guest, Jane Doe, became ill and was unable to stay for the entire week.
A refund check was issued in the amount of $1,000. Jane originally paid her registration fees
in cash on the 7th.
##
Deposited registration fees, $30,500 plus sales from camp store, $1500 plus $90 sales tax.
##
Journalize the payroll entry using the following data taken from the payroll register for April
15th. Regular earnings $9000, Overtime earnings $1000, Deductions: Federal income tax
$1250, Social Security tax $620, Medicare tax $145. qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx THE FOLLOWING TRANSACTIONS TOOK PLACE DURING THE MONTH OF APRIL.
Date Description
##
Journalize the employer's payroll taxes expense for the above payroll using the following
information: Taxable Earnings for All Employees for Social Security Wages was $10,000.
Taxable Earnings for All Employees for Unemployment Compensation was $500. (Note: Tax
rates are given description paragraph above the Chart of Accounts.)
##
Paid 941 taxes for the 1st Quarter which include Employee Income Tax Payable $1435,
Social Security Tax Payable $620 and Medicare Tax Payable $145. (See opening balances
given for March 31st.)
##
Received cash on account from Big Game, Inc. , $3000.
##
Earned registration fees on account from a new customer, Happy Trails, Inc., $2500, terms
2/10, n/30.
##
Paid for stamps from the US Postmaster, $150.
##
Night's office manager returned office supplies to Gordon Office Supply and received a credit
on account, $100. (Hint: Credit will be to Office Supplies account.)
##
Paid Florida Dept. of Revenue for March sales tax, $180.
##
Deposited registration fees, $35,600 plus sales from camp store, $500 plus $30 sales tax.
##
Paid for advertising spots on National Sports Talk Radio, $2500.
##
Bought food supplies from Acme Super Market on account, $12,500.
##
Returned food supplies to Acme Super Market and received a credit on account, $350. (Hint:
Credit will be to Food Supplies account.)
##
Paid Don Brown to repair damaged fishing boat, $850.
##
Received payment from Happy Trails, Inc. on account for Apr 17th invoice less discount.
##
Issued refund check to customer for merchandise purchased at camp store, $50 plus $3
sales tax.
##
Deposited registration fees, $32,000 plus sales from camp store, $600 plus $36 sales tax.
##
Petty Cash fund records showed the following totals at the end of the month: Repairs $65,
Postage $14. Petty cash fund was replenished.
##
Paid Acme Super Market on account, $11,229. qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx THE FOLLOWING TRANSACTIONS TOOK PLACE DURING THE MONTH OF APRIL.
Date Description
##
Paid utilities bill to Progress Energy, $2,000.
##
Bob Night withdrew cash for personal use, $5,000.
##
Paid FUTA tax for first quarter, $80.
##
Paid SUTA tax from first quarter, $540.
##
Journalize the payroll entry using the following data taken from the payroll register for April
30th. Regular earnings $7500, Overtime earnings $500, Deductions: Federal income tax
$1050, Social Security tax $496, Medicare tax $116.
##
Journalize the employer's payroll taxes expense for the above payroll using the following
information: Taxable Earnings for All Employees for Social Security Wages was $8,000.
Taxable Earnings for All Employees for Unemployment Compensation was $1,000. (Note:
Tax rates are given description paragraph above the Chart of Accounts.) *** Wait and use the following information for Part II. ***
Adjustment information at the end of April is provided below:
(a) Office supplies remaining on hand, $100. (b) Food supplies remaining on hand, $8000. (c) Merchandise inventory remaining on hand, $1250. (d) Calculate insurance expired for month using transaction information on 1st with Allstate. (e) Calculate depreciation expense for one month for fishing boats using information from
transaction on 2nd. (f) Wages earned, but not yet paid, at the end of April, $5000. qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx GENERAL JOURNAL 1
2 DATE
20xx
April
1 Cash DESCRIPTION PAGE POST.
REF.
101 Bob Night, Capital DEBIT CREDIT 75,000.00 311 1 75,000.00 Owner invested cash in business 3 6 4 1 Prepaid Insurance
Cash 145 12,000.00 101 5 12,000.00 Paid Allstate for 6 mo premium 7 10 8 1 Petty Cash 100.00 Cash 9 100.00 Established new fund for Off Mgr 11 14 12 2 Rent Expense 40,000.00 Cash 13 40,000.00 Paid rent to Universal Prop 15 18 16 2 Cash 35,000.00 Sales tration Fees 17 35,000.00 Deposited reg. fees 19 22 20 2 Fishing Boats 60,000.00 Accounts Payable / Fred's Flat Bottom Boats 21 60,000.00 Purch 10 fishing boats on acct 23 26 24 3 Food Supplies 12,079.00 Accounts Payable / Acme Super Market 25 12,079.00 Purch food supplies on acct 27 30 28 4 Cash 1,500.00 Accounts Payable / Buffalo Bill's Emporium Ltd 29 1,500.00 Purch merchandise for camp store on acct 31 34 32 5 Office Supplies 500.00 Accounts Payable / Gordon Office Supp 33 500.00 Purch office supp on acct 35 38
39 36 7 Cash 38,600.00 Sales - tration Fees 37 38,600.00 Deposited reg fees 42
43 38
39 40
41 34
35 36
37 30
31 32
33 26
27 28
29 22
23 24
25 18
19 20
21 14
15 16
17 10
11 12
13 6
7 8
9 2
3 4
5 1 40 8 Purchase Returns and Allowances
Accounts Payable / Buffalo Bills Emporium Ltd
Returned merchandise 100.00 41 100.00 42
43 44 44 45 45 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx GENERAL JOURNAL 1 DATE
DESCRIPTION
20xx
8 Sales - tration Fees
April PAGE POST.
REF. DEBIT CREDIT 6,000.00 Accounts Recievable / Big Game Inc. 2 1 6,000.00 Earned fees on acct 3 2
3 4
5 2 4 12 1,400.00 5 6 28.00 6 7 1,428.00 7 8 8 9
10 9 13 10 11 11 12 12 13
14 13 14 14 15 15 16 16 17 17 18 18 19
20 19 15 20 21 21 22 22 23 23 24 24 25 25 26
27 26 15 27 28 28 29 29 30 30 31 31 32 32 33
34 33 15 34 35 35 36 36 37 37 38 38 39
40 39 16 40 41 41 42 42 43 43 44 17 44 45 45 46 46 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx GENERAL JOURNAL 1 DATE
20xx
April
18 DESCRIPTION PAGE POST.
REF. DEBIT 3 CREDIT
1 2 2 3 3 4
5 4 18 5 6 6 7 7 8
9 8 20 9 10 10 11 11 12
13 12 21 13 14 14 15 15 16 16 17 17 18
19 18 23 19 20 20 21 21 22
23 22 24 23 24 24 25 25 26
27 26 25 27 28 28 29 29 30
31 30 25 31 32 32 33 33 34
35 34 26 35 36 36 37 37 38 38 39 39 40 27 40 41 41 42 42 43 43 44 44 45 45 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx GENERAL JOURNAL 1 DATE
20xx
April
28 DESCRIPTION PAGE POST.
REF. DEBIT 4 CREDIT
1 2 2 3 3 4 4 5 5 6
7 6 29 8 7
8 9 9 10 10 11 11 12 30 12 13 13 14 14 15 15 16 30 16 17 17 18 18 19 19 20 30 20 21 21 22 22 23
24 23 30 24 25 25 26 26 27
28 27 30 28 29 29 30 30 31
32 31 30 32 33 33 34 34 35 35 36 36 37 37 38
39 38 30 39 40 40 41 41 42 42 43 43 44 44 45 45 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx GENERAL LEDGER Cash ACCOUNT: 101 ACCOUNT NO.: BALANCE
DATE 20xx
April ITEM POST.
REF. DEBIT 1 Balance P 11,000.00 1 J1 75,000.00 1 J1 CREDIT DEBIT CREDIT 11,000.00
86,000.00
12,000.00 74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00
74,000.00 Petty Cash ACCOUNT: DATE ITEM 110 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April Accounts Receivable ACCOUNT: DATE ITEM 122 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April Merchandise Inventory ACCOUNT: DATE 20xx
April ITEM 1 Balance qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 131 ACCOUNT NO.: POST.
REF. P BALANCE
DEBIT
2,000.00 CREDIT DEBIT
2,000.00 CREDIT GENERAL LEDGER Office Supplies ACCOUNT: DATE ITEM 142 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April Food Supplies ACCOUNT: DATE ITEM 144 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April Prepaid Insurance ACCOUNT: DATE ITEM 145 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April
1 J1 12,000.00 12,000.00 Fishing Boats ACCOUNT: DATE ITEM 181 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: Accumulated Depreciation-Fishing Boats DATE ITEM ACCOUNT NO.: POST.
REF. 181.1 BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April Accounts Payable ACCOUNT: DATE ITEM 202 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: Employee Income Tax Payable DATE
20xx
1 Balance
April ITEM qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 211 ACCOUNT NO.: POST.
REF.
P BALANCE
DEBIT CREDIT
1,435.00 DEBIT CREDIT
1,435.00 GENERAL LEDGER qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx GENERAL LEDGER Social Security Tax Payable ACCOUNT: DATE
20xx
April ITEM
1 Balance DATE
20xx
1 Balance
April DEBIT CREDIT ITEM DATE
1 Balance DATE
20xx
1 Balance
April DEBIT CREDIT DATE CREDIT
145.00 214 BALANCE
DEBIT CREDIT DEBIT CREDIT 80.00 80.00 215 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 540.00 P ITEM 213 ACCOUNT NO.: POST.
REF. Wages Payable ACCOUNT: DEBIT 145.00 P ITEM 620.00 BALANCE SUTA Tax Payable ACCOUNT: CREDIT ACCOUNT NO.: POST.
REF.
P ITEM DEBIT 620.00 P FUTA Tax Payable ACCOUNT: 20xx
April BALANCE Medicare Tax Payable ACCOUNT: 212 ACCOUNT NO.: POST.
REF. 540.00 219 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April Sales Tax Payable ACCOUNT: DATE 20xx
April ITEM 1 Balance qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 231 ACCOUNT NO.: POST.
REF. P BALANCE
DEBIT CREDIT
180.00 DEBIT CREDIT
180.00 GENERAL LEDGER Bob Night, Capital ACCOUNT: DATE 20xx
April ACCOUNT: DATE ITEM 1 Balance
1 BALANCE
DEBIT CREDIT DEBIT CREDIT 10,000.00
75,000.00 P
J1 Bob Night, Drawing
ITEM 311 ACCOUNT NO.: POST.
REF. 10,000.00
85,000.00 312 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Income Summary
ITEM 313 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Sales - tration Fees
ITEM 401 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Sales - Camp Store
ITEM 410 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Sales Returns and Allowances
ITEM 20xx
April qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx ACCOUNT NO.: POST.
REF. 410.1 BALANCE
DEBIT CREDIT DEBIT CREDIT GENERAL LEDGER
ACCOUNT: DATE Sales Discounts
ITEM ACCOUNT NO.: POST.
REF. 410.2 BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Purchases
ITEM 501 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Purchase Returns & Allowances
ITEM ACCOUNT NO.: POST.
REF. 501.1 BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Purchase Discounts
ITEM ACCOUNT NO.: POST.
REF. 501.2 BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Wages Expense
ITEM 510 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Payroll Taxes Expense
ITEM 520 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Advertising Expense
ITEM 20xx
April qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 530 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT GENERAL LEDGER
ACCOUNT: DATE Office Supplies Expense
ITEM 542 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Food Supplies Expense
ITEM 544 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Insurance Expense
ITEM 545 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Rent Expense
ITEM 555 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Repair Expense
ITEM 560 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Postage Expense
ITEM 565 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Utilities Expense
ITEM 570 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT 20xx
April ACCOUNT: DATE Depreciation Expense-Fishing Boats
ITEM 20xx
April qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 580 ACCOUNT NO.: POST.
REF. BALANCE
DEBIT CREDIT DEBIT CREDIT ACCOUNTS RECEIVABLE LEDGER NAME: Big Game, Inc. ADDRESS: 1874 Los Cruces, Ocala FL 32887 TERMS: Net 30 DATE ACCOUNT NO: POST.
REF. ITEM DEBIT CREDIT 10-111 BALANCE 20xx
April Happy Trails, Inc.
48711 W. 19th Ave., Kissimmee FL 34786
2% 10 days, Net 30 NAME:
ADDRESS:
TERMS:
DATE POST.
REF. ITEM ACCOUNT NO: DEBIT CREDIT BALANCE 20xx
April The General's Favorite Fishing Hole
Schedule of Accounts Receivable
April 30, 20xx
Big Game, Inc.
Happy Trails, Inc.
Total Accounts Receivable qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx $ 10-487 - ACCOUNTS PAYABLE LEDGER NAME: Acme Super Market ADDRESS: 46 Papillon Blvd., Clermont, FL 34711 TERMS: Net 30 DATE ITEM ACCOUNT NO: POST.
REF. DEBIT CREDIT A001 BALANCE 20xx
April Buffalo Bill's Emporium
87 W. Mills Ave, Winter Park CO 20610
2% 10 days, Net 30 NAME:
ADDRESS:
TERMS: DATE ITEM POST.
REF. ACCOUNT NO: DEBIT CREDIT B046 BALANCE 20xx
April Fred's Flat Bottom Boat Co.
1869 1st Street, Orlando FL 32817
Net 6 mo NAME:
ADDRESS:
TERMS: DATE ITEM POST.
REF. ACCOUNT NO: DEBIT CREDIT F023 BALANCE 20xx
April Gordon's Office Supplies
86 W. Orange Ave, Orlando FL 32819
Net 30 NAME:
ADDRESS:
TERMS: DATE ITEM POST.
REF. ACCOUNT NO: DEBIT CREDIT BALANCE 20xx
April The General's Favorite Fishing Hole
Schedule of Accounts Payable
April 30, 20xx
Acme Super Market
Buffalo Bill's Emporium
Fred's Flat Bottom Boat Co.
Gordon's Office Supplies
Total Accounts Payable qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx $ G049 - Captain Bob's Favorite Fishing Hole
Worksheet
For Month Ended April 30, 20xx Account Title Trial Balance
Debit
Credit Adjustments
Debit Adjusted Trial Balance
Debit
Credit Credit Income Statement
Debit
Credit Balance Sheet
Debit
Credit Cash
Petty Cash
Accounts Receivable
Merchandise Inventory
Office Supplies
Food Supplies
Prepaid Insurance
Fishing Boats
Accumulated Deprec. Fishing Boats
Accounts Payable
Employee Income Tax Payable
Social Security Tax Payable
Medicare Tax Payable
FUTA Tax Payable
SUTA Tax Payable
Wages Payable
Sales Tax Payable
Bob Night, Capital
Bob Night, Drawing
Income Summary
Sales - tration Fees
Sales - Camp Store
Sales Returns & Allowances
Sales Discounts
Purchases
Purchase Returns & Allowances
Purchase Discounts
Wages Expense
Payroll Taxes Expense
Advertising Expense
Office Supplies Expense
Food Supplies Expense
Insurance Expense
Rent Expense
Repair Expense
Postage Expenses
Utilties Expense
Depreciation Expense - Fishing Boats Net Income - qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx - - - - - - - - - - - Captain Bob's Favorite Fishing Hole
Income Statement
For Month Ended April 30, 20xx
Revenues:
Sales - tration Fees
Sales - Camp Store
Less: Sales Returns & Allowances
Less: Sales Discounts
Total Revenue
Expenses:
Purchases
Less Purchase Returns & Allowances
Less Purchase Discounts
Wages Expense
Payroll Taxes Expense
Advertising Expense
Office Supplies Expense
Food Supplies Expense
Insurance Expense
Rent Expense
Repair Expense
Postage Expense
Utilities Expense
Depr. Exp. - Fishing Boats
Total Expenses
Net Income qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx - $ - Captain Bob's Favorite Fishing Hole
Statement of Owner's Equity
For Month Ended April 30, 20xx
Bob Night, Capital, April 1, 20xx
Add additional investment
Total investment
Net income for April
Less withdrawals for April
Increase in capital
Bob Night, Capital, April 30, 20xx qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx $ - $
$ - - Captain Bob's Favorite Fishing Hole
Balance Sheet
April 30, 20xx
Assets
Current Assets:
Cash
Petty Cash
Accounts Receivable
Merchandise Inventory
Office Supplies
Food Supplies
Prepaid Insurance
Total Current Assets
Property, Plant, and Equipment:
Fishing Boats
Less Accumulated Depreciation
Total Assets
Liabilities
Current Liabilities:
Accounts Payable
Employee Income Tax Payable
Social Security Tax Payable
Medicare Tax Payable
FUTA Tax Payable
SUTA Tax Payable
Wages Payable
Sales Tax Payable
Total Current Liabilities
Owner's Equity
Bob Night, Capital
Total Liabilities & Owner's Equity qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx $ - $ - $ - $ - GENERAL JOURNAL
DATE DESCRIPTION POST.
REF. Adjusting Entries 1 2 PAGE 20xx
April 30 2
3 4 4 30 5 6 6 7
8 CREDIT
1 3 5 DEBIT 5 7 30 8 9 9 10 10 11 30 11 12 12 13 13 14 30 14 15 15 16
17 16 30 17 18 18 19 19 Closing Entries 20
21 30 Sales - tration Fees 20 401 21 410 22 22 Sales - Camp Store 23 Purchase Returns & Allowances 501.1 23 24 Purchase Discounts 501.2 24 25 Income Summary 313 25 26
27 26 30 Income Summary 313 27 28 Sales Returns & Allowances 410.1 28 29 Sales Discounts 410.2 29 30 Purchases 501 30 31 Wages Expense 510 31 Payroll Taxes Expense 520 32 Advertising Expense 530 32 33 Office Supplies Expense 542 33 34 Food Supplies Expense 544 34 35 Insurance Expense 545 35 36 Rent Expense 555 36 37 Repair Expense 560 37 38 Postage Expense 565 38 39 Utilities Expense 570 39 40 Depreciation Expense - Fishing Boats 580 40 41 41 42
43
44 42 30 Income Summary
Bob Night, Capital 313 43 311 44 45
46
47 45 30 Bob Night, Capital
Bob Night, Drawing 48 qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx 311 46 312 47
48 Captain Bob's Favorite Fishing Hole
Post-ClosingTrial Balance
April 30, 20xx ACCOUNT TITLE ACCOUNT
NO. Totals qattachments_0c774db1227cf53ab6021fb403477c0d369247cb.xlsx DEBIT BALANCE CREDIT BALANCE - -