Vendor Bill Payment reportLast updated on 09/12/2022

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

Click Next.

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.

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.