Skip to content

5-Way Reconciliation ยท Kentro IQ

See where orders, invoices, shipments, payments and QuickBooks disagree

Kentro compares what was ordered, invoiced, shipped, paid and posted to your general ledger in QuickBooks, every day by default. Each gap becomes an exception you can fix in place, with the decision on record. It comes with every Kentro OS plan.

  • QuickBooks Online and QuickBooks Desktop
  • Order to cash, from order to ledger
  • Fix exceptions in place
  • Every decision recorded with a name
5-Way Reconciliation
Five totals for the month: ordered, invoiced, shipped, paid and the general ledger. Four tie out; the one exception, an invoice missing in QuickBooks, opens with its likely cause and the next step, and ties out once a person exports it.

What is 5-way reconciliation?

5-way reconciliation checks that five records of the same sales agree: what was ordered, invoiced, shipped and paid, and what was posted to the general ledger. Kentro 5-Way Reconciliation, part of Kentro IQ, compares the five for each period, reads the ledger from QuickBooks and turns every difference into an exception with a suggested next step.

The five legs

Five records of the same sales

Each leg is a total for the period, built from the documents in Kentro and in QuickBooks.

1. Ordered

Net order value: orders placed, less cancellations and removed lines.

2. Invoiced

Invoices issued, less credit memos.

3. Shipped

Shipped lines, valued at the invoice or order price.

4. Paid

Payments recorded and applied, less refunds.

5. General ledger

Invoices, credit memos and payments as they stand in QuickBooks.

Where they drift apart

Four places the numbers drift apart

Between two legs sits a gap, and every gap opens the list of documents behind it, not a number to explain away.

  • Between ordered and invoiced

    An order that never became an invoice. A line removed or repriced after the order was placed.

  • Between invoiced and shipped

    Billed but not shipped, or shipped but not billed. A short shipment invoiced in full.

  • Between shipped and paid

    Goods out the door with no payment applied. A payment sitting unapplied. A refund that was never netted.

  • Between Kentro and the ledger

    An invoice or payment that never reached QuickBooks. A duplicate. A record edited or voided in QuickBooks after it was sent. A customer or product that is not linked.

Labels and units

Every gap gets a label, and the same check runs in units

Kentro labels each gap, so your team can work the queue by type instead of reading every row.

A second view compares units product by product: ordered, shipped, deducted from stock and returned. It feeds the same exception queue. It leaves out stand-alone stock adjustments such as counts and write-offs, so it is not a full inventory reconciliation.

  • Missing in QuickBooks
  • Missing in Kentro
  • Duplicate
  • Amount variance: tax, discount, fees, rounding or currency
  • Unlinked customer or product
  • Edited in QuickBooks
  • Void mismatch
  • Timing: clears on its own
Illustration of a ledger with labeled entries

Exception queue

Every gap is a row you can close

Open an exception to see both sides, the history of the document and what Kentro suggests. Then fix it without leaving the page.

Before anything is written, you type the document id to confirm. A closed period cannot change until someone reopens it.

  • What kind of gap it is, and how large
  • Which document and which customer, and how old it is
  • Who owns it and where it stands
  • What Kentro suggests to resolve it
Illustration of a queue of exceptions with one row open

Fix it in place

Four ways to close an exception

Each action needs the invoices or payments permission and is recorded with your name. You can also assign an exception to a colleague, mark it as timing with the date you expect it to clear, and close the period to lock the totals.

  • Export to QuickBooks again

    Send the invoice, payment or credit memo to QuickBooks again. If it is already there, nothing is booked twice.

  • Link customer or product

    Match a Kentro customer or product to its QuickBooks record so the documents line up.

  • Apply payment

    Apply an open payment to the right invoice, in Kentro and in QuickBooks.

  • Accept with a reason

    Close a known difference with a written reason, or write off an amount. Both are recorded with your name.

Kentro AI and your agents

Ask why it does not tie

Kentro AI, or your own agent over MCP, reads both sides of an exception, explains the difference in plain language and names the next step. It cannot post anything. A person with the right permission makes the fix in the app, and the decision is recorded under their name.

  • In the app: open the exception and read both sides and the history
  • With Kentro AI: ask why a document does not tie and get the reason and the next step
  • With your own agent: connect over MCP and ask the same question with your permissions
In the app
Kentro IQ ยท Reconciliation
With your agent
The agent explains and suggests. A person acts.
Left, the exception queue in Kentro IQ. Right, an agent connected over MCP lists the open exceptions, explains that one invoice is in Kentro but missing in QuickBooks and names the next step. A person exports the invoice to QuickBooks in the app and the exception is resolved.

Fit

What it needs, and what it is not

Knowing the limits up front keeps the wrong expectations out of the demo.

What it needs

Reconciliation runs on the documents Kentro already holds and on the ledger in QuickBooks.

  • Kentro OS as the place where orders, invoices, shipments and payments are recorded
  • A connected QuickBooks Online or QuickBooks Desktop company (Desktop connects through the Web Connector)
  • Customers and products linked between Kentro and QuickBooks; the Mappings tab lists what is missing
QuickBooks integration

What it is not

It checks the selling side of the business, from order to ledger, and nothing beyond it.

  • Not bank reconciliation: it does not match bank or card statements
  • Not a general ledger: your books stay in QuickBooks
  • Not AP three-way match: it does not match purchase orders, receipts and vendor bills
  • Not payout matching: Shopify payouts and Amazon settlements are not reconciled
  • Not for Xero or NetSuite

Pricing

Included in every Kentro OS plan

5-Way Reconciliation is part of Kentro IQ, and it comes with every Kentro OS plan, from $500 a month. It is not an add-on.

There is no fee per finance user. Connect QuickBooks, link your customers and products, and it runs every day.

  • Included in every Kentro OS plan, from $500 a month
  • No add-on fee, and no fee per user or per AI agent
  • Questions to Kentro AI draw on the $50 of usage included each month
  • Needs a connected QuickBooks Online or QuickBooks Desktop company
See pricing
Illustration of a monthly invoice

Questions about 5-Way Reconciliation

What is 5-way reconciliation, and how is it different from a 3-way match?

A 3-way match is an accounts payable check: it matches a purchase order, the goods receipt and the vendor bill before you pay. 5-way reconciliation is order to cash on the selling side. It checks that what was ordered, invoiced, shipped and paid agrees with the general ledger in QuickBooks. Kentro does not do AP three-way matching.

Does it work with QuickBooks Online and QuickBooks Desktop? What about Xero or NetSuite?

It works with QuickBooks Online and QuickBooks Desktop; Desktop connects through the QuickBooks Web Connector. Xero and NetSuite are not supported, so 5-Way Reconciliation is not a fit if your books live there. On either QuickBooks, Kentro reads the invoices, credit memos and payments in your books and compares them with the documents in Kentro.

Is this bank reconciliation, or a replacement for my accounting software?

Neither. Bank reconciliation matches your bank and card statements to your books, and 5-Way Reconciliation does not read bank statements. It is not a general ledger either: your books stay in QuickBooks. It checks that the sales documents in Kentro and the entries in QuickBooks agree, and helps you fix the ones that do not, before your accountant closes the month.

How often does it run, and can I lock a period after the close?

By default, Kentro refreshes the current month every day and runs the prior month again on the 1st of the next month, so exceptions show up while they are still cheap to fix. You can also start a run from the overview. When the month is done, close the period: its totals lock, and nothing changes until someone reopens it.

What gets written to QuickBooks when I fix an exception?

Exactly what the action names, and nothing else. Export to QuickBooks sends a missing invoice, payment or credit memo, and nothing is booked twice if it is already there. Apply payment applies an open payment to the right invoice in Kentro and in QuickBooks. Before anything is written, you type the document id to confirm. Every decision is recorded with your name.

Can the AI assistant change my books?

No. Kentro AI can list open exceptions, explain why two records differ, suggest the matching record and summarize a period, but those tools are read-only. It cannot post, export, apply or write off anything. A person with the invoices or payments permission takes every action, and the decision is recorded under their name. Your own agent over MCP has the same limits.

How do I start with 5-Way Reconciliation, and what does it cost?

It comes with every Kentro OS plan, from $500 a month, with no add-on fee and no fee per finance user. Connect your QuickBooks Online or QuickBooks Desktop company, link your customers and products on the Mappings tab, and reconciliation runs every day. Book a demo to see a month tie out on data like yours.

See a month tie out on data like yours

It comes with every Kentro OS plan and connects to QuickBooks Online or Desktop. A short call shows it on your numbers.

Choose what this site may use. Necessary storage is always on.

  • Necessary

    Remembers this choice for 12 months and keeps forms safe from spam. No tracking.

    Always on

Cookie policyPrivacy policy