I am working on the statement of retained earnings as well as the balance sheet--what am I doing wrong with the retained earnings statement and what order should I post things on the balance sheet

Note: this workbook contains macros. If prompted above, please enable this function. Enter your first and last name: Jayme Lohr Begin! Random Number Gen. $ Dollar Modifier $ 339,002.00 53,345.00 e, please enable this function. Begin! Hampton Accounting Service Inc. Chart of Accounts Note: This chart of accounts is complete for every account you will need for this assignment. Acct # n/a 100 110 115 120 130 150 151 155 156 160 161 200 210 215 220 300 305 310 400 410 500 510 520 530 540 550 560 570 Description [enter here] Cash Accounts Receivable Allowance for Unc. Accounts Supplies Inventory Building Accumulated Depreciation- Building Furnishings Accumulated Depreciation- Furnishings Office Equipment Accumulated Depreciation- Off. Equip. Accounts Payable Unearned Service Revenue Salary Payable Dividends Payable Common Stock, $1 par value Additional Paid in Capital Retained Earnings Service Revenue Sales Revenue Advertising Expense Depreciation Expense Repairs & Maintenance Expense Supplies Expense Uncollectible Accounts Expense Utilities Expense Cost of Goods Sold Salary Expense Hampton Accounting Service Inc. Journal NOTE: Do not proceed until this page has no errors. Errors will be carried through the rest of the assignment, so you will receive a poor score. Hint: It will be much easier to post these to the Ledger if you use the "Filter" function below is a link to a video showing how to use filters in case you are un-familiar with it. Excel 2013: Filtering Data Date Accounts and Explanation December 2, 2013 Inventory Accounts Payable December 2, 2013 Salary Payable Cash December 2, 2013 Accounts Receivable Service Revenue December 5, 2013 Office Equipment Accounts Payable December 8, 2013 Supplies Cash December 10, 2013 Cash Accounts Receivable December 11, 2013 Accounts Receivable Sales Revenue December 11, 2013 Cost of Goods Sold Inventory December 11, 2013 Accounts Payable Cash December 12, 2103 Inventory Accounts Payable December 14, 2013 Advertising Expense Post Ref. 130 200 Debit 1,300.00 215 100 2,500.00 110 400 3,200.00 160 200 4,800.00 120 100 800.00 100 110 3,000.00 110 410 4,500.00 560 130 2,000.00 200 100 1,000.00 130 200 2,400.00 500 250.00 December 14, 2013 Cash December 15, 2013 Cash Service Revenue December 16, 2013 Salary Expense Cash December 17, 2013 Accounts Receivable Service Revenue December 19, 2013 Accounts Receivable Sales Revenue December 19, 2013 Cost of Goods Sold Inventory December 22, 2013 Cash Accounts Receivable December 23, 2013 Accounts Payable Cash December 24, 2013 Utilities Expense Cash December 27, 2013 Cash Unearned Service Revenue December 29, 2013 Cash Service Revenue December 30, 2013 Cash Common Stock, $1 par value Additional Paid in Capital December 31, 2013 Retained Earnings Dividends Payable 100 100 400 8,000.00 570 100 2,500.00 110 400 6,000.00 110 410 3,000.00 560 130 1,200.00 100 110 2,500.00 200 100 2,500.00 550 100 850.00 100 210 2,000.00 100 400 5,000.00 100 300 305 310 220 15,000.00 570 215 2,500.00 31,500.00 The following adjustments SHOULD NOT be posted to the Ledger; instead, they should be posted directly to the Trial Balance Adj Salary Expense Salary Payable Depreciation Expense Accumulated Depreciation- Building 510 151 6,500.00 Adj 510 156 12,000.00 Adj Depreciation Expense Accumulated Depreciation- Furnishings 510 161 200.00 Adj Depreciation Expense Accumulated Depreciation- Off. Equip. Supplies Expense Supplies 530 120 1,175.00 Adj Cost of Goods Sold Inventory 560 130 240.00 Adj 210 400 500.00 Adj Unearned Service Revenue Service Revenue Uncollectible Accounts Expense Allowance for Unc. Accounts 540 115 167.00 Adj arried through the e "Filter" function un-familiar with it. Credit Correct 1,300.00 Correct Correct 2,500.00 Correct Correct 3,200.00 Correct Correct 4,800.00 Correct Correct 800.00 Correct Correct 3,000.00 Correct Correct 4,500.00 Correct Correct 2,000.00 Correct Correct 1,000.00 Correct Correct 2,400.00 Correct Correct 250.00 Correct Correct 8,000.00 Correct Correct 2,500.00 Correct Correct 6,000.00 Correct Correct 3,000.00 Correct Correct 1,200.00 Correct Correct 2,500.00 Correct Correct 2,500.00 Correct Correct 850.00 Correct Correct 2,000.00 Correct Correct 5,000.00 Correct Correct 1,000.00 Correct 14,000.00 Correct Correct 31,500.00 Correct Correct 2,500.00 Correct Correct 6,500.00 Correct Correct 12,000.00 Correct Correct 200.00 Correct Correct 1,175.00 Correct Correct 240.00 Correct Correct 500.00 Correct Correct 167.00 Correct Hampton Accounting Service Ledger Page 12 of 30 Hampton Accounting Service Inc. Ledger NOTE: The table will be shaded blue when you have the correct balance. NOTE: Do not post adjusting entries here. You should post these directly on the "Trial Open Bal $ $ $ $ $ $ $ 100 - Cash 139,579.00 $ 3,000.00 $ 8,000.00 $ 2,500.00 $ 2,000.00 $ 5,000.00 $ 15,000.00 $ Bal $ 164,679.00 Open Bal 115 - Allowance for Uncollect Acct $ 900.00 Bal $ 2,500.00 800.00 1,000.00 250.00 2,500.00 2,500.00 850.00 900.00 Open Bal $ $ $ 130 - Inventory 4,200.00 $ 2,000.00 1,300.00 $ 1,200.00 2,400.00 Bal $ 4,700.00 Open Bal $ $ $ $ $ Bal $ 21,200.00 Open Bal $ $ 120 - Supplies 2,000.00 800.00 Bal $ 2,800.00 Open Bal $ 150 - Building 140,000.00 Bal $ 140,000.00 151 - Accum Depre Building Open Bal 110 - Accounts Receivable 10,000.00 3,200.00 4,500.00 6,000.00 3,000.00 Open Bal $ 155 - Furnishings 30,000.00 Hampton Accounting Service Ledger Page 13 of 30 Bal $ - Bal $ Open Bal $ Bal $ 156 - Accum Depre Furnishings Open Bal Bal $ - 30,000.00 160 - Office Equipment 4,800.00 4,800.00 Hampton Accounting Service Ledger Page 14 of 30 161 - Accum Depre Office Equip Open Bal Bal Open Bal Bal Open Bal Bal Open Bal Bal Open Bal Bal Open Bal $ - 210- Unearned Ser. Rev. $ 2,000.00 $ 2,000.00 220- Dividends Payable $ 31,500.00 $ 31,500.00 305- Additional Paid In Capital $ 233,345.00 $ 14,000.00 $ 247,345.00 400 - Service Revenue $ 102,500.00 $ 3,200.00 $ 8,000.00 $ 6,000.00 $ 5,000.00 $ 124,700.00 $ $ 200 - A/P 1,000.00 2,500.00 $ 215 - Salary Payable 2,500.00 Bal Open Bal Bal 300- Stock, Common Open Bal Bal Open Bal $ 310- Retained Earnings 31,500.00 Bal 410 - Sales Revenue Open Bal Bal Hampton Accounting Service Ledger Page 15 of 30 Open Bal $ $ Bal $ Open Bal $ Bal $ 500 - Advertising Expense 7,589.00 250.00 7,839.00 520 - Repairs & Maint Expense 10,567.00 10,567.00 510 - Depreciation Expense Open Bal Bal $ Open Bal $ Bal $ Open Bal 540 - Uncollectible Accts Expense $ 900.00 Open Bal $ $ Bal $ Bal $ Open Bal $ $ $ Bal $ 900.00 560 - Cost of Goods Sold 7,700.00 2,000.00 1,200.00 10,900.00 530 - Supplies Expense 3,560.00 3,560.00 550 - Utilities Expense 5,650.00 850.00 6,500.00 Open Bal $ $ 570 - Salary Expense 55,000.00 2,500.00 Bal $ 57,500.00 Hampton Accounting Service Ledger Page 16 of 30 irectly on the "Trial Balance" sheet 10 - Accounts Receivable $ 3,000.00 $ 2,500.00 120 - Supplies 150 - Building 155 - Furnishings 160 - Office Equipment Hampton Accounting Service Ledger Page 17 of 30 Hampton Accounting Service Ledger Page 18 of 30 200 - A/P $ $ $ $ $ 1,000.00 1,300.00 4,800.00 2,400.00 6,000.00 215 - Salary Payable $ 2,500.00 $ - 300- Stock, Common $ 20,000.00 $ 1,000.00 $ 21,000.00 310- Retained Earnings $ 40,000.00 $ 8,500.00 410 - Sales Revenue $ 16,500.00 $ 4,500.00 $ 3,000.00 $ 24,000.00 Hampton Accounting Service Ledger Page 19 of 30 0 - Depreciation Expense 530 - Supplies Expense 550 - Utilities Expense 570 - Salary Expense Hampton Accounting Service Inc. Trial Balance Cash Accounts Receivable Allowance for Unc. Accounts Supplies Inventory Building Accumulated Depreciation- Building Furnishing Accumulated Depreciation- Furnishings Office Equipment Accumulated Depreciation- Off. Equip. Accounts Payable Unearned Service Revenue Salary Payable Dividends Payable Stock, Common Additonal Paid in Capital Retained Earnings Service Revenue Sales Revenue Advertising Expense Depreciation Expense Repairs & Maintenance Expense Supplies Expense Uncollectible Accounts Expense Utilities Expense Cost of Goods Sold Salary Expense Total Unadjusted Trial Balance Debit Credit $ 164,679.00 $ $ 21,200.00 $ 900.00 $ 2,800.00 $ 4,700.00 $ 140,000.00 $ $ 30,000.00 $ $ 4,800.00 $ $ 6,000.00 $ 2,000.00 $ $ 31,500.00 $ 21,000.00 $ 247,345.00 $ 8,500.00 $ 124,700.00 $ 24,000.00 $ 7,839.00 $ - $ $ 10,567.00 $ 3,560.00 $ 900.00 $ 6,500.00 $ 10,900.00 $ 57,500.00 $ 465,945.00 $ 465,945.00 Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Adjustments Debit Credit $ - $ $ $ - $ 167.00 $ - $ 1,175.00 $ - $ 240.00 $ $ 6,500.00 $ $ 12,000.00 $ $ 200.00 $ $ 500.00 $ $ 2,500.00 $ $ $ $ $ 500.00 $ $ $ 18,700.00 $ $ 1,175.00 $ 167.00 $ $ 240.00 $ 2,500.00 $ 23,282.00 $ 23,282.00 Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Correct Adjusted Trial Balance* Debit Credit $ 164,679.00 $ 21,200.00 $ 1,067.00 $ 1,625.00 $ 4,460.00 $ 140,000.00 $ 6,500.00 $ 30,000.00 $ 12,000.00 $ 4,800.00 $ 200.00 $ 6,000.00 $ 1,500.00 $ 2,500.00 $ 31,500.00 $ 21,000.00 $ 247,345.00 $ 8,500.00 $ 125,200.00 $ 24,000.00 $ 7,839.00 $ 18,700.00 $ 10,567.00 $ 4,735.00 $ 1,067.00 $ 6,500.00 $ 11,140.00 $ 60,000.00 $ 487,312.00 $ 487,312.00 *Project requirements #4 are posted directly here. Hampton Accounting Service Inc. Income Statement For the Year Ending December 31, 2013 Service Revenue Sales Revenue Net Revenue Cost of Goods Sold Gross Profit Operating Expenses Advertising Expense Depreciation Expense Repairs & Maintenance Supplies Expense Uncollectible Accts Expense Utilities Expense Salary Expense Total Operating Expense Net Income $ $ $ $ $ $ $ $ $ 125,200.00 24,000.00 $ $ $ 149,200.00 11,140.00 138,060.00 $ $ 109,408.00 28,652.00 Correct 7,839.00 18,700.00 10,567.00 4,735.00 1,067.00 6,500.00 60,000.00 Hampton Accounting Service Inc. Statement of Retained Earnings For the Year Ending December 31, 2013 Retained Earnings, January 1 Add: Net Income Less: Dividends Retained Earnings, December 31 $ $ $ $ 28,652.00 28,652.00 31,500.00 (2,848.00) Incorrect amount Hampton Accounting Service Inc. Balance Sheet Hint: List the accounts in the Balance Sheet in the same order as in the Chart of Accounts Hint: If the number is going to be modified, it should first appear in the left column (Column C). If is NOT going to be modified, it should appear in the center column (Column D). Totals will appear far right coumn (Column E). December 31, 2013 Assets Current: Cash Accounts Receivable Less: Repairs & Maintenance Expense Advertising Expense Cost of Goods Sold Total Current Assets $ 164,679.00 $ 21,200.00 $ $ $ 21,200.00 7,839.00 11,140.00 Long- Term: Cash Less: Accounts Receivable Inventory [enter here] [enter here] [enter here] Total Long- term Assets Total Assets Liabilities Current: [enter here] [enter here] [enter here] [enter here] Total Current Liabilities Stockholders Equity [enter here] [enter here] [enter here] Total Liabilities & Stockholders Equity $ 164,679.00 $ 164,679.00 $ - $ - Total Assets should equal Total Liabilities + Stockholders Equity of Accounts olumn (Column C). If it D). Totals will appear in $ 204,858.00 $ $ 164,679.00 369,537.00 Incorrect amount $ - $ - Instuctor Interface Instructor View Student View