Difference between Outstanding and Real balance


I’m about to shift to V5, but before I do that I wanted to check my numbers and everything to start with V5 on good basis. It appears that there is a 75$ difference between Outstanding and real unpaid invoices total. Please see screen capture : https://drive.google.com/file/d/174JcVc-p-H7ol-8orQZzRDJ4VSroXsh5/view?usp=sharing.

I don’t know where it is coming from. I have checked and rechecked every invoice and payment. Everything is correct. I have checked in the DB trying to find any loose numbers (!), but I can’t find anything. Could you please help me by telling me which tables in DB are holding amounts of invoices and payments ? Any clue where I could find this error ? I have entered invoice dated fo 2012, but I suspect this error to be not older than a year because I would have noticed before.

Thanks for any help.


From the screenshot it looks like the difference may be more than one year old.


this a long due issue to be resolved on my side, but I can’t find how.

Coulf you please have a look at this short video that visually explain my issue, hoping that will help resolve it : IN - Outstanding amount issue

Thanks for your support


That value is calculated from the balance column in the clients table.

Thanks a lot, found the unbalanced transactions.