Accounting Chap 5

profileiReusecondoms
spreadsheet_comppr02_corpfin.xlsx
Home>Business & Finance homework help>Accounting homework help>Accounting Chap 5

Ledger

Select the desired account title from the Excel Name Box.
Make your entries in the appropriate cells. No entry is required in the ITEM column.
Remember, this spreadsheet will not be part of your CengageNow grade.
GENERAL LEDGER
Account: Cash Account No. 110
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Account: Accounts Receivable Account No. 112
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
5
6
7
8
9
Account: Inventory Account No. 115
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
5
6
7
8
9
10
11
12
13
Account: Estimated Returns Inventory Account No. 116
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
Account: Prepaid Insurance Account No. 117
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Store Supplies Account No. 118
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
Account: Store Equipment Account No. 123
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
Account: Accumulated Depreciation-Store Equipment Account No. 124
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Accounts Payable Account No. 210
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
5
6
7
Account: Salaries Payable Account No. 211
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
Account: Customers Refunds Payable Account No. 212
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
Account: Common Stock Account No. 310
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
Account: Retained Earnings Account No. 311
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
Account: Dividends Account No. 312
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Income Summary Account No. 313
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
Account: Sales Account No. 410
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
5
6
7
Account: Cost of Goods Sold Account No. 510
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
5
6
7
8
Account: Sales Salaries Expense Account No. 520
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
Account: Advertising Expense Account No. 521
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
Account: Depreciation Expense Account No. 522
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Store Supplies Expense Account No. 523
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Miscellaneous Selling Expense Account No. 529
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Office Salaries Expense Account No. 530
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
4
Account: Rent Expense Account No. 531
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
3
Account: Insurance Expense Account No. 532
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2
Account: Miscellaneous Administrative Expense Account No. 539
DATE ITEM POST. REF. DEBIT CREDIT BALANCE
DEBIT CREDIT
1
2

EoP Work Sheet

Remember, this spreadsheet will not be part of your CengageNow grade.
Palisade Creek Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended May 31, 2018
ACCOUNT TITLE UNADJUSTED TRIAL BALANCE ADJUSTMENTS ADJUSTED TRIAL BALANCE INCOME STATEMENT BALANCE SHEET
DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT
Cash
Accounts Receivable
Inventory
Estimated Returns Inventory
Prepaid Insurance
Store Supplies
Store Equipment
Accumulated Depreciation-Store Equipment
Accounts Payable
Salaries Payable
Customers Refunds Payable
Common Stock
Retained Earnings
Dividends
Sales
Cost of Goods Sold
Sales Salaries Expense
Advertising Expense
Depreciation Expense
Store Supplies Expense
Miscellaneous Selling Expense
Office Salaries Expense
Rent Expense
Insurance Expense
Miscellaneous Administrative Expense
Net income