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
