ACCT010 Excel Project Complete Accounting Cycle | Browse Homework

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 memorandum—usually known as a memo—is 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
Formulated and linked cells in Excel
20 ptsFull Marks
All cells are formulated and linked to the source of their data.
0 ptsNo Marks
No or partially formulated/lnked cells
20 pts
Correct Journal Entries
20 ptsFull Marks
Correct daily transactions’ Journal Entries with proper Debit and Credit posted to the General ledger. The General ledger data should be linked to the Journal Entries.
0 ptsNo Marks
All or partially wrong daily transactions’ Journal Entries with improper Debit and Credit
20 pts
Worksheet Correct, balanced, and linked worksheet with Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, and Balance Sheet
30 ptsFull Marks
Worksheet requirements are met.
0 ptsNo Marks
The worksheet is not linked properly, partially completed, or balanced.
30 pts
Financial Statements Income Statement, Statement of Retained Earnings, and Balance Sheet
40 ptsFull Marks
Income Statement, Statement of Retained Earnings, and Balance Sheet are prepared correctly and properly.
0 ptsNo Marks
Partially and incorrect Income Statement, Statement of Retained Earnings, and Balance Sheet
40 pts
MemorandumA proper formatted one-page memorandum.
30 ptsFull Marks
A proper formatted, meaningful one-page memorandum with Introduction, Body Paragraph, and Conclusion.
0 ptsNo Marks
A poorly formatted, not meaningful memorandum with hardly separated Introduction, Body Paragraph, and Conclusion.
30 pts
Bank Reconciliation Proper Bank Reconciliation with correct adjusting journal entries.
20 ptsFull Marks
Proper Bank Reconciliation with correct adjusting journal entries that are posted to General Ledger before preparing the Worksheet.
0 ptsNo Marks
Partial or no Bank Reconciliation with no or wrong adjusting journal entries that are not posted to General Ledger before preparing the Worksheet.
20 pts
Adjusting Journal Entries.Proper Adjusting Journal Entries that are posted to the General ledger linked to the original journal entries.
20 ptsFull Marks
Proper Adjusting Journal Entries that are posted to the General ledger linked to the original journal entries.
0 ptsNo Marks
Partial or wrong Adjusting Journal Entries that are posted to the General ledger without linked to the original journal entries.
20 pts
Closing Journal Entries End of the period proper Closing Journal Entries that are posted to the General ledger linked to the original journal entries.
20 ptsFull Marks
End of the period proper Closing Journal Entries that are posted to the General ledger linked to the original journal entries.
0 ptsNo Marks
20 pts
Total Points: 200