Using the worksheet for Williams pests Control, post to closing entries to a general journal account and create the post closing trial balance repor

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter19: Variable Costing (varcost)
Section: Chapter Questions
Problem 2R: Open the file VARCOST from the website for this book at cengagebrain.com. Enter the formulas where...
icon
Related questions
icon
Concept explainers
Question
Using the worksheet for Williams pests Control, post to closing entries to a general journal account and create the post closing trial balance report.
Googie Doc Access Directions:
Please click on File in the upper left corner.
If you are working on a Chromebook or Google Docs, choose the Make a copy option and save a copy of the document to your Google Drive.
If not, choose the Download as option and then the Microsoft Excel option to download an editable copy of the document to your computer.
William's Pest Control
Worksheet
For Period Ended June 30, 200X
1
2
3
4
TRIAL BALANCE
ADJUSTMENTS
INCOME STATEMENT
BALANCE SHEET
ACCOUNT TITLE
DEBIT
CREDIT
DEBIT
CREDIT
DEBIT
CREDIT
DEBIT
CREDIT
1 Cash
14,610.00
14,610.00
1
2 Accounts Receivable - UNC
750.00
750.00
1
3.
Accounts Receivable - NC State
699.00
699.00
3
12
4 Supplies
690.00
4
1.640.00
950.00
13
5 Prepaid Insurance
960,00
480.00
480.00
5
14
6 Account Payable - Crapper's Zappers
1.000.00
6
1,000.00
15
7 Accounts Payable - Roach Coach
1,250.00
1,250.00
16
13,500.00
13,500.00
8
8 Roy Williams, Capital
17
9 Roy Williams, Drawing
975.00
975.00
18
10 Income Summary
10
19
11 Sales
6,750.00
6,750.00
11
20
12 Advertising Expense
350.00
12
350.00
21
13 Insurance Expense
480,00
480.00
13
22
14 Miscellaneous Expense
266.00
266,00
14
23
15 Rent Expense
1,500.00
1,500.00
15
24
16 Supplies Expense
950,00
950,00
16
25
17 Utilities Expense
750.00
750.00
17
26
22,500.00
22,500.00
1,430.00
1,430.00
4,296.00
6,750.00
18,204.00
15,750.00
18
18 Totals
27
2,454.00
2,454.00
19
19 Net Income
6,750.00
6,750.00
18,204.00
18,204.00
20
28
20
21
29
21
30
31
32
33
Transcribed Image Text:Googie Doc Access Directions: Please click on File in the upper left corner. If you are working on a Chromebook or Google Docs, choose the Make a copy option and save a copy of the document to your Google Drive. If not, choose the Download as option and then the Microsoft Excel option to download an editable copy of the document to your computer. William's Pest Control Worksheet For Period Ended June 30, 200X 1 2 3 4 TRIAL BALANCE ADJUSTMENTS INCOME STATEMENT BALANCE SHEET ACCOUNT TITLE DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT 1 Cash 14,610.00 14,610.00 1 2 Accounts Receivable - UNC 750.00 750.00 1 3. Accounts Receivable - NC State 699.00 699.00 3 12 4 Supplies 690.00 4 1.640.00 950.00 13 5 Prepaid Insurance 960,00 480.00 480.00 5 14 6 Account Payable - Crapper's Zappers 1.000.00 6 1,000.00 15 7 Accounts Payable - Roach Coach 1,250.00 1,250.00 16 13,500.00 13,500.00 8 8 Roy Williams, Capital 17 9 Roy Williams, Drawing 975.00 975.00 18 10 Income Summary 10 19 11 Sales 6,750.00 6,750.00 11 20 12 Advertising Expense 350.00 12 350.00 21 13 Insurance Expense 480,00 480.00 13 22 14 Miscellaneous Expense 266.00 266,00 14 23 15 Rent Expense 1,500.00 1,500.00 15 24 16 Supplies Expense 950,00 950,00 16 25 17 Utilities Expense 750.00 750.00 17 26 22,500.00 22,500.00 1,430.00 1,430.00 4,296.00 6,750.00 18,204.00 15,750.00 18 18 Totals 27 2,454.00 2,454.00 19 19 Net Income 6,750.00 6,750.00 18,204.00 18,204.00 20 28 20 21 29 21 30 31 32 33
F
G
H
J
A
B
C
1
2
GENERAL JOURNAL
PAGE
3
4
DOC. POST.
GENERAL
DATE
ACCOUNT TITLE
NO.
REF.
DEBIT
CREDIT
Adjusting Entries
950.00
1 June 30 Supplies Expense
Supplies
30 Insurance Expense
Prepaid Insurance
8.
950.00 2
2
6.
480.00
3.
3
10
480.00
4
4
11
5
12
Closing Entries
6.
13
7.
Use t
7.
14
8
8.
15
9
9
16
10
10
17
11
11
18
12
12
19
13
13
20
14
14
21
15
15
22
16
16
23
17
17
24
18
18
25
19
19
26
20
20
27
21
21
28
22
22
29
23
23
30
24
24
31
25
25
Transcribed Image Text:F G H J A B C 1 2 GENERAL JOURNAL PAGE 3 4 DOC. POST. GENERAL DATE ACCOUNT TITLE NO. REF. DEBIT CREDIT Adjusting Entries 950.00 1 June 30 Supplies Expense Supplies 30 Insurance Expense Prepaid Insurance 8. 950.00 2 2 6. 480.00 3. 3 10 480.00 4 4 11 5 12 Closing Entries 6. 13 7. Use t 7. 14 8 8. 15 9 9 16 10 10 17 11 11 18 12 12 19 13 13 20 14 14 21 15 15 22 16 16 23 17 17 24 18 18 25 19 19 26 20 20 27 21 21 28 22 22 29 23 23 30 24 24 31 25 25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage