I am new to Financial Edge and I have not been able to find how to add sub-accounts to already existing G/L accounts - help!

are you trying add a new account number, cost center,or just track a specific project?

I don't believe FE has sub accounts unless you set them up in the original set-up and they would be defined by the account number something like xx-xxx-xx. However, if you want certain accounts to be grouped under one heading like office expenses, which could include rent, office supplies, utilities. You can design your income statement and balance sheet in the visual chart organizer (vco). There you can create a format which allows you to put the accounts under certain headings and group them however you want. You just have to remember to update your format if you add a new account. I usually check to make sure I am including everything by running a balance sheet and income statement under the default chart template or else you will notice that your balance sheet isn't balancing. Hope that helps. Kathleen Patlovich Boise State University Foundation

I inherited a chart of account that is not specific enough for some analysis that I would like to do. For example - we have a maintenance expense account but now we would like to tracking certain types of maintenance. We will probably not ever need this detail for Financial Statement purposes but rather just analysis - other programs I have worked with allowed you to add sub-accounts to accomplish this goal - I think you can add new accounts and roll them up to a "lead" or "header" account but this would be more cumbersome than I want - plus, I think that our chart of accounts is set and therefore adding new accounts would cause grave mental problems with respect to account sequencing. Any ideas?

I inherited a chart of account that is not specific enough for some analysis that I would like to do. For example - we have a maintenance expense account but now we would like to tracking certain types of maintenance. We will probably not ever need this detail for Financial Statement purposes but rather just analysis - other programs I have worked with allowed you to add sub-accounts to accomplish this goal - I think you can add new accounts and roll them up to a "lead" or "header" account but this would be more cumbersome than I want - plus, I think that our chart of accounts is set and therefore adding new accounts would cause grave mental problems with respect to account sequencing. Any ideas?

adding sub accounts I inherited a chart of account that is not specific enough for some analysis that I would like to do. For example - we have a maintenance expense account but now we would like to tracking certain types of maintenance. We will probably not ever need this detail for Financial Statement purposes but rather just analysis - other programs I have worked with allowed you to add sub-accounts to accomplish this goal - I think you can add new accounts and roll them up to a "lead" or "header" account but this would be more cumbersome than I want - plus, I think that our chart of accounts is set and therefore adding new accounts would cause grave mental problems with respect to account sequencing. Any ideas?

My suggestion then would be to have specific expenses to be run through different projects. You could then run a report and filter for the projects that you want included. Here we track expenses by development officer, so I can analyze their expenses by project. So you could have a mechanical expense project and maybe a computer expense project. Any charges would go to the same account but the difference would be the project that gets charged. Then when you pull an account report, you would only include those projects with the specific expenses that you want to analyze.

Joe, I suugest using transaction codes. Transaction codes are "additional fields on each transaction that allow you to further categorize information for use in reporting." You can have up to five categories of transaction codes. You set up the transaction code categories in General Ledger/ Configuration/Transaction Codes. Then, you set up the allowable values for the transaction code in General Ledger/Configuration/Tables. Our organization has used these codes to track maintenace by category (HVAC, Elevator, Security, Pest Control). We only needed to have one maintenance G/L account but the transaction codes allowed us to run reports to determine how much we were spending on each type of maintenance. We have also used transaction ceds to track spending by department and spending by state. Hope this helps.

We're using attributes on the transactions to track some underlying detail.