Hi,

In Odoo, when you imported your credit card transactions through a CSV file, the system automatically created a new Bank Statement and corresponding Statement Lines. Even though you deleted the duplicate transactions, the statement record itself remained, which is why your dashboard now shows an incorrect balance; the “Last Statement Balance” still comes from that imported statement. To fix this, you can go to Accounting → Bank → Bank Statements, open the statement linked to your credit card journal, and delete it if it’s still in draft. If it’s already posted, first cancel it and then delete it. If deleting isn’t possible, you can instead create a new adjustment statement with one line to correct the balance difference. For example, if your dashboard shows ₹13,000 instead of ₹3,000, add a correction line for −₹10,000 and reconcile it with a balance adjustment account.

Hope it helps.

Hello Furqan,

It sounds like you've encountered a common issue when manually importing bank statements after using Odoo's automatic synchronization. Here’s how you can address the balance discrepancy:

  First, reconcile all your existing transactions. Go to Accounting > Bank and Cash > your Credit Card Journal and click on "Reconcile". Ensure all matched transactions are correctly reconciled.

  Next, check for any unreconciled entries that might be affecting the balance. These could be remnants from the deleted duplicate entries. Reconcile or remove them as necessary.

  If the "Last Statement Balance" is incorrect, manually adjust it. Go to your Credit Card Journal, and find the last statement. Edit the closing balance to match your actual records. If the statement was created erroneously, you might need to adjust the opening balance of the subsequent statement (or create one if it doesn't exist) to correct the overall balance.

  If you still face issues, create a new bank statement with an opening balance that reflects the correct amount. This will effectively "reset" the balance in Odoo to match your real-world balance.

For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html