Issue with Upload Invoice

I have an issue when uploading invoices through an excel file as it doesn't deduct the items sold in items list. It also doesn't compute the current balance in account under banking, but it is calculated properly in total incomes in the dashboard. I dont think there is an issue with the data as all information including the items sold, quantity, sku, tax information were recorded properly in the invoice section. I also tried to delete the invoice transaction done through the upload and it worked  as it was able to delete the transaction properly and it also recalculated the stocks in items.