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

Import Bank statement

770 views 19 January 2017 27 June 2018
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
June 27th, 2018

In Uniconta, there are two places where Bank statements can be imported using the navigation panel and going to either:

 

General Ledger/Posting or;

General Ledger/Bank reconciliation.

 

The difference between the two import methods are that a bank reconciliation ensures than the same transaction is not imported more than once. A bank reconciliation also imports payment forms (such as the Danish FI card) and ensures that transactions are settled automatically.

These days, banks can send statements in an external file. These can be imported into Uniconta’s journal or bank reconciliation functions and further information can be added before posting in Uniconta.

Read more on performing a bank reconciliation in Uniconta here.

 

Method 1: Import the file via General Ledger/Posting:

 

 

Click on the ‘Import bank statement’ button in the toolbar/ribbon as shown in the screenshot above.  The detail form below will appear.

 

 

NOTE: A ‘Bank account’ is only available for selection in the dropdown menu if it has been set up as a ‘Bank’ (not just as an ‘Asset’ account) in the Chart of Accounts.  Read more about how to set up account types in the Chart of Accounts here.

Use ‘Column (Bank)’ to choose whether the bank should be the account or the offset account.

‘Reverse sorting’, sorts the transactions by latest/earliest date.

‘Last date’ is the date of the last import.

Use the ‘Browse’ button (shown in the screenshot above) to find the file that is to be imported. The ‘Attach’ button is only used for additional documentation.

 

OR:

Method 2: Import the file via General Ledger/Bank reconciliation:

 

 

Click on the ‘Import bank statement’ button in the toolbar/ribbon as shown in the screenshot above. The detail form below will appear.

 

 

 

‘Reverse sorting’, sorts the transactions by latest/earliest date.

‘Last date’ is the date of the last import.

Use the ‘Browse’ button, shown in the screenshot above, to find the file that is to be imported. The ‘Attach’ button is only used for additional documentation.

 

 

Description of buttons in the ‘import bank statement’ toolbar/ribbon:

  • ‘Add file format’
    • Adds a new format to the list. (See also ‘Bank file format setup’ below).
  • ‘Edit file format’
    • Edits a format that has already been set up. (See also ‘Bank file format setup’ below).
  • ‘Automatic account selection’
    • See description of Automatic account selection.
  • ‘Import’
    • Click on this button to import the bank statement.

 

Bank file format setup

Click on ‘Add file format’ or ‘Edit file format’ to add/edit a new bank file format. This allows the user to add/edit the file import method.

 

 

Description of buttons in the ‘Add/edit file format’ toolbar/ribbon. 

  • ‘Save’
    • Saves the format.
  • ‘Cancel’
    • Cancels changes or setup of file format.
  • ‘Delete’
    • Deletes a format from the list of formats.
  • ‘Templates’
    • Retrieves saved file import setup templates.

 

Description ‘file format’ fields.

  • ‘File format’
    • Adds a new format to the list of formats.
  • ‘Field delimiter’
    • Insert the punctuation (e.g. a comma or semicolon) that should separate the fields in the file.
  • ‘Date format’
    • Date format in the file.
  • ‘Skip lines’
    • Indicate whether to skip lines in the file. For example, if a bank statement file includes a heading that is one line, then insert a ‘1’ here and the first line will be skipped upon import.

‘Field position in the file’.  Order that fields are to appear in the bank statement. 

  1. Date
  2. Text
  3. Amount
  4. Voucher
  5. Invoice
  6. Physical voucher
  7. Offset account
  8. Payment reference
  9. Payment identification
  10. Amount (Payment identification)
  11. Position (Identification). Which fields contain the debit and credit information (if +/- signs are not used).
  12. Identification – Debit (Debit identifier e.g.”D”)
  13. Identification – Credit (Credit identifier e.g. “C”)
  14. IBAN number

 

Description of payment codes (e.g. FIK set up, Denmark specific)

In order to set up recognition of payment codes correctly (e.g. Danish FIK codes) it is necessary to analyze the bank file.

 

 

For example, the screenshot above is from a Danish file, showing that FIK payment code starts with “IK71 0000”

This is imported in field 8, ‘Payment Identification’

The FIK text is also in field 2.

So field 7, ‘Payment reference’ should be “2”

Payment codes can be set up using the navigation panel under Company/Company information.

For example, in Denmark, the ‘FIK’ payment code is entered, as shown in the screenshot below.

  • Was this Helpful ?
  • YesNo
Categories: Unipedia

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