Predictive Ledger — Aito Accounting Demo
Interactive workbook demonstrating how Aito's predictive database powers accounting automation: GL code prediction, vendor matching, rule mining, and anomaly detection.
Database: aito-accounting-demo
Welcome
Predictive Ledger
Predictive Ledger
This workbook demonstrates how Aito turns accounting software into predictive accounting software.
The 70% → 90% gap: Rules-based automation tops out at ~70%. The remaining 30% is too sparse or contextual to write rules for. Aito fills this gap — without replacing rules.
Dataset: 230 Finnish invoices across 17 vendors, 120 bank transactions, 44 human overrides.
Aito operators used:
_predict— GL code, approver, vendor matching, anomaly detection_relate— rule mining, override pattern discovery_match— invoice-to-bank-transaction linking_evaluate— prediction accuracy measurement
Instance Activity
Real-time metrics: status, lastRequest, requests5min, memory.
Data Overview
Explore the accounting dataset
Sample invoices
Interactive query — results displayed as table.
Invoices by vendor
Interactive query — results displayed as chart.
Invoices by GL code
Interactive query — results displayed as chart.
Routing breakdown (rules vs Aito vs human)
Interactive query — results displayed as chart.
GL Code Prediction
Predict which GL account an invoice should be assigned to
How it works
GL Code Prediction
Given a vendor name and amount, Aito predicts the most likely GL code. The $why explanation shows which features drove the prediction.
Try changing the vendor name to see how predictions change.
Predict GL code for Kesko Oyj
Interactive predict — results displayed as table.
Predict GL code for unknown vendor (low confidence)
Interactive predict — results displayed as table.
GL code prediction accuracy
ML evaluation for predict queries.
Approver Routing
Predict which approver should handle an invoice
Predict approver for Kesko Oyj
Interactive predict — results displayed as table.
Predict approver for Kone Oyj
Interactive predict — results displayed as table.
Approver prediction accuracy
ML evaluation for predict queries.
Processor Routing
Predict which approver should handle an invoice
Predict approver for Kesko Oyj
Interactive predict — results displayed as table.
Predict approver for Kone Oyj
Interactive predict — results displayed as table.
Approver prediction accuracy
ML evaluation for predict queries.
Payment Matching
Match bank transactions to invoices via _predict invoice_id
How it works
Payment Matching
_predict invoice_id traverses the schema link from bank_transactions to invoices, returning full invoice rows ranked by how well they match the bank transaction.
Aito uses description text tokens and amount as context. When the amount matches training data, it appears as a lift factor in $why.
Try modifying the description and amount to see how predictions change.
Match bank transaction to invoice (with $why)
Interactive predict — results displayed as table.
Telia Finland — amount in $why when it matches training data
Interactive predict — results displayed as table.
Vendor resolution: _predict vendor_name (comparison)
Interactive predict — results displayed as table.
Unknown transfer (should be low confidence)
Interactive predict — results displayed as table.
Browse bank transactions (training data)
Interactive query — results displayed as table.
Rule Mining
Discover patterns with _relate for rule candidates
How it works
Rule Mining
_relate finds statistical relationships between features. For each vendor or category, it shows how strongly it predicts a GL code — with exact support ratios.
Support ratios like 18/18 are exact historical counts, not ML estimates. An accountant can verify each one.
What GL code does category=telecom predict?
Interactive relate — results displayed as table.
What GL code does vendor=Kesko Oyj predict?
Interactive relate — results displayed as table.
Override patterns: which GL corrections cluster?
Interactive relate — results displayed as table.
Anomaly Detection
Inverse prediction: low confidence = anomaly signal
How it works
Anomaly Detection
Same _predict engine, used in reverse. If Aito is confident about the GL code (high $p), the invoice fits known patterns. If confidence is low, something is unusual — that's the anomaly signal.
No separate anomaly model needed. Compare the two queries below: known vendor vs unknown vendor.
Normal invoice: Kesko Oyj (high confidence = no anomaly)
Interactive predict — results displayed as table.
Anomalous: unknown vendor (low confidence = anomaly)
Interactive predict — results displayed as table.