I Need to convert my chart of accounts - moving subaccounts to classes and classes to projects - and retain history - is there an automated method?
My nonprofit uses QB online. In the current setup, revenue and expense accounts use sub accounts to identify the program (general admin, high schools, middle schools, college prep, etc). Classes are used to ID the specific school or event, for example, Wisdom High School, youth camping, or Professional Bootcamp.
This is very unwieldy because virtually all expense accounts have 5 sub accounts and the list of classes is getting too long to make it easy to report.
Thus, I want to convert my chart of accounts (and all the historical data) as follows:
- I want to use the class in place of the sub accounts to eliminate the subaccounts for each account
- I want to use projects in place of the classes so that new projects like a fundraising event can be readily added without having to modify QB classes.
Is there a way that this can be done programmatically? I’ve written lots of software over the years but I need to know if there is something out there that I could parameterize or code to take my existing QB chart and convert it to a new chart as described above.
TIA