Trial Balance by Profit Center

How can I get a trial balance in Excel that is by profit center

Unless your AR activity (including payments and applications) is profit center specific, you will be unable to with standard NAV. Now a P&L would be a different story. But you’re asking for a Trial Balance. Which comes from the balance sheet.

But I guess the first question is how are you defining “Profit Center”?