SEFA Coverage

Audit SEFA field and note coverage.

Description

A Schedule of Expenditures of Federal Awards organizes federal-award expenditures and related disclosures.

A Schedule of Expenditures of Federal Awards organizes federal-award expenditures and related disclosures. Its required fields depend on applicable reporting rules.1

Audit SEFA field and note coverage.

When to use SEFA Coverage

Use this tool to audit SEFA field and note coverage.

Prepare the documented facts, aligned totals or expected/observed evidence labels requested. Choose applicable requirements and thresholds separately before interpreting a planning screen.

How to use SEFA Coverage and understand its results

  1. Prepare the documented facts, aligned totals or expected/observed evidence labels requested. Choose applicable requirements and thresholds separately before interpreting a planning screen.
  2. Enter requiredFields, presentFields using the field table and calculation rules, then run the tool.
  3. Read coveragePercent, matched, missing, unexpected. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
Input fieldMeaningValue type; see rules belowRequirement
requiredFieldsRequired SEFA fieldslist of stringRequired
presentFieldsPresent fieldslist of stringRequired

Enter requiredFields as the nonempty expected list and presentFields as observations, which may be empty. Trim entries, compare case-insensitively using en-US lowercase and collapse duplicates. Return matched/missing expected labels and unexpected observed labels. Output follows first occurrence order with the last duplicate’s trimmed spelling.

coverage%=100matchedUnique/expectedUnique

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output fieldMeaningValue type
coveragePercentCoverage (%)number; minimum: 0; maximum: 100
matchedMatched itemslist of string
missingMissing itemslist of string
unexpectedUnexpected itemslist of string
json
{
  "input": {
    "requiredFields": [
      "alpha",
      "beta",
      "gamma",
      "delta"
    ],
    "presentFields": [
      "beta",
      "alpha",
      "extra"
    ]
  },
  "output": {
    "coveragePercent": 50,
    "matched": [
      "alpha",
      "beta"
    ],
    "missing": [
      "gamma",
      "delta"
    ],
    "unexpected": [
      "extra"
    ]
  }
}

Limitations and assumptions

No award expenditure, federal rule or schedule accuracy is verified. Blank entries are errors; requirements are entirely caller-supplied and items have equal weight.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Grant Cost Allowability: Summarize allowable and questioned costs in a tested grant sample. For a complementary task, use Sampling Coverage: Measure audit sample coverage by item count and value.

References

  1. SEFA Coverage — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies