Accounting
ERP
Financial Management
Acumatica Bank Feeds: Connecting Accounts, Matching Rules and Fixing Sync Problems

Last updated: November 3, 2026 · Independent guide · We do not sell rankings or coverage.
Acumatica bank feeds pull transactions from your bank and card accounts into Acumatica through two aggregators, Plaid and MX, so you match and post activity on the Process Bank Transactions form instead of uploading statement files. Setup takes five pieces of work: enable the Bank Feed Integration feature, create a feed and set its import start date, connect to the bank, map each bank account to a cash account, and then build the matching settings and bank transaction rules that clear most lines automatically. This guide walks through each step using Acumatica’s own form names and IDs, then covers expired connections, duplicates, missing transactions and when a statement file import is the better choice.
Before you start
- License. Bank Feed Integration is subject to licensing, and mapping more than one bank feed account needs an appropriate license. Acumatica does not publish a price, so ask your partner how many feed accounts you have (Acumatica help, Integrating with Bank Feeds, no date shown).
- Access. You need rights to Enable/Disable Features (CS100000), and a cash account for every bank account you connect, ideally in the same currency.
- Bank login. Whoever connects the feed needs online banking credentials and access to any one-time code the bank sends.
- Coverage. MX works only with US and Canadian institutions. Acumatica says Plaid and MX together reach more than 14,000 institutions (Acumatica, updated September 3, 2026).
- Expense receipts (optional). Creating receipts from card lines requires Expense Management and a non-stock Expense item as the default.
Acumatica sells the product described here. Its main help portal could not be retrieved by our research tools, so we cite the copy of Acumatica’s base documentation that MYOB publishes. Those pages state that the Plaid and MX integrations from base Acumatica are not available in MYOB Acumatica.
Step 1: Enable Bank Feed Integration
Open Enable/Disable Features (CS100000), select Bank Feed Integration and enable the change. Plaid and MX then become available without a separate registration with either provider. If several bank accounts will feed one cash account, also select Mapping of Multiple Accounts for Bank Feeds, which the documentation lists under Experimental Features (Mapping of Multiple Bank Accounts to One Cash Account).
Step 2: Create the feed and set the import start date
Open Retrieve Bank Feed Transactions (CA507500) and click Add New Record to open Bank Feeds (CA205500). Enter a Bank Feed ID, choose a Bank Feed Type of Plaid, MX, File or Test Plaid, and set the Import Start Date (To Set Up Plaid Integration).
Choose the date carefully. On Plaid feeds it defaults to 90 days back, cannot exceed 730 days and locks once you connect (Bank Feeds (CA205500) form reference). Use the day after the last statement you reconciled in Acumatica. The read-only Import Transactions From column then takes the latest of the start date, the last feed transaction, or the last transaction from another source plus one day, which prevents overlap.
Step 3: Connect to the bank
Click Connect, then Continue. In the window hosted by Plaid or MX, select your bank, sign in and complete any extra authorization. Plaid lets you choose which accounts to share. MX adds every account the credentials can see (To Set Up MX Integration). The status changes to Setup Required, and Acumatica shows an error if an account already belongs to another feed.
Step 4: Map bank accounts to cash accounts
On the Cash Accounts tab, select a cash account for each bank account, then set the Statement Period (Month, Week or Day) and Statement Start Date. Once one account is mapped, the status changes to Active. Unmapped accounts do not import. Each cash account links to one bank feed account unless you select Map Multiple Bank Accounts to One Cash Account, and Acumatica warns you about currency mismatches.
For corporate cards, select Create Expense Receipts, link cards on the Corporate Cards tab and choose a Default Expense Item on the Expense Items tab. The feed will not save without the default item.
Step 5: Load the default mapping rules
On the Custom Mapping Rules tab, click Set Default Mapping. For Plaid this maps the check number, or the transaction ID when there is none, into Ext. Ref. Nbr. Active rules override the core mapping for every cash account in the feed (To Set Up Mapping Rules).
Step 6: Test, then schedule retrieval
Run Load Transactions in Test Mode on the feed first. It shows what the bank returns, including pending status, without creating bank transactions. To import, select feeds on Retrieve Bank Feed Transactions (CA507500) and click Process or Process All. Click Schedules on the same form to automate it, and review each statement on Import Bank Transactions (CA306500) (To Import Bank Transactions from a Bank Feed).
Step 7: Tune matching settings per cash account
On Process Bank Transactions (CA306000), select the cash account and click Match Settings. Set the days before and after the bank date that a disbursement or receipt may fall, whether receipts can match AR credit memos, and the weights for payee, date and reference number. Accounts without their own settings use Cash Management Preferences (CA101000) (To Set Up Transaction Matching Settings).
Each candidate match gets a relevance score up to 100%. The documented default thresholds are 75 absolute and 20 relative (Process Bank Transactions (CA306000)).
Step 8: Build auto-create and hide rules
Bank fees, interest and loan payments rarely have a matching document. On Bank Transaction Rules (CA204500), define criteria (debit or credit, cash account, transaction code, description with optional wildcards, payee, and an amount equal to or between values) and an action (Bank Transaction Rules (CA204500)). Create Document creates a cash transaction from the entry type you choose. Hide Transaction marks the line processed without posting. Rules create cash management documents only, not AR payments or AP checks. Clicking Create Rule on the Create Payment tab pre-fills a rule from the selected line.
Then click Auto-Match, which applies match settings and then active rules, review the result and click Process. Payments created on this form skip approval, so restrict who can run it. With the feed clearing documents daily, month-end cash reconciliation becomes a review of exceptions.
Common problems and how to fix them
| Symptom | Likely cause | Fix |
|---|---|---|
| Retrieval Status shows Login Failed | Password changed or bank consent expired | Update Credentials on CA205500 |
| Same charge appears twice | Account linked twice, or a file import overlapped the feed | Remove the second link and hide the extra lines |
| Recent transactions missing | Still pending, or account not mapped | Check test mode, map the account, retrieve again |
| Feed will not activate | Cash account linked to another active feed | Suspend or remap the other feed |
Expired or failed connections
Login Failed means the bank could not verify the stored credentials (Retrieve Bank Feed Transactions (CA507500)). Click Update Credentials and sign in again. Plaid notes that certain institutions put an expiry date on consent, so a feed can stop without a password change (Plaid, Link update mode, no date shown). Give each feed a named owner who checks Retrieval Status daily.
If an MX feed returns “Bank feed has been already connected,” an Acumatica employee said in April 2025 that MX may raise it when no reconnect is needed, and advised a support case if retrieval still fails (Acumatica Community, April 8, 2025). Show Access ID gives support the IDs they need.
Duplicate transactions
Plaid lists four causes: one account linked twice, genuine double charges, updated or posted versions appearing as separate transactions, and data errors at the institution or at Plaid (Plaid, Transactions troubleshooting, no date shown). In Acumatica, the first usually comes from a second feed on the same login or a statement upload for dates the feed covered. Hide the extra lines and remove the duplicate link.
Refreshing a test tenant from production also copies live feeds. An Acumatica employee called this a known issue in May 2024, and the poster reported that reconnecting the live feeds duplicated transactions (Acumatica Community, May 8, 2024). Talk to your partner before copying a company with active feeds.
Missing transactions
Run test mode for the missing dates. If a line is pending, wait: Plaid says most post within one to five business days, the posted amount can differ, and some holds never post (Plaid, Transaction states, no date shown). If the line is absent in test mode too, check the account mapping and the Error Message column on CA507500. Nothing before the Import Transactions From date imports.
When to fall back to statement file import
Use files when your bank is not on Plaid or MX, when the connection keeps failing at close, or when treasury already receives BAI2 files. The File feed type collects CSV, BAI2 or AMEX GL1025 files from an SFTP folder (Integrating with Bank Feeds), and CSV files use column mapping rules (To Set Up Bank Feeds Loaded from a CSV File). For a one-off statement, Upload File on Process Bank Transactions takes OFX, QBO and QFX, but only when the cash account is not mapped to an active feed.
To switch temporarily, click Suspend on the feed, which allows imports from other sources. On reactivation, the Import Transactions From rule in Step 2 sets where retrieval starts, so lines already imported from another source are not fetched again. Record the switch in your month-end close checklist.
Limitations of the native feature
- Rules create cash management documents only, so AR and AP activity still needs matching.
- Plaid history stops at 730 days and the start date locks after connection.
- MX is US and Canada only and imports every account on the login.
- Multiple-account mapping is an experimental feature.
- Feed accounts count against your license, Test Plaid included.
When companies add a third-party tool
Most companies do not need one. Outside help makes sense when a bank offers only a proprietary API, when treasury needs intraday balances, or when one connection must serve many branches with rules the native feature lacks. Developers such as FintegrationFS, which sells integration services, build custom Plaid connections, and its own page advises against duplicating a native feed that works (FintegrationFS, no date shown). If you are still choosing an ERP, see our NetSuite vs Acumatica comparison.
How we researched this
We read the Acumatica documentation for each form named above, Acumatica’s product page and datasheet, Plaid’s developer documentation, Acumatica Community threads answered by Acumatica staff, and the partner pages ranking for this topic. All were checked on November 3, 2026. We did not test the feature in a live tenant.
Related guides
- Acumatica Financials Setup: GL, AP, AR and Multi-Entity
- Acumatica API: REST Endpoints, OAuth Setup and Rate Limits
- NetSuite vs Acumatica (2026): Which Fits Your Business
Frequently asked questions
Which banks work with Acumatica bank feeds?
Any institution reachable through Plaid or MX, which Acumatica says covers more than 14,000 institutions. MX is limited to US and Canadian banks. If your bank is not in the sign-in window, use the File feed type or statement uploads.
How far back can Acumatica import bank transactions?
A Plaid feed defaults to 90 days and can go back no more than 730 days. The import start date locks once you connect, so set it first.
Why does my Acumatica bank feed say Login Failed?
The bank rejected the stored credentials, usually after a password change or expired consent. Open the feed on Bank Feeds (CA205500), click Update Credentials and sign in again.
Can I map two bank accounts to one cash account?
Yes. Enable Mapping of Multiple Accounts for Bank Feeds, then select Map Multiple Bank Accounts to One Cash Account on the feed.
Does MYOB Acumatica use the same setup?
No. MYOB’s documentation says the Plaid and MX integrations from base Acumatica are not available in MYOB Acumatica, which has its own bank feed documentation.
Sources
- Acumatica (vendor), Bank Feeds product page, last modified September 3, 2026. acumatica.com
- Acumatica (vendor), Bank Feeds datasheet, document version 20260320, no publication date shown. acumatica.com
- Acumatica documentation (published by MYOB), Integrating with Bank Feeds, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, To Set Up Plaid Integration, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, To Set Up MX Integration, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, Bank Feeds (CA205500) form reference, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, Retrieve Bank Feed Transactions (CA507500), no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, To Import Bank Transactions from a Bank Feed, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, Mapping of Multiple Bank Accounts to One Cash Account, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, To Set Up Mapping Rules, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, Process Bank Transactions (CA306000), no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, To Set Up Transaction Matching Settings Applicable to a Particular Cash Account, no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, Bank Transaction Rules (CA204500), no date shown, checked November 3, 2026. help.myob.com.au
- Acumatica documentation, To Set Up Bank Feeds Loaded from a CSV File, no date shown, checked November 3, 2026. help.myob.com.au
- Plaid (aggregator; sells data connectivity services), Link update mode, no date shown, checked November 3, 2026. plaid.com
- Plaid, Transaction states, no date shown, checked November 3, 2026. plaid.com
- Plaid, Transactions troubleshooting, no date shown, checked November 3, 2026. plaid.com
- Acumatica Community, “Bank feed error message: Credentials were not updated,” answer by an Acumatica employee, April 8, 2025. community.acumatica.com
- Acumatica Community, “Bank Feeds in Test Environment,” May 8, 2024. community.acumatica.com
- FintegrationFS (sells integration services), Acumatica Plaid bank feed integration, no date shown, checked November 3, 2026. fintegrationfs.com