Skip to content

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.

Screenshot
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.
Screenshot
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
money
move_down
savings
balance
ActionDescription
money
Add Bank Charge
move_down
Transfer Funds
Click to transfer funds from this account to another
savings
Add Bank Interest
balance
Manual Reconciliation
home
attach_file
home Main Shows the main form fields as described above
attach_file 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.

No scenarios available.