1099-C Tax Calculator: Build the Insolvency Worksheet
Quick Answer: There is no single IRS calculator for a 1099-C, but the math fits in a short spreadsheet. Box 2 is the cancelled amount, which is ordinary income unless an exclusion applies. For insolvency, subtract the fair market value of everything you owned from everything you owed just before the cancellation; you can exclude the smaller of that gap and the cancelled debt, and only the rest is taxable.
A Form 1099-C reports debt a lender cancelled, such as the forgiven part of a settled or charged-off credit card. The IRS treats that forgiven amount as income, but the insolvency exclusion often removes some or all of it. A spreadsheet that copies the IRS insolvency worksheet gives you the excludable amount, the taxable remainder and a rough tax estimate.
Drop your bank statement here
PDF or OFX · Max 4.4 MB
Uploaded over an encrypted connection. We never ask for your bank login. Privacy
Preview free with no account. Free account to download.
What the form is telling you
The Instructions for Forms 1099-A and 1099-C name each box. The ones the calculation needs:
| Box | Label | What to do with it |
|---|---|---|
| 1 | Date of identifiable event | The "immediately before" date for your insolvency test |
| 2 | Amount of debt discharged | The income figure you start from |
| 3 | Interest if included in box 2 | The interest part of box 2; see below |
| 5 | Debtor personally liable | If checked, the general income rule applies |
| 6 | Identifiable event code | Why it was filed, e.g. F (by agreement) or G (policy to discontinue collection) |
Creditors generally file the form when they cancel $600 or more. A smaller cancellation can still be income; Publication 4681 says plainly: "Even if you didn't receive a Form 1099-C, you must report canceled debt as gross income on your tax return unless one of the exceptions or exclusions described later applies."
On box 3, the publication says whether the interest portion is income "depends on whether the interest would be deductible if you paid it." Personal credit card interest generally isn't deductible, so for a personal card the box 3 amount usually stays in the total. Read the Deductible Debt section of Pub 4681 if the card was used for a business.
Confirming the numbers with old statements
Before trusting box 2, rebuild it from your own records. Creditors do make mistakes, and a settlement can be reported at the wrong figure.
- Find the last statement before the settlement or charge-off. It shows the balance including interest and fees. That balance is also your credit card line on the insolvency worksheet.
- Find the settlement letter. It states what you agreed to pay and that the rest is forgiven.
- Find the payments on your bank statement. Lump sums or installments to the creditor or collector prove what you actually paid.
- Subtract. Balance at settlement minus what you paid should be close to box 2. If it is far off, ask the creditor for a corrected form before you file.
Old statements are often only PDFs in an online archive, and closed accounts may give you a short window to download them. QuickBankConvert can turn those card and bank statement PDFs into spreadsheet rows, so the payment dates and amounts drop straight into the sheet; our page on credit card statements to Excel shows what comes out. Keep the PDFs too; our guide on how long to keep bank statements for taxes covers retention.
How do you build the 1099-C calculator in a spreadsheet?
Set up one sheet with labels in column A and amounts in column B. The rows follow Publication 4681's Insolvency Worksheet, which has 14 liability lines and 21 asset lines.
Inputs from the form
- B2: box 2 amount
- B3: box 3 interest (for reference)
- B4: box 1 date
Part I, liabilities immediately before the cancellation (B7 to B20). One row each for: credit card debt; mortgages; car and other vehicle loans; medical bills; student loans; past-due mortgage interest; past-due real estate taxes; past-due utilities; past-due childcare costs; federal or state income taxes still due for prior years; judgments; business debts; margin debt and other investment debt; other liabilities. Then:
B21: =SUM(B7:B20)
Part II, fair market value of assets (B24 to B44). One row each for: cash and bank balances; real property including land; cars and other vehicles; computers; household goods and furnishings; tools; jewelry; clothing; books; stocks and bonds; collectibles; firearms, sports, photographic and hobby equipment; retirement accounts; pension interest; education accounts; cash value of life insurance; security deposits; partnership interests; value of investment in a business; other investments; other assets. Then:
B45: =SUM(B24:B44)
Part III and the result
B47: =MAX(0, B21-B45)(amount of insolvency; zero means not insolvent)B48: =MIN(B2, B47)(excludable amount, the Form 982 line 2 figure)B49: =B2-B48(taxable cancelled debt)- B50: your marginal rate, entered as a decimal
B51: =B49*B50(rough federal tax on the cancelled debt)
The formulas are identical in Excel and Google Sheets. Count each debt and each asset once only; the worksheet says the same.
A worked example
Suppose a card with a 9,400.00 balance was settled for 3,900.00, and the 1099-C shows 5,500.00 in box 2. Immediately before the settlement date:
| Liabilities | Amount | Assets (FMV) | Amount |
|---|---|---|---|
| Credit card | 9,400 | Checking and savings | 1,150 |
| Car loan | 11,200 | Car | 9,500 |
| Student loan | 6,800 | Household goods | 2,000 |
| Medical bills | 1,300 | 401(k) | 6,400 |
| Clothing and other | 300 | ||
| Total | 28,700 | Total | 19,350 |
Insolvency is 28,700 − 19,350 = 9,350. The excludable amount is the smaller of 5,500 and 9,350, so all 5,500 is excluded and the taxable amount is zero.
Change one number: if the 401(k) were worth 14,000, assets total 26,950 and insolvency drops to 1,750. Only 1,750 is excluded, and 3,750 is taxable. At a placeholder rate of 0.20 in B50, B51 shows 750.00. Use your own bracket from the IRS federal income tax rates and brackets page rather than that placeholder; the brackets change every year.
Where do the numbers go on the return?
Publication 4681 spells out the reporting for a non-business debt:
- Taxable part (B49): Schedule 1 (Form 1040), line 8c.
- Excluded part (B48): attach Form 982, check the box on line 1b, and enter the amount on line 2.
- Tax attributes: complete Part II of Form 982. Excluding debt reduces certain tax attributes, such as losses, credits and the basis of property you keep, in a set order. The spreadsheet doesn't model this; the Form 982 instructions do.
Bankruptcy uses a different box (line 1a) and takes priority over insolvency. Other exclusions, for qualified farm debt, qualified real property business debt and some principal residence debt, have their own rules in Pub 4681.
Limits of a home-made calculator
The sheet answers one question well: how much of box 2 is taxable under the insolvency rule. It doesn't handle state tax, the effect of extra income on credits or deductions that phase out, or a debt shared with a spouse, where Pub 4681 has each person work out a separate insolvency figure on their share. Fair market value is also a judgment call; write down how you valued the car and household goods and keep the evidence. This is how the rules work, not advice about your return. If the amounts are large, take the sheet and your statements to a tax professional.
Related guides
Frequently Asked Questions
Is a settled credit card debt taxable?
Generally yes. Publication 4681 says the cancelled part of a debt you were personally liable for is ordinary income unless an exception or exclusion applies, such as bankruptcy or insolvency.
Do I report cancelled debt if I never got a 1099-C?
Yes. The IRS says that even if you didn't receive a Form 1099-C, you must report cancelled debt as income unless an exception or exclusion applies. Creditors generally file the form when the cancelled amount is $600 or more.
What does insolvent mean for a 1099-C?
You were insolvent to the extent your total liabilities were more than the fair market value of all your assets immediately before the cancellation. Retirement accounts and pension interests count as assets for this test.
Which line of Form 982 is for insolvency?
Check line 1b and enter on line 2 the smaller of the cancelled debt or the amount you were insolvent. You also complete Part II to reduce tax attributes.
Can I get an exact tax figure from a spreadsheet?
Only a rough one. Extra income can move part of your income into a higher bracket and affect credits, so run the final numbers through your tax software or a preparer.
Ready to convert your bank statement?
Free to preview. No bank login. Results in about a minute.
Convert a statement