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.
- If you select the Unexported Only option in the 'Specify Banking File' window, Payments in the range that have not been marked as Ordered and those that have been marked as Ordered will be exported. Payments that have been marked as OK will not be exported. After the export process, any unordered Payments in the range will be marked as Ordered automatically. If you need to export a Payment that has been marked as OK, select the All option in the 'Specify Banking File' window but be careful when specifying the range of Payments to be exported as any Payments in the range that have previously been exported will be exported again. Payments and individual Payment rows that have been invalidated will never be exported.
---
Export functions in the Purchase Ledger and Integration modules:
- Australia - ABA
- Croatia (Croatia - SEPA)
- 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)
- Estonian banking file formats (includes Riigikassa and Swedbank Gateway)
- Finland - SEPA
- Germany - SEPA
- Hungary - HVB
- Italy - SEPA
- 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, Telepay 2 and SEPA)
- Polish banking file formats (includes Elixir, ING Bank and Reiffaisen Bank)
- South Africa - First National Bank
- Spain - SEPA
- Swedish banking file formats (includes Handelsbanken, Nordea, PostGirot, SE-Banken, Swedbank and SEPA)
- UK - BACS
Intrastat Purchase Invoices UK
Open Purchase Invoices
P/L Liquidity ListGo back to:
Introduction to Exports in the Purchase Ledger
