Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

While using the 'Export to Excel' option to export expenses, the 'Category' gets truncated to only the text after the colon. How can I also get the text before colon?

 
Solved
Best answer April 03, 2020

Best Answers
Moderator

While using the 'Export to Excel' option to export expenses, the 'Category' gets truncated to only the text after the colon. How can I also get the text before colon?

Welcome to the QuickBooks family, @hagupta.


I can share some insights about the categories in QuickBooks Online. When exporting expenses to Excel, our system is designed to only show the texts after the colon, which is the actual sub-account name.

 

Right now, including the entire information is currently unavailable. I recommend checking out the following screenshots to help you know more about the process:

 

 

 

I understand how the workflow you're looking for is beneficial to your business. To ensure your voice is heard, I can pass along another feature request on my end.

 

For the time being, you can visit our blog and sign up to our Newsletter. This way, you’ll receive email updates about changes in the product.

 

In case you want to learn more about exporting and not limited to expenses, I'm attaching this article: Export reports, lists, and more.

 

If you have additional questions or concerns while working in QBO, leave a comment below. I’ll be happy to help you out.

View solution in original post

1 Comment
Moderator

While using the 'Export to Excel' option to export expenses, the 'Category' gets truncated to only the text after the colon. How can I also get the text before colon?

Welcome to the QuickBooks family, @hagupta.


I can share some insights about the categories in QuickBooks Online. When exporting expenses to Excel, our system is designed to only show the texts after the colon, which is the actual sub-account name.

 

Right now, including the entire information is currently unavailable. I recommend checking out the following screenshots to help you know more about the process:

 

 

 

I understand how the workflow you're looking for is beneficial to your business. To ensure your voice is heard, I can pass along another feature request on my end.

 

For the time being, you can visit our blog and sign up to our Newsletter. This way, you’ll receive email updates about changes in the product.

 

In case you want to learn more about exporting and not limited to expenses, I'm attaching this article: Export reports, lists, and more.

 

If you have additional questions or concerns while working in QBO, leave a comment below. I’ll be happy to help you out.

View solution in original post

Need to get in touch?

Contact us