In Milestone One, you completed the first part of your course project to demonstrate your ability to accurately record financial data. In Milestone Two, you will use your journal entries from Milestone One to continue working through the next stages of the accounting cycle in preparation for creating financial statements in Module Seven.

Scenario

You are a certified public accountant (CPA) who is working with a small bakery to prepare their financial statements for three months of the current fiscal year. Because the company is a startup and so small, the accounting is done manually in Microsoft Excel. You have been given the accounts and information you need to prepare their financial statements, but you will need to use the accounting cycle to report accurate information to the finance department.

Prompt

Accrual Basis: In your company accounting workbook, apply the accrual basis of accounting and prepare adjusting entries to ensure accurate accounting for expenses that lack transactions in the current period. (You may refer to the Company Accounting Workbook Template Spreadsheet if necessary, but keep in mind that your work for this milestone should be added to the work you completed in your workbook for the previous milestone.)

Specifically, you must address the following rubric criteria:

Unadjusted Trial Balance: Prepare the unadjusted trial balance portion of the “Trial Balance” tab of the company accounting workbook, ensuring that the total debits and credits match.

Adjusting Entries: Prepare the “Adjusting Entries” tab of the company accounting workbook. Ensure that the entries are correctly transferred to the adjusting entries portion of the “Trial Balance” tab.

Adjusted Trial Balance: Prepare the adjusted trial balance on the “Trial Balance” tab, ensuring that the debit and credit totals match.

Please tell me what I am missing, I have gone through these numbers multiple times and need another set of eyes... Thanks in advance!

 

Account Cash Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Baking Equipment Accumulated Depreciation Office Supplies Accounts Receivable Notes Payable Interest Payable Accounts Payable Wages Payable Common Stock Dividends Bakery Sales Merchandise Sales Baking Supplies Expense Rent Expense Interest Expense Insurance Expense Depreciation Expense Misc. Expense Office Supplies Expense Business License Expense Advertising Expense Wages Expense Telephone Expense COGS Total: A Company Trial Balance 20xx Unadjusted trial balance Debit Credit 54,436.75 20,500.00 237.25 1,500.00 1,200.00 5,000.00 600.00 9,700.00 10,000.00 4,500.00 250.00 375.00 200.00 1,956.00 150.00 96.00 10,000.00 7,000.00 480.00 30,000.00 60,000.00 221.00 110,701.00 107,701.00 Adjusting entries Debit 19,400.00 150.00 200.00 208.33 550.00 Credit 19,400.00 200.00 208.33 550.00 150.00 20,508.33 20,508.33 Adjusted trial balance Debit 54,436.75 1,100.00 237.25 1,500.00 1,000.00 5,000.00 50.00 9,700.00 10,000.00 19,400.00 4,500.00 150.00 200.00 208.33 250.00 550.00 375.00 200.00 1,956.00 150.00 96.00 Credit 208.33 10,000.00 150.00 7,000.00 480.00 30,000.00 60,000.00 221.00 111,059.33 108,059.33