Библиотека / Финансы, счета и бухгалтерия
Финансы, счета и бухгалтерия
Сопоставление счетов поставщиков с заказами на поставку (PO) и приёмками товаров (GRN) с помощью OpenAI, Gmail, Drive и Sheets
Запускается для каждого нового счёта из Gmail с меткой: архивирует его в Drive, извлекает поля с помощью OpenAI, сопоставляет с заказом на поставку и приёмкой товара, проверяет GST, TDS и дубликаты, затем записывает в журнал AP с уведомлением в Slack.
Что делает
## 🧾 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.
Шаги
- 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
Всего шагов: 37.
Похожие автоматизации
Финансы, счета и бухгалтерияSync Shopify orders to Xero invoices with Slack and email alertsШагов: 12Финансы, счета и бухгалтерияОбновление HubSpot и оповещение в Slack при оплате счетов StripeШагов: 8Финансы, счета и бухгалтерияЗапись заказов доставки еды из Gmail в SlackШагов: 6Финансы, счета и бухгалтерияFlag possible duplicate supplier invoices in Google Sheets before payment with SlackШагов: 9