This question has been flagged
1 Reply
4001 Views

Hello,


As I understand, the reconciliation widget is removed from Odoo 14.0 CE. But there must be a way to reconcile Outstanding Receipts/Payments accounts for cash and bank journals, otherwise, how can I get the actual balances for those accounts?


Regards

Avatar
Discard
Best Answer

Hello.

Hope you are well. I have the same issue on V14 CE.
I have figured a way to manually reconcile, as follows:

Case:
NB: Opening Bank Balance is 1,000.00
Made a Supplier Bill and Payment for the same
Amount: 100.00

Looking at the Journal Entries, Odoo has:
DR: [211000] Accounts Payable: 100.00
CR: [101403] Outstanding Payments: 100.00

When you look at the Overview, it shows as follows:

Balance in GL: 1,000.00
Outstanding Payments/Receipts: 100.00 (This is from the Supplier Bill Above)

To clear this Outstanding:
STEP A:
No Bank Statements Imported to Odoo
STEP B: Bank Statements are Imported to Odoo

I made a Journal Called: BANK RECONCILIATION, Type = Miscellaneous

STEP A: Entries made as follows:
DR: [101403] Outstanding Payments: 100.00
CR: Bank: 100.00

 

STEP B: In this case, where you add/import bank account lines, Odoo will:

DR: [101702] Suspense: 100.00
CR: Bank: 100.00

To reconcile this, pass an entry as follows:
DR: [101403] Outstanding Payments: 100.00
CR: [101702] Suspense: 100.00

End Result
Balance in GL: 900.00
Outstanding Payments/Receipts: 0.00

Thanks & Nice Day!

Avatar
Discard