Get an overview of income and expenses - Xero SQL Query - Peliqan

Get an overview of income and expenses

SQL query for Xero

Get an overview of income and expenses.

SELECT ‘Income’ as category, SUM(Amount) as total_amount FROM Invoices UNION ALL SELECT ‘Expense’ as category, SUM(Amount) as total_amount FROM CreditNotes UNION ALL SELECT ‘Income’ as category, SUM(Amount) as total_amount FROM Payments

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.