MYBREAKEVEN • Published November 7, 2026

Allowance for Doubtful Accounts: Estimate and Reconcile — working record

Original fictional USD case. This worksheet does not automatically calculate. Edit the blank cells, then print or save your completed copy before closing. Fields are not uploaded or saved by this page.

Completed teaching case

Reconciled case from the guide
Movement / targetAmount
Opening allowance credit1,200
Write-offs debited to allowance−700
Reinstatement on recovery+200
Credit balance before new provision700
Required closing allowance2,800
Current provision credit needed2,100

Your evidence and assumptions

Your working record — replace each cell
Bucket / cutoff / evidenceGross exposureSupported loss assumptionRequired allowanceExisting balance / provision / reviewer
Enter record 1Enter valueEnter valueEnter valueEnter value
Enter record 2Enter valueEnter valueEnter valueEnter value
Enter record 3Enter valueEnter valueEnter valueEnter value
Enter record 4Enter valueEnter valueEnter valueEnter value
Enter record 5Enter valueEnter valueEnter valueEnter value

Check amounts, dates, scope and source documents independently. Planning education; not accounting, legal, tax or lending advice.

Read the full method and limitations