FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

I'm not sure what goes on the adjustments debit and credit column. Need help filling out the spreadsheet.

Comprehensive Problem 2
Part 5: Optional work sheet
Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the
following adjustment data.
a. Inventory on May 31
b. Insurance expired during the year
c. Store supplies on hand on May 31
d. Depreciation for the current year
e. Accrued salaries on May 31:
Sales salaries
Office salaries
Account
13,600
f. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold.
If an amount box does not require an entry, leave it blank.
Cash
Accounts
Receivable
Inventory
Estimated
Returns
Inventory
Prepaid
Insurance
Store
Supplies
Store
Equipment
Accum.
Depr.-Store
Equip.
Accounts
Payable
Salaries
Payable
Customers
Refunds
Unadjusted Unadjusted
Trial
Trial
Balance
Balance
Debit
Credit
86,970
247,450
583,950
15,200
16,800
$7,000
6,600
13,800
569,500
56,700
✓
63,150
$570,000
12,000
4,000
14,000
29,270
Pallsade Creek Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended May 31, 20Y6
Adjustments Adjustments
Debit
Credit
MEN
Adjusted Adjusted
Trial Trial
Balance Balance
Debit
Credit
9,800
86,970
247,450
13,950 570,000
4,800
4,000
569,500
Income Income Balance Balance
Statement Statement Sheet
Debit
Sheet
Credit
Debit
Credit
expand button
Transcribed Image Text:Comprehensive Problem 2 Part 5: Optional work sheet Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following adjustment data. a. Inventory on May 31 b. Insurance expired during the year c. Store supplies on hand on May 31 d. Depreciation for the current year e. Accrued salaries on May 31: Sales salaries Office salaries Account 13,600 f. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold. If an amount box does not require an entry, leave it blank. Cash Accounts Receivable Inventory Estimated Returns Inventory Prepaid Insurance Store Supplies Store Equipment Accum. Depr.-Store Equip. Accounts Payable Salaries Payable Customers Refunds Unadjusted Unadjusted Trial Trial Balance Balance Debit Credit 86,970 247,450 583,950 15,200 16,800 $7,000 6,600 13,800 569,500 56,700 ✓ 63,150 $570,000 12,000 4,000 14,000 29,270 Pallsade Creek Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended May 31, 20Y6 Adjustments Adjustments Debit Credit MEN Adjusted Adjusted Trial Trial Balance Balance Debit Credit 9,800 86,970 247,450 13,950 570,000 4,800 4,000 569,500 Income Income Balance Balance Statement Statement Sheet Debit Sheet Credit Debit Credit
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
Admin
Expense
Net Income
✓
135,000
✓
3,013,000
✓
720,800
✓
292,000
or on
0
✓
12,600
411,100
88,700
✓
0
7,800
100,000
✓
585,300
✓
5,380,250
6,214,670 6,214,670
135,000
14,000
7,800
100,000
expand button
Transcribed Image Text: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 Admin Expense Net Income ✓ 135,000 ✓ 3,013,000 ✓ 720,800 ✓ 292,000 or on 0 ✓ 12,600 411,100 88,700 ✓ 0 7,800 100,000 ✓ 585,300 ✓ 5,380,250 6,214,670 6,214,670 135,000 14,000 7,800 100,000
Expert Solution
Check Mark
Still need help?
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Journalize the closing entries. Indicate closed accounts by inserting a line in both the balance columns opposite the closing entry. Insert the new balance in the retained earnings account. And 

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Question

I added all the items and got an incorrect for the totals on the spreadsheet and partical complete. I'm not sure what else I'm missing. Please help

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
Admin.
Expense
Net Income
135,000
3,013,000
720,800
292,000
0
12,600
411,100
88,700
0
✓
7,800
100,000
585,300
5,380,250
6,214,670 6,214,670
X
X
6,214,670 6,214,670
60,000
13,950
7,000
14,000
9,800
6,600
12,000
158,350
X
158,350
135,000
35,000 2,991,950
727,800
292,000
14,000
9,800
12,600
417,700
12,000
100,000
585,300
5,320,250
2,991,950
727,800
292,000
14,000
9,800
12,600
417,700
88,700
✓
12,000
✓
7,800
5,320,250
745,900
135,000
100,000
585,300
7,800
✓
158,350 6,242,270 6,242,270 4,574,350 5,320,250 1,667,920 922,020
745,900
X
X
X
158,350 6,242,270 6,242,270 5,320,250 5,320,250 1,667,920 1,667,920
expand button
Transcribed Image Text: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 Admin. Expense Net Income 135,000 3,013,000 720,800 292,000 0 12,600 411,100 88,700 0 ✓ 7,800 100,000 585,300 5,380,250 6,214,670 6,214,670 X X 6,214,670 6,214,670 60,000 13,950 7,000 14,000 9,800 6,600 12,000 158,350 X 158,350 135,000 35,000 2,991,950 727,800 292,000 14,000 9,800 12,600 417,700 12,000 100,000 585,300 5,320,250 2,991,950 727,800 292,000 14,000 9,800 12,600 417,700 88,700 ✓ 12,000 ✓ 7,800 5,320,250 745,900 135,000 100,000 585,300 7,800 ✓ 158,350 6,242,270 6,242,270 4,574,350 5,320,250 1,667,920 922,020 745,900 X X X 158,350 6,242,270 6,242,270 5,320,250 5,320,250 1,667,920 1,667,920
Comprehensive Problem 2
Part 5: Optional work sheet
Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following
adjustment data.
a. Inventory on May 31
b. Insurance expired during the year
c. Store supplies on hand on May 31
d. Depreciation for the current year
e. Accrued salaries on May 31:
Sales salaries
Office salaries
Account
Title
13,600
f. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold.
If an amount box does not require an entry, leave it blank.
Cash
Accounts
Receivable
Inventory
Estimated
Returns
Inventory
Prepaid
Insurance
Store
Supplies
Store
Equipment
Accum.
Depr.-Store
Equip.
Accounts
Payable
Salaries
Payable
Customers
Refunds
Payable
Unadjusted Unadjusted
Trial
Trial
Balance
Debit
86,970
247,450
583,950
15,200
16,800
$7,000
6,600
13,800
569,500
Balance
Credit
56,700
63,150
0
$570,000
12,000
4,000
14,000
29,270
Palisade Creek Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended May 31, 2016
Adjustments Adjustments
Debit
Credit
35,000
13,950 570,000
14,000
Adjusted Adjusted
Trial Trial
Balance Balance
Debit Credit
13,600
86,970
✓
247,450
12,000 4,800
✓
9,800
60,000
50,200
4,000
569,500
70,700
63,150
13,600
✓
89,270
Income Income Balance Balance
Statement Statement Sheet Sheet
Debit Credit Debit Credit
86,970
✓
247,450
570,000
50,200
4,800
4,000
569,500
70,700
63,150
13,600
89,270
expand button
Transcribed Image Text:Comprehensive Problem 2 Part 5: Optional work sheet Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following adjustment data. a. Inventory on May 31 b. Insurance expired during the year c. Store supplies on hand on May 31 d. Depreciation for the current year e. Accrued salaries on May 31: Sales salaries Office salaries Account Title 13,600 f. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold. If an amount box does not require an entry, leave it blank. Cash Accounts Receivable Inventory Estimated Returns Inventory Prepaid Insurance Store Supplies Store Equipment Accum. Depr.-Store Equip. Accounts Payable Salaries Payable Customers Refunds Payable Unadjusted Unadjusted Trial Trial Balance Debit 86,970 247,450 583,950 15,200 16,800 $7,000 6,600 13,800 569,500 Balance Credit 56,700 63,150 0 $570,000 12,000 4,000 14,000 29,270 Palisade Creek Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended May 31, 2016 Adjustments Adjustments Debit Credit 35,000 13,950 570,000 14,000 Adjusted Adjusted Trial Trial Balance Balance Debit Credit 13,600 86,970 ✓ 247,450 12,000 4,800 ✓ 9,800 60,000 50,200 4,000 569,500 70,700 63,150 13,600 ✓ 89,270 Income Income Balance Balance Statement Statement Sheet Sheet Debit Credit Debit Credit 86,970 ✓ 247,450 570,000 50,200 4,800 4,000 569,500 70,700 63,150 13,600 89,270
Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Journalize the closing entries. Indicate closed accounts by inserting a line in both the balance columns opposite the closing entry. Insert the new balance in the retained earnings account. And 

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Question

I added all the items and got an incorrect for the totals on the spreadsheet and partical complete. I'm not sure what else I'm missing. Please help

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
Admin.
Expense
Net Income
135,000
3,013,000
720,800
292,000
0
12,600
411,100
88,700
0
✓
7,800
100,000
585,300
5,380,250
6,214,670 6,214,670
X
X
6,214,670 6,214,670
60,000
13,950
7,000
14,000
9,800
6,600
12,000
158,350
X
158,350
135,000
35,000 2,991,950
727,800
292,000
14,000
9,800
12,600
417,700
12,000
100,000
585,300
5,320,250
2,991,950
727,800
292,000
14,000
9,800
12,600
417,700
88,700
✓
12,000
✓
7,800
5,320,250
745,900
135,000
100,000
585,300
7,800
✓
158,350 6,242,270 6,242,270 4,574,350 5,320,250 1,667,920 922,020
745,900
X
X
X
158,350 6,242,270 6,242,270 5,320,250 5,320,250 1,667,920 1,667,920
expand button
Transcribed Image Text: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 Admin. Expense Net Income 135,000 3,013,000 720,800 292,000 0 12,600 411,100 88,700 0 ✓ 7,800 100,000 585,300 5,380,250 6,214,670 6,214,670 X X 6,214,670 6,214,670 60,000 13,950 7,000 14,000 9,800 6,600 12,000 158,350 X 158,350 135,000 35,000 2,991,950 727,800 292,000 14,000 9,800 12,600 417,700 12,000 100,000 585,300 5,320,250 2,991,950 727,800 292,000 14,000 9,800 12,600 417,700 88,700 ✓ 12,000 ✓ 7,800 5,320,250 745,900 135,000 100,000 585,300 7,800 ✓ 158,350 6,242,270 6,242,270 4,574,350 5,320,250 1,667,920 922,020 745,900 X X X 158,350 6,242,270 6,242,270 5,320,250 5,320,250 1,667,920 1,667,920
Comprehensive Problem 2
Part 5: Optional work sheet
Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following
adjustment data.
a. Inventory on May 31
b. Insurance expired during the year
c. Store supplies on hand on May 31
d. Depreciation for the current year
e. Accrued salaries on May 31:
Sales salaries
Office salaries
Account
Title
13,600
f. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold.
If an amount box does not require an entry, leave it blank.
Cash
Accounts
Receivable
Inventory
Estimated
Returns
Inventory
Prepaid
Insurance
Store
Supplies
Store
Equipment
Accum.
Depr.-Store
Equip.
Accounts
Payable
Salaries
Payable
Customers
Refunds
Payable
Unadjusted Unadjusted
Trial
Trial
Balance
Debit
86,970
247,450
583,950
15,200
16,800
$7,000
6,600
13,800
569,500
Balance
Credit
56,700
63,150
0
$570,000
12,000
4,000
14,000
29,270
Palisade Creek Co.
End-of-Period Spreadsheet (Work Sheet)
For the Year Ended May 31, 2016
Adjustments Adjustments
Debit
Credit
35,000
13,950 570,000
14,000
Adjusted Adjusted
Trial Trial
Balance Balance
Debit Credit
13,600
86,970
✓
247,450
12,000 4,800
✓
9,800
60,000
50,200
4,000
569,500
70,700
63,150
13,600
✓
89,270
Income Income Balance Balance
Statement Statement Sheet Sheet
Debit Credit Debit Credit
86,970
✓
247,450
570,000
50,200
4,800
4,000
569,500
70,700
63,150
13,600
89,270
expand button
Transcribed Image Text:Comprehensive Problem 2 Part 5: Optional work sheet Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet using the following adjustment data. a. Inventory on May 31 b. Insurance expired during the year c. Store supplies on hand on May 31 d. Depreciation for the current year e. Accrued salaries on May 31: Sales salaries Office salaries Account Title 13,600 f. The adjustment for customer returns and allowances is $60,000 for sales and $35,000 for cost of goods sold. If an amount box does not require an entry, leave it blank. Cash Accounts Receivable Inventory Estimated Returns Inventory Prepaid Insurance Store Supplies Store Equipment Accum. Depr.-Store Equip. Accounts Payable Salaries Payable Customers Refunds Payable Unadjusted Unadjusted Trial Trial Balance Debit 86,970 247,450 583,950 15,200 16,800 $7,000 6,600 13,800 569,500 Balance Credit 56,700 63,150 0 $570,000 12,000 4,000 14,000 29,270 Palisade Creek Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended May 31, 2016 Adjustments Adjustments Debit Credit 35,000 13,950 570,000 14,000 Adjusted Adjusted Trial Trial Balance Balance Debit Credit 13,600 86,970 ✓ 247,450 12,000 4,800 ✓ 9,800 60,000 50,200 4,000 569,500 70,700 63,150 13,600 ✓ 89,270 Income Income Balance Balance Statement Statement Sheet Sheet Debit Credit Debit Credit 86,970 ✓ 247,450 570,000 50,200 4,800 4,000 569,500 70,700 63,150 13,600 89,270
Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education