Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 8, 2022
Question

A/P reports

  • February 8, 2022
  • 1 reply
  • 0 views

I need to generate an A/P report to sort by class or customer, any thoughts?

When I enter a bill I assign a class and a customer:Job.

At the end of the month I would like to generate a report that sorts (open) accounts payable by either the class or customer:job, any thoughts?

Thanks in advance

1 reply

Level 9
February 8, 2022

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: 

 

 

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.

FGCSDAuthor
February 8, 2022

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?

katherinejoyceO
Level 9
February 8, 2022

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.