PO budget bridge proof.

A redacted or synthetic proof that checks Google Sheets expense rows against Airtable projects and purchase orders. Valid rows become sync-ready ledger entries; cancelled POs, wrong sheets, over-PO amounts, paused projects, and unknown projects stay visible before any budget or accounting update happens.

Bridge Ledger CSV Exception Queue CSV Error Log CSV Projects CSV Airtable POs CSV Sheet Expense Rows CSV Runbook Source Script

Input

Sample Airtable project records, approved PO rows, and Google Sheets budget expense rows.

Output

Safe expense rows become sync-ready bridge ledger entries with project, PO, vendor, and budget code evidence.

Failure Path

Unknown projects, cancelled POs, wrong sheets, paused projects, and over-amount rows are blocked for review.

Expense Row	Project	PO	Decision	Reason
row-2001	PRJ-410	PO-1001	Sync ready	Project, sheet, PO status, budget code, and amount all match.
row-2002	PRJ-410	PO-1002	Exception	Expense amount is higher than the approved PO amount.
row-2007	PRJ-999	PO-1001	Error	Budget sheet row references a project that is not in the project table.