Week 4: Bank Reconciliation and Journal Entries

Due by the end of Week 4 at 11:59 pm, ET.

The bank statement came in the mail, and you have consolidated the important information below. Please complete a bank reconciliation.Be sure to do the appropriate journal entry and required posting using the excel templates provided.

Bank balance	4417
Checkbook balance	1578
Outstanding deposits	3313
Outstanding checks	6202
Service Charge	50

Week 5: Adjusting Entries & Adjusted Trial Balance

Due by the end of Week 5 at 11:59 pm, ET.

Its the end of the month, and you have gathered the required information needed to adjust your records to get them up to date. You are to adjust the entries in the journal and ledgers, post to the appropriate accounts, and check your work with the adjusted trial balance. Continue to use the excel templates provided.

May 31

Supplies used $400.

Unexpired insurance at the end of the period was $1,100.

Depreciation for the period was $200.

Accrued salaries were $300.

Week 6: Financial Statements Creation and Analysis

Due by the end of Week 6 at 11:59 pm, ET.

Once you have completed and checked your work, your employer asked you to create Financial Statements. Be sure to do the Income Statement, Statement of Owners Equity, and Balance Sheet for the company. Make sure you do each Financial Statement in good form, including the appropriate Title Information for each statement. Once you have ensured your Adjusted Trial Balance is correct, you are all set to proceed to the Financial Statements. Continue to use the excel templates provided. Use the lecture, assignments, and resources as a reference.

Week 7: Closing Entries and Post-Closing Trial Balance and Final Submission to ePortfolio

Due by the end of Week 7 at 11:59 pm, ET.

It is the final step in the accounting cycle. You are at the end of the month, and you have to reset the temporary accounts prior to the new period starting. You have to do the closing entries in order to do this. Please close the appropriate accounts using the journal and ledgers again. Make sure to do a post-closing trial balance to ensure you are still in balance after the closing is done. Continue to use the excel templates provided. Be sure to double check that all temporary accounts are properly closed and not reflected on the post-closing