Documentation/Billing/Bank/Import

From ISP admin

Jump to: navigation, search

Import of the bank statements


The import of the electronic bank statements into the invoicing of the ISP admin system. By means of this screen you can import the electronic bank statements for the purposes of payment matching in the billing module. After the import of the file, the system will try to automatically match all the payments according to the variable symbol (Cutomer number), or according to the specific symbol (Invoice number). If the set payments cannot be dealt with automatically, the rest of the payments will be marked as "Unmatched payments" and then they can be matched manually. The payments not relating to the billing for the services may be marked as "Unidentified payments" and will not be worked with anymore.

Currently, imports of the following banking institutions are supported:

  • Česká spořitelna ( Business accounts as well as drawing accounts )
  • ČSOB
  • Raiffeisenbank
  • GE Money Bank
  • UniCredit Bank ( Optimalized also for the Slovak Republic )
  • mBank ( mKonto )
  • Tatra Banka ( the Slovak Republic )


ABO format - ABO is commonly used in the Czech and Slovak Republics for the exchange of financial messages, more information.

CSV format - General text format for data transfers.




Year

Select a required year for displaying the overview of imported bank statements.


Month

The option to select displaying for All months, one specific month, or Unprocessed.



File

Select a bank statement file for the import into the system.


Type

The account of the banks for which the imports are supported. Select the type of statement according to your bank. Upon clicking on the icon of image:info.png The list of types of importing the bank statements, the window with the legend to the import of supported banking files appears.


The button for import of selected file into the billing module.


Date of import

The day and time when the bank statement import was carried out.


Title of imported file

The title of the file which we imported into the system.


Number of records

The number of records contained within the imported file.


Matched

Indicates the number of automatically matched payments. Upon clicking on the number, you will display a detailed overview of matched payments where you can enter the client`s invoicing by clicking on their name, or you can simply cancel done matching .


Unmatched

Indicates the number of unmatched payments. Upon clicking on the number, you will display the import detail. This screen shows the overview of the unmatched payments and you can thus match the payments manually.

Duplicate records

Shows the same overview as for the matched and unmatched payments. The records which correspond here are moved, therefore they cannot be automatically matched. This may happen in case a customer pays one invoice twice during the same day, or when they import two different statements with the same day by mistake.


image:move.png Rematch the payments

By using this button, you will re-match the payments from the imported bank statement.


image:remove.png Remove

Removes the imported statement out from the system.