Bank Inquiry
The Bank Inquiry view is a central dashboard for monitoring and auditing all transactions associated with a specific bank or cash account. It provides a chronological ledger of inflows (deposits) and outflows (payments/transfers), allowing users to track the running balance, verify transaction statuses, and perform quick searches within a defined period. This view is essential for reconciling internal records with physical bank statements.
Search & Filter Options
These tools allow users to narrow down the transaction list for specific reporting needs:
- Search: A text-based filter to find specific records by reference number or description.
- Account: A dropdown menu to select the specific bank or cash account to view (e.g., Cash 2).
- Date: A range picker to filter transactions within a specific timeframe (e.g., 23/03/2026 - 29/03/2026).
- Person/Item: Filters transactions by the specific entity involved (e.g., Miscellaneous, Customer, or Vendor).
- Include Draft Balance: A checkbox to include pending "Draft" transactions in the running balance calculation.
- Show Button: Refreshes the list based on the selected filters.
Transaction List Columns
The main table provides a detailed breakdown of the account's history:
- Type: The category of the transaction (e.g., Customer Payment, Bank Payment, Bank Deposit, or Funds Transfer).
- Reference: The clickable unique identifier for the document (e.g., 009/2026).
- Date: The calendar date the transaction was recorded (e.g., 24/03/2026).
- Debit: Incoming funds that increase the account balance (e.g., 1,000.00).
- Credit: Outgoing funds that decrease the account balance (e.g., 870.00).
- Balance: The running total of the account after each transaction.
- Person/Item: The counterparty involved (e.g., Customer 5% discount customer).
- Memo: Brief notes or system-generated descriptions for the transaction.
Balance Summary Lines
- Opening Balance: The starting amount in the account at the beginning of the selected date range.
- Ending Balance: The final calculated amount after all debits and credits in the selected period are applied.
Transaction Status & Shortcuts
Each row contains status indicators and quick-access icons:
- Allocated/Posted: Green badges showing the current accounting state of the record.
- Share Icon: Allows for quick sharing or exporting of the specific transaction details.
- GL Icon: A shortcut to view the General Ledger impact for that specific row.
- Edit (Pencil Icon): Quick access to modify the transaction.
- Delete (Trash Icon): Removes the transaction (subject to user permissions and posting status).
Action Buttons (Top Bar)
- + New Payment: Create a new Bank Payment from this screen.
- + New Deposit: Create a new Bank Deposit entry.
- + New Transfer: Initiate a new Funds Transfer between accounts.
- Import Export: Tools for bulk uploading transactions or downloading the inquiry list.
- Reports: Quick access to related financial statements like the Bank Reconciliation report.
Note
The running balance in this view is calculated based on the sort order. If you change the date range, the "Opening Balance" will automatically adjust to reflect the account standing as of the start date selected.