How to export vendor payments?
  • 26 Jan 2024
  • PDF

How to export vendor payments?

  • PDF

Article Summary

In this charper we will explain how to export vendor payments file.
Exported file must be uploaded to Bank manually.

Important

At the moment you can export payment file only for Barclays Bank (UK).

How to prepare payment lines?

Payments to vendors should be prepared in Payment Journals.
It is standart Business Central functionality and Bankfeed does not require to add any additional information.

Payment journal lines can be filled:

  • Manually, by entering all payment data in payment journal line.
  • Using function Suggest Vendor Payments (Prepare -> Suggest Vendor Payments).

Then payment lines are prepared, we can export them.

Mandatory information in journal line

There are some fields which should be filled before export and without it, export won't work.

  • "Recipient Bank Account"- vendor's (customer's) bank account information. Vendors Bank account card must be filled with all necessary information.
  • "Payment Reference" - enter what you are paying for.
  • "Bal. Account No." - company bank account card must be set and filled with all information.
    If any information is missing you will get an error message saying what is missing.

image.png

When you will fill it, click "Clear Exported to Payment File (Bankfeed)" and Export the line once again.

How to export payment lines?

To export prepared payment lines click Bank -> Export Payment (Bankfeed).

image.png

All lines in the journal will be exported. If you want to export just some of the lines, you have to filter them first.
Then export is done, you will get a downloaded file with transactions, which should be uploaded to Bank manually.

image.png

Exported lines will a value in field Exported to Payment File (Bankfeed) and will not be exported once again.

image.png

How to export the same payment lines once again?

To export the same lines once again you have to remove Exported to Payment File (Bankfeed) from the lines you want.
To do this select the lines you need and click Bank - > Clear Exported to Payment File (Bankfeed).

image.png

This will remove Exported to Payment Files (Bankfeed).

How to see what is already exported?

You can find a register of exported payment in page Payment Registers (Bankfeed).

image.png

To open detailed payment entries, click Entries in action pane.

image.png

Page Payment Register Entries (Bankfeed) is opened, where you can see all information from the payment lines.

image.png

In Payment Registers (Bankfeed) you can download the prepared payment file once again, by clicking Download Transformed File.

image.png