Dear all,
as a beginner I importet a statement from Wise via CSV file in order to try the reconciliation process in my new database. Before I tried the import, I had some entries in my Trade account receivable which I reversed by using "Reverse Entry" button of the respective Journal Entries.
Now I just want to have a clean database, which I achieved by using "Reverse Entry" for the items which booked to the Bank suspense account and the Wise account. I achieved that with some work. However, still I am facing all the entries in bank transactions to be reconciled. However, attempting to simply delete them seems to lead to unbalancing bank suspence account and Wise account again.
Is it possible at all to get rid of these entries? I just need to start over from scratch, nothing else.
Thanks for any hint and best regards
Lars
This question has been flagged
Dear Amir, dear Balagopal,
thanks a lot for your hints. Makes sense to me. Finally, I went with the following way:
1. I ensured none of the entries is reconciled.
2. Deleted the bank statement explicitely
3. Reconciliation entries still persisted, I deleted them one by one. This also had the effect, that all the suspense bookings were gone.
Best,
Lars
Yes, it is possible, but reversing is not the right tool for this situation.
When you import a bank statement, Odoo creates bank statement lines, not accounting entries. Reversing journal entries does not remove the statement itself, so Odoo keeps asking for reconciliation.
Correct way to start over (clean database):
Unreconcile everything
Go to Accounting → Reconciliation
Open each reconciled line and click Undo Reconciliation
Delete the bank statement (not the journal entries)
Accounting → Bank → Select the Wise bank journal
Open the imported Bank Statement
Make sure:
Statement is not validated
No lines are reconciled
Then delete the statement
If delete is blocked
Enable Developer Mode
Ensure the statement state is draft
Then delete it
Do NOT reverse bank suspense entries
Reversing creates extra noise and imbalance
Deleting the statement automatically removes the related suspense lines correctly
You can cancel all the wrong entries by following way.
Accounting > Accounting > Journal entries
Group by Journal. Then you can cancel the journal entries from that bank journal and delete it.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Jun 26
|
1269 | ||
|
0
Oct 24
|
3557 | ||
|
0
Oct 23
|
3866 | ||
|
Accounting Reconciliation-
Solved
|
|
5
Jun 23
|
8193 | |
|
0
Nov 22
|
3609 |
Hi, thanks for your reply.
Since I do not find a Cancel button in the Actions menu, I guess you mean the Delete button?
Can I be sure that this does not lead to inconsistencies in the data base but rolls back both the bookings?