Sorry was busy making phone calls…
The key (I think) is you will need to split your Tips Accounts based on this syntax:
{ACCOUNT TRANSACTION DETAILS:Customer Account Transaction:Customer Accounts}
The syntax will produce a 3 column table based on your Account Transaction i.e. “CC Tip Transaction” and then you specify an Account “CC Tips”. So above you may run into my issue is based on the Syntax if you need to split your tips into Account Type you will need separate Accounts.
That’s my interpretation and check this link: