Vendor Reconciliation Detail

Prev Next

The Vendor Reconciliation Detail Report will run for a single Vendor as of a specific cut-off date so that a vendor's statement can be reconciled and inconsistencies can be addressed. This report will display all the AP Transactions entered into R365 with an open/amount remaining on or before the statement date, allowing for a precise date range to view and reconcile transactions.

Unlike the Vendor Reconciliation Summary report, this report provides a break down of an AP Payment or AP Invoice distribution when multiple accounts or Locations are expensed. See a more summarized version of this report.


Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

  1. Open the Reports app. 
  2. Navigate to My Reports
  3. Enter all or part of the report name in the search bar.
  4. The Results tab will open with the list of search results.
  5. From beneath the report name, click Run to run the report with the selected report view.
    -OR-
    Click Customize to adjust the report parameters and run the report. 



Report Parameters

Field/Column

Description

Filter By

A list of all filter categories. Filter categories will vary based by report.

Filter

A list of filter options determined by the 'Filter By' category selected.

GL Date

This option will either show or hide the GL date on the report.

Report Date

The date the report is run as of.

Vendor

A listing of all vendors based on the location(s) selected. Only one vendor can be selected.

Vendor Balance

The total amount due to the vendor from the statement.

Invoice Cut Off

The cut off for invoices. The user can enter any whole number, including a negative number, to indicate a number of days before or after the statement date to include invoices on the report. This will override the statement date.

Payment Cut Off

The cut off date for payments and credit memos. The user can enter any whole number, including a negative number, to indicate a number of days before or after the statement date to include payments and credit memos in the report. This will override the statement date.

Statement Dated

Provides the option of including a statement date, which is the cut off date for transactions unless specified otherwise via the other parameters.

Show Fully Paid Invoices Since

This option will either show or hide invoices paid on or after this date but not on or before the statement date or the invoice/payment cut off date. By default, a transaction with a $0 amount remaining will not display on the report.

Show Fully Applied Payments Since

This option will either show or hide invoices paid on or after this date but not on or before the statement date or the invoice/payment cut off date. By default, a transaction with a $0 amount remaining will not display on the report as an individual line.

Run Button

Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action.


Report Columns

Field/Column

Description

Trx Date

The date noted on the transaction.

GL Date

The date of the invoice. Only the AP invoice has a GL date, while the GL date for an AP payment and a credit memo is also the transaction date.

Number

The number assigned by the vendor or the payment number assigned by R365. This is hyperlinked to the transaction.

Transaction Type

The type of transaction assigned in R365 (AP payment, AP invoice, or AP credit memo).

Legal Entity Name

The name of the legal entity assigned to the location on the header of the transaction.

Account Number

The number assigned to the GL account.

Account Name

The name of the GL account used on the first line of the GL distribution. When there is more than one GL account, 'Multiple' will be displayed.

Location Number

The number assigned to this location.

Location Name

The name of the location on the first line of the transaction. When there is more than one location on the transaction, 'Multiple' will be displayed.

Location Amt

The amount for a location when multiple accounts and/or locations are expensed by one invoice. These are the amounts distributed by location.

Invoice Amount

The amount of the invoice.

Payment Amt

The amount paid. This will differ based on its transaction type. If it's an AP invoice, then this is the total amount of applied payments using the cut off date. If it's an AP payment, then this is the total amount of the unapplied payment.

Date Paid

The date the payment or credit memo is applied to the invoice.

Payment Ref

The R365 document number assigned to the payment or credit memo.

Applied Amt

The portion of the payment or credit memo that is applied to this invoice.

Amount Remaining (Date)

The open amount of the transaction as of the cut off date. When the amount remaining is for a payment or credit memo, the amount will be negative (e.g., -1.00) and shown in red.

Current Amt Remaining

The open amount of the transaction as of the date the report is run.

Running Total

The amount remaining as a running total.


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to send, export, or print this report.