Excel in accounting cycle problem-solving. Record debits, credits, and journal entries effortlessly with preformatted Excel worksheets. Read more.
Robert (Bob) Steele CPA, CGMA, M.S. Tax, CPI
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Accountants
- Bookkeepers
What you’ll learn:Â
- Enter accounting transaction
- Enter journal entries into a general journal
- Post journal entries to a 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 partners’ equity
- Navigate an Excel worksheet
- Enter standard Excel formulas
Requirements:Â
- Fundamental knowledge of accounting principles
In the full accounting cycle problem using Excel course, we will enter journal entries into the general journal related to setting up a partnership 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 worksheet 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 form 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 is 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 partners’ 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 to use Excel for accounting Cycle Problem.
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 Corporation Accounting Cycle Problem Overview | 00:00:00 | ||
| Downloadable Materials | 00:00:00 | ||
| Section 2 - Financial Transactions | |||
| 10 Corporation Comp Prob Introduction | 00:00:00 | ||
| 20 Corporation Comp Prob Stock Purchase | 00:00:00 | ||
| 30 Corporation Comp Prob Equipment Purchase | 00:00:00 | ||
| 40 Corporation Comp Prob Supplies Purchase | 00:00:00 | ||
| 50 Corporation Comp Prob Revenue on Account | 00:00:00 | ||
| 60 Corporation Comp Prob Customer Payment Unearned Revenue | 00:00:00 | ||
| 70 Corporation Comp Prob Purchase Insurance | 00:00:00 | ||
| 80 Corporation Comp Prob Unhide And Hide Pains | 00:00:00 | ||
| 90 Corporation Comp Prob Pay Vendor One Account | 00:00:00 | ||
| 100 Corporation Comp Prob Receive Cash on Account | 00:00:00 | ||
| 110 Corporation Comp Prob Revenue for Cash | 00:00:00 | ||
| 120 Corporation Comp Prob Pay Expenses | 00:00:00 | ||
| 130 Corporation Comp Prob Dividends | 00:00:00 | ||
| Section 3 - Adjusting Entries | |||
| 140 Corporation Comp Prob Adj Entry Insurance | 00:00:00 | ||
| 150 Corporation Comp Prob Adj Entry Supplies | 00:00:00 | ||
| 160 Corporation Comp Prob Adj Entry Depreciation | 00:00:00 | ||
| 170 Corporation Comp Prob Adj Entry Wages | 00:00:00 | ||
| 180 Corporation Comp Prob Adj Entry Unearned Revenue | 00:00:00 | ||
| Section 4 - Financial Statements | |||
| 190 Corporation Comp Prob Financial Statements Assets | 00:00:00 | ||
| 200 Corporation Comp Prob Liability & Equity· | 00:00:00 | ||
| 210 Corporation Comp Prob Net Income | 00:00:00 | ||
| 220 Corporation Comp Prob Statement of Equity | 00:00:00 | ||
| Section 5 - Closing Entries | |||
| 230 Corporation Comp Closing Entry One | 00:00:00 | ||
| 240 Corporation Comp Closing Entry Two | 00:00:00 | ||
| 250 Corporation Comp Closing Entry Three | 00:00:00 | ||
| 260 Corporation Comp Closing Entry Four | 00:00:00 | ||
About This Course
Who this course is for:
- Accountants
- Bookkeepers
What you’ll learn:Â
- Enter accounting transaction
- Enter journal entries into a general journal
- Post journal entries to a 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 partners’ equity
- Navigate an Excel worksheet
- Enter standard Excel formulas
Requirements:Â
- Fundamental knowledge of accounting principles
In the full accounting cycle problem using Excel course, we will enter journal entries into the general journal related to setting up a partnership 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 worksheet 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 form 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 is 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 partners’ 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 to use Excel for accounting Cycle Problem.
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 Corporation Accounting Cycle Problem Overview | 00:00:00 | ||
| Downloadable Materials | 00:00:00 | ||
| Section 2 - Financial Transactions | |||
| 10 Corporation Comp Prob Introduction | 00:00:00 | ||
| 20 Corporation Comp Prob Stock Purchase | 00:00:00 | ||
| 30 Corporation Comp Prob Equipment Purchase | 00:00:00 | ||
| 40 Corporation Comp Prob Supplies Purchase | 00:00:00 | ||
| 50 Corporation Comp Prob Revenue on Account | 00:00:00 | ||
| 60 Corporation Comp Prob Customer Payment Unearned Revenue | 00:00:00 | ||
| 70 Corporation Comp Prob Purchase Insurance | 00:00:00 | ||
| 80 Corporation Comp Prob Unhide And Hide Pains | 00:00:00 | ||
| 90 Corporation Comp Prob Pay Vendor One Account | 00:00:00 | ||
| 100 Corporation Comp Prob Receive Cash on Account | 00:00:00 | ||
| 110 Corporation Comp Prob Revenue for Cash | 00:00:00 | ||
| 120 Corporation Comp Prob Pay Expenses | 00:00:00 | ||
| 130 Corporation Comp Prob Dividends | 00:00:00 | ||
| Section 3 - Adjusting Entries | |||
| 140 Corporation Comp Prob Adj Entry Insurance | 00:00:00 | ||
| 150 Corporation Comp Prob Adj Entry Supplies | 00:00:00 | ||
| 160 Corporation Comp Prob Adj Entry Depreciation | 00:00:00 | ||
| 170 Corporation Comp Prob Adj Entry Wages | 00:00:00 | ||
| 180 Corporation Comp Prob Adj Entry Unearned Revenue | 00:00:00 | ||
| Section 4 - Financial Statements | |||
| 190 Corporation Comp Prob Financial Statements Assets | 00:00:00 | ||
| 200 Corporation Comp Prob Liability & Equity· | 00:00:00 | ||
| 210 Corporation Comp Prob Net Income | 00:00:00 | ||
| 220 Corporation Comp Prob Statement of Equity | 00:00:00 | ||
| Section 5 - Closing Entries | |||
| 230 Corporation Comp Closing Entry One | 00:00:00 | ||
| 240 Corporation Comp Closing Entry Two | 00:00:00 | ||
| 250 Corporation Comp Closing Entry Three | 00:00:00 | ||
| 260 Corporation Comp Closing Entry Four | 00:00:00 | ||
Course Review
4.5
2 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Fresh
Enjoyed learning a new perspective on the accounting cycle using Excel spreadsheets. Robert did an awesome job explaining each section in a concise manner.
Excellent Beginnner Course and/or Refresher Course for the Accounting Cycle
Good Refresher on the entire Accounting Cycle. Appreciated the thorough explanations for each transaction. Definitely would recommend for a beginner or someone looking for a brush up on the accounting cycle.