Excel Accounting 5–Bank Reconciliations-Month 1 & 2

Learn how to put together a bank reconciliation using Excel from a Certified Public Accountant (CPA)

4.30 (39 reviews)
Udemy
platform
English
language
Accounting & Bookkeeping
category
Excel Accounting 5–Bank Reconciliations-Month 1 & 2
17,954
students
2 hours
content
Jan 2022
last update
$84.99
regular price

What you will learn

Explain why the bank reconciliation process is important

Describe the bank reconciliation process

Complete a bank reconciliation process after the first month of operations, explaining the problems often faced during the first bank reconciliation

Complete a bank reconciliation after the second month of operations, explaining how the outstanding items in the first month will be included

Define outstanding checks and how they are shown on the bank reconciliation

Define outstanding deposits and how the are shown on the bank reconciliation

Description

This course will focus on creating bank reconciliations after two months of financial data was entered into an accounting system using Excel.

For most new steps in the process, you will have access to a downloadable Excel Workbook containing at least two tabs, one with the answer, the new steps completed, the other starting where the prior presentation left off.

We will create a bank reconciliation for the first and second months.

The bank reconciliation process is one of the most important internal controls over the accounting system and also one of the most misunderstood and poorly taught procedures.

Most people think a bank reconciliation’s purpose is to double-check the ending balance of cash, and it is, in part. However, we are also verifying all the transactions that have involved cash, both increases, and decreases.

Because cash is the lifeblood of the business and because every transaction will impact at least two accounts, due to the double entry accounting system, verifying cash transactions also provides a huge internal control over the rest of the accounting system, including the revenue cycle, the expenses cycle, and the employee cycle.

Most textbook problems will teach the bank reconciliation process without providing a bank statement, which can be confusing. We will give an example bank statement we will use to perform our bank reconciliation process.

As we construct our bank reconciliation, we will discuss how accounting software, like QuickBooks, lays out the bank reconciliation process.

We will also discuss some of the problems often faced when entering the first bank reconciliation.

Content

Month One Bank Reconciliation

9040 Bank Reconciliation Month One Part 1
9041 Bank Reconciliation Month One Part 2
9042 Bank Reconciliation Month One Part 3

Month Two Bank Reconciliation

9140 Bank Reconciliation Month Two Part 1
9141 Bank Reconciliation Month Two Part 2
9143 Bank Reconciliation Month Two Part 3

Coupons

DateDiscountStatus
1/9/2022100% OFF
expired
1/21/2022100% OFF
expired
2/7/2022100% OFF
expired
2/15/2022100% OFF
expired
2/26/2022100% OFF
expired
3/5/2022100% OFF
expired
3/24/2022100% OFF
expired
4/2/2022100% OFF
expired
4/10/2022100% OFF
expired
4/19/2022100% OFF
expired
5/14/2022100% OFF
expired
5/20/2022100% OFF
expired
6/8/2022100% OFF
expired
6/14/2022100% OFF
expired
7/7/2022100% OFF
expired
8/10/2022100% OFF
expired
8/17/2022100% OFF
expired
9/8/2022100% OFF
expired
9/21/2022100% OFF
expired
10/4/2022100% OFF
expired
10/11/2022100% OFF
expired
10/17/2022100% OFF
expired
11/5/2022100% OFF
expired
12/4/2022100% OFF
working

Charts

Price

Excel Accounting 5–Bank Reconciliations-Month 1 & 2 - Price chart

Rating

Excel Accounting 5–Bank Reconciliations-Month 1 & 2 - Ratings chart

Enrollment distribution

Excel Accounting 5–Bank Reconciliations-Month 1 & 2 - Distribution chart

Related Topics

4441162
udemy ID
12/12/2021
course created date
1/9/2022
course indexed date
Ignacio Castro
course submited by