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	Respostes	Vistes
Listing all Invoices with their line items and custom Product fields accounting	0 d’ag. 25	172
simplified chart of accounts for non-profit organization accounting	1 d’ag. 25	291
Why does the same bank transaction appear on different bank statements? How can I fix it? accounting	0 d’ag. 25	211
Bill import template accounting	2 d’ag. 25	232
Analytical distributions by amount in accounting app Solved accounting	2 d’ag. 25	784

This question has been flagged

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