50ページのスキャン済み請求書を検証済みの買掛金元帳に変換

会計士が入力した内容

This PDF is Item XII ('Payment(s) Above $50,000') from the Bunker Hill Village council packet for 18 August 2026. Page 1 is the typed cover memo listing nine invoices, A to I. Pages 2-50 are scans of those invoices plus backup (TGC approval memos, sub-consultant invoices, status reports, water flow records).

Please build an AP ledger in Excel with one row per memo item A-I. Do not add rows for the sub-consultant invoices (United Engineers, TEI, Cypress Environmental) - they are backup inside the HR Green packages. Columns:
1. Memo item (A-I)
2. Vendor
3. Invoice no. (for the City of Houston bills, use the account number)
4. Invoice / bill date
5. Service period or description
6. Amount due - read from the scanned invoice itself, not the memo
7. PDF page of the invoice's first page

Add a total row, and a reconciliation line showing the memo total, the ledger total and the difference.

会計士が入力した内容

In the same workbook, extend the ledger:
1. Add a 'GL category' column using these categories: Water purchase; Wastewater treatment; Engineering - Memorial/Gessner Ph II - BHV Work Order #1; Engineering - Memorial/Gessner Ph II - TIRZ Work Order #2; Capital - water plant.
2. Add a 'Handwritten notes' column: transcribe any handwriting on that item's pages (e.g. marks on the TGC approval memo or the invoice itself). Write 'none' if there is no handwriting, and 'illegible' if you can't read it - please don't guess. Typed 'Approved by' stamps don't count.
3. Add a 'Summary' sheet with SUMIF totals by GL category, and a check that the category totals add back to the ledger total.

Don't change the turn-1 rows or amounts.