Banking File - UK - BACS
This page contains some guidance about where to enter information in order for it to be included correctly in
Banking File export files when they are produced using the UK - BACS
Payment File Format.
Configuration
- In the Contact records for each Supplier:
- Enter the Supplier's bank account number in the Bank Account field and the Sort Code of the Supplier's bank in the Sort Code field (without hyphens or spaces). This information will be exported from the Contact records for each Supplier, not from the Payment rows. So if you forget to enter a Supplier's bank details before entering a Payment, you can make the correction in the Supplier record before exporting. However, any changes that you make to a Supplier's bank details in a Payment row won't be exported.
- If the Supplier has a Factoring Supplier, follow step (a) above for that Factoring Supplier. Payments will be sent to the Factoring Supplier.
- In the Payment Modes setting:
- Enter your bank account number in the Bank A/C No. field in each Payment Mode.
- Enter the Sort Code of your bank in the Sort Code field (without hyphens or spaces).
Purchase Invoices
- Specify a Supp. Inv. No. in each Purchase Invoice.
Payments
- Select "Per Supplier" as the Payment Format on the 'Bank' card if appropriate.
Exporting
- If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier if you want those rows to be grouped together in the export file. If selected, all Payments will be exported on a One Payment per Supplier basis. If not selected, only those Payments where the Payment Format is Per Supplier (step 4 above) will be exported on that basis.
---
Export functions in the Purchase Ledger and Integration modules:
- Introduction
- Banking File, including:
- Australia - ABA
- Czech banking file formats (includes Czech - ABO and Czech - CITI bank)
- Danish banking file formats (includes BGBank, Den Denske Bank, Jyske Bank, Midtbank, SYDBANK and Unibank)
- Estonia - Riigikassa
- Finland - SEPA
- Germany - SEPA
- Hungary - HVB
- Latvian banking file formats (includes
FidaVista and SEPA)
- Lithuanian banking file formats
(includes LITAS-ESIS 1.1 and SEPA)
- Namibia
- New Zealand banking file formats (includes ANZ, ASB, BNZ, KiwiBank, National Bank and Westpac)
- Norwegian banking file formats (includes DnB Telepay, K-Link, SparNett, Postbanken and Telepay 2)
- Polish banking file formats (includes BPH, ING Bank and Reiffaisen Bank)
- Spain - SEPA
- Swedish banking file formats (includes Handelsbanken, Nordea, PostGirot, SE-Banken and Swedbank)
- UK - BACS
- Intrastat Purchase Invoices UK
- Open Purchase Invoices
- P/L Liquidity List
Go back to:
