Financial Ratios

Financial Statements
1

Has anyone had success calculating ratios that use accounts from both P&L and the Balance Sheet?

1 Like
2

I used to have a simple debtor days from the sales data and a ledger balance stream.

3

Hi
Do you mean for calculations like Return on Equity as an example?

4

Well, the two in particular we’re having trouble calculating are Days Payables and Days Receivables.

We think the problem is because it combines data from two different financial sheets (P&L and Balance Sheet,) but we aren’t sure.

1 Like
5

Yes, there are two areas of functionality in financial statement calculations we are currently working on:

  • The ability to reference groups on other financial statements (e.g. Balance Sheet groups on the P&L).

  • The ability to annualize a value (such as profit in the RoE calculation) and the ability to divide a value by the number of days in a given period (such as in the days payable outstanding calculation).

I hope to have this functionality in place in time for the March release of Phocas. Would you be interested in trialing it once it becomes available?

1 Like
6

We would love to trial it!

7

Terrific. Would you mind emailing me on nick.collett@phocassoftware.com so we can discuss further?

8

I’m having the same issue and would love to trial it too, if possible.

Additionally, is it possible to use subcategories in the custom calculations for financial statements? In my case, I need to add back Depreciation (which is split up into G&A Exp & Indirect Manufacturing) for the EBITDA calculation.

9

Hi Kai
Please could you email me directly (nick.collett@phocassoftware.com) and we can discuss financial ratios and your requirements for custom calculations.
Thanks
Nick