Copilot in Business Central helps simplify the bank reconciliation process by automating transaction matching and assisting with unreconciled entries.

Two key benefits of using Copilot are:

• Quickly post unmatched transactions to the General Ledger and clear them during reconciliation.
• Machine learning capabilities improve matching accuracy over time by learning from previous reconciliations.

Import bank statement lines

To begin a bank reconciliation:

1. Search for Bank Account Reconciliations.
2. Create a new reconciliation or open an existing one.
3. Select the bank account you want to reconcile.
4. Choose Import Bank Statement.
5. Upload the bank statement file in CSV format.

If the imported file does not contain a statement date, Business Central will suggest a date that can be accepted or adjusted before continuing.

Use Copilot to reconcile transactions

Once the statement lines have been imported:

1. Select the Copilot icon.
2. Choose Reconcile.
3. Review any suggested matches.
4. Keep or discard suggested reconciliations as needed.

Copilot identifies potential matches, including transactions where details such as dates may differ slightly from the bank statement.

Post unreconciled differences

For transactions that remain unmatched:

1. Select Post Difference to GL.
2. Review the proposed general ledger account.
3. If no account is suggested, choose the appropriate GL account manually.
4. Accept the proposal to create and post the entry.

Unlike the traditional transfer-to-GL process, Copilot can create and post the required entry in a single step, reducing the number of manual actions required.

Review and post the reconciliation

Before posting the reconciliation:

• Run a test report to review the results.
• Verify that the bank balance and general ledger balance match.
• Confirm that the reconciliation difference equals zero.

Many organizations save the test report for future reference and audit purposes. Once everything is balanced:

1. Select Post.
2. Confirm the posting.

The reconciliation is then completed and the statement is recorded.

Key takeaways

• Copilot helps automate bank reconciliation in Business Central.
• Bank statements can be imported directly from CSV files.
• Copilot suggests transaction matches and improves over time through machine learning.
• Unmatched transactions can be posted directly to the General Ledger using Post Difference to GL.
• Reviewing a test report before posting helps ensure balances are accurate.
• A successful reconciliation should result in the bank balance and GL balance matching with no remaining differences.