Bank Register
The bank register gives you a single place to review balances, monitor transaction activity, and prepare for reconciliation. You can quickly see current balance, last reconciled balance and date, ending balance, and transaction details.
From Treasury, select Bank accounts, then open an account. Under Register, you can open transactions, edit details, add adjustments, review history, and reconcile.
When bank feeds are enabled and an online bank account is linked in Financial Edge NXT, the online balance and last download date appear on the register. To run the download and clear process again, select Refresh.
Tip: Bank Feed reminders appear at the top of the register to help you prioritize follow-up, such as unmatched transactions or an online account that needs attention.
To find transactions faster, select Filter, set transaction or date criteria, and select Apply filters.
Tip: After you apply filters, the register balance updates to a running total based on the filtered transactions.
Sort transactions — To review recent activity, sort transactions by Date, Clear date, or Post date in descending order to see the newest transactions first.
View reconciliation history — Select Reconciliation history on the register action bar to review previous reconciliations, including date and ending balance.
Clear transactions electronically — To clear transactions from a bank file, select Clear electronically on the register action bar and upload a .qif, .ofx, .qbo, bai.txt, or .qfx file. Matched transactions update to Cleared, and unmatched transactions appear as exceptions so you can quickly clear them electronically.
View clearing history — Select Clearing history on the register action bar to review previous imports, including last run date, exception count, and import file details.
Set default clear date — To set a default cleared date for transactions, select Set default clear date on the register action bar.
Tip: Transactions have an Outstanding status when the clear date is after the reconciliation date.
Reconcile from the register — To reconcile the bank account, select Reconcile on the register action bar.
From the Reconcile page, you can enter statement details, choose manual or bank-feed reconciliation, match and clear transactions, and review your register before you complete reconciliation. Follow the reconciliation process to complete your account setup.
Manually match transactions — When bank feeds are enabled, transactions download and match automatically when possible. If items remain unmatched, a reminder appears at the top of the register with the unmatched count. To review and manually match those transactions, select Click here to view and match. You can manage transactions manually when needed.
Export to Excel — To export register details to an Excel .xlsx file, select Export.
Tips for Working with Your Bank Register
After you apply filters, the register balance updates to a running total based on the filtered transactions. This helps you focus on specific transaction types or date ranges.
When the clear date is after the reconciliation date, transactions display as Outstanding. Check this status when setting your default clear date.
Your sort selection persists until you choose a different option, so you can quickly navigate back to your preferred view.
Keep an eye on Bank Feed reminders at the top of the register. They alert you to unmatched transactions or accounts needing attention.