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.

20260724 FXG Settlement (Mountaineer).xlsxJul 29, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Jul 24, 2026
Notes: Imported and parsed successfully.
20260724 FXG Settlement (Mountaineer).xlsxJul 29, 2026
DuplicateStandard Settlement
Operating Unit: Mountaineer
Week Ending: Jul 24, 2026
Notes: A file for this operating unit, source type, and week ending date already exists. Choose whether to overwrite the existing record or skip this upload.
20260724 FXG Settlement (PRO16-9 LNC).xlsxJul 29, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Jul 24, 2026
Notes: Imported and parsed successfully.
20260724 FXG Settltment (Mountaineer).xlsxJul 29, 2026
FailedStandard Settlement
Operating Unit: Mountaineer
Week Ending: Jul 24, 2026
Notes: 20260724 FXG Settltment (Mountaineer).xlsx: Filename must include the exact phrase "FXG Settlement".
20260724 FXG Settlement (Switchback).xlsxJul 29, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Jul 24, 2026
Notes: Imported and parsed successfully.
20260724 FXG Settlement (Story HIC).xlsxJul 29, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Jul 24, 2026
Notes: Imported and parsed successfully.
20260724 FXG Settlement (Story GRN).xlsxJul 29, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Jul 24, 2026
Notes: Imported and parsed successfully.
20260717 FXG Settlement (Mountaineer).xlsxJul 22, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Jul 17, 2026
Notes: Imported and parsed successfully.
20260717 FXG Settlement (Switchback).xlsxJul 22, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Jul 17, 2026
Notes: Imported and parsed successfully.
20260717 FXG Settlement (Story HIC).xlsxJul 22, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Jul 17, 2026
Notes: Imported and parsed successfully.
20260717 FXG Settlement (Story GRN).xlsxJul 22, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Jul 17, 2026
Notes: Imported and parsed successfully.
20260717 FXG Settlement (PRO16-9 LNC).xlsxJul 22, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Jul 17, 2026
Notes: Imported and parsed successfully.
20260710 FXG Settlement (PRO16-9 LNC).xlsxJul 15, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Jul 10, 2026
Notes: Imported and parsed successfully.
20260710 FXG Settlement (Mountaineer).xlsxJul 15, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Jul 10, 2026
Notes: Imported and parsed successfully.
20260710 FXG Settlement (Switchback).xlsxJul 15, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Jul 10, 2026
Notes: Imported and parsed successfully.
20260710 FXG Settlement (Story HIC).xlsxJul 15, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Jul 10, 2026
Notes: Imported and parsed successfully.
20260710 FXG Settlement (Story GRN).xlsxJul 15, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Jul 10, 2026
Notes: Imported and parsed successfully.
20260703 FXG Settlement (Mountaineer).xlsxJul 8, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Mountaineer
Week Ending: Jul 3, 2026
Notes: Imported and parsed successfully.
20260703 FXG Settlement (Switchback).xlsxJul 8, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Switchback
Week Ending: Jul 3, 2026
Notes: Imported and parsed successfully.
20260703 FXG Settlement (Story HIC).xlsxJul 8, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story HIC
Week Ending: Jul 3, 2026
Notes: Imported and parsed successfully.
20260703 FXG Settlement (Story GRN).xlsxJul 8, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Story GRN
Week Ending: Jul 3, 2026
Notes: Imported and parsed successfully.
20260703 FXG Settlement (PRO16-9 LNC).xlsxJul 8, 2026
ParsedStandard SettlementCloud Storage
Operating Unit: Pro16-9 LNC
Week Ending: Jul 3, 2026
Notes: Imported and parsed successfully.