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
- On New Invoice Email
- Split Invoice Attachments
- Archive Invoice to Drive
- Prepare AI Extraction
- AI Extract Invoice Fields
- Parse Extracted Fields
- Read Vendor Master
- Read Purchase Orders
- Read GRNs
- Read AP Ledger
- 3-Way Match & GST/TDS Checks
- Append to AP Ledger
- Route by Decision
- Post Auto-approved FYI to Slack
Insgesamt 37 Schritte.
Ähnliche Automatisierungen
Chatbots & Messaging-BotsRestaurantbestellungen per Chat mit GPT-4o aufnehmen14 SchritteFinanzen, Rechnungen & BuchhaltungHubSpot aktualisieren und Slack bei bezahlten Stripe-Rechnungen benachrichtigen8 SchritteFinanzen, Rechnungen & BuchhaltungSync Shopify orders to Xero invoices with Slack and email alerts12 SchritteFinanzen, Rechnungen & BuchhaltungEssenslieferbestellungen aus Gmail in Slack protokollieren6 Schritte