Custom report for cash account

I would like to create a custom report for the cash on hand account (mainly listing all information including the date, payee, description, reference, etc).

What is the sql query for cash on hand? I have tried SELECT * FROM CashAccounts and SELECT * FROM CashOnHand. Both command is not working. Please help. Thank you very much.

Click on the blue balance of the account in the Cash Accounts tab. All that information is already shown. You can export the listing.


SELECT * FROM CashTransactions

@Tut @lubos Thank you :heart_eyes:. Tried both ways. What a perfect program!