Report Title: Payment Register

Category: Bill Pay

Available to: Users with access to Bill Pay

Pricing Package: Basic


Overview

The Payment Register report returns a list of payments (checks & ACH) sent out in a given time period.


Bill Pay users can use this to see how cash flows out for each Bank Account queried.


Dashboard View




Filters


FilterMeaning
Bank AccountList of Bank Accounts used with Bill Pay.  Leaving this blank will return payments sent from all bank accounts.
GroupGroup of locations to run the report on.  To run the report on all locations, leave this blank.
LocationTo run a report for a single location, select the location's Group, and choose the location from the dropdown. 

Invoice 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.
Invoice Date
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.
VendorTo view payments from a particular vendor
EmailPre-populated with the user's email address.  Additional emails can be included by appending other comma-separated emails.



Data


ColumnMeaning
Payment DateDate that the payment was created
Payment NumberEither the ACH # or Check #
Location NameLocation Name
Bank Account NameName of the bank account used in Bill Pay that the payment was sent from
Vendor NameVendor name, as it's read on the invoice
AmountPayment total
InvoicesArray of invoices that were paid

 

Note: If a single payment was used for many invoices across many locations, filtering on Group/Location will return the payment in full.  That is, a hypothetical payment across 5 locations for a total of $5,000 will show a $5,000 payment even if you filter on 1-4 of those locations.


Sample