Analyze spending by category - Xero SQL Query - Peliqan

Analyze spending by category

SQL query for Xero

Get total spending by category from the Accounts table.

SELECT category, SUM(amount) AS total_spending FROM Accounts GROUP BY category

Xero data model

Accounts

Contacts

Credit Notes

Invoices

Items

Journals

Manual Journals

Payments

Payment Services

Purchase Orders

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.