Managing Bank Accounts (Intacct)
Access your bank account balances directly within your financial management software, using the Cash Management Reporting features.
The Bank Accounts page allows you to see previous and intraday balances directly from your accounts in near real-time. You can also export this data in an Intacct CSV file to use for reconciliation.
The bank accounts that are shown to a user depend on their level of permission. For example, if a user is restricted to a specific entity, they will only see the accounts linked to that entity.
Viewing Bank Accounts
Go to Bank Accounts
Go to HSBC Integrator -> Bank Accounts.
Here, you can view all of the bank accounts that you have connected with the plugin.
View Balances and Transactions
Select the account name or view to see the previous day and intraday balances for the chosen bank account along with transaction data.
To see the Bank Transactions, scroll down. The screen displays the information as it appears on a bank statement.
You’ll see all of the settled transactions, debits, and credits for the account.
Go to the Details column → Select View to see more details about a transaction.
Balances & Transactions Reconciliation
Follow these steps to reconcile your accounts. For a much more efficient and automated reconciliation process, we recommend leveraging the Bank Feeds product instead.
Export CSV File
Go to My Bank Pay -> Bank Accounts.
Select the account that you would like to access by selecting the Account Name or by selecting View.
Select Export to export a CSV file of your transactions.
You will be given 3 export options. We recommend using the Intacct CSV if you plan to utilize Intacct's Reconciliation module.
If you would like to export a CSV from a different account, you can toggle between accounts by selecting the drop-down next to Switch to Account.
TIP: If the file does not download, make sure your pop-up blocker is disabled.
Import CSV File
Go to Cash Management → Reconciliation → Bank
Choose the Account to Reconcile, then enter the Beginning balance cutoff date, the Statement ending date, and the Statement ending balance.
Select Import to add a CSV file.
To import your account transactions, select Choose File and upload the CSV you exported from Balances & Transactions.
Select Done.
Select Transaction(s) to Match from Intacct
Select the transaction(s) you would like to match from Intacct and select Match to view the unmatched transaction(s) from the plugin.
Select the transaction(s) you would like to match from the plugin and select Match.
These selected transaction(s) are now reconciled.