Use this report to view your unpaid invoices. This report provides information about invoice payments due within four time periods you specify in the Aging Periods window.
If you use multiple currencies, the report converts invoice amounts into your ledger currency. If this report includes foreign currency invoices with missing exchange rates, the amounts appear as null values. We recommend that before submitting this report that you run the AutoRate program to provide any missing exchange rate information. See: AutoRate Program.
Prerequisite
Create Invoice Aging periods in the Aging Periods window. See: Aging Periods.
Sort Invoices By.
Invoice Type. Sorts the report by invoice type and then by supplier.
Supplier Name. Sorts the report alphabetically by supplier name.
Include Invoice Detail.
Yes. Displays invoice detail when showing the invoice payments due to a supplier.
No. Summarizes the total invoice payments due to a supplier without displaying each invoice.
Include Site Detail.
Yes. Displays site detail and sorts by supplier site.
No. Displays only the name of each supplier.
Minimum Amount Due. The report includes invoice information for invoices that have invoice amounts greater than this Minimum Amount Due and that fall within the aging period you specify.
Maximum Amount Due. The report includes invoice information for invoices that have invoice amounts less than this Maximum Amount Due and that fall within the aging period you specify.
Invoice Type. Enter the type (Credit Memo, Debit Memo, Expense Report, Interest, Mixed, Prepayment, Withholding Tax, or Standard) for the invoices you want to review, or leave this field blank to run this report for invoices with all invoice types.
Supplier Name. If you want to submit this report for only one supplier, enter the supplier name.
Aging Period Name. The report displays unpaid invoices for the first four periods that you defined for this aging period in the Aging Periods window.
Due Date. Date an invoice is due, assuming no discounts are taken (displayed if Invoice Detail option is set to Yes).
Days Due. Number of days until an invoice is due. For example, 30 Days Due describes an invoice that was due 30 days ago, and -30 Days Due describes an invoice that will be due 30 days after today (displayed if Invoice Detail option is set to Yes).
% Unpaid. Percent of an invoice that remains unpaid. The total amount of an invoice equals the Amount Remaining divided by the % Unpaid (displayed if Invoice Detail option is set to Yes).
Amount Remaining. Amount remaining for payment. The total amount of an invoice equals the Amount Remaining divided by the % Unpaid. If an invoice includes two scheduled payments in different periods, this calculation includes all Amounts Remaining periods.
[Aging Period 1-4] In each of the four aging period columns, Payables displays the sum of invoice amounts due within the invoice aging period. Payables also displays the invoice amounts due to each supplier within the period.
Voucher Number. If you use sequential numbering or entered a voucher number, Payables displays the voucher number.