Note 10 - Related Party Transactions (Details Textual) - USD ($)		3 Months Ended		9 Months Ended
	Jun. 30, 2022	Mar. 31, 2023	Mar. 31, 2022	Mar. 31, 2023	Mar. 31, 2022
Revenues		$ 8,298,771	$ 8,793,688	$ 26,002,524	$ 27,963,824
Related Party [Member]
Notes Payable		0		0
Two Shareholders [Member]
Repayments of Related Party Debt	$ 600,000
Interest Paid, Including Capitalized Interest, Operating and Investing Activities, Total	144,000
Notes Payable [Member] | Related Party [Member]
Interest Expense, Debt		0	5,987	0	18,226
USCF and USCF Advisers [Member]
Expense Waiver Funds, Related Party		29,000	18,000	122,000	77,000
Waivers Payable, Related Party	70,000	$ 29,000		$ 29,000
USCF and USCF Advisers [Member] | USCF Gold Strategy Plus Income Fund [Member]
Investments, Total	$ 1,300,000
Percentage of Outstanding Shares of Investment	40.00%	40.00%		40.00%
USCF and USCF Advisers [Member] | USCF Gold Strategy Plus Income Fund [Member] | GLDX [Member]
Investments, Total		$ 1,300,000		$ 1,300,000
USCF and USCF Advisers [Member] | SCF Sustainable Battery Metals Strategy Fund ("ZSB") [Member]
Percentage of Outstanding Shares of Investment		91.00%		91.00%
USCF and USCF Advisers [Member] | SCF Sustainable Battery Metals Strategy Fund ("ZSB") [Member] | ZSB [Member]
Investments, Total		$ 2,100,000		$ 2,100,000
USCF and USCF Advisers [Member] | Related Party [Member]
Revenues		5,000,000.0	$ 5,900,000	15,700,000	$ 17,200,000
Accounts Receivable, after Allowance for Credit Loss	$ 2,200,000	$ 1,700,000		$ 1,700,000