Loading bank statements

Bank statements can be imported at two places in Uniconta. You can import into the General Journal or from Bank Reconciliation. The big difference between the two imports is that bank reconciliation can ensure that the same transaction is not loaded again. In addition, bank reconciliation can handle payments and ensure automatic settlement of records. Today, all banks can output bank statements to external file that can be imported into the posting journal and bank reconciliation in Uniconta. In this way, the bank statement can be entered in Uniconta's posting journal or bank reconciliation and additional information is added before posting in Uniconta. Read more about bank reconciliation here and watch a video on how to import a bank file into the general journal (from minute 27:00 -34:00 in the video) or from bank reconciliation (from minute 1:00-27:00 in the video ). Watch a video about currency management in Uniconta here. Bank import in currency is presented from minute 28:00-35:00.

Load records into general journal

Press the 'Import bank statement' button under General ledger/General journals, you'll see this screen: ATTENTION! A bank account can only be selected if it is set up as "Bank" under account type in the chart of accounts Read more about how to choose account types in the chart of accounts here. If it is loaded incorrectly, it can be deleted on General ledger / General journals, select the button "delete journal transactions"

Load records for bank reconciliation

Pressing the Load File button under General ledger/Bank Reconciliation displays this screen: Use "Browse" to find the file with the bank statement you have exported from the bank and saved on your local drive. If you have sent the bank statement into "Physical vouchers (Inbox)", you can download it by clicking on "Attach". You can make use of this if not everyone has access to the bank itself, but only needs to be able to reconcile in Uniconta. NOTE: If bank is to be filled in automatically upon loading, then bank account/counter account must be filled in in the setup of journal. Here, the completed account/counter account must be equal to selected here. Read more here Loading wrong file, it can be deleted on "delete imported" button

Fields - Import bank statements

File format: Select bank format from the list. !!!slet!!!NOTE: "PBS FIK" is a fixed-length format. It is NOT a commafile. csv. The file is used for loading banks' FIK files. Be aware here that banks store the file type with all kinds of extension. For example. Dat. In Uniconta, the file should be named .txt. If necessary, rename the file before loading.!!!!!!!!!!!!!slet!!!!! Excel files (XLS*) cannot be loaded directly. They must first be saved as CSV files. Reverse sorting: Reverses the date order in loading. Put the lines on hold: Puts the lines on hold after loading. Last date: Date of last loading. Not required. Select file: Select file to load Attach: Attaches the file to import

Buttons - Import bank statements

Add file format: Adds a new format to the list of formats. (See also "Setting up bank format") Edit file format: Edits an existing format (See also "bank format setup") Auto account selection: See description for Auto account selection. Import: Press this button to Load the bank account statement. View bank statements: Read the description of this button below.

Setting up file formats

File formats can be added or edited using the buttons under Import bank statement. If the Add or Edit File Format buttons are pressed, the way a file is loaded can be changed. The file format can also be set up using the View Bank Account Statements button, as described further down in the article.

Buttons - Setting up file format

Save: Saves the format. Cancel: Cancels changes or creating a file format. Delete: Deletes a format from the list of formats. Templates: Retrieves saved templates for setting up import files.

Fields - Setting up file format

Field name	Field Description
File format	Enter or change the name of the file format
Formatting
Field delimiters	Here is put the character that separates the fields in the file. Typical comma or semicolon.
Date format	The date format of the file.
Skip lines	This indicates whether to skip the top line(s) of the file. For example, if the file contains a header, then 1 is entered in this field so that the first line is skipped when loading.
Field position in the file	In the fields below, enter the field number where the current information is located in the file.
The date	If the date is in field 1 of the file, enter 1 in this field.
Text	See description above
Amount	See description above
Attachments	See the description above
Invoice	See description above
Physical appendix	See description above
Counter account	See the description above
!!slet!! Payment reference FIK!!slet!!!	!!slet!!Enter the number of the field in the file that contains the FIK information. Typically, the field is the same as the text field, which is why the same field number should appear in the Text field and this field.
The payment identification of FIK	Enter what characterizes the FIK text. That is, how Uniconta can recognize that it is a FIK code. Typically, banks write the text FI code or similar before the actual got code. If necessary, enter the text FI code in this field.
Amount (Payment identification of FIK)	Enter the number of the field in the file that contains the amounts of the FIK deposits. Typically, the field is the same as the amount field, which is why the same field number should appear in the Amount field and this field.!!! sleet"!!!!
Position (indentification).	Which field does the Debit and Credit information stand in if no sign is used
Identification- Debit	Signs for Debit. For example, "D"
Identification- Credit	Signs for credit. For example, "K"
IBAN	See the description for the Date field above
Memo	See the description for the Date field above
Currency	See the description of the Date field above
Amount currency	See the description for the Date field above
Information	See the description for the Date field above
Documents	Link to a document, can be Kontolink or a physical attachment placed on a web server.

View Bank Statements button

If the Show Bank Statements button is selected, the data from the selected bank statement file is displayed, and at the top you can then choose to which field in Uniconta the data should be saved to. The file is displayed and via the "Field Selector" above each column they can be selected which field column should be loaded into. So when you see a column with the "amount", you must select above the column that this column should be read into the "amount" field. Then Uniconta will automatically set the "amount" to e.g. column 3 if the "amount" is now in the third column.

!! slet?? Payment ID recognition

In order to get the payment ID recognition setup correct, it is necessary to review the bank file In it, it can be seen that the way Payment ID can be recognized is by means of the text 'IK71'. Therefore, the field Payment identificationis filled in with IK71 The FIK code itself is in field 2 of the file, which is why the field Payment reference FIK is filled in with 2. The amount for the FIK report is in field 3 of the file, which is why the field Amount Payment identification of FIK is filled in with 3. A file with FI may also look like this: Here, "payment identification of FIK" should be: FI – 0 So FI, space, rose, space, zero   Setup regarding FIK under Company information Under company information, the company's FIK number is set up. The length of the customer's account number itself is put in the field FIK account no. Length. If your account numbers are shorter than 8 digits, Uniconta will insert the missing digits. The type of FIK code used by the company is selected in the Payment guidance code field. Here in the example it is +71, but other values are also possible. !!!! slet!!!!!!