Skip to Content
Menu
This question has been flagged
1 Reply
373 Views

Hi,


This question is about the Accounting app.


I have a credit card journal setup, which synchronizes online and fetches the transaction, and then I reconcile records. 


However, I made a mistake, I thought there were some transactions missing, beyond a certain date in past (3 months), however they were not missing. 


I downloaded CSV and uploaded the transactions. However, those records needed not to be created. 


It created duplicated records, however with a reversed notation. For example amounts in minus were created as positive and vice versa. 


Anyway, I deleted all those duplicated records. However, the balance don't match anymore. 


It created a Statement record. Is there a way to delete that Statement record? Because that Credit Card account on the Dashboard now shows a 'Balance' amount and also shows a 'Last Statement' amount. 


For example, the Balance amount as 13000, and Last Statement Balance as 10,000. 


However the correct balance is supposed to be 3000. 


Is there a way to correct this? Or is this beyond repair?


Thank you.

Avatar
Discard
Best Answer

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.

Avatar
Discard
Related Posts Replies Views Activity
0
Oct 25
39
2
Oct 25
209
1
Oct 25
239
2
Oct 25
364
0
Oct 25
6