Level 3 Fair Value Rollforward Calculator (ASC 820)

Does it tie out, and if not, where is the difference?

Opening to closing Level 3 balance through gains, purchases, sales, issues, settlements and transfers, tied to the ledger.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Closing Level 3 balance
$5,510,000
Reconciled from opening balance
Difference to ledger
$0
Total gains (losses)
$210,000
Drawn to one scale
Closing Level 3 balance$5,510,000
Difference to ledger$0
Total gains (losses)$210,000
Net transfers-$150,000
All results
MeasureResult
Closing Level 3 balance$5,510,000
Difference to ledger$0
Total gains (losses)$210,000
Net transfers-$150,000
How this was worked out
Work shownrecomputed as you type
Closing = opening + gains in earnings + gains in OCI + purchases + issues - sales - settlements + transfers in - transfers out

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Closing = opening + gains in earnings + gains in OCI + purchases + issues - sales - settlements + transfers in - transfers out

How it works

ASC 820-10-50-2(c) requires, for recurring Level 3 measurements, a reconciliation from opening to closing balances showing total gains and losses in earnings and in OCI, purchases, sales, issues and settlements each separately, and transfers into and out of Level 3.

ASU 2018-13 removed the full rollforward for nonpublic entities, which instead disclose transfers into and out of Level 3 and purchases and issues. Public entities keep the full reconciliation.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

Should sales and settlements be netted?

No. The disclosure presents purchases, sales, issues and settlements separately.

When are transfers measured?

At the point set by the entity's policy for when transfers between levels are deemed to occur, applied consistently to transfers in and out.

What about unrealized gains on items still held?

Public entities also disclose the change in unrealized gains and losses for the period in earnings and OCI on items held at period end.

Sources

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required