Freigeben über

Match without using a monetary key in data reconciliation (preview)

  • Artikel

[This article is prerelease documentation and is subject to change.]

This article explains how to match transactions through reconciliation in Excel with Microsoft 365 Copilot for Finance without having to use a monetary key. This capability extends the use cases for reconciliation in Excel by enabling matches to occur based only on mapping keys that involve dates, text, and strings. It removes the requirement for a monetary key (amount). During reconciliation vector selection, users can now remove any monetary keys that are suggested. If no monetary keys are suggested, users can choose not to add them.

To provide increased visibility into the results of matching without monetary keys, the Potentially matched section of the reconciliation report shows the detailed results of one-to-many (1:N), many-to-many (N:N), and many-to-one (N:1) matching instead of one consolidated line for each source table. When 1:N, N:N, and N:1 detail transactions are shown in the Potentially matched section of the report, they're presented in groups that are separated by blank rows.

Enable nonmonetary matching

During reconciliation vector selection, you can remove any monetary keys.

To remove a monetary key, follow these steps.

  1. Open the Excel workbook that contains the data that you want to use reconciliation in Excel to compare.

  2. Follow the regular process of data reconciliation until the step where the vectors are presented. (Learn how to reconcile data in Reconcile data with Copilot for Finance.)

  3. Follow one of these steps, depending on whether monetary keys are suggested:

    • If no monetary keys are suggested, continue with the reconciliation by selecting Keep in the Keys card.

    • If monetary keys are suggested, follow these steps:

      1. Select Keep to confirm and edit the rules.
      2. Identify the monetary key that you want to remove.
      3. Hover over the monetary key and select the larger X in the upper-right corner of the rectangular frame around the monetary key to remove the entire monetary key.
      4. Select Reconcile to proceed.

Note

A banner message appears at the top of the Copilot for Finance sidecar stating "No monetary key selected. The reconciliation report will not include any monetary data". The warning message can be dismissed.