Intacct
Features

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:



Viewing Balances & Transactions

Go To Balances & Transcations
Go To Balances & Transcations


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 Accouhnt
Click Accouhnt


Click into an account to view it’s previous day and intraday balances.


Bank Account Balances
Bank Account 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.

Click View Details
Click View Details


Go to the Details column → Click View to see richer details about a transaction.



Balances & Transactions Reconciliation

Step 1: Export CSV File

Go to Balances & Transactions
Go to Balances & Transactions


Navigate to Applications  > J.P. Morgan Pay > Balances & Transactions.


Click View Accounbt
Click View Accounbt


Select the account that you would like to access, by clicking on the account name, or by clicking view.


Export CSV
Export CSV


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.


Select Account
Select Account


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”.



Step 2: Import CSV File

Go to Bank
Go to Bank


Go to Cash Management > Reconciliation > Bank


Choose Account to Reconcile
Choose Account to Reconcile


Choose Account to Reconcile and select Beginning balance cutoff dateStatement ending date, and Statement ending balance.


Import CSV
Import CSV


Click Import to add a CSV file.


Select CSV to Import
Select CSV to Import


Click Choose File to import the CSV you exported in Information Reporting to import account transactions.

 Click Done.



Step 3: Select Transaction(s) to Match from Intacct

Match Transactions
Match Transactions


Click on transaction(s) you would like to match from Intacct and click Match to view unmatched transaction(s) from J.p. Morgan.


Match
Match


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).