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.
The action buttons on the bank details page allow you to enter bank charges and bank interest received quickly and easily.
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. |
| 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. |
| 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.