Bank Transactions
The data model captures information on bank transactions, including transaction debit, credit, and total amount transacted, as well as the countervalue in local currency for debited, credited transactions, and total transactions. It also includes metrics like the total count of transactions, the number reconciled and not reconciled, the reconciled percentage, manual and automatic reconciliations, their respective percentages, and the reconciliation discrepancy between expected and actual amounts.
Benefits of This Data Model
- Enhanced Financial Insights: The data model provides a comprehensive view of all bank transactions, enabling detailed analysis of transaction debit, credit, and total amounts transacted in multiple currencies.
- Improved Reconciliation Process: By tracking metrics such as reconciled and not reconciled transactions, reconciled percentage, and reconciliation discrepancies, the data model facilitates a better reconciliation process with insights into both manual and automatic reconciliations.
- Efficient Performance Monitoring: With metrics like the total count of transactions and percentages for manual and automatic reconciliations, the data model supports effective monitoring of transaction activities and reconciliation performances.
Key Performance Indicators (KPIs)
- Transaction Debit: The total amount of money debited in transactions within the bank system.
- Transaction Credit: The total amount of money credited in transactions within the bank system.
- Transaction Amount: The total amount of money transacted, including both debit and credit transactions.
- Countervalue Debit: The equivalent amount in local currency of the debited transactions.
- Countervalue Credit: The equivalent amount in local currency of the credited transactions.
- Countervalue Amount: The total equivalent amount in local currency of all transactions.
- Count: The total count of all transactions recorded.
- Reconciled: The number of transactions that have been reconciled.
- Not Reconciled: The number of transactions that have not been reconciled.
- Reconciled %: The percentage of transactions that have been reconciled.
- Manual Reconciliation: The number of reconciliations that have been manually processed.
- % Manual Reconciliation: The percentage of reconciliations that were manually processed.
- Automatic Reconciliation: The number of reconciliations that were automatically processed.
- % Automatic Reconciliation: The percentage of reconciliations that were automatically processed.
- Reconciliation Discrepancy: The difference between the expected and actual reconciled amounts.
Available Visualisations
| View Name | Description |
|---|---|
| Bank Transactions | Provides insights into all financial transactions made within the banking system. |