Josh,
In the design view of your report, go to the Sorting and Grouping
dialog, and put a Group Footer for the Client. Then, in the Client
Footer section thus created on the report, put an unbound textbox, with
its Control Source set to...
=Sum([CostOfItem]-[Payment])
... or whatever your formula is (I couldn't understand the figures in
your example, so please adjust accordingly).

Signature
Steve Schapel, Microsoft Access MVP
> Hello,
>
[quoted text clipped - 34 lines]
> Any suggestions on how to set this up so I only see 1
> Total balance per client? Thanks in advance.