You can now expand or collapse each parent entry to show or hide sub-entries so you can easily switch between levels of detail.#QuickBooksThe worlds largest workforce works for themselves. QuickBooks Online Tutorial Customizing Rows and Get an introduction into Dimensions and Expressions, the foundation of the reports you'll build in Advanced Reporting. Grouping data into columns by customer or class in QuickBooks summary report is now much easier. Yes, by default a "summary report" is going to total something and group them together. Thanks to all. Telephone: 925-247-0100 Allow me to provide some instructions on how you can get rid of the custom template that's showing up on the list. Moraga, CA 94556-2005 This will get rid of the empty column and align all of your reports correctly. Welcome Katelynne, who is here to share some quick tips to help you out This is unbelievable. I think if I can get it off the list, I should be able to delete it. It did not accomplish what I was trying to do and now I can't get rid of it. Have a wonderful Wednesday! To remove the space between column, you need to click the Advanced button from your Export Wizard, and unchecked the checkbox for Space between columns from the Advanced Excel Options. When it put the link at google, it just show blank page. If your client's account age is older than 60 days, they are unable to purge it but open a new QBO account. Click Refresh. Nice to have you joining this thread, @STAT1. When routed to the Information window, click bto confirm the action. When exporting list reports (such as General Ledger report), by default, there will be a space between the column (blank column). The extra blank column creates a You may also want to reach out to the Microsoft Support Team or ourQuickBooks Desktop Support Teamto get the excel sheet formatted correctly. This report option removes all active and deleted zero-balance accounts. To create this new report, choose Reports > Budgets & Forecasts > Profit & Loss Budget Performance. The QuickTips video for the Desktop version can be found below. Look for the template from the result, then double-click to open. There are no upcoming live seminars at this time. First, let's make sure that the custom field added isn't used on your template, this can be done by removing the field from the selected template. CRM. QuickBooks Desktop Users: you can now clean up your reports with a Collapse Columns feature in Desktop 2020. WebCollapse Columns on Reports: * Using the Class field to track programs, admin and fundraising, many use Subclasses which can cause extra columns to appear on reports Take care and enjoy the rest of the day. I just do not want it to display would love to see an option to remove the OVERALL total column. I'll also attach this YouTube video as well: How to erase your QuickBooks Online data and start over. To do that, please follow the steps found in this link:Verify and Rebuild Data in QuickBooks Desktop.