AI-driven invoice reconciliation that catches billing mismatches before they cost you money. Built for Office Technology companies who manage vendor service contracts.
Built on Microsoft Power Platform + Copilot Studio, deployed in your tenant, secured by your on-premises data gateway.
AI-powered email parsing (OCR + Copilot Studio) auto-ingests invoices, or import from e-automate AP vouchers
Lines matched to contracts by serial number, equipment, and vendor
Grouped by invoice with priority flags and status at a glance
Invoice vs. contract comparison with mismatch highlighting
Approve, dispute, flag, or email vendor - all from one screen
Every action logged with full change history and user tracking
The app is deployed directly into your Microsoft 365 environment. CEO Juice builds it - you own it. No third-party servers, no external databases, no data leaving your organization.
All app data flows through your existing on-premises data gateway. Invoice data, contract details, and meter readings travel encrypted between your e-automate SQL Server and Power Apps - no new inbound ports, no cloud copies of your database. Optional integrations are explicit per-client switches, listed in full below.
Only users you explicitly authorize can access the application. Admin access management lets you control who can view invoices, modify contracts, and change system settings.
Every import, approval, dispute, and configuration change is recorded with timestamps, user identity, and full details. Your audit log lives in your SQL Server - available for compliance reporting anytime.
Vendor invoices are parsed automatically using Copilot Studio. The system reads emailed invoice PDFs, extracts line-level meter data, and loads it into your recon tables - no manual data entry required.
Everything ID283 talks to, in one table. All integration traffic is outbound HTTPS from Power Automate flows running in your own Power Platform environment, initiated one direction per transaction. Nothing polls or listens back into your network.
| Connection | Path & direction | Auth & footprint |
|---|---|---|
| App data - contracts, invoices, reconciliation | Power Apps in your tenant → on-premises data gateway → your e-automate SQL Server | Your existing gateway. Encrypted tunnel, no new inbound ports. |
| e-automate write-back - AP invoices & sales orders (optional) | Power Automate flow in your tenant → ID136 Client API on your own web server | Outbound HTTPS with a bearer token. Only three paths are ever called:POST /api/Auth/tokenPUT /api/Id455/APInvoicePUT /api/SalesOrder/AddOrder |
| Payments hand-off (optional) | Power Automate flow in your tenant → CEOJuice-hosted Payments API | Cloud to cloud - never touches your network. Sends approved invoices to your CEOJuice Payments portal for processing; it never moves money itself. |
| AI invoice parsing | Copilot Studio agent in your tenant, watching the invoice mailbox you designate | Runs entirely inside Microsoft 365. Nothing installed on-premises. |
The foundation. If any of these are missing, the install can't even start.
We deploy as a regular user in your tenant (no service principal needed). Create one user account, set it up properly, and share the credentials with us.
ceojuice@yourcompany.com - in your Microsoft 365 admin center.We share the app and all its data connections with one Entra group once. From then on, you manage who has access by adding or removing members from that group - you never have to come back to us per user.
Once the three steps above are done, send us these four things and the install is on us.
| Item | Where to find it |
|---|---|
| Tenant ID | Entra Admin Center → Overview → Tenant ID |
| CEOJuice account username and password | The user account you created in step 2 (with Power Platform Admin and MFA registered) |
| Security group Object ID | Entra Admin Center → Groups → your group → Overview → Object ID |
| Invoice mailbox & folder | The inbox (and folder inside it) where vendor invoice PDFs land - e.g., ap-invoices@yourcompany.com, folder Inbox. The parser flow watches this for new invoices. |
Once we’ve installed in your tenant, ongoing access is managed by your IT through the security group (step 3) - no further help from us required to onboard or offboard a user.
Your command center for invoice review. Vendor invoice lines are grouped by invoice, scored by priority, and sorted so the costliest mismatches surface first. Pick an invoice to open a full-width line item table where you match, resolve, and (for admins) push clean invoices straight into e-automate.
Open any flagged line from the Inbox and see exactly what the vendor billed next to what the contract says you owe. Every difference is highlighted, so the conversation with your vendor is backed by the numbers.
The single source of truth for every vendor agreement. The list on the left finds any contract fast, and the panel on the right edits terms inline with auto-save, so what you set is what the matching engine validates against.
Every line on a contract, captured exactly the way the vendor bills it. Open a line to edit base rates, meter pricing, volume tiers, and the customer-side rates you charge, all auto-saved as you type.
When an imported contract names a vendor (dealer) that does not match a vendor in your e-automate system, it lands here. Pick the right vendor once, link it, and every contract under that name updates in a single step.
Your pricing playbook in one place. Each agreement holds the approved items, approved customers, and machine configurations your team is cleared to sell and buy against, so both a quote and an invoice are checked against the same numbers.
A shared library of reusable host-and-accessory configurations. Build a machine bundle once — the same builder you use inside an agreement — and pull it into any agreement instead of recreating it each time.
Build a customer quote in minutes. A rep picks a machine, the accessories that belong with it come along automatically, and the whole package carries one price. When the quote is accepted it becomes a contract and an e-automate sales order, with no re-keying.
See every quote at a glance on one board. Cards move through Draft, Sent, Ordered, and Converted as reps work them, and the board keeps itself current, so managers always know where the money is.
Reconciliation and quoting both end the same place — back in e-automate. v2 pushes sales orders out and vendor payments through automatically, so approved work reaches operations and accounting without anyone re-keying it.
Pull posted AP vouchers straight from e-automate into the reconciliation queue. One click moves a vendor bill into the inbox, ready to validate against contract pricing.
Turn a vendor spreadsheet into clean, matched contracts in three steps. AI reads any layout, matches vendors and equipment, and shows you exactly what will be created before anything is committed.
One screen to tune how validation behaves, set your branding and home currency, switch on the features each client is licensed for, control who sees what, and keep an eye on every change. Admin-only, with a left side-nav of sub-screens for Defaults, Branding, Reference Data, Operations, Audit Log, and Access.
Match the vendor by name (fuzzy ranked: exact → partial → contains). Match equipment by serial or asset number, item by SKU. Find the governing contract via four passes - header number, line number, cascade, or equipment → detail → contract.
Inside that contract, pick the most specific row in priority order: Equipment > Item > Meter Type > Description > Effective Date. That row supplies the ExpectedRate for this line.
Driven by the contract's PricingModel - base rate, meter overage (Usage − Allowance) × Rate, supplies-included, and other models. Multi-year rate schedules escalate automatically.
If the item or equipment is on a vendor rebate program, cross-check the ProgramPurchasePrice (Fixed or % of List), the expected rebate, and the customer's approval status on that program.
Variance = LineAmount − ExpectedAmount. Stored on every line so reviewers see the exact dollar gap, not just a pass/fail flag.
Tolerance breach, missing quantity, meter-allowance mismatch, supplies on/off contract, below minimum billing, duplicate invoice, customer not approved - each is its own flag so the reviewer sees exactly what's off.
Clean lines within tolerance with no exception flags are auto-approved - no human touch. Anything else lands in the Recon Inbox, prioritized by variance size and severity.
Every check runs automatically on ingestion. Your team focuses on resolving the exceptions that matter - not manually reviewing every line item.
Every feature in ID283 started as a real request from Office Technology companies. We prioritize based on what will save you the most time and catch the most money - not a generic product roadmap.
New capabilities are deployed directly to your tenant as part of your subscription. Version 2 alone added CPQ quoting with a package-based builder and pipeline board, agreement pricing with reusable configuration templates, direct e-automate write-back for AP vouchers and sales orders, PO matching, MSP cost allocation, and per-person access controls — on top of v1's AI-powered invoice parsing, side-by-side comparison, and bulk contract import.
ID283 connects with other CEO Juice processes you already know. ID890 cross-dealer sync enablement streamlines ITT contract data sharing and invoice reconciliation across your network - all part of the CEO Juice ecosystem.
We're actively exploring automated vendor mismatch notifications and deeper quote-to-order automation for sales reps - all driven by feedback from Office Technology companies. Have a feature request? We want to hear it.
AI-powered reconciliation, included in your CEO Juice subscription. Runs in your Microsoft tenant. Your data never leaves your infrastructure.
Get Started ➝