Please ensure Javascript is enabled for purposes of website accessibility
QuickBooks Desktop 2021 #12 - Loan Manager And Amortization Tables
0( 0 REVIEWS )
23 STUDENTS
1h 44m

This course is designed for those interested to learn the QuickBooks Desktop 2021 software in accounting, how to effectively use the loan manager, generate amortization tables and make loan projections.

Read more.
Course Skill Level
Beginner
Time Estimate
1h 44m

Instructor

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 Course

About This Course

amoWho this course is for:

  • Accountants
  • Bookkeepers
  • Business owners

What you’ll learn: 

  • How to use the loan manager to generate an amortization schedule
  • Generate an amortization table in Excel
  • Generate bills or checks for payments with proper breakdown of principal and interest
  • Make loan projections

Software version used in the course: 

  • QuickBooks Desktop Pro 2021

This is the twelfth in a series of courses covering QuickBooks Desktop Pro 2021, comprehensively.

We will outline what the loan manager is and how to use it.

Learners will learn how to use the loan manager to generate an amortization table, a list of future payments, the interest and principal portion of each payment, and the loan balance after each.

The course will demonstrate how to generate an amortization table in Excel for comparison to the loan manager, Excel providing a transparent look at what an amortization table is and how it is calculated.

We will show how the loan manager can be used to generate bills or checks as payments become due in accordance to the loan manager amortization table, the bills and checks generated properly breaking out the amount of the payment applying to interest and the amount applying to principal.

Learners will run multiple practice scenarios utilizing the loan manager tool.

The course will also demonstrate how the loan manager can be used to make loan projections, the demonstrations comparing the loan manager tools to those that can be found in Excel.

Our Promise to You

By the end of this course, you will have learned how to use the loan manager and generate amortization tables in QuickBooks Desktop 2021.

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 using QuickBooks Desktop 2021.

Course Curriculum

Section 1 - Overview
Loan Amortization Schedule 00:00:00
Loan Manager Overview 00:00:00
Loan Manager Setup QuickBooks File 00:00:00
Section 2 - Setup Loan
Loan Manager Amortization Table Excel 00:00:00
Loan Manager Setup New Loan 00:00:00
Section 3 - Generate Checks And Bills
Loan Manager Generate Checks And Bills 00:00:00
Section 4 - Setup Loan Where Payments Have Already Been Made
Loan Manager Enter Loan Where Payments Have Already Been Made 00:00:00
Section 5 - Use What If Scenario Tool
Loan Manager What If Scenario Tool 00:00:00
4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?