SELECT t.id, coa.title, coa.acct_no, td.t_date, td.debit, td.credit, td.description, t.voucher_no, t.invoice_id FROM transaction_detail AS td INNER JOIN transactions AS t ON t.id = td.transaction_id INNER JOIN tbl_chart_accounts AS coa ON td.account_id = coa.acc_id WHERE DATE(td.t_date) BETWEEN '2026-05-01' AND '' AND t.reference_key = 'Cash-Received' ORDER BY t.id DESC;