Reconcile invoices against bank transactions?

Using my Dolibarr Financial modules
1

Hello and good evening from Ireland.

I am just getting started on my Dolibarr journey and have hit my first snag.

It seems when I enter a payment for an invoice to mark it as paid, it will create an entry in the bank account. This is undesirable, because my bank account is kept up to date via a tool I built to import statements from my bank. When the invoice module creates a payment, it means there is a duplicate entry in my bank account and throws everything off.

Is there a way that I select a bank transaction and inform Dolibarr that it is a payment for invoice, which then links the two, and marks the invoice as paid.

Many thanks
Conor

2

Hi @ronoc114

I think you can take a look at the bank reconciliation feature. If you click on your bank account, you’ll see a ‘Reconciliation’ tab. Try exploring that section to see if it helps.

Thanks & regards
Saikat Koley
Software Developer
Call/WhatsApp : +919903256573
https://www.linkedin.com/in/saikatkoley/

3

Hi

Thanks for your reply. Unfortunately there are no options there in reconciliation for invoice. It is very basic.

Can you do it on yours - perhaps you can share a screenshot?

Or if you have experience with developing on Dolibarr is it possible to make a module or some modifiction to enable the functionality?

Thank you a lot.

4

Hi

Yes, I’m a Dolibarr developer from India, and I completely understand your point. You’re right, the functionality you’re describing isn’t natively available in Dolibarr’s current bank reconciliation system. The reconciliation tool is quite basic and doesn’t allow you to directly link an imported bank transaction to an invoice in a way that marks it as paid without creating a duplicate bank entry.

To achieve what you’re looking for, the best approach would be to develop a small custom module that extends Dolibarr’s bank functionality.

Here’s how I understand the custom module will work (this is just an initial approach you may consider)

  • The module would add a “Link to Invoice” button or action beside each imported bank transaction.
  • When you click it, you can search and select the relevant customer invoice.
  • The module would then:
    1. Create a payment entry linked to the invoice.
    2. Attach that payment to the existing bank transaction (instead of generating a new one).
    3. Mark the invoice as “Paid” automatically.

Thanks & regards
Saikat Koley
Software Developer
Call/WhatsApp : +919903256573
https://www.linkedin.com/in/saikatkoley/

5

Hi @ronoc114

This does not exist in Dolibarr as such.

A module already exists that can help you achieve this : Banking monitoring

It let you import your bak statement via a CSV file and then you can reconcile or create objects from the specific reconciliation tab in the bank account. Furthermore, for a monthly fee, the process could be automated from your bank.

6

Hi there,

Can you please tell me the process your module with do, because right now it looks like when a payment is made, it changes lots of strange things.

I want to be sure that this will work before paying.

Thank you

7

Hi ronoc114,
i believe there were an option to match the invoices against any payment you have recorded separately, but you have to have activated Accounting module and it has to be set up.