Skip to main content

AP Bill Transactions Historical

The AP Bill Transactions Historical data model provides historical transaction-level visibility into vendor payables. It supports as-of-date analysis of bills, payments, retainage, adjustments, balances, due amounts, and aging by vendor, project, company, department, location, class, employee, and transaction type.

Benefits of This Data Model​

  • Review historical payables: See which vendor bills were outstanding as of a selected reporting date.
  • Analyze historical aging: Review open balances across current and past-due aging buckets using due-date or GL-date aging.
  • Track payments and retainage: Analyze payments, adjustments, retained amounts, released amounts, and historical bill balances.

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 (Historical Aging by Due Date)Provides historical AP bill detail aged using bill due dates.
AP Bills Details (Historical Aging by Posted Date)Provides historical AP bill detail aged using GL/posting dates.