Accounting Problem

profileguzmaseb
AggieGolfClub.xlsx
Home>Business & Finance homework help>Accounting homework help>Accounting Problem

GENERAL JOURNAL

GENERAL JOURNAL
Transaction # Date Account Titles Debit Credit
1 1-Jan CASH 120,000.00
COMMON STOCK 120,000.00
2 2-Jan PREPAID RENT 45,000.00
CASH 45,000.00
3 2-Jan FURNITURE 24,000.00
FIXTURES 4,320.00
EQUIPMENT 79,200.00
CASH 21,504.00
NOTES PAYABLE 86,016.00
4 3-Jan PREPAID INSURANCE 4,500.00
CASH 4,500.00
5 3-Jan OFFICE SUPPLIES 700.00 Kellis supplies
ACCOUNTS PAYABLE 700.00
6 3-Jan INVENTORY-SHIRTS 1,000.00
ACCOUNTS PAYABLE 1,000.00
7 3-Jan INVENTORY-CONCESSIONS 4,200.00
CASH 1,050.00
ACCOUNTS PAYABLE 3,150.00
8 3-Jan CASH 168,750.00
UNEARNED REVENUE 168,750.00
9 3-Jan PREPAID MAINTENANCE 7,800.00
CASH 7,800.00
10 5-Jan CASH 650.00
ACCOUNTS RECEIVABLE 2,950.00
SERVICE REVENUE 3,600.00
11 6-Jan LEGAL EXPENSE 250.00
ACCOUNTS PAYABLE 250.00
12 8-Jan CASH 450.00
ACCOUNTS RECEIVABLE 518.00
SALES REVENUE 968.00
COST OF GOODS SOLD 440.00
INVENTORY-SHIRTS 440.00
13 14-Jan OFFICE SUPPLIES 300.00 kellis
ACCOUNTS PAYABLE 300.00
14 15-Jan SALARY EXPENSE 2,250.00
CASH 2,250.00
15 15-Jan CASH 56,250.00
UNEARNED REVENUE 56,250.00
16 15-Jan ACCOUNTS RECEIVABLE 5,500.00
SALES REVENUE 5,500.00
COST OF GOODS SOLD 2,800.00
INVENTORY-CONCESSIONS 2,800.00
17 16-Jan INVENTORY-CONCESSIONS 1,800.00
ACCOUNTS PAYABLE 1,800.00
18 18-Jan ACCOUNTS PAYABLE 2,250.00
CASH 2,250.00
19 19-Jan CASH 324.00
ACCOUNTS RECEIVABLE 756.00
SALES REVENUE 1,080.00
COST OF GOODS SOLD 360.00
INVENTORY-SHIRTS 360.00
20 22-Jan DIVIDENDS 3,000.00
CASH 3,000.00
21 26-Jan CASH 518.00
ACCOUNTS RECEIVABLE 518.00
22 28-Jan UTILITIES EXPENSE 980.00
ACCOUNTS PAYABLE 980.00
23 31-Jan ACCOUNTS RECEIVABLE 4,680.00
SERVICE REVENUE 4,680.00
24 31-Jan CASH 240.00
SALES REVENUE 240.00
COST OF GOODS SOLD 80.00
INVENTORY-SHIRTS 80.00
25 31-Jan CASH 1,500.00
ACCOUNTS RECEIVABLE 3,500.00
SALES REVENUE 5,000.00
COST OF GOODS SOLD 2,400.00
INVENTORY-CONCESSIONS 2,400.00
26 31-Jan CASH 4,400.00
ACCOUNTS RECEIVABLE 4,400.00
27 31-Jan CASH 1,250.00
SERVICE REVENUE 1,250.00
28 31-Jan FIXTURES 2,650.00
CASH 2,650.00
GENERAL JOURNAL - ADJUSTING ENTRIES
Transaction # Date Account Titles Debit Credit
GENERAL JOURNAL - CLOSING ENTRIES
Transaction # Date Account Titles Debit Credit

GENERAL LEDGER

GENERAL LEDGER
ACCOUNT DATE DR CR BAL NOTES
CASH 1-Jan 120,000.00 Owner Contribution
2-Jan 45,000.00 Prepaid four months of rent
2-Jan 21,504.00 20% paid in cash for furniture, fixtures, and equipment
3-Jan 4,500.00 Prepaid 6 months of insurance
3-Jan 1,050.00 25% of concessions paid in cash
3-Jan 168,750.00 Sale of memberships
3-Jan 7,800.00 Prepaid 6 months of maintenance
5-Jan 650.00 Cash collected from golf lessons
8-Jan 450.00 Cash collected from sale of shirts
15-Jan 2,250.00 Paid wages to employees
15-Jan 56,250.00 Sale of memberships
18-Jan 2,250.00 Paid portion of accounts payable
19-Jan 324.00 Cash collected from sale of shirts
22-Jan 3,000.00 Paid dividend to owners
26-Jan 518.00 Collected portion of accounts receivables
31-Jan 240.00 Cash collected from sale of shirts
31-Jan 1,500
31-Jan 4,400.00 Cash collected from accounts receivables
31-Jan 1,250.00 Green fees collected
31-Jan 2,650.00 Purchase of additional fixtures
264,328 CASH BALANCE
ACCOUNTS RECEIVABLE 5-Jan 2,950.00 Portion of golf lessons charged to costumers account
8-Jan 518.00 Portion of sale of shirts owed to club on acount
15-Jan 5,500.00 Sale of concessions on account
26-Jan 756.00 Portion of sale of shirts owed to club on acount
518.00 Collected cash from sale to Allen on account
31-Jan 4,680.00 Golf lessons on account
31-Jan 3,500.00 Sale of concessions on account
31-Jan 4,400.00 Cash received from services rendered on account
12,986 ACCOUNTS RECEIVABLE BALANCE
INVENTORY - SHIRTS 3-Jan 1,000.00 Purchased shirts
8-Jan 440.00 Sale of shirts
19-Jan 360.00 Sale of shirts
31-Jan 80.00 Sale of shirts
120 UNADJUSTED INVENTORY BALANCE
120 ENDING INVENTORY BALANCE
INVENTORY - CONCESSIONS 3-Jan 4,200.00 Purchased concession
15-Jan 2,800.00 Sale of concession
16-Jan 1,800.00 Purchased concession
31-Jan 2,400.00 Sale of concession
800 UNADJUSTED INVENTORY BALANCE
800 ENDING INVENTORY-CONCESSIONS BAL.
OFFICE SUPPLIES 3-Jan 700.00
14-Jan 300.00
1,000 UNADJUSTED SUPPLIES BALANCE
1,000 ENDING SUPPLIES BALANCE
PREPAID RENT 1/2 45,000
45,000 UNADJUSTED RENT BALANCE
45,000 ENDING PREPAID RENT BALANCE
PREPAID INSURANCE 1/3 4,500
4,500 UNADJUSTED PREPAID INSURANCE BALANCE
4,500 ENDING PREPAID INSURANCE BALANCE
PREPAID MAINTENANCE 1/3 7,800
7,800 UNADJUSTED PREPAID MAINT BALANCE
7,800 ENDING PREPAID MAINT BALANCE
FURNITURE 24,000
24,000 FURNITURE BALANCE
FIXTURES 4,320
4,320 FIXTURES BALANCE
EQUIPMENT 79,200 8
79,200 EQUIPMENT BALANCE
ACCUMULATED DEPRECIATION - FURNITURE
- 0 ENDING ACCUM. DEPR.- FURNITURE BALANCE
ACCUMULATED DEPRECIATION - FIXTURES
- 0 ENDING ACCUM. DEPR.- FIXTURES BALANCE
ACCUMULATED DEPRECIATION - EQUIPMENT
- 0 ENDING ACCUM. DEPR.- EQUIPMENT BALANCE
ACCOUNTS PAYABLE 700.00
1,000.00
3,150.00
250.00
300.00
1,800.00
18-Jan 2,250.00
4,950 ACCOUNTS PAYABLE BALANCE
SALARIES PAYABLE
- 0 ENDING SALARIES PAYABLE BALANCE
INTEREST PAYABLE
- 0 ENDING INTEREST PAYABLE BALANCE
UNEARNED REVENUE
- 0 UNADJUSTED UNEARNED REVENUE BALANCE
- 0 ENDING UNEARNED REVENUE BALANCE
NOTES PAYABLE
- 0 NOTES PAYABLE BALANCE
COMMON STOCK
- 0 COMMON STOCK BALANCE
RETAINED EARNINGS
- 0 RETAINED EARNINGS BALANCE
DIVIDENDS 1/22 3,000
3,000 DIVIDENDS BALANCE
3,000 DIVIDENDS BALANCE - AFTER CLOSING
SALES REVENUE
- 0 SALES REVENUE BALANCE
- 0
- 0 BALANCE AFTER CLOSING
SERVICE REVENUE
- 0 UNADJUSTED SERVICE REVENUE BALANCE
- 0 SERVICE REVENUE BALANCE
- 0 BALANCE AFTER CLOSING
COST OF GOODS SOLD 440.00
2,800.00
360.00
80.00
2,400.00
6,080 COST OF GOODS SOLD BALANCE
6,080 BALANCE AFTER CLOSING
RENT EXPENSE
- 0 RENT EXPENSE BALANCE
- 0 BALANCE AFTER CLOSING
INSURANCE EXPENSE
- 0 INSURANCE EXPENSE BALANCE
- 0 BALANCE AFTER CLOSING
MAINTENANCE EXPENSE
- 0 MAINTENANCE EXPENSE BALANCE
- 0 BALANCE AFTER CLOSING
SALARY AND WAGE EXPENSE 2,250
2,250 UNADJUSTED SALARY EXPENSE BALANCE
2,250 SALARY AND WAGE EXPENSE BALANCE
2,250 BALANCE AFTER CLOSING
SUPPLIES EXPENSE
- 0 SUPPLIES EXPENSE BALANCE
- 0 BALANCE AFTER CLOSING
LEGAL EXPENSE 250
250 LEGAL EXPENSE BALANCE
250 BALANCE AFTER CLOSING
UTILITIES EXPENSE 980
980 UTILITIES EXPENSE BALANCE
980 BALANCE AFTER CLOSING
DEPRECIATION EXPENSE
- 0 DEPRECIATION EXPENSE BALANCE
- 0 BALANCE AFTER CLOSING
INTEREST EXPENSE
- 0 INTEREST EXPENSE BALANCE
- 0 BALANCE AFTER CLOSING
LOSS ON SHRINKAGE
- 0 LOSS ON SHRINKAGE BALANCE
- 0 BALANCE AFTER CLOSING

WORKSHEET

GROUP ID 01 TRIAL BALANCE ADJUSTMENTS ADJ. TRIAL BALANCE AFTER CLOSING TB
ACCOUNT DR CR DR CR DR CR DR CR
CASH 264,328 264,328 264,328
ACCOUNTS RECEIVABLE 12,986 12,986 12,986
INVENTORY - SHIRTS 120 - 0 120 120
INVENTORY - CONCESSIONS 800 - 0 800 800
SUPPLIES 1,000 - 0 1,000 1,000
PREPAID RENT 45,000 - 0 45,000 45,000
PREPAID INSURANCE 4,500 - 0 4,500 4,500
PREPAID MAINTENANCE 7,800 - 0 7,800 7,800
FURNITURE 24,000 24,000 24,000
ACCUMULATED DEPRECIATION - FURNITURE - 0 - 0 - 0
FIXTURES 4,320 4,320 4,320
ACCUMULATED DEPRECIATION - FIXTURES - 0 - 0 - 0
EQUIPMENT 79,200 79,200 79,200
ACCUMULATED DEPRECIATION - EQUIPMENT - 0 - 0 - 0
ACCOUNTS PAYABLE 4,950 4,950 4,950
SALARIES PAYABLE - 0 - 0 - 0
INTEREST PAYABLE - 0 - 0 - 0
UNEARNED REVENUE - 0 - 0 - 0 - 0 - 0
NOTES PAYABLE - 0 - 0 - 0
COMMON STOCK - 0 - 0 - 0
RETAINED EARNINGS - 0
DIVIDENDS 3,000 3,000 - 0
SALES REVENUE - 0 - 0 - 0
SERVICE REVENUE - 0 - 0 - 0 - 0 - 0
COST OF GOODS SOLD 6,080 6,080 6,080
RENT EXPENSE - 0 - 0 - 0 - 0
INSURANCE EXPENSE - 0 - 0 - 0 - 0
MAINTENANCE EXPENSE - 0 - 0 - 0 - 0
SALARY AND WAGE EXPENSE 2,250 - 0 - 0 2,250 2,250
SUPPLIES EXPENSE - 0 - 0 - 0 - 0
LEGAL EXPENSE 250 250 250
UTILITIES EXPENSE 980 980 980
DEPRECIATION EXPENSE - 0 - 0 - 0 - 0
INTEREST EXPENSE - 0 - 0 - 0 - 0
LOSS ON SHRINKAGE - 0 - 0 - 0 - 0
Trial Balance Totals 456,614 4,950 - 0 - 0 456,614 4,950 453,614 4,950

FINANCIAL STATEMENTS

The Golf Club
Income Statement
For the month ended January 31, 2021
The Golf Club
Statement of Retained Earnings
For the month ended January 31, 2021
The Golf Club
Balance Sheet
For the month ended January 31, 2021