Portfolio Gmail Historical Audit — Final Report

Run finalized: 2026-05-24T16:35:00

Outcome

• Historical Gmail candidate audit completed.
• Attachments were staged, reconciled, copied into the OneDrive financial statement tree, and used to backfill Portfolio.xlsx where needed.
• Portfolio dashboard was rebuilt and verified before archiving.
• Gmail inbox messages archived in this final step: 95 / 95
• Archive errors or still-in-inbox results: 0

Key verified portfolio result

• Latest dashboard total value: R200,265,574.60
• Latest valuation date: 2026-04-30
• Dashboard XIRR: 11.1%
• Portfolio history now spans 57 valuation dates.

Artifact locations

• Download manifest: /Users/elmar/PKA/.scratch/portfolio-gmail-audit/20260524-151056/download_manifest.json
• Reconciliation report: /Users/elmar/PKA/.scratch/portfolio-gmail-audit/20260524-151056/reconciliation_report.json
• Archive result JSON: /Users/elmar/PKA/.scratch/portfolio-gmail-audit/20260524-151056/gmail_historical_archive_results.json
• Live workbook: /Users/elmar/Library/CloudStorage/OneDrive-Personal/Conradie Family Documents/Financial Statements/Portfolio.xlsx
• Dashboard: /Users/elmar/PKA/dashboards/portfolio.html

Archive detail

Only Gmail messages that were in INBOX in the audit manifest and whose attachments had known outcomes were archived. Messages that were already archived historically were not touched; excluded-only messages were left alone.