Report: Vendor Invoice Payments

Use the Vendor Invoice Payments report to monitor your invoice payments to vendors. For the date range and business unit criteria that you select, the report returns payment activity history for each invoice within these parameters. You can run the report in summary or allocation format.

Report Selections

What is this?

Payment Date Range

Option	What is this?
From List	Use this option to select a pre-defined date range from the list. The default option is Current Month.
Select Dates	Use this option to type in specific From and To dates, not covered by the choices in the From List option.

Vendor

The default is All; you can select a specific or multiple vendors.

Invoice

This field is disabled unless you select a single specific vendor. From the list, select the paid vendor invoice.

Payment Division

The default is All; you can select a specific or multiple business units.

For this report, user business unit security applies to the invoice payment division, not the allocation business units. A user who has access to the payment division will see all related allocations, even if the user is not authorized for those allocation units.

Bank

The default is All; you can select a specific or multiple banks.

The list is based on the Payment Division selected. This field is not available when you select a specific invoice.

Sort Option

From the list, select how you would like to organize the results. Choices include:

Bank
Paid Date
Payment Division
Vendor

The default sort order is Vendor.

Print Cover Page

Allows you to include a cover page with the report, which lists the selected options included in the report. This option defaults as unchecked.

Format

Format	What is this?
Business Unit Allocation	If you select the Business Unit Allocation option, the report includes all subtotals paid on an invoice by each distinct Business Unit.
Summary	The Summary report does not include detail by business unit. It reports by total invoice.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Report Fields

Summary Report Fields

The sequence of these fields depends on the report Sort Order you select.

Your Sort Order selection appears as a header row at the top of each report section. The header row is not repeated as a column within the report section. Instead, for that specific Sort Order, the column is hidden.

Example If you select Vendor as your Sort Order, then each section on the report includes a vendor's name in the header row. There is no "Vendor" report field within each section.

Report Fields	What is this?
Vendor	Vendor firm name, or last name and first name of the individual.
Invoice	Vendor invoice number, as entered on the Vendor Invoice data entry form.
Inv Date	Vendor Invoice Date (e.g., date of incurred expense), as entered on the Vendor Invoice data entry form.
Paid Date	Pay Date as entered in the Vendor Invoice form: payment check date for the invoice.
Check #	The number on the check. If the check has not been printed yet, the check number is unassigned.
Bank	Name of the bank through which this invoice payment is made.
Invoice Amt	The total invoice amount as entered on the Vendor Invoice.
Description	Description of charge, as it appears on the Vendor Invoice form.
Pay Amount	The Pay Amount as entered on the Vendor Invoice form: the amount paid on the invoice for the transaction.

Business Unit Allocation Report Fields

The sequence of these fields depends on the report Sort Order you select.

Example If you select Vendor as your Sort Order, then each section on the report includes a vendor's name in the header row. There is no "Vendor" report field within each section.

Report Fields	Description
Vendor	Vendor firm name, or last name and first name of individual.
Invoice	Vendor invoice number, as entered on the Vendor Invoice data entry form.
Inv Date	Vendor Invoice Date (e.g., date of incurred expense), as entered on the Vendor Invoice data entry form.
Paid Date	Pay Date as entered in the Vendor Invoice form: payment check date for the invoice.
Check #	The number on the check. If the check has not been printed yet, the check number is unassigned.
Bank	Name of the bank through which this invoice payment is made.
Inv Amount	The total invoice amount as entered on the Vendor Invoice.
Description	Description of the expense, as entered on the Vendor Invoice form.
GL #	The General Ledger account number associated with the paid-out transaction.
Div/Branch/Dept/Group	The agency business units associated with the bank through which this invoice payment was made.
Pay Amount	The amount paid on the invoice for the transaction.

CSV Columns

CSV Columns	Description
DateRange	Report date range, formatted MM/DD/YYYY
Vendor	Firm name, or last and first name of the individual.
Invoice	Vendor invoice number, as entered on the Vendor Invoice data entry form.
InvDate	Vendor invoice date or date of incurred expense, as entered on the Vendor Invoice data entry form.
InvAmount	Dollar amount of the invoice.
Description	Description of the expense, as it appears on the Vendor Invoice form.
BankName	Name of the bank through which this invoice payment was made.
PaymentGL	The general ledger bank account number from which this transaction posted.
PaymentDivName	Agency payment division from which this transaction posted.
SourceRefNo	Internal number used to track the accounting transaction through the system.
PaidAmount	Amount paid toward the invoice on this transaction.
PaidDate	Pay Date as entered in the Vendor Invoice form: payment check date for the invoice.
Check#	The number on the check payment. If check has not been printed yet, the check number is unassigned.
AllocationGL	The General Ledger account number used for posting the invoice expense portion allocated to this transaction's specific business unit. This number corresponds to the GL Number as it appears in the GL Distribution section of the Vendor Invoice data entry form.
AllocationDivName	Division associated with the Allocation GL #, as it appears in the GL Distribution section of the Vendor Invoice data entry form.
AllocationBranch	Branch associated with the Allocation GL #, as it appears in the GL Distribution section of the Vendor Invoice data entry form.
AllocationDeptName	Department associated with the Allocation GL #, as selected in the GL Distribution section of the Vendor Invoice data entry form.
AllocationGroup	Group associated with the Allocation GL #, as selected in the GL Distribution section of the Vendor Invoice data entry form.
AllocationPaidAmount	The portion, in dollars, of the invoice pay amount allocated to this business unit for this transaction.
DueDate	Vendor due date for payment, as entered on the Vendor Invoice form.