Zum Inhalt springen
NEUMarktplatz und trig8n Agent: Verkaufen Sie, was Sie bauen, und erhalten Sie Pläne und Änderungen, die getestet sind, bevor Sie sie sehen. Neuigkeiten ansehen

Bibliothek / Finanzen, Rechnungen & Buchhaltung

Finanzen, Rechnungen & Buchhaltung

Lieferantenrechnungen mit OpenAI, Gmail, Drive und Sheets Bestellungen (POs) und Wareneingängen (GRNs) zuordnen

Wird für jede neue, markierte Rechnung in Gmail ausgeführt, archiviert sie in Drive, extrahiert die Felder mit OpenAI, ordnet sie der Bestellung und dem Wareneingang zu, prüft GST, TDS und Duplikate und bucht sie dann mit einer Slack-Benachrichtigung in das AP-Hauptbuch.

Was sie bewirkt

## 🧾 FinanceOS – Vendor Invoice 3-Way Match For finance teams at Indian companies who still match vendor invoices against POs and GRNs by hand in Excel. Duplicate bills slip through, wrong GST splits get paid, and TDS is calculated at the wrong rate. ### How it works Invoices arriving in a labelled Gmail inbox are archived to Drive and read by GPT-4o. Each line is matched to its purchase order and the goods actually received. The workflow checks price and quantity, GSTIN validity, CGST/SGST vs IGST, TDS section and duplicates, then posts the invoice to the AP ledger with a decision: auto-approve, send for approval, or hold. Approvers approve or reject from Slack with one click. Held invoices get an AI-drafted query to the vendor for review. Every Friday, approved invoices due in the coming week are grouped into a bank-ready payment CSV. ### Setup steps 1. In Gmail, create an invoices label and filter vendor emails into it. 2. Create a Google Sheet with Vendor Master, Purchase Orders, GRNs, AP Ledger and Vendor Bank Details tabs, plus two Drive folders. 3. Connect Gmail, Google Sheets, Drive, Slack and OpenAI. 4. In 3-Way Match & GST/TDS Checks, set your GSTIN, auto-approve limit, tolerances, approver levels and n8n domain. 5. Forward a sample invoice to test, then activate.

Die Schritte

  1. On New Invoice Email
  2. Split Invoice Attachments
  3. Archive Invoice to Drive
  4. Prepare AI Extraction
  5. AI Extract Invoice Fields
  6. Parse Extracted Fields
  7. Read Vendor Master
  8. Read Purchase Orders
  9. Read GRNs
  10. Read AP Ledger
  11. 3-Way Match & GST/TDS Checks
  12. Append to AP Ledger
  13. Route by Decision
  14. Post Auto-approved FYI to Slack

Insgesamt 37 Schritte.

Ähnliche Automatisierungen