This question has been flagged
1 Reply
1755 Views

I would like to export all of the following information for each Payment in a Vendor Batch Payment:

1. Routing Number

2. Account Number

3. Amount

4. Vendor Tax ID

5. Account Holder Name

Avatar
Discard
Best Answer

If you have already created a Bank Account record linked to your Vendor:


And you have a Payment like this:


That you include in a Payment Batch like this:


You would then switch to the List View of Batch Payments, select the payment (or payments) you want to export:


Then add the following fields to the Export Wizard:

Note: you need to expand the fields and "drill down" to get to the information you want, and choose either XLSX or CSV on the Wizard.


This gives you the following file:


If you want additional information, go back to a single Vendor Payment and review any other information you would want and find those fields also:

  • Payments/Date
  • Payments/Reference (for Memo)
Avatar
Discard