I am trying to get the right number for the unadjusted trial balance after a month of transactions. Can anyone help me figure out

I am trying to get the right number for the unadjusted trial balance after a month of transactions. Can anyone help me figure out what I'm doing wrong? The excel file is what I have so far (only looking for the unadjusted balance that should be equal to  $459,264 and I'm getting $456,614)

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

,

Practice Problem in Accounting

The Golf Club

Instructions

Use the following TRANSACTIONS AND ADDITIONAL INFORMATION to complete the General Journal, Ledger, Worksheet and Financial Statements for the first month of operations for The Golf Club. Use the Perpetual Inventory method as discussed in class for all sales of merchandise.

TRANSACTIONS

TRANSACTION #

DATE

TRANSACTION DESCRIPTION

1

Jan 1

At the beginning of January, three friends organized The Golf Club by contributing $40,000 each to begin the new business in exchange for shares of stock.

2

Jan 2

Signed a one-year lease on an existing golf club and golf course for The Golf Club and made a $45,000 advance payment for the first four month’s rent.

3

Jan 2

The Golf Club purchased the following fixed assets, paying 20% down and giving a two-year, 6% APR, note for the balance. Principle and interest are due at maturity.

Furniture………………..$24,000

Fixtures…………………$4,320

Equipment………………$79,200

$107,520

4

Jan 3

Purchased a 6-month insurance policy on The Golf Club and its contents and paid the premium of $4,500 in advance.

5

Jan 3

Purchased office supplies for $700 on an open account from Kelli’s Office Supplies. The Golf Club has 30 days to pay for the supplies.

6

Jan 3

Purchased on account a total of 100 shirts with an embroidered Golf Club logo from C & C Creations at a price of $10 per shirt. These shirts are available for resale to customers.

7

Jan 3

Purchased concessions for $4,200 from Delta Distributing, Inc. These concessions consist of energy drinks, chips, crackers, nuts etc., and are available for resale to customers. The Golf Club paid 25% down and put the balance on account.

8

Jan 3

Sold 75, twelve-month memberships to The Golf Club for $2,250 each. All membership dues were collected in cash.

9

Jan 3

Purchased a 6-month maintenance contract with Larry’s Landscaping to provide grounds maintenance. Paid $7,800 in advance for this service.

10

Jan 5

Provided 60 hours of golf lessons to members. Fees are charged at a rate of $60/hour. Of these fees, $650 was collected in cash and the balance was billed to individual member’s accounts.

11

Jan 6

Received a bill for $250 from The Golf Club’s attorney for legal ser

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018