Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Accounts Receivable & Allowance Method-Excel Practice Proble

via Udemy

Overview

Excel - accounts receivable valuation, allowance method, direct write off method, valuation of notes receivable,

What you'll learn:
  • Accounts receivable and note receivable characteristics
  • Accounts Receivable Cycle
  • Accounts Receivable Subsidiary Ledger
  • Accounts Receivable Valuation
  • Allowance For Doubtful Accounts Method of Accounts Receivable
  • Direct Write Off Method of Accounts Receivable
  • How to Estimate Bad Debt Expense Under the Allowance Method
  • Components of a Note Receivable
  • How to Calculate Simple Interest
  • How to Record A Note Receivable

This course will just provide the Excel practice questions component of our resources so that learners can practice problems without the distraction of other resources.

Bookkeeping problems in Excel.

We will discuss receivables, focusing on accounts receivable and notes receivable, reviewing the accounts receivable cycle, the journal entries for recording accounts receivable, and related subsidiary ledgers.

We will discuss bad debt and valuing ofaccounts receivable using two methods, the allowance method and the direct write off method. The accounts receivable account represents money owed to the company but there will be times when the companycannot collect on the account receivables.

Under the direct write off method, we write off the accounts receivable as we determine they are not collectible. The direct write off method does not do a good job of representing the accounts receivable account'strue value and does not do a good job of conformingto the matching principle, matching up expenses with the related revenue it was used to generate.

The allowance method does a better job of valuingaccounts receivableand conforming to the matchingprinciple and is the method preferred. The allowance method is more complex, however, and requires the use of estimates.

We will also discuss notes receivable, the journal entry for recording notes receivable, and for receivingpaymenton a note receivable. We will cover detailed methods for calculating simple interest.

Who will we be learning from?

You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together curriculum.

You will be learning from somebody who is a:

• CPA – Certified Public Accountant

• CGMA – Chartered Global Management Accountant

• Master of Science in Taxation

• CPS – Certifies Post-Secondary Instructor

• Curriculum Development Export

As a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.

As a CPS and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.

The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also benefit in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.

Content Includes:

  • Account receivable and note receivable characteristics
  • Accounts receivable cycle
  • Accounts receivable subsidiary ledger
  • Accounts receivable valuation
  • Allowance for doubtful accounts method of accounts receivable
  • Direct write off method of accounts receivable
  • How to estimate bad debt expense under the allowance method
  • Components of a note receivable
  • How to calculate simple interest
  • How to record a note receivable

Taught by

Robert (Bob) Steele

Reviews

4.3 rating at Udemy based on 62 ratings

Start your review of Accounts Receivable & Allowance Method-Excel Practice Proble

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.