Bank Transactions Import

 

 

1.  Bank Transactions Import

The import has been tested for files generated in the following e-banking systems:

 

a.  Import configuration

You need to configure the function properly before importing bank transactions:

  • define Bank Account. The bank account which number is included in the MT940 file must be defined.
  • in the module General Ledger → Bank Transactions Import Configuration, you can:
    • configure default accounts for frequently repeated transactions (e.x. daily funding)
    • allow Partial Statement Import
    • allow searching for invoice reference
    • define file format for selected bank accounts

The placement of certain options may differ depending on the theme chosen.

b.  How to import bank transactions

You will find in the module General Ledger. Previously, you need to prepare a file from e-banking system on the computer local disc.

Note: You need to comply with the security policy and remember that the program doesn’t delete the file after uploading it. If the computer local disc isn’t secured, the fragile information may fall into the wrong hands.

 

Statement uploading

After file uploading, the program displays all bank statement positions on the screen.

Statement editing

While uploading a file, the program tries to find Suppliers and Customers by  comparing companies bank account numbers with the bank accounts on the statement.

Additionally, the program tries to identify the document, which a given payment refers to (unless the function Search Invoice References Also for Unknown Bank Accounts is set Yes). You will find more information in the article Bank Transaction Import Match.

By clicking on the icon program księgowy online, you can select/change:

  • date
  • Supplier/Customer
  • document type
  • settled document (ex. invoice) or account
  • transaction description

In the box Transaction Type select one of the available types.

If the amount is negative (bank payment), the program allows users to select the following types:

  • supplier payment – in that case, the program will allow to select a supplier and an amount
  • return to customer
  • other payment

If the amount is positive (bank deposit), the program allows users to select the following types:

  • customer payment - in that case, the program will allow to select a customer and an amount
  • return for supplier
  • other deposit

After selecting all date, click on Update. The program will return to the list of statement positions. 

Statement posting

After document editing, click on the button  Data Import. The program will process the proper bookings on the basis of settings.

Note:

  • the program will process one booking for each position on the bank statement. You can view the booking in Journal Inquiry as Bank Payment, Bank Deposit, Bank Transfer, Customer Payment and Supplier Payment. You can view statements in Bank Statement Inquiry.
  • In the Reconcile Bank Account function in the module General Ledger, you can not only reconcile statement, but also delete and add statement positions.

2.  MT940 files import

MT940 format is commonly used for import of operation history into finance and accounting systems and, frequently, e-banking programs allow to generate them.

MT940 files are text files, most often with STA extension (although the program doesn’t require this). They are based on the SWIFT MT940 standard. Defined file format gives the opportunity to book operations automatically in the mKsiegowa program.

The program is prepared to upload Mt940 files from the following banks:

 

  • Alior Bank
  • Deutsche Bank - db powerNET account
  • ING Bank Śląski - ING BankOnLine account
  • iPKO - iPKO biznes account
  • BGŻ - BGŻ Firma account
  • BZ WBK - iBiznes24 account
  • PekaoSA - PekaoBIZNES24 account
  • Raiffeisen - R-ONLINE account
  • Millenium - Biznes account
  • Nest Bank - Nest Konto account

3.  CSV text files import

It is possibile to import CSV files for certain banks which offer such a format:

  • Citibank
  • mBank
  • Deutsche Bank – dbNET account
  • Raiffeisen
  • VW Bank
  • Idea Bank

4.  File import for db collect Elixmas

In the mKsiegowa program you can import statement generated in Deutsche Bank e-banking  in Elixmas format (function connected with issuing recurrent invoices)

Try it 4 3