Payment Disbursements Export

Prev Next

The Payment Disbursements Export uses previous check run information to display the payments made and the details attached to those payments. This export is beneficial in reviewing information tied to check runs and saving this information for records.


Navigation

To navigate to the Payment Disbursements Export, click 'My Reports' under 'Reports' in the left pane and select 'Banking' in the top header of the reporting window. Once opened, a listing of reports will be shown.

Find 'Payment Disbursements Export' and select 'Customize' next to the report. This will open up the Report Parameters that can be used to define your export.


Report Parameters

Field

Description

Filter By

A list of all filter categories. Filter categories will vary based by report.

Filter

A list of filter options, determined by the 'Filter By' category selected (#1).

Start

First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates.

End

Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates. 

Check Run

A listing of all check runs.

Date Format

The date format options available for the report:

  • MM/DD/YYYY

  • YYYY-MM-DD

One Invoice Per Row

True - Each invoice will be displayed on a separate row.

False - Each invoice will not be displayed on a separate row and will instead be grouped by transaction ID.

View Options

This section provides options to select, save, edit, or delete a report view.

Download

Downloads the report.

Learn more about Report Views and their added functionality.


Report Columns

Column

Description

Financial Institution ID

The ID number associated with the bank.

Bank Account Type

The type of bank account used (Checking, ZBA (Zero Balance Account), or Savings).

Bank Routing Number

The routing number for the bank account used.

Bank Account Number

The account number for the bank account used.

Bank Account ID

The ID number associated with the bank account.

Bank Account Name

The name of the bank used.

GL Account Name

The name of the bank account used.

Legal Entity Name

The Legal Entity that owns this bank account.

Legal Entity ID

The number associated with the Legal Entity ID.

Legal Entity Tax ID

The Tax ID associated with the Legal Entity.

File Date

The date this payment was issued.

Transaction ID

The date and time this report was ran.

Amount

The amount paid.

Location ID

The ID number associated with the restaurant Location that made this payment.

Location Name

The name of the restaurant Location that made this payment.

Invoice Numbers

The invoice numbers associated with this payment.

Invoice Dates

The dates on these invoices.

Invoice Amounts

The amounts on the invoices.

Invoice Totals

The total amount from all invoices.

Invoice Descriptions

These descriptions include the transaction type, the Vendor name, and the invoice number.

Invoice Image URL

If an invoice has a hyperlink and is viewable, it will be entered here.

Check Number

The number of the check used for payment.

Vendor ID

The ID number associated with the Vendor.

Vendor Number

The number associated with the Vendor that received the payment.

Vendor Name

The name of the Vendor that received the payment.

Vendor Check Name

The check name entered on the vendor record.

Vendor Address Line 1

The Vendor's street address.

Vendor Address Line 2

An additional line used for a unit number.

Vendor City

The city of the Vendor Location.

Vendor State

The state of the Vendor Location.

Vendor Zip

The zip code of the Vendor Location.

Vendor Email

An email address associated with a Person of Contact at the Vendor Location.

Vendor Bank Account Number

The account number for the Vendor's bank account.

Vendor Bank Routing Number

The routing number for the Vendor's bank account.

Vendor Bank Account Type

The type of bank account the Vendor uses (Checking, ZBA (Zero Balance Account), or Savings).

Payment Run

The payment run number that the payment is associated with.