Aged Balance

Aged Balance

Compatibility: Dolibarr 15 - 23 • PHP 7.1 minimum.

Using an older Dolibarr version? Contact us to discuss compatibility.

Take control of your receivables and payables in Dolibarr

Identify overdue amounts immediately, analyze balances by aging bucket or month, and export professional reports.

Aged Balance tracks amounts still to be collected from customers and paid to suppliers at a selected cut-off date. Balances are rebuilt on the fly from Dolibarr's native invoices, payments, credit notes and deposits, without redundant business data storage.

Customers, suppliers and net position

• Customer receivables aged balance.
• Supplier payables aged balance.
• Combined Customer/Supplier summary.
• Net position calculation: customer receivables minus supplier payables.
• Direct access to each third-party record from the tables.

Reliable historical balances

• Selectable cut-off date.
• Historical balance reconstruction at the selected date.
• Payments recorded up to the cut-off date included.
• Allocated credit notes and deposits included.
• Fully settled invoices automatically excluded.
• Calculations restricted to the current Dolibarr entity.

Aging and calendar analysis

Classify outstanding amounts as Not due, 1 to 30 days, 31 to 60 days, 61 to 90 days, or over 90 days. All three bucket limits are configurable.

Calendar mode groups amounts by month over 3, 6 or 12 months, using either the due date or invoice date, with a dedicated column for periods outside the displayed range.

Excel and PDF exports

• Exports matching the displayed cut-off date, mode and filters.
• Excel workbook with Customer and Supplier sheets, summary, numeric values, formatted headers, automatic filters and frozen header row.
• Landscape PDF report with company logo, adapted title, summary indicators, detailed tables and totals by bucket.
• French and English translations with UTF-8 support.

Configuration and permissions

Configure bucket limits, visibility of the Not due and final buckets, reference date, default mode and calendar period.

Assign separate rights to view Customer, Supplier and Summary reports, plus the right to export Excel and PDF files.

Online demo

Try the module in our demonstration environment.

Access: https://demodolibarr.almisbah.ma

English user: en.user

Password: 000000000000

Available permissions: view customer and supplier aged balances, view the summary and net position, and export Excel and PDF reports.

Module configuration: bucket limits set to 30, 60 and 90 days; Not due and final buckets displayed; due date used as reference; Aging as default mode; 12-month calendar period.

Additional information

Included in the purchase

• The complete module
• Functional and technical bug fixes
• Support through our contact form

Installation, training and custom development are not included.

Updates

All updates to our modules are free for life.

Bug fixes will be published on DoliStore. Download the latest ZIP from your customer account and check compatibility before updating.

Installation and assistance

Install the ZIP through external module deployment, enable Aged Balance, then configure the module according to your needs.

Request assistance

Who are we?

AL MISBAH INFORMATIQUE helps businesses integrate, customize and develop solutions around Dolibarr ERP/CRM.

We develop practical modules that automate everyday tasks and improve team efficiency.

Discover AL MISBAH INFORMATIQUE

View all our modules on DoliStore

Contact and support

Need help?

For installation, configuration or compatibility requests, our team is ready to help.

Contact our team

Technical issue?

Corrective maintenance is free for the Dolibarr and PHP versions explicitly covered by the Compatibility section.

Include the Dolibarr, PHP and module versions and the steps required to reproduce the problem.

Contact support