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 | |
|---|---|---|
1 | Filter By | A list of all filter categories. Filter categories will vary based by report. |
2 | Filter | A list of filter options, determined by the 'Filter By' category selected (#1). |
3 | 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. |
4 | 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. |
5 | Check Run | A listing of all check runs. |
6 | Date Format | The date format options available for the report:
|
7 | 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. |
8 | View Options | This section provides options to select, save, edit, or delete a report view. |
9 | 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 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) |