Hi, I'm trying to create custom dashboard. First, I'm trying to gather all the info I need into a dynamic spreadsheet.

What I try to do seems obvious and simple but I can't find a way to do it.

I'm trying to have an overview of all the sales with all expenses related to each sale.

I would like to sort them by month and/or by SalesTeams

(FYI, each of our sales is automatically linked to a Project.)

So, my problem is that I have a hard time with the "expenses". I can only find the expenses in Accounting→Configuration→Analytic Accounts.

There, I can see the all the Projects(under a Name column) , we also have a Debit Credit and Balance Column. Where Credit is the amount untaxed of the sale, Debit is all the expenses related by the Analytic Distribution (Timesheet, purchase, external supplier, etc) and Balance is, well, the balance.

I would like to have in the same dynamic spreadsheet (To convert it after in a custom dashboard...) the sale, salesteams, date, project, Debit

But I can't find how?