This course is designed for those interested to learn the basics of accounting cycle problem using preformatted Excel worksheets to enter normal financial transaction for a month of operations, recording debits and credits, or journalizing the financial transactions in the general journal, so that we can jump forward or go back and rework any component of the comprehensive problem. Read more.
Robert (Bob) Steele CPA, CGMA, M.S. Tax, CPI
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
About This Course
Who this course is for:
- AccountantsÂ
- Bookkeepers
- Business owners
What you’ll learn:Â
- Enter accounting transaction
- Enter journal entries into a general journal
- Post journal entries to the general ledger
- Create a trial balance from a general ledger
- Enter adjusting entries
- Create an adjusted trial balance
- Create financial statements from the trial balance
- Build a balance sheet
- Build an income statement
- Build a statement of owners’ equity
- Navigate an Excel worksheet
- Enter standard Excel formulas
Requirements:Â
- No prior knowledge is required to take this courseÂ
This course covers full accounting cycle comprehensive proprietorship problems where we will enter journal entries into the general journal related to setting up a proprietorship and to the first month of operations.Â
We will enter the normal financial transaction for a month of operations, recording debits and credits, or journalizing the financial transactions in the general journal. We will perform these tasks using preformatted Excel worksheets. Even though this is a comprehensive problem, each new step will have a new Excel worksheet so that we can jump forward or go back and rework any component of the comprehensive problem.
Each new step in the process will include an Excel worksheet with at least two tabs, one demonstrating the completed task, and one with a preformatted worksheets to complete the task in a step by step format with instructional videos. Once we have journalized the journal entries, we will post them to the general ledger and then create a trial balance from the general ledger.
After completing the accounting transactions for the month, we will enter adjusting journal entries for the month, using an adjusting entry worksheet, the result being an adjusted trial balance. We will use the adjusted trial balance to create the financial statements, to create the balance sheet, income statement, and statement of owners’ equity.
Finally, we will enter the closing entries to prepare for the next accounting period, the next month of operations.
Our Promise to You
By the end of this course, you will have learned the accounting cycle for a sole proprietorship with the use of Excel.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.Â
Get started today and learn more about the accounting cycle problem using Excel.
Course Curriculum
| Section 1 - Introduction | |||
| Excel Sole Proprietorship Accounting Cycle Problem Overview | 00:00:00 | ||
| Downloadable Materials - Accounting Cycle Problem For A Sole Proprietorship Using Excel | 00:00:00 | ||
| Section 2 - Financial Transactions | |||
| Introduction | 00:00:00 | ||
| Stock Purchase | 00:00:00 | ||
| Equipment Purchase | 00:00:00 | ||
| Supplies Purchase | 00:00:00 | ||
| Revenue On Account | 00:00:00 | ||
| Customer Payment Unearned Revenue | 00:00:00 | ||
| Purchase Insurance | 00:00:00 | ||
| Unhide and Hide Pains | 00:00:00 | ||
| Pay Vendor One Account | 00:00:00 | ||
| Receive Cash On Account | 00:00:00 | ||
| Revenue For Cash | 00:00:00 | ||
| Pay Expenses | 00:00:00 | ||
| Draws | 00:00:00 | ||
| Section 3 - Adjusting Entries | |||
| Insurance | 00:00:00 | ||
| Supplies | 00:00:00 | ||
| Depreciation | 00:00:00 | ||
| Wages | 00:00:00 | ||
| Section 4 - Financial Statements | |||
| Assets | 00:00:00 | ||
| Liability And Equity | 00:00:00 | ||
| Equity | 00:00:00 | ||
| Net Income | 00:00:00 | ||
| Statement Of Equity | 00:00:00 | ||
| Section 5 - Closing Entries | |||
| Closing Entry One | 00:00:00 | ||
| Closing Entry Two | 00:00:00 | ||
| Closing Entry Three | 00:00:00 | ||
| Closing Entry Four | 00:00:00 | ||
About This Course
Who this course is for:
- AccountantsÂ
- Bookkeepers
- Business owners
What you’ll learn:Â
- Enter accounting transaction
- Enter journal entries into a general journal
- Post journal entries to the general ledger
- Create a trial balance from a general ledger
- Enter adjusting entries
- Create an adjusted trial balance
- Create financial statements from the trial balance
- Build a balance sheet
- Build an income statement
- Build a statement of owners’ equity
- Navigate an Excel worksheet
- Enter standard Excel formulas
Requirements:Â
- No prior knowledge is required to take this courseÂ
This course covers full accounting cycle comprehensive proprietorship problems where we will enter journal entries into the general journal related to setting up a proprietorship and to the first month of operations.Â
We will enter the normal financial transaction for a month of operations, recording debits and credits, or journalizing the financial transactions in the general journal. We will perform these tasks using preformatted Excel worksheets. Even though this is a comprehensive problem, each new step will have a new Excel worksheet so that we can jump forward or go back and rework any component of the comprehensive problem.
Each new step in the process will include an Excel worksheet with at least two tabs, one demonstrating the completed task, and one with a preformatted worksheets to complete the task in a step by step format with instructional videos. Once we have journalized the journal entries, we will post them to the general ledger and then create a trial balance from the general ledger.
After completing the accounting transactions for the month, we will enter adjusting journal entries for the month, using an adjusting entry worksheet, the result being an adjusted trial balance. We will use the adjusted trial balance to create the financial statements, to create the balance sheet, income statement, and statement of owners’ equity.
Finally, we will enter the closing entries to prepare for the next accounting period, the next month of operations.
Our Promise to You
By the end of this course, you will have learned the accounting cycle for a sole proprietorship with the use of Excel.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.Â
Get started today and learn more about the accounting cycle problem using Excel.
Course Curriculum
| Section 1 - Introduction | |||
| Excel Sole Proprietorship Accounting Cycle Problem Overview | 00:00:00 | ||
| Downloadable Materials - Accounting Cycle Problem For A Sole Proprietorship Using Excel | 00:00:00 | ||
| Section 2 - Financial Transactions | |||
| Introduction | 00:00:00 | ||
| Stock Purchase | 00:00:00 | ||
| Equipment Purchase | 00:00:00 | ||
| Supplies Purchase | 00:00:00 | ||
| Revenue On Account | 00:00:00 | ||
| Customer Payment Unearned Revenue | 00:00:00 | ||
| Purchase Insurance | 00:00:00 | ||
| Unhide and Hide Pains | 00:00:00 | ||
| Pay Vendor One Account | 00:00:00 | ||
| Receive Cash On Account | 00:00:00 | ||
| Revenue For Cash | 00:00:00 | ||
| Pay Expenses | 00:00:00 | ||
| Draws | 00:00:00 | ||
| Section 3 - Adjusting Entries | |||
| Insurance | 00:00:00 | ||
| Supplies | 00:00:00 | ||
| Depreciation | 00:00:00 | ||
| Wages | 00:00:00 | ||
| Section 4 - Financial Statements | |||
| Assets | 00:00:00 | ||
| Liability And Equity | 00:00:00 | ||
| Equity | 00:00:00 | ||
| Net Income | 00:00:00 | ||
| Statement Of Equity | 00:00:00 | ||
| Section 5 - Closing Entries | |||
| Closing Entry One | 00:00:00 | ||
| Closing Entry Two | 00:00:00 | ||
| Closing Entry Three | 00:00:00 | ||
| Closing Entry Four | 00:00:00 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved