# Chart of Account Export **URL:** \ **Category:** Uncategorized\ **Created:** [October 3, 2019, 5:37am UTC](https://forum.manager.io/t/chart-of-account-export/24548 "2019-10-03T05:37:56Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [October 3, 2019, 5:37am UTC](https://forum.manager.io/t/chart-of-account-export/24548/1 "2019-10-03T05:37:56Z")
@lubos Is there any way to export Chart of Account key and value? Thanks ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [October 3, 2019, 5:47am UTC](https://forum.manager.io/t/chart-of-account-export/24548/2 "2019-10-03T05:47:55Z")
Does this help > [@How to find Hexadecimal codes for chart of accounts](https://forum.manager.io/t/how-to-find-hexadecimal-codes-for-chart-of-accounts/23232): > > Hey, I am new to [Manager.io](http://Manager.io). I have set up my starting balances and read through a lot of guides and posts. The main thing Id like to do is import all the payments and receipts for current year. A lot of the accounts are defaulting to ‘suspense’. I have read the posts about this. What I do not understand is how to extract the 32 string codes for each account in my chart of accounts. Please advise. or > [@Exporting Chart of Account](https://forum.manager.io/t/exporting-chart-of-account/14618): > > Is there a way to delete all transactions by a single click or can I export chart of accounts to a new company? ---
**Author:** ![novica](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/novica/32/7414_2.png) [@novica](https://forum.manager.io/u/novica)\ **Post date:** [October 3, 2019, 8:20am UTC](https://forum.manager.io/t/chart-of-account-export/24548/3 "2019-10-03T08:20:14Z")
Actually, you can export the Chart of accounts just like the transaction reports export. Assuming you have an empty Manager company with just a template CoA you can export that and use in other companies. ---
**Author:** ![novica](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/novica/32/7414_2.png) [@novica](https://forum.manager.io/u/novica)\ **Post date:** [October 3, 2019, 9:22am UTC](https://forum.manager.io/t/chart-of-account-export/24548/5 "2019-10-03T09:22:15Z")
No, actually what I mean, and I found this by accident when developing a VAT transaction report, is that if you **export** from **Settings** the chart of accounts is also exported, along with any other Tax related modifications that are done. So, if you have an empty company with just a CoA you can use this to transfer the CoA just like you would import a report transformation. ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [October 3, 2019, 9:24am UTC](https://forum.manager.io/t/chart-of-account-export/24548/6 "2019-10-03T09:24:15Z")
Sorry, I missed that feature - you are correct 100% What happens if you import a CoA to a business with a different CoA and transactions - does the new CoA completely overwrite the existing CoA which mightlead to the invalid transactions and postings to the Suspense account ---
**Author:** ![novica](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/novica/32/7414_2.png) [@novica](https://forum.manager.io/u/novica)\ **Post date:** [October 3, 2019, 9:38am UTC](https://forum.manager.io/t/chart-of-account-export/24548/7 "2019-10-03T09:38:20Z")
I don’t think that scenario is advisable. I think you can possible get: 1. conflicts on import and 2. duplicate accounts. So importing CoA would only make sense on a new empty business. ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [October 3, 2019, 9:44am UTC](https://forum.manager.io/t/chart-of-account-export/24548/8 "2019-10-03T09:44:36Z")
Renaming the old manually entered accounts eg add “old”. Then importing the transformation then recoding transactions, could be used to ensure a group of Manager business had uniform account UUID. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [October 3, 2019, 2:28pm UTC](https://forum.manager.io/t/chart-of-account-export/24548/9 "2019-10-03T14:28:59Z")
> [@Patch](#): > > manually Thanks I would like to use them in excel 🙂 ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [October 3, 2019, 9:45pm UTC](https://forum.manager.io/t/chart-of-account-export/24548/10 "2019-10-03T21:45:07Z")
A way of moving transactions in an account is to 1. Think of a unique alphanumeric string 2. Check it doesn’t appear any where in the business by searching for it 3. Appended it to the source account name by editing the COA 4. Now you can search for all transactions which contain it to select all transactions in the source account 5. choose recode, select them all, choose the new account and apply. Unfortunately I could only find a way to select one page at a time via recode. Batch update may be more efficient for many transactions. ---
**Author:** ![San\_Thida\_Myo\_Latt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/san_thida_myo_latt/32/16513_2.png) [@San\_Thida\_Myo\_Latt](https://forum.manager.io/u/San_Thida_Myo_Latt)\ **Post date:** [October 4, 2019, 1:38am UTC](https://forum.manager.io/t/chart-of-account-export/24548/11 "2019-10-04T01:38:49Z")
when i try to export settings and import to new db, “Profit and Loss Statement” Items are not imported ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [October 4, 2019, 1:43am UTC](https://forum.manager.io/t/chart-of-account-export/24548/12 "2019-10-04T01:43:26Z")
Nothing to do with profit and loss statements is a setting. ---
**Author:** ![sxr8000](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@sxr8000](https://forum.manager.io/u/sxr8000)\ **Post date:** [October 8, 2019, 6:38am UTC](https://forum.manager.io/t/chart-of-account-export/24548/13 "2019-10-08T06:38:07Z")
I have a chart of accounts that I use that has no transactions and I have saved it as “Business Template”. When I start a new business I then import this as a new business then change the name and I am under way with a new business and any new accounts that pertain to the new business I just add as necessary. Hope this is a help to someone… ---
**Author:** ![Davide](https://avatars.discourse-cdn.com/v4/letter/d/258eb7/32.png) [@Davide](https://forum.manager.io/u/Davide)\ **Post date:** [October 8, 2019, 7:21am UTC](https://forum.manager.io/t/chart-of-account-export/24548/14 "2019-10-08T07:21:03Z")
Since the export and import functions were creates by @lubos for tax reporting they were not linked to “profit and loss statement”. A further implementation with this function was promised a few months ago but it hasn’t been implemented yet. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 2:59pm UTC](https://forum.manager.io/t/chart-of-account-export/24548/15 "2023-01-18T14:59:07Z")
Closed on January 18, 2023, 2:59pm UTC