Bank Register

The bank account register displays transaction information specific to the bank account, such as current balance, last reconciled balance and date, ending balance, and detailed transaction information.

When bank feeds are enabled, and an online bank account is linked to a bank account in Financial Edge NXT, the online bank account balance and date of the last download appear. To initiate the download and clear process again, click Refresh.

Tip: With bank feeds, reminders display at the top of a register. For example, when downloaded transactions do not automatically match, a reminder appears at the top of the register displaying the number of transactions that were not automatically matched. A reminder also displays when the linked, online bank account needs to be updated. For more information, see Bank Feeds.

From Treasury, Bank accounts, open an account to view the register. Under Register, you can open and edit specific transactions, reconcile the bank account, view reconciliation history, and add adjustments.

To choose which information to view, select Columns, choose details to include, and select Apply changes. If necessary, drag and drop the headers to reorder each column.

To locate transactions within the bank register, select Filter. For example, you can specify the transactions that display, or a particular date or date range. Once you select your filters, select Apply filters to filter the grid.

Tip: Note that a register’s balance is a reflection of deposits and payments over time. Once you apply one or more register filters, the balance changes to a running total based on the filters you select.

To view the account balance for recent transactions, sort the list of transactions in descending order by Date, Clear date, or Post date (displaying the newest transaction first). When you do this, Current balance displays in reverse order. The subsequent transaction rows also display the correct "as of" balance for each transaction in the Account Balance column, in order of newest to oldest.

Tip: The most recent sort option you selected remains in place until you select a different one.

Note: When you sort by ascending dates or by any other column, the Account Balance column starts at 0 and accumulates with each transaction.

You can review the bank account's reconciliation history when you select Reconciliation history on the bank register action bar. The history displays the date and ending balance for previous reconciliations.

To use a .qif, .ofx, .qbo, bai.txt, or .qfx file from your bank to match and clear transactions in your register electronically, select Clear electronically on the bank register action bar. After you complete the process, matching transactions have a Cleared status and transactions that don't match display as exceptions on the Clear Transactions Electronically report. Use the report to identify, match, and clear unmatched transactions. You can then reconcile the bank account. For more details, see Clear Transactions Electronically.

You can review the bank account's clearing history when you select Clearing history on the bank register action bar. The history displays important details about previous clearing imports such as the last run date and the number of exceptions. You can also view and download the import file.

You can specify a default date for setting a transaction status to cleared when you select Set default clear date from the bank register action bar.

Tip: Transactions have an Outstanding status when the clear date is after the reconciliation date.

To reconcile a bank account, select Reconcile from the bank register action bar.

From the Reconcile page, you can specify a statement date and ending balance, select to reconcile manually or with bank feeds, match and clear transactions, and review your register prior to reconciling. For more information, see Reconcile Bank Accounts.

When bank feeds are enabled, you can download and automatically match bank feed transactions to Financial Edge NXT transactions. When transactions do not automatically match, a reminder appears at the top of the bank account register displaying the number of transactions that were not automatically matched. To review and manually match them, select Click here to view and match. For more information, see Manually Manage Transactions.

The Bank register displays transaction information specific to the bank account, such as current balance, last reconciled balance and date, ending balance, and detailed transaction information. To export the this information to an Excel .XLSX file, select Export.

Tip: The bank account number does not appear in bank register grid, however, it does appear in the Excel file you export. This is helpful when you want to compare bank register information with bank accounts in Excel.