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.
- Date
- Text
- Amount
- Voucher
- Invoice
- Physical voucher
- Offset account
- Payment reference
- Payment identification
- Amount (Payment identification)
- Position (Identification). Which fields contain the debit and credit information (if +/- signs are not used).
- Identification – Debit (Debit identifier e.g.”D”)
- Identification – Credit (Credit identifier e.g. “C”)
- 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.