Statement of Account

A customer has asked for a statement of their account. I have tried to filter this in the ledger as suggested in other threads but this does not seem to work.

How do I create one for the customer showing their remaining balance?

What do you mean by “but this does not seem to work”?

What is your exact requirement?

I need to show the customer exactly what they owe

That’s not called statement of account, that is called “Account Payable”

Are you looking for something like this?

checked accounts payable, that didnt seem to work either

What does and does not seem to work - a screenshot or two might help explain?