
Explore adjusting entries through hands-on Excel problems, covering supplies, unearned revenue, payroll payable, prepaid insurance, depreciation, and the path from adjusted trial balance to financial statements with reversing entries.
Perform end-of-period adjusting entries to achieve accrual-basis statements, using the unadjusted trial balance to adjust supplies and unearned revenue with one balance sheet and one income statement account.
Explore adjusting entries for earned revenue and payroll, using debits and credits to reflect earned amounts and wages payable, and understand accrual vs cash basis effects on net income.
Develop adjusting entries for prepaid insurance and depreciation using an unadjusted trial balance, aligning revenue, accounts receivable, and related depreciation with accrual-basis concepts in journal entries.
Explore adjusting entries for prepaid insurance and depreciation, including how to record assets, recognize depreciation expense, use the straight-line method, and establish a contra asset with book value calculations.
Create financial statements from a trial balance by assembling the balance sheet, income statement, and statement of equity in Excel, using formula-driven asset, liability, and equity calculations.
Learn to record and reverse accounts receivable adjusting entries in Excel, applying the revenue recognition and matching principles, and align invoices with the proper month.
Reversing the unearned revenue entry in Excel handles a negative receivable and moves the amount toward earned revenue.
This course will provide only Excel practice problems, so learners can practice working through problems. Our course entitled “Financial Accounting – Adjusting Entries & Financial Statements” will also include test questions, presentations, and discussion questions.
The adjusting entry process is a fundamental bookkeeping and accounting process but is often the accounting process most misunderstood.
Because of the name of accounting adjusting entry process we are led to believe that we are adjusting errors made by the accounting department. In other words, we may get the idea that the adjusting process would not be needed if the accounting department did their work perfectly through the period. This assumption of the adjusting process fixing errors is not the primary purpose for the adjusting process.
The adjusting process is a necessary part of the accounting cycle and one that is built into the accounting system. In other words, we plan for the adjusting process, and part of the plan is to enter normal accounting transactions in such a way that we will most easily be able to make adjustments at the end of the time period.
The adjusting process helps significantly with the understanding of accrual concepts because the adjusting process focuses on timing differences, on when revenue and expense should be recognized.
We enter adjusting entries as of the end of the period. Adjusting entries will have a balance sheet component and an income statement component.
Once the adjusting entries are complete, we can use the adjusted trial balance to create the financial statements, the balance sheet, the income statement, and the statement of equity. Who will we be learning from?
You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together curriculum.
You will be learning from somebody who is a:
• CPA – Certified Public Accountant
• CGMA – Chartered Global Management Accountant
• Master of Science in Taxation
• CPS – Certifies Post-Secondary Instructor
• Curriculum Development Export
As a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.
As a CPS and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.
The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also benefit in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.
Please join us for Financial Accounting, Adjusting Entries & Financial Statements.
It will be great.