Vendor Reconciliation Summary

The Vendor Reconciliation Summary 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 Detail Report, this report provides a quick view as to the AP Transactions that occurred, the Payments made, and the Amount Remaining. Click here to see a more detailed version of this report.

Navigation

To navigate to the Vendor Reconciliation Summary Report, click 'My Reports' under 'Reports' in the left pane and then select 'Vendors' in the top header of the reporting window. Once opened, a listing of reports will be shown.

Find 'Vendor Reconciliation Summary' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be set to pinpoint the exact report a User needs.

Report Parameters

1. Filter By - A listing of all Location categories

2. Filter - A listing of all Locations associated with the selected Location category 

3. GL Date - This option will either show or hide the GL Date on the report

4. Report Date - The date the report is ran as of 

5. Vendor - A listing of all Vendors based on the Location(s) selected. Only one Vendor can be selected

6. Vendor Balance - This is the total amount due to the Vendor from the statement

7. 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

8. 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

9. Statement Dated - This provides the option of including a Statement Date, which is the cut off date for transaction unless specified otherwise via the other parameters

10. 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

11. 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

12. 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. Click here to learn more about this functionality

Click here to learn more about Report Views and their added functionality.

Report Columns

1. Trx Date - The date noted on the transaction

2. GL Date - The date 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 Trx Date

3. Number - The number assigned by the Vendor or the Payment number assigned by R365. This is hyperlinked to the transaction

4. Transaction Type - The type of transaction assigned in R365 (AP Payment, AP Invoice, or AP Credit Memo)

5. Legal Entity Name - The name of the Legal Entity assigned to the Location on the header of the transaction

6. Account Number - The number associated with the GL Account

7. Account Name - The name of the GL Account, as noted on the first line of the GL distribution. When there are more than one GL Account, 'Multiple' will be displayed

8. Location Number - The number associated with the Location

9. Location Name - The name of the Location, as noted on the first line of the transaction. When there is more than one Location on the transaction, 'Multiple' will be displayed

10. Invoice Amount - The amount of the invoice

11. 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

12. Amount Remaining (Date) - This is 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 (1.00) and red in color

13. Current Amt Remaining - This is the open amount of the transaction as the date the report is ran

14. 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. Click here to learn how to send, export, or print this report.