Accounting

Accounting

In this section, we discuss different accounting concepts in a step-by-step approach and upload the Excel Templates.

ACCT101: Accounting Principles:

---

1. Accounting in Business
2. Analyzing Business Transactions
3. Recording Business Transactions and Preparing Financial Statements
   • Journalizing
   • Posting to Ledger
   • Preparing Trial Balance
   • Adjusting Entries
   • Adjusted Trial Balance
   • Income Statement
   • Balance Sheet
   • Cash Flow Statement
   • Closing Entries
   • Post-Closing Trial Balance
   • Reversing Entry
4. Accounting for Merchandising
5. Accounting for Receivable
6. Plant Assets, Natural Resources, and Intangible Assets
7. Current Liabilities
8. Long-term Liabilities
9. Inventories
10. Statement of Cash Flows
11. Financial Statement Analysis

---

Most Popular:

---

1. 100 Most Common Journal Entries

2. 50 Most Common Adjusting Entries

3. Most Common Accounting Principles with Examples

---

ACT340: Intermediate Accounting:

---

1. Environment and Theoretical Structure of Financial Accounting
2. Review of Accounting Process
3. The Balance Sheet and Financial Disclosure
4. The Income Statement, Comprehensive Income, and Statement of Cash Flows
5. Revenue Recognition
6. Cash and Receivable
7. Inventories: Measurement
8. Inventories: Additional Issues
9. Property, Plant, and Equipment and Intangible Assets: Acquisition
10. Property, Plant, and Equipment and Intangible Assets: Utilization and Disposition
11. Investment

---

1. Environment and Theoretical Structure of Financial Accounting:

Lesson-01: Theoretical Structure of Financial Accounting

Problem set and Excel Templates

Data Set for Excel Analysis

2. Review of Accounting Process:

Lesson 01: Debit and Credit in Accounting

More Questions:

Lesson 02: The Accounting Process [Journal –Unadjusted Trial Balance]

Lesson 03: The Adjusting Entry

Lesson 03: Adjusted Trial Balance, Income Statement, and Closing Entry:

Lesson 04: Worksheet

3. The Balance Sheet and Financial Disclosure:

In this chapter, we discuss on Balance sheet items and calculation of different ratios.

4. The Income Statement, Comprehensive Income, and Statement of Cash Flows:

In-Class Solution to Chapter-04 in Excel

Chapter 04-02-Ext-Template

5. Revenue Recognition:

Problem set-01 and Excel Template:

Problem set -02 and Excel Template:

Chapter-06: IN-class Solution Excel

Problems: Variable Considerations:

Problems set:

6. Cash and Receivable:

7. Inventories: Measurement:

8. Inventories: Additional Issues:

9. Property, Plant, and Equipment and Intangible Assets: Acquisition:

10. Property, Plant, and Equipment and Intangible Assets: Utilization and Disposition:

11. Investment:

The Final Project:

Additional Company List

Data Analysis Quiz Data

Data Analysis Lessons Materials:

Lesson -01: SUMIF, IF, IFS, and SWITCH Function

In-Class Worked Out Excel File-001

Lesson -02: COUNTIF, COUNTIFS, PROPER, CONCAT

DA-Lesson-02 Instructions

In-class DA-Lesson-002 Solution

Singer Data Solution

Lesson -03: SUMIF, IF, IFS, and SWITCH Function

Coming Soon

Lesson -04: SUMIF, IF, IFS, and SWITCH Function

Coming Soon

Lesson -05: SUMIF, IF, IFS, and SWITCH Function

Coming Soon

Accounting Data Analytics

Lesson-01: Introduction to Data Analytics:

1. Sales Data-SUMIFS
2. IF Data Set
3. SNDL Data