Payment Report with Invoice Details

This guide will cover:

 

Information

The Payment Report with Invoice Details gives us a report to analyze both invoices and their payments in one space. This can be run throughout the entire Fiscal Year to include the payment report emphasizing invoice details to show totals and other important invoice information.

 

Step One

Navigating to the Reporting Table of Contents

  • Navigate to WyoCloud and click on the Reporting Table of Contents tile

 

Step Two

To Run the Payment Report with Invoice Details

  • Under the Business Optimization Beta Reports header on the Table of Contents, click on the Payment Report with Invoice Details

  • The report page will open

  • You can use the parameters listed in Step Three to filter your search inside the report.

  • After you have put in your parameters, when the report finishes loading, the data will display underneath the prompts.

  • To export the report, click on the export link at the bottom of the page. Click Data and then CSV or similarly select Data followed by Excel.

  • The file will download, and you can open the file in the necessary means based on the web browser used.

  • You have the ability to sort and filter for the information you would like to see within the CSV or Excel spreadsheet.

    • Note: Data saved in csv will not retain data formatting

 

 

Step Three

Search Parameters Defined

  • You may use any of the following prompts on the top of the screen to narrow the report to show data that is relevant to your needs.

    • Note: in some cases, you can leave a prompt blank. You can search individually, for example by Invoice Number or Party Name

  • The following criteria can be used to help you filter your search:

Field

Description

Payment Date

This field can be used to narrow down your search by payment date of invoices. Narrow results by selecting a date range for the invoice date. It is important to put in payment dates otherwise it will take longer to load.

Check Number

The number stated on the check.

Invoice Number

The number stated on the invoice.

Party Name

Party Name is the name of the requester or supplier.

Cost Center Code

Cost centers are CO objects and used for internal management reporting.

 

 

Step Four

Interpreting the Report

  • This report can be used for several reasons. When interpreting the report, you can view the following fields in the Payment Report with Invoice Details. Below is a list of each column and a description of its input:

Column

Description

Concatenated Segments

Concatenated Segments identifies unique account combination.

Cost Center Code

Cost centers are CO objects and used for internal management reporting.

Distributed Line Amount

The distributions you enter for an invoice allocate the total invoice amount to various expense or asset accounts.

Payment Date

The date of constructive receipt of pay, on which paychecks become negotiable.

Check Number

The number stated on the check.

Invoice Number

The number stated on the invoice.

Invoice Date

The date the invoice was created.

Invoice Description

Stating what the invoice is about.

Invoice Type Code

The code entered while creating the type of invoice.

Payment History Distribution Amount

Amount of a payment. Payables calculates the Payment Amount for the payment by subtracting the Discount Amount from the Gross Amount.

Validation Status

Displays whether the invoice has been validated or rejected.

Identifying PO

The purchase order number only for purchase orders, not applicable to non-PO invoices

Requisition

The requisition number of the invoice submitted

Cost Center Description

The description of the organization that is paying the invoice, a complete business purpose for the expense

Payment Total

The total payment made for the payment cycle

Payment Posted Status

Whether payment has been initiated for the invoice

Invoice Total

The total stated on the invoice.

Payment Document

The form of payment used for the invoice

Invoice Line Description

Defines information for the invoice lines such as amount, distribution set information, tax determinants, as well as default information to create invoice distributions.

Party Name

The third-party supplier or distributor of the goods or service that was purchased

Party Site Street Address 1

Street address of supplier or distributor of the goods or service that was purchased

Party Site City

City of supplier or distributor of the goods or service that was purchased

Party Site State

State of supplier or distributor of the goods or services being purchased

Party Site Postal Code

Postal Codes allows you to associate a district with country/state/territory/city/postal code combinations.

 

This completes all the Payment Report with Invoice Details processes. 

 

Was this helpful?
0 reviews
Print Article