Cost center report

Hi all, is there a way to see a financial report for multiple cost centers? I can currently do a report for each cost center. But I would like to see a timebased (one year for example) the different cost centers by column.

My workaround is do each cost center and export them and find a way to merge them into one report in excel.

Thank you

It is not available out of the box but you sure can try to create a query report for it.

Hi @Nathan,

Check Profitability Analysis report, it may help you to resolve your issue.

Thanks

1 Like

can you lead me to more information about creating a query report?

That’s great for summary. Thanks. I would like to get the full p&l though.

Hello! Have you found a solution to this?

https://erpnext.com/docs/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext

https://frappe.io/docs/user/en/guides/reports-and-printing/how-to-make-query-report.html

Hello, thank you for the reply! Would I be able to produce the same type of profit and loss report by just using query reports?

Yes, that is correct.