Seeking Best Practice Advice: Reporting Financials in Domo

Hi community,

What is best practice for reporting financials in Domo?

Currently, we have raw financials, account by account, fed in through a simple CSV. There are no summaries in this CSV, so I have to aggregate them with Beastmodes to get to summary numbers. For example, EBITDA is calculated as such (see code below)

This is is a lot of work for a simple calculation that would take three clicks in Excel.

My question: Should I calculate EBITDA/Gross Profit/Overhead%/etc. externally in an Excel workbook, and then upload the summarized financials, or should I continue to perform financial aggregations within Domo? I am not sure of the benefits of either or what would be most scalable so I wanted some thoughts.

SUM(CASE
WHEN Account = 'Net Revenue' THEN Value
WHEN Account = 'Other Revenues' THEN Value
ELSE 0 END)

-- Net Revenue

-

SUM(CASE WHEN Account = 'Cost of Good Sold' THEN Value ELSE 0 END)

-- less COGS equals Gross Profit

-

SUM(CASE
WHEN Account = 'EE Salaries and Benefits' THEN Value
WHEN Account = 'Supplies' THEN Value
WHEN Account = 'Rent' THEN Value
WHEN Account = 'Occupancy' THEN Value
WHEN Account = 'Purchased Services' THEN Value
WHEN Account = 'Insurance' THEN Value
WHEN Account = 'Other Expenses' THEN Value
ELSE 0 END)

-- less expenses equals EBITDA