Epicor FP&A Secondary BS/IS

Is it possible to create a secondary balance sheet and/or income statement in Epicor FP&A?

For example, we have our standard balance sheet, but I want to create a second balance sheet using different categories with different accounts in them.

The accounts currently housed in “Property & Equipment” may not be in “Property & Equipment” in the secondary balance sheet, so the expand row wouldn’t work. I’d need to go into Dimensions and move them to different headings, but I don’t want to remove them from my original. I don’t see any way for an account to be a member of two different balance sheets (Like balance sheet orig and balance sheet secondary) in different places.

Any ideas?

just clone the Balance Sheet and make the changes on the cloned one

That isn’t the problem.

I can duplicate the balance sheet just fine. I cannot put the accounts under different balance sheet headings without removing them from the original BS heading and screwing up the way it appears in the 1st balance sheet.

Say, for example, I want 1410 Inventory - Raw Materials to show up under WIP-Material in the second Balance Sheet.

If I move it, it won’t show up under Raw Materials in the first Balance Sheet anymore.

Screenshot 2025-05-13 123304

Hi Elaine,

Sure this is possible to do, start off doing what @Moreno.Mauricio stated and clone the balance sheet (don’t forget to rename it as “BS FP&A” or whatever.)

Then you just need to update the rows to the accounts you want…
this is my original BS…

and this is the updated one…

you update based on “Accounts” not “Category”

I hope this helps.

This doesn’t appear to be Epicor FP&A in Kinetic. This appears to be Financial Report Designer in an On-Prem version of Epicor.