Body
1. Format Data
Highlight your financial data, go to the Home tab, and select Insert Table.
2. Activate Copilot Finance
Click the Finance button on the far right of the Home ribbon.
3. Our Use Case: Automated Reconciliation
Use Copilot to compare tables, such as reconciling a bank statement against internal records, and request a report of unmatched transactions.
4. Data Reconciliation Process
- Open the Finance agent sidecar from the Home tab.
- Click Financial Reconciliation.
- The add-in identifies the two data sets formatted as Excel tables (for example: bank statement vs. ledger).
Copilot will suggest matching columns and prompt you to Accept, Discard, or Regenerate the suggestions. You may accept suggestions or manually edit them if the selected columns are not correct.In most cases, you will need to make manual adjustments!
5. Editing Column Mappings
- Select Mapping 1 to edit or discard the suggested mapping.
- In this example, discard Mapping 1 and Mapping 2.
- Click the + Add button to create a new mapping.
- Select Mapping from the drop down.
A new Mapping 1 will appear.
- Click + Add to select the Table 1 column.
- Repeat the process for Table 2 by clicking + Add and selecting the column to compare.
6. Run the Reconciliation
Once the mappings are complete and verified, click the green Reconcile Data button to generate a tabular report with automated summary highlights.
7. Review the Results
Three new tabs will be generated:
- Reconciled Table 1
- Reconciled Table 2
- Reconciliation Report
The reconciliation tabs allow you to filter the Reconciliation Results column to quickly identify Unmatched records.
This makes it easier to investigate reconciliation discrepancies.
8. Re-running the Reconciliation
If connected to an environment, you may have the option to Save as Template.
The same dropdown also contains Re-reconcile Data, which:
- Deletes the existing reconciliation tabs
- Removes the reconciliation report
- Allows you to run the reconciliation again
If any matching columns are changed, a Re-reconcile Data button will appear at the bottom. In this example, an additional Mapping 2 was added for the Date.
