Going backwards will only hide the problem, @ozyrobotics. You are showing us very little actual information, so it is hard to diagnose your problem. But I am starting to believe you have been making account allocations incorrectly, probably beginning with your sales invoices. But you only have 36, so it should not be an insurmountable problem to fix them.
I’d like to ask you to perform a test. Create a test sales invoice, using exactly the same process you normally do. Post a screen shot of the input screen. You can obscure the customer’s name, but leave everything else visible. This will be a fake invoice and will be deleted later. So what it is doesn’t really matter, except that it should be similar to transactions that are giving you problems.
After the invoice is created, enter a simulated receipt for that invoice, using exactly the same procedures you would normally use. Put it into one of your 11 cash accounts. Post a screen shot of that receipt.
Be sure to take note of these transactions so you can delete them later.
Now tell us where these transactions ended up. Are they in
Suspense? Or did they go to the expected accounts?
If either transaction ended up in Suspense, post a screen shot of the
Suspense drill-down report showing it/them.
As soon as we are done analyzing the results, delete the two transactions. You will have to delete the receipt first, or you will not be able to delete the sales invoice.