Category: VendorPay

Available to: Users with ‘Administrator role’ and users with “access all transactions report” permission. 

Pricing Package: Basic

Overview

The 'All Transactions Report' provides a holistic view of Vendor Pay transactions, encompassing ACH debit, ACH credit, ACH refund, vCard refund, and Cashback transactions across all bank accounts, facilitating easy reconciliation for users with their bank statements.

Dashboard View

Filters

Filter

Meaning

Bank Account

List of Bank Accounts used with Vendor Pay.  

Group

Group of locations to run the report on.  

Location

To run a report for a single location, select the location's Group, and choose the location from the dropdown. 

Transaction Date Range

A date must be selected, so either choose a pre-filled Date Range including today's date, yesterday, the last 7 days, month to date, last 30 days, last 3 months, last 1 year, or a custom Date Range.

Transaction Dates

Mandatory date field that is pre-populated if a Date Range is selected, or can be manually populated by entering a start and end date.  These dates are inclusive, meaning 06/01/19 will return data from June 1st as well.

Vendor

To view payments from a particular vendor

Email

Pre-populated with the user's email address.  Additional emails can be included by appending other comma-separated emails.

Data

Column

Meaning

Transaction type

ACH debit / vCard debit / ACH refund / vCard refund / Cashback

Transaction date

Date the transaction happened

Transaction amount

Dollar value of the transaction

PIQ checkrun number

Plate IQ’s checkrun number

Client bank account number 

Account number of the bank account the particular transaction happened in

Client bank account name

Name of the bank account the particular transaction happened in

Description

Transaction description

Location name

Location name

Vendor name

Vendor name

Acc sw Payment Ref number

Payment reference number from accounting software if the checkrun was created through the disbursement workflow

 


Sample