microsoft excel

profileproeti
excel1.xlsx
Home>Business & Finance homework help>Accounting homework help>microsoft excel

Chart of Accounts

Chart of Accounts
Cash 111
Accounts Receivable 113
Office Supplies 115
Prepaid Rent 117
Office Equipment 145
Accumulated Depreciation - Office Equipment 146
Accounts Payable 212
Unearned Design Revenue 213
Wages Payable 214
J. Miller, Capital 311
J. Miller, Withdrawals 312
Income Summary 313
Design Revenue 411
Wages Expense 511
Utilities Expense 512
Rent Expense 514
Office Supplies Expense 517
Depreciation Expense - Office Equipment 519
Dropdown List for Transaction Descriptions
Billed for design services performed
Cash investment by J. Miller
For design services performed for Rave Department Stores
Paid amount due for utility bill received and recorded in July
Paid assistant four weeks' wages
Paid for office equipment purchased in July
Paid September rent in advance
Paid utilities bill for August
Purchased office equipment
Purchased office supplies
Received advance fee for design services
Received cash payment for design services
Received payment for design services performed last month
To accrue unrecorded wages
To close the expense accounts into the income summary account
To close the income summary account
To close the revenue account into the income summary account
To close the withdrawals account
To recognize expiration of one month's rent
To recognize office supplies used during the month
To recognize performance of services paid for in advance
To record depreciation of equipment for the month
To record revenue earned, but not billed until September
To reverse the adjusting entry for accrued design revenue earned
To reverse the adjusting entry for accrued wages
Withdrawal of cash by J. Miller
Dropdown List for Statement of Owner's Equity
J. Miller, Capital, August 1, 2011
J. Miller, Capital, August 31, 2011
Less Withdrawals
Net Income (Loss)
Plus Investment by Owner
Subtotal
Dropdown List for Work Sheet Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
Dropdown List for Ledger Items
Adjusting
Closing
Reversing
Dropdown List for Ledger Post Ref
J1
J2
J3
J4
J5
J6
J7
J8
J9
J10

Reversing Journal Entries

Name: # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
Course: 0
Date: # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
14
Chapter 4, Comprehensive Problem # N-box + B-box corrects COUNTIF(B7:AT41," ")
0
1. Record the optional reversing entry on August 1 for Wages Payable (see adjustment for unrecorded wages on page 112). Total SUM(AV13:AV15)
14
General Journal Page 5 Percentage =AV14/AV16
Date Description Post Ref Debit Credit 0%
2011 Notes:
Aug 01
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Enter amounts as positive whole numbers.		 If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
1. Record the optional reversing entry on August 1 for Accounts Receivable (see adjustment for design revenue on page 115).
Aug 01
Overall Score: 0%
Tab Score: 0%
Chapter 4, Comprehensive Problem
1. Record the optional reversing entry on August 1 for Wages Payable (see adjustment for unrecorded wages on page 112).
General Journal Page 5
Date Description Post Ref Debit Credit
2011
Aug 01 Wages Payable
Emily Philippe: Choose answers from dropdown list.		 214
Emily Philippe: Choose answers from dropdown list.		 720
Emily Philippe: Enter amounts as positive whole numbers.

Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Choose answers from dropdown list.		 Wages Expense 511 720
To reverse the adjusting entry for accrued wages
1. Record the optional reversing entry on August 1 for Accounts Receivable (see adjustment for design revenue on page 115).
Aug 01 Design Revenue 411 400
Accounts Receivable 113 400
To reverse the adjusting entry for accrued design revenue earned

August Journal Entries

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
2. Record the transactions for August in journal form. Note that, for the August 8 transaction, the instructions should state: "Completed the series of designs that began on July 31 for which $1,400 cash was received in advance on July 19. The accrued revenues were adjusted on July 31st for the $800 of work that wa completed and accepted during July." # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
105
# N-box + B-box corrects COUNTIF(B7:AT41," ")
0
Total SUM(AV13:AV15)
General Journal Page 6 105
Date Description Post Ref Debit Credit
2011 Percentage =AV14/AV16
Aug 01
Emily Philippe: Enter amounts as positive whole numbers.		 0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
Aug 02 If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
Aug 07
Aug 08
Aug 12
Aug 13
Aug 15
Aug 16
Aug 19
Aug 20
Aug 21
Aug 22
Aug 23
Aug 26
Aug 30
Tab Score: 0%
Chapter 4, Comprehensive Problem
2. Record the transactions for August in journal form.
General Journal Page 5
Date Description Post Ref Debit Credit
2011
Aug 01 Cash
Emily Philippe: Choose answers from dropdown list.		 111
Emily Philippe: Choose answers from dropdown list.		 20,000
Emily Philippe: Enter amounts as positive whole numbers.
J. Miller, Capital 311 20,000
Cash investment by J. Miller
Aug 02 Office Equipment 145 4,700
Cash 111 4,700
Purchased office equipment
Aug 07 Office Supplies 115 540
Emily Philippe: Enter amounts as positive whole numbers.
Cash 111 540
Purchased office supplies
Aug 08 Unearned Design Revenue 213 600
Design Revenue 411 600
Billed for design services performed
Aug 12 Accounts Payable 212 3,000
Cash 111 3,000
Paid for office equipment purchased in July
Aug 13 Cash 111 2,400
Emily Philippe: Enter amounts as positive whole numbers.
Unearned Design Revenue 213 2,400
Received advance fee for design services
Aug 15 Cash 111 2,900
Design Revenue 411 2,900
Received cash payment for design services
Aug 16 Cash 111 2,800
Accounts Receivable 113 2,800
Received payment for design services performed last month
Aug 19 Accounts Payable 212 140
Emily Philippe: Enter amounts as positive whole numbers.
Cash 111 140
Paid amount due for utility bill received and recorded in July
Aug 20 Accounts Receivable 113 3,200
Design Revenue 411 3,200
For design services performed for Rave Department Stores
Aug 21 Cash 111 1,160
Design Revenue 411 1,160
Received cash payment for design services
Aug 22 Utilities Expense 512 900
Emily Philippe: Enter amounts as positive whole numbers.

Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Enter amounts as positive whole numbers.
Emily Philippe: Enter amounts as positive whole numbers.
Emily Philippe: Enter amounts as positive whole numbers.		 Cash 111 900
Paid utilities bill for August
Aug 23 Wages Expense 511 4,800
Cash 111 4,800
Paid assistant four weeks' wages
Aug 26 Prepaid Rent 117 1,600
Emily Philippe: Enter amounts as positive whole numbers.

Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Enter amounts as positive whole numbers.
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Choose answers from dropdown list.		 Cash 111 1,600
Paid September rent in advance
Aug 30 J. Miller, Withdrawals 312 2,800
Cash 111 2,800
Withdrawal of cash by J. Miller

General Ledger

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
1, 3, 7 & 8. Post the reversing journal entries, August journal entries, adjusting journal entries, and closing journal entries to the ledger accounts. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
202
# N-box + B-box corrects COUNTIF(B7:AT41," ")
General Ledger 0
Cash Account No. 111 Total SUM(AV13:AV15)
Balance 202
Date Item Post Ref Debit Credit Debit Credit
2011 Percentage =AV14/AV16
Jul 31 J4 2,800 22,480 0%
Aug 01
Emily Philippe: Enter amounts as positive whole numbers.
Emily Philippe: Choose answers from dropdown list.		 Notes:
Aug 02 If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
Aug 07 If number-entry or bland-entry box is incorrect, returns "*"
Aug 12 If number-entry or blank-entry box is correct, returns single space, " "
Aug 13 Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Aug 15 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
Aug 16
Aug 19
Aug 21
Aug 22
Aug 23
Aug 26
Aug 30
Accounts Receivable Account No. 113
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 400 5,000
Aug 01
Emily Philippe: Choose answers from dropdown list.
Aug 16
Aug 20
Aug 31
Office Supplies Account No. 115
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 Beginning Balance P 3,660
Aug 07
Aug 31
Prepaid Rent Account No. 117
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 1,600 1,600
Aug 26
Aug 31
Office Equipment Account No. 145
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 16,320 16,320
Aug 02
Accumulated Depreciation - Office Equipment Account No. 146
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 300 300
Aug 31
.
Accounts Payable Account No. 212
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 Beginning Balance P 6,280
Aug 12
Aug 19
Unearned Design Revenue Account No. 213
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 800 600
Aug 08
Aug 13
Aug 31
Wages Payable Account No. 214
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 J4 720 720
Aug 01
Aug 31
J. Miller, Capital Account No. 311
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Jul 31 Beginning Balance P 41,160
Aug 01
Aug 31
Aug 31
J. Miller, Withdrawals Account No. 312
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 30
Aug 31
Income Summary Account No. 313
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Aug 31
Design Revenue Account No. 411
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 01
Aug 08
Aug 15
Aug 20
Aug 21
Aug 31
Aug 31
Aug 31
Wages Expense Account No. 511
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 01
Aug 23
Aug 31
Aug 31
Utilities Expense Account No. 512
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 22
Aug 31
Rent Expense Account No. 514
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Office Suplies Expense Account No. 517
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Depreciation Expense - Office Equipment Account No. 519
Balance
Date Item Post Ref Debit Credit Debit Credit
2011
Aug 31
Aug 31
Tab Score: 0%

Work Sheet

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
4 & 5. Prepare the work sheet. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
87
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Work Sheet 0
For the Month Ended August 31, 2011 Total SUM(AV13:AV15)
87
Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet
Account Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Percentage =AV14/AV16
Cash 0%
Accounts Receivable
Emily Philippe: For columns F and J, choose answers from dropdown list that correspond with respective adjustment debit and credit amounts.
Emily Philippe: Enter all amounts in the debit and credit columns for each section as positive whole numbers.		 Notes:
Office Supplies If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
Prepaid Rent If number-entry or bland-entry box is incorrect, returns "*"
Office Equipment If number-entry or blank-entry box is correct, returns single space, " "
Accumulated Depreciation - Office Equipment Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Accounts Payable Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
Unearned Design Revenue
J. Miller, Capital
J. Miller, Withdrawals
Design Revenue
Wages Expense
Utilities Expense
Rent Expense
Depreciation Expense - Office Equipment
Wages Payable
Office Supplies Expense
Net Loss
Tab Score: 0%

Income Statement

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
6. From the work sheet, prepare the income statement. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
14
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Income Statement 0
For the Month Ended August 31, 2011 Total SUM(AV13:AV15)
14
Revenues

Emily Philippe: Enter all amounts as positive whole numbers unless otherwise noted.		 Percentage =AV14/AV16
Expenses 0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Total expenses Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
Net Income (Loss)
Emily Philippe: Net loss should be entered as a negative amount.
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Enter expenses in order from largest to smallest using dropdown list.
Tab Score: 0%

Statement of Owner's Equity

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
6. From the general ledger, work sheet, and income statement, prepare the statement of owner's equity. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
12
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Statement of Owner's Equity 0
For the Month Ended August 31, 2011 Total SUM(AV13:AV15)
12
Percentage =AV14/AV16

Emily Philippe: Net loss should be entered as a negative amount.		 0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Tab Score: 0%
Chapter 4, Comprehensive Problem
6. From the work sheet, prepare the income statement.
Miller Design Studio
Statement of Owner's Equity
For the Month Ended August 31, 2011
J. Miller, Capital, August 1, 2011
Emily Philippe: Choose answers from dropdown list, and be sure to order items in format shown in Chapter 3 Exhibit.		 - 0
Emily Philippe: Enter all amounts as positive whole numbers.

Emily Philippe: Choose answers from dropdown list, and be sure to order items in format shown in Chapter 3 Exhibit.
Emily Philippe: Enter all amounts as positive whole numbers unless otherwise noted.
Emily Philippe: Choose answers from dropdown list, and be sure to order items in format shown in Chapter 3 Exhibit.		 Plus Investment by Owner - 0
Net Income (Loss) - 0
Subtotal - 0
Less Withdrawals - 0
J. Miller, Capital, August 31, 2011 - 0

Balance Sheet

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
6. From the work sheet and statement of owner's equity, prepare the balance sheet. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
25
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Balance Sheet 0
August 31, 2011 Total SUM(AV13:AV15)
25
Assets

Emily Philippe: Enter all amounts as positive whole numbers.
Emily Philippe: Choose answers from dropdown list. Enter assets and liabilities in order shown on work sheet.		 Percentage =AV14/AV16
0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Total assets Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
Liabilities
Total liabilities
Owner's Equity
Total owner's equity
Total liabilities and owner's equity
Tab Score: 0%

Adjusting Journal Entries

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
7. From the work sheet, record adjusting entry (a) in journal form. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
42
General Journal Page 7 # N-box + B-box corrects COUNTIF(B7:AT41," ")
Date Description Post Ref Debit Credit 0
2011 Total SUM(AV13:AV15)
Aug 31
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Enter amounts as positive whole numbers.		 42
Percentage =AV14/AV16
0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
7. From the work sheet, record adjusting entry (b) in journal form. If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Aug 31 Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
7. From the work sheet, record adjusting entry (c) in journal form.
Aug 31
7. From the work sheet, record adjusting entry (d) in journal form.
Aug 31
7. From the work sheet, record adjusting entry (e) in journal form.
Aug 31
7. From the work sheet, record adjusting entry (f) in journal form.
Aug 31
Tab Score: 0%

Closing Journal Entries

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
8. From the work sheet, record closing entry for revenue in journal form. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
40
General Journal Page 8 # N-box + B-box corrects COUNTIF(B7:AT41," ")
Date Description Post Ref Debit Credit 0
2011 Total SUM(AV13:AV15)
Aug 31 40
Percentage =AV14/AV16
0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
8. From the work sheet, record closing entry for expenses in journal form. If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Aug 31 Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.

Emily Philippe: Enter expenses in order from largest to smallest using dropdown list.
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Choose answers from dropdown list.
Emily Philippe: Enter amounts as positive whole numbers.		 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.
8. Record closing entry for the income summary account in journal form.
Aug 31
8. From the work sheet, record closing entry for withdrawals in journal form.
Aug 31
Tab Score: 0%

Post-Closing Trial Balance

Chapter 4, Comprehensive Problem # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*")
0
9. From the balance sheet, prepare the post-closing trial balance as of August 31, 2011. # N-box Incorrects due to blanks COUNTIF(B7:AT41," ")
22
Miller Design Studio # N-box + B-box corrects COUNTIF(B7:AT41," ")
Post-Closing Trial Balance 0
August 31, 2011 Total SUM(AV13:AV15)
22
Percentage =AV14/AV16
0%
Notes:
If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or bland-entry box is incorrect, returns "*"
If number-entry or blank-entry box is correct, returns single space, " "
Use data verification to set data entry to whole number >=0, and use dropdowns for labels and names so that students can't enter a space in a box and have it counted as correct.
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1="~*", then font=red, if something else, then font=background color.

Emily Philippe: Enter total debits.
Emily Philippe: Enter answers from dropdown list. List accounts in order shown on balance sheet.
Emily Philippe: Enter total debits.
Emily Philippe: Enter amounts as positive whole numbers.
Tab Score: 0%