All Training Videos: QuickBooks Online Tutorial - How to run reports for custom fields | QuickBooks Online Advanced

With QuickBooks Online Advanced (Learn more: http://intuit.me/QBO-Advanced), you can track your own unique data with enhanced custom fields and then run reports on it. We’ll cover different ways to customize your reports based on your custom fields data. Once your custom fields are set up, start by selecting “Reports.” Then search for the report you want to run. For example, you can run a report on “Sales by Customer Detail,” which displays sales detail divided by customer and project. You can customize this report to show information for sales over the last two months using custom field data. You can add columns to the report to see your custom fields or reorganize the report to group data by custom fields. For example, you can group sales by sales rep instead of by customer and project. You can also sort data on reports by custom field. For example, you can sort by “project hours” and the data will stay grouped by sales rep and in each grouping the transactions are sorted by project hours in ascending order. You can use filters to limit what data goes on the report, too. With custom fields in QuickBooks Online Advanced, you can run reports to get the specialized information you need for your business. In this video: 0:00 With enhanced custom fields in QuickBooks Online Advanced you can track your own unique data, like sales rep and project hours. 0:10 Once you set them up, you can run reports specifically for your custom fields. 0:18 We’ll cover different ways you can customize your reports based on custom fields. 0:23 To start, select “Reports,” then search for the report you want to run; for example “Sales by Customer Detail.” 0:30 This report displays sales detail divided by customer and project. 0:40 Let’s customize the report so that it shows information for sales over the last two months using custom field data. 0:47 One option is to add columns to the report so that you can see custom field data for each transaction. 0:55 Select the gear icon, then select all the custom fields you want to see as columns. 1:07 You can also reorganize the report so it groups data by custom field. 1:12 Select the “Group by” menu, then select a custom field, like sales rep. 1:20 Run the report and now it groups sales by sales rep instead of by customer and project. 1:25 You can also sort data on reports by custom field. 1:30 Select the “Sort by” menu and choose a custom field like “project hours.” 1:35 Now the transactions stay grouped by sales rep and in each grouping the transactions are sorted by project hours in ascending order. 1:50 You can also use filters to limit what data goes on the report. 1:54 Select “Customize” then in the filters section select what you want the report to show. 2:12 Now you’re ready to run reports for the custom fields data you record. We have over 100 step-by-step tutorials to help you master QuickBooks. Browse our entire library by topic: Getting Started - https://bit.ly/2PaHuGz Accounting Basics - https://bit.ly/2Jc5dSX Sales - https://bit.ly/2Weq7WV Invoicing - https://bit.ly/2JelfeQ Expenses - https://bit.ly/31HK89r Reports - https://bit.ly/2MADTzM Reconciliation and Preparing for Tax Season - https://bit.ly/2MAfydj Managing Inventory - https://bit.ly/2W8NQaH Projects (without QuickBooks Payroll) - https://bit.ly/2P9UWdF Projects (with QuickBooks Payroll) - https://bit.ly/2W5Tjio Subscribe to our YouTube channel: https://intuit.me/3bOj0M2 Learn more about QuickBooks Online Advanced at: http://intuit.me/QBO-Advanced #QuickBooksOnline #QBOA #QuickBooks #CustomFields The world’s largest workforce works for themselves. We work for them by providing smarter business tools. QuickBooks #BackingYou.