Skip to main content

AI Commission Reconciliation - in beta

How agency admins can use AI Commission Reconciliation to add supplier statements, auto-match line items to bookings, and approve statements for payout.

J
Written by Jack Bradmiller-Feld

Overview

AI Commission Reconciliation lets you upload a supplier or host payout statement and automatically match its line items to bookings in Tern — reducing the manual work of commission reconciliation.

  • Please use extra caution when reviewing AI-generated statements. Submit any feedback to Tern support!

  • AI Commission Reconciliation counts toward your monthly AI usage and shows as AI Reconciliation in your usage breakdown. When you reach 100% of your monthly limit, AI features pause until your next billing cycle. You can add more usage anytime with Tern Pro. See AI usage limits.


Before you start

  • You must be an agency admin to use AI Commission Reconciliation.

  • You need at least one statement ready to upload — either as an attachment or inline email from a supplier or host, or as a file saved to your device.

  • Bookings should already be created in Tern for the best auto-match results. Missing details like confirmation numbers, supplier names, or client names will reduce match accuracy. Manage your booking requirements in Agency Financial Settings.


Step 1: Add a statement

You can add a statement two ways. Use whichever fits your workflow.

Option A: From your Tern inbox (requires email integration)

  1. Go to the Emails tab in your topbar.

  2. Click on the supplier or host payout email you want to reconcile.

  3. Click Add Statement. Tern will scan the email — whether the statement is inline or attached — and automatically parse the details.

  4. Review the parsed details and click Save.

If you haven't set up the email integration yet, go to Settings > Email & Scheduling and follow the prompt to connect your inbox.

Option B: From the Statements tab

  1. Go to Commission in your topbar and open the Statements tab.

  2. Click Add Statement and select Choose File.

  3. Review the parsed details and click Save.


Step 2: Review AI reconciliation results

Once you save a statement, Tern's AI reads it and matches each line item to a booking. This may take a moment. Each line item ends up either Reconciled or in Needs review.

Reconciled (auto-matched)

These line items have a match on:

  • Exact confirmation number match

  • Only one confirmation match — there's exactly one suggested match across all your bookings

  • Supplier

  • Non-custom commission split

If a line item has been auto-matched but you believe it's incorrect, click the X on the row to remove it. The line item will move to Needs review.

Needs review

Each line item here shows a status:

  • Partial match: matched on some details but not all. For example, the advisor left off the client name.

  • Multiple matches: more than one booking could be the match.

  • No bookings found: no booking in Tern matched.

To review a match:

  1. Click Review on the line item.

  2. Check the matched details. If it looks correct, click Confirm match. The line item will move to Reconciled.

  3. If it's not a match, click Not a match. Tern will look for other possible matches. If none are found, you can search manually.

If no booking was found

  1. Click Review on the line item.

  2. Search for the booking using the confirmation number, supplier, or other details. This helps when there was a typo or a booking was entered with incomplete information.

  3. If you still can't find a match, click Add to unclaimed to move the line item to your unclaimed commissions. This applies when, for example, the advisor hasn't added the booking yet. You can reconcile it later once the booking exists in Tern.

From the review panel you can also click Edit line item to fix the parsed details, Skip for now to come back later, or Dismiss to remove the line item. Dismissing can't be undone.


Step 3: Approve for payout

Once all line items are reconciled, click Approve for Payout. Your agents are now ready to be paid.


If Statements is its own item in your Back Office sidebar

Some agencies have a newer Statements page. If Statements appears as its own item in your Back Office sidebar, open it there instead of Commission. Click Add statement to add one. Each statement's line items are split into All bookings, Needs review, and Reconciled tabs. To move several line items at once, select them and click Add to unclaimed. Click Approve for payout once every line item is reconciled.


Common issues

AI reconciliation completely messed up. What do I do? We recommend 1) sending a support ticket in with any feedback to help us improve the feature, 2) deleting any logged commission on any "auto-matched" bookings to prevent future confusion, and then 3) fully deleting the statement and starting over manually.

A line item I expected to auto-match ended up in Needs review. This usually means a booking is missing one or more key details — confirmation number, supplier, or client. Confirm the match manually if the booking is correct, and ask your agent to fill in the missing information going forward - or configure booking requirements under financial settings.

My statement failed to parse correctly. Contact Tern support. It helps to share the statement file itself and a link to the specific statement in Tern so the team can identify any supplier-specific formatting issues.

Did this answer your question?