Bank Transactions Import Configuration

In the online accounting program mKsiegowa.pl, you can configure Bank Transactions Import.

 

Default accounts

Default accounts are defined in the program in the following way:

  • Unidentified Income Account will be selected during a bank statement import if there is a customer bank account number on the imported file, but it wasn't found in the list of customers and the amount of the banking operation is positive
  • Unidentified Costs Account will be selected automatically if there is a customer bank account number on the imported file, but it wasn't found in the list of customers and the amount of the banking operation is negative
  • Bank Charges Account will be selected if there isn't any bank account number on the imported file and the banking operation amount is negative
  • Bank Interest Account will be selected automatically if there isn't any bank account number on the imported file and the banking operation amount is positive

Other settings

  • If Allow Partial Statement Import is set to Yes, only transactions with a set target posting account are imported; the others are ignored. This setting allows you to import the same file multiple times. The program prevents loading the same statement entry twice, if the file content hasn't been changed.
  • If the option Search Invoice References Also for Unknown Bank Accounts is set to Yes, the program will search for the invoice reference number in the transaction description and try to match the invoice with the statement entry.
 

Przelewy24 Service

Before importing data from the Przelewy24.pl website, you should:

  • in the Bank Accounts enter the bank account for your account in Przelewy24.pl. set Type as Savings Account. Select a previously created GL account. In the box Bank Account Number, enter the account number from the configuration of the account in przelewy24.pl. The boxes 'Bank Name' and 'Bank Address' can be left blank.
  • download the mKsiegowa server IP address using one of the websites or by writing a support request to the administrator
  • send a request for access-key to the address serwis@przelewy24.pl, writing your account ID on the website and your IP address; you should indicate in the e-mail that you want an access your account via API
  • after receiving an answer from the Przelewy24.pl website, in the of the Bank Transactions Import Configuration in the module General Ledger, you enter:
    • User name
    • received access-key in the box Access token
  • select from the list a previously created bank account in the box Clearing account

Assigning statement file format

Before importing bank statements, it is necessary to define which statement file format will be used for which bank accounts.

You can do it by assigning the appropriate format to those bank accounts for which the import function will apply.