Accounting Excel - Debits & Credits - Example Problems

Name: Accounting Excel - Debits & Credits - Example Problems
Rating: 4.2 (36 reviews)

Accounting Essentials - Accounting terms Bookkeeping & recording transactions using the accounting equation

Created byRobert (Bob) Steele

Last updated 7/2018

English

What you'll learn

Define accounting
List accounting objectives
List and describe financial statements
Explain the relationship between financial statements
Describe the double entry accounting system
Name and explain the accounting equation
Record financial transactions using the accounting equation
Record financial transactions using debits and credits
Post general journal entries to the general ledger

Course content

4 sections • 9 lectures • 4h 29m total length

Introduction3:02
Explore accounting Excel debits and credits through example problems and hands-on worksheets, comparing the accounting equation with debits and credits and posting to the general ledger.

Worksheet 1 Accounting Equation Cash46:19
Explore using excel to record accounting transactions, apply the accounting equation (assets equals liabilities plus equity), and practice formulas, cell references, balance tracking, revenue, and expenses.
Worksheet 3 Accounting Equation Account Payable36:27
Track the accounts payable cycle and transactions in an Excel worksheet, recording purchases on account and payments to reinforce the accounting equation of assets, liabilities, and equity, with debits and credits.

Prob 4 Debits and Credits Cash45:32
Record cash transactions using a general journal and trial balance in an accounting Excel worksheet; post debits and credits to assets, liabilities, and equity to calculate net income.
Prob 5 Debits and Credits Accounts Receivable29:21
Explore the accounts receivable cycle by recording sales on account, posting journal entries, and tracing revenue recognition effects on assets, revenue, and the accounting equation.
Prob 6 Debits and Credits Accounts Payable28:39
Explore the accounts payable purchasing cycle by recording on-account purchases and payments in a journal, worksheet, and ledger. See how debits and credits affect assets, liabilities, and equity.

General Ledger Cash28:51
Prob 8 General Ledger Accounts Payable26:35
Post entries from the general journal to the general ledger to track the accounts payable cycle and verify the trial balance after each transaction.
Prob 8 General Ledger Accounts Receivable24:47
Post journal entries to the general ledger as you go, build the trial balance, and use Excel to track accounts receivable, cash, and revenue for accurate net income.

Requirements

Knowledge of accounting topics

Description

This course will provide only Excel practice problems, so learners can practice working through problems. Our course entitled “Financial Accounting – Debit & Credits-Accounting Transactions” will also include test questions, presentations, and discussion questions.

Accounting core concepts will be covered, foundational accounting skills needed for all levels of accounting including the accounting terms, the double entry accounting system, and recording transactions using both the accounting equation and debits and credits. These accounting skills are fundamental bookkeeping skills.

These are the accounting fundamentals which most accounting courses spend far too little time on. The better we understand these accounting foundational topics, the better we will do in all accounting concepts.

Like practicing catch or going over those musical scales, practicing the accounting fundamentals is time well spent for beginners as well as experienced accountants. We are never too smart to practice the accounting fundamentals. This course will thoroughly cover the fundamentals and will provide a foundation for learning concepts that limit the likelihood of learning rules that do not always apply.

Who this course is for:

Accounting students
Business owner
Anyone who whats to learn accounting

Accounting Excel - Debits & Credits - Example Problems

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Financial Transactions Using The Accounting Equation2 lectures • 1hr 23min

Financial Transactions Using Debits and Credits3 lectures • 1hr 44min

Financial Transactions Posting to The General Ledger3 lectures • 1hr 20min

Requirements

Description

Who this course is for: