Process single source transaction matching

Use this process to match transactions within a single data source by completing an assigned Single Source Transaction Matching task. The system groups transactions that offset each other so the total equals zero.

Open the task

  1. Go to ..

  2. In the task list, locate the assigned task.

  3. Click the task name. The Import Data page displays.

     

Import transactions

  1. On the Import Data page, click the Download link to obtain the import template.

  2. Enter your data into the template and save the file.

  3. Click Browse.

  4. Select the transaction file.

  5. Click . The transaction file is uploaded.

    The system:

    • Scans all transactions in the selected transaction set

    • Identifies offsetting entries

    • Creates matched groups that net to zero

    • Displays the transaction match result in the General tab.

Review matches

Reconciled transactions

  1. Navigate to the Reconciled transactions tab to view more details including Matched reasons and the number of matched transactions.

  2. Click on an Id to navigate to Match Details.

  3. Verify:

    • Net total equals zero

      In this example

      • Debit total: One Maintenance Advance Inward = $100.00

      • Credit total: Related expenses (4 transactions × $25.00 each) = $100.00

      When these amounts are combined:

      • $100.00 (Debit) − $100.00 (Credit) = $0.00

      These entries offset each other exactly, resulting in a net total of zero.

    • Key fields (Reference ID, Date, Amount)

Unreconciled transactions

  1. Navigate to the Unreconciled transactions tab.

  2. Review remaining transactions,

  3. To manually reconcile them, refer to Handle unmatched transactions.

Re-import transactions

Use re-import when you need to replace or update existing data.

  1. In the Unreconciled transactions tab, click .

  2. Select Reimport.

  3. Upload a new file. The system accepts a single source file.

Reset matching

Use reset to clear all matching results and start over.

  1. In the Unreconciled transactions tab, click .

  2. Select Reset.

  3. Re-import the transaction file.

  4. Run matching again.