Plaid Integration
ERPNext integrates with Plaid to synchronize supported bank accounts directly with your ERP system. Once connected, bank transactions are imported automatically, eliminating the need to manually upload CSV or XLSX files for bank reconciliation.
Prerequisites
- A Plaid account with access to a supported financial institution.
- ERPNext server access to configure Plaid credentials in the site configuration.
Configure Plaid Settings
Before enabling Plaid, add the following parameters to your
site_config.json file:
{
"plaid_env": "your_environment",
"plaid_public_key": "your_public_key",
"plaid_secret": "your_secret_key"
}- plaid_env – Specifies the Plaid environment (Sandbox, Development, or Production).
- plaid_public_key – Public API key provided by Plaid.
- plaid_secret – Secret key used for secure authentication.
Enable Plaid Integration
Step 1: Open Plaid Settings
Navigate to the Plaid Settings DocType within ERPNext.
Step 2: Enable Integration
Click the Enable button to activate Plaid integration after the required credentials have been configured.
Once enabled, ERPNext allows you to connect bank accounts directly from the Bank Reconciliation dashboard.
Link a Bank Account
Step 1: Open Bank Reconciliation
Go to the Bank Reconciliation dashboard.
Step 2: Link Your Account
Click Link a New Bank Account and complete the authentication process through Plaid.
After successful authorization, the selected bank account will be linked with ERPNext.
Synchronize Bank Transactions
Manual Synchronization
- Select the linked bank account.
- Click the Action button.
- Select Synchronize This Account.
ERPNext imports transactions beginning from the date stored in the
Last Integration Date field of the Bank Account record.
Incremental Synchronization
Every imported transaction includes a unique transaction ID. During subsequent synchronizations, ERPNext imports only new transactions, preventing duplicate records.
Resynchronization
If you need to import older transactions again, update the
Last Integration Date in the Bank Account document and run synchronization again. ERPNext will reprocess transactions from the selected date while continuing to avoid duplicates based on transaction IDs.
Automatic Synchronization
To keep bank transactions updated automatically, enable the
Synchronize All Accounts Every Hour option in
Plaid Settings.
When enabled, ERPNext performs hourly synchronization for all linked bank accounts without requiring manual intervention.
Key Features
- Direct integration with supported banks through Plaid.
- Automatic transaction import without manual file uploads.
- Incremental synchronization using unique transaction IDs.
- Manual resynchronization by modifying the Last Integration Date.
- Optional hourly synchronization for all connected bank accounts.
