Hi,

You can handle this requirement in Odoo Online by adding a custom field to map Spanish accounts to their U.S. equivalents. Using Odoo Studio, create a new field (for example, x_us_account_code) on the Chart of Accounts model to store the corresponding U.S. account code for each Spanish account.

However, since Odoo Online doesn’t allow direct modifications to standard financial reports, you can’t add this field directly to the Trial Balance with Period Balance report. Instead, you can export the Trial Balance to Excel and manually merge it with your U.S. codes, or use Odoo Spreadsheets or Data Studio to build a custom report that displays both Spanish and U.S. account codes side by side.

If you ever migrate to Odoo.sh or an on-premise setup, you’ll have full access to extend the XML of the report. In that case, you can inherit the Trial Balance report and include the custom field directly in the output. In short, for Odoo Online, use custom fields with Spreadsheet or Excel export; for self-hosted setups, customize the report template itself.

Hope it helps