Skip to main content

Sales Transactions

The data model encompasses measures such as Customer Credit Limit, Transaction Value, and Current Amount, enabling analysis of outstanding balances by age brackets. It also includes views like Balance by Age Bracket, Credit Notes, and Payments for monitoring transactions, credit adjustments, and cash flow analysis. Additionally, it tracks invoices, receipts, and overdue amounts across defined bucket classifications to facilitate comprehensive financial decision-making and revenue tracking.

Benefits of This Data Model​

  • Enhanced Financial Decision-making: The data model allows for comprehensive analysis of outstanding balances by age brackets, aiding in strategic financial decision-making.
  • Real-time Cash Flow Analysis: With data on current transactions, credit notes, and payments, the model enables real-time monitoring and analysis of cash flow for informed decision-making.
  • Improved Customer Credit Management: By tracking customer credit limits, overdue amounts, and transaction values, businesses can effectively manage credit risk and ensure timely payments.
  • Detailed Revenue Tracking: The model provides insights into invoices, receipts, and overdue amounts classified by bucket categories, facilitating detailed revenue tracking and analysis.

Key Performance Indicators (KPIs)​

  • Customer Credit Limit: The credit limit assigned to a specific customer account.
  • Customer 80% Credit Limit: 80% of the credit limit assigned to a specific customer account.
  • Transaction Value: The total value of a specific transaction.
  • Transaction Tax Value: The tax value associated with a specific transaction.
  • Transaction Discount Value: The discount value applied to a specific transaction.
  • Transaction Allocated Value: The allocated value of a specific transaction.
  • Transaction Balance: The balance remaining after considering transaction value, tax, discount, and allocations.
  • Current Amount: The current amount due for a specific transaction or customer account.
  • Overdue @@S200UK_ARBUCKET01MIN-@@S200UK_ARBUCKET01MAX Days: The amount overdue falling within a specific range of days according to bucket classification.
  • Overdue @@S200UK_ARBUCKET02MIN-@@S200UK_ARBUCKET02MAX Days: The amount overdue falling within a different range of days according to bucket classification.
  • Overdue @@S200UK_ARBUCKET03MIN-@@S200UK_ARBUCKET03MAX Days: The amount overdue falling within another range of days according to bucket classification.
  • Overdue @@S200UK_ARBUCKET04+ Days: The amount overdue falling beyond the defined ranges of days according to bucket classification.
  • Overdue Total: The total amount that is currently overdue across all buckets.
  • Overdue Days: The total number of days that specific transactions or accounts are overdue.

Available Visualizations​

View NameDescription
Balance by Age BracketProvides a breakdown of outstanding balances categorized by age brackets for analysis.
Opening Balance InvoicesDisplays invoices that carry forward balances from previous periods for tracking purposes.
Credit NotesLists all credit notes issued, allowing monitoring of adjustments made to transactions.
PaymentsShows a detailed record of all payments received, aiding in cash flow analysis.
Current TransactionsOffers real-time data on current transactions in the system for immediate decision-making.
InvoicesProvides a comprehensive view of all invoices generated to track sales transactions.
ReceiptsDisplays receipts for payments received, enabling reconciliation and revenue tracking.