I'm beggining to use Odoo 16 from january, and I do'nt match payments with Bank Reconciliation, I mean, I post payments not automatically. I have yet several journal posts of payments of invoices with the outstanding account, and I want to unreconcile this posts to achieve change the outstanding account by the bank account directly. I would like to learn how to do it by my hand, without distort the accounting result, please.
This question has been flagged
3
Replies
1182
Views
Hello,
Yes, this is possible in Odoo, but it should be done carefully to avoid impacting your accounting reports.
You can unreconcile the existing payments from the outstanding account by going into the journal entries and removing the reconciliation. Once that is done, you can reprocess the payments correctly by linking them directly to the bank journal, or adjust them using proper accounting entries depending on your setup.
However, since these entries are already posted, it’s important to ensure that any changes are made in a controlled way (for example, by using correction entries or re-reconciliation) so that your financial statements remain accurate and compliant.
If the number of entries is large, it’s usually better to follow a structured correction process rather than manually editing each entry.
Hope this works for you! If you need any help implementing this or want a more optimized approach, feel free to reach out for further discussion
Regards,
Zehntech Technologies Inc.
In Odoo payments are usually posted first to Outstanding Receipts/Payments and later moved to the bank account during bank reconciliation.
If you already have payments sitting on the outstanding account, there are two practical ways to fix it.
Option 1 — Bulk correction (best for many transactions)
Instead of editing every payment, create one manual journal entry that moves the total balance from the Outstanding Receipts account to the Bank account (debit Bank, credit Outstanding Receipts).
After posting the entry, go to the Outstanding account → Journal Items, select the original payment lines and the line from your new journal entry, and click Reconcile. This will clear the outstanding balance without affecting profit or loss.
Option 2 — Manual correction (best for a few payments)
If there are only a few entries, you can open the payment journal entry, unreconcile it, and adjust it manually.
To avoid this in the future, you can also review your Bank Journal configuration:
Accounting → Configuration → Journals → Bank → Incoming/Outgoing Payments.
If you prefer payments to post directly to the bank account, you can set the Outstanding Receipts/Payments accounts to your Bank account.
Best regards,
The Glorium Technologies Team
Hello Pilar Garcia,
I hope you are doing well
1. Stop the issue going forward: Accounting → Configuration → Journals → Bank → Incoming/Outgoing Payments → set Outstanding Receipts/Payments Account = Bank account. New payments will post directly to the bank.
2. Fix the old ones with one manual journal entry:
Customer payments:
I hope you are doing well
1. Stop the issue going forward: Accounting → Configuration → Journals → Bank → Incoming/Outgoing Payments → set Outstanding Receipts/Payments Account = Bank account. New payments will post directly to the bank.
2. Fix the old ones with one manual journal entry:
Customer payments:
Account | Debit | Credit |
Bank | X | |
Outstanding Receipts | X |
Vendor payments: reverse it (Dr Outstanding Payments / Cr Bank).
3. Reconcile: Open the Outstanding account → Journal Items → select old payment lines + your new JE line → Reconcile.
Done - invoices stay paid, suspense account = 0, bank corrected, no P&L impact. Check via Trial Balance.
I hope this information helps to you
Thanks & Regards,
Kunjan Patel
3. Reconcile: Open the Outstanding account → Journal Items → select old payment lines + your new JE line → Reconcile.
Done - invoices stay paid, suspense account = 0, bank corrected, no P&L impact. Check via Trial Balance.
I hope this information helps to you
Thanks & Regards,
Kunjan Patel
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 | |
|---|---|---|---|---|
|
0
Jan 17
|
5028 | ||
|
0
Mar 15
|
6122 | ||
|
1
Jun 19
|
4158 | ||
|
1
Apr 19
|
5857 | ||
|
|
0
Mar 15
|
5814 |
Good afternoon, Santosh.
Thank you so much, I've learned to solve my problem with your answer. Best regards,
Pilar