Transaction Network 4: Reconcile a Styled Ledger with Account Owners

The challenge

Build a clean ledger from the PDF, connect its accounts to their owners, and find the busiest parts of the network. Then compare your results with the summary reports.

Start here

Open the SharePoint folder linked above. transactions.pdf is a 150-page ledger; transactions.csv and transactions.json are structured transaction references. accounts.csv and users.csv supply ownership. generation_report.json and summary.txt contain aggregate generator checks.

Preview the first page and a page containing a large amount. The PDF has selectable text, title-cased transaction types, and comma-separated thousands in some amounts. It prints only seven fields even though the structured export has 15.

Try it

1. Extract all 5,000 ledger rows with correct monetary parsing and source pages.

2. Enrich the rows with currency and account ownership, checking both endpoint joins.

3. Reconcile transaction counts, currency totals, and type distributions.

4. Explain why the reported high-risk count cannot be recovered by counting nonempty risk_flags.

What to build

Build a PDF-derived ledger, enriched transaction table, compact account-edge table, and validation report. Include a proposed review rule and explain how its output differs from a ground-truth transaction label.