Language:


Bank Transactions

If your bank sends bank statements electronically, you can use the 'Bank Transactions' Import function to import them in to your Standard ERP database. This function will save the contents of a bank statement file in the Bank Transactions setting, adding separate records to that setting for each line in the statement. You can then use the Bank Reconciliation register to reconcile the transactions in the statements with transactions in your Standard ERP database.

Before using the 'Bank Transactions' Import function, you should specify a Bank A/C No. for each Payment Mode that represents a payment method that affects your bank account (e.g. payment by bank transfer or cheque). This will ensure that the imported Bank Transactions will be connected with the correct Bank Account in Standard ERP:

You should also check that the Company Name, Reg. No. and VAT Reg. No. in the Company Info setting are correct and match the information that will be in the bank statement files.

As there is no standardised format for bank statement files, a specification window will appear when you run the 'Bank Transactions' Import function. This window will allow you to specify the format of the bank statement file and the originating bank:

Proceed as follows, depending on which bank sent the statement file that you need to import:

Croatia - Addiko, Croatia - Erste, Croatia - Raiffeisen, Croatia - Zagrebačka

Bank A/C
Enter your bank account number in this field. 'Paste Special' will list the Bank A/C Nos that you have specified in the Payment Modes setting (a Payment Mode without a Bank A/C No will be included as a blank in the list).

Usually your bank account number will be included in the statement. The account number that you enter here will only be used if this is not the case.

Bank
Use 'Paste Special' to specify the bank that sent the statement.

Format
CSV or XML.
If the file contains a payment to you from a Customer, the Import routine will attempt to create a Receipt in which it matches the payment to an Invoice. It will do this by checking the numeric characters only in the <Ref> tag in <CdtrRefInf> and attempting to match those to the Official Number or Invoice Number of an Invoice. It will then check that the IBAN in the file is the same as the Bank Account in the Contact record for the Customer in the Invoice. If an Invoice with the correct Official No. or Invoice Number is found, and the Customer in that Invoice has the correct Bank Account, then a Receipt will be created. The Receipt will not be marked as OK. If you need to use this feature, you should therefore ensure that you have entered IBANs in the Bank Account field in the Contact records for your Customers.

Estonia - SEB, Estonia - Swedbank. Latvia - SEB, Latvia - Swedbank, Lithuania - Luminor, Lithuania - Paysera, Lithuania - SEB, Lithuania - Swedbank

To import a statement from one of these banks, follow the instructions for the Croatian banks described above. The only difference is that when the Import routine attempts to create a Receipt, it will check the Reg. No. 1 in the Contact record for the Customer. If the statement does not contain a company registration number, then it will check the IBAN in the Bank Account field as described for the Croatian banks.

USA - Ally, USA - Amex, USA - Bank of America, USA - Chase, USA - Wells Fargo

Bank
Use 'Paste Special' to specify the bank that sent the statement.

Format
CSV.

Column 1
Enter your bank account number in this field.

CSV Files from Other Banks

Bank A/C
Enter your bank account number in this field. 'Paste Special' will list the Bank A/C Nos that you have specified in the Payment Modes setting (a Payment Mode without a Bank A/C No will be included as a blank in the list).

Format
CSV.

Field Separator, Date Format, Decimal Separator, Thousand Separator
Enter the separators and formats that have been used in the CSV file.

Column 1 - Column 10
Use these fields to map the columns in the CSV file to fields in a Bank Transaction record.

For example, if the third column in the CSV file contains the transaction dates of each transaction, use 'Paste Special' from the Column 3 field to set it to "Date". The information in the third column will then be brought in to the Received Date field in each Bank Transaction record created by the Import function.

If the CSV file contains a column that you do not need to be imported, leave the corresponding Column field at its default value ("unassigned").

The options in the 'Paste Special' list correspond to the fields in the Bank Transaction record as follows:
Option in 'Paste Special'Field in Bank Transaction record
DateReceived Date, and R. Trans. Date (if the Type is "C") or P. Trans. Date (if the Type is "D")
Time (not used)
Name (not used)
TypeType (usually you should not map a column in the CSV file to the Type field. The Import routine will set the Type field to "C" if the value of the transaction is positive or "D" if the value of the transaction is negative. As described in this table, the filling of the fields on the 'Payer' and 'Recipient' cards in a Bank Transaction will depend on the first character of the Type being "C" or "D". These fields will not be filled if this is not the case)
Status (not used)
CurrencyCurrency
AmountSum
Receipt IDOrd. Number
Balance (not used)
CommentComment
Bank AccountR. Bank Acc. (if the Type is "C") or P. Bank Acc. (if the Type is "D") i.e. this is your bank account. If your bank account is not in the CSV file, it will be taken from the Bank A/C field in the 'Specify Bank Transactions' window
ReferenceReference, and R. Reference (if the Type is "C") or P. Reference (if the Type is "D")
Skip first lineSelect this option if you do not need the first line in the CSV file to be imported (e.g. it might contain column headings).
You can also run the 'Bank Transactions' Import function from the 'Bank Reconciliation' register. Please refer to step 8 in the description of this register here for details.

---

Import functions in the Nominal Ledger and Integration module:

---

Go back to: