Udemyintermediateen

Accounts Receivable & Allowance Method-Excel Practice Proble

Master Excel for accounts receivable! Learn valuation methods (allowance, direct write-off) & notes receivable. Improve financial analysis skills.

4.3(122)
1,136students
4h 45m
Certificate
Robert (Bob) Steele
Robert (Bob) SteeleCPA, CGMA, M.S. Tax, CPI

Course Content

Accounts Receivable & Allowance Method-Excel Practice Proble is an intermediate-level Udemy course taught by Robert (Bob) Steele. It runs 4h 45m, is taught in English, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 122 reviews, with 1,136 students enrolled. It is a paid course, first published July 2018.

Mastering Accounts Receivable & Notes Receivable in Excel: Practical Accounting Skills

This course focuses on providing you with essential Excel practice questions to solidify your understanding of key accounting concepts, all without distractions. We'll dive into practical bookkeeping problems in Excel, specifically centered around accounts receivable and notes receivable.

Accounts Receivable Deep Dive:

  • Understanding Accounts Receivable: Learn what accounts receivable represents – money owed to your company by customers.
  • The Accounts Receivable Cycle: A comprehensive review of the entire accounts receivable cycle, from invoicing to collection.
  • Journal Entries for Accounts Receivable: Master the journal entries for recording accounts receivable and managing the accounts receivable subsidiary ledger.
  • Bad Debt & Accounts Receivable Valuation: Explore methods for handling uncollectible amounts. We'll cover two primary approaches:
    • Direct Write-Off Method: Understand how this method simplifies accounting but may not accurately reflect the true value of your accounts receivable.
    • Allowance Method: Learn the preferred method for valuing accounts receivable and adhering to the matching principle (matching expenses with related revenue). We'll discuss how to estimate bad debt expense under the allowance method.

Notes Receivable Fundamentals:

  • Understanding Notes Receivable: Learn the characteristics of notes receivable and how they differ from accounts receivable.
  • Journal Entries for Notes Receivable: Master the journal entry for recording notes receivable and the process of receiving payment on a note receivable.
  • Calculating Simple Interest: Gain practical skills in how to calculate simple interest on notes receivable.

Who is this course for?

You'll learn from an experienced instructor with a strong background in accounting and accounting software. Our instructor possesses:

  • CPA (Certified Public Accountant) credentials
  • CGMA (Chartered Global Management Accountant) designation
  • Master of Science in Taxation
  • CPS (Certified Post-Secondary Instructor) certification
  • Extensive experience in curriculum development.

As a practicing CPA, the instructor has directly addressed complex technical accounting issues for clients across various levels. Their experience as a CPS and professor has honed their ability to teach accounting concepts effectively. The instructor's expertise in designing technical courses ensures a logical learning path and addresses challenges related to technical topics and software like QuickBooks Pro.

Content Breakdown:

  • Accounts Receivable and Note Receivable Characteristics: A foundational understanding of both.
  • Accounts Receivable Cycle: A step-by-step walkthrough.
  • Accounts Receivable Subsidiary Ledger: Managing detailed customer balances.
  • Accounts Receivable Valuation: Understanding different valuation methods.
  • Allowance for Doubtful Accounts Method: Estimating and accounting for uncollectible amounts.
  • Direct Write-Off Method: A simpler, but less accurate, approach.
  • How to Estimate Bad Debt Expense: A critical skill for accurate financial reporting.
  • Components of a Note Receivable: Understanding the key elements.
  • How to Calculate Simple Interest: Practical application of interest calculations.
  • How to Record a Note Receivable: Proper accounting procedures.
$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(9)
42h 53m
beginner
5.0(3)
99h 1m
intermediate
5.0(2,858)
1h 6m
intermediate

Accounts for Partnership

by Md Ilias Rubel FCCA, MBA

5.0(211)
1h 17m
all