Bank statement processing

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

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

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

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

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

You can view processed payments from a particular bank statement more detailed. If you click on the View option in Actions or on a title of each file in the Title column, a window will appear with a description of every status of processed payment.

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

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

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

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

Once the 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.