Chapter 4 · Role-Specific Scenarios

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:

StepTraditional approachPain point
1. Invoice processingManually extract invoices from email/system, enter one by oneHundreds of invoices a month, time-consuming and error-prone
2. ReconciliationCompare supplier invoices against internal records in ExcelHours of work at high volume, hard to locate discrepancies
3. Payment trackingManual check of due invoices, manual payment schedulingEasy to miss due invoices, affecting supplier relationships
4. Report generationManually summarize data and write financial reportsData 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

TypeResourceWhat it does hereNotes
AppBaseInvoice register, check records, and due datesThroughout; build the register first
AppLibraryInvoice originals and reconciliation reportsThroughout; monitor financial file access
MaterialsValidation rules and purchase ordersTax rates, amount tolerances, and order-matching evidenceUpload 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

  1. 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.

  2. AI auto-recognizes and extracts.
    The AI reads each invoice and extracts key fields:

FieldDescription
Supplier nameBilling company name
Invoice numberUnique ID
Invoice dateDate of issue
Due datePayment deadline
Net amountAmount before tax
Tax amountVAT / IVA amount
Gross amountInvoice total including tax
CurrencyEUR / USD / GBP etc.
PO numberPurchase order number (if available)
  1. AI auto-validates.
    The AI checks data consistency:
ValidationDescription
Amount calculationNet + Tax = Gross
Tax rate checkDoes the rate match the supplied applicable-rate table? Mark missing evidence for verification
Duplicate detectionCheck supplier and invoice number first, then flag matching amounts and nearby dates as possible duplicates
PO matchingDoes the invoice amount match the PO
  1. Flag anomalies for human review.
    Valid invoices are auto-entered; anomalies (calculation errors, suspected duplicates, PO mismatches) are flagged for you to confirm.

  2. 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

Batch process the following invoice files (PDF), extract key fields:
- 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

Summarize this month's invoice amounts by supplier and currency without adding different currencies together.
For each currency, sort descending and create a Top 10 supplier pie chart.

Sample Prompt

List all due-but-unpaid invoices.
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.