The PIE Board
Driving Performance Innovation and Excellence
Back to Home
Intake Workflow

Imports

This first version captures import metadata, validates the filename against known companies and operating units, and saves the record to the database before full parsing is added.

Standard settlements are expected to resolve to one operating unit and one Friday week ending date. Adjustment settlements can be logged separately for later allocation logic.

Validation Coverage
5

Active operating units are available for filename matching.

Valid uploads are retained in app-managed storage for later parsing, review, and hosted access workflows.

New Import Intake

Choose a file and source type. The system will inspect the filename, attempt to match it to your operating structure, and create an import record while saving valid uploads to the configured file storage backend.

Batch Import Intake

Use this for historical backfills. Each file still goes through filename validation, storage, parsing, and review detection.

Batch mode skips duplicates automatically unless overwrite is selected, then matching existing imports are replaced and re-parsed.

Recent Import Activity

This combines saved imports with skipped duplicates and failed intake attempts from the last 30 days so there is one place to see what happened.

For WSW files, Needs Review means the file parsed, but at least one worksheet row did not match a settlement route or the parser raised another warning. Today that is an inspection state, so use the notes below to decide whether the file is acceptable or needs correction and re-upload.

20260911 FXG Settlement (Switchback).xlsxSep 16, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Sep 11, 2026
Notes: Imported and parsed successfully.
20260911 FXG Settlement (Story HIC).xlsxSep 16, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Sep 11, 2026
Notes: Imported and parsed successfully.
20260911 FXG Settlement (PRO16-9 LNC).xlsxSep 16, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Sep 11, 2026
Notes: Imported and parsed successfully.
20260911 FXG Settlement (Mountaineer).xlsxSep 16, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Sep 11, 2026
Notes: Imported and parsed successfully.
20260911 FXG Settlement ( Story GRN).xlsxSep 16, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Sep 11, 2026
Notes: Imported and parsed successfully.
20260904 FXG Settlement (Pro16-9 LNC).xlsxSep 9, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Sep 4, 2026
Notes: Imported and parsed successfully.
20260904 FXG Settlement (Mountaineer).xlsxSep 9, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Sep 4, 2026
Notes: Imported and parsed successfully.
20260904 FXG Settlement (Switchback).xlsxSep 9, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Sep 4, 2026
Notes: Imported and parsed successfully.
20260904 FXG Settlement (Story HIC).xlsxSep 9, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Sep 4, 2026
Notes: Imported and parsed successfully.
20260904 FXG Settlement (Story GRN).xlsxSep 9, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Sep 4, 2026
Notes: Imported and parsed successfully.
20260828 FXG Settlement (Pro16-9 LNC).xlsxSep 2, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Aug 28, 2026
Notes: Imported and parsed successfully.
20260828 FXG Settlement (Mountaineer).xlsxSep 2, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Aug 28, 2026
Notes: Imported and parsed successfully.
20260828 FXG Settlement (Switchback).xlsxSep 2, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Aug 28, 2026
Notes: Imported and parsed successfully.
20260828 FXG Settlement (Story HIC).xlsxSep 2, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Aug 28, 2026
Notes: Imported and parsed successfully.
20260828 FXG Settlement (Story GRN).xlsxSep 2, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Aug 28, 2026
Notes: Imported and parsed successfully.
20260821 FXG Settlement (Pro16-9 LNC).xlsxAug 26, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Aug 21, 2026
Notes: Imported and parsed successfully.
20260821 FXG Settlement (Story HIC).xlsxAug 26, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Aug 21, 2026
Notes: Imported and parsed successfully.
20260821 FXG Settlement (Story GRN).xlsxAug 26, 2026
DuplicateStandard Settlement
Operating Unit: Story GRN
Week Ending: Aug 21, 2026
Notes: 20260821 FXG Settlement (Story GRN).xlsx: skipped because a matching import already exists.
20260821 FXG Settlement (Mountaineer).xlsxAug 26, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Aug 21, 2026
Notes: Imported and parsed successfully.
20260824 FXG Settlement (Story HIC).xlsxAug 26, 2026
FailedStandard Settlement
Operating Unit: Story HIC
Week Ending: Aug 24, 2026
Notes: 20260824 FXG Settlement (Story HIC).xlsx: The parsed week ending date is not a Friday, which is unusual for this import type.
20260824 FXG Settlement (Pro16-9 LNC).xlsxAug 26, 2026
FailedStandard Settlement
Operating Unit: Pro16-9 LNC
Week Ending: Aug 24, 2026
Notes: 20260824 FXG Settlement (Pro16-9 LNC).xlsx: The parsed week ending date is not a Friday, which is unusual for this import type.
20260821 FXG Settlement (Switchback).xlsxAug 26, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Aug 21, 2026
Notes: Imported and parsed successfully.
20260821 FXG Settlement (Story GRN).xlsxAug 26, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Aug 21, 2026
Notes: Imported and parsed successfully.