Match one transaction to multiple transactions
If you're reconciling with an import file or a bank feed, you might need to match one bank transaction to multiple transactions in Sage Intacct, or vice versa. For example, you might have one ACH payment at the bank that corresponds to multiple payments within Intacct. Match these transactions on the Match transactions page.
Best practice: Select the single transaction first on either the Intacct tab or the Bank tab on the reconciliation page. Then, select the transactions that make up the single transaction to match.
Set up a matching rule to match one transaction to multiple transactions automatically.
Currently, matching multiple transactions to multiple transactions is not a supported functionality.
Example
At the bank there are two deposits, one for $200 and one for $100. You record these two transactions as one deposit in Intacct for $300.
| Subscription | Cash Management |
|---|---|
| Regional availability |
All regions |
| User type | Business |
| Permissions |
Reconcile bank: List, View, Add, Edit Reconcile credit card: List, View, Add, Edit Users with permissions to Reconcile can also match transactions. |
-
Go to Cash Management > All > Reconciliation > Bank or Credit card.
- Enter your account information.
- Select Continue.
- On the account reconciliation page, find the single transaction on the Bank or Intacct tab.
-
Select Match.
Following the example, on the Intacct tab select the $300 deposit. The Match transactions page appears with the information for the selected transaction at the top.
-
Select the transactions that match to the original transaction.
Following the example, select the two bank deposits. The Remaining to match amount updates based on your selection.
Is the Remaining to match amount not zero?If you're reconciling with an import file or bank feed, you can partially match a bank transaction from the Bank tab.
This means that the Remaining to match amount does not equal zero, and the transaction is not marked as matched yet, but your work is saved when you select Match. Come back later to complete the match.
- Select Match.