Accounts Receivable and Bad Debt: Percentage of Net Sales, Aging, Write-offs, and Note Receivable Conversions

Focus and scope

  • In accounting problems, much information can be extraneous. Focus on what you actually need to answer the question.
  • Important principle: for each method, use the data the method requires (e.g., credit sales for aging or net-sales method; exclude cash Sales when calculating uncollectible estimates).
  • This set covers: percentage of net sales method, aging method, write-offs and recoveries, and converting AR to a note receivable.

Percentage of net sales method

  • Key idea: Bad debt expense is based on a percentage of credit sales (not total sales).
  • Data to use in this scenario:
    • Total sales: 168,000 (ignore for this method unless specified as credit sales)
    • Credit sales: 110,000
    • Cash sales: 58,000 (not used for uncollectibility calculation)
    • Estimated uncollectible percentage: 2%
    • Beginning balance in Allowance for Doubtful Accounts: 1,220 (note: transcript also mentions 1,002.20 in another place; both appear in the material; use 1,220 for the worked example consistency here)
  • Step 1: Compute bad debt expense using credit sales only
    • extBaddebtexpense=extCreditsalesimesextUncollectible<br/>rate=110,000imes0.02=2,200.ext{Bad debt expense} = ext{Credit sales} imes ext{Uncollectible <br /> rate} = 110{,}000 imes 0.02 = 2{,}200.
  • Step 2: Journal entry under percentage of net sales
    • Debit Bad Debt Expense 2{,}200; Credit Allowance for Doubtful Accounts 2{,}200.
  • Step 3: Ending balances (using beginning allowance balance)
    • Beginning Allowance balance: 1,220 (per the problem statement)
    • Increase in Allowance from entry: 2,200
    • Ending Allowance = Beginning + Increase = 1,220 + 2,200 = 3,420
  • Step 4: T-accounts and implications
    • Bad Debt Expense (temporary): beginning balance = 0; Debit 2,200; Ending = 2,200
    • Allowance for Doubtful Accounts (permanent/contra-asset): beginning = 1,220; Credit 2,200; Ending = 3,420
  • Note on variants in initial data
    • If you see a beginning allowance of 1,002.20 (as written in one part of the material), the ending balance would be 1,002.20 + 2,200 = 3,202.20. The key concept remains: you credit the allowance by the same amount as the debit to bad debt expense.

Aging of accounts receivable method

  • Key idea: Estimate uncollectible based on the age buckets of AR; compute an ending allowance balance, then derive bad debt expense as the plug to move beginning balance to ending balance.
  • Data to use in this scenario:
    • Accounts receivable ending balance: 73,000 (from the quarter end)
    • Age buckets with associated uncollectible percentages:
    • 48,000 aged some period → 3% uncollectible
    • 17,000 aged some period → 6% uncollectible
    • 8,000 aged some period → 12% uncollectible
    • Beginning balance in Allowance for Doubtful Accounts: 1,220
  • Step 1: Compute required ending allowance by bucket
    • 48,000imes0.03=1,44048{,}000 imes 0.03 = 1{,}440
    • 17,000imes0.06=1,02017{,}000 imes 0.06 = 1{,}020
    • 8,000imes0.12=9608{,}000 imes 0.12 = 960
    • Ending Allowance = 1{,}440 + 1{,}020 + 960 = 3{,}420</li></ul></li><li>Step2:Determinebaddebtexpense(plug)<ul><li>BadDebtExpenseneededtomovefrombeginningtoendingallowance:</li><li></li></ul></li> <li>Step 2: Determine bad debt expense (plug)<ul> <li>Bad Debt Expense needed to move from beginning to ending allowance:</li> <li> ext{Bad Debt Expense} = ext{Ending Allowance} - ext{Beginning Allowance} = 3{,}420 - 1{,}220 = 2{,}200</li></ul></li><li>Step3:Journalentryunderagingmethod<ul><li>DebitBadDebtExpense2,200;CreditAllowanceforDoubtfulAccounts2,200.</li></ul></li><li>Step4:Whattheagingmethodprovides<ul><li>ItprovidestheendingAllowanceforDoubtfulAccountsbalance(3,420here),notthebaddebtexpensedirectly(thoughthepluggivesyoutheexpensefigure).</li></ul></li><li>Exampletakeaway<ul><li>Inaging,youcomparebeginningvsendingallowancetocomputetheexpenseneededtoreachtherequiredendingbalance.</li></ul></li><li>Similaritiestopercentagemethod<ul><li>Inthisproblem,baddebtexpenseendeduptobe2,200inbothmethods;themechanismsdiffer(endingallowancevs.expenseasthedirectoutput).</li></ul></li></ul><h4id="writeoffsandrecoveriesofaccountsreceivable">Write−offsandrecoveriesofaccountsreceivable</h4><ul><li>April15write−offof400<ul><li>Purpose:removeuncollectibleARandreducetheestimateduncollectibleviatheallowance</li><li>Entry(typical):DebitAllowanceforDoubtfulAccounts;CreditAccountsReceivable400</li><li>Effect:AssetARdecreases;Allowancedecreases(reducingtheestimateduncollectible)</li></ul></li><li>June28recoveryofpreviouslywritten−offamount(400)<ul><li>Step1:Reinstatementoftheaccountsreceivableandreversalofthewrite−off</li><li>Entry:DebitAccountsReceivable400;CreditAllowanceforDoubtfulAccounts400</li><li>Step2:Cashcollectionwhenthecustomerpays</li><li>Entry:DebitCash400;CreditAccountsReceivable400</li><li>Effect:ARisrestoredandthensettledbycash;theallowanceisadjustedbacktoreflecttherecovery</li></ul></li></ul><h4id="conversionofaccountsreceivabletoanotereceivable">Conversionofaccountsreceivabletoanotereceivable</h4><ul><li>Scenario:ConvertanetARtoanotereceivablewithinterest</li><li>Initialconversion(AR→NoteReceivable)<ul><li>Entry:DebitNoteReceivable4,000;CreditAccountsReceivable4,000</li><li>Rationale:Convertanon−interest−bearingARintoaninterest−bearingnotereceivable;nocashyet</li></ul></li><li>Interestandmaturitycalculations<ul><li>Annualinterestrate:12<li>Principal:4,000</li><li>Term:3months(90days)</li><li>Interestearnedoverterm:</li></ul></li> <li>Step 3: Journal entry under aging method<ul> <li>Debit Bad Debt Expense 2{,}200; Credit Allowance for Doubtful Accounts 2{,}200.</li></ul></li> <li>Step 4: What the aging method provides<ul> <li>It provides the ending Allowance for Doubtful Accounts balance (3,420 here), not the bad debt expense directly (though the plug gives you the expense figure).</li></ul></li> <li>Example takeaway<ul> <li>In aging, you compare beginning vs ending allowance to compute the expense needed to reach the required ending balance.</li></ul></li> <li>Similarities to percentage method<ul> <li>In this problem, bad debt expense ended up to be 2,200 in both methods; the mechanisms differ (ending allowance vs. expense as the direct output).</li></ul></li> </ul> <h4 id="writeoffsandrecoveriesofaccountsreceivable">Write-offs and recoveries of accounts receivable</h4> <ul> <li>April 15 write-off of 400<ul> <li>Purpose: remove uncollectible AR and reduce the estimated uncollectible via the allowance</li> <li>Entry (typical): Debit Allowance for Doubtful Accounts; Credit Accounts Receivable 400</li> <li>Effect: Asset AR decreases; Allowance decreases (reducing the estimated uncollectible)</li></ul></li> <li>June 28 recovery of previously written-off amount (400)<ul> <li>Step 1: Reinstatement of the accounts receivable and reversal of the write-off</li> <li>Entry: Debit Accounts Receivable 400; Credit Allowance for Doubtful Accounts 400</li> <li>Step 2: Cash collection when the customer pays</li> <li>Entry: Debit Cash 400; Credit Accounts Receivable 400</li> <li>Effect: AR is restored and then settled by cash; the allowance is adjusted back to reflect the recovery</li></ul></li> </ul> <h4 id="conversionofaccountsreceivabletoanotereceivable">Conversion of accounts receivable to a note receivable</h4> <ul> <li>Scenario: Convert a net AR to a note receivable with interest</li> <li>Initial conversion (AR → Note Receivable)<ul> <li>Entry: Debit Note Receivable 4{,}000; Credit Accounts Receivable 4{,}000</li> <li>Rationale: Convert a non-interest-bearing AR into an interest-bearing note receivable; no cash yet</li></ul></li> <li>Interest and maturity calculations<ul> <li>Annual interest rate: 12%</li> <li>Principal: 4{,}000</li> <li>Term: 3 months (90 days)</li> <li>Interest earned over term:I = P imes r imes t = 4{,}000 imes 0.12 imes rac{3}{12} = 120</li></ul></li><li>Maturitysettlement(endofterm)<ul><li>Amountdueatmaturity:principal+interest=4,000+120=4,120</li><li>Entrytosettlethenote:DebitCash4,120;CreditNoteReceivable4,000;CreditInterestRevenue120</li></ul></li><li>Importantdistinctions<ul><li>ConvertingARtoNoteReceivabletransferstheassetformbutnotthecashflowimmediately</li><li>Interestrevenueisrecognizedatthetimeofcollection(oraccrualsifapplicable)</li></ul></li></ul><h4id="practicaltakeawaysandexamorientedtips">Practicaltakeawaysandexam−orientedtips</h4><ul><li>Whenaskedtousethepercentageofnetsalesmethod,useonlycreditsales;ignorecashsalesfortheuncollectibleestimate.</li><li>Inthepercentagemethod,baddebtexpenseistherequiredadjustmenttorecognizetheexpecteduncollectibleamountfromcreditsales;thecorrespondingcreditgoestotheAllowanceforDoubtfulAccounts.</li><li>Intheagingmethod,computetheendingallowancebasedonbucket−basedpercentages,thendeterminebaddebtexpenseastheplugneededtomovefrombeginningtoendingallowance(EndingAllowance−BeginningAllowance).</li><li>BadDebtExpenseisatemporary/nominalaccountandclosestoRetainedEarningsatperiod−end;AllowanceforDoubtfulAccountsisapermanent(contra−asset)account.</li><li>Write−offsdonotaffecttheincomestatementatthetimeofwrite−off;theyreducebothARandtheAllowance.RecoveriesaffectthebalancesheetbyreinstatingARandsubsequentlyincreasingcash(andreversingtheallowanceimpactifapplicable).</li><li>ConvertingARtoanotereceivablecreatesanewasset(NoteReceivable)andreplacesAR;interestaccruesoverthenotetermandisrecognizedasInterestRevenueatcollectionorovertimedependingonpolicy.</li><li>Keyformulastomemorize:<ul><li></li></ul></li> <li>Maturity settlement (end of term)<ul> <li>Amount due at maturity: principal + interest = 4{,}000 + 120 = 4{,}120</li> <li>Entry to settle the note: Debit Cash 4{,}120; Credit Note Receivable 4{,}000; Credit Interest Revenue 120</li></ul></li> <li>Important distinctions<ul> <li>Converting AR to Note Receivable transfers the asset form but not the cash flow immediately</li> <li>Interest revenue is recognized at the time of collection (or accruals if applicable)</li></ul></li> </ul> <h4 id="practicaltakeawaysandexamorientedtips">Practical takeaways and exam-oriented tips</h4> <ul> <li>When asked to use the percentage of net sales method, use only credit sales; ignore cash sales for the uncollectible estimate.</li> <li>In the percentage method, bad debt expense is the required adjustment to recognize the expected uncollectible amount from credit sales; the corresponding credit goes to the Allowance for Doubtful Accounts.</li> <li>In the aging method, compute the ending allowance based on bucket-based percentages, then determine bad debt expense as the plug needed to move from beginning to ending allowance (Ending Allowance − Beginning Allowance).</li> <li>Bad Debt Expense is a temporary/nominal account and closes to Retained Earnings at period-end; Allowance for Doubtful Accounts is a permanent (contra-asset) account.</li> <li>Write-offs do not affect the income statement at the time of write-off; they reduce both AR and the Allowance. Recoveries affect the balance sheet by reinstating AR and subsequently increasing cash (and reversing the allowance impact if applicable).</li> <li>Converting AR to a note receivable creates a new asset (Note Receivable) and replaces AR; interest accrues over the note term and is recognized as Interest Revenue at collection or over time depending on policy.</li> <li>Key formulas to memorize:<ul> <li> ext{Bad debt expense} = ext{Credit sales} imes ext{Uncollectible rate}</li><li></li> <li> ext{Ending Allowance} = ext{Beginning Allowance} + ext{Bad Debt Expense (if using percentage)}</li><li></li> <li>I = P imes r imes t(fornotes)</li></ul></li><li>Quickconsistencycheckyoucanperformonproblems<ul><li>Ifagingbucketsyieldanendingallowanceof3,420andbeginningallowanceis1,220,baddebtexpenseshouldbe2,200</li><li>Ifbothmethodsyieldthesamebaddebtexpense,that’scommonbutnotguaranteed;focusonwhatthemethodrequires</li></ul></li><li>Quickreferencenumbersfromtheexample<ul><li>Creditsales:110,000;Uncollectiblerate:2(for notes)</li></ul></li> <li>Quick consistency check you can perform on problems<ul> <li>If aging buckets yield an ending allowance of 3,420 and beginning allowance is 1,220, bad debt expense should be 2,200</li> <li>If both methods yield the same bad debt expense, that’s common but not guaranteed; focus on what the method requires</li></ul></li> <li>Quick reference numbers from the example<ul> <li>Credit sales: 110{,}000; Uncollectible rate: 2% → Bad debt expense =2{,}200</li><li>Beginningallowance:1,220;Endingallowance(aging):3,420→Baddebtexpense=</li> <li>Beginning allowance: 1{,}220; Ending allowance (aging): 3{,}420 → Bad debt expense =2{,}200</li><li>ARendingbalance:73,000;buckets:48,000@3<li>Noteconversion:4,000note;12</li> <li>AR ending balance: 73{,}000; buckets: 48{,}000 @ 3% → 1{,}440; 17{,}000 @ 6% → 1{,}020; 8{,}000 @ 12% → 960; Total ending allowance: 3{,}420</li> <li>Note conversion: 4{,}000 note; 12% annual; 3 months → Interest =120; Cash received at maturity = 4{,}000 + 120 = 4{,}120

End of module context

  • This is presented as Module Five content; anticipation of Module Six on long-term assets next
  • Core exam-ready concepts include the mechanics of recognizing bad debt using different estimation methods, handling write-offs and recoveries, and basic note receivable conversions with interest