Loading
Uniconta
Search
Generic filters
Free trial signup
  • Visit a Country Site
    • Dansk
    • Deutsch
    • Eesti
    • Íslenska
    • Lietuvis
    • Nederlands
    • Norsk
    • English
  • Search
  • Uniconta
    • What is Uniconta ?
    • Modules
    • Ledger
    • Customer
    • Sales Order
    • Vendor
    • Purchase
    • Inventory
    • Logistics
    • Project
    • Light Manufacturing
    • CRM
    • Fixed assets
    • Dashboard
    • Company
    • Adaptability
  • Download
    • Uniconta for Windows
    • Uniconta for Mac
    • Download for Developers
    • Free trial signup
  • Resellers
    • Find a reseller
    • Become a reseller
    • Partner Portal Login
    • Partner Portal sign up
  • Developers
    • Become an integration partner
    • Documentation
    • Samples
    • Downloads
  • Accountants
    • Become a Univisor
  • News Overview
    • Blog
    • News
    • Uniconta Update
    • Customer cases
  • About us
    • About us
      • Management
      • Contact
      • IT Security ISAE 3402
      • System status
    • Terms & Conditions
      • License Agreement
      • Data Processing Agreement (DPA)
      • Privacy policy
      • Cookie policy
      • Sub-processors

Unipedia

  • Introduction
    • Get started with Uniconta
    • Which browser are you using?
    • Get started with an existing set of accounts
  • Converting to Uniconta
    • Conversion tool
    • What can be converted to Uniconta?
    • Converting from NAV to Uniconta
    • Converting from e-conomic to Uniconta
    • Converting from C5 to Uniconta
    • Converting from eCtrl to Uniconta
    • Checking your accounts after conversion
  • General Ledger
    • How to split voucher PDF
    • Chart of Accounts
      • Chart of Accounts
      • Account types
      • System Accounts
      • Import a Chart of Accounts
    • General journals
      • Journal Entries
      • Import from a file
      • Import Bank statement
        • Automatic account selection
      • Posting in foreign currency
      • Posting customer payments
      • How to manage voucher number series
      • Setting up Journals
      • Cancel voucher/delete journal/delete record
    • Bank Reconciliation
      • Bank Management / Bank reconciliation
      • Automatic account selection
    • Budget
      • Budget
    • Reports
      • Account statements
      • Transactions
      • Financial Statement
      • Physical Vouchers
      • Posted Journals
    • VAT reporting
      • VAT reporting – Denmark
      • VAT specification – Denmark
      • EU sales
      • Intrastat
      • EU sales list
    • Pivot table
    • Maintenance
      • Dimensions
      • – Join two dimensions
      • – Reverse charged VAT – Denmark
      • Voucher number series
      • – Automatic allocation of number series
      • Terms of payment
      • – Managing cash discounts
      • Accounting year
      • – Year end closing/opening balances
      • Join two accounts
    • Audit activities
      • Company accounts templates
      • Export transactions
  • Customer
    • Customer
      • Customer
      • – Reconciling Customer Accounts
    • Quick invoice
      • Quick invoice
    • Sales
      • Sales orders
      • – Create purchase/sales order
      • Quotations
      • Mass update
      • – Generate UBL
      • – Purchases and sales without VAT
      • Order journal
    • Reports
      • Statement
      • Transactions
      • Open transactions
      • Payment proposals (SEPA)
      • Ageing report
      • Interest and collection letter
        • – Collection letter messages
      • Invoices
      • Delivery note
      • Stock transactions
      • Order lines
      • Customer statistics
      • Pivot table
    • Maintenance
      • Customer groups
      • Order groups
      • Shipments
      • Terms of delivery
      • Layout groups
      • Number sequences
        • – Error messages
      • Invoice layout
        • – Creating watermarks
      • E-mail setup
        • – Setting up SMTP
        • – Mail server set up
        • – Forwarding e-mails to Uniconta
      • Document messages
      • SEPA set up
      • Mandates (SEPA)
      • Customer Direct Debit
      • Join
        • Join two accounts
        • Join two sales orders
        • Join many
  • CRM
    • – Introduction to CRM
    • Prospects
      • – Creating an quotation for a prospect
      • – Create follow-up
    • Customers & Prospects
    • Follow-up activities
    • Create e-mail list
    • Campaign
    • Maintenance
      • Interests
      • Products
      • CRM groups
      • Follow-up groups
      • Campaign groups
  • Vendor
    • Mass update
    • – Purchases and sales without VAT
    • Reports
      • Statement
      • Merge payments
      • Ageing report
      • Pivot table
    • Maintenance
      • Vendor groups
      • Purchase order groups
      • Vendor layout groups
      • Number sequences
      • File formats for methods of payment
        • – Setting up messages for vendor payments
        • – Setting up bank days
      • Join
      • – Join two accounts
      • – Join two purchase orders
      • – Join many
  • Inventory
    • Items
    • Stock Journal
    • – Posting in the stock journals
    • – BOMs in Uniconta
    • – Handling packaging fees
    • Reports
      • Inventory account statement
      • Inventory transactions
      • Item stock status
      • On-hand
      • Re-order list
      • Pivot table
    • Maintenance
      • – Purchasing number series items
      • Join two items
      • Variants
        • – Default variants
        • – Importing old inventory transactions
  • Project
    • Get started with Project and Time
    • Invoicing in the project module
    • Project Categories
    • Pivot table
    • Project groups
  • Company
    • Company information
    • View a demonstration company
    • User rights
      • Manage users
      • Requests for company access
      • Request company access
    • Maintenance
      • Configure application functionality
      • Preferences
      • Subscription (Administrators)
      • – Create subscription (Administrators)
      • – Create subscription (Client)
      • – From trial period to subscription
      • – Counting financial items
      • – Azure Authentication in Uniconta
      • Modification URL
      • Create a new company
    • Contacts
  • Administrator
    • Distributor Administration
    • User Login History
    • Partner Plugin
  • Tools
    • Main Menu
    • Save layout as a menu item
    • User Plugin
      • How to change Uniconta’s default plugin path
    • Report Generator
      • Report Generator
        • Acccount statement
        • Collection letter documents
        • Company accounts cover page
        • Picking list
        • Purchase documents
        • Sales documents
      • Create a report to be viewed externally
      • Expression binding for Reports
    • Additional setup
      • Local backup
      • Import e-conomic
  • Data Access
    • Transfer data from Uniconta to Excel
    • OData filter function
  • General
    • User Interface
      • User Profile
      • Shortcut Keys in Uniconta
      • Layout
      • Templates
      • How to search in Uniconta
      • Filter/Clear Filter
      • General tips
    • General Functions
      • Attachments
      • Copy and paste in Uniconta
      • Export data and reports to file format
      • Send documents and data by e-mail
      • Print reports and list forms
      • National company number lookup
      • Excel, export and import
    • Security
      • Forgot Password
      • Backup
      • Uniconta Security
    • Installation
      • Installation on RDS – Remote Desktop Server
      • Optimal internet access for Uniconta
      • Install Uniconta in Windows 7
      • Uniconta in the Microsoft App-Store
      • Uniconta for Mac
Search
Generic filters

File formats for methods of payment

741 views 24 June 2017 25 April 2018
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
April 25th, 2018

Before setting up vendor payments, users need to make sure that the bank accounts and file formats for methods of payment are set up as follows:

 

Bank accounts

To set up one or more bank accounts, use the navigation panel to go to General Ledger/Bank reconciliation, and click on ‘Add bank account’ as shown in the screenshot below.

 

 

The IBAN and SWIFT numbers should be filled out, if foreign payments are to be made.

 

File formats for methods of payment

Next, set up a ‘File format for methods of payment’ for each bank account. This can be done under Vendor/Maintenance/File formats for methods of payment and click on ‘Add payment format’.

 

 

Form description

Formatting
Enter an ID for the method of payment, for example ‘DB’ for Danske Bank.

Name
Description of the method of payment, for example, ‘Danske Bank professional account’.

Default
Check this box if this will be the primary method of payment.

Payment format
Select from the payment formats available in Uniconta from the dropdown box. The following formats are currently available.

In Denmark, for example, Danske Bank (DanskeBank_CSV) and Nordea (Nordea_CSV) have their own format.

Other Danish banks use BankData, BEC_CSV or SDC.

This article does not describe ISO20022 formats.

Grouping

Grouping is used for merging payments to the same vendor using various principles (under Vendor/Reports/Payment proposal) as described here. (English translation coming soon.)

‘Invoice’, for example, creates payments by invoice.

Bank account

Enter the bank’s ledger account.

Journal

Enter the posting journal to be used for posting these payments. The field can also be left blank.

Message

User defined message for the payment recipient. Read more here.

 

 

Making payments via the Vendor module

Payment information should be completed for each vendor.

The following section describes the different methods of payment currently available in the Uniconta system.

 

Methods of payment: Vendor bank account

The method of payment to a vendor is set up as follows:

 

Use the navigation panel to go to Vendor/Vendor.  Click on ‘Add’.  The ‘method of payment’ is entered in this form under ‘Group’, as shown in the screenshot below.

 

 

In Denmark, for example, the vendors bank account is often called the BBAN (Basic Bank Account Number).

A Danish bank account number should be entered as the payment identification as per the following example:

 

 

The first 4 characters are the Danish bank registry number and the remaining characters relate to the account number.

The payment identification field is in fact an alpha numeric free text field, so the account number could be entered in several ways, as shown below.

All alpha numeric values will be removed when it is exported to the payment file,

The only requirements are:

  • The bank registry number is given before the account number;
  • The bank registry number should  always be four numbers;
  • The account number will be read as all numbers appearing after the registry number. Uniconta automatically inters the zero’s required before the account number.

For example, the following could be entered as the payment identification number:

  • 66107051101114
  • 6610 7051101114
  • 6610-7051101114
  • 6610/7051101114
  • Regnr: 6610 Account number: 7051101114
  • 6610567689
  • 6610-567689
  • 6610 567689
  • 6610/567689
  • Regnumber: 6610 Account: 567

Foreign bank account numbers that are not IBAN’s can also be entered. In this case, the SWIFT code must be entered. Foreign bank accounts do not require a registry number and the length of the account number.

Payment method Betal: IBAN

When sending money abroad, both an IBAN and a SWIFT code should be entered as follows:

  • Enter the SWIFT code in the ‘SWIFT’ field.
  • Enter the IBAN number in the payment identification field.
  • Was this Helpful ?
  • YesNo
Categories: Unipedia, Vendor

Get in touch with us

Uniconta

  • Uniconta
  • Modules
  • Downloads
  • Free trial signup
  • Subscription Terms
  • System Status

PARTNER

  • Become a Reseller
  • Become App Partner
  • For Developers
  • For Accountants (Univisor)
  • Uniconta Partner Portal

INFO

  • News
  • Updates
  • Customer cases
  • Video
  • IT Security
  • About us
  • Management

Support

  • Unipedia
  • API information
  • Contacts
  • Visit a Country Site
    • Dansk
    • Deutsch
    • Eesti
    • Íslenska
    • Lietuvis
    • Nederlands
    • Norsk
    • English
Uniconta
© Copyright 2019 | All rights reserved | info@uniconta.com | Terms & Conditions
Facebook LinkedIn Youtube