Creating a Financial Monitoring System for Grafana Finance
Budget: $30 – $250 USD
1. Data Sources
PostgreSQL
Database:
Wholesale prices.
Markup percentage.
Retail prices.
Sales history.
Balance Data:
Merchants:
Reward percentage (the percentage they keep from each payment).
Top-up amounts: the amount merchants add each time.
Top-up history: date, amount, and method of each top-up.
Write-off statistics: detailed transactions that decrease the merchant's balance.
Aggregators (Wholesalers):
Turnover accounts and their balances.
Currency Rates:
Tenge, USD, USDT, GEL.
Fixation of rates for each transaction for accurate accounting.
2. Main Monitoring Modules
2.1. Registers by Clients, Services, and Merchants
Automatic creation of registers for each client, service, and merchant, including:
Cash balances.
Initial cost of products or services.
Markup percentage and retail price.
Merchant balance details:
Reward percentage.
Top-up amounts and top-up history.
Balance write-off statistics.
Marginality for each transaction, taking into account all costs.
2.2. Currency Rates and Their Fixation
Monitoring and fixing currency rates for each transaction:
Receiving payments from clients to the bank account.
Purchasing services from aggregators (wholesalers).
Integration with up-to-date currency rate sources for accurate calculation of profit and expenses.
2.3. Balances of Clients, Merchants, and Aggregators
Merchants:
Accounting of top-up amounts: recording each top-up amount and date.
Top-up history: access to the full journal of top-ups.
Write-off statistics: detailing transactions that decrease the balance, including date, amount, and reason for write-off.
Monitoring balance remainder and automatic warning when it decreases to a critical level.
Clients:
Tracking prepaid balance and its decrease as purchases are made.
Aggregators:
Monitoring account balances and notification when reaching a minimum level.
2.4. Automation of Profit and Expense Calculations
Automation of calculating all expenses and profits, taking into account:
Wholesale prices and markup percentages.
Merchant reward percentage.
Top-up amounts and balance write-offs of merchants.
Currency exchange differences during currency operations.
Bank commissions and costs for transferring funds.
Calculating margin for each service or transaction, considering all costs.
2.5. Server and System Status
Monitoring the status of servers and databases.
Notifications of any failures or deviations in system operation.
3. Dashboards and Visualization in Grafana
Merchant Balance:
Displaying current balance amounts.
Graphs of top-up amounts and write-offs over a selected period.
Top-up history with the ability to filter by date and amount.
Income and Expenses:
Visualization of income and expenses by clients, services, and merchants.
Analysis of marginality by transactions.
Currency Rates:
Dynamics of currency rates and their impact on profit.
System Status:
Displaying the status of servers and databases in real-time.
4. Notification System
Setting up instant notifications in the following cases:
Merchant Balance:
Decrease of balance to the critical minimum.
Unusual write-off amounts or frequent write-offs.
Balance Top-ups:
Notifications of large top-ups.
Problems with the server or database.
Critical changes in currency rates.
5. Data Update Frequency
Data should be updated in real-time or at intervals of no more than one hour, especially for transactions and critical metrics.
Updating information about merchant balance top-ups and write-offs should occur immediately after the corresponding operations
PostgreSQL
Database:
Wholesale prices.
Markup percentage.
Retail prices.
Sales history.
Balance Data:
Merchants:
Reward percentage (the percentage they keep from each payment).
Top-up amounts: the amount merchants add each time.
Top-up history: date, amount, and method of each top-up.
Write-off statistics: detailed transactions that decrease the merchant's balance.
Aggregators (Wholesalers):
Turnover accounts and their balances.
Currency Rates:
Tenge, USD, USDT, GEL.
Fixation of rates for each transaction for accurate accounting.
2. Main Monitoring Modules
2.1. Registers by Clients, Services, and Merchants
Automatic creation of registers for each client, service, and merchant, including:
Cash balances.
Initial cost of products or services.
Markup percentage and retail price.
Merchant balance details:
Reward percentage.
Top-up amounts and top-up history.
Balance write-off statistics.
Marginality for each transaction, taking into account all costs.
2.2. Currency Rates and Their Fixation
Monitoring and fixing currency rates for each transaction:
Receiving payments from clients to the bank account.
Purchasing services from aggregators (wholesalers).
Integration with up-to-date currency rate sources for accurate calculation of profit and expenses.
2.3. Balances of Clients, Merchants, and Aggregators
Merchants:
Accounting of top-up amounts: recording each top-up amount and date.
Top-up history: access to the full journal of top-ups.
Write-off statistics: detailing transactions that decrease the balance, including date, amount, and reason for write-off.
Monitoring balance remainder and automatic warning when it decreases to a critical level.
Clients:
Tracking prepaid balance and its decrease as purchases are made.
Aggregators:
Monitoring account balances and notification when reaching a minimum level.
2.4. Automation of Profit and Expense Calculations
Automation of calculating all expenses and profits, taking into account:
Wholesale prices and markup percentages.
Merchant reward percentage.
Top-up amounts and balance write-offs of merchants.
Currency exchange differences during currency operations.
Bank commissions and costs for transferring funds.
Calculating margin for each service or transaction, considering all costs.
2.5. Server and System Status
Monitoring the status of servers and databases.
Notifications of any failures or deviations in system operation.
3. Dashboards and Visualization in Grafana
Merchant Balance:
Displaying current balance amounts.
Graphs of top-up amounts and write-offs over a selected period.
Top-up history with the ability to filter by date and amount.
Income and Expenses:
Visualization of income and expenses by clients, services, and merchants.
Analysis of marginality by transactions.
Currency Rates:
Dynamics of currency rates and their impact on profit.
System Status:
Displaying the status of servers and databases in real-time.
4. Notification System
Setting up instant notifications in the following cases:
Merchant Balance:
Decrease of balance to the critical minimum.
Unusual write-off amounts or frequent write-offs.
Balance Top-ups:
Notifications of large top-ups.
Problems with the server or database.
Critical changes in currency rates.
5. Data Update Frequency
Data should be updated in real-time or at intervals of no more than one hour, especially for transactions and critical metrics.
Updating information about merchant balance top-ups and write-offs should occur immediately after the corresponding operations