This page is used to import bank files for the purposes of payment matching in the invoicing module. After a bank file is imported, the system tries to automatically match payments from the file with invoices in the system based on the matching rules settings in Invoicing Settings Bank Rules.
When payments cannot be processed automatically, they are marked as Unmatched payments. You can manually match them with the corresponding invoices. Payments that have nothing to do with the invoicing of services provided are marked as Unidentified and will not be processed further.
File import
You can find more information about the various import files that ISPadmin supports by clicking on this button.
After you have uploaded a file, a notice appears at the top of the page saying “Import was successfully completed”. The file in question is then displayed in the overview.
When you want to choose which type of import is to be used, the system offers only those types of imported files that are used in a given country (a bank that is used in a particular country).
How to work with imported files
You can filter the imported files according to year, month and type. Payments (all or only unmatched) can be exported to these three formats: PDF, CSV and XML.
Unidentified payments - Display unidentified payments in the system.
In the overview, you can see basic information about imported files:
| Import date | The date when a given file was imported |
|---|---|
| Name of imported file | You can download a given file by clicking on its name. |
| Number of records | The number of items in a given imported file |
| Matched | The number of automatically matched payments (according to the set rules) By clicking on this number, you call up a list of matched payments. You can cancel matching by clicking on  . |
| Unmatched | The number of unmatched payments. By clicking on a given number, you call up a list of such payments. You can then match them. |
| Duplicate entries | The number of duplicate payments |
| Repeat payment matching This option is useful when you change matching rules. | |
 |
Save an imported file to PDF |
|
Delete an imported file |
Payment matching
| Match | A new page is displayed where you can search according to client name or variable/specific symbol. By clicking on Add to credit, you can add a given unmatched payment to a client’s credit. By clicking on Match, you can match an unmatched payment with the corresponding invoice. |
| Transfer a given payment to the category of unidentified payments in the system. |