Penafort Recon Suite v6

Upload

›

Extract

›

Merge

›

Analyse

›

Reports

Pipeline

⬆ 1. Upload

⚙ 2. Extract

🔗 3. Merge

Analysis

📊 4. Analyses

Output

📁 5. Reports

Drive Storage
01 RAW_INPUTS
02 EXTRACTED
03 MERGED
04 ANALYSIS
05 REPORTS

1. Upload Bank Statements

Confirm bank & period first · Files routed to correct Drive folder

Files on Drive

Uploaded

Banks

Periods

—

Formats

—

Statement Files

PDFXLSXXLSCSVDOCX

Add Bank Statement

Enter bank name & period → choose file → upload to Drive

Uploading…

Log

Clear

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

2. Extract Transactions

Select statements → each extracted to its own Excel in 02_EXTRACTED/

Select Statements to Extract

Select the uploaded statements you want to extract. Each file produces a separate Excel. Multiple strategies are tried per page for maximum coverage.

Uploaded Files

All | None

Loading…

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

3. Merge into Consolidated Excel

Select extracted files · Name your output · Deduplicates · Saves to 03_MERGED/

Select Extracted Files

Extracted Files (02_EXTRACTED/)

All | None

Loading…

📝 Consolidated File Name

Timestamp appended · Saved as .xlsx in 03_MERGED/

4. Analyses

Select consolidated file · Check analyses to run · Upload extra files if needed

Select Consolidated File

Choose the consolidated Excel from 03_MERGED/ to analyse. All selected analyses will run on this file.

Consolidated Files (03_MERGED/)

Loading…

Supplementary Files (Optional)

For Debtor & Quantity analyses

👥 Debtor / Receivables CSV

Click to upload
customer, amount, due_date columns

📦 Quantity / Ascertainment

Click to upload
product, litres/MT, price columns

⏱ Trading / Deal File

Click to upload
Deal_Reconciliation.xlsx

Select Analyses to Run

Select All | None

[--:--:--] [OK] Select a consolidated file and tick analyses above

5. Export Reports

Select consolidated file · Generate any format · Saved to 05_REPORTS/

Select File for Reports

Consolidated Files (03_MERGED/)

Loading…

Word

DOCX

PDF

PowerPoint

PPTX

Excel

XLSX

CSV Exports