SEFA to Financial Statements Reconciliation Calculator (Single Audit)

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

Reconcile federal expenditures on the schedule of expenditures of federal awards to federal revenue in the financial statements and size the unreconciled difference.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Unreconciled difference
$16,000
SEFA total less the reconciled amount
Reconciled federal expenditures
$8,924,000
Unreconciled as % of SEFA
0.18%
Drawn to one scale
Reconciled federal expenditures$8,924,000
Unreconciled difference$16,000
All results
MeasureResult
Reconciled federal expenditures$8,924,000
Unreconciled difference
SEFA less reconciled amount
$16,000
Unreconciled as % of SEFA0.18%
How this was worked out
Work shownrecomputed as you type
Reconciled = federal revenue in the statements + noncash assistance + timing items + other items
Unreconciled difference = SEFA total - reconciled

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

The formulas

  • Reconciled = federal revenue in the statements + noncash assistance + timing items + other items
  • Unreconciled difference = SEFA total - reconciled

How it works

2 CFR 200.514(b) requires the auditor to determine whether the schedule of expenditures of federal awards is fairly stated in all material respects in relation to the financial statements as a whole. That opinion rests on reconciling the schedule to the accounting records and the statements.

Common reconciling items are loans and loan guarantees reported on the schedule but carried on the balance sheet, noncash assistance such as donated commodities, and expenditures recognized in a different period than the related revenue. Every remaining difference needs an explanation before the in-relation-to opinion is given.

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

Common questions

Why would revenue differ from expenditures for a reimbursement grant?

Revenue follows allowable expenditures, so they usually match. Differences come from timing, disallowed costs and amounts recorded in a different fund or entity.

Where do pass-through awards go?

On the SEFA under the pass-through entity, with the pass-through identifying number. They are reconciled the same way.

What size of difference is acceptable?

None unexplained. Small unexplained differences are still questions about completeness of the schedule.

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