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”?