ID283 - AI-Powered & Live

Stop Overpaying
Your Vendor Invoices

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.

0%
Invoice Coverage
0
Integrated Screens
0
Data Sources
<3s
Per Invoice Review
What's New in v2
Version 2 closes the loop into e-automate: reconciled invoices push back as AP vouchers and payments, and won deals become sales orders — no re-keying either way. Around that it adds CPQ quoting, agreement-level pricing, and deeper billing validation. Everything ships with your CEO Juice subscription, each capability switches on per client, and the v1 validation you rely on stays the core of the app.
🧾  Sales Orders into e-automate
Win a deal or activate a contract and push it straight to e-automate as a sales order — no manual re-entry — carrying the agreed pricing and order type with it. From there the pipeline board tracks that order’s real e-automate status, so sales and operations see the same picture.
💳  Payments & AP Write-Back
Reconciled vendor invoices post back into e-automate as AP vouchers and invoices, so approved bills reach accounting without anyone re-keying them. Approved bills can also flow into your CEOJuice Payments portal for processing, with the vendor’s portal notified of the approval — a duplicate-push guard and approval thresholds keep it safe. Validate to accounting to payment, in one place.
🛒  CPQ: Quote-to-Order
Your reps quote in the app: pick a machine, its accessories come along automatically, and the customer sees one clean package price on a PDF branded with your logo and colors. Quote against an agreement and pricing locks to the approved rates; win the deal and one click creates the e-automate sales order — no re-keying, no side spreadsheets.
📋  Quote Pipeline Board
Every quote on one board — Draft, Sent, Ordered, Converted — with stages that update themselves from what actually happened, including the live e-automate sales-order status. Reps see their own deals; managers see the whole pipeline and its dollar value at a glance.
💼  Vendor Programs / Agreements
Your negotiated pricing lives on the agreement — approved items, approved customers (co-op and multi-level customer hierarchies included), and ready-made machine configurations built from e-automate’s own related-items data. Contracts and quotes tied to an agreement can’t drift from what was bid, and a full pricing agreement imports from a spreadsheet in minutes.
🔍  Deeper Billing Validation
New optional checks catch what slips through elsewhere: invoice lines matched against your purchase orders, billed seats and licenses compared to what your customer contracts actually cover (built for IT/MSP resale), and coverage-date checks that stop payments on machines whose contracts ended. Same philosophy as always — flag for review, never silently block.
🛡  You Stay in Control
Every v2 capability is a per-client switch — adopt at your own pace. Set your branding once, control which tabs each person sees, and rely on payment guardrails like duplicate-push warnings and approval thresholds. Amounts display in your home currency throughout.
Plus dozens of workflow, matching, and reliability improvements throughout the app. Want the detail for your team? Ask us — we’ll walk you through what’s relevant to how you use it.
v1 Foundation (still core)
  • AI invoice parsing from emailed PDFs (Copilot Studio OCR)
  • Automatic vendor, equipment, and contract matching
  • 15 automated validation checks (rates and escalation, program pricing, duplicates, meter allowance and overage, supplies included, minimum billing, customer program approval)
  • Variance analysis with tolerance thresholds and auto approval of clean lines
  • Side by side invoice vs contract comparison
  • Bulk actions: assign, status, priority, resolve
  • AP voucher import from e-automate
  • AI assisted bulk contract import from spreadsheets
  • Multi year rate schedule escalation (percentage or fixed)
  • ITT contract settings (20+ configurable fields)
  • Vendor program management with per item pricing
  • Full audit trail and admin controlled access
From Invoice to Resolution in 6 Steps
Every vendor invoice flows through an AI-driven pipeline that parses, matches, validates, and highlights discrepancies - so you only review what matters.
01
📦

Ingest

AI-powered email parsing (OCR + Copilot Studio) auto-ingests invoices, or import from e-automate AP vouchers

02
🔗

Auto-Match

Lines matched to contracts by serial number, equipment, and vendor

03
📋

Recon Inbox

Grouped by invoice with priority flags and status at a glance

04

Side by Side

Invoice vs. contract comparison with mismatch highlighting

05

Resolve

Approve, dispute, flag, or email vendor - all from one screen

06
📊

Audit Trail

Every action logged with full change history and user tracking

Your Data, Your Tenant, Your Control
ID283 runs entirely within your Microsoft 365 environment. Your data flows securely between your e-automate SQL Server and Power Apps through your own on-premises data gateway - and every connection the app makes is listed below, so your IT and security team can scope the install once, with no surprises.
🏢

Lives in Your Tenant

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.

🔒

Secure Gateway Connection

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.

🛡

Admin-Controlled Access

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 Action Logged

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.

🤖

AI-Powered Processing

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.

How It All Connects
🖥 Power Apps Code Component
Your Microsoft 365 tenant • Browser-based • React + Fluent UI
⚡ Power Automate + Copilot Studio
Email invoice OCR • AI-powered parsing • Auto-matching • Notifications
🔐 On-Premises Data Gateway
Your infrastructure • Encrypted tunnel • No cloud storage
🗄 e-automate SQL Server
Your database • AP invoices • Contracts • Equipment • Meters
For Your IT & Security Team

Every Connection, Listed

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/token
PUT /api/Id455/APInvoice
PUT /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 API credential ID283 uses is restricted with function- and row-level security to just the three endpoints above - it cannot reach service calls, customers, or any other part of the API.
  • Inbound traffic to the ID136 site can be locked down at your firewall to Microsoft's published Power Platform outbound IP ranges for your region.
  • ID136 is the same CEOJuice Client API already running at Office Technology companies across our client base - ID283 consumes it rather than standing up a one-off endpoint inside your network.
  • Every integration is a per-client switch. Endpoints for features you have not enabled are never called.
What You Need Before We Install
ID283 lives in your Microsoft tenant. Before we install it the first time, a few things need to be in place on your side. Here's the plain-English checklist - have your IT tick each box, then we take it from there.
1

Your Microsoft Tenant Is Ready

The foundation. If any of these are missing, the install can't even start.

  • Dataverse capacity available - A new Production environment needs ~1 GB of free Dataverse storage. Your IT can check in the Power Platform Admin Center under Resources → Capacity. (Most tenants have plenty; heavy Power Platform users sometimes hit the cap.)
  • On-premises Data Gateway installed - A gateway service running on a Windows server inside your network, registered to your Power Platform tenant. This is how the app reaches your e-automate SQL Server.
  • Power Apps Premium licenses - One license per employee who will use the app. Either the per-user plan or Pay-As-You-Go (PAYG) works. AI Builder / Copilot credits (for the invoice parsing) are included in your Microsoft licensing.
2

A "CEOJuice" User Account in Your Tenant

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.

  • Create a user - e.g., ceojuice@yourcompany.com - in your Microsoft 365 admin center.
  • Grant Power Platform Administrator - Entra Admin Center → Roles and admins → Power Platform Administrator → Add this user. This is what lets us create the dedicated CEOJuice environment in your tenant.
  • Pre-register MFA - Sign in once as that user at aka.ms/mysecurityinfo using a modern browser (Edge or Chrome), and add an authentication method (Authenticator app or phone). If MFA isn’t registered first, the install sign-in gets stuck on the “set up authentication methods” screen in a browser it can’t render.
  • Share the username and password securely with the CEO Juice deployment team.
3

A Security Group for App Users

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.

  • Group type must be Security - Entra Admin Center → Groups → New group → Group type = Security. Microsoft 365 groups and distribution lists will not work: the sharing UI accepts them, but members silently get a “no access” error on the data.
  • Add users as direct members - Nested membership (a person in another group that’s in this group) is not honored by Power Platform. Each user must be a direct member of this group.
  • Grab the Object ID - On the group’s Overview page in Entra, copy the Object ID value. You’ll hand that to us.

What you hand off to CEO Juice

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.

Feature Walkthrough
Every Screen, Explained
Click through each screen to see what it does and why it matters.

Recon Inbox

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.

  • 📑
    Smart Grouping & Sort Lines roll up by invoice with status, priority, resolved and matched counts. Sort by Priority, Date (newest or oldest), Amount, or Impact
  • 🔍
    Search That Reaches the Line One box searches invoice number, vendor, serial number, equipment number, and model description across every line
  • 🔗
    Link to Contract Link the whole invoice to one contract, or link a single line to a contract pricing line. Expected vs. actual recomputes automatically
  • 📄
    Create Contract from Invoice Admins turn an unmatched invoice into a new vendor contract, pre-filled with vendor, dates, and equipment
  • Resolve & Bulk Actions Approve, assign, resolve, or compare per line, or select many lines to set status and priority in one pass
  • 🚀
    Push to e-automate Once an invoice is reconciled, admins post it to e-automate as an AP voucher via the ID136 API, no re-keying
apps.powerapps.com - ID283 Reconciliation Inbox
ID283 Reconciliation Inbox
▼ Selected Invoice - Line Item Details
apps.powerapps.com - ID283 Recon Inbox (Detail)
CEOJuice
ID283 ITT Vendor Service & Billing Validation
ReconciliationVendor ContractsCPQAdmin
Your Name
JN
← Back to Inbox 🔗 Link Invoice to Contract Invoice: 8847291
Vendor
Metro Document Solutions✉ Email Vendor
Invoice Date
03/15/2026
Total Amount
$247.83
Line Items
3
Coverage
03/01/2026 to 03/31/2026
Days Outstanding
38
StatusPending Review
PriorityHigh
Contracts
3/3 matched
Push to e-automate →
Equipment Amount Expected Variance Flags Status Priority Assigned Actions
999943
bizhub 8830-Di
View Contract
$89.50 $82.00 $7.50
(9.1%)
Pgm Mismatch 👤 🔗
999944
bizhub C550i
View Contract
$105.33 $98.33 $7.00
(7.1%)
Below Min 👤 🔗
999945
bizhub C250i
View Contract
$53.00 $53.00 $0.00
(0.0%)
- 👤 🔗
Bulk Actions: Apply to Selected (1) 👤 Assign All to Me ✔ Resolve All Compare Side-by-Side → 📄 Create Contract

Side by Side Comparison

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.

  • Invoiced vs Expected Two clean columns, Invoice Value next to Contract / Expected, for every field on the line
  • 📊
    Variance Banner Overcharge, undercharge, or no variance called out up top with the dollar amount and percent
  • 🔴
    Mismatch Flags Any field that does not match the contract is shaded red, so problems jump out instantly
  • 📋
    Grouped Detail Financial, Meter / Volume, Coverage, and Equipment sections lay out the full picture per line
  • 📄
    Contract Context The linked contract number, program, customer, and period sit right above the comparison
  • Decide and Act Approve, Flag, Dispute, or email the vendor without leaving the comparison view
apps.powerapps.com - ID283 Side-by-Side
ID283 Side-by-Side

Vendor Contracts

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.

  • 🔍
    Searchable Contract List Search by program, vendor, contract number, or any pricing line's serial or equipment number, with an Active only toggle
  • 📝
    Inline Auto-Save Editing Contract Information and ITT Settings save the moment you change a field, no Save button to remember
  • 📁
    View Invoices & View Details Jump to this contract's invoices in the Inbox, or open its pricing lines with a live line-item count
  • 🔗
    Merge Contracts Check two or more, pick the keeper, and the rest fold in (pricing lines and matched invoices move over, duplicates deleted)
  • Break Out Pricing Lines Select lines on the Details screen and split them into their own new contract when one agreement covers two deals
  • Evergreen & Unlimited Evergreen (no end date) keeps matching ongoing, and Unlimited base volume removes the page cap when there is no overage
  • 📝
    Create Sales Order Admin-gated push that builds an e-automate sales order from the contract's active item lines through the ID136 API
apps.powerapps.com - ID283 Vendor Contracts
ID283 Vendor Contracts

Contract Details

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.

  • 📋
    Per-Line Detail Cards One expandable card per pricing line with equipment, item, quantity, base rate, dates, and an Active badge
  • 💲
    Two-Sided Rates (Track mode) Customer-side rate columns sit alongside the vendor comp rates, so you see what you pay and what you bill on one card
  • 📊
    Meter Tier Editor Volume-banded overage rates per meter, up to 3 meter groups, with a From/To/Rate grid that replaces the flat rate
  • 📅
    Per-Line Coverage Dates Give each line its own service-coverage window; invoices billed outside it are flagged, so lapsed coverage stops getting paid
  • 📈
    Rate Schedules & Escalation Apply a multi-year rate schedule to a line, or set base and overage escalation percents, with the current escalated rate shown alongside the original
  • Contract & ITT Settings General contract settings (toner, meters, order type, base volume, NASPO IFF) up top; out-of-territory partner-dealer terms grouped separately below
  • 🔒
    Agreement Conformance A line under an agreement pre-fills the approved pricing and won’t save a price or item that breaks it, so a contract can’t drift from what was bid
apps.powerapps.com - ID283 Contract Details
ID283 Contract Details

Unmatched Vendors

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.

  • 🔍
    Searchable Vendor Picker Type a vendor name to search your live e-automate vendor list, even when the list is thousands of records long
  • 🔗
    Link by Raw Name Contracts are grouped by the raw vendor name that came in on the import, so you resolve each name once
  • 📦
    One Link Updates Many Linking applies to every contract carrying that name, including detail rows, in one server-side operation
  • 💾
    Saves Reliably The link is written through the stored procedure (VendorMatchType MANUAL), so it sticks on every SQL server and the row clears on refresh
  • 🔢
    Live Counts See how many vendor names are unmatched and how many contracts they cover at a glance
  • Clean Empty State When everything is linked, the screen confirms there is nothing left to reconcile
apps.powerapps.com - ID283 Unmatched Vendors
ID283 Unmatched Vendors

Vendor Agreements

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.

  • 💰
    Approved Items & Customers Set the selling price, purchase price, rebate, and comps per item, and limit an agreement to specific customers
  • 📦
    Configuration Builder Pair a host with its accessories straight from e-automate related items, grouped into bands with per-item quantity rules; the e-automate cost and a suggested price sit next to your pricing for reference, and every column sorts
  • 📋
    Reusable Templates Save a configuration to the template library once and pull it into any agreement instead of rebuilding the same bundle
  • Ready for Orders Gate An agreement can’t be quoted or ordered against until it’s marked ready, with a one-click note to your order-processing team when it flips on
  • 📊
    Import & Export Bring in a full agreement price file from a spreadsheet with AI-assisted review, and export defined pricing (with cost and comps) to Excel for audit
apps.powerapps.com - ID283 Vendor Agreements
ID283 Vendor Agreements
▼ View Details - Items, Configurations & Customers
apps.powerapps.com - ID283 Program Details
CEOJuice
ID283 ITT Vendor Service & Billing Validation
ReconciliationVendor ContractsCPQAdmin
Your Name
JN
← Back to Programs
Program: Konica Toner Inclusive
Active
Vendor
Metro Document Solutions
Customer
All
Program Code
KM-TI-2026
Type
Toner Inclusive
Costing Type
Fixed
Start Date
01/01/2026
End Date
12/31/2026
Rebate
5% + $2.00
Approved Items & Equipment (6)
+ Add Item
bizhub C550i Equipment Sell: $98.33 Rebate: 5% Active 🗑
TK-5292K Black Toner Item Sell: $84.00 Rebate: $2.00 Active 🗑
Item
Equipment
Equipment Model Pattern
Selling Price
Purchase Price
Rebate Type
Configurations (2)
+ Add Configuration
C550i + maintenance kit bundle 2 members Active 🗑
bizhub C550i (999944) needs MK-738 Maintenance Kit ×1 WX-105 Waste Toner Box
Approved Customers (3)
+ Add Customer
Riverside Medical Group Preferred Active 🗑
Lakeside Accounting LLP Standard Active 🗑

Configuration Templates

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 Once, Reuse Everywhere Author a host plus its accessory bundle as a template, then drop it into any agreement with “Add from Template”
  • 📦
    Same Configuration Builder Accessories from e-automate related items, grouping bands, and per-item quantity rules — identical to building inside an agreement
  • 💰
    Pricing Travels With It Set pricing on the template so a machine carries consistent numbers into every agreement it’s added to
apps.powerapps.com - ID283 Configuration Templates
Build a template — host + accessories
Build a template — host + accessories
Grouping bands + per-item pricing columns
Grouping bands + per-item pricing columns

CPQ Quote Builder

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.

  • 📦
    Package-Based Quoting Pick a machine and its finisher, punch, and paper deck come pre-bundled as one package with one price and a quantity stepper
  • 🔒
    Program-Locked or Build-Your-Own Quote from vetted agreement pricing that reps cannot overwrite, or build a custom package when you need the flexibility
  • 📄
    Branded Quote PDF Generate a clean, on-brand PDF with your logo and accent color, ready to send to the customer
  • 👤
    Customer & Vendor Quotes Quote the deals your reps sell and the servicing-dealer contracts you sign in one tool; start from a prospect name and push it to e-automate to create the customer when the deal is real
  • 🔁
    Revisions & Archive Clone a quote into a numbered revision to iterate without losing history; archive lost or superseded quotes and bring them back anytime
  • 🚀
    Convert to Contract & Sales Order Turn an accepted quote into a vendor contract and push it to e-automate as a sales order in one step
apps.powerapps.com - ID283 CPQ Quote Builder
1 - Customer & header
1 - Customer & header
2 - Configure & price (package builder)
2 - Configure & price (package builder)
Rates & meters (advanced)
Rates & meters (advanced)
3 - Review: totals, margin, send
3 - Review: totals, margin, send
Branded quote PDF
Branded quote PDF

Quote Pipeline

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.

  • 📋
    Self-Updating Lanes Quotes flow from Draft to Sent to Ordered to Converted automatically as each step happens
  • 🔄
    Live Sales-Order Status When you subscribe to order tracking, cards show the real e-automate stage the order sits in right now
  • 👤
    Filtered by Rep Narrow the board to one rep to review a pipeline one-on-one, or view the whole team at once
apps.powerapps.com - ID283 Quote Pipeline
CEOJuice
ID283 ITT Vendor Service & Billing Validation
ReconciliationVendor ContractsCPQAdmin
Your Name
JN
Pipeline $11,550 open • $46,950 ordered or converted Mine only
Draft2$11,550
Lakeside Accounting$8,400
MAQC-100488
Harbor Dental$3,150
TSQC-100485
Sent1$17,180
Riverside Dental$17,180
MAsent Jul 6
Ordered1$14,900
1. PENDING 1
Summit Legal$14,900
SO ID283_90032 • Pending
2. PROCUREMENT 0
3. READY FOR DELIVERY 0
Converted1$32,050
Cascade Office (ITT)$32,050
Live contract
Drag between Draft and Sent • drop on Ordered to link a sales order • orders pushed to e-automate move automatically.

Orders & Payments

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.

  • 🧾
    Create Sales Order Turn a won quote or an active contract into an e-automate sales order in one click, with the agreed pricing and order type carried across
  • 📤
    Push AP to e-automate Post a reconciled invoice into e-automate as an AP voucher and invoice, so approved bills reach accounting with no re-entry
  • 💳
    Payments hand-off Send an approved vendor bill to your CEOJuice Payments portal for processing — the vendor’s portal is notified of the approval, and how it’s paid is decided in Payments
  • 🔐
    Safe by Default A duplicate-push guard warns before a second push, and an approval-dollar threshold holds large invoices for a human — each push is gated until its integration is installed
apps.powerapps.com - ID283 Orders & Payments
Push a reconciled invoice to e-automate (AP voucher)
Push a reconciled invoice to e-automate (AP voucher)
Create a sales order from a contract; track its e-automate status
Create a sales order from a contract; track its e-automate status

AP Voucher Import

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.

  • 📥
    Import From e-automate Select any posted AP voucher and bring it into the recon inbox in one click, with line items and coverage dates intact
  • 🔎
    Search By Anything Find vouchers by vendor, invoice number, description, serial number, or equipment number from a single search box
  • 🔗
    Contract Match Badge See at a glance whether a voucher ties to an active contract (Matched) or has no contract on file (Vendor Only) before you import
  • 📅
    Date And Vendor Filters Narrow the list to the last 30, 90, 180, or 365 days and filter to one vendor, with a live loaded count
  • Select All, Import Selected Batch-select the vouchers you want, then import them together with a running progress bar
  • Honest Import Results An Import Complete summary reports exactly how many succeeded, flags duplicates already in the system, and lists any failures by invoice
apps.powerapps.com - ID283 AP Import
ID283 AP Import

Bulk Import Contracts

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.

  • 🤖
    AI Assisted Parsing Drop any spreadsheet or paste data in any format. AI reads the columns and maps vendors and equipment for you, no template required
  • 📑
    Pick the Right Sheet Multi-tab workbooks show every sheet with its row count and header preview so you choose the contract data, not the cover page
  • Review and Edit Inline Fix any cell right in the preview grid. Editing a flagged row promotes it from Error to Warning so it can be imported
  • Clear Validation Counts See Valid, Warnings, and Errors tallied before you commit. Click any tile to filter the grid to just those rows
  • 🔢
    Include or Exclude per Row Toggle individual rows in or out, then commit only the rows you trust with a single button
  • Fast on Large Files Batched processing handles big workbooks reliably, with a progress count so you always know where it stands
apps.powerapps.com - ID283 Contract Import
CEOJuice
ID283 ITT Vendor Service & Billing Validation
ReconciliationVendor ContractsCPQAdmin
Your Name
JN
Contract Import
Upload 2 Review 3 Complete
Vendor_Contracts_2026.xlsx This file has 4 sheets - pick the one with your contract data:
Service Contracts (312 rows)
VendorName, SerialNumber, BaseRate, MonoAllowance, MonoOverageRate, ColorAllowance
Cover Page (3 rows)
Prepared by, Date, Notes
Meter History (1,840 rows)
SerialNumber, ReadDate, MonoMeter, ColorMeter
Pricing Reference (58 rows)
Model, ListPrice, TierBreaks
298 Included
274 Valid
24 Warnings
14 Errors
Clear filter
Incl Status Vendor Name Serial Number Base Rate Mono Allowance Mono Overage Rate Color Allowance Matched Vendor Name
Valid Metro Document Solutions H7117101648 $82.00 5,000 $0.0089 -- Metro Document Solutions
Valid ↳ Metro Document Solutions A9CJ021003 $98.33 7,500 $0.0079 2,000 Metro Document Solutions
Warning
Vendor matched at 71% confidence - confirm.
Summit Office Tech A7PH021559 $64.50 4,000 $0.0095 -- Summit Office Technologies
Error
Base rate missing - edit to fix.
Cascade Business Systems N4G8L2200817 -- 10,000 $0.0072 3,000 Cascade Business Systems
Valid Pacific Coast Imaging VK52910044 $120.00 12,000 $0.0068 4,500 Pacific Coast Imaging
← Back to Upload Commit Import (298 rows)

Admin Settings

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.

  • 🎯
    Per-Client Feature Toggles Switch Customer-Side Rates, Evergreen Contracts, and NASPO / IFF Fields on or off so each client sees only what they are licensed for
  • 📤
    Gated Push Toggles Push AP to e-automate and Create Sales Order stay locked until the integration (ID136 plus ID455 or ID634) is subscribed and installed
  • 🔢
    Reference Data Lists Maintain pricing models, recon statuses, termination reasons, variance reasons, billing cycles, and rate schedules with escalation steps
  • Operations Safety Switches Emergency toggles to pause processing, disable auto-recon, or force manual review when something needs a hold
  • 📋
    Full Audit Log Filterable history of every change by category, status, and user, so you can answer who changed what and when
  • 🎨
    Branding & Home Currency Set your logo and accent color once for the quote PDF, and choose your company currency so every amount across the app displays in it
  • 👤
    Access & Tab Visibility Decide who can open Settings, and control which tabs each person sees, so an order-processing role sees only Agreements and Contracts without affecting anyone else
apps.powerapps.com - ID283 Admin Settings
Defaults - tolerances, currency, auto-approval
Defaults - tolerances, currency, auto-approval
Per-client feature toggles
Per-client feature toggles
Quote branding
Quote branding
Reference data
Reference data
Operations
Operations
Audit log
Audit log
User access - roster
User access - roster
Per-user, per-page tab visibility
Per-user, per-page tab visibility
Matching Every Line Against the Contract
Every invoice line passes through these 7 stages - 15 distinct validation checks in total - before anything reaches your inbox. Lines that come through cleanly are auto-approved; you only see what needs attention.
1

Find the Contract

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.

2

Match the Detail Line

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.

3

Calculate Expected Amount

Driven by the contract's PricingModel - base rate, meter overage (Usage − Allowance) × Rate, supplies-included, and other models. Multi-year rate schedules escalate automatically.

4

Validate Program Pricing

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.

5

Compute Variance

Variance = LineAmount − ExpectedAmount. Stored on every line so reviewers see the exact dollar gap, not just a pass/fail flag.

6

Run Exception Checks

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.

7

Auto-Approve or Queue

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.

Calculate Your Impact
Vendor invoice reconciliation is included in your CEO Juice subscription at no additional cost. You pay Microsoft directly for Power Platform licensing (Power Apps Premium per user or PAYG, Power Automate Premium, Copilot Studio). See how much manual effort and overpayment risk this process eliminates.

Your Numbers

How many vendor service invoices do you process per month?
10300
Average number of equipment/service lines per invoice
120
Time currently spent comparing invoices to contracts manually
2 hrs80 hrs
Industry average is $8-$25 per invoice in undetected overcharges
$0$50
Fully loaded cost of AP/billing staff per hour
$15$75

Your Projected Savings

Based on your inputs, here's what ID283 delivers
Time Saved Monthly
16 hrs
80% reduction in manual review time
Overpayments Caught Monthly
$750
Across 50 invoices
Labor Cost Savings Monthly
$560
16 hours at $35/hr
Total Annual Impact
$15,720
$1,310/month in combined savings
Included in Your CEO Juice Subscription
No additional software cost. You pay Microsoft directly for Power Apps Premium (per-user or PAYG), Power Automate Premium, and Copilot Studio. See full licensing details ↑
Built for Office Technology Companies
ID283 is actively developed and shaped by real feedback from Office Technology companies. We release updates regularly as part of your CEO Juice subscription - no upgrade fees, no migration headaches.

💬 Driven by Your Feedback

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.

🚀 Regular Updates

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.

🔗 ID890 Ecosystem Integration

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.

🎯 What's Next

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.

Ready to Stop Overpaying?

AI-powered reconciliation, included in your CEO Juice subscription. Runs in your Microsoft tenant. Your data never leaves your infrastructure.

Get Started ➝