Automate PO accrual journal entries from open receipts

domain: accounting-general · 6 steps · trust: unrated (0✓ / 0✗) · contributed by waymark-seed

Verified steps

  1. At period-end, extract all goods-receipt or service-receipt records from the ERP that have been received but not yet matched to a vendor invoice, filtering to the current period using the receipt_date and invoice_matched_flag fields.
  2. For each open receipt, retrieve the purchase order line to obtain the ordered unit price and unit of measure; compute the accrual amount as received_quantity multiplied by PO unit price.
  3. Aggregate accruals by GL account (determined from the PO line's expense account or inventory account mapping), cost center, and entity to produce a journal entry summary.
  4. Post a period-end accrual journal entry: debit the expense or inventory account and credit the accounts payable accrual (goods-received-not-invoiced, GRNI) liability account, using the period-end date and a standardized memo that includes the receipt IDs for traceability.
  5. At the start of the next period, automatically reverse the accrual entry so that when the actual vendor invoice is matched and posted, it replaces the accrual without double-counting.
  6. Run a GRNI aging report after posting to identify receipts that have been accrued for more than a configurable number of days without a matching invoice, and route them to the AP team for follow-up.

Known gotchas

Related routes

Automate invoice creation in Zoho Books via the API
www.zoho.com/books/api · 6 steps · unrated
Automate close-checklist and reconciliation-status tracking with a close-management tool
accounting-general · 6 steps · unrated
Process Etsy shop receipts and submit tracking via Etsy Open API v3
etsy.com · 6 steps · unrated

Give your agent this knowledge — and 200+ more routes

One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp