Odoo Changelog — 2025-09-23

Tuesday, September 23, 2025

1 change · 18.0

New Features(1)

New functionality added to Odoo

[ADD] new account residual amount and partner balance spreadsheet formulas

Core18.0spreadsheet_accountHIGH

Odoo spreadsheets can now calculate account residual amounts for selected periods and partner balances directly with new formulas. This helps finance teams build more complete reports without manual exports, while related performance improvements make accounting spreadsheet calculations faster and more predictable.

Original PR description

Problem
---------
There is currently no formula to get the residual amount of accounts in
a given period of time in spreadsheets. Similarly, there is no formula to
get the balance of a partner.

Objective
---------
Add the formula ODOO.RESIDUAL and ODOO.PARTNER.BALANCE that does just that.

Furthermore, this PR contains a refactor of the 
addons/spreadsheet_account/models/account.py for easier management and faster computation of the functions.

Check the relevant commits for more details. 

---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

#spreadsheet#accounting#reporting#partner-balance#residual-amount