How to Automatically Record Debit Invoices in Bank Entries

Hello, everyone.

When I record an invoice for a customer (an unpaid creditor), how can it automatically be entered into the bank entries under the debit column of the customer’s bank account?

For example, if I issue an invoice for 500 euros and then pay 300, the remaining balance should be 200 euros.

What’s happening is that only the 300 euros are automatically recorded in the bank entries under the credit column, but the remaining 200 euros need to be entered manually for the balance to be correct.

How can I make the invoice automatically register as a debit in the bank entries, and the paid amount as a credit?

which dolibarr version, and can you provide a picture?

Which module are you using in the above scenario?

  1. Commerce
  2. Billing / Payment
  3. Accounting
  4. Banks / Cash

In essence you can do what you are suggesting in any one of these modules.

Latest version 19.0.2
This is a video descibe the issue

All of these modules are already activated and I use them all.

Hi Mohaamaad,
the Bank Entries in Dolibarr only record real Payments credit and debit, you will not find any open payments in the bank, compare the bank with your real Bank account, you wont find any unpaid invoices on your bank account, only real payments.
All Open Invoices are found in your comerce module.

Hi Plows,
My question is about real debit payments, how to record it according to not paid invoice (postpaid invoice)?

In other words; what is the correct configuration for the chart of accounts and bank account to accept the real debit payment, in the (bank entries) automatically once the postpaid invoice is validated?

Hi,
the bank statement only records the real payment, not the open invoice, just like your real bank account at the bank, i hope i explain it clearly :slight_smile:

there is no real debit payment at the bank account, you wont see any invoices at the bank statement until a payment has been made, and when a payment has been made you will only see the payment that has been made, and not the payment that has not been made.

So, how to manage the postpaid invoices in Dolibarr?

Hi @sheref,

I believe there are a few accounting concepts you might be missing:

  1. As @Plows mentioned, your bank account only records real money transactions, money left to be paid does not appear there. You will find that information under your client’s profile though.
  2. From an accounting perspective, a credit record is money coming in, while a debit record is money going out. As the $1000.00 is yet to be paid and has not really left our account, that $1000.00 should appear in your accounts receivable account (chart of accounts), not in your bank account.

    If you click on #4, it will give you a list of all open invoices, as well as any payments related to them. Basically the view you are looking for
2 Likes

Thanks all very much