Managing Integrations

The Integrations tab displays all available integration connections for your organization. Integrations allow Account Reconciliation to automatically pull data from external systems, eliminating the need for manual data entry.

To access the Integrations tab:

1. Navigate to the Administration module.

2. Click the Integrations tab.

The Integrations tab displays all available and configured integrations for your organization.

Enterprise version Account Reconciliation supports two types of integrations:

• ERP Integration (OBDF) — Connects to your ERP platform to synchronize GL balances, GL transaction lines, account master data, and FX rates.

• Bank Integration (Plaid)[v26.2] — Connects bank accounts via Plaid to automatically retrieve bank transactions and closing balances for reconciliation.

Each integration tile on the Integrations page displays:

• The current connection status (Healthy, Failing, Configured, Not Configured)

• The date and time of the last successful data refresh

• Controls to manually refresh data, enable or disable the integration, and configure connection settings

Enabling or Disabling Integrations

Toggle integrations on or off directly from the integration cards:

1. Click the toggle switch on any integration card to Enable (activate) or Disable (deactivate) the integration.

   • Enabled - The integrations actively sync data according to their configured schedules.

   • Disabled - The integrations stop synchronizing but retain their configuration settings for future use.

   Note: Only administrators can enable or disable integrations.

Refresh Integration Data

To manually refresh integration data:

1. Click the Refresh button on any enabled integration tile to manually sync the latest data from the connected system.

2. Wait for the refresh process to complete.

3. Verify the status remains Healthy.

Note: If changes are made in your ERP or source system — such as new accounts, updated GL balances, or modified transactions — you must manually refresh the integration to pull the latest data into Account Reconciliation.

Note: Each integration tile on the Integrations tab displays a last refresh timestamp showing when the most recent synchronization occurred — whether triggered manually or by the scheduled job. [v26.1] 

Schedule Refresh [v26.1] 

Starting from version 26.1, Account Reconciliation runs automated scheduled jobs to keep GL data in sync with source systems without requiring manual intervention. The scheduled refresh runs automatically and performs the following operations:

• Detects and creates missing reconciliations for enabled accounts.

• Updates GL balances from the connected ERP.

• Fetches new or updated GL transaction lines without performing a full data reload.

No manual configuration is required to enable the scheduled refresh.

[v26.2]  The scheduled nightly refresh also applies to Plaid-connected bank accounts.

Note: Manual refresh remains available via the Refresh icon on any enabled integration tile.

For more information, see:

• ERP Integration: OBDF — Configure and manage the OBDF ERP integration.

• Bank Integrations: Plaid — Connect and manage bank accounts via Plaid. [v26.2] 

ERP Integration: OBDF [v26.1] 

The OBDF integration connects Account Reconciliation to your ERP platform for automated data synchronization. Once configured, the integration pulls the following data from the connected ERP into Account Reconciliation:

• Account master data

• GL transaction data

• Bank account information

• FX rates

To access the OBDF integration:

1. Navigate to the Administration module.

2. Click the Integrations tab.

The Integrations tab displays all available and configured integrations for your organization. The OBDF tile shows the current connection status.

Modifying Configuration

To modify an existing integration configuration:

1. Choose the desired integration card (e.g., OBDF)

2. Select Modify Configuration to open the configuration panel.

   The Configuration page pops up.

   

3. Review the integration status at the top of the panel to verify current health.

4. Update the configuration fields as needed:

   The following table describes the configuration fields available for integration setup:

   Field	Description
   Status Indicator	Shows the current health status of the integration (Healthy/Warning/Error)
   API Base *	The base URL endpoint for the integration API. Example: https://angles.insightsoftware.com/api/SharedData/odata
   API Key *	Secure authentication key for accessing the integration. Click the info icon to manage API Keys and Access Tokens in Platform
   Run integration after saving	Toggle switch to automatically execute the integration immediately after saving configuration

5. Complete the configuration steps:

   1. Verify or update the API Base URL.

   2. Enter a new API Key if credentials have changed.

   3. Click the link to manage your API Keys and Access Tokens in Platform.

   4. Toggle Run integration after saving based on your preference:

      • ON: Integration runs immediately after saving

      • OFF: Manual execution is required later

6. Click Submit to save your changes or Cancel to discard modifications.

7. If integration is set to run after saving, monitor the status indicator for successful connection.

Note: Only administrators can modify integration configurations. Ensure API keys are kept secure and rotated regularly for security compliance.

Note: If changes are made in your ERP or source system — such as new accounts, updated GL balances, or modified transactions — use the Refresh icon on the OBDF tile to pull the latest data into Account Reconciliation.

Bank Integrations: Plaid [v26.2] 

Account Reconciliation supports direct bank account connectivity through Plaid, a secure third-party bank data provider.

The Bank Integration tile on the Integrations page allows administrators to connect bank accounts through Plaid for automated bank transaction and closing balance (support balance) retrieval.

Once connected, bank transactions synchronize incrementally into reconciliations, and auto-matching runs after each refresh.

Note: Only Admin users can connect, configure, and manage the Plaid bank integration.

Access the Bank Integration tile

To access the Bank Integration tile:

1. Navigate to the Administration module.

2. Click the Integrations tab. The Integrations page displays all available integration tiles. The Bank Integration tile shows the current Plaid connection status.

The Bank Integration tile displays the following connection information:

Connect bank accounts through Plaid

Plaid supports connections to US and Canada banks and European banks through two separate Connect buttons on the Bank Integration tile.

To connect bank accounts through Plaid:

1. Navigate to Administration > Integrations.

2. Click the applicable Connect button on the Bank Integration tile:

   • Connect US & Canada Bank Accounts — for banks in the US and Canada region.

   • Connect European Bank Accounts — for banks in the European region.

     The Plaid modal opens and displays the Select your institution screen, showing a grid of supported financial institutions with a search bar at the top.

3. Search for or select the institution you want to connect to. The Log in screen for the selected institution displays.

4. Review the permissions requested by Plaid and select Continue to login.

   The institution’s login screen opens.

   The login method varies by institution — you may be prompted for a customer ID and password, a mobile PIN, or another authentication method required by your bank.

5. Enter your banking credentials to authenticate.

   After successful authentication, the screen displays the bank accounts you have access to for the selected institution. Upon selection of the bank accounts, the connected institution appears with a green checkmark.

   Note: The login screen and authentication steps are controlled entirely by the institution. Account Reconciliation does not store your banking credentials.

6. To connect additional institutions, click + Add another and repeat steps 3–5. When all required institutions are connected, proceed to the next step.

7. Click Finish.

   The Plaid modal closes. The connected bank accounts are now available in the Bank Accounts tab in Administration.

   The Bank Integration tile updates to show:

   • Status badge: Configured

   • Updated Banks connected count

   • Updated Bank accounts created count

   • Authorization status showing the number of accounts in each state (OK, Warning, Error)

   The Authorization status section on the tile displays the count of accounts in each state. Click any row to navigate directly to the Bank Accounts tab with accounts pre-filtered by that status.

   Account Status	Indicator	Action
   X accounts OK	Green dot	Click to view healthy accounts in the Bank Accounts tab.
   X accounts with Warning	Orange triangle	Click to navigate to Warning accounts in the Bank Accounts tab. Click Requires update on each account to reauthorize.
   X accounts with Error	Red dot	Click to navigate to Error accounts in the Bank Accounts tab. Click Requires update on each account to reauthorize.

   Note: Banks may require reauthorization periodically as part of their security policy. When reauthorization is due, the account status changes to Warning or Error. Click the relevant status row to go to the Bank Accounts tab and click Requires update on the affected accounts to restore the connection. For step-by-step instructions, see Managing Bank Accounts.

View and manage connected bank accounts

Once connected, bank accounts are available in the Bank Accounts tab in Administration. Plaid-connected accounts are listed with PLAID Integration as the source and display an inline authorization status in the Account Number/IBAN column.

To link a Plaid-connected bank account to a reconciliation account, navigate to Administration > Reconciliations and configure the Support Source for the relevant account. Once mapped, the system automatically retrieves the closing balance and bank transactions from Plaid.

The following apply to Plaid-connected reconciliation accounts:

• When a Plaid-connected bank account is mapped to a reconciliation account, the manual bank statement upload button and the Set Balance button are not displayed for that account.

• If a Plaid-connected bank account becomes unhealthy (Warning or Error status), a warning indicator is displayed on the Reconciliation Details page for any reconciliation that uses that account as a support source. Reauthorize the bank account connection to clear the warning and resume automatic data retrieval.

• For loan and credit accounts connected through Plaid, balances and transactions are displayed with the opposite sign (multiplied by -1), reflecting the standard accounting treatment for liability accounts.

• Auto-matching runs automatically after each data pull. When a reconciliation is automatically moved to In Progress by the system, the System user Lineos Agent is recorded in the workflow history for that transition.

For more information on managing bank accounts, inline status indicators, and reauthorizing connections, see Managing Bank Accounts.

Reopen reconciliation

When a balance change is detected on a completed reconciliation, the reconciliation is automatically reopened and moved to In Progress. Actions on the subsequent period’s reconciliation are disabled until the previous period progresses beyond the Preparer stage.

Refresh bank transactions through Plaid [v26.2] 

Plaid integration data can be refreshed in two ways: through a scheduled automatic refresh that runs multiple times a day, or through a manual refresh triggered from the Bank Integration tile. Each refresh pulls only new transactions since the last sync, preventing duplicates. Auto-matching runs immediately after each refresh, and any unmatched transactions are surfaced for manual resolution.

Note: Refresh is triggered from the Bank Integration tile on the Integrations page.

Scheduled refresh

The system automatically performs a nightly refresh for all connected bank accounts. This ensures transactions remain up to date without requiring manual action each session.

Manual refresh

To manually trigger a refresh and fetch the latest transactions:

1. Navigate to Administration > Integrations.

2. On the Bank Integration tile, click Refresh. The system fetches new bank transactions from Plaid since the last sync. The refresh status displays on the tile while the sync is in progress.

3. Review the updated reconciliation data once the refresh is complete:

   • New transactions appear in the Unmatched Items tab of the relevant reconciliation.

   • Auto-matching runs automatically and matched transactions appear in the Matched tab.

   • The GL Balance, Support Balance, Matched, and Unmatched summary cards update to reflect the latest data.

Note: Manual bank statement uploads are disabled for reconciliation accounts linked to Plaid. If the Plaid connection is disconnected, manual uploads are automatically re-enabled.