🏦 Playbook: Invoice & Statement Reconciliation

The Invoice & Statement Reconciliation playbook demonstrates AMBA's deterministic SQLite calculation engine for Chief Accountants and Financial Controllers.

---

🎯 When to Use This Playbook

• Monthly Bank Statement Reconciliation: Matching thousands of bank ledger transactions against internal billing registers.
• Multi-Gateway Payment Audit: Reconciling Stripe, VNPay, or MoMo settlement sheets against ERP sales orders.
• Vendor Payment Verification: Catching duplicate invoices, unbilled deliveries, and currency conversion deltas.

---

🔒 Zero-Hallucination Guarantee

Unlike generic chatbots that guess numbers or truncate long tables:

1. AMBA ingests .xlsx and .csv files into a private, embedded SQLite database.
2. Every sum, average, and variance is computed via exact SQL queries.
3. Financial project workspaces are strictly air-gapped (allowInternet: false).

---

🚀 Step-by-Step Workflow

Step 1: Create a Reconciliation Project

1. In AMBA, click + New Project.
2. Select the Invoice & Statement Reconciliation template.
3. Note that the Deterministic Analytics & SQLite Engine is enabled and Internet Access is air-gapped.
4. Click Create Project.

Step 2: Add Source Documents

Drop your files into input/:

• bank_statement_august.xlsx (Columns: Date, Txn_ID, Description, Debit, Credit, Balance)
• invoices_august.csv (Columns: Invoice_Number, Customer, Amount, Issue_Date, Status)

Step 3: Execute the Reconciliation Directive

Switch to ⚡ Exec mode and prompt the agent:

Load the August bank statement and invoice register into the analytical database.
Reconcile all transactions based on transaction ID, invoice number, and amounts.
Identify all mismatches and compile a complete Exception List.
Save the final reconciliation workbook to `output/Reconciliation_Report.xlsx`
and generate a summary briefing PDF in `output/`.

Step 4: What AMBA Produces

1. Analytical Database Loading: Ingests files into indexed SQL tables in milliseconds.
2. Schema Verification: Checks column formats and normalizes transaction numbers.
3. Deterministic Reconciliation: Executes SQL JOIN queries comparing statement credits against invoice amounts.
4. Deliverables in output/:
   • output/Reconciliation_Report.xlsx:
     • Sheet 1: Matched Records (All fully verified transactions).
     • Sheet 2: Exception List (Unmatched bank deposits, partial payments, and missing invoices with exact numerical deltas).
     • Sheet 3: Audit Trail (The exact SQL queries used for verification).
   • output/Reconciliation_Summary.pdf: An executive summary for the Chief Accountant.