The listing of transactions in the Account Details table can be sorted by the data in any column. Click the arrows in the column headers to sort the table (up arrows give an ascending sort, down arrows give a descending sort).
To see details for a different account, select another account from the Account Selection drop-down list.
Note: For all accounts, the table will display an Item Reference Number column in addition to the standard ones.
If you have access to the Imaging service and an image is available, the following will be displayed:
The check number (for checking account) will display as a hyperlink; click the link to display the check image in a secondary browser window.
The text "View" or transaction number (for deposits) will display as a hyperlink; click the link to display the deposit slip image or the deposit transaction list in a secondary browser window.
You can set the date range for the transactions you wish to see by filling out the From and To fields in the Request Specific Date Range table. (Enter dates in dd/mm/yyyy format.) For convenience, click the Today or Yesterday buttons to set one-day ranges.
You can also filter the data by clicking on the Transaction Search button. The data can be filtered by Check Number, Dollar Amount or Available Transaction Categories. Make your changes and click the Submit button to update the display.
If you have a large number of transaction records, you will be able to page through the list using First, Previous, Next and Last options on screen. If there are more than 10 pages of transactions you will also have the option to jump to any page. Simply insert the page number and select GO.
Note: If account category codes are not available, the Available Transaction Categories displayed will be Debit and Credit.
The display of the More button indicates that there are additional transactions available for the date range requested.
If you press the More button without a Sort and/or Transaction Category Filter in use, the system will land the you on the same page from which you pressed the More button.
If you pressed the More button with a Sort and/or Transaction Category Filter in use, the application will return you to the first page of history and the ‘new’ transactions will be sorted within your original set of transactions.
You can create an export file of Account Details data by choosing a format from the Select Export Format drop-down list and clicking the Export button. A standard Windows dialog box lets you specify the filename and directory location.
Note: If the balance for the account is not real-time, a pop-up warning will be displayed before the download of the file.
The Business Banking system can export financial transaction data in a format specific to BAI, MicrosoftÒ Money (OFX), WebConnect for QuickBooksÒ or WebConnect for QuickenÒ,. QuickBooksÒ(.IIF), QuickenÒ/Money (.qif). It can also create a comma-delimited text file that can be read by most database systems, spreadsheets, word processors, etc. or an HTML file for display in a browser.
IMPORTANT! Before exporting account information to QuickBooks or Quicken for the first time, please confirm that the QuickBooks or Quicken "Chart of Accounts" name (for example, Corporate Checking) matches the Business Banking system account name. If not, QuickBooks and Quicken will automatically create new accounts to match the Business Banking system account name.