Odoo Help

2

How can I reconcile general accounts from my bank statement?

By
Els Van Vossel (evv)
on 7/7/14, 10:29 AM 4,458 views

I have for instance cash deposits that are already reconciled with invoices. How can I reconcile the general account concerned - which is not linked to a partner - from my bank statement?

This question has been included in the official documentation.
1

Els Van Vossel (evv)

--Els Van Vossel (evv)--
2018
| 6 3 7
Belgium
--Els Van Vossel (evv)--

Author of some OpenERP / Odoo books

Els Van Vossel (evv)
On 7/7/14, 10:42 AM

In the new Bank Statement Reconciliation (V8) you have the ability to reconcile other accounts than receivable and payable ones. For those accounts you need to reconcile (without adding a partner in the bank statement), you just have to tick Allow Reconciliation for the account concerned (menu Accounting > Configuration > Accounts > Accounts).

When you encode (or import) the bank statement, leave the partner empty in the bank statement line concerned. When you click the Reconcile button, all the unreconciled entries for all accounts which allow reconciliation will be displayed (and not only payable/receivable). Then you can filter on the account code to make your searches faster. Select the counterpart to be reconciled by clicking the + in front of the line, then click OK. The entries will now be reconciled. This should solve the clearing accounts of card payments, deposits, etc.

Filter box in Reconciliation screen

When you return to the bank statement, you can click the Journal Items button to display all reconciliations made from this statement.

In the latest RC leaving the partner blank actually results in an exception that states "Reconcilation can only be done for transactions against the same partner.". Not sure about the work-around other than just providing the partner for each transaction on the bank statement.

Frank Adler
on 9/2/14, 2:41 AM

Seems to be okay now.

Els Van Vossel (evv)
on 9/16/14, 10:39 AM
This question has been included in the official documentation.
0
Willox Gaulard
On 1/16/17, 2:49 AM

The answer given by Els Van Vossel is 100% correct

however I would like to add. A bank reconciliation consists of two columns; one for the book balance, the other for the bank balance. The person reconciling the accounts then adjusts one column by adding deposits that had not yet been recorded and subtracting checks and other outlays that had not yet been cashed when the statement had been prepared. The reconciliation is not complete until the adjusted column equals the unadjusted column. There may be some cases where the process reveals a legitimate transaction that was not recorded in the books. When that occurs, the person responsible for the business's books must record the transaction using a journal entry.

This question has been included in the official documentation.
0
Frederic Clementi
On 9/18/14, 10:23 AM

It must be forbiden to reconcile entry with different partners.

The partner is a auxiliary account. 

As far as I know you do not reconcile journal entries with different accounts ?

 

The batch reconciliation is a functionality lack I agree but it has to be done a different way

I fully agree with the fact that you do not reconcile different partners. My "seems okay now" was meant for the reconciliation of a general account without a partner.

Els Van Vossel (evv)
on 9/19/14, 4:49 AM

Ok. Good to read it. Today these constraint have been removed totally from v8. Meaning you can do any kind of reconciliation :( This is a very dangerous regression.

Camptocamp SA, Frederic Clementi
on 9/19/14, 4:53 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 7/7/14, 10:29 AM
Seen: 4458 times
Last updated: 1/16/17, 2:49 AM