Penafort Recon Suite v5

Upload

›

Extract

›

Merge

›

P&L

›

Trading

›

Reports

Pipeline

⬆ 1. Upload Files

⚙ 2. Extract

🔗 3. Merge

Analysis

📈 4. Profit & Loss

⏱ 5. Trading

Output

📁 6. Reports

Storage
/data/Penafort_Recon/
01 RAW_INPUTS
02 EXTRACTED
03 MERGED
04 ANALYSIS
05 REPORTS

1. Upload Bank Statements

Confirm bank & period before each upload

Files

Uploaded

Banks

Periods

—

Formats

—

Statement Files

PDFXLSXXLSCSVDOCX

Add Bank Statement

Enter bank name & period first, then choose file

Uploading…

Log

Clear

[--:--:--] [OK] Ready — click "Add Bank Statement" to begin

2. Extract Transactions

Select uploaded statements to extract · Each saves a separate Excel to 02_EXTRACTED/

Select Statements to Extract

How it works: Tick statements, click Extract Selected. Each file is extracted and saved as its own Excel in 02_EXTRACTED/.

Uploaded Files

Select All | None

Loading…

[--:--:--] [OK] Select files above and click Extract

3. Merge into Consolidated Excel

Select extracted files · Name your consolidated file · Saved to 03_MERGED/

Select Extracted Files to Merge

Select extracted Excels from 02_EXTRACTED/ to combine. The app deduplicates and merges them.

Extracted Files (02_EXTRACTED/)

Select All | None

Loading…

📝 Consolidated File Name

Timestamp appended automatically · Saved as .xlsx in 03_MERGED/

4. Profit & Loss Analysis

Select a consolidated Excel from 03_MERGED/ · P&L saved to 04_ANALYSIS/

Select Consolidated File

Choose one consolidated Excel from 03_MERGED/. The app produces a full P&L breakdown by period.

Consolidated Files (03_MERGED/)

Loading…

5. Trading Reconciliation

Select consolidated Excel + optionally upload deal files

Select Consolidated File

Consolidated Files (03_MERGED/)

Loading…

Upload Additional Trading Files (Optional)

XLSX · CSV

📊

Upload Deal / Trading File

Deal_Reconciliation.xlsx · Trading CSVs

Select a consolidated file and click Run Trading Analysis

6. Export Reports

Select consolidated file · Generate DOCX · PDF · PPTX · CSV · XLSX

Select Consolidated File for Reports

Select a consolidated file from 03_MERGED/, then click Use Selected File to load it. Then generate any report format below.

Consolidated Files (03_MERGED/)

Loading…

Word

DOCX

PDF

PowerPoint

PPTX

Excel

XLSX

CSV Exports