4.3 Finance: Invoice Processing, Reconciliation & Reporting
This lesson starts with batch invoice processing: extract fields, check amounts, tax rates, and purchase orders against supplied rules, then write results to Base. After entry, summarize supplier totals and query overdue items.
The Finance Workflow
Whether you're in accounts payable or financial planning, the daily finance work follows similar logic:
| Step | Traditional approach | Pain point |
|---|---|---|
| 1. Invoice processing | Manually extract invoices from email/system, enter one by one | Hundreds of invoices a month, time-consuming and error-prone |
| 2. Reconciliation | Compare supplier invoices against internal records in Excel | Hours of work at high volume, hard to locate discrepancies |
| 3. Payment tracking | Manual check of due invoices, manual payment scheduling | Easy to miss due invoices, affecting supplier relationships |
| 4. Report generation | Manually summarize data and write financial reports | Data comes from multiple sources and takes time to combine |
The exercise below covers extraction, checks, and summaries. Cross-system reconciliation also requires internal records; ongoing due-date monitoring requires a scheduled task.
Resources Used
| Type | Resource | What it does here | Notes |
|---|---|---|---|
| App | Base | Invoice register, check records, and due dates | Throughout; build the register first |
| App | Library | Invoice originals and reconciliation reports | Throughout; monitor financial file access |
| Materials | Validation rules and purchase orders | Tax rates, amount tolerances, and order-matching evidence | Upload your organization's rule table and purchase orders; mark checks without evidence for verification |
For retrieving invoice attachments from email, see Email management and structured follow-ups. Archive originals with Library upload and organization, and query or update records with the Base exercise.
Sub-scenario A: Batch Invoice Processing — Hundreds of Invoices, Auto-Recognized & Auto-Entered
Pain Point
"Every month, I receive 200–300 invoices in supplier emails, with different layouts from each supplier. I have to manually extract supplier name, invoice number, amount, date, tax — and enter them into the system. This alone takes two days."
Steps
-
Upload the invoice files.
Upload the invoice PDFs or scans you want to process to the AOS Work conversation as a batch. If a mail Connector is connected, you can instead specify supplier emails and ask the agent to extract their invoice attachments. -
AI auto-recognizes and extracts.
The AI reads each invoice and extracts key fields:
| Field | Description |
|---|---|
| Supplier name | Billing company name |
| Invoice number | Unique ID |
| Invoice date | Date of issue |
| Due date | Payment deadline |
| Net amount | Amount before tax |
| Tax amount | VAT / IVA amount |
| Gross amount | Invoice total including tax |
| Currency | EUR / USD / GBP etc. |
| PO number | Purchase order number (if available) |
- AI auto-validates.
The AI checks data consistency:
| Validation | Description |
|---|---|
| Amount calculation | Net + Tax = Gross |
| Tax rate check | Does the rate match the supplied applicable-rate table? Mark missing evidence for verification |
| Duplicate detection | Check supplier and invoice number first, then flag matching amounts and nearby dates as possible duplicates |
| PO matching | Does the invoice amount match the PO |
-
Flag anomalies for human review.
Valid invoices are auto-entered; anomalies (calculation errors, suspected duplicates, PO mismatches) are flagged for you to confirm. -
Write to the Base.
All invoice data is written to the table, organized by supplier, date, and status. Invoice originals are stored in Library and linked to the records.
Sample Prompt
- Supplier Name, Invoice Number, Invoice Date, Due Date, Net Amount, Tax Amount, Gross Amount, Currency, PO Number
Automated validation:
1. Verify amount calculation (Net + Tax = Gross)
2. Check tax rates against my supplied applicable-rate table; mark checks without supporting rules for verification
3. Check duplicates by supplier and invoice number first, then list matching amounts and nearby dates as possible duplicates; do not delete without confirmation
4. Match numbers and amounts against the supplied purchase orders; mark records without an order for verification
Output Requirements:
1. Auto-write validated invoices to Base
2. Flag anomalous invoices separately, list exception reasons
3. Store invoice originals in Library and link to corresponding records
4. Generate processing summary: total invoices, passed count, exception count
Expected Results
-
Every invoice has an extraction result; unreadable fields and checks without supporting rules are marked separately
-
Valid invoices auto-entered, anomalies flagged separately
-
Processing summary: total, passed, exceptions
-
Invoice originals auto-archived, traceable anytime
Advanced: Invoice Data Summary & Visualization
After entry, use natural language to analyze:
Sample Prompt
For each currency, sort descending and create a Top 10 supplier pie chart.
Sample Prompt
Sort by due date ascending and flag overdue days.
Exercise: Process five invoices and query overdue amounts
Select Library to read five invoices, the corresponding purchase orders, and the example tax-rate rules. Extract invoice numbers, suppliers, amounts, currencies, and due dates. Select Library and Base to save them to the Invoices table with links to the originals.
Check net amount plus tax against the gross amount, the supplied tax rate, duplicate invoices, and purchase-order totals. Summarize only records that pass, keep currencies separate, and use 2026-10-26 to find invoices past their due dates that remain unpaid.
Summary
Base holds the invoice fields, exception reasons, and links to originals. Use the records to summarize supplier amounts and query due dates.
4.2 Legal: Supplier Contract Review, Template Generation & Expiry Tracking
Review supplier contracts against standard terms, generate agreements from templates, and track contract expiry and renewal dates.
4.4 Designers: AI Image Generation for Fashion
Generate colorway previews from sketches and fabric references, then organize design results in Library and Base.