Skip to Content
Menu
This question has been flagged
4 Replies
8575 Views

Dears,

Good Day.


How can i add opening balance value for my customer and vendors

i'm using V12.


Thanks

Avatar
Discard
Best Answer

you can do it by exporting your customers/supplier details from system then add the opening balance by using Vlookup in excel

go to accounting > journal entries  and create new journal called under type opening balance  journal , then try to click import and import the excel sheet that you made  

 

Avatar
Discard
Best Answer

With Odoo, there are so many work arounds.

You can create additional journal for beg. balance of sales and vendors. It should be done by vendor and customers to make reconcilliation of it's partner account

Avatar
Discard
Best Answer

You may want to watch this video: https://odoobook.readthedocs.io/en/latest/accounting/import_opening.html

Avatar
Discard
Best Answer

For managing opening balance for customer / supplier try following:

Go to Accounting -> Journal Entries -> Journal Entries and try to create new journal entry.

While creating the entry you need to select the journal under which you need the accounting entry to be done, which is mostly the 'Opening Journal'

Enter appropriate date (the starting date of new fiscal year).

Then you have to enter the details for customer/suppliers and their credit or debit respectively.

Once you are done with this post this journal entry details, which will generate the opening entries for customers / suppliers.

Avatar
Discard
Related Posts Replies Views Activity
0
Apr 24
14328
1
Mar 15
3052
1
Mar 23
4314
3
Apr 24
57878
1
Aug 20
4379