• Michael Intravartolo

How to: Export Payments to a Bank File


When you are ready to make payments to your vendors using the Payment Journal window, you can export a file with the payment information on the journal lines. You can then upload the file to your electronic bank to process the related money transfer.

In the generic version of Dynamics 365 for Financials, a global provider of services to convert bank data to any file format that your bank requires is set up and connected. In North American version, the same service can be used to send payment files as electronic funds transfer (EFT), however with a slightly different process. See step 6 in the "To export payments to a bank file" section.

Note: Before you can export payment files from the payment journal, you must specify the electronic format for the involved bank account, and you must enable the bank data conversion service. For more information, see How to: Set Up Bank Accounts and How to: Set Up the Bank Data Conversion Service. In addition, you must select the Allow Payment Export check box in the General Journal Batches window. For more information, see Working with General Journals.

You use the Credit Transfer Registers window to view the payment files that have been exported from the payment journal. From this window, you can also re-export payment files in case of technical errors or file changes. Note, however, that exported EFT files are not shown in this window and cannot be re-exported.

To export payments to a bank file

1. In the top right corner, choose the Search for Page or Report icon, enter Payment Journals, and then choose the related link.

2. Fill payment journal lines, for example, by using the Suggest Vendor Payments function. For more information, see How to: Suggest Vendor Payments.

3. Fill in the fields on the payment journal lines as necessary. Choose a field to read a short description of the field or link to more information.

Note: If you are using EFT, you must select either Electronic Payment or Electronic payment-IAT in the Bank Payment Type field.

Different file export services and their formats require different setup values in the Bank Account Card and Vendor Bank Account Card windows. You will be informed about wrong or missing setup values as you try to export the file.

When you have completed all payment journal lines, choose the Export action.

5. In the Export Electronic Payments window, fill in the fields as necessary.

Any error messages will be shown in the Payment File Errors FactBox where you can also choose an error message to see detailed information. You must resolve all errors before the payment file can be exported.

Tip: When you use the bank data conversion service, a common error message states that the bank account number does not have the length that your bank requires. To avoid or resolve the error, you must remove the value in the IBAN field in the Bank Account Card window and then, in the Bank Account No. field, enter a bank account number in the format that your bank requires.

6. In the Save As window, specify the location that the file is exported to, and then choose Save.

Note: If you are using EFT, save the resulting vendor remittance form as a Word document or select to have it emailed directly to the vendor. The payments are now added to the Generate EFT File window from where you can generate multiple payment orders together to save transmission cost. For more information, see the following steps.

7. In the Payment Journal window, choose the Generate EFT File action.

In the Generate EFT File window, all payments set up for EFT that you have exported from the payment journal for a specified bank account but not yet generated are listed on the Lines FastTab.

8. Choose the Generate EFT File action to export one file for all the EFT payments.

9. In the Save As window, specify the location that the file is exported to, and then choose Save.

The bank payment file is exported to the location that you specify, and you can proceed to upload it to your electronic bank account and make the actual payments. Then you can post the exported payment journal lines.

To export payments that represent customer refunds

The following describes a work-around for exporting electronic refund payments.

Caution: The resulting payment journal lines cannot be posted, deleted, or voided.

1. Set up the customer as a vendor. Name it "Customer X for Refunds", for example. For more information, see How to: Register New Vendors.

2. On the payment journal line for the customer, set the Account Type field to Customer, and the Document Type field to Refund.

3. Perform the normal steps for payment export as described in the "To export payments to a bank file" section.

To plan when to post exported payments

If you do not want to post a payment journal line for an exported payment, for example because you are waiting for confirmation that the transaction has been processed by the bank, you can just delete the journal line. When you later create a payment journal line to pay the remaining amount on the invoice, the Total Exported Amount field shows how much of the payment amount has already been exported. Also, you can find detailed information about the exported total by choosing the Credit Transfer Reg. Entries button to see details about exported payment files.

If you follow a process where you do not post payments until you have confirmation that they have been processed in the bank, you can control this in two ways.

  • In a payment journal with suggested payment lines, you can sort on either the Exported to Payment File column or the Total Exported Amount and then delete payment suggestions for open invoices for which payments have already been made and you do not want to make payments for.

  • In the Suggest Vendor Payments window, where you specify which payments to insert in the payment journal, you can select the Skip Exported Payments check box if you do not want to insert journal lines for payments that have already been exported.

To see information about exported payments, choose the Payment Export History action.

To re-export payments to a bank file

You can re-export payment files from the Credit Transfer Registers window. Before you delete or post payment journal lines, you can also re-export the payment file from the Payment Journal window by simply exporting it again. If you have deleted or posted the payment journal lines after exporting them, you can re-export the same payment file from the Credit Transfer Registers window. Select the line for the batch of credit transfers that you want to re-export and then use the Reexport Payments to File action.

Note: Exported EFT files are not shown in the Credit Transfer Registers window and cannot be re-exported.

1. In the top right corner, choose the Search for Page or Report icon, enter Credit Transfer Registers, and then choose the related link.

2. Select a payment export that you want to re-export, and then choose the Reexport Payment to File action.

Are you looking for Microsoft Dynamics 365 for Financials support and training? Take a look at our Online Dynamics 365 University at www.dynamics365university.com


Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

Connect With Us
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Chicago
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
Join our Mailing List

© 2020 Solution Systems, Inc.