Skip to main content

AR Invoice Transactions

The AR Invoice Transactions data model provides detailed visibility into current customer invoice activity. It supports analysis of invoice amounts, payments, retainage, adjustments, balances, due amounts, aging, invoice states, and related operational dimensions.

Benefits of This Data Model​

  • Monitor current receivables: Review customer invoices that are currently open, partially paid, or outstanding.
  • Analyze current aging: Understand receivable balances across current and past-due aging buckets.
  • Review payment and retainage status: Track payments, adjustments, retainage, balances, and due amounts for current invoices.

Key Performance Indicators (KPIs)​

  • Invoice Amount: Total customer invoice amount.
  • Payment Amount: Payments applied to the invoice.
  • Retained Amount: Retainage held on the invoice.
  • Released Amount: Retainage released.
  • Retainage Balance: Outstanding retainage balance.
  • Total Invoice Balance: Total remaining invoice balance.
  • Adjustment Amount: Adjustments applied to the invoice.
  • Due Amount: Invoice amount currently due.
  • Current Amount: Open amount in the current aging bucket.
  • Current Amount by GL Date: Open amount in the current aging bucket when aging is based on GL/posting date.
  • 1-30 Days: Open amount aged 1-30 days.
  • 1-30 Days by GL Date: Open amount aged 1-30 days by GL/posting date.
  • 31-60 Days: Open amount aged 31-60 days.
  • 31-60 Days by GL Date: Open amount aged 31-60 days by GL/posting date.
  • 61-90 Days: Open amount aged 61-90 days.
  • 61-90 Days by GL Date: Open amount aged 61-90 days by GL/posting date.
  • 91+ Days: Open amount aged 91 days or more.
  • 91+ Days by GL Date: Open amount aged 91 days or more by GL/posting date.
  • Base Invoice Amount: Invoice amount in base currency.
  • Base Payment Amount: Payment amount in base currency.
  • Base Retained Amount: Retained amount in base currency.
  • Base Released Amount: Released retainage in base currency.
  • Base Retainage Balance: Retainage balance in base currency.
  • Base Total Invoice Balance: Total invoice balance in base currency.
  • Base Adjustment Amount: Adjustment amount in base currency.
  • Base Due Amount: Due amount in base currency.
  • Base Aging Amounts: Aging amounts expressed in base currency.

Available Visualizations​

View NameDescription
AR Detail Report (Current Aging by Due Date)Provides current AR detail aged using invoice due dates.
AR Detail Report (Current Aging by Posted Date)Provides current AR detail aged using GL/posting dates.