ScenarioYou are a certified public accountant (CPA) who is working with a small bakery
ScenarioYou 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.
PromptAccrual 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.
Guidelines for SubmissionBuild on your work from Milestone One to complete the “Trial Balance” and “Adjusting
Entries” tabs in your company accounting workbook. This should be completed and
submitted using Microsoft Excel. Please note that there are drop-down menus embedded
in the “Accounts” columns as well as formulas throughout the spreadsheet to help you
complete the workbook without accidentally introducing errors.