When you import 100-, 1000- or even more bank payments a day, processing and reconciling them can be a big hassle. This module will save you a lot of work by automating this process: for every bank statement lines it looks for a sale order or invoice, creates an invoice if it does not exists, process the payment and reconcile it with the bank statement line. All on the background based on rules you define.
Define which references to extract from a bank statement line. By default all sale order, invoice and refund references are extracted. You can define your own and use normal text or regular expressions to search in the statement line description, partner, remote bank account and more.
Create rules to find a matching invoice or sale order for instance based on payment amount, bank account number, date, partner, country, etcetera. If a defined rules applies to a statement line a match is created with the defined score.
If one correct match is found the payment will be processed and the invoice is automatically reconciled with the bank statement line.
If no winning match or more then one match is found you can select the best option from a list with probabilities scores.
Create new rules on the fly when you are manually processing the left-overs. For instance: Book all payments from bank account DE123xxx with 'Computer' in the description on the 'Computer and Service' journal.
This module works out-of-the-box and includes a set of extraction and bonus rules which should be enougn for most installations. But you can easily adapt all settings and create your own rules.
Depends on the free Advanced Bank Statement module from Noviat
All 1200 Web Development modules are extensively tested in a live environment.
Please contact us if you have any remarks, questions or feature requests.
1200 Web Development
Amsterdam, The Netherlands
1200wd.com
info@1200wd.com