Skip to main content

Peliqan

Total income by category

SQL query for Quickbooks

Get total income by category from Quickbooks data.

SELECT Category, SUM(Amount) AS TotalIncome FROM QuickbooksData GROUP BY Category

Quickbooks data model

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.