Vendor Bill Payment reportLast updated on 09/12/2022
With Payables, you can send Bill payments to remittance vendors. Run the Vendor Bill Payment report so you can see all of your Virtual Card (VCard) transactions and calculate monthly vendor rebates.
Things to know
Vendor rebates are 1% of VCard payments.
If a payment is processed at the end of the month and it is cleared in the following month, the rebates for the VCard payment are distributed in the next payment cycle.
Create a report
Go to the navigation bar and click Reports .
Click Create Report.
The Report Builder opens.
Under the Choose report type column, click Others. Under the Select a report template column, click Bill Payment. A list of columns available for the Bill Payment template displays.
Click Deselect All.
Select each of the following columns:
Remittance Vendor Name—Name of the remittance vendor
Payment Method—Method of processing the bill payment
Date—Date of bill payment
Approved Date—Date that bill payment is approved
Payment Amount—Amount of the bill payment in dollars
Payment Status—Status of the bill payment
Payment Delivery Method—Method that the bill payment is delivered to the vendor. ACH, VCard, or Check
Enter the report’s name. For example, “
Bill Payment Report”.
Click the Category dropdown and select Accounting. For more information, see Create custom reports.
When you're done, click Save.
The report opens.
Run the report to calculate rebates
Go to the navigation bar and click Reports . The All Reports screen opens displaying reports on cards in a grid.
Click the name of the bill payment report you created. The report opens.
Tip: Enter the first few letters of the report title in the search bar to filter the list of reports.
Use the From and To calendar fields to set a range of dates to run the report on.
Click the Export Status dropdown and Select Pending, Posted, and Exported.
When you’re done setting filters for your report, click Run Report.
Click Filter next to the Payment Delivery Method column.
Click the Is one of dropdown and select VCard. Then, click Filter.
Click Export. The Export Report pop-up opens.
Select Export as XLSX (MS Excel)and click Export.
The XLSX file is downloaded to your web browser.
Open the XLSX file. Take the Sum of the Payment Amount column and multiply it by 1%. For example, if the sum is $1105, then the rebate is $11.05.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.