Bank Accounts
Bank Accounts records the OMC’s bank accounts and their associated transaction history. The system imports bank statements and matches transactions against the accounting ledger, providing a clear picture of the OMC’s cash position at any time.
Each bank account has a full transaction analysis showing debits, credits and running balances, along with bank statement history. When a statement is imported, the reconciliation process matches statement lines to accounting entries; any unmatched items are flagged for review. Bank charges, interest and inter-account transfers can all be posted directly from the bank account record.
List View
Section titled “List View”
| Column | Type | Description |
|---|---|---|
| Name | text | The account name or label for this bank account. |
| IBAN | text | The International Bank Account Number for this account. |
| BIC | text | The Bank Identifier Code (SWIFT code) for this account's bank. |
| Agent | picklist | The agent team this bank account belongs to. |
| Last Reconciliation Date | date | The date of the most recent bank reconciliation. |
| Last Reconciled Balance | number | The closing balance confirmed at the most recent reconciliation. |
| Linked | boolean | Whether this account is linked to an online banking feed for automatic balance updates. |
| Balance as at | dateTime | The date and time of the last automatic balance pull from the bank feed. |
| Last Balance | number | The most recently pulled live balance from the bank feed. |
| default | boolean | Whether this is the default bank account used for payment runs. |
| Asset Budget Code | picklist | The asset budget code that this bank account maps to in the chart of accounts. |
| Charges Budget Code | picklist | The default expense budget code for bank charges on this account. |
| Interest Income Budget Code | picklist | The default income budget code for interest received on this account. |
| Notes | longText | Internal notes about this bank account. |
Detail View
Section titled “Detail View”
| Field | Type | Description |
|---|---|---|
| Name | text | The account name or label for this bank account. |
| IBAN | text | The International Bank Account Number for this account. |
| BIC | text | The Bank Identifier Code (SWIFT code) for this account's bank. |
| Agent | picklist | The agent team this bank account belongs to. |
| Last Reconciliation Date | date | The date of the most recent bank reconciliation. |
| Last Reconciled Balance | number | The closing balance confirmed at the most recent reconciliation. |
| Linked | boolean | Whether this account is linked to an online banking feed for automatic balance updates. |
| Balance as at | dateTime | The date and time of the last automatic balance pull from the bank feed. |
| Last Balance | number | The most recently pulled live balance from the bank feed. |
| default | boolean | Whether this is the default bank account used for payment runs. |
| Asset Budget Code | picklist | The asset budget code that this bank account maps to in the chart of accounts. |
| Charges Budget Code | picklist | The default expense budget code for bank charges on this account. |
| Interest Income Budget Code | picklist | The default income budget code for interest received on this account. |
| Notes | longText | Internal notes about this bank account. |
| Cashflow | grid | Cashflow summary for this account broken down by period. |
| Period | text | The name of the budget period. |
| Start Date | date | The start date of this period. |
| Opening Balance | number | The opening balance at the start of this period. |
| Money In | number | Total money received into the account during this period. |
| Money Out | number | Total money paid out of the account during this period. |
| End Date | date | The end date of this period. |
| Balance | number | The closing balance at the end of this period. |
| Items | link | View individual transactions for this period. |
| text | ||
| Reconciliations | grid | History of bank reconciliations completed for this account. |
| From Date | date | The start date of this reconciliation period. |
| Opening Balance | number | The opening balance at the start of the reconciliation period. |
| Transaction Value | number | The total value of transactions in this reconciliation. |
| Reconciliation Date | date | The reconciliation date (closing date). |
| Closing Balance | number | The confirmed closing balance at reconciliation. |
| Items | link | View the individual items in this reconciliation. |
| text | ||
| Rules | grid | Automatic matching rules applied when importing bank statements. |
| Field | text | The transaction field this rule matches against. |
| Matches | text | The text pattern to match in the transaction field. |
| Applied to | text | The budget code or action applied when this rule matches. |
| Notes | longText | Notes about this rule. |
| Active | boolean | Whether this rule is currently active. |
| Used | number | Number of times this rule has been applied. |
| text |
Available Actions
Section titled “Available Actions”| Action | Description |
|---|---|
Add Bank Charge | |
Transfer Funds | Click to transfer funds from this account to another |
Add Bank Interest | |
Manual Reconciliation |
Related Tabs
Section titled “Related Tabs”| Main | Shows the main form fields as described above | |
| Attached Files | Files attached to this bank account record, such as bank statements. |
Attached Files
Files attached to this bank account record, such as bank statements.