Client trust ledger (custom reports)

[RiotPropeller]

I appreciate the detailed response but this is not necessary and will create a lot of overhead.

I have followed this and it is successful with tracking client funds in a mixed trust account:

Trust account transaction

I receive a retainer and deposit into a mixed trust account (liability). After invoicing the client, for billable time spent and/or billable expenses, the money is transferred into the general bank account as payment for those invoices. What is the best way to record these transactions? I have setup a liability control account with special sub-account for each client. I create invoices for billable hours, for example. How are they paid, given that the payment is from trust into general account? …

Now the issue is reporting. Manager has custom reporting, but the documentation is weak on setting up the logic for custom reporting. All I need are custom reports now to comply with my legal regulations for reports and records.