Check on debtor and ledger

Is there a way to check the bookings on the debtor account in the ledger vs the invoices? Our accountant demands the list, however it seems not to be in Dolibarr.

Hey!

You can find most of what you need in the Accounting module under “Reports” then “Account balance” or “General ledger”. The debtor accounts (usually 411xxx series) will show all the accounting entries, and you can cross-reference these with your customer invoices.

For a more detailed reconciliation, go to Accounting > Journal and filter by the debtor accounts to see all movements. You can also check individual customer cards under the “Customer account” tab which shows both invoices and payments.

The tricky part is getting a clean reconciliation report that directly matches invoices to accounting entries. Dolibarr shows the data but doesn’t have a built-in reconciliation tool that formats it exactly like accountants typically want.

If you need this kind of report regularly, you might want to export the data to Excel and create your own reconciliation template, or check if there are accounting modules on DoliStore that provide better reconciliation features.

Worth checking your Dolibarr version too - newer versions have improved accounting reports that might give you what your accountant needs.

Clément Houde - Founder of Dolicraft