BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
rpv
Level 1

How do I "remap" my Chart of Accounts? Should I create a dummy company as a safeguard to avoid the risk of corrupting my original set of books?

I've just completed my second year of my start-up business and I wish I knew then what I know now about what I wanted/needed in a Chart of Accounts. I'm thinking I need to export all my transactions to a CSV file, remap my accounts in Excel, and then import the remapped transactions into a new dummy/test company (which I should always have anyways for whenever I want to test something new). Any advice (particularly any "been there, done that" advice") will be greatly appreciated.

1 Comment 1
BonJulius_G
QuickBooks Team

How do I "remap" my Chart of Accounts? Should I create a dummy company as a safeguard to avoid the risk of corrupting my original set of books?

Congratulations on the success of your start-up, rpv! It's great to hear you're taking a thoughtful approach to remapping your Chart of Accounts (COA). 

 

Using a dummy company is indeed a smart strategy to safeguard your existing data. You’re on the right track of exporting all transactions to a CSV file, remapping accounts in Excel, and importing the updated transactions into a test company, as this is an ideal way to handle this process without risking your current records. 

 

To learn more about the data that can be exported and imported in QuickBooks, refer to these articles:

 

 

Please also note QBO allows you to safely rename existing accounts or merge redundant ones directly, which helps in mapping and reclassifying transactions without the need for a full re-import process.

It would also be best to consult your accountant for accurate bookkeeping and account management. 

If you have further questions regarding your concern, feel free to reply below.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us