Joey’s Bike Shop sells new and used bicycle parts

Intermediate AccountingReceivables

The textbook question

Joey’s Bike Shop sells new and used bicycle parts. Although a majority of its sales are cash sales, it makes a significant amount of credit sales. During Year 1, its first year of operations, Joey’s Bike Shop experienced the following:

Sales on account$258,000
Cash sales694,800
Collections of accounts receivable245,100
Uncollectible accounts charged off during the year1,380

Required
Assume that Joey's Bike Shop uses the allowance method of accounting for uncollectible accounts and estimates that 1 percent of its sales on account will not be collected. Answer the following questions:

a. What is the Accounts Receivable balance at December 31, Year 1?
b. What is the ending balance of Allowance for Doubtful Accounts at December 31, Year 1, after all entries and adjusting entries are posted?
c. What is the amount of uncollectible accounts expense for Year 1?
d. What is the net realizable value of accounts receivable at December 31, Year 1?

Below is the Accuity problem: the same method with different numbers. We solve ours, so work through it and you'll know how to solve yours.

The Accuity problem

Spoke & Sprocket Cycles runs a parts counter for new and used bike components. Most customers pay at the register, but local repair shops and cycling clubs buy on credit, and those sales add up. The shop's first year of business was Year 1, and its records show:

ItemAmount
Sales on account$280,000
Cash sales$700,000
Collections of accounts receivable$220,000
Uncollectible accounts written off during the year$1,200

The shop uses the allowance method and expects 1% of its sales on account to go uncollected.

  1. What is the Accounts Receivable balance on December 31, Year 1?
  2. After every entry for the year, including the year-end adjustment, what is the balance in Allowance for Doubtful Accounts on December 31, Year 1?
  3. How much uncollectible accounts expense does the shop report for Year 1?
  4. What is the net realizable value of accounts receivable on December 31, Year 1?

An Accuity original. We write our own version of each problem and solve it from scratch, so you learn the method rather than copying an answer.

Video solution

Covers the full step-by-step solution below, start to finish.

Jake Glidden, CPA, MSA

Solved by

Jake Glidden, CPA, MSA

Founder of Accuity

Jake started Accuity while studying accounting at UCF and has worked with hundreds of students in introductory and upper-level accounting classes. Accuity solutions are checked against the textbook before they're published.

Certified Public Accountant (CPA) · B.S.B.A. in Accounting, UCF · M.S. in Accounting, UCF

More about Accuity →

Step-by-step solution

The same steps the video works through, written out.

This problem tests the allowance method with the percent of sales estimate in a company's first year. Because it's the first year, every account starts at zero. Two rules carry the problem:

  • Write-offs reduce both Accounts Receivable and the Allowance. They are not an expense.
  • The year-end estimate (1% of sales on account) is the expense, and it is added to the allowance.

Cash sales never pass through receivables, so the $700,000 is a distractor.

Requirement 1: Accounts receivable

Accounts ReceivableAmount
Beginning balance$0
Add: Sales on account280,000
Less: Collections(220,000)
Less: Write-offs(1,200)
Ending balance$58,800

Requirement 3 first: The expense

Do the expense before the allowance, because the allowance depends on it.

$280,000 × 1% = $2,800

With percent of sales, the expense is the estimate itself. It doesn't depend on what is already in the allowance.

Requirement 2: The allowance

Allowance for Doubtful AccountsAmount
Beginning balance$0
Less: Write-offs during the year(1,200)
Balance before adjustment (debit)(1,200)
Add: Uncollectible accounts expense2,800
Ending balance (credit)$1,600

The write-offs came first, so before the adjustment the allowance briefly sat at a $1,200 debit. That's normal mid-year. The year-end entry adds $2,800, leaving a $1,600 credit.

Requirement 4: Net realizable value

$58,800 - $1,600 = $57,200

Cross-check another way: sales on account $280,000, minus cash collected $220,000, minus the full $2,800 of expected losses = $57,200. The $1,200 already written off is part of that $2,800.

A/R $58,800; Allowance $1,600; uncollectible accounts expense $2,800; NRV $57,200.

Where students go wrong

  • Making the allowance equal the expense. The allowance is $2,800 only before the write-offs use part of it. After $1,200 of write-offs, it's $1,600.
  • Taking 1% of total sales. The estimate applies to sales on account ($280,000), not the $980,000 that includes cash sales.

More Receivables problems

Got a different wording of this problem?

Assignments vary by school and semester. Share the version you were given and we'll add it so other students can find this solution.

Studying Receivables for a class?

Accuity courses map to your actual syllabus — video lessons, exam-style practice, and walkthroughs for the problems you're assigned.

Ace your accounting classes.

Textbook questions are for reference. We show a textbook's question only so you can find the problem you were assigned. We don't solve textbook questions: every solution and video on this site works through our own Accuity problem, written to teach the same method with different numbers.

Educational use. Accuity problems are original teaching material — we write our own version of each problem and solve it on video so you learn the method. Don't submit our work as your own; that violates your school's academic integrity policy. If you believe content here infringes your rights, file a DMCA notice.