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?