Is there even a report that i can raise to show a client balance after each transaction over a selected period.

In statements - go to advanced filters - there is a box you can tick that says show itemised payment details for each invoice - see if that is ticked

Have a look at the customer ledger report ( in reports - sales - customer)

use the advanced filter to select your client and the date range required

Do hope that helps

Lisa