Comprehensive Accounting Study Notes: Bank Reconciliations, Bad Debts, and Notes Receivable

Bank Reconciliation Procedures and Entries

• Purpose of Bank Reconciliation:

  • Reconciles the differences between the cash balance reported on the bank statement and the cash balance recorded on the company's books.
  • Accounts for timing differences, unrecorded transactions, and errors made by either the bank or the company.

• Initial Account Data (Unique Inc.):

  • Cash balance per bank statement: $53,451$.
  • Cash balance per company books: Approximately $10,000$ apart (give or take a few hundred dollars) from the bank statement balance, necessitating reconciliation.
  • Company Name: Unique Inc.
  • Third-Party Entity: Acme.

• Reconciliation Items and Adjustments:

  • Item C — Deposit in Transit:
  • Cash receipts representing May 31 collections totaling $221$ that do not appear on the bank statement.
  • Treatment: Added to the bank balance ($\text{Bank} + 221$).
  • Item D — Outstanding Checks:
  • Checks written by the company totaling $3,937$ that have not yet cleared the bank.
  • Treatment: Subtracted from the bank balance ($\text{Bank} - 3,937$).
  • Item E — Company Posting Error:
  • A check was correctly written for $19.40$ but was incorrectly posted on the company's books as $12.90$.
  • Calculated difference: $19.40 - 12.90 = 6.30$.
  • Correction: Subtract the difference of $6.30$ from the company books ($\text{Books} - 6.30$).
  • Description: "Error, check posted incorrectly" or "wrong amount posted". Neither original line item letter lists the value $6.30$, so the description must link directly back to the transaction discrepancy.
  • Item F — Bank Service Charge / Bank Fee:
  • Bank fee assessed by the financial institution in the amount of $30$.
  • Treatment: Subtracted from the company books ($\text{Books} - 30$).
  • Item G — Note Receivable Collected by Bank:
  • The bank collected $12,200$ on behalf of Unique Inc. on a note receivable.
  • Face value of the note: $12,000$.
  • Interest earned: $12,200 - 12,000 = 200$.
  • Treatment: Both items are additions to the company books ($\text{Books} + 12,000$ and $\text{Books} + 200$).
  • Separation of items: In real-world accounting, these require distinct entries because the $12,000$ principal affects only the balance sheet (reducing Notes Receivable), while the $200$ interest constitutes revenue appearing on the income statement.
  • Item H — Non-Sufficient Funds (NSF) Check:
  • Customer NSF check from Eve Lane in the amount of $1.79$.
  • Treatment: Subtracted from the company books ($\text{Books} - 1.79$).
  • Item I — Bank Error:
  • The bank accidentally deducted a check for $7.50$, written by another company named Acme, from the account of Unique Inc.
  • Correction: Added back to the bank balance ($\text{Bank} + 7.50$) under the label "Error, check for another company cashed/deducted by mistake". The bank must be notified to correct its records.
  • Item J — Interest Revenue on Average Balance:
  • The bank credited interest on the average balance in the amount of $2.15$ (recorded as $2.50$ in calculations).
  • Treatment: Added to the company books ($\text{Books} + 2.50$) as interest revenue on balance.

• Final Reconciled Balances:

  • Adjusted balance per bank: $55,445$ (referenced alternatively as $55.44$ and $55,485$ / 50 by $4.85).
  • Adjusted balance per books: Exactly equals the adjusted bank balance ($55,485$).
  • Cash reported on the May 31 balance sheet: Corresponds to the reconciled adjusted balance ($55,485$).

• Real-World Case Study on Banking Verification Errors:

  • A customer paid a Bank of America credit card statement at a physical branch using a paper check several days after receiving the bill, well before the deadline.
  • Two weeks later, the customer received an automated past-due notice accompanied by late penalties and interest charges because the payment had not been credited to their account.
  • Upon contacting customer service with the paper deposit receipt in hand, the representative stated that "the money went somewhere."
  • The teller had failed to verify the customer's first name, last name, home address, and account number, inadvertently crediting the funds to another individual who shared the same common Polish surname.
  • Resolution required three months, involving approximately six separate telephone calls lasting roughly an hour each to provide identification, reverse penalty fees and interest, and recover the payment.
  • Practical takeaway: Tellers should always be requested to spend five full minutes thoroughly verifying identity and account information against an ID, or payments should be processed online to eliminate human error.

Bad Debt Accounting: Percent of Sales vs. Analysis of Receivables (Sand Company)

• Initial Financial Data for Sand Company (End of October):

  • Net credit sales: $2,380,000$.
  • Estimated bad debt expense rate: $3\%$ of net credit sales.
  • Allowance for Doubtful Accounts (unadjusted balance): Debit balance of $7,000$.
  • Accounts Receivable balance: $800,000$ (Debit).
  • Aging analysis of Accounts Receivable estimated uncollectibles: $76,000$.

• T-Account Classifications and Characteristics:

  • Accounts Receivable: Asset account with a normal debit balance ($800,000$ debit).
  • Bad Debt Expense: Temporary income statement account starting at zero ($0$).
  • Allowance for Doubtful Accounts: Permanent contra-asset account paired with Accounts Receivable; normal balance is credit, but carries an unadjusted debit balance of $7,000$.

• Method 1: Percent of Sales Method (Income Statement Approach):

  • Relevant Data: Net credit sales ($2,380,000$) and the bad debt percentage ($3\%$ or $0.03$).
  • Calculation:$\text{Bad Debt Expense} = 2,380,000 \times 0.03 = 71,400$
  • Adjusting Entry: The calculated $71,400$ is the exact amount of the entry. The existing $7,000$ debit balance in the allowance account is completely ignored when recording the entry:
  • Debit: Bad Debt Expense $71,400$
  • Credit: Allowance for Doubtful Accounts $71,400$
  • Ending Balance of Allowance for Doubtful Accounts:$\text{Ending Allowance Balance} = 71,400 - 7,000 = 64,400\text{ (Credit)}$
  • Financial Statement Questions:
  • Bad debt expense reported on the income statement: $71,400$.
  • Accounts Receivable Net (Net Realizable Value) on balance sheet:       $\text{Accounts Receivable Net} = 800,000 - 64,400 = 735,600$
  • Total amount owed by customers: $800,000$ (Gross Accounts Receivable).
  • Meaning of $735,600$: Accounts Receivable Net.
  • Amount estimated to be uncollectible: $64,400$ (Ending balance in Allowance for Doubtful Accounts).

• Method 2.1: Analysis of Receivables Method (Balance Sheet / Aging Approach) with Initial Debit Balance:

  • Target Ending Balance: Aging schedule dictates that the desired ending credit balance in the Allowance for Doubtful Accounts is $76,000$.
  • Calculation of Adjusting Entry Amount:
  • Initial balance: $7,000$ Debit.
  • Target balance: $76,000$ Credit.
  • When values are on opposite sides of a T-account, they are added together (analogous to moving from negative to positive across a number line):       $\text{Adjustment Amount} = 76,000 + 7,000 = 83,000$
  • Adjusting Journal Entry:
  • Debit: Bad Debt Expense $83,000$
  • Credit: Allowance for Doubtful Accounts $83,000$
  • Financial Statement Questions:
  • Allowance for Doubtful Accounts ending balance: $76,000$ Credit.
  • Bad debt expense reported on the income statement: $83,000$.
  • Accounts Receivable Net on balance sheet:       $\text{Accounts Receivable Net} = 800,000 - 76,000 = 724,000$
  • Amount owed by customers: $800,000$.
  • Amount expected to be collected from customers: $724,000$.
  • Amount estimated to be uncollectible: $76,000$.

• Method 2.2: Analysis of Receivables Method with Initial Credit Balance:

  • Data: Same data as Part 2.1, except the Allowance for Doubtful Accounts has an unadjusted credit balance of $14,000$.
  • Target Ending Balance: $76,000$ Credit.
  • Calculation of Adjusting Entry Amount:
  • Because both values reside on the credit side, subtract the initial balance from the desired target balance:       $\text{Adjustment Amount} = 76,000 - 14,000 = 62,000$
  • Adjusting Journal Entry:
  • Debit: Bad Debt Expense $62,000$
  • Credit: Allowance for Doubtful Accounts $62,000$
  • Financial Statement Questions:
  • Allowance for Doubtful Accounts ending balance: $76,000$ Credit.
  • Bad debt expense reported on the income statement: $62,000$.
  • Accounts Receivable Net: $800,000 - 76,000 = 724,000$.
  • Amount customers owe Sand Company: $800,000$.
  • Amount expected to be collected: $724,000$.
  • Amount estimated to be uncollectible: $76,000$.

Bad Debt Write-offs, Recoveries, and Estimations (Wild Company)

• Journalizing Transactions (Wild Company — January, Year 1):

  • January 3 — Direct Write-off of Bankrupt Customer:
  • Wrote off $12,750$ owed by Co, an entity confirmed to be bankrupt.
  • Journal Entry:
    • Debit: Allowance for Doubtful Accounts $12,750$
    • Credit: Accounts Receivable — Co $12,750$
  • January 16 — Partial Collection and Partial Write-off:
  • Received $5,500$ from Heiden, a bankrupt customer owing a total balance of $22,000$; wrote off the remaining balance as uncollectible.
  • Uncollectible amount written off:       $\text{Write-off Amount} = 22,000 - 5,500 = 16,500$
  • Compound Journal Entry:
    • Debit: Cash $5,500$
    • Debit: Allowance for Doubtful Accounts $16,500$
    • Credit: Accounts Receivable — Heiden $22,000$
  • January 23 — Reinstatement and Recovery of Written-off Account:
  • Customer H. Carr (Harry or Harriet Carr) paid $4,000$ cash in full settlement of an account written off two years prior as uncollectible.
  • Requires a two-step process: first reinstate the account, then record the collection.
  • Step 1: Reinstatement (reversal of the original write-off entry):
    • Debit: Accounts Receivable — H. Carr $4,000$
    • Credit: Allowance for Doubtful Accounts $4,000$
  • Step 2: Collection on account:
    • Debit: Cash $4,000$
    • Credit: Accounts Receivable — H. Carr $4,000$
  • Note on Revenue: No revenue is recorded upon collection. Revenue is recognized only when services or goods are delivered to a client, which occurred over two years earlier.

• Year-End Estimation Practice (Wild Company — December 31):

  • Given Information:

  • Unadjusted Allowance for Doubtful Accounts credit balance: $50,000$.

  • Gross Accounts Receivable: $2,350,000$.

  • Analysis of receivables estimated uncollectible: $120,000$.

  • Total sales for the year: $15,800,000$.

  • Historical uncollectible rate: $0.5\%$ (half of one percent, or $0.005$, not $5\%$).

  • Approach 1: Analysis of Receivables Method:

  • Desired target ending credit balance in Allowance: $120,000$.

  • Existing credit balance: $50,000$.

  • Adjustment required:       $\text{Adjusting Entry} = 120,000 - 50,000 = 70,000$

  • Journal Entry:

    • Debit: Bad Debt Expense $70,000$
    • Credit: Allowance for Doubtful Accounts $70,000$

  • Reporting Metrics:

    • Bad debt expense on income statement: $70,000$.
    • Allowance for Doubtful Accounts on December 31 balance sheet: $120,000$.
    • Net Realizable Value formula and calculation:         $\text{Net Realizable Value} = \text{Accounts Receivable} - \text{Allowance for Doubtful Accounts}$$\text{Net Realizable Value} = 2,350,000 - 120,000 = 2,230,000$

  • Approach 2: Percent of Sales Method:

  • Calculation using half a percent ($0.5\%$):       $\text{Bad Debt Expense} = 15,800,000 \times 0.005 = 79,000$(Caution: Using $5\%$ yields $790,000$, which includes an erroneous extra zero).

  • Adjusting entry ignores the existing $50,000$ balance:

    • Debit: Bad Debt Expense $79,000$
    • Credit: Allowance for Doubtful Accounts $79,000$

  • Reporting Metrics:

    • Bad debt expense on income statement: $79,000$.
    • Allowance for Doubtful Accounts ending balance:         $\text{Allowance Ending Balance} = 50,000 + 79,000 = 129,000$
    • Accounts Receivable Net Realizable Value:         $\text{Net Realizable Value} = 2,350,000 - 129,000 = 2,221,000$(Referenced as subtracting $121,000$ / $129,000$ to arrive at $2,221,000$).
    • Contrast between accounts: On financial statements, Bad Debt Expense and Allowance for Doubtful Accounts will never have identical ending amounts because Bad Debt Expense is a temporary zero-out account, whereas Allowance is a permanent cumulative account.

Accounting for Notes Receivable (SmileLine Case Study)

• Note Parameters:

  • Issuance Date: March 7, Year 1.
  • Payee: SmileLine.
  • Principal (Face Value): $68,000$.
  • Annual Interest Rate: $6\%$.
  • Duration: $90$ days.
  • Underlying context: Received from a client on account.
  • Accounting policies: Company adjusts and closes books monthly; interest paid at maturity; round all calculations to the nearest dollar; base year contains $365$ days.

• Maturity Date Calculation (90 Days Total):

  • March: 31 total days. Subtract the 7 days prior to issuance: $31 - 7 = 24$ days in March.
  • April: $30$ days in April ($24 + 30 = 54$ cumulative days).
  • May: $31$ days in May ($54 + 31 = 85$ cumulative days).
  • June: Number of days remaining to achieve $90$ days: $90 - 85 = 5$ days.
  • Maturity Date: June 5.

• Interest and Maturity Value Formulas:

  • General Interest Formula:     $\text{Interest} = \text{Face Value (Principal)} \times \text{Annual Interest Rate} \times \frac{\text{Days}}{365}$
  • Total Note Interest:     $\text{Total Interest} = 68,000 \times 0.06 \times \frac{90}{365} = 1,006.03 \approx 1,006$
  • Maturity Value:     $\text{Maturity Value} = \text{Principal} + \text{Interest}$$\text{Maturity Value} = 68,000 + 1,006 = 69,006$
  • Annual Interest on a One-Year Note (for comparison):     $\text{One-Year Interest} = 68,000 \times 0.06 \times 1 = 4,080$

• Sequential Monthly Adjusting Entries Through Maturity:

  • March 7 (Receipt of Note):
  • Debit: Notes Receivable $68,000$
  • Credit: Accounts Receivable $68,000$
  • March 31 (Monthly Adjusting Entry — 24 days):$\text{March Interest} = 68,000 \times 0.06 \times \frac{24}{365} = 268.27 \approx 268$
  • Debit: Interest Receivable $268$
  • Credit: Interest Revenue $268$
  • April 30 (Monthly Adjusting Entry — 30 days):$\text{April Interest} = 68,000 \times 0.06 \times \frac{30}{365} = 335.34 \approx 335$
  • Debit: Interest Receivable $335$
  • Credit: Interest Revenue $335$
  • May 31 (Monthly Adjusting Entry — 31 days):$\text{May Interest} = 68,000 \times 0.06 \times \frac{31}{365} = 346.52 \approx 347$
  • Debit: Interest Receivable $347$
  • Credit: Interest Revenue $347$
  • June 5 (Receipt of Payment at Maturity — 4 lines):
  • Interest revenue for the remaining 5 days in June:       $\text{June Interest} = 68,000 \times 0.06 \times \frac{5}{365} = 55.89 \approx 56$
  • Cumulative Interest Receivable balance from previous months:       $\text{Interest Receivable} = 268 + 335 + 347 = 950$
  • Journal Entry:
    • Debit: Cash $69,006$
    • Credit: Notes Receivable $68,000$
    • Credit: Interest Receivable $950$
    • Credit: Interest Revenue $56$
  • Sum of credit amounts: $68,000 + 950 + 56 = 69,006$ (balances the debit to Cash).

• Alternative Scenario: No Monthly Accruals Recorded (Collection Recorded at Maturity Only):

  • If the company records interest strictly when collected at maturity rather than performing monthly adjusting entries:
  • Journal Entry on June 5 (3 lines):
  • Debit: Cash $69,006$
  • Credit: Notes Receivable $68,000$
  • Credit: Interest Revenue $1,006$(Interest Receivable cannot be credited because no prior debit accrual entry was ever created).

• Financial Statement Reporting on May 31, Year 1:

  • Balance Sheet (May 31):
  • Interest Receivable asset account reports cumulative accrued interest:       $\text{Interest Receivable} = 268 + 335 + 347 = 950$
  • Income Statement (May 31):
  • Interest Revenue temporary account reflects only the current month's earnings:       $\text{Interest Revenue for May} = 347$

Overview of Long-Term Assets

• Property, Plant, and Equipment (PPE):
  • Also referred to interchangeably as fixed assets or long-term assets.
  • Defined by tangible, long-term operational utility across multiple reporting periods.
  • Structured around five core learning objectives governing asset acquisition, depreciation, disposal, and presentation.

Questions & Discussion

• Bank Reconciliation Inquiries:

  • Prompt: What side do company records belong to, and what do we call them?
  • Response: The company side represents "the books."
  • Prompt: On which side is cash from the bank statement placed?
  • Response: The bank side, with an unadjusted balance of $53,451$.
  • Prompt: How are deposits in transit classified and handled?
  • Response: They are treated as additions to the bank side.
  • Prompt: What term describes checks written by the company that have not yet cleared the bank?
  • Response: Outstanding checks; they are subtracted from the bank side ($-3,937$).
  • Prompt: How should the company correct an error where a check written for $19.40$ was posted on the books as $12.90$?
  • Response: Do not subtract either of the full amounts; subtract the difference of $6.30$ on the company side and provide a clear description ("Error, check posted incorrectly").
  • Prompt: How should the bank's collection of a $12,000$ note for $12,200$ be recorded?
  • Response: It requires two separate addition entries on the company side: $12,000$ to reduce the note receivable (balance sheet) and $200$ for interest revenue (income statement).
  • Prompt: How is an erroneous bank deduction of $7.50$ for an Acme check handled for Unique Inc.?
  • Response: Add the $7.50$ back to the bank side as an error correction.
  • Prompt: What is the final adjusted cash balance on the balance sheet?
  • Response: Both the bank side and book side balance to the exact same adjusted figure ($55,485$).

• Bad Debt Accounting Inquiries:

  • Prompt: What T-accounts must be created when calculating bad debts?
  • Response: Accounts Receivable (debit balance), Bad Debt Expense (starts at zero), and Allowance for Doubtful Accounts (contra-asset, normal credit balance).
  • Prompt: Does the unadjusted debit balance of $7,000$ matter when calculating bad debt expense under the percent of sales method?
  • Response: No, the $71,400$ calculated ($2,380,000 \times 0.03$) is the direct entry amount.
  • Prompt: Under the analysis of receivables method, how do you find the adjusting entry if the target balance is $76,000$ credit and the initial balance is $7,000$ debit?
  • Response: When balances are on opposite sides of the T-account, add them together ($76,000 + 7,000 = 83,000$). If both were on the credit side, subtract them.
  • Prompt: Why must write-offs and recoveries of bankrupt accounts not include revenue?
  • Response: Revenue only occurs when performance obligations are met or services are rendered, not when simply collecting overdue cash on an old existing account.
  • Prompt: Will the Allowance for Doubtful Accounts and Bad Debt Expense ever show the same ending balance on the financial statements?
  • Response: Never. Bad Debt Expense is a temporary account that starts at zero and closes each period, whereas Allowance is a cumulative permanent balance sheet account.

• Notes Receivable Inquiries:

  • Prompt: How is the maturity date determined for a 90-day note issued March 7?
  • Response: Count the remaining days in March ($31 - 7 = 24$), add April ($30$), add May ($31$), reaching $85$ cumulative days. The remaining $5$ days place maturity on June 5.
  • Prompt: Does the order of credits matter in the maturity journal entry?
  • Response: No, within the credits, the order of Notes Receivable, Interest Receivable, and Interest Revenue can be placed in any sequence as long as each account is correctly credited.
  • Prompt: Why is Cash excluded from monthly adjusting entries?
  • Response: Adjusting entries never involve cash; cash is only recorded during actual payment transactions, such as at note maturity.
  • Prompt: On the May 31 financial statements, why does Interest Receivable report $950$ while Interest Revenue reports $347$?
  • Response: Interest Receivable is a cumulative balance sheet asset totaling the accruals across March ($268$), April ($335$), and May ($347$). Interest Revenue is an income statement temporary account reflecting only May's monthly earnings ($347$).