AP Aging Report Fields
AP Aging Summary Report
The AP Aging Summary report serves as a consolidated overview of outstanding payments to the vendors. This report organizes the data by vendors and billing periods, offering a clear breakdown of the amount owed to each vendor and the total outstanding amount. It allows businesses to quickly assess their financial obligations and gain insights into their overall accounts payable status.
AP Aging Summary Fields
Vendor
This field indicates the name or identifier of the vendor to whom the payment is owed. It helps in identifying and categorizing the outstanding balances according to the respective vendors.
Currency
This field specifies the currency in which the payment obligations are denominated.
Payment Term
The payment term field denotes the agreed-upon terms between the business and the vendor regarding the payment schedule.
Type
This field categorizes the type of transaction, such as "Bill," "Item Receipt", or "Vendor Credit".
Ref#
The reference number field contains a unique identifier assigned to each transaction or invoice, facilitating easy tracking and reference.
Date
This field indicates the date of the transaction.
Aging
This field shows the number of days for which the bill has been outstanding or the vendor credit has been unutilized.
Current
This field displays the total outstanding balance that are due within the current billing period (e.g., within 30 days).
1-30
This field displays the amount within the current billing period, not yet past due.
31-60
This field displays the total amount due that is 31 to 60 days past the bill date.
61-90
This field displays the total amount due that is 61 to 90 days past the bill date.
90+
This field displays the total amount due that is over 90 days past the bill date.
Amount
This field captures the total amount of outstanding bills associated with the vendor in the transaction currency.
Amount (Home Curr)
This field captures the total amount outstanding for the vendor in the home currency of the business.
AP Aging Detail Report
AP Aging Detail report provides an in-depth analysis of aging vendor bills, offering detailed information on unpaid item receipts, vendor bills, unused vendor credits, aging period, and the amount owed. By examining the report, you can determine which bills require immediate attention due to being past their due date.
Vendor
This field shows the name or identifier of the vendor associated with each transaction.
Currency
This field indicates the currency in which the transaction is carried out.
Payment Term
This field specifies the terms agreed upon for payment (e.g., Net 45, Net 30).
Type
This field displays the type of transaction (Receipt, Bill, or Vendor Credit).
Ref#
This field shows the unique reference number for the transaction, such as the Bill# to facilitate tracking.
Vendor Bill#
This field captures the bill number issued by the vendor.
Bill Date
This field shows the date on which the bill was issued.
Due Date
This field displays the due date of the bill.
Aging
This field shows the number of days a bill has been outstanding.
Current
This field displays the total amount due for payment within the current period (typically 0-30 days).
1-30
This field shows the amount due that is 1 to 30 days past the due date.
31-60
This field shows the amount due that is 31 to 60 days past the due date.
61-90
This field shows the amount due that is 31 to 60 days past the due date.
90+
This field shows the amount due that is over 90 days past the due date.
Amount
This field displays the total amount of the vendor bill in the transaction currency.
Amount (Home Curr)
This field displays the total amount due converted into the home currency of the business.
AP Aging Report (With Prepayments)
Apart from the AP Aging Summary and AP Aging Detail reports, the users can also access the AP Aging report (With Prepayments). Available in both summary and detail formats, this report shows the unpaid bills for the current period and for the last 30, 60, and 90+ days, along with the unutilized vendor prepayments. The report shows when the prepayment was created and for how long has it been unutilized. This report is critical for those looking to manage their payables more effectively by incorporating the impact of prepayments on their overall financial standing.
Last updated
Was this helpful?