Prerequisites
Before connecting, confirm the following:- You have Admin or IT role access in DualEntry (see User Roles and Permissions).
- The GL cash or liability account the bank will map to already exists in your chart of accounts.
- You have online banking credentials for the institution you want to connect.
Connect via a certified aggregator
DualEntry connects to your bank through a certified third-party aggregator. The aggregator handles authentication with your bank and returns a secure access token to DualEntry. You never paste banking credentials into the DualEntry interface. To connect a bank account:- Navigate to Company → Bank Connections in the DualEntry sidebar.
- Choose Add Bank Connection, then DualEntry Router from the menu. For a brokerage or investment account, choose Investment Account Router instead so holdings come across as well as transactions.
- Search for your bank and choose it. DualEntry opens that institution’s hosted sign-in, where you enter your online banking credentials.
- Choose the accounts you want to connect. You can connect multiple accounts from the same institution in a single flow.
- After approval, the flow redirects back to DualEntry. Each selected account appears in the Bank Connections list with a status of Connected.
Some institutions require multi-factor authentication during the hosted flow. If your bank requires MFA, you complete it inside the aggregator’s window. DualEntry never sees the MFA code.
If your bank is not supported
Coverage determines whether your bank is reachable through the aggregator search. If you cannot find your institution there, it is not currently reachable that way, and there are three alternatives in rough order of effort:- SFTP. Ask your bank whether they deliver a daily transaction file over SFTP. This is the usual answer for an institution without a live connection, and it is self-serve. See SFTP bank connections.
- Build the feed yourself. If your systems already pull transactions from the bank, a developer can push them into DualEntry over the Bank Connections API. See Bank Connections: Inbound Feed API.
- Ask for a non-standard connection. DualEntry builds against the same API at its discretion, subject to feasibility review and additional fees quoted in your Order Form. Raise it with your account manager.
Upload bank statements manually
If your bank is not supported by the aggregator, or you prefer to upload statements manually, use CSV or BAI import from Bank Match instead. Manual statement uploads rely on you to provide transaction data on a regular cadence. The bank is not polled automatically. To upload a CSV or BAI bank statement:- Open Close Workflows → Bank Match from the sidebar.
- Choose the bank account from the account bar at the top of the Bank Match page.
- Open the To Match tab.
- On the Bank Statement Lines side of the page, choose Upload statement.
- In the side drawer, download the template if you need to reformat the statement into the accepted format.
- Drag and drop the CSV or BAI file into the drawer, or choose the file from your computer.
GL mapping and feed frequency
Every bank connection must be mapped to exactly one GL account. This mapping determines where transactions appear in your ledger and which account is reconciled during reconciliation. To configure or change the mapping:- Open Company → Bank Connections.
- Choose the connection you want to configure.
- Under GL Account, choose the cash or liability account from the dropdown.
- Save.
Manage, disconnect, and reconnect
The Bank Connections list shows the status, last sync time, and GL account for every active connection. To keep things organized, name each connection with the institution and last four digits of the account number (for example, “Chase ••1234”). DualEntry doesn’t enforce a naming convention, but a consistent pattern makes it easier to identify connections at a glance. To disconnect a bank connection:- Open Company → Bank Connections.
- Choose the connection and choose Disconnect.
- Confirm the action.