Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
Is there a way to batch edit the Tax-Line Mapping for each chart of account item on Quickbooks Accountant Desktop either through the application or importing/exporting through Excel? What I've been doing is that I've been going through each account one-by-one and editing the Tax-Line Mapping (see image attached) on the application but if there's a faster way to do it, please let me know.
Solved! Go to Solution.
Batch editing and importing data are essential tasks that can help you save time, @jeffrey10013. Let me share some information about it.
You can import your Chart of Accounts data in an Excel or CSV file in QuickBooks. However, the option to include the Tax-Line Mapping is currently unavailable as QuickBooks only allows the following information to be mapped through the Import from Excel feature:
Moreover, the batch editing feature is also not accessible within the program. Thus, you'll have to edit each account and select the corresponding tax-line mapping manually.
If you would like to have the feature to import the tax-line mapping with the other data and be able to edit in batch, you may submit your feedback to our Product Development team. They are genuinely interested in hearing your input and highly encourage you to share your suggestions for improving the program.
Here is how you can do it:
Furthermore, I've got this reference to help you manage your accounts in QBDT: Add, edit, or delete accounts in QuickBooks Desktop.
You can also check this page about customizing reports and adding more details to it: Customize reports in QuickBooks Desktop.
Thanks for dropping by @jeffrey10013. If you have any additional QuickBooks-related concerns, feel free to post here again. I'll be more than willing to help you. Take care!
Batch editing and importing data are essential tasks that can help you save time, @jeffrey10013. Let me share some information about it.
You can import your Chart of Accounts data in an Excel or CSV file in QuickBooks. However, the option to include the Tax-Line Mapping is currently unavailable as QuickBooks only allows the following information to be mapped through the Import from Excel feature:
Moreover, the batch editing feature is also not accessible within the program. Thus, you'll have to edit each account and select the corresponding tax-line mapping manually.
If you would like to have the feature to import the tax-line mapping with the other data and be able to edit in batch, you may submit your feedback to our Product Development team. They are genuinely interested in hearing your input and highly encourage you to share your suggestions for improving the program.
Here is how you can do it:
Furthermore, I've got this reference to help you manage your accounts in QBDT: Add, edit, or delete accounts in QuickBooks Desktop.
You can also check this page about customizing reports and adding more details to it: Customize reports in QuickBooks Desktop.
Thanks for dropping by @jeffrey10013. If you have any additional QuickBooks-related concerns, feel free to post here again. I'll be more than willing to help you. Take care!
Thanks for the quick response!
On behalf of my colleague, you're welcome, Jeffrey.
If you require further assistance working on specific tasks in QuickBooks, the Community is willing to assist you at any time. Have a great day ahead!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here