Balances & Transactions
The Balances & Transactions feature allows you to see previous and intraday balances directly from your J.P. Morgan accounts in near real-time. You can also export this data in a Intacct-friendly CSV file to use for reconciliation. Follow the steps below to use this feature:
Navigate to Applications > J.P. Morgan Pay > Balances & Transactions.
Here, you can view all of the bank accounts that you have connected with the plugin.
Click into an account to view it’s previous day and intraday balances.
Bank Account Balances are displayed at the top of the page.
Bank Transactions: scroll down to see what is essentially your bank statement, populated on this page.
- You’ll see all of the settled transactions, debits and credits, for the account.
Go to the Details column → Click View to see richer details about a transaction.
Navigate to Applications > J.P. Morgan Pay > Balances & Transactions.
Select the account that you would like to access, by clicking on the account name, or by clicking view.
Click Export CSV to export a CSV file of your transactions.
You will be given 3 export options and it’s recommended to use the Intacct CSV if you will be using Intacct’s Reconciliation module.
Note: If the file does not download, make sure your pop-up blocker is disabled.
If you would like to export a CSV from a different account, you can toggle between account by selecting the drop down next to “Select An Account”.
Go to Cash Management > Reconciliation > Bank
Choose Account to Reconcile and select Beginning balance cutoff date, Statement ending date, and Statement ending balance.
Click Import to add a CSV file.
Click Choose File to import the CSV you exported in Information Reporting to import account transactions.
Click Done.
Click on transaction(s) you would like to match from Intacct and click Match to view unmatched transaction(s) from J.p. Morgan.
Click on transaction(s) you would like to match from J.P. Morgan and click Match.
That’s it! You have reconciled those selected transaction(s).