Hi guys, just subscribed to odoo and I'm having issues importing transaction data from previous system into the new one via the Import Journal Entries tool.
 
https://i.imgur.com/Gh5mIWe.png
as per the image in the link above, I always encountered the error where the move is not properly balanced (between Credit and Debit).

Error at row 0: "An error has occured. The move (Draft entry XXX (Paid in Capital)) is not balanced. The total of debits equals X and the total of credits equal Y. You might want to specify a default account on journal "Miscellaneous Operations" to automatically balance each move.

I have tried setting up the excel formatting in a way to accommodate this requirement but it still failed to import. I am running out of ideas and it's been weeks since I'm stuck trying to export transaction data from past system to Odoo due to this error.

Odoo v 17.00 btw