Zero-type vendor invoice processing to QuickBooks

Operations or finance lead at product/retail/construction/services companies (10-100 employees) receiving 20-300 invoices/month · First batch processed in ~20 min after connecting Gmail, QuickBooks, and dropping PO register into Sheet.

FinanceEdit flowon X● golden 83

step 1connector

Pull invoice PDFs from inbox

⚡ bring your own tool

step 2ready

Extract structured fields from each PDF

PDF Processing Pro

step 3ready

Organize and deduplicate invoice records

invoice-organizer

step 4connector

Match invoices to purchase orders

⚡ Apollo.io

step 5partial

Assign GL codes via spend categorization

procurement-optimizer

step 6ready

Stage AP batch for human review in Google Sheets

googlesheets-automation

step 7connector

Push approved invoices to QuickBooks

⚡ bring your own tool

Did this recipe work for you?

What you get

▸Normalized invoice records CSV — every field extracted from all PDFs, deduplicated
▸PO match report — auto-matched, near-match, and unmatched invoices flagged for review
▸GL-coded AP staging ledger in Google Sheets — ready for one-click finance approval
▸QuickBooks bill creation log — inv# → QB bill ID mapping with push timestamps

tools: QuickBooks Online from $35/mo · Composio/Rube MCP free tier or ~$20/mo · Google Sheets free

tokens: ~$1-4 per 20-invoice batch (PDF extraction + GL coding)

≈ $35-60/mo in tooling at steady volume; tokens negligible vs. manual labor saved

What stays yours

· Review and approve the AP staging ledger before each QuickBooks push — a 5-minute scan replaces hours of manual entry
· Resolve unmatched invoices (vendor not in PO register, amount discrepancy) — the agent flags these but cannot authorize payment
· Accountant sign-off on GL code assignments before month-end close; confirm with your bookkeeper or CPA that the chart-of-accounts mapping is correct

✓ Last verified 2026-06-11claude-sonnet-4-6 (subagent, test-mode fixtures)

✓ step 1 · Pull invoice PDFs from inbox

✓ step 2 · Extract structured fields from each PDF

✓ step 3 · Organize and deduplicate invoice records

✓ step 4 · Match invoices to purchase orders

✓ step 5 · Assign GL codes via spend categorization

✓ step 6 · Stage AP batch for human review in Google Sheets

✓ step 7 · Push approved invoices to QuickBooks

view sample outputs from this run

step 2 · Extract structured fields from each PDF

# Step 2 — Raw Invoice Records (PDF Processing Pro)

OCR + table extraction applied to 3 unique PDFs (File 4 excluded as duplicate).
Extracted: 2026-06-11T08:15:22Z

---

## Invoice A — INV-2026-0841_TechFlow_Solutions.pdf

**Header fields**
| Field | Extracted value |
|-------|----------------|
| Vendor name | TechFlow Solutions Inc. |
| Vendor address | 412 Market Street, Suite 700, San Francisco, CA 94105 |
| Vendor phone | +1 (415) 555-0182 |
| Vendor email | ap@techflowsolutions.com |
| Vendor tax ID (EIN) | 82-4471039 |
| Invoice number | INV-2026-0841 |
| Invoice date | 2026-06-01 |
| D…

step 3 · Organize and deduplicate invoice records

# Step 3 — Normalized Invoice Records (invoice-organizer)

Normalization applied: 2026-06-11T08:16:05Z
Input: 3 unique raw invoice records + pdf-file-batch.md
Schema version: v1.2

---

## Canonical Schema (per invoice)

```
vendor_name       string   Normalized vendor name (title-case, no Inc/LLC)
vendor_id         string   Internal vendor slug
invoice_number    string   Original invoice number from document
canonical_inv_id  string   Standardized: VENDOR-YYYY-INVNUM
invoice_date      date     ISO 8601
due_date          date     ISO 8601
payment_terms     string
po_reference      string   PO …

step 5 · Assign GL codes via spend categorization

# Step 5 — GL-Coded Invoice Records (procurement-optimizer)

GL assignment applied: 2026-06-11T08:18:00Z
Chart of accounts: Cybos Inc. — standard CoA (QuickBooks Online layout)
Taxonomy: UNSPSC-aligned spend categorization

---

## Chart of Accounts Reference (relevant accounts)

| GL Code | Account name | Type |
|---|---|---|
| 6010 | Software Development Services | Operating Expense |
| 6020 | IT Infrastructure & Cloud Hosting | Operating Expense |
| 6030 | Office Supplies | Operating Expense |
| 6031 | Shipping & Freight (inbound) | Operating Expense |
| 5900 | Cost of Revenue — Engineering…

The problem

When PDF invoices arrive in my inbox from vendors, I want an AI to extract every field, match to the purchase order, assign the right GL code, and push it to QuickBooks so that I stop manually typing invoice details for hours every month

Cybernetic layers

Memorybyo

Vendor-to-GL mapping table and PO register must live somewhere the agent can read — a Google Sheet or local CSV works. No harvested memory artifact persists vendor history or learned GL assignments across runs yet.

Backgroundbyo

Running the batch on a schedule (e.g., nightly or on email arrival) requires a cron/Claude Code scheduled task or a Gmail trigger. Not yet a library artifact — wire it with Claude Code's CronCreate or a Zapier/Make email trigger.

Harnessready

Claude Code is the runtime. Drop invoice-organizer and PDF Processing Pro into ~/.claude/skills/ and invoke sequentially. The Google Sheets automation skill runs via Rube MCP (Composio).

Click any step to see what fills it — and the ranked alternatives you can swap in.