A Complete Accounting Cycle Excel Project

Electronic spreadsheets are a fact of life for all business professionals. It is essential that you learn how to use Excel to present accounting information. Excel is the most powerful tool used by accountants today. The more you learn about how it works, the more marketable your skills will be in the job market.

To receive full credit, you must build the spreadsheet using the Excel template provided in the "Files" section.

As a group of four or five, you will complete a Problem as your project on a multi-page, formulated, interconnected Excel sheet including the following tabs:

General Journal Tab General Ledger - Asset Tab General Ledger - Liability Tab General Ledger - Equity Tab Worksheet Tab Income statement and Stock Holders Equity Tab Classified Balance Sheet Tab Post-Closing Trial Balance Tab The Excel project of Group X Consulting Inc. must be submitted with a Business Memorandum.

A memorandumusually known as a memois a document that is most commonly used for internal communication between coworkers or members of a department. In our case, the Board of Directors is concerned about this year's profitability. Each issue in a memorandum needs one paragraph plus you should start with one introduction at the beginning and finish with one conclusion at the end of the memorandum. You do not write unnecessary information in the memorandum. You should write only about the requested issues. You need to write a memo to the board of directors about their concerns based on your prepared financial reports.

Bank Statement.pdf

Service invoice July 20.docx

Service invoice July 12.pdf

Service invoice July 31.pdf

Stock certificate.pdf

Project-Student template.xlsx

The important issue to be followed. All cells are formulated and linked to the source of their data. Please refer to the Rubric for more details on the grading and requirements of this project. Invoice #006 is correct: 40 hours @ $150.00 is $6000.00 plus some additional charge = $6600.00