Bank statement processing

The bank statement processing feature lets you reconcile payments receivable with invoices issued by paring them, so it can proceed multiple payments. Bank payment transactions are automatically processed by Splynx handlers – small modules created for each bank file format.

Bank statement processing


Bank statement processing starts with importing bank statement format file into Splynx. For each bank different handler can be used. We can also connect your bank to email processing bank statements.

Handler Upload


When the file's been downloaded next step is to set up matching criteria for bank statement processing and click on Preview.

Loaded data


The table with paired data will appear where we can check all matches with payments and invoices. To finish process multiple payments click on Process button below the table.

Period


The message will appear that payments paired successfully. Then, in Bank Statements History (Bank Statements → History) you will be able to check downloaded file with information in the table about status of bank statement importing, records, processed payments and errors.

History

It is possible to see processed payments from particular bank statement more detailed. If you click on View option View in Actions or on a title of each file in Title column, the window will pop-up with description of every status of processed payment.

Payments with Error or Ignored status can be checked and paired manually by clicking on icon Paired in Actions. Payments will be in Ignored status when they've been already paid, but you can always double check them and manually pair.

View history

When you click on Manual pair icon Paired, a new window will pop-up, where you can search for a customer by entering his ID, Login, Contact details, Partner, Status, etc. in Customer section of the table.

Manual pair

You can also search by entering Invoice number or Proforma Invoice number in Invoice section or Proforma Invoice section of the table or check all invoices/proforma invoices for a particular period.

Manual pair

When you find a customer who's payment needs to be paired, click on Manual pair icon Paired in Pair column of the table. The window will pop-up where you will confirm the paring.

Pair

After manual paring is done the status of the payment in a Bank statements history view (Finance → Bank Statements → View History) will be marked as Manually paired. Status