Help with Importing a Trial Balance in the Accounting Module

Question

Hi everyone,
I’m trying to import a trial balance via a journal entry in the accounting module. Has anyone already done this successfully?
Is there an Excel template available that can be used for this import? Any help or guidance would be greatly appreciated!

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

Importing a trial balance in Odoo via a
journal entry is possible, and it’s a common step when setting up a new
company or migrating from another accounting system.
Refer to the following.
*  https://www.youtube.com/watch?app=desktop&v=VEmb4DrI_Pw [1]
*  https://www.cybrosys.com/blog/how-to-add-opening-balance-in-odoo-17-accounting [2]
*  https://www.odoo.com/id_ID/forum/help-1/importing-open-ar-open-ap-items-245846 [3]
*  https://www.odoo.com/id_ID/forum/help-1/accounting-opening-balances-

Andry Ang · Answer

Hi Zoe,
I suggest you to follow this official tutorial: https://www.odoo.com/id_ID/slides/slide/import-an-opening-balance-7312

Or if you insisted with journal entry you can use mine
https://docs.google.com/spreadsheets/d/1Sj6NFYYvgucHPiBq1M4msEEoWdQBX4Hzm_xHGekz6yo/edit?usp=sharing [1]

Hope this helps.

[1] https://docs.google.com/spreadsheets/d/1Sj6NFYYvgucHPiBq1M4msEEoWdQBX4Hzm_xHGekz6yo/edit?usp=sharing

Zoé Gruloos · Answer

Hello Andry,
It's an opening balance for a new company,

Thank you for your help

Related Posts	Replies	Views
Hierarchy Group Name is too long on Balance Sheet Report accounting odoo19 balancesheet	3 Jun 26	439
『✦Iberia✦Costa~Rica✦』¿Cómo comunicarse con Iberia Costa Rica? accounting	0 Jun 26	51
Prevent auto-validation of bank journal transaction to vendor bill matching accounting	3 Jun 26	380
in odoo 19 the amount does not appear distributed Profits/Losses after closing the balance accounting	2 Jun 26	2921
AVCO Vendor Return Creates Inventory Valuation Difference – Correct Accounting Treatment? accounting	1 Jun 26	1560

This question has been flagged

Enjoying the discussion? Don't just read, join in!