Skip to main content

AP Bill Transactions

The AP Bill Transactions data model provides detailed visibility into current vendor bill activity. It supports analysis of bill amounts, payments, retainage, adjustments, balances, due amounts, aging, payment status, and related operational dimensions.

Benefits of This Data Model​

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

Key Performance Indicators (KPIs)​

  • Bill Amount: Total vendor bill amount.
  • Payment Amount: Payments applied to the bill.
  • Retained Amount: Retainage held on the bill.
  • Released Amount: Retainage released.
  • Retainage Balance: Outstanding retainage balance.
  • Total Bill Balance: Total remaining bill balance.
  • Adjustment Amount: Adjustments applied to the bill.
  • Due Amount: Bill 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 Bill Amount: Bill 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 Bill Balance: Total bill 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
AP Bills Details (Current Aging by Due Date)Provides current AP bill detail aged using bill due dates.
AP Bills Details (Current Aging by Posted Date)Provides current AP bill detail aged using GL/posting dates.