A/P reports

I can surely help you with that, @FGCSD.

In QuickBooks Desktop, you can pull up the A/P Aging Detail report and customize it to get the information you need. Let me show you how:

1. Go to the Reports menu.
2. Under Vendors & Payables, click A/P Aging Detail.
3. Click the Customize Report button.
4. Then, in the Display tab, make sure to add the following:
   Name
   Source Name
   Class
   Open Balance. Note: You can include other details you want to populate on the report.
   
5. In the Filters tab, include the following:
   Class - You can select multiple classes by clicking the Class drop-down arrow and select Multiple classes. Then, tick all the classes you want.
   
   Job status - set to In progress.
   Name
   Paid Status -  set to Open
   Preferred Vendor.
   
6. Review them. Once done, click OK.
7. Set the reporting date correctly.
8. Click the Sort By drop-down arrow and select Class or Name.
   
   
   

Also, you can export the report to Excel by clicking the Excel drop-down menu and selecting Create New Worksheet. Then, Export. From there, you can expand your customization to add other details to the report.

For additional reference about running and customizing reports in QuickBooks Desktop, you can read these articles: 

• Understand reports.
• Customize reports in QuickBooks Desktop.

If you have more QuickBooks concerns, please let me know. I'd be glad to help and provide more details about QuickBooks. Take care and stay safe, FGCSD.

Hi Sara, 

Thank you so much for responding.

I've followed your steps - but the class field is blank???

All of my bills are classed but not on the report...

Thoughts?

Hi Sara, 

Thank you so much for responding.

I've followed your steps - but the class field is blank???

All of my bills are classed but not on the report...

Thoughts?

The type of transaction information pulled into a report depends on the type of report. For example:

• Reports that are reporting income and expense account information, pull information from the detail of transactions.
• Reports that are reporting asset, liability, and equity account information, pull information from the header portions of transactions.
   

QuickBooks provides different kinds of reports that cater to your business needs. You can visit this article for additional reference: Understand reports.

Thanks for coming back for more support, @FGCSD. I've got you some insights about why your bills aren't classed on the report even when they have been assigned to certain classes.

This is because it depends on how the Class is assigned and the sort of report you've run. There is a header and a detail section for every transaction (with the exception of journal entries).

When classes are allocated, they are linked to the transaction's details. They aren't linked to the accounts in the headers.

You'll want to run the Customer Balance Detail Report instead and filter it by Class. 

Here's how:

1. Click Reports at the top menu bar. 
2. On the drop-down list, click Customers & Receivables and choose Customer Balance Detail. 
3. Click Customize Report.
4. From Filters, search Class.  
5. Click the drop-down arrow from Class and choose the specific company you want to show in the report, then click OK.

The type of transaction information pulled into a report depends on the type of report. For example:

• Reports that are reporting income and expense account information, pull information from the detail of transactions.
• Reports that are reporting asset, liability, and equity account information, pull information from the header portions of transactions.

QuickBooks have different kinds of reports that suit your business needs. You can visit this article for additional reference: Understand reports.

Get back to me if you have follow-up questions or additional concerns. I'll be here to help you again.