AI Matching: 3-Way Matching

3-Way Matching in FloQast AI Matching gives your team the ability to reconcile transactions across three distinct data sources, all within a single reconciliation. Whether you're matching a General Ledger against a Bank Statement and a Point of Sale system, or reconciling a Purchase Order, Goods Receipt, and Supplier Invoice, this feature eliminates the need for manual Excel workarounds or duplicate account setups to complete your process. So how do you set up 3-way matching? Click here to find out.

How Do I Set Up a 3-Way Match?

Setting up a 3-way reconciliation follows the same flow as a standard AI Matching setup, with a few additional steps to configure your third source and comparison pairings.

First, navigate to the Manage Data screen for the reconciliation you want to configure. Once you're on the Manage Data screen, you'll see tabs for Data Source 1, Data Source 2, and Data Source 3, configure each data set using its respective tab. Then follow the steps below:

1. Click the Matching Setup tab.
2. Use the checkboxes to select which source comparisons to include in your reconciliation. You must select at least two comparisons.

How Do I Execute a 3-Way Reconciliation?

Once your data sources are configured and imported, completing the reconciliation works just like standard AI Matching, with one addition: a dropdown that lets you switch between your configured comparison pairs.

1. Navigate to the AI Matching reconciliation interface.
2. Locate the Data Sources dropdown above the Unmatched Transactions table.
3. Select the comparison pair you want to work in (e.g., GL vs. Bank, GL vs. POS, Bank vs. POS). (see screenshot below)

Once you're on the Manage Data screen, follow the steps below:

1. Apply rules or manually match transactions to move them from the Unmatched Transactions tab to the Matched Transactions tab.
2. Repeat for each configured comparison pair using the dropdown until all transactions are resolved.

Your goal is the same as in standard AI Matching: move all transactions from Unmatched to Matched. Any items that remain unmatched at period close will roll forward to the next period's reconciliation.

How Do I Read the AI Matching Summary Page?

The Summary page gives you a consolidated view of match status across all three data sources, so you can trace any transaction through each configured comparison without switching views.

Each row on the Summary page represents a single transaction and includes the following columns:

• Reference fields — All reference fields configured during Matching Setup are displayed (e.g., if you mapped 3 reference fields, all 3 appear).
• Source — Identifies which data source the transaction originates from (e.g., GL File, Bank Statement, Point of Sale).
• Transaction date
• Amount
• Overall status — A high-level indicator of how fully matched the transaction is across all configured comparisons (see statuses below).
• Match comparison columns — One column per configured comparison pair, showing the per-pairing match status for that transaction.

Overall match statuses are:

• Unmatched — The transaction has not been matched to any other data source. For example, a transaction from File A has no match in File B or File C.
• Partial Match — The transaction has been matched to at least one other source, but not all applicable sources. For example, a transaction from File A was matched to File B but not yet to File C.
• Matched — The transaction has been matched across all comparisons configured in Matching Setup.

NOTE: The Summary page respects the comparisons you selected during Matching Setup. If you configured only File A → File B and File A → File C (and not File B → File C), a transaction from File A that matches both B and C will display as Matched — a B-to-C comparison is not required. Configure your comparison pairings thoughtfully during setup, as they determine what "fully matched" means on the Summary page.

Is 3-Way Matching Right for My Workflow?

3-Way Matching is designed for any reconciliation process that spans three distinct data sources. If your workflow resembles any of the examples below, this feature is built for you:

• Retail Cash Reconciliation: General Ledger → Bank Statement → Point of Sale (POS)
• Bank / Treasury Reconciliation: Bank Statement → Cash Sub-Ledger → GL
• Accounts Payable (Purchase-to-Pay): Purchase Order → Goods Receipt → Supplier Invoice
• Expense Reporting: Expense System (e.g., Concur) → Corporate Credit Card Feed → GL
• Revenue / Accounts Receivable: CRM/Order Management System → Billing System → GL
• Payroll: Payroll Processor (e.g., ADP, Workday) → HR System → GL

NOTE: Enabling 3-Way Matching introduces a new tabbed layout on the Manage Data screen. This updated UI applies to all AI Matching types, including 2-way and debits vs. credits.

Troubleshooting / Known Issues

Q: How do I change the match type if the dropdown is grayed out? 

A: If you need to switch to a 3-way match after your data has already been uploaded, the dropdown menu will temporarily be disabled. To adjust this, simply click the three dots (kebab menu) in the top right corner, select Undo all imports, update your match type in the dropdown, and then re-import your data.

Q: Do existing AI Matching rules work for 3-way matching? 

A: Yes, your existing AI Matching rules are fully compatible. If you are applying rules from the Rule Library, please ensure that the specific Reference fields (Refs) align accurately across all three data sources so the rules can trigger successfully.

Q:  Are there any ERP limitations? 

A: No. 3-way matching works with all data sources currently supported by FloQast, including direct ERP integrations, Trovata, or manual file uploads

If you have any questions about 3-Way Matching or need help please contact support@floqast.com. 

🎓Want to learn more? Check out the CPE eligible FloQademy Learning Path, FloQast AI Transaction Matching today or bookmark for later!